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: The feature was ported from Percona Server for MySQL 5.7.
|Default value||0 (disabled)|
If non-zero, any idle transaction will be killed after being idle for this many seconds.