Killing a mass of queries from MySQL

mysql

to kill a whole bunch of mysql queries in one go, I used something like this that you can adapt for your own use:

select concat('KILL ',id,';') from information_schema.processlist where Host like 'some-sexy-server-ws%';
select concat('KILL ',id,';') from information_schema.processlist where Host like 'some-sexy-server-ws%' into outfile '/tmp/a.txt';
source /tmp/a.txt

Leave a Reply

Your email address will not be published. Required fields are marked *