Kill Idle Transactions

Kill Idle Transactions

This feature limits the age of idle XtraDB transactions. If a transaction is idle for more seconds than the threshold specified, it will be killed. This prevents users from blocking purge by mistake.

System Variables

variable innodb_kill_idle_transaction
Version Info:
Scope:

GLOBAL
Config:

YES
Dynamic:

YES
Variable Type:

INTEGER
Default Value:

0 (disabled)
Units:

Seconds

To enable this feature, set this variable to the desired seconds wait until the transaction is killed.

Download PDF Manual

Table Of Contents

This Page

Percona Server Series