Bug #77861 "SHOW PROCESSLIST" needs higher resolution time
Submitted: 28 Jul 2015 17:30 Modified: 29 Jul 2015 6:58
Reporter: Domas Mituzas Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.6, 5.6.26 OS:Any
Assigned to: CPU Architecture:Any

[28 Jul 2015 17:30] Domas Mituzas
yup, I saw bug#75156. 
existence of performance schema doesn't mean that all existing features should be gimped forever. 

there're ways to add support to both 5.6 and future releases - e.g. by having a session variable, 'show processlist' syntax modifier, separate i_s table, separate column and many other ways.

even mongodb has an easy access to high resolution data - https://jira.mongodb.org/browse/SERVER-13368

How to repeat:
'show processlist'

Suggested fix:
add millisecond or microsecond resolution to all 'Time' columns.
[29 Jul 2015 6:58] Umesh Shastry
Hi Domas,

Thank you for the report.