MySQL Bugs: #77861: "SHOW PROCESSLIST" needs higher resolution time

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:	None
Category:	MySQL Server: Information schema	Severity:	S3 (Non-critical)
Version:	5.6, 5.6.26	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.

Hi Domas,

Thank you for the report.

Thanks,
Umesh