杀mysql sleep 进程的脚本{摘抄的]

#It is used to kill processlist of mysql sleep~~~
#!/bin/sh
while ：

do
        n=`/opt/mysql/bin/mysqladmin processlist|grep -i sleep |wc -l`
        date=`date +%Y%m%d\[%H:%M:%S]`
        echo $n
#      id=`/opt/mysql/bin/mysqladmin processlist |grep Sleep |awk '{if ($12 > 100) {print $2}}'`
#      echo "$date : $n" >> /tmp/sleep.log
#      if [ id != "" ]
#      then
#              for j in $id
#              do
#              /opt/mysql/bin/mysqladmin kill $j
#              echo "$date : sleep is to long " >> /tmp/sleep.log
#      fi
#
        if [ "$n" -gt 60 ]
        then

                for i in `/opt/mysql/bin/mysqladmin processlist|grep -i sleep |awk '{print $2}'`
                do
                        /opt/mysql/bin/mysqladmin kill $i
                done
                echo "sleep is too many i killed it " >> /tmp/sleep.log
                echo "$date : $n" >> /tmp/sleep.log
        fi             
        sleep 1
done