mysql kill process resolves a deadlock

1. View the list of processes and find the ID

SHOW processlist

2, the query statement to lock the table, hurriedly find the first locked thread_id, in the shell of MySQL execution.

Kill ID

#!/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

;

mysql kill process resolves a deadlock