Note
This variable is available starting with V2.1.
Description
ob_trx_idle_timeout specifies the transaction idle timeout. If the execution interval between two statements in a transaction exceeds this value, the transaction will timeout.
Notice
After you enable distributed transaction routing, the configuration of the ob_trx_idle_timeout variable will no longer take effect.
Privilege requirements
Query variables
Global level
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) and theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of Global system variables.Session level
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) and theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the value of Session system variables.
Modify variables
Global level
The
systenant can directly modify the value of Global system variables.MySQL user tenants need to have the
SUPERorALTER SYSTEMprivilege to modify the value of Global system variables.Oracle user tenants need to have the
ALTER SYSTEMprivilege to modify the value of Global system variables.
Session level
The
systenant and all user tenants can directly modify the value of Session system variables in their own tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 86400000000 microseconds.
NoteThe default value of this variable was changed from 120000000 to 86400000000 starting with V4.0.0. |
| Value range | [100000000, +∞) |
| Scope |
|
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the transaction idle timeout to 86400000000 microseconds.
Session level
obclient> SET ob_trx_idle_timeout =86400000000;Global level
obclient> SET GLOBAL ob_trx_idle_timeout =86400000000;