Skip to content

Instantly share code, notes, and snippets.

@vanjos
Created August 28, 2013 12:42
Show Gist options
  • Save vanjos/6365590 to your computer and use it in GitHub Desktop.
Save vanjos/6365590 to your computer and use it in GitHub Desktop.
Find the volume of running MySQL queries. Helps nail down what gets run a lot in a high-volume system
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