The process of killing all lock tables in MySQL

Reprint please retain the following author information Author: Jesse Blog: http://hi.baidu.com/leechl 3 o'clock just slept, more than 4, the colleague called to tell me that the user database was hung off. I get up and look at the list of processes. Mysql>show processlist; Out of several screens, no 1000 also have hundreds of, query statements to lock the table, hurriedly find the first locked thread_id, in the shell of MySQL execution. Mysql>kill thread_id; The process of killing the first lock table still does not improve. Since it doesn't improve, let's try to kill all the lock-list processes, the simple script is as follows. #!/bin/bash Mysql-u root-e "Show Processlist" | Grep-i "Locked" >> locked_log.txt For line in ' Cat Locked_log.txt | awk ' {print '} ' Do echo "Kill $line;" >> Kill_thread_id.sql Done Now Kill_thread_id.sql's content looks like this. Kill 66402982; Kill 66402983; Kill 66402986; Kill 66402991; ..... Well, we execute it in the shell of MySQL and we can kill all the lock-list processes. Mysql>source Kill_thread_id.sql Of course, it can be done in one line. For ID in ' Mysqladmin processlist | Grep-i Locked | awk ' {print '} ' Do Mysqladmin Kill ${id} Done

The process of killing all lock tables in MySQL