MySQL Bugs: #3761: my.cnf example files should be reworked

Bug #3761	my.cnf example files should be reworked
Submitted:	14 May 2004 13:41	Modified:	12 Jul 2005 15:59
Reporter:	Stefan Hinz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	Releases 4.0 and above	OS:	N/A
Assigned to:	Lenz Grimmer	CPU Architecture:	Any

Description:
1. The example my.cnf files we are shipping with our binaries include a syntax that the manual says is deprecated:
set-variable	= key_buffer=384M
set-variable	= max_allowed_packet=1M
set-variable	= table_cache=512
...
"set-variable =" should be removed.

2. The manual and the training materials recommend to always enable the slow query log. However, this is not done in any of our example my.cnf files. The following lines should be added:
# Enable slow query log
log-slow-queries

3. On Windows, files with the .cnf extension show up in a weird way (no extension, no matter whether "do not show extensions for known file types" is disabled or not). They are, by default, associated with NetMeeting, which may confuse users. For Windows binaries, we should therefore change the names to end with .ini, for example my-small.ini, my-medium.ini, and so forth.

How to repeat:
Have a look at the example files we are shipping.

Suggested fix:
See above.

"Release" should not be "all releases" -- at least,
not for all parts of the suggestions. The deprecated
syntax is not deprecated (and *must* be used)
for 3.23.xx releases.

Paul's right. --set-variable is needed for releases < 4.0.

Just as an update to this bug report: the "set-variable" statements have been removed from the
sample config files a while ago. Adding "log-slow-queries" still remains to be done, as well as
renaming the files from *.cnf to *.ini for the Windows packages.

Setting this to "feature request"