Wednesday, January 27, 2010

To KILL a mysql process from SHOWED Processlist

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