Socket-based kill idle transaction feature re-implementation
Registered by
Laurynas Biveinis
https:/
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_
Blueprint information
- Status:
- Complete
- Approver:
- Laurynas Biveinis
- Priority:
- Medium
- Drafter:
- Laurynas Biveinis
- Direction:
- Approved
- Assignee:
- Laurynas Biveinis
- Definition:
- Approved
- Series goal:
- Accepted for 5.6
- Implementation:
- Implemented
- Milestone target:
- 5.6.35-80.0
- Started by
- Laurynas Biveinis
- Completed by
- Laurynas Biveinis
Related branches
Related bugs
Sprints
Whiteboard
(?)
Work Items
Dependency tree
* Blueprints in grey have been implemented.