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








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:


connect_timeout = 10