Skip to content

Instantly share code, notes, and snippets.

@vanjos

vanjos/Running_query_volume.sh

Created August 28, 2013 12:42
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Learn more about clone URLs
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