Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
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