Bug #61018 Update config option template files to reflect default usage of InnoDB
Submitted: 1 May 2011 13:11 Modified: 25 Jun 2013 1:35
Reporter: Sierk Bornemann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version:5.5 and higher OS:Any
Assigned to: CPU Architecture:Any
Tags: config
Triage: Needs Triage: D5 (Feature request)

[1 May 2011 13:11] Sierk Bornemann
Description:
Since InnoDB now is the default storage engine of MySQL, this should also be reflected in MySQLs default config option template files (my-huge.cnf, my-large.cnf, my-medium.cnf, my-small.cnf) in the support-files directory of a MySQL installation.

So, the section of

# The MySQL server
[mysqld]
[..]
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir =
#innodb_data_file_path =
#innodb_log_group_home_dir =
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size =
#innodb_additional_mem_pool_size =
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size =
#innodb_log_buffer_size =
#innodb_flush_log_at_trx_commit =
#innodb_lock_wait_timeout =
[..]

should now really be uncommented per default and shouldn't need action by the user or admin. Or, if not needed, to be deleted.

How to repeat:
Install MySQL from mysql.com.

Suggested fix:
Uncomment the config optione in this section per default:

# The MySQL server
[mysqld]
[..]
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir =
innodb_data_file_path =
innodb_log_group_home_dir =
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size =
innodb_additional_mem_pool_size =
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size =
innodb_log_buffer_size =
innodb_flush_log_at_trx_commit =
innodb_lock_wait_timeout =
[..]

Or delete the whole section, if not needed per default.
Or, if it is a possible suggestion which differs from the compiled/imprinted values of MySQL, adjust the comment prose in these config option files.

Additionally, these config file templates maybe could be tidied up concerning other config options, if reasonable.
[1 May 2011 13:14] Valeriy Kravchuk
Thank you for the feature request.
[25 Jun 2013 1:35] Matthew Lord
Hi Sierk,

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

I'm closing this feature request for now, as the defaults (values and sample files) have been totally revamped in 5.6.

If you feel that I'm mistaken on anything here, please let me know.

Thanks again!