MySQL Bugs: #20416: Some variables and startup options are not documented or removed from mysqld

Bug #20416	Some variables and startup options are not documented or removed from mysqld
Submitted:	13 Jun 2006 6:40	Modified:	22 Jun 2006 7:15
Reporter:	Oli Sennhauser	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	5.0.22	OS:	Any (any)
Assigned to:	MC Brown	CPU Architecture:	Any

Description:
IMHO all startup options as well all variables should be listed in show variables. This makes it easier to monitor and maintain the DB.

* prepared_stmt_count is in wrong sort order!?! Why? (collation)?

* All variables not listed with show variables:
abort-slave-event-count
disconnect-slave-event-count
enable-pstack
gdb
innodb_safe_binlog
innodb_status_file
log-bin-index
log-bin-trust-routine-creators
log-queries-not-using-indexes
log-short-format
log-slow-admin-statements
log-tc
log-tc-size
log-update
master-connect-retry
master-host
master-info-file
master-password
master-port
master-retry-count
master-user
max-binlog-dump-events
memlock
myisam_block_size
myisam_max_extra_sort_file_size
myisam-recover
multi_read_range
named_pipe
ndb-cache-check-time
ndbcluster
ndb-connectstring
ndb_index_stat_cache_entries
ndb_index_stat_enable
ndb_index_stat_update_freq
ndb-mgmd-host
ndb-nodeid
ndb-optimized-node-selection
ndb_report_thresh_binlog_epoch_slip
ndb_report_thresh_binlog_mem_usage
ndb-shm
old-style-user-limits
one_shot
port-open-timeout
record_buffer
relay-log
relay-log-index
relay-log-info-file
replicate-same-server-id
report-host
report-password
report-port
report-user
safe-user-create
shared_memory
shared_memory_base_name
show-slave-auth-info
skip-grant-tables
skip-slave-start
sporadic-binlog-dump-fail
tc-heuristic-recover
thread_concurrency

How to repeat:
Compare show variables with doc and mysqld --help --verbose

Can you please indicate which parts of your bug report cover
- server behaviour (i.e. the SHOW VARIABLES statement),
- documentation (please provide URLs),
- server help/verbose output?
In autumn (2006) we plan to add a section/page that contains a table with all options and server variables, which should greatly improve the overview and also show at one glance what behaviour can be set at startup, and/or at runtime.

Sorry wrong title