**Reported in Launchpad by Perrin Harkins last update 22-11-2012 19:23:37
I've been using this from cron to send a daily report of slow queries:
pt-query-digest --processlist h=dbhost,u=root,p=mypassword --run-time 24h --limit=10 | mutt -s "Daily Top 10 Queries" email@example.com
This works great except that it sends hundreds of queries, not just 10. If I use a lower --run-time, like 24m, everything works as expected.
My tool version is 2.1.5, MySQL version 5.0.91-community-log.