Digital Marketing

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

Popular posts from this blog

MySQL Sandbox with the Sakila sample database