Add the following lines to the database configuration file:

sort_buffer_size=10M
join_buffer_size=100M
join_buffer_space_limit=300M
join_cache_level=8
tmp_table_size=512M
max_heap_table_size=512M
key_buffer_size=200M
innodb_buffer_pool_size=the real value must be no less than 80% of the expected KAV database size
innodb_thread_concurrency=20
innodb_flush_log_at_trx_commit=0 (in most cases, the server uses small transactions)
innodb_lock_wait_timeout=300
max_allowed_packet=32M
max_connections=151
max_prepared_stmt_count=12800
table_open_cache=60000
table_open_cache_instances=4
table_definition_cache=60000

Make sure join_cache_incremental, join_cache_hashed, join_cache_bka are enabled: in the MariaDB console, execute the SELECT @@optimizer_switch command and check if the following lines are present:

join_cache_incremental=on
join_cache_hashed=on
join_cache_bka=on

If they are missing or have the off value, add the following lines into the my.ini file:

optimizer_switch='join_cache_incremental=on'
optimizer_switch='join_cache_hashed=on'
optimizer_switch='join_cache_bka=on'

Use the formula below to calculate the overall volume of RAM used by the MariaDB server:

innodb_buffer_pool_size + key_buffer_size + max_connections * (sort_buffer_size + read_buffer_size + binlog_cache_size) + max_connections*2MB

You may set the value of binlog_cache_size at your own discretion. We recommend leaving the default settings in place.