Configuring MySQL
We recommend basing your MySQL configuration on the example configuration file my-large.cnf
included in the MySQL distribution.
In addition the following changes should be made:
- Increase the value of the
max_allowed_packet
setting to support transfer of large binary objects to and from the database will be supported. We recommend this setting:max_allowed_packet = 64M
- Ensure InnoDB is available and configured. This is necessary for the MySQL instance to work properly with the CLC Server.
- Enable the options in the InnoDB section of the configuration as outlined 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
Additionally, there appears to be a bug in certain versions of MySQL that can cause the cleanup of the query cache to take a very long time. If you experience this, please disable the query log by setting the query_cache_size
option to 0:
query_cache_size= 0