The process of killing all lock tables in MySQL

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 inch `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

  id   in   " mysqladmin Processlist | Grep-i Locked | awk ' {print  } ' '

The process of killing all lock tables in MySQL