MySQL Bugs: #12380: mysqld --verbose --help does not print all variables

Bug #12380	mysqld --verbose --help does not print all variables
Submitted:	4 Aug 2005 12:54	Modified:	9 Sep 2005 10:31
Reporter:	Lenz Grimmer	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	all	OS:	Any (all)
Assigned to:	Jim Winstead	CPU Architecture:	Any

Description:
The command "mysqld --help --verbose" also prints out some server variables. However, the list is not complete - many variables (especially the "have_*%" ones) are missing.

How to repeat:
Run "mysqld --help --verbose" and compare the variable listing with the output of "SHOW VARIABLES" or "mysqladmin variables"

Suggested fix:
My suggestion would be to remove the listing of the variables from the "--help" output completely, but rather print out a complete list (incl. the missing ones) when running "mysqld --print-variables"

mysqld --help --verbose only shows the default values of variables that can be set from the command line, it is not the same as 'SHOW VARIABLES'.

This is hardly possible.
--print-variables and --help --verbose show command line options, and the values they have.

SHOW VARIABLES shows server variables, some of them are just not possible to see without starting the server - they all rely on different subsystems of the server, so as the server starts up more and more variables became "defined". It could be possible that some variables are defined only when the server is (almost) fully operational.