清除mysql进程脚本 编辑词条 发表评论(0)

#!/bin/sh
        NUM=`/usr/local/mysql/bin/mysqladmin -ukill -pkillabc processlist|grep -i
sleep |wc -l`
        date=`date +%Y%m%d\[%H:%M:%S]`
         echo  时间:$date Sleep:$n  >>/tmp/sleep.log
        if [  $NUM -gt 40 ]
        then
                for i in `/usr/local/mysql/bin/mysqladmin -uuser -ppasswd proce
sslist|grep -i sleep |awk '{print $2}'`
                do
                 /usr/local/mysql/bin/mysqladmin -uuser -passwd kill $i
               # echo $i >>/data/zgq.txt
                done
                echo  时间:$date Sleep:$n  >>/tmp/sleep.log
         fi
        sleep 1

---------------