kill sleep mysql_kill_mysql_sleep_thread

#!/bin/bash

while [ "2" -gt "1" ]

sleep_sum=`mysqladmin -uroot -ptonggangdasha processlist | grep -i sleep | wc -l`

date=`date "+%F->%R"`

#echo $sleep_sum

if [ "$sleep_sum" -gt 250 ]

then

for i in `mysqladmin -uroot -ptonggangdasha processlist | grep -i sleep | awk '{print $2}'`

do

`mysqladmin -uroot -ptonggangdasha kill $i`

done

echo "$date:$sleep_sum,sleep is too many i killed it" >> /opt/kill_sleep/sleep.log

else

echo "$date:$sleep_sum,not need to kill" >> /opt/kill_sleep/sleep.log

fi

sleep 180

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14661773/viewspace-1318787/，如需转载，请注明出处，否则将追究法律责任。