Percona Server moved to https://jira.percona.com/projects/PS

innodb_kill_idle_transaction should be implemented in the server

Series 5.7
Bug #907719

Bug #907719 reported by Alexey Kopytov on 2011-12-22

This bug affects 2 people

	Status	Importance	Assigned to	Milestone
Percona Server moved to https://jira.percona.com/projects/PS	Status tracked in 5.7
5.5	Won't Fix	Wishlist	Unassigned
5.6	Fix Released	Wishlist	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.6.35-80.0
5.7	Fix Released	Wishlist	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.7.17-11

Bug Description

As suggested on percona-discussion, innodb_kill_idle_transaction should be implemented in the server rather than in InnoDB. This approach, besides resulting in a more simple patch, avoids locking kernel_mutex to iterate list of active transactions inside InnoDB.

Tags:

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2011-12-22:

Link to the percona-discussion thread: http://groups.google.com/group/percona-discussion/t/b0b7ff01987c16a5

Changed in percona-server:
status:	New → Confirmed

Valentine Gostev (longbow) on 2011-12-22

Changed in percona-server:
importance:	Undecided → Wishlist

Revision history for this message

Lixun Peng (P.Linux) (plx) wrote on 2011-12-23:

server_kill_idle_trx.patch

Revision history for this message

Lixun Peng (P.Linux) (plx) wrote on 2011-12-23:

This patch is we used.

+------------------------------+-------+
| Variable_name | Value |
+------------------------------+-------+
| trx_changes_idle_timeout | 0 |
| trx_idle_timeout | 0 |
| trx_readonly_idle_timeout | 0 |
+------------------------------+-------+
"trx_idle_timeout" like your "innodb_kill_idle_transaction".Priority first.
"trx_changes_idle_timeout" will kill the transaction with "update", "delete", "insert" queries.
"trx_readonly_idle_timeout" will kill the transaction with only "select" queries.