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

  1. Series 5.7
  2. Bug #907719
  3. Comment #3

Comment 3 for bug 907719

Revision history for this message
Lixun Peng (P.Linux) (plx) wrote :

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.