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
Triage: Needs Triage: D2 (Serious)

[2 Mar 2011 15:10] Daniël van Eeden
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.
[2 Mar 2011 16:34] Valeriy Kravchuk
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>
[20 Apr 2011 11:32] Daniël van Eeden
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.
[23 Nov 2012 9:40] Daniël van Eeden
Isn't this fixed in the 5.6 RC?

https://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default
[11 Mar 2013 13:34] Erlend Dahl
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