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; ......

 

posted @ 2019-03-19 10:15  小泉哥  阅读(2781)  评论(0编辑  收藏  举报