If you use the MySQL server for Kaspersky Security Center, enable support of InnoDB and MEMORY storage and of UTF-8 and UCS-2 encodings.
Recommended settings for the my.ini file
To configure the my.ini file:
sort_buffer_size = 10M
join_buffer_size = 20M
tmp_table_size = 200M
max_heap_table_size = 200M
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
The value of the innodb_buffer_pool_size
must be no less than 80 percent of the expected KAV database size.
It is recommended to use the parameter value innodb_flush_log_at_trx_commit = 0
, because the values "1" or "2" negatively affect the operating speed of MySQL.