杀死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 高华 阅读(2506) 评论(0) 推荐(0)
                    
                
浙公网安备 33010602011771号