Skip to content

Instantly share code, notes, and snippets.

@vanjos

vanjos/Running_query_volume.sh

Created August 28, 2013 12:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save vanjos/6365590 to your computer and use it in GitHub Desktop.
Save vanjos/6365590 to your computer and use it in GitHub Desktop.
Download ZIP
Find the volume of running MySQL queries. Helps nail down what gets run a lot in a high-volume system
Raw
Running_query_volume.sh
mysql -e "show processlist" | grep -v Rows | grep -v Sleep | grep -oP -A1 "(SELECT|UPDATE|INSERT).*FROM \w+" | sort -h | uniq -c | sort -n
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment