Note
This variable was introduced in OceanBase Database V2.2.77.
Description
ob_trx_lock_timeout specifies the lock wait timeout period for transactions.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | -1, in microseconds. The value indicates that the setting does not take effect. |
| Value range | [0, +∞)
NoteThe value |
| Effective scope | |
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Examples
Set the variable at the session level
obclient> SET ob_trx_lock_timeout = 3000;Set the variable at the global level
obclient> SET GLOBAL ob_trx_lock_timeout = 3000;