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.
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.
For general inquiries, please send us your question and someone will contact you.
