Socket-based kill idle transaction feature re-implementation

Registered by Laurynas Biveinis

Current kill idle transaction feature implementation works at a low InnoDB transaction list level, periodically scanning it and killing the old ones.

Lixun Peng proposed re-implementing this by setting a different socket read timeout value instead (bug 907719). Such implementation has several advantages:
- much simpler code, getting rid of crashing bugs in the current one (bug 1166744, bug 1179136)
- works with any storage engine, not only InnoDB.

On user level, introduce a new server variable kill_idle_transaction. Make the old innodb_kill_idle_transaction variable its deprecated alias, to be removed in 8.0.



Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.


No subscribers.