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

[28 Aug 2012 20:26] Todd Farmer
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:
[28 Aug 2012 20:53] Todd Farmer
Just for sake of clarity, the expectation is that KILL TRANSACTION would initiate rollback of the active transaction for the given MySQL connection ID.