krukru/gist:6c799d760924e80d19038a6e9efabfdb

Created December 20, 2019 11:23

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/krukru/6c799d760924e80d19038a6e9efabfdb.js"></script>
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