Stops a running process in an AnalyticDB for MySQL cluster.
Syntax
KILL PROCESS process_idParameters
| Parameter | Description |
|---|---|
process_id | The ID of the process to stop. To get this value, run SHOW PROCESSLIST and note the ProcessId field. |
Permissions
| Scenario | Permission required |
|---|---|
| Stop processes under your own account | None (default) |
| Stop processes owned by any account in the cluster | PROCESS permission, granted by a privileged account |
To grant the PROCESS permission to a standard account, run the following as a privileged account:
GRANT process on *.* to account_name;Example
Step 1: Get the process ID.
SHOW PROCESSLIST;Locate the process you want to stop and note its ProcessId.
Step 2: Stop the process.
KILL PROCESS 12345;Replace 12345 with the actual ProcessId from Step 1.