Skip to content

Instantly share code, notes, and snippets.

@daniDLL

daniDLL/select blocked mysql queries

Last active March 2, 2020 15:52
Show Gist options
  • Save daniDLL/5a05b2d7434876b77517b0ab5d06bcdd to your computer and use it in GitHub Desktop.
Save daniDLL/5a05b2d7434876b77517b0ab5d06bcdd to your computer and use it in GitHub Desktop.
Download ZIP
select blocked mysql queries
Raw
select blocked mysql queries
select group_concat(concat('KILL ',id,';') separator ' ') from information_schema.processlist where time > 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment