mysql
>
kill
thread_id
;
kill掉第一个锁表的进程, 依然没有改善. 既然不改善, 咱们就想办法将所有锁表的进程kill掉吧, 简单的脚本如下.
#!/bin/bash
mysql - u root - e " show processlist " | grep - i " Locked " >> locked_log . txt
for line in ` cat locked_log.txt | awk '{print $1 }' `
do
echo " kill $line ; " >> kill_thread_id . sql
done
mysql - u root - e " show processlist " | grep - i " Locked " >> locked_log . txt
for line in ` cat locked_log.txt | awk '{print $1 }' `
do
echo " kill $line ; " >> kill_thread_id . sql
done
现在kill_thread_id.sql的内容像这个样子
kill
66402982
;
kill 66402983 ;
kill 66402986 ;
kill 66402991 ;
.....
kill 66402983 ;
kill 66402986 ;
kill 66402991 ;
.....
好了, 我们在mysql的shell中执行, 就可以把所有锁表的进程杀死了.
mysql
>
source
kill_thread_id
.
sql
当然了, 也可以一行搞定
当然了, 也可以一行搞定
for id in `mysqladmin processlist | grep -i locked | awk '{print $1}'`
do
mysqladmin kill ${id}
done
do
mysqladmin kill ${id}
done