Bug #67906 | MySQL should kill idle transactions | ||
---|---|---|---|
Submitted: | 14 Dec 2012 10:09 | Modified: | 14 Dec 2012 10:21 |
Reporter: | Lixun Peng (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S4 (Feature request) |
Version: | 5.* | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | Kill Idle Transactions, Long Transactions |
[14 Dec 2012 10:09]
Lixun Peng
[14 Dec 2012 10:10]
Lixun Peng
this patch based on 5.1.61, and we used it on our production environment
Attachment: 5.1.61_server_kill_idle_trx.diff (application/octet-stream, text), 12.90 KiB.
[15 Dec 2012 8:38]
MySQL Verification Team
this effectively deals with the old problem i reported :) http://bugs.mysql.com/bug.php?id=54455 (innodb needs a way to limit consistent read snapshot age)