Skip to content

Instantly share code, notes, and snippets.

@iandev

iandev/kill all queries

Created August 24, 2021 04:46
Show Gist options
  • Save iandev/ff27b6a77976ec8b9e08b7826cbf4557 to your computer and use it in GitHub Desktop.
Save iandev/ff27b6a77976ec8b9e08b7826cbf4557 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
kill all queries
SELECT CONCAT('KILL ', id, ';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE `User` = '<username>' AND `db` = '<dbname>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment