Bug #63789 Update default config files reflecting that InnoDB is the default storage engine
Submitted: 18 Dec 2011 21:11 Modified: 29 Jun 2013 0:14
Reporter: Sierk Bornemann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.5.x, 5.6.x OS:Any
Assigned to: Matthew Lord CPU Architecture:Any
Tags: my.cnf
Triage: Needs Triage: D5 (Feature request)

[18 Dec 2011 21:11] Sierk Bornemann
Description:
Since MySQL's default storage engine no longer is MyISAM but InnoDB on MySQL 5.5.x and newer, this should also be reflected in the default config options stored in the config files my-small.cnf, my-medium.cnf, my-large.cnf, my-huge.cnf in the support-files directory.

How to repeat:
Install MySQL

Suggested fix:
The appropriate section in [mysqld] "# Uncomment the following if you are using InnoDB tables" should be unommented per default and should be preset with valid, non-deprecated options (non-deprecated means: for instance the error log says while starting the server: "InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.") and reasonable default values to these config options.
[19 Dec 2011 7:14] Valeriy Kravchuk
Thank you for the feature request. Work is in progress for 5.6 on this...
[29 Jun 2013 0:14] Matthew Lord
Hi Sierk,

Thank you for the feature request, and for helping to make MySQL even better!

I'm closing this feature request, as the defaults files and default values were totally revamped in MySQL 5.6, so it no longer applies.

Thanks again!