Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-6733

QAN explain, example, table not working

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.10.1
    • None
    • Documentation
    • None

    Description

      QAN explains,  examples, tables tab not showing details for selected queries.

      Issue consistently reproduciable when using --query-source=perfschema

      Reproduciable test: 

      #pmm-admin add mysql ps_5731 127.0.0.1:5731 --username=msandbox --password=msandbox --query-source=perfschema
      
      run symple sysbench load:
      $ sysbench /usr/share/sysbench/oltp_read_write.lua --mysql_storage_engine=innodb --table-size=133 --tables=4 --mysql-db=foo_perf --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5731.sock --threads=3 --time=900 --report-interval=1 --events=0 --db-driver=mysql prepare
      

       

      check QAN for foo_perf schema,

      examples:

       

       

       

      Attachments

        1. ps_56_default_Examples.png
          ps_56_default_Examples.png
          163 kB
        2. ps_56_default_QAN_Explain.png
          ps_56_default_QAN_Explain.png
          185 kB
        3. ps_56_default-QAN_Tables.png
          ps_56_default-QAN_Tables.png
          172 kB
        4. ps_fix_examples.png
          ps_fix_examples.png
          180 kB
        5. ps_fix_explain.png
          ps_fix_explain.png
          195 kB
        6. ps_fix_tables_tab.png
          ps_fix_tables_tab.png
          197 kB
        7. Qan_query_examples.png
          Qan_query_examples.png
          177 kB
        8. Qan_query_explain.png
          Qan_query_explain.png
          188 kB
        9. Qan_query_tables_tab.png
          Qan_query_tables_tab.png
          177 kB
        10. QAN_slowlog_query_explain.png
          QAN_slowlog_query_explain.png
          189 kB
        11. QAN_slowlog_query_tables_tab.png
          QAN_slowlog_query_tables_tab.png
          125 kB

        Activity

          People

            Unassigned Unassigned
            lalit.choudhary Lalit Choudhary
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist