Mk-Query-Digest
mk-query-digest Tips – Showing all hosts & users
The Maatkit tools provide a suite of additional MySQL commands. There is one command I use constantly and that is mk-query-digest. Unfortunately the documentation does leave a lot to be desired for usability.
tcpdump errors on FreeBSD for mk-query-digest
While I use this tcpdump command for MySQL query analysis with mk-query-digest , I found recently that it didn’t work on FreeBSD $ tcpdump -i bge0 port 3306 -s 65535 -x -n -q -tttt -c 5 tcpdump: syntax error It left me perplexed and reading the man page seemed to indicate my options were valid.
Take a look at mk-query-digest
Q: What SQL is running on your MySQL database server now? A: The bane of pain for MySQL DBA’s when there is no official MySQL instrumentation that is dynamic and fine grained sufficiently to solve this problem at the SQL interface.