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

Slow log parse error: explain as part of a fingerprint

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.5.1
    • Fix Version/s: 1.8.0
    • Component/s: QAN Agent
    • Labels:
      None

      Description

      Hi,
      QAN fingerprint shows `explain` as part of a fingerprint after updating PMM to 1.5.1 from 1.4:

      # Time: 171205 12:03:32
      # User@Host: test[test] @ app1.test [127.0.0.1]
      # Thread_id: 81911987 Schema: test QC_hit: No
      # Query_time: 15.129081 Lock_time: 0.000038 Rows_sent: 10 Rows_examined: 6293211
      # Rows_affected: 0
      #
      # explain: id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra
      # explain: 1 SIMPLE notifications ref for_resource for_resource 5 const 4183495 6293211.00 100.00 0.00 Using index condition; Using where
      #
      SET timestamp=1512464612;
      SELECT `notifications`.* FROM `notifications` WHERE `notifications`.`resource_id` IS NULL AND `notifications`.`key` = 'some_key';

      QAN's fingerprint:

      # # explain: id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra # explain: 1 SIMPLE notifications ref for_resource for_resource 5 const 4183485 6293207.00 100.00 0.00
      USING index condition;
      USING
      WHERE #SELECT `notifications`.*
      FROM `notifications`
      WHERE `notifications`.`resource_id` IS NULL
       AND `notifications`.`key` = 'some_key'

      Expected fingerprint:

      SELECT `notifications`.*
      FROM `notifications`
      WHERE `notifications`.`resource_id` IS NULL
       AND `notifications`.`key` = 'some_key'

      We're using mariadb 10.1.20.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  borys.belinsky Borys Belinsky
                  Reporter:
                  kompastver Pavel Znamensky
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 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 - 1 day, 1 hour, 40 minutes
                    1d 1h 40m