删除mysql sleep的连接
摘要：
#!/bin/sh#while :#do 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 阅读全文
posted @ 2012-11-21 14:23 高华 阅读(1020) 评论(0) 推荐(0) 编辑
