optimizer_dynamic_sampling is used to control the level of dynamic sampling.
Note
This variable is available starting with V4.2.0.
Attribute |
Description |
|---|---|
| Parameter type | int |
| Default Value | 1 |
| Value range | [0,1] |
| Effective Scope |
|
| Read-only | No |
| Whether to participate in serialization | Yes |
| Whether restart is required for the change to take effect | No |
Example
set optimizer_dynamic_sampling = 0;
set global optimizer_dynamic_sampling = 1;