删除mysql sleep的连接

#!/bin/sh
#while :

#do
  n=`/data/mysql/bin/mysqladmin -uroot -hmaster_db_72 -ppassword -P3306 processlist | grep -i sleep | awk '$12>300 {print $2}' | wc -l`
  date=`date +%Y%m%d\[%H:%M:%S]`

  if [ "$n" -gt 10 ]
  then
    for i in `/data/mysql/bin/mysqladmin -uroot -hmaster_db_72 -ppassword -P3306 processlist | grep -i sleep | awk '$12>300 {print $2}'`
    do
      /data/mysql/bin/mysqladmin -uroot -hmaster_db_72 -ppassword -P3306 kill $i
    done
    #echo "$date : $n sleep processes were killed" >> kill_sleep_mysqlpro.log
    echo "$date : $n sleep processes were killed" 

  fi

转载于:https://www.cnblogs.com/gaohuag/archive/2012/11/21/2780675.html