Kill Multiple MySQL Queries
SELECT
GROUP_CONCAT(CONCAT('KILL ', id, ';')
SEPARATOR ' ')
FROM
information_schema.processlist
WHERE
user <> 'system user';
SELECT
GROUP_CONCAT(CONCAT('KILL ', id, ';')
SEPARATOR ' ')
FROM
information_schema.processlist
WHERE
Command <> 'Slepp';
#kill the query being implemented by a thread and leave the connection active,
#use the KILL QUERY command instead.
SELECT
GROUP_CONCAT(CONCAT('KILL QUERY ', id, ';')
SEPARATOR ' ')
FROM
information_schema.processlist
WHERE
Command <> 'Slepp';
https://gist.github.com/i88ca/cea1853ed4f548caa2c7f611f2c41b5b
Comments
Post a Comment