Setting Memory Control

When the number of parallel queries is large and the available memory is small, you can use the memory control function to prevent the database from breaking down due to out of memory (OOM).

The parameters related to memory control for parallel queries are as follows. For details, see Setting and Querying KOVAE Parameters and Querying Status Variables.

kovae_memory_control
kovae_memory_max_size
kovae_memory_save_num

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