推荐

删除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

posted on 2012-11-21 14:23  高华  阅读(1018)  评论(0编辑  收藏  举报

导航