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

Query Analytics: no 'Example' or 'Explain' data for MariaDB

Details

    • Platform Sprint 33
    • Yes
    • Yes

    Description

      Impact on the user:

      • Users unable to monitor MariaDB

      Steps to reproduce:

      1. connect MariaDB with enabled performance-schema to pmm-server
      2. exec any query 
      3. find the query in QAN
      4. check tabs "Example" and "Explain"

      Actual result:

      • Query example and some explain data

      Expected Result:

      • No example and no Explain/table data

      Workaround:

      Run following command to start collecting data into  performance_schema.events_statements_history

      UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES'
       WHERE NAME LIKE 'statement/%';
       UPDATE performance_schema.setup_consumers SET ENABLED = 'YES'
       WHERE NAME LIKE '%statements%';

      Documentation

      To collect real examples user should execute following queries in DB.

      UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES'
       WHERE NAME LIKE 'statement/%';
       UPDATE performance_schema.setup_consumers SET ENABLED = 'YES'
       WHERE NAME LIKE '%statements%';

      Details


      Attachments

        Issue Links

          Activity

            People

              paul.jacobs Paul Jacobs (Inactive)
              vadim.yalovets Vadim Yalovets
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 2 hours, 40 minutes
                  2h 40m

                  Smart Checklist