Explain section returns different results

Description

STR:

Open these two instances, select few queries and notice that Explain section is returning different results.

http://18.216.249.15/graph/d/pmm-qan/pmm-query-analytics?columns=%5B%22load%22,%22num_queries%22,%22query_time%22%5D&filter_by=a4e608692ba2721250c223e88b0110cf&var-environment=All&var-cluster=All&var-replication_set=All&var-database=All&var-schema=All&var-node_name=All&var-service_name=All&var-service_type=All&var-service_type=mysql&var-service_type=mongodb&var-node_type=All&var-interval=$__auto_interval_interval&order_by=-load&group_by=queryid&from=now-12h&to=now&totals=false&query_selected=true

http://18.219.161.142/graph/d/pmm-qan/pmm-query-analytics?columns=%5B%22load%22,%22num_queries%22,%22query_time%22%5D&filter_by=0777f5fb19c1c948f63a61c7df1778a2&var-environment=All&var-cluster=All&var-replication_set=All&var-database=All&var-schema=All&var-node_name=All&var-service_name=All&var-service_type=All&var-service_type=mongodb&var-service_type=mysql&var-node_type=All&var-interval=$__auto_interval_interval&order_by=-load&group_by=queryid&from=now-12h&to=now&totals=false&query_selected=true

Actual result:

The first one showing "No explains found" for every single query - backend is not answering with results

Second one is answering with results and showing explains correctly

 ***

Both instances were same version and same settings. This appears also for queries where the fingerprint matches the example.

For example query - see attachments

SELECT `TABLE_SCHEMA` , TABLE_NAME , `TABLE_TYPE` , `ifnull` ( ENGINE , ? ) AS ENGINE , `ifnull` ( `VERSION` , ? ) AS `VERSION` , `ifnull` ( ROW_FORMAT , ? ) AS ROW_FORMAT , `ifnull` ( `TABLE_ROWS` , ? ) AS `TABLE_ROWS` , `ifnull` ( `DATA_LENGTH` , ? ) AS `DATA_LENGTH` , `ifnull` ( `INDEX_LENGTH` , ? ) AS `INDEX_LENGTH` , `ifnull` ( `DATA_FREE` , ? ) AS `DATA_FREE` , `ifnull` ( `CREATE_OPTIONS` , ? ) AS `CREATE_OPTIONS` FROM `information_schema` . `tables` WHERE `TABLE_SCHEMA` = ?

 

How to test

None

How to document

None

Attachments

3

Smart Checklist

Activity

Show:

Roman Misyurin July 3, 2020 at 9:17 AM

Wait for the backend fixes

Details

Assignee

Reporter

Priority

Components

Needs QA

Yes

Needs Doc

Yes

Story Points

Environment

Smart Checklist

Created May 28, 2020 at 7:59 AM
Updated November 13, 2024 at 8:34 AM