Configurations for MySQL

For MySQL we recommend basing your configuration on the example configuration file my-large.cnf which is included in the MySQL distribution.

In addition the following changes should be made:

The max_allowed_packet should be increased to allow transferring large binary objects to an from the database. This is done by setting the option: max_allowed_packet = 64M

InnoDB must be available and configured for the MySQL instance to work properly as the CLC Database. You should enable the options in the InnoDB section of your configuration as suggested below:

# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

There appears to be a bug in certain versions of MySQL which can cause the cleanup of the query cache to take a very long time (some time many hours). If you experience this you should disable the query log by setting the following option: query_cache_size= 0