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
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
