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.
In Percona Server 5.6.35-80.0 this feature has been re-implemented by
setting a connection socket read timeout value instead of periodically scanning
the internal InnoDB transaction list.
5.6.11-60.3:- Feature ported from Percona Server 5.5
5.6.35-80.0:- Feature re-implemented using socket timeouts
innodb_kill_idle_transaction¶| Version Info: |
|
|---|---|
| Scope: |
|
| Config: |
|
| Dynamic: |
|
| Variable Type: |
|
| Default Value: | 0 (disabled) |
| Units: | Seconds |
To enable this feature, set this variable to the desired seconds wait until the transaction is killed. NOTE: This variable has been deprecated and it will be removed in a future major release.
kill_idle_transaction¶| Version Info: |
|
|---|---|
| Scope: |
|
| Config: |
|
| Dynamic: |
|
| Variable Type: |
|
| Default Value: | 0 (disabled) |
| Units: | Seconds |
If non-zero, any idle transaction will be killed after being idle for this many seconds.
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.
