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

LP #1371774: pt-query-digest inconsistent rank order

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Frank Cizmich last update 12-02-2015 15:14:47

      This is a minor issue that only affects testing.

      pt-query-digest (specifically the EventAggregator module) orders the top "worst" queries according to one or more pre-definable attribute values.
      But when two values are equal, the sort algorithm sometimes inverts their order in different OSs.
      This is innocuous to an end user, but causes false positives in the testing suite.

      Sample output showing differences from testing run:

      1. < # 5 0xED69B13F3D0161D0 20661.0000 16.7% 1 20661.0000 0.00 UPDATE test?.tbl?
      2. < # 6 0x79BFEA84D0CED05F 20661.0000 16.7% 1 20661.0000 0.00 INSERT UPDATE test?.tbl?
      3. > # 5 0x79BFEA84D0CED05F 20661.0000 16.7% 1 20661.0000 0.00 INSERT UPDATE test?.tbl?
      4. > # 6 0xED69B13F3D0161D0 20661.0000 16.7% 1 20661.0000 0.00 UPDATE test?.tbl?

      Simplest solution should be to tie-break using the query fingerprint.

        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: