Details

    • Type: Bug
    • Status: Open
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: 2.1.0, 2.2.0
    • Fix Version/s: future
    • Component/s: QAN API, QAN App
    • Labels:
    • Sprint:
      Ready for Grooming

      Description

      User Impact: 

      AVG values for Query time in Details and Profile sections are different. one of them is wrong, so user can't  see real numbers

       

      Reproducible test case:

       

      # pmm-admin add mysql ps5728 --query-source=slowlog --username=msandbox --password=msandbox 127.0.0.1:5728 --environment=bugtest
      MySQL Service added.
      Service ID : /service_id/d4324fc4-6504-4bd3-ae32-fcde18a9920a
      Service name: ps5728
      Load some data:
      sysbench /usr/share/sysbench/oltp_read_write.lua --mysql_storage_engine=innodb --table-size=10000 --tables=1 --mysql-db=test --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5728.sock --threads=10 --time=900 --report-interval=1 --events=0 --db-driver=mysql prepare
      
      sysbench /usr/share/sysbench/oltp_read_write.lua --mysql_storage_engine=innodb --table-size=10000 --tables=1 --mysql-db=test --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5728.sock --threads=10 --time=100 --report-interval=1 --events=0 --db-driver=mysql run
      

       

       

      Example1:  Difference in average time with something wrong with the decimal point or units.

      QAN Query: select c from sbtest1 where id=?

           VS  

       

      Example2:

      QAN Query:update sbtest1 set k=k? where id=?

        VS  

       

      Expected Behavior:

      Avg values should the same and correct at both places.

       

      Original report:

      ---------

       

       

      There are consistently latency reporting inconsistencies in QAN, generally with the average.

      I've included an example where the individual query stats are clearly wrong, where the average is higher than the p99. In the second screenshot, it appears to be correct when hovering on the chart in the list, and the average is a completely different number.

      In this next example, it's a similar problem with the average, but this time the average isn't a completely different number, it appears to be something wrong with the decimal point or units.

       

        Smart Checklist

          Attachments

          1. image-2019-11-28-16-20-59-292.png
            image-2019-11-28-16-20-59-292.png
            35 kB
          2. image-2019-11-28-16-23-33-235.png
            image-2019-11-28-16-23-33-235.png
            13 kB
          3. image-2019-11-28-16-28-39-140.png
            image-2019-11-28-16-28-39-140.png
            39 kB
          4. image-2019-11-28-16-29-02-132.png
            image-2019-11-28-16-29-02-132.png
            12 kB
          5. PMM2.1.0_img2.jpg
            PMM2.1.0_img2.jpg
            255 kB
          6. PMM2.1.0_per_query_statsimg1.jpg
            PMM2.1.0_per_query_statsimg1.jpg
            134 kB
          7. PMM2.2.0_avg_img1.jpg
            PMM2.2.0_avg_img1.jpg
            240 kB
          8. PMM2.2.0_update_avg_img2.jpg
            PMM2.2.0_update_avg_img2.jpg
            229 kB

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                derekperkins Derek Perkins
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: