Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Explain is a part of query

Description

  1. Install PMM 1.9.0

  2. Setup MariaDB with slow log

  3. Add MariaDB to monitoring

  4. Run sysbench. for example :

  5. Open QAN dashboard and find "Explain" query
    Result: Explain query looks like "explainSELECT c
    FROM sbtest?
    WHERE id=? " See screenshot
    Expected result: It should looks like "explain SELECT c
    FROM sbtest?
    WHERE id=?"

Bug is reproducible for Pertcona Server 5.7 with enabled slow log

How to test

None

How to document

None

Attachments

3

Smart Checklist

Activity

Daria Lymanska April 22, 2018 at 10:56 PM

Problem appeared due to case sensitive behavior of workaround. Fixed by performing case insensitive check.

Nailya Kutlubaeva April 19, 2018 at 7:09 AM

Fingerprint part was fixed, but example part was not.

Roma Novikov April 19, 2018 at 7:05 AM

Andrii Skomorokhov April 5, 2018 at 2:05 PM
Edited

Need to create a PR at https://github.com/vkiryukhin/vkBeautify

with next fix: 

https://github.com/vkiryukhin/vkBeautify/blob/master/vkbeautify.js#L254

Add line: 

.replace(/EXPLAIN\s{0,}/ig,"EXPLAIN ")

 

Also check whether better to use https://github.com/vkiryukhin/pretty-data instead of vkbeautify (same author, similar functionality, but more activity in repo)

 

 

Done

Details

Assignee

Reporter

Priority

Components

Fix versions

Affects versions

Smart Checklist

Created April 4, 2018 at 5:15 PM
Updated November 13, 2024 at 8:34 AM
Resolved May 24, 2018 at 9:29 AM