http://blog.csdn.net/superchanon/article/details/8546254/
https://jingyan.baidu.com/article/a378c9609eb652b3282830fd.html
两篇文章结合起来。
会报这个错误:
mysql.plugin' doesn't exis
原因是因为mysql的安装目录不在 /usr/local/mysql,需要:[root@localhost mysql]scripts/mysql_install_db --user=mysql \
--basedir=/opt/mysql/mysql \ //mysql的安装目录
--datadir=/opt/mysql/mysql/data //mysql data的安装目录
加上面那段命令
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 }' `
转自:http://blog.sina.com.cn/s/blog_6f7df0610101ap6m.html
do
echo " kill $line ; " >> kill_thread_id . sql
done