79461

Configuration Changes

• Beginning with MySQL 5.6.6, several MySQL Server parameters have defaults that differ from

previous releases. The motivation for these changes is to provide better out-of-box performance and

to reduce the need for the database administrator to change settings manually. These changes are

subject to possible revision in futurę releases as we gain feedback.

In some cases, a parameter has a different static default value. In other cases, the server

autosizes a parameter at startup using a formula based on other related parameters or server

host configuration, ratherthan using a static value. For example, the setting for back_log [480]

now is its previous default of 50, adjusted up by an amount proportional to the value of

max_connections [518]. The idea behind autosizing is that when the server has information

available to make a decision about a parameter setting likely to be better than a fixed default, it will.

The following table summarizes changes to defaults. Any of these can be overridden by specifying an explicit value at server startup.