Kill Idle Transactions

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

Version Specific Information

  • 8.0.12-1:
    Feature ported from Percona Server for MySQL 5.7

System Variables

variable kill_idle_transaction
Scope:GLOBAL
Config:YES
Dynamic:YES
Variable Type:INTEGER
Default Value:0 (disabled)
Units:Seconds

If non-zero, any idle transaction will be killed after being idle for this many seconds.

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.