to show the processlist and get the THREAD ID to kill the process
mysql> SHOW PROCESSLIST;
use the KILL command followed by the thread ID returned by SHOW PROCESSLIST:
mysql> KILL 27;
Query OK, 0 rows affected (0.05 sec)
To kill the query being executed by a thread but leave the connection active (yes, MySQL even allows such fine-grained control), use the KILL QUERY command instead, followed by the appropriate thread ID.
No comments:
Post a Comment