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

LP #1265546: wrong statistics for query type

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Aleksandr Kuzminsky last update 17-11-2014 04:17:20

      There are two types of queries in a slow log:
      1. SELECT /*!40001 SQL_NO_CACHE */ * FROM <table> (2 queries)
      2. INSERT INTO <table> (4k queries)

      Nevertheless pt-query-digest reports this statistics:

      1. Attribute pct total min max avg 95% stddev median
      2. ============ === ======= ======= ======= ======= ======= ======= =======
      3. Count 0 751
      4. Exec time 20 198s 44us 29s 264ms 501ms 2s 84us
      5. Lock time 0 20ms 16us 140us 26us 42us 8us 22us
      6. Rows sent 48 31.81M 0 10.79M 43.38k 59.57k 467.31k 9.83
      7. Rows examine 13 31.81M 0 10.79M 43.38k 59.57k 467.31k 9.83
      8. Query size 0 43.21k 45 79 58.92 69.19 6.27 56.92
      9. String:
      10. Databases <db1> (173/23%), <db2> (98/13%)... 32 more
      11. Hosts localhost
      12. Users <user>
      13. Query_time distribution
      14. 1us
      15. 10us ################################################################
      16. 100us ####################
      17. 1ms ##########
      18. 10ms ###########
      19. 100ms #########
      20. 1s ###
      21. 10s+ #

      Count 751 neither corresponds to SELECT nor to INSERT.

        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: