mysql kill所有Sleep/Execute进程

现查出需要kill的进程：

SELECT GROUP_CONCAT(CONCAT('kill ',id) SEPARATOR '; ') AS cmd FROM information_schema.processlist 
WHERE USER='root' 
AND command='Sleep'
AND db='pcms'

结果：

copy出来结果执行

kill 4352; kill 4354; kill 4351; kill 4350; kill 4353; kill 4355; kill 4356; kill 4357; kill 4358; kill 4359; kill 4292; kill 4294; kill 4296; kill 4293; kill 4295; kill 4299; kill 4300; kill 4298; kill 4297; kill 4331; kill 4333; kill 4330; kill 4332; kill 4336; kill 4334; ......

 

转载于:https://www.cnblogs.com/penghq/p/10556872.html