MySQL Bugs: #26987: innodb_* and possibly other server vars missing from mysqld --help --verbose

Bug #26987	innodb_* and possibly other server vars missing from mysqld --help --verbose
Submitted:	9 Mar 2007 4:18	Modified:	15 May 2007 3:00
Reporter:	Arjen Lentz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.1.17-BK, 5.1.16	OS:	Any (any)
Assigned to:	Antony Curtis	CPU Architecture:	Any

Description:
Quite a few variables are missing from the list at the bottom of mysqld --help --verbose. innodb_buffer_pool_size is not there, for instance.

Please note it's the variable default settings overview at the end of the output I'm referring to, not the overview of the cmdline options

How to repeat:
 mysqld --help --verbose

compare with
 SHOW GLOBAL VARIABLES

innodb_buffer_pool_size is missing from the former, for instance.
Rather important/relevant.

Suggested fix:
Add missing vars in output.

Even sort_buffer_size is missing.

Only just noticed, the output is inconsistent as well.
Some variables have _ some have - (underscores vs. dashes).

I know both will work, but for this kind of output the information should at least be consistent.

Thank you for a problem report. Sorry, but I can not repeat some of the results described with latest 5.1.17-BK on Linux:

openxs@suse:~/dbs/5.1> libexec/mysqld --help --verbose | grep size
--binlog-row-event-max-size=#
The maximum size of a row-based binary log event in
size if possible. The value has to be a multiple of 256.
Path to individual files and their sizes.
--log-tc-size=# Size of transaction coordinator log.
--binlog_cache_size=#
The size of the cache to hold the SQL statements for the
--bulk_insert_buffer_size=#
--delayed_queue_size=#
What size queue (in rows) should be allocated for
--innodb_additional_mem_pool_size=#
--innodb_buffer_pool_size=#
The size of the memory buffer InnoDB uses to cache data
--innodb_log_buffer_size=#
The size of the buffer which InnoDB uses to write log to
--innodb_log_file_size=#
--join_buffer_size=#
The size of the buffer that is used for full joins.
--key_buffer_size=# The size of the buffer used for index blocks for MyISAM
--key_cache_block_size=#
The default size of key cache blocks
--max_binlog_cache_size=#
Can be used to restrict the total size used to cache a
--max_binlog_size=# Binary log will be rotated automatically when the size
max_relay_log_size is 0. The minimum value for this
--max_heap_table_size=#
--max_join_size=# Joins that are probably going to read more than
max_join_size records return an error.
--max_relay_log_size=#
the size exceeds this value; if zero (the default): when
the size exceeds max_binlog_size. 0 excepted, the minimum
--myisam_block_size=#
Block size to be used for MyISAM index pages.
--myisam_data_pointer_size=#
Default pointer size to be used for MyISAM tables.
--myisam_max_extra_sort_file_size=#
--myisam_max_sort_file_size=#
--myisam_sort_buffer_size=#
--preload_buffer_size=#
The size of the buffer that is allocated when preloading
--query_alloc_block_size=#
Allocation block size for query parsing and execution
minimal size of unit in wich space for results is
--query_cache_size=#
--query_prealloc_size=#
--range_alloc_block_size=#
Allocation block size for storing ranges during
--read_buffer_size=#
buffer of this size for each table it scans. If you do
--read_rnd_buffer_size=#
--record_buffer=# Alias for read_buffer_size
--sort_buffer_size=#
this size.
--thread_cache_size=#
--thread_stack=# The stack size for each thread.
--tmp_table_size=# If an in-memory temporary table exceeds this size, MySQL
--transaction_alloc_block_size=#
Allocation block size for transactions to be stored in
--transaction_prealloc_size=#

innodb_* and sort_buffer_size are there. The only thing I see is inconsistency in "_" vs. "-". See --binlog-row-event-max-size=# vs. --binlog_cache_size=#, for example.

fixed by WL#2936

fixed by wl2936 - mysql-5.1.18

Noted in 5.1.18 changelog.

Some InnoDB variables were missing from the output of
mysqld--verbose --help.