Skip to main content

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

  1. Find the $CONTRAST_HOME/data/conf/my_extra.cnf file.

  2. Add or change icon-external-link.svg MySQL settings, as needed.

  3. Restart Contrast. or, if you're using Microsoft Windows, restart the MySQL service.