Note
In OceanBase Database V4.x, the corresponding feature is no longer available. This parameter has been deprecated since OceanBase Database V4.2.0.
Description
max_px_worker_count specifies the maximum number of threads for the SQL parallel query engine.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 64 |
| Value range | [0, 65535] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Set the maximum number of threads for the SQL parallel query engine to 64.
obclient> ALTER SYSTEM SET max_px_worker_count=64;