Emulate A More Granular MySQL Slow Query Log With Maatkit

[rolandomysqldba]

This video is simply dynamite. I have implemented this over 4 months ago for a client at my employer's web hosting company.

The method presented in the video was crontab'd every 20 minutes and helped my client find the troublesome queries they had. They have since placed the query output into memcached.

Anytime a bad query rears its ugly head, the top 20 worst performing queries show up and my client responses to it. GOOD JOB, PERCONA !!!

[qwertydzen1]

It don't working for me

I checked on the 3 servers

perl mk-query-digest --processlist localhost --interval 0.01

Pipeline process 2 (Processlist) caused an error: Use of uninitialized value in anonymous hash ({}) at mk-query-digest line 2259.

Pipeline process 2 (Processlist) caused an error: Use of uninitialized value in anonymous hash ({}) at mk-query-digest line 2259.

# Caught SIGINT.

[RobertMOdell]

Why not just configure mySQL to dump all the queries strings it receives to a log?