Buy Percona SupportBuy Now

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.

This documentation is developed in Launchpad as part of the Percona Server 5.6.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.


General Inquiries

For general inquiries, please send us your question and someone will contact you.