Skip to content

Instantly share code, notes, and snippets.

@bogdanr

bogdanr/gist:59297a484f0ec8211a35

Created February 5, 2016 09:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bogdanr/59297a484f0ec8211a35 to your computer and use it in GitHub Desktop.
Save bogdanr/59297a484f0ec8211a35 to your computer and use it in GitHub Desktop.
Download ZIP
Kill long running processes in RDS
Raw
gistfile1.txt
mysql -h __some_host__ -p __some_pass__ -r -s -e "select concat('CALL mysql.rds_kill(',id,');') from information_schema.processlist where command='Sleep' and time > 200;" > aaa.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment