Kill all sleeping MySQL connections

SnippetApril 7, 2015

SELECT GROUP_CONCAT(CONCAT('KILL ', id, ';') SEPARATOR ' ')
  FROM information_schema.processlist
 WHERE command = 'Sleep' AND time > 300;