Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1042

LP #1074472: pt-query-digest ignores --limit when running for 24h

    XMLWordPrintable

    Details

      Description

      **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" perrin@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.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: