殺掉查詢的死鎖的mysql的連結

殺掉查詢的死鎖的mysql的連結:

檢查過程：

mysqladmin -uroot -p'Zykj#558996' -S /tmp/mysql5.6.sock processlist|awk -F "|" '{print $2,$3,$6,$8}'

Id User Command State

54251602 mdrdb Query Waiting for table level lock

mysqladmin -uroot -p'Zykj#558996' -S /tmp/mysql5.6.sock processlist >>/tmp/test.txt 儲存sql記錄

殺掉查詢的死鎖的mysql的連結

mysqladmin -uroot -p'Zykj#558996' -S /tmp/mysql5.6.sock processlist|grep "Waiting for table level lock"|awk -F "|" '{print $2}'|xargs -n 1 mysqladmin -uroot -p'Zykj#558996' -S /tmp/mysql5.6.sock kill

殺掉目前的所有的mysql的連結：

mysqladmin -uroot -p'Zykj#558996 -S /tmp/mysql5.6.sock processlist|awk -F "|" '{print $2}'|xargs -n 1 mysqladmin -uroot -p'Zykj#558996 -S /tmp/mysql5.6.sock kill

檢視表記錄數：

for n in <code>mysql -utestuser04 -p'Zykj#558996' -S /tmp/mysql5.6.sock -e "use testdrnew;show tables;"|sed '1d'</code>;do echo $n&amp;&amp;mysql -utestuser04 -p'Zykj#558996' -S /tmp/mysql5.6.sock -e "use testdrnew;select count(*) from $n";done &gt;/tmp/test.txt

 本文轉自 wjw555 51CTO部落格，原文連結:http://blog.51cto.com/wujianwei/2054122