Use the
information_schema.processlist table to identify which processes are currently running.
SELECT * FROM processlist\G;
--Kill multiple processes SELECT CONCAT('KILL ',id,';') AS Kill_Processes
FROM
information_schema.processlist
WHERE user = 'root' AND info = 'SELECT * FROM processlist';