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 about our open source software and database management tools, please send us your question and someone will contact you.
