parallel_degree_limit specifies the upper limit of the degree of parallelism that the optimizer can select when the auto-DOP strategy is used.
Note
This variable is available starting with V4.2.0.
Attribute |
Description |
|---|---|
| Parameter type | uint |
| Default Value | 0
Note0 indicates that the degree of parallelism is not limited. |
| Value range | [ 0, 9223372036854775807 ] Unit: degree of parallelism |
| Effective Scope |
|
Example
set parallel_degree_limit =256;
set global parallel_degree_limit =256;