Note
This variable is introduced since OceanBase Database V2.2.77.
Description
ob_trx_lock_timeout specifies the lock wait timeout duration for transactions.
Attributes
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | -1, which indicates that the setting does not take effect. The unit is microsecond. |
| Value range | [0, +∞)
NoteThe value 0 indicates NO WAIT. |
| Applicable scope | |
| Involved in serialization | Yes |
| Modifiable | Yes. It can be modified using the SET statement. |
Examples
Session level
obclient> SET ob_trx_lock_timeout = 3000;Global level
obclient> SET GLOBAL ob_trx_lock_timeout = 3000;