杀死sleep的mysql连接
摘要:
n=`/data/mysql/bin/mysqladmin -uroot -hmaster_db_72 -ppassword -P3306 processlist | grep -i sleep | awk '$12>300 {print $2}' | wc -l` date=`date +%Y%m%d\[%H:%M:%S]` if [ "$n" -gt 10 ] then for i in `/data/mysql/bin/mysqladmin -uroot -hmaster_db_72 -ppassword -P3306 processlist | 阅读全文
posted @ 2013-01-21 16:25 高华 阅读(2495) 评论(0) 推荐(0) 编辑