#!/bin/bash
for i in `mysql -uroot -ppasswd -Bse "show processlist" | grep -v "show processlist" | awk '{print $1}'`
domysql -uroot -ppasswd -e "kill $i"
done
注:这里将自身命令的show processlist进程过滤掉
#!/bin/bash
for i in `mysql -uroot -ppasswd -Bse "show processlist" | grep -v "show processlist" | awk '{print $1}'`
do