How to configure the MySQL server for Kaspersky Security Center 10 Service Pack 1 and Service Pack 2

 

Kaspersky Security Center 10

 
 
 

How to configure the MySQL server for Kaspersky Security Center 10 Service Pack 1 and Service Pack 2

Back to "Server Management"
Latest update: 2019 Oct 07 ID: 13180
 
 
 
 

This article concerns Kaspersky Security Center 10: 

  • Service Pack 2 (version 10.3.407.0)
  • Service Pack 1 (version 10.2.434)
 
 
 
 

If you use the MySQL server as a database server for Kaspersky Security Center, you must enable the support of InnoDB and MEMORY storages as well as the utf and ucs2 encodings.

The settings for running MySQL are stored in the my.ini configuration file (the default path is %Program Files%\MySQL\MySQL Server 5.0\my.ini). Create the my.ini file using the template: %Program Files%\MySQL\MySQL Server 5.0\my-innodb-heavy-4G.ini and then make the changes listed below.

Paths for Linux systems:
/usr/share/mysql/my-innodb-heavy-4G.cnf 
/etc/my.cnf 

The my.ini file must be created before the installation of Kaspersky Security Center.

When the file is created:

  1. Stop the MySQL service.
  2. Delete or move all the files named ib_logfile  to a separate folder (by default, these files are located in C:/Program Files/MySQL/MySQL Server 5.0/Data/).
  3. Run the MySQL service.
 
 
 
 
 

Recommended parameters for the my.ini file

 
 
 
 
 

The formula for calculating the RAM volume for the MySQL server

 
 
 
 
Was this information helpful?
Yes No
Thank you
 

 
 

How can we improve this article?

Your feedback will be used for content improvement purposes only. If you need assistance, please contact technical support.

Submit Submit

Thank you for your feedback!

Your suggestions will help improve this article.

OK