Mk-Query-Digest

Databases MySQL

mk-query-digest Tips – Showing all hosts & users

Ronald Bradford
June 1, 2010

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.

Databases MySQL

tcpdump errors on FreeBSD for mk-query-digest

Ronald Bradford
May 28, 2010

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.

Databases MySQL Uncategorized

Take a look at mk-query-digest

Ronald Bradford
October 8, 2009

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.