Hcy

批量kill sql

Dec 13, 2021
81
0
SELECT GROUP_CONCAT(CONCAT('kill ',id,';') separator '')\
FROM `information_schema`.`PROCESSLIST` t\
WHERE  t.`Time`>600\
AND t.`User` IN('meta')\
AND t.`HOST` like '%supervisor%'
AND t.`COMMAND` IN ('Sleep') \G;