杀掉mysql查询进程的shell脚本
- #!/bin/bash
- # script name : killquery
- /usr/local/mysql/bin/mysql -uroot -p'password' gcore -s -e 'show processlist'|grep -v -i -E "system user|Sleep|replication"|awk '{if($6>15)print $1}'|while read line; do /usr/local/mysql/bin/mysql -uroot -p'password' gcore -s -e "kill query $line" ;done