Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 27.1Mb
PDF (A4) - 27.2Mb
PDF (RPM) - 25.7Mb
HTML Download (TGZ) - 6.5Mb
HTML Download (Zip) - 6.6Mb
HTML Download (RPM) - 5.6Mb
Man Pages (TGZ) - 158.5Kb
Man Pages (Zip) - 262.1Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

MySQL 5.5 Reference Manual  /  ...  /  Server System Variable Reference

5.1.4 Server System Variable Reference

The following table lists all system variables applicable within mysqld.

The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding option. The scope of the variable (Var Scope) is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the variables. Where appropriate, direct links to further information about the items are provided.

Table 5.2 System Variable Summary

Name Cmd-Line Option File System Var Var Scope Dynamic
audit_log_buffer_size Yes Yes Yes Global No
audit_log_file Yes Yes Yes Global No
audit_log_flush Yes Global Yes
audit_log_format Yes Yes Yes Global No
audit_log_policy Yes Yes Yes Global Yes
audit_log_rotate_on_size Yes Yes Yes Global Yes
audit_log_strategy Yes Yes Yes Global No
authentication_windows_log_level Yes Yes Yes Global No
authentication_windows_use_principal_name Yes Yes Yes Global No
auto_increment_increment Yes Both Yes
auto_increment_offset Yes Both Yes
autocommit Yes Yes Yes Varies Yes
automatic_sp_privileges Yes Global Yes
back_log Yes Global No
basedir Yes Yes Yes Global No
big-tables Yes Yes Yes
- Variable: big_tables Yes Varies Yes
binlog_cache_size Yes Yes Yes Global Yes
binlog_direct_non_transactional_updates Yes Yes Yes Both Yes
binlog-format Yes Yes Yes
- Variable: binlog_format Yes Both Yes
binlog_stmt_cache_size Yes Yes Yes Global Yes
bulk_insert_buffer_size Yes Yes Yes Both Yes
character_set_client Yes Both Yes
character_set_connection Yes Both Yes
character_set_database (note 1) Yes Both Yes
character-set-filesystem Yes Yes Yes
- Variable: character_set_filesystem Yes Both Yes
character_set_results Yes Both Yes
character-set-server Yes Yes Yes
- Variable: character_set_server Yes Both Yes
character_set_system Yes Global No
character-sets-dir Yes Yes No
- Variable: character_sets_dir Yes Global No
collation_connection Yes Both Yes
collation_database (note 1) Yes Both Yes
collation-server Yes Yes Yes
- Variable: collation_server Yes Both Yes
completion_type Yes Yes Yes Both Yes
concurrent_insert Yes Yes Yes Global Yes
connect_timeout Yes Yes Yes Global Yes
datadir Yes Yes Yes Global No
date_format Yes Varies No
datetime_format Yes Varies No
debug Yes Yes Yes Both Yes
debug_sync Yes Varies Yes
default-storage-engine Yes Yes Yes
- Variable: default_storage_engine Yes Both Yes
default_week_format Yes Yes Yes Both Yes
delay-key-write Yes Yes Yes
- Variable: delay_key_write Yes Global Yes
delayed_insert_limit Yes Yes Yes Global Yes
delayed_insert_timeout Yes Yes Yes Global Yes
delayed_queue_size Yes Yes Yes Global Yes
div_precision_increment Yes Yes Yes Both Yes
engine-condition-pushdown Yes Yes Yes
- Variable: engine_condition_pushdown Yes Both Yes
error_count Yes Session No
event-scheduler Yes Yes Yes
- Variable: event_scheduler Yes Global Yes
expire_logs_days Yes Yes Yes Global Yes
external_user Yes Session No
flush Yes Yes Yes Global Yes
flush_time Yes Yes Yes Global Yes
foreign_key_checks Yes Varies Yes
ft_boolean_syntax Yes Yes Yes Global Yes
ft_max_word_len Yes Yes Yes Global No
ft_min_word_len Yes Yes Yes Global No
ft_query_expansion_limit Yes Yes Yes Global No
ft_stopword_file Yes Yes Yes Global No
general-log Yes Yes Yes
- Variable: general_log Yes Global Yes
general_log_file Yes Yes Yes Global Yes
group_concat_max_len Yes Yes Yes Both Yes
have_compress Yes Global No
have_crypt Yes Global No
have_csv Yes Global No
have_dynamic_loading Yes Global No
have_geometry Yes Global No
have_innodb Yes Global No
have_ndbcluster Yes Global No
have_openssl Yes Global No
have_partitioning Yes Global No
have_profiling Yes Global No
have_query_cache Yes Global No
have_rtree_keys Yes Global No
have_ssl Yes Global No
have_symlink Yes Global No
hostname Yes Global No
identity Yes Session Yes
ignore-builtin-innodb Yes Yes No
- Variable: ignore_builtin_innodb Yes Global No
init_connect Yes Yes Yes Global Yes
init-file Yes Yes No
- Variable: init_file Yes Global No
init_slave Yes Yes Yes Global Yes
innodb_adaptive_flushing Yes Yes Yes Global Yes
innodb_adaptive_hash_index Yes Yes Yes Global Yes
innodb_additional_mem_pool_size Yes Yes Yes Global No
innodb_autoextend_increment Yes Yes Yes Global Yes
innodb_autoinc_lock_mode Yes Yes Yes Global No
innodb_buffer_pool_instances Yes Yes Yes Global No
innodb_buffer_pool_size Yes Yes Yes Global No
innodb_change_buffering Yes Yes Yes Global Yes
innodb_change_buffering_debug Yes Yes Yes Global Yes
innodb_checksums Yes Yes Yes Global No
innodb_commit_concurrency Yes Yes Yes Global Yes
innodb_concurrency_tickets Yes Yes Yes Global Yes
innodb_data_file_path Yes Yes Yes Global No
innodb_data_home_dir Yes Yes Yes Global No
innodb_doublewrite Yes Yes Yes Global No
innodb_fast_shutdown Yes Yes Yes Global Yes
innodb_file_format Yes Yes Yes Global Yes
innodb_file_format_check Yes Yes Yes Global Varies
innodb_file_format_max Yes Yes Yes Global Yes
innodb_file_per_table Yes Yes Yes Global Yes
innodb_flush_log_at_trx_commit Yes Yes Yes Global Yes
innodb_flush_method Yes Yes Yes Global No
innodb_force_load_corrupted Yes Yes Yes Global No
innodb_force_recovery Yes Yes Yes Global No
innodb_io_capacity Yes Yes Yes Global Yes
innodb_large_prefix Yes Yes Yes Global Yes
innodb_limit_optimistic_insert_debug Yes Yes Yes Global Yes
innodb_lock_wait_timeout Yes Yes Yes Both Yes
innodb_locks_unsafe_for_binlog Yes Yes Yes Global No
innodb_log_buffer_size Yes Yes Yes Global No
innodb_log_file_size Yes Yes Yes Global No
innodb_log_files_in_group Yes Yes Yes Global No
innodb_log_group_home_dir Yes Yes Yes Global No
innodb_max_dirty_pages_pct Yes Yes Yes Global Yes
innodb_max_purge_lag Yes Yes Yes Global Yes
innodb_mirrored_log_groups Yes Yes Yes Global No
innodb_old_blocks_pct Yes Yes Yes Global Yes
innodb_old_blocks_time Yes Yes Yes Global Yes
innodb_open_files Yes Yes Yes Global No
innodb_print_all_deadlocks Yes Yes Yes Global Yes
innodb_purge_batch_size Yes Yes Yes Global Yes
innodb_purge_threads Yes Yes Yes Global No
innodb_random_read_ahead Yes Yes Yes Global Yes
innodb_read_ahead_threshold Yes Yes Yes Global Yes
innodb_read_io_threads Yes Yes Yes Global No
innodb_replication_delay Yes Yes Yes Global Yes
innodb_rollback_on_timeout Yes Yes Yes Global No
innodb_rollback_segments Yes Yes Yes Global Yes
innodb_spin_wait_delay Yes Yes Yes Global Yes
innodb_stats_method Yes Yes Yes Global Yes
innodb_stats_on_metadata Yes Yes Yes Global Yes
innodb_stats_sample_pages Yes Yes Yes Global Yes
innodb_strict_mode Yes Yes Yes Both Yes
innodb_support_xa Yes Yes Yes Both Yes
innodb_sync_spin_loops Yes Yes Yes Global Yes
innodb_table_locks Yes Yes Yes Both Yes
innodb_thread_concurrency Yes Yes Yes Global Yes
innodb_thread_sleep_delay Yes Yes Yes Global Yes
innodb_trx_purge_view_update_only_debug Yes Yes Yes Global Yes
innodb_trx_rseg_n_slots_debug Yes Yes Yes Global Yes
innodb_use_native_aio Yes Yes Yes Global No
innodb_use_sys_malloc Yes Yes Yes Global No
innodb_version Yes Global No
innodb_write_io_threads Yes Yes Yes Global No
insert_id Yes Session Yes
interactive_timeout Yes Yes Yes Both Yes
join_buffer_size Yes Yes Yes Both Yes
keep_files_on_create Yes Yes Yes Both Yes
key_buffer_size Yes Yes Yes Global Yes
key_cache_age_threshold Yes Yes Yes Global Yes
key_cache_block_size Yes Yes Yes Global Yes
key_cache_division_limit Yes Yes Yes Global Yes
language Yes Yes Yes Global No
large_files_support Yes Global No
large_page_size Yes Global No
large-pages Yes Yes No
- Variable: large_pages Yes Global No
last_insert_id Yes Session Yes
lc-messages Yes Yes Yes
- Variable: lc_messages Yes Both Yes
lc-messages-dir Yes Yes No
- Variable: lc_messages_dir Yes Global No
lc_time_names Yes Both Yes
license Yes Global No
local_infile Yes Global Yes
lock_wait_timeout Yes Yes Yes Both Yes
locked_in_memory Yes Global No
log Yes Yes Yes Global Yes
log-bin Yes Yes Yes Global No
log_bin Yes Global No
log-bin-trust-function-creators Yes Yes Yes
- Variable: log_bin_trust_function_creators Yes Global Yes
log-bin-trust-routine-creators Yes Yes Yes
- Variable: log_bin_trust_routine_creators Yes Global Yes
log-bin-use-v1-row-events Yes Yes No
- Variable: log_bin_use_v1_row_events Yes Global No
log_bin_use_v1_row_events Yes Yes Yes Global No
log-error Yes Yes No
- Variable: log_error Yes Global No
log_output Yes Yes Yes Global Yes
log-queries-not-using-indexes Yes Yes Yes
- Variable: log_queries_not_using_indexes Yes Global Yes
log-slave-updates Yes Yes No
- Variable: log_slave_updates Yes Global No
log_slave_updates Yes Yes Yes Global No
log-slow-queries Yes Yes Yes
- Variable: log_slow_queries Yes Global Yes
log-warnings Yes Yes Yes
- Variable: log_warnings Yes Both Yes
long_query_time Yes Yes Yes Both Yes
low-priority-updates Yes Yes Yes
- Variable: low_priority_updates Yes Both Yes
lower_case_file_system Yes Global No
lower_case_table_names Yes Yes Yes Global No
max_allowed_packet Yes Yes Yes Both Yes
max_binlog_cache_size Yes Yes Yes Global Yes
max_binlog_size Yes Yes Yes Global Yes
max_binlog_stmt_cache_size Yes Yes Yes Global Yes
max_connect_errors Yes Yes Yes Global Yes
max_connections Yes Yes Yes Global Yes
max_delayed_threads Yes Yes Yes Both Yes
max_error_count Yes Yes Yes Both Yes
max_heap_table_size Yes Yes Yes Both Yes
max_insert_delayed_threads Yes Both Yes
max_join_size Yes Yes Yes Both Yes
max_length_for_sort_data Yes Yes Yes Both Yes
max_long_data_size Yes Yes Yes Global No
max_prepared_stmt_count Yes Yes Yes Global Yes
max_relay_log_size Yes Yes Yes Global Yes
max_seeks_for_key Yes Yes Yes Both Yes
max_sort_length Yes Yes Yes Both Yes
max_sp_recursion_depth Yes Yes Yes Both Yes
max_tmp_tables Yes Both Yes
max_user_connections Yes Yes Yes Both Yes
max_write_lock_count Yes Yes Yes Global Yes
metadata_locks_cache_size Yes Global No
min-examined-row-limit Yes Yes Yes Both Yes
multi_range_count Yes Yes Yes Both Yes
myisam_data_pointer_size Yes Yes Yes Global Yes
myisam_max_sort_file_size Yes Yes Yes Global Yes
myisam_mmap_size Yes Yes Yes Global No
myisam_recover_options Yes Global No
myisam_repair_threads Yes Yes Yes Both Yes
myisam_sort_buffer_size Yes Yes Yes Both Yes
myisam_stats_method Yes Yes Yes Both Yes
myisam_use_mmap Yes Yes Yes Global Yes
named_pipe Yes Global No
ndb_autoincrement_prefetch_sz Yes Yes Yes Both Yes
ndb-batch-size Yes Yes Yes Global No
ndb-blob-read-batch-bytes Yes Yes Yes Both Yes
ndb-blob-write-batch-bytes Yes Yes Yes Both Yes
ndb_cache_check_time Yes Yes Yes Global Yes
ndb-cluster-connection-pool Yes Yes Yes Global No
ndb-deferred-constraints Yes Yes Yes
- Variable: ndb_deferred_constraints Yes Both Yes
ndb_deferred_constraints Yes Yes Yes Both Yes
ndb-distribution Yes Yes Yes
- Variable: ndb_distribution Yes Global Yes
ndb_distribution Yes Yes Yes Global Yes
ndb_eventbuffer_max_alloc Yes Yes Yes Global Yes
ndb_extra_logging Yes Yes Yes Global Yes
ndb_force_send Yes Yes Yes Both Yes
ndb_index_stat_cache_entries Yes Yes Yes Both Yes
ndb_index_stat_enable Yes Yes Yes Both Yes
ndb_index_stat_option Yes Yes Yes Both Yes
ndb_index_stat_update_freq Yes Yes Yes Both Yes
ndb_join_pushdown Yes Both Yes
ndb-log-apply-status Yes Yes No
- Variable: ndb_log_apply_status Yes Global No
ndb_log_apply_status Yes Yes Yes Global No
ndb_log_bin Yes Yes Both Yes
ndb_log_binlog_index Yes Yes Global Yes
ndb-log-empty-epochs Yes Yes Yes Global Yes
ndb_log_empty_epochs Yes Yes Yes Global Yes
ndb-log-empty-update Yes Yes Yes Global Yes
ndb_log_empty_update Yes Yes Yes Global Yes
ndb-log-orig Yes Yes No
- Variable: ndb_log_orig Yes Global No
ndb_log_orig Yes Yes Yes Global No
ndb-log-transaction-id Yes Yes No
- Variable: ndb_log_transaction_id Yes Global No
ndb_log_transaction_id Yes Global No
ndb-log-update-as-write Yes Yes Yes Global Yes
ndb_log_updated_only Yes Yes Yes Global Yes
ndb_optimization_delay Yes Global Yes
ndb_optimized_node_selection Yes Yes Yes Global No
ndb_report_thresh_binlog_epoch_slip Yes Yes Yes Global Yes
ndb_report_thresh_binlog_mem_usage Yes Yes Yes Global Yes
ndb_table_no_logging Yes Session Yes
ndb_table_temporary Yes Session Yes
ndb_use_copying_alter_table Yes Both No
ndb_use_exact_count Yes Both Yes
ndb_use_transactions Yes Yes Yes Both Yes
ndb_version Yes Global No
ndb_version_string Yes Global No
ndb-wait-connected Yes Yes Yes Global No
ndb-wait-setup Yes Yes Yes Global No
ndbinfo_database Yes Global No
ndbinfo_max_bytes Yes Yes Both Yes
ndbinfo_max_rows Yes Yes Both Yes
ndbinfo_offline Yes Global Yes
ndbinfo_show_hidden Yes Yes Both Yes
ndbinfo_table_prefix Yes Yes Both Yes
ndbinfo_version Yes Global No
net_buffer_length Yes Yes Yes Both Yes
net_read_timeout Yes Yes Yes Both Yes
net_retry_count Yes Yes Yes Both Yes
net_write_timeout Yes Yes Yes Both Yes
new Yes Yes Yes Both Yes
old Yes Yes Yes Global No
old-alter-table Yes Yes Yes
- Variable: old_alter_table Yes Both Yes
old_passwords Yes Both Yes
open-files-limit Yes Yes No
- Variable: open_files_limit Yes Global No
optimizer_prune_level Yes Yes Yes Both Yes
optimizer_search_depth Yes Yes Yes Both Yes
optimizer_switch Yes Yes Yes Both Yes
performance_schema Yes Yes Yes Global No
performance_schema_events_waits_history_long_size Yes Yes Yes Global No
performance_schema_events_waits_history_size Yes Yes Yes Global No
performance_schema_max_cond_classes Yes Yes Yes Global No
performance_schema_max_cond_instances Yes Yes Yes Global No
performance_schema_max_file_classes Yes Yes Yes Global No
performance_schema_max_file_handles Yes Yes Yes Global No
performance_schema_max_file_instances Yes Yes Yes Global No
performance_schema_max_mutex_classes Yes Yes Yes Global No
performance_schema_max_mutex_instances Yes Yes Yes Global No
performance_schema_max_rwlock_classes Yes Yes Yes Global No
performance_schema_max_rwlock_instances Yes Yes Yes Global No
performance_schema_max_table_handles Yes Yes Yes Global No
performance_schema_max_table_instances Yes Yes Yes Global No
performance_schema_max_thread_classes Yes Yes Yes Global No
performance_schema_max_thread_instances Yes Yes Yes Global No
pid-file Yes Yes No
- Variable: pid_file Yes Global No
plugin_dir Yes Yes Yes Global No
port Yes Yes Yes Global No
preload_buffer_size Yes Yes Yes Both Yes
profiling Yes Varies Yes
profiling_history_size Yes Yes Yes Both Yes
protocol_version Yes Global No
proxy_user Yes Session No
pseudo_slave_mode Yes Session Yes
pseudo_thread_id Yes Session Yes
query_alloc_block_size Yes Yes Yes Both Yes
query_cache_limit Yes Yes Yes Global Yes
query_cache_min_res_unit Yes Yes Yes Global Yes
query_cache_size Yes Yes Yes Global Yes
query_cache_type Yes Yes Yes Both Yes
query_cache_wlock_invalidate Yes Yes Yes Both Yes
query_prealloc_size Yes Yes Yes Both Yes
rand_seed1 Yes Session Yes
rand_seed2 Yes Session Yes
range_alloc_block_size Yes Yes Yes Both Yes
read_buffer_size Yes Yes Yes Both Yes
read_only Yes Yes Yes Global Yes
read_rnd_buffer_size Yes Yes Yes Both Yes
relay-log Yes Yes No
- Variable: relay_log Yes Global No
relay-log-index Yes Yes No
- Variable: relay_log_index Yes Global No
relay_log_index Yes Yes Yes Global No
relay_log_info_file Yes Yes Yes Global No
relay_log_purge Yes Yes Yes Global Yes
relay_log_recovery Yes Yes Yes Global Yes
relay_log_space_limit Yes Yes Yes Global No
report-host Yes Yes No
- Variable: report_host Yes Global No
report-password Yes Yes No
- Variable: report_password Yes Global No
report-port Yes Yes No
- Variable: report_port Yes Global No
report-user Yes Yes No
- Variable: report_user Yes Global No
rpl_recovery_rank Yes Global Yes
rpl_semi_sync_master_enabled Yes Global Yes
rpl_semi_sync_master_timeout Yes Global Yes
rpl_semi_sync_master_trace_level Yes Global Yes
rpl_semi_sync_master_wait_no_slave Yes Global Yes
rpl_semi_sync_slave_enabled Yes Global Yes
rpl_semi_sync_slave_trace_level Yes Global Yes
secure-auth Yes Yes Yes
- Variable: secure_auth Yes Global Yes
secure-file-priv Yes Yes No
- Variable: secure_file_priv Yes Global No
server-id Yes Yes Yes
- Variable: server_id Yes Global Yes
server-id-bits Yes Yes No
- Variable: server_id_bits Yes Global No
server_id_bits Yes Yes Yes Global No
shared_memory Yes Yes Yes Global No
shared_memory_base_name Yes Yes Yes Global No
skip_external_locking Yes Yes Yes Global No
skip-name-resolve Yes Yes No
- Variable: skip_name_resolve Yes Global No
skip-networking Yes Yes No
- Variable: skip_networking Yes Global No
skip-show-database Yes Yes No
- Variable: skip_show_database Yes Global No
slave_allow_batching Yes Yes Yes Global Yes
slave_compressed_protocol Yes Yes Yes Global Yes
slave_exec_mode Yes Yes Yes Global Yes
slave-load-tmpdir Yes Yes No
- Variable: slave_load_tmpdir Yes Global No
slave_max_allowed_packet Yes Global Yes
slave-net-timeout Yes Yes Yes
- Variable: slave_net_timeout Yes Global Yes
slave-skip-errors Yes Yes No
- Variable: slave_skip_errors Yes Global No
slave_transaction_retries Yes Yes Yes Global Yes
slave_type_conversions Yes Yes Yes Global No
slow_launch_time Yes Yes Yes Global Yes
slow-query-log Yes Yes Yes
- Variable: slow_query_log Yes Global Yes
slow_query_log_file Yes Yes Yes Global Yes
socket Yes Yes Yes Global No
sort_buffer_size Yes Yes Yes Both Yes
sql_auto_is_null Yes Varies Yes
sql_big_selects Yes Varies Yes
sql_big_tables Yes Varies Yes
sql_buffer_result Yes Varies Yes
sql_log_bin Yes Varies Yes
sql_log_off Yes Varies Yes
sql_log_update Yes Session Yes
sql_low_priority_updates Yes Both Yes
sql_max_join_size Yes Both Yes
sql-mode Yes Yes Yes
- Variable: sql_mode Yes Both Yes
sql_notes Yes Varies Yes
sql_quote_show_create Yes Varies Yes
sql_safe_updates Yes Varies Yes
sql_select_limit Yes Both Yes
sql_slave_skip_counter Yes Global Yes
sql_warnings Yes Varies Yes
ssl-ca Yes Yes No
- Variable: ssl_ca Yes Global No
ssl-capath Yes Yes No
- Variable: ssl_capath Yes Global No
ssl-cert Yes Yes No
- Variable: ssl_cert Yes Global No
ssl-cipher Yes Yes No
- Variable: ssl_cipher Yes Global No
ssl-key Yes Yes No
- Variable: ssl_key Yes Global No
storage_engine Yes Both Yes
stored_program_cache Yes Yes Yes Global Yes
sync_binlog Yes Yes Yes Global Yes
sync_frm Yes Yes Yes Global Yes
sync_master_info Yes Yes Yes Global Yes
sync_relay_log Yes Yes Yes Global Yes
sync_relay_log_info Yes Yes Yes Global Yes
system_time_zone Yes Global No
table_definition_cache Yes Global Yes
table_lock_wait_timeout Yes Yes Yes Global Yes
table_open_cache Yes Global Yes
table_type Yes Both Yes
thread_cache_size Yes Yes Yes Global Yes
thread_concurrency Yes Yes Yes Global No
thread_handling Yes Yes Yes Global No
thread_pool_algorithm Yes Yes Yes Global No
thread_pool_high_priority_connection Yes Yes Yes Both Yes
thread_pool_max_unused_threads Yes Yes Yes Global Yes
thread_pool_prio_kickup_timer Yes Yes Yes Both Yes
thread_pool_size Yes Yes Yes Global No
thread_pool_stall_limit Yes Yes Yes Global Yes
thread_stack Yes Yes Yes Global No
time_format Yes Varies No
time_zone Yes Both Yes
timed_mutexes Yes Yes Yes Global Yes
timestamp Yes Session Yes
tmp_table_size Yes Yes Yes Both Yes
tmpdir Yes Yes Yes Global No
transaction_alloc_block_size Yes Yes Yes Both Yes
transaction_allow_batching Yes Session Yes
transaction_prealloc_size Yes Yes Yes Both Yes
tx_isolation Yes Both Yes
unique_checks Yes Varies Yes
updatable_views_with_limit Yes Yes Yes Both Yes
version Yes Global No
version_comment Yes Global No
version_compile_machine Yes Global No
version_compile_os Yes Global No
wait_timeout Yes Yes Yes Both Yes
warning_count Yes Session No

Notes:

1. This option is dynamic, but only the server should set this information. You should not set the value of this variable manually.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.