Replace and Revert Your MySQL Configuration

This section is applicable only to customers who are using a MySQL database and want to utilize the system memory of a host where their MySQL database is deployed to the fullest extent.

Replacing the MySQL Configuration

When you install or upgrade your RiskVision server, the installer will place the my.ini file in the %AGILIANCE_HOME%\install directory > MySQL folder. The Upgrade wizard also copies the my-4CPU-8GB.ini  and use_4CPU_8GB_mysql_ini.bat files into the %AGILIANCE_HOME%\install\mysql directory. The use_4CPU_8GB_mysql_ini.bat file is used only if the MySQL database is deployed on the host with at least 8 GB of system memory to optimize the response time of the MySQL database.

To change the MySQL configuration on a host with at least 8 GB of system memory:

1. Ensure your RiskVision Server has been upgraded to the latest version. To upgrade, see the steps in Upgrade Process Map For Single Tier RiskVision Setup, or Upgrade Process Map For N-tier RiskVision Setup
2. Go to the %AGILIANCE_HOME%\install\mysql directory in the system that hosts the MySQL database. 
3. Double-click the use_4CPU_8GB_mysql_ini.bat file to run the script. Allow sufficient time to run the script. After the script is complete, all the properties in the filemy.ini are replaced with the properties specified in the my-4CPU-8GB.ini file.
4. Restart the RiskVision Tomcat service to apply the latest changes.

With the modified configurationmy.ini file, RiskVision should load more quickly.