Note
This variable was introduced in OceanBase Database V2.2.77.
Description
ob_query_timeout specifies the maximum execution duration allowed for an SQL query.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 10000000, in microseconds |
| Value range | [0, 3216672000000000] |
| 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_query_timeout = 20000000;Set the variable at the global level
obclient> SET GLOBAL ob_query_timeout = 20000000;