MySQL Bugs: #20414: Some variables are not listed in show variables

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

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.

How does this bug report differ from bug #20416? It looks like a duplicate to me, but I might be missing something.

The title is wrong. I wanted to write: "Some variables and startup options are not documented or removed from mysqld".

noticed also that show binlog events and show binlogs are not documented in 13.5.4 of the 5.1 documentation.

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