After upgrading the server many users start it with an unchanged config file only to find some deprecated options that they were using are no longer supported by the later server version, which causes the upgraded server to shutdown. In other cases modifying the server configuration file results in the server refusing to start when an invalid name is mistakenly entered in the configuration file.…
Category Archives: Configuration
Plan to improve the out of the Box Experience in MySQL 8.0
In MySQL 8.0, we will be introducing a new configuration parameter called innodb_dedicated_server=bool. When ON, this option will look at the system memory, and then automatically set the these configuration parameters using the following rules:
MySQL 8.0.2 More Flexible Undo Tablespace Management
In MySQL 8.0.2 DMR we will introduce features which make managing undo tablespaces easier in InnoDB.
The main improvement is that you can now create and drop undo tablespaces at any time. You can change the config file setting before any startup, whether recovery is needed or not. …
Planning the defaults for MySQL 5.8
Improved Server Defaults in 5.7
Morgan and I started an initiative a while back to improve the “out of the box” configuration and behavior defaults for MySQL. Working closely with the Community, we were able to come up with a good list of improvements. This work really began to bear fruit starting with the MySQL 5.7.7…