Configuring the MySQL x64 server for working with Kaspersky Security Center 13.1

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:

1. Open the my.ini file in a text editor.
2. Enter the following lines into 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.