Note
The default value of this variable is changed from 120000000 to 86400000000 since OceanBase Database V4.0.0.
Description
ob_trx_idle_timeout specifies the idle timeout period of a transaction. A timeout occurs when the execution interval between two statements in a transaction exceeds the specified timeout period.
Attributes
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 86400000000. The unit is microsecond. |
| Value range | [100000000, +∞) |
| Applicable scope | |
| Involved in serialization | Yes |
| Modifiable | Yes. It can be modified using the SET statement. |
Examples
Session level
obclient> SET ob_trx_idle_timeout =86400000000;Global level
obclient> SET GLOBAL ob_trx_idle_timeout =86400000000;