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

[9 Mar 2007 4:18] Arjen Lentz
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.
[9 Mar 2007 4:20] Arjen Lentz
Even sort_buffer_size is missing.
[9 Mar 2007 4:21] Arjen Lentz
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.
[9 Mar 2007 7:07] Valeriy Kravchuk
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.
[27 Mar 2007 22:55] Antony Curtis
fixed by WL#2936
[14 May 2007 5:33] Antony Curtis
fixed by wl2936 - mysql-5.1.18
[15 May 2007 3:00] Paul DuBois
Noted in 5.1.18 changelog.

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