MySQL Bugs: #60306: my-innodb-heavy-4G.cnf contains obsolete options

Bug #60306	my-innodb-heavy-4G.cnf contains obsolete options
Submitted:	2 Mar 2011 15:10	Modified:	11 Mar 2013 13:34
Reporter:	Daniël van Eeden	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S2 (Serious)
Version:	5.1.55, 5.5.9	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The sample config file which is installed in /usr/share/doc/MySQL-server-5.5.9/my-innodb-heavy-4G.cnf has master-* options as example. Those options are obsolete and according to http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html this will make the server abort with an "unknown variable" error.

How to repeat:
$ grep master-.*= /usr/share/doc/MySQL-server-5.5.9/my-innodb-heavy-4G.cnf
#master-host = <hostname>
#master-user = <username>
#master-password = <password>
#master-port = <port>

Suggested fix:
Remove the obsolete and deprecated options from the sample config files.

Actually, these obsolete options are mentioned in many sample my.cnf files in current MySQL server versions:

macbook-pro:5.5 openxs$ grep -n master- /usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/*
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-huge.cnf:54:# defaults to 1 if master-host is not set
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-huge.cnf:81:#    if you mistyped the password in master-password and the slave fails to
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-huge.cnf:91:# defaults to 2 if master-host is set
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-huge.cnf:96:#master-host     =   <hostname>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-huge.cnf:100:#master-user     =   <username>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-huge.cnf:104:#master-password =   <password>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-huge.cnf:108:#master-port     =  <port>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-innodb-heavy-4G.cnf:242:# "master-host" is not set, but will MySQL will not function as a master
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-innodb-heavy-4G.cnf:269:#    if you mistyped the password in master-password and the slave fails to
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-innodb-heavy-4G.cnf:279:# defaults to 2 if master-host is set
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-innodb-heavy-4G.cnf:284:#master-host = <hostname>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-innodb-heavy-4G.cnf:288:#master-user = <username>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-innodb-heavy-4G.cnf:292:#master-password = <password>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-innodb-heavy-4G.cnf:296:#master-port = <port>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-large.cnf:57:# defaults to 1 if master-host is not set
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-large.cnf:84:#    if you mistyped the password in master-password and the slave fails to
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-large.cnf:94:# defaults to 2 if master-host is set
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-large.cnf:99:#master-host     =   <hostname>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-large.cnf:103:#master-user     =   <username>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-large.cnf:107:#master-password =   <password>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-large.cnf:111:#master-port     =  <port>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-medium.cnf:55:# defaults to 1 if master-host is not set
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-medium.cnf:82:#    if you mistyped the password in master-password and the slave fails to
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-medium.cnf:92:# defaults to 2 if master-host is set
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-medium.cnf:97:#master-host     =   <hostname>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-medium.cnf:101:#master-user     =   <username>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-medium.cnf:105:#master-password =   <password>
/usr/local/mysql-5.5.9-osx10.5-x86_64/support-files/my-medium.cnf:109:#master-port     =  <port>

I believe that there should be an example config for advanced/enterprise use which will enable performance_schema as this will allow merlin to do more/better monitoring.

Isn't this fixed in the 5.6 RC?

https://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default

Correct, these files are no longer part of the distribution as of 5.6.8:

http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-8.html