Bug #31573 Several variables are incorrectly listed as session variables

• Submitted: 12 Oct 2007 18:27
• Modified: 23 Oct 2007 22:58
• Reporter: Mark Callaghan
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.0.37
• OS: Any
• Assigned to: Peter Lavin
• CPU Architecture: Any
• Tags: global, session, variable

[12 Oct 2007 18:27] Mark Callaghan

Description:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html describes whether variables are global or global/session.

Several dynamic variables are listed as global/session when they are only global. This includes: delay_key_write, delayed_insert_limit, connect_timeout, innodb_concurrency_tickets, character_set_system, concurrent_insert, connect_timeout, delayed_insert_limit, delayed_insert_timeout, innodb_autoextend_increment, innodb_commit_concurrency, innodb_thread_sleep_delay, innodb_max_dirty_pages_pct, innodb_max_purge_lag, key_buffer_size, log_queries_not_using_indexes, long_query_time, myisam_max_sort_file_size, slave_transaction_retries, sync_binlog, sync_frm, table_cache, table_lock_wait_timeout, thread_cache_size, thread_stack, 

Also, many are listed as global/session but not dynamic. How can a variable be global/session when it is static. If it cannot be changed, the global and session values are always the same.

How to repeat:
mysql> select @@session.delay_key_write;
ERROR 1238 (HY000): Variable 'delay_key_write' is a GLOBAL variable

mysql> select @@session.delayed_insert_limit;
ERROR 1238 (HY000): Variable 'delayed_insert_limit' is a GLOBAL variable

mysql> select @@session.connect_timeout;
ERROR 1238 (HY000): Variable 'connect_timeout' is a GLOBAL variable

Suggested fix:
Update the docs

[14 Oct 2007 3:37] MySQL Verification Team

Thank you for the bug report. Most probably this bug report is duplicate
I will verify that; in the meantime it stay as verified.

[23 Oct 2007 22:58] Peter Lavin

Scope of dynamic variables corrected. Also fixed status variables with incorrect scope.

Thanks for your bug report!