Customize MySQL
Note
This procedure applies to the embedded MySQL database, not a distributed configuration.
To match the needs of your environment, you might need to change the default settings that Contrast specifies for the MySQL database. For example, after an upgrade, you might need to adjust the value for the innodb_buffer_pool_size
setting.'
To change the default MySQL settings, use the my_extra.cnf
options file. The Contrast installer includes this file as part of the on-premises installation.
Contrast loads its default options file first and then, applies custom settings that you specify in the my_extra.cnf
file.
Steps
Find the
$CONTRAST_HOME/data/conf/my_extra.cnf
file.Add or change MySQL settings, as needed.
Restart Contrast. or, if you're using Microsoft Windows, restart the MySQL service.