Setting the Number of Parallel Operators in the Secondary Engine

If the usage of available CPU cores is not high and you require to improve the performance of parallel queries, you can adjust the number of parallel operators.

The parameters related to the number of parallel operators are as follows. For details, see Setting and Querying KOVAE Parameters and Querying Status Variables.

innodb_parallel_read_threads
kovae_threadpool_size
kovae_parallel_threads
kovae_threadpool_stalltime

Procedure

Set KOVAE parameters.

set variable Parameter_name=Parameter_value;
set global variable Parameter_name=Parameter_value;

Check the configured parameters.
```
show variables like "%Parameter_name%";
```

Parent topic: Feature Usage