查看MySQL进程拥堵，并kill杀掉进程

--by www.qzphp.cn
show processlist;

desc information_schema.processlist ;

SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='news';

SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='news' INTO OUTFILE 'D:/SOFT_PHP_PACKAGE/mysql/temp/a.txt';

source D:/SOFT_PHP_PACKAGE/mysql/temp/a.txt;