Bug #75101 Query Stats Information with P_S enabled/disabled

• Submitted: 4 Dec 2014 3:58
• Modified: 17 May 2016 22:30
• Reporter: Philip Olson
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.3.7
• OS: Any
• CPU Architecture: Any

[4 Dec 2014 3:58] Philip Olson

Description:
The "Query Stats" information tab is populated whether or not the Performance Schema is enabled or not. However, the information is different. For example, "SELECT * FROM sakila.actor LIMIT 200" yields something like:

With P_S enabled:
Rows sent to client: 200
Index usage: No index used
Full table scans (Select_scan): 1

With P_S disabled:
Rows sent to client: 0
Index usage: At least one index was used
Full table scans (Select_scan): 0

This can be confusing, which makes me wonder if this tab should be disabled (or only certain content disabled) when P_S is disabled. 

Please explain how this works.

How to repeat:
1. Enable P_S
2. Execute a query
3. View Query Stats
4. Pin results tab
5. Disable P_S
6. Execute the same query
7. View Query Stats
8. Compare the two results

[4 Dec 2014 5:05] MySQL Verification Team

Hello Philip Olson,

Thank you for the bug report and repeatable test case.

Thanks,
Umesh

[4 Dec 2014 5:06] MySQL Verification Team

Screenshot..

Attachment: 75101.png (image/png, text), 31.30 KiB.

[22 Mar 2016 11:54] Miguel Tadeu Mota

The code was there, just that the map always seems to have at least one item present

[17 May 2016 22:30] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.7 release, and here's the changelog entry:

The Query Stats information tab was populated even when the Performance
Schema was disabled.

Thank you for the bug report.