Skip to content

Instantly share code, notes, and snippets.

@phcostabh

phcostabh/generate_kill_command_processlist.sql

Created July 13, 2017 12:39
Show Gist options
  • Save phcostabh/2b5b6862b43105e33db618d4d3dfecfb to your computer and use it in GitHub Desktop.
Save phcostabh/2b5b6862b43105e33db618d4d3dfecfb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
generate_kill_command_processlist.sql
SELECT GROUP_CONCAT(CONCAT('KILL ',id,';') SEPARATOR ' ') 'command' FROM information_schema.processlist WHERE db = 'letras'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment