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.
