#!/bin/bash #by LC USER=root PASS=123456 PID=`mysql -u$USER -p$PASS -e "show processlist;"|grep -i ‘sleep‘|awk ‘{print $1}‘` for n in $PID do mysql -u$USER -p$PASS -e "kill $n" done
shell 之 mysql批量杀sleep连接
原文：http://10896311.blog.51cto.com/10886311/1720833
