Skip to content

Instantly share code, notes, and snippets.

@boris

boris/kill.sql

Created January 14, 2014 13:05
Show Gist options
  • Save boris/8417992 to your computer and use it in GitHub Desktop.
Save boris/8417992 to your computer and use it in GitHub Desktop.
Download ZIP
Massive kill mysql processes.
Raw
kill.sql
/* select contact .. from TALBE where user="user" and CONDITION into outfile 'path';*/
select concat('KILL ',id,';') from information_schema.processlist where user='root' and Info like "%fail%" outfile '/tmp/kill.txt';
source /tmp/kill.txt;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment