If you are using a MySQL server for Kaspersky Administration Kit database, you should enable support of InnoDB and MEMORY storages.
MySQL start-up settings are stored in the my.ini configuration file (by default, %Program Files%\MySQL\MySQL Server 5.0\my.ini). You should create this file from the template file %Program Files%\MySQL\MySQL Server 5.0\my-innodb-heavy-4G.ini, and introduce the following changes:
Linux paths:
The my.ini file should be created immediately before installing Kaspersky Administration Kit. You should restart the MySQL service once the file has been created.
Recommended my.ini configuration:
binlog_cache_size = 10M
sort_buffer_size = 10M
join_buffer_size = 20M
thread_concurrency = 20
tmp_table_size = 100M
max_heap_table_size = 100M
key_buffer_size = 200M
innodb_buffer_pool_size – the set value should be equal to at least 80% of the expected KAV database size
innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 0 (the server mostly uses small transactions)
innodb_log_buffer_size = 50M (This value should be set before the KAV database has been created)
innodb_log_file_size = 500M (This value should be set before the KAV database has been created)
innodb_lock_wait_timeout = 300
The general amount of RAM consumed by MySQL server can be calculated as follows:
innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB
Kaspersky Administration Kit can establish up to 22 simultaneous connections with MySQL server. Meaning the max_connections value can reach 22, yet the common number of simultaneous connections does not go beyond 13.
