mysql 杀掉sleep的连接_清除mysql sleep连接

线上环境难免遇到一些程序bug，一类bug可能是程序没有关闭mysql连接导致mysql processlist里面大量的sleep线程不释放的情况，遇到这样的情况，只能kill 掉这些sleep的连接，等程序修复bug，下面是线上常用的脚本：

#!/bin/sh

user=

passwd=

host=

while :

do

n=`mysqladmin processlist -u$user -p$passwd -h$host | grep -i sleep | wc -l`

date=`date +%Y%m%d[%H:%M:%S]`

echo $n

if [ "$n" -gt 50 ]

then

for i in `mysqladmin processlist -u$user -p$passwd -h$host | grep -i sleep | awk '{print $2}'`

do

mysqladmin -u$user -p$passwd -h$host kill $i

done

echo "sleep is too many I killed it " >> /tmp/sleep.log

echo "$date : $n" >> /tmp/sleep.log

fi

sleep 1

done

其实变量我都留空了，可以根据实际情况，补齐