批量杀掉Sleep的脚本

我们经常需要使用show processlist命令,然后kill掉Sleep进程防止堵塞数据库,这里提供一个脚本可以批量杀进程方便使用.

#!/bin/sh 
n=`/usr/local/mysql/bin/mysql -uxxxx -pxxxx -S/dev/shm/mysql.sock -e "show full processlist\G" | grep -i Sleep | wc -l` 
#date=`date +%Y%m%d\[%H:%M:%S]` 
#echo $n 
#if [ "$n" -gt 10 ] 
#then 
for i in `/usr/local/mysql/bin/mysqladmin  -uxxxx -pxxxx -S/dev/shm/mysql.sock processlist | grep -i Sleep | awk '{print $2}'` 
do 
/usr/local/mysql/bin/mysqladmin  -uxxxx -pxxxx -S/dev/shm/mysql.sock kill $i 
done 
echo "sleep is too many i killed it" >> /tmp/sleep.log 
echo "$date : $n" >> /tmp/sleep.log 
#fi