Bug #73344 Unit Scale (Label) is Wrong
Submitted: 21 Jul 2014 15:07 Modified: 3 Feb 2015 3:27
Reporter: Eric Harney Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.1.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: display, label, millisecond, time, unit

[21 Jul 2014 15:07] Eric Harney
Description:
MySQL Workbench 6.1 (on MySQL 5.6.17) shows the unit of the measured value in the performance reports, and claims the values to be milliseconds (ms), when in fact they are microseconds (us or ┬Ás). 

How to repeat:
(0. Install & activate/enable the performance schema)
1. Open any of the reports in MySQL Workbench 6.1 that displays time values, (e.g. "statement analysis")
2. run the same query the report used to generate the table
3. compare the values - they're 6 orders of magnitude, when in fact they should be 9, since MySQL returns the values as picoseconds and MySQL Workbench claims to display them as milliseconds

Suggested fix:
Divide the values by another 10^3 before displaying them.
[21 Jul 2014 15:17] Eric Harney
(fixed tags)
[23 Jul 2014 6:19] MySQL Verification Team
Hello Eric,

Thank you for the report.
Verified as described.

Indeed, the results are showing in microseconds.

// 5.6.21
mysql> select "Bug",sleep(1) from dual;
+-----+----------+
| Bug | sleep(1) |
+-----+----------+
| Bug |        0 |
+-----+----------+
1 row in set (1.00 sec)

// Statement Analysis - WB 6.1.7

Query, Full Table Scan, Executed (#), Errors (#), Warnings (#), Total Time (ms), Max Time (ms), Avg Time (ms), Rows Sent (#), Avg. Rows Sent (#), Rows Scanned (#), Avg. Rows Scanned (#), Temp. Tables (#), Temp. Disk Tables (#), Rows Sorted (#), Sort Merge Passes (#), Digest
SELECT ? , `sleep` (?) FROM DUAL , , 1, 0, 0, 1000367.656, 1000367.656, 1000367.656, 1, 1.0, 0, 0.0, 0, 0, 0, 0, 9db124ab2b949be0a91a4658923f43ba

It shows 1000367.656, for 1 sec.

Thanks,
Umesh
[7 Jan 2015 14:48] Juan Rene Ramirez Monarrez
Posted by developer:
 
The issue was properly identified and fixed.

Problem was that the menu is only enabled fo specific units (time/bytes) and the table was not reporting properly the clicked column which has the unit associated, this caused the real column unit to never be selected and so caused the menu to be disabled all the time.

Now the menu will be enabled for all the columns having a time/byte unit.

Thanks for reporting this issue, fix will be available in 6.2.5
[3 Feb 2015 3:27] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry:

The measurement units used by the performance reports were sometimes
incorrect.

Thank you for the bug report.