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

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.