Skip to content

Instantly share code, notes, and snippets.

@mgttt

mgttt/mysql kill sleep

Created October 19, 2020 13:52
Show Gist options
  • Save mgttt/1b8e9678bcc0a7181bb5309eee3717ca to your computer and use it in GitHub Desktop.
Save mgttt/1b8e9678bcc0a7181bb5309eee3717ca to your computer and use it in GitHub Desktop.
Download ZIP
mysql kill sleep
Raw
mysql kill sleep
select @to_kill_proc_list:=GROUP_CONCAT(CONCAT('KILL ',ID) SEPARATOR ';') q FROM information_schema.processlist WHERE Command='Sleep' and Time>5;PREPARE stmt FROM @to_kill_proc_list;EXECUTE stmt;DEALLOCATE PREPARE stmt;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment