Bug #63187 | mysqld --help --verbose should not try to startup but only provide help | ||
---|---|---|---|
Submitted: | 10 Nov 2011 15:36 | Modified: | 16 Oct 2012 5:13 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Options | Severity: | S3 (Non-critical) |
Version: | 5.5.16, 5.5.19 | OS: | Any (Linux, Mac OS X) |
Assigned to: | CPU Architecture: | Any | |
Tags: | windmill |
[10 Nov 2011 15:36]
Simon Mudd
[10 Nov 2011 16:10]
Valeriy Kravchuk
Thank you for the problem report. Verified just as described with current 5.5.19 on Fedora Core 14. I do not see this problem on Windows though.
[15 Nov 2011 10:05]
Hartmut Holzgraefe
See also bugs #30970, #30261, #31106
[15 Nov 2011 18:37]
Simon Mudd
Note: one thing that is mentioned in http://bugs.mysql.com/bug.php?id=30970 says: "--help output often contains information on current default settings so reading the option file is required in these cases. An error message should only be printed when reaching this part of the help output though *after* printing the usage information." I disagree. I think there's a very valid reason for mysqld to be able to provide the DEFAULT settings (hard-coded settings built-in to the mysqld binary) _without_ reading _any_ configuration files and provide that information to the DBA. There may be a similar requirement to show the settings that would be applied _after_ reading any configuration files but that should be a separate requirement. Either way mysqld --help --verbose should _not_ attempt to write to any files.
[5 Dec 2011 17:39]
Simon Mudd
Also see: http://blog.wl0.org/2011/11/managing-mysqls-configuration/ this current behaviour is really irritating as I'm trying to use this "only" mechanism of getting default information out of the binaries so I can check how my servers configuration varies to the default settings is troublesome to put it mildly.
[16 Oct 2012 5:13]
Erlend Dahl
MySQL --help will print information about variables in various dynamically loadable plugins. So it will always need to attempt loading those plugins before printing out the help information.