Skip to content

Instantly share code, notes, and snippets.

@lucashungaro

lucashungaro/mysql - kill all sleeping connections

Created August 11, 2010 13:20
Show Gist options
  • Star 7 You must be signed in to star a gist
  • Fork 6 You must be signed in to fork a gist
  • Save lucashungaro/518964 to your computer and use it in GitHub Desktop.
Save lucashungaro/518964 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