Skip to content

Instantly share code, notes, and snippets.

@vithalreddy

vithalreddy/mysql - kill all sleeping connections

Forked from lucashungaro/mysql - kill all sleeping connections
Created January 11, 2022 07:33
Show Gist options
  • Save vithalreddy/4f0220c077bc2ab634317383861997ec to your computer and use it in GitHub Desktop.
Save vithalreddy/4f0220c077bc2ab634317383861997ec 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