Skip to content

Instantly share code, notes, and snippets.

@chris-huffman

chris-huffman/kill-multiple-mysql-processes.sh

Created December 6, 2019 16:17
Show Gist options
  • Save chris-huffman/6c5d93cf95c063f8bdf051081be89601 to your computer and use it in GitHub Desktop.
Save chris-huffman/6c5d93cf95c063f8bdf051081be89601 to your computer and use it in GitHub Desktop.
Download ZIP
Delete Multiple MySQL processes
Raw
kill-multiple-mysql-processes.sh
for PID in $(mysqladmin processlist | grep 'INSERT INTO `search_tmp' | awk '{ print $2; }'); do mysqladmin kill $PID; done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment