MySQL Bugs: #73344: Unit Scale (Label) is Wrong

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

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.

(fixed tags)

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

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

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.