Oct 25, 2017

How to kill multiple MySQL process at the same time

SELECT CONCAT('KILL ',id,';') AS run_this FROM information_schema.processlist WHERE user='i88ca' INTO OUTFILE '/tmp/kill_process.txt';
#You can now run this file back through MySQL to execute all KILL commands in one batch.

SOURCE /tmp/kill_process.txt