Database Considerations

The default MySQL configuration for a new installation has changed, but if you are upgrading from an earlier release, installation does not modify your configuration unless you select rebuild database when you upgrade. The following are changes to the default configuration you can apply manually. On Windows these changes occur in C:\Windows\my.ini. On Linux or Solaris, they are in /etc/my.cnf.

max_allowed_packet = 32M

table_cache=1024

innodb_log_files_in_group=3

innodb_log_file_size=256M

innodb_buffer_pool_size=512M

innodb_additional_mem_pool_size=20M

innodb_lock_wait_timeout=30

Modification to log file settings requires removal of existing log file(s) before restarting MySQL.

Also recommended: If you are upgrading, increase server side connection timeout from 5 to 10 seconds to reliably create new connections. Newer versions of MySQL require a longer connection timeout. My.cnf/ini files created by earlier installations have no timeout setting and will default to 5 seconds. Here is the suggested change to my.ini or my.cnf:

[mysqld]

connect_timeout = 10