Убить запросы из processlist
SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE USER='user_name' INTO OUTFILE '/tmp/KILL.sql'; SOURCE /tmp/KILL.sql;
SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE USER='user_name' AND TIME > 60 INTO OUTFILE '/tmp/KILL.sql'; SOURCE /tmp/KILL.sql;
Обсуждение