MySQL Bugs: #66582: Add support for KILL TRANSACTION

Bug #66582	Add support for KILL TRANSACTION
Submitted:	28 Aug 2012 20:26
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S4 (Feature request)
Version:	5.6.6	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MySQL allows privileged users to issue KILL [QUERY|CONNECTION].  That helps deal with long-running queries or problematic connections.  It does not help deal with long-running transactions that hold locks for excessive periods of time.  Implementing KILL TRANSACTION to release held locks would be useful in such situations, and where killing a connection has severe effects on the impacted application.

How to repeat:
Try to kill a long-running transaction without killing the connection.

Suggested fix:
Add KILL TRANSACTION support.

Just for sake of clarity, the expectation is that KILL TRANSACTION would initiate rollback of the active transaction for the given MySQL connection ID.