MySQL Bugs: #51120: Reveal problem query in large transaction COMMIT hang

Bug #51120	Reveal problem query in large transaction COMMIT hang
Submitted:	11 Feb 2010 21:02	Modified:	14 Jan 2013 17:52
Reporter:	Jonathon Coombes	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Logging	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	commit, innodb, locking, transaction

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When a large transaction is committing it shows up only as COMMIT in the processlist. Is there some feature that could be added to allow a view of where the transaction is in time and what specific query in the transaction is causing the delay or locking.

How to repeat:
N/A

Suggested fix:
N/A

Surely this can be done with appropriate performance_schema queries in 5.6?
http://dev.mysql.com/doc/refman/5.6/en/events-statements-history-long-table.html