Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1074472
  2. Comment #0

Comment 0 for bug 1074472

Revision history for this message
Perrin Harkins (perrin) wrote :

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 address hidden>

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.