Skip to content

Instantly share code, notes, and snippets.

@krukru

krukru/gist:6c799d760924e80d19038a6e9efabfdb

Created December 20, 2019 11:23
Show Gist options
  • Save krukru/6c799d760924e80d19038a6e9efabfdb to your computer and use it in GitHub Desktop.
Save krukru/6c799d760924e80d19038a6e9efabfdb to your computer and use it in GitHub Desktop.
Download ZIP
RDS get sleepy connections kill list
Raw
gistfile1.txt
SELECT GROUP_CONCAT('CALL mysql.rds_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