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

LP #1195456: pt-query-digest skips queries

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Ryan Lowe last update 02-08-2013 18:37:38

      Having run pt-query-digest 2.2 against a slow query log, I get the following (anonymized) output:

      1. Profile
      2. Rank Query ID Response time Calls R/Call V/M Item
      3. ==== ================== =============== ======= ======== ===== =========
      4. 1 0x9547A60B17EFDFF2 3942.7586 22.1% 2585 1.5252 0.00 SELECT x
      5. 2 0x3CA33B6583A85AC0 2033.2187 11.4% 1958 1.0384 0.68 SELECT x y
        ...
      6. 19 0x12CD1C170E457B81 195.6057 1.1% 1 195.6057 0.00 SELECT z
      7. 20 0x51363D8AFB1D6F90 186.3636 1.0% 1376 0.1354 0.00 SELECT a
      8. 22 0xE524E76CF9719105 144.7776 0.8% 27 5.3621 0.03 SELECT x y
      9. 24 0x9D4430B7270E6646 128.3290 0.7% 46 2.7898 1.65 SELECT x b
        ...
      10. 82 0x40A235ECA8139B12 18.0485 0.1% 126 0.1432 1.16 SELECT x y
      11. MISC 0xMISC 3377.6036 18.9% 5170806 0.0007 0.0 <787 ITEMS>

      Notice 19-24 where it skips 21 and 23. They also do not appear later in the report. What gives?

        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: