samlambert/qps

Last active December 14, 2015 12:48

Star 3 You must be signed in to star a gist
Fork 0 You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/samlambert/5089207.js"></script>
Save samlambert/5089207 to your computer and use it in GitHub Desktop.

Download ZIP

One liner to print MySQL Queries Per Second.

Raw

qps

mysqladmin ext -i1 | gawk '/Queries/{q=$4-ql;ql=$4; printf("%s QPS: %s\n", strftime("%H:%M:%S"), q)}'

Author

samlambert commented Sep 23, 2013

Output to file:

sudo mysqladmin ext -i1 | gawk '/Queries/{q=$4-ql;ql=$4; printf("%s %s\n", strftime("%H:%M:%S"), q, fflush())}' | tee qps.dat

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment