Skip to content

Instantly share code, notes, and snippets.

@aaronpearce

aaronpearce/mysql - kill all sleeping connections

Forked from lucashungaro/mysql - kill all sleeping connections
Created January 10, 2019 07:12
Show Gist options
  • Save aaronpearce/3422bbcf3681b0653b293bf8cb1f1c62 to your computer and use it in GitHub Desktop.
Save aaronpearce/3422bbcf3681b0653b293bf8cb1f1c62 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL - kill command for all idle queries
Raw
mysql - kill all sleeping connections
SELECT GROUP_CONCAT('kill ',id SEPARATOR '; ') AS kill_list
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE command='Sleep';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment