Recommended configuration for the MariaDB server x64 for correct functioning of Kaspersky Security Center 12
Kaspersky Security Center 12 supports MariaDB version 10.3.22 and later.
If you use the MariaDB server for Kaspersky Security Center, enable support for:
- InnoDB and MEMORY storages
- Utf-8 и ucs2 encodings
Recommended settings for the my.ini file (my.cnf for *nix systems)
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'
Formula for calculating the RAM volume for the MariaDB server
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.
