Killing All MySQL Processes at once.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 320
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';

Comments or Responses

Login to post response