监控Mysql超过指定时间的sleep连接
sh 代码如下
#!/bin/sh
n=`/usr/local/mysql5/bin/mysqladmin -uroot -pPassword processlist | grep -i sleep | wc -l`
if [ "$n" -gt 10 ]
then
for i in `/usr/local/mysql5/bin/mysqladmin -uroot -pPassword processlist | grep -i sleep | awk '{print $2}'`
do
/usr/local/mysql5/bin/mysqladmin -uroot -pPassword kill $i
done
fi
