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

QAN explain, example, table not working

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 2.10.1
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      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
          163 kB
          Lalit Choudhary
        2. ps_56_default_QAN_Explain.png
          185 kB
          Lalit Choudhary
        3. ps_56_default-QAN_Tables.png
          172 kB
          Lalit Choudhary
        4. ps_fix_examples.png
          180 kB
          Lalit Choudhary
        5. ps_fix_explain.png
          195 kB
          Lalit Choudhary
        6. ps_fix_tables_tab.png
          197 kB
          Lalit Choudhary
        7. Qan_query_examples.png
          177 kB
          Lalit Choudhary
        8. Qan_query_explain.png
          188 kB
          Lalit Choudhary
        9. Qan_query_tables_tab.png
          177 kB
          Lalit Choudhary
        10. QAN_slowlog_query_explain.png
          189 kB
          Lalit Choudhary
        11. QAN_slowlog_query_tables_tab.png
          125 kB
          Lalit Choudhary

          Activity

            People

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

              Dates

              Created:
              Updated:

                Smart Checklist