Note
This parameter was introduced in OceanBase Database V1.4.
Description
large_query_threshold specifies the threshold of the query execution time. A request may be suspended if its execution time exceeds this threshold. A suspended request is considered a large query and is processed by following the large query scheduling strategy.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 5s |
| Value range | [0ms, +∞)
NoteThe value range has been changed from [1ms, +∞) to [0ms, +∞) since OceanBase Database V4.3.0. |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No |
Example
obclient> ALTER SYSTEM SET large_query_threshold = '5s';