Bug #20414 Some variables are not listed in show variables
Submitted: 13 Jun 2006 6:35 Modified: 3 Apr 2007 21:38
Reporter: Oli Sennhauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0.22 OS:Any (any)
Assigned to: Paul Dubois CPU Architecture:Any
Triage: D4 (Minor)

[13 Jun 2006 6:35] Oli Sennhauser
Description:
Some variables are not documented in Chap. "5.2.2. Server System Variables" or if tey do not exist it is not yet removed from mysqld --verbose --help.

How to repeat:
Compare mysqld --help --verbose with docu.

Suggested fix:
Eighter fix docu or output of mysqld --help --verbose

* abort_slave_event_count is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help

* automatic_sp_privileges is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help AND SHOW VARIABLES

* disconnect_slave_event_count is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help

* enable_pstack is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help

* gdb is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help. See skip_external_locking (inconsistency?).

* large_page_size is not documented in Chap. "5.2.2. Server System Variables"

* log_tc and log_tc_size is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* max_binlog_dump_events is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* max_sp_recursion_depth is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* multi_range_count and myisam_block_size is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* myisam_max_extra_sort_file_size is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* prepared_stmt_count is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* read_rnd_buffer_size is not in alphabetical order.

* record_buffer, report_host, report_password, report_port, report_user, rpl_recovery_rank, safe_user_create is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* show_slave_auth_info is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* sporadic_binlog_dump_fail, sql_notes, sql_warnings is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.

* tc_heuristic_recover, timed_mutexes is not documented in Chap. "5.2.2. Server System Variables" or if it does not exist it is not yet removed from mysqld --verbose --help.
[13 Jun 2006 7:22] Stefan Hinz
How does this bug report differ from bug #20416? It looks like a duplicate to me, but I might be missing something.
[14 Jun 2006 8:16] Oli Sennhauser
The title is wrong. I wanted to write: "Some variables and startup options are not documented or removed from mysqld".
[8 Nov 2006 20:39] john danilson
noticed also that show binlog events and show binlogs are not documented in 13.5.4 of the 5.1 documentation.
[3 Apr 2007 21:38] Paul Dubois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

The variables/options now all are listed here:

http://dev.mysql.com/doc/refman/5.0/en/mysqld-option-tables.html

With the following exceptions:

large_page_size does not exist; perhaps you meant large_pages?

record_buffer is not in the 5.0 manual because it was renamed in
4.0.3 to read_buffer_size.

Re: SHOW BINLOG EVENTS and SHOW BINARY LOGS,
13.5.4 of the 5.1 documentation mentions them and points
out that they're described at:

http://dev.mysql.com/doc/refman/5.1/en/replication-sql.html