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:
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.
Release of antivirus database updates (required to protect your computer/server/mobile device)
Providing technical support over phone / web
Release of patches for the application (addressing detected bugs)
Kaspersky Security Center takes the complexity out of security administration and IT systems management.
Buy as a part of Kaspersky Endpoint Security for Business Advanced
Renew
To get the most out of Kaspersky solutions, try Professional Services or Premium Support plans.
Kaspersky Security Center 12 (version 12.2.0.4376)
Please let us know how we can make this website more comfortable for you
Thank you for submitting your feedback. We will review your feedback shortly.
Your feedback will be used for content improvement purposes only. If you need assistance, please contact technical support.
Your suggestions will help improve this article.