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

MariaDB Slow Query log metrics do not seem to be parsed

    Details

      Description

      Hi,

      I'm testing PMM with MariaDB 10.1

      I see this in my log file:

      SELECT @@version;

      1. User@Host: root[root] @ localhost []
      2. Thread_id: 58 Schema: QC_hit: No
      3. Query_time: 0.001969 Lock_time: 0.000072 Rows_sent: 523 Rows_examined:
        523
      4. Rows_affected: 0
      5. Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
      6. Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No

      As you see there are many Query Plan metrics supported similar to Percona
      Server

      However the only metrics I see are ones from MySQL

      [image: Inline image 1]

      MariaDB Configuration

      [mariadb]
      log_output=file
      slow_query_log=ON
      long_query_time=0
      log_slow_verbosity=query_plan,innodb
      log_slow_admin_statements=ON
      log_slow_slave_statements=ON
      innodb_monitor_enable=all
      userstat=1


      Peter Zaitsev, CEO, Percona
      Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  pz Peter Zaitsev
                • 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 - 0 minutes
                    0m
                    Logged:
                    Time Spent - 4 hours
                    4h