pt-query-digest ignores --limit when running for 24h

[Perrin Harkins]

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.

[Daniel Nichter (daniel-nichter)]

This one might be difficult to reproduce if it requires running for a day, but we'll try nonetheless and see if --limit is somehow affected by different --run-time lengths.

[Perrin Harkins (perrin)]

I looked into this some more and finally discovered that it was the default setting of --outliers that was adding more queries in. Unfortunately, there is no way to turn that off completely except to specify an absurd value, but that's a separate issue. Consider this bug report retracted.

[Daniel Nichter (daniel-nichter)]

Thanks for reporting back. I'll keep in mind that --outliers can't be disabled when/if someday we do some major work on pqd.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1042