有问题的sql ,慢查询如:Sending data ,怎么一次kill掉:
mysql -uroot -h 127.0.0.1 -P3307 -e "show full processlist"|grep "Sending data"|awk ‘{printf "mysql -uroot -h 127.0.0.1 -P3307 -e " "\047" "kill " $1"\047;" }‘|sh
原文:http://chenwenming.blog.51cto.com/327092/1900299