Bug #19103 --defaults-group-suffix not documented
Submitted: 14 Apr 2006 13:04 Modified: 9 Oct 2007 18:03
Reporter: Sergei Golubchik Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[14 Apr 2006 13:04] Sergei Golubchik
Description:
Neither manual, not command-line help describe --defaults-group-suffix option.
It belongs to "defaults" family of options, such as --no-defaults, --defaults-extra-file, and so on, and as such must be the first in the command line.

See below what it does

How to repeat:
% mysql --help | grep group
The following groups are read: mysql client
% mysql --defaults-group-suffix=_A --help | grep group
The following groups are read: mysql client mysql_A client_A
[29 Jun 2007 11:43] Alexander Keremidarski
There is nasty side effect of that option behaviour which renders it unusable in production environment. 

It must be either documented or considered separate bug to be fixed.

Since --defaults-group-suffix must be first in order to be accepted that makes it unusable with mysqld_safe script.

mysqld_safe script doesn't parse that option and passes it to mysqld. However it goes after other options so mysqld can't recognize it.

This raises the question about existence of such option. It can be only used if mysqld is started manually which is NOT recommended for production usage.
[9 Oct 2007 18:03] Sergei Golubchik
this bug (--defaults-group-suffix not documented) is fixed. if the implementation of the option is buggy, it must be in a separate bug report.
[13 Nov 2012 10:17] dAniel hAhler
"--defaults-group-suffix" is not documented with "mysql Ver 14.14 Distrib 5.5.28".

Neither with the output of "--help" nor the man page.