MySQL Bugs: #63608: When thread state contains "locked" (case insensitive), I need "by what"

Bug #63608	When thread state contains "locked" (case insensitive), I need "by what"
Submitted:	5 Dec 2011 17:16	Modified:	5 Dec 2011 17:28
Reporter:	Kevin Benton	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S4 (Feature request)
Version:	Any	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When looking at the list of active processes either from SHOW PROCESSLIST or from INFORMATION_SCHEMA.PROCESSLIST, I would like to have it tell me what thread is blocking the "current" thread when it's blocked. That would make it possible to troubleshoot any blocked threads without respect to storage engine and make the administrator's job a ton easier.

How to repeat:
See description.

Suggested fix:
See description.

Thank you for the feature request.