http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html
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 |
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[a] | 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[b] | 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_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_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_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 | Global | No | ||
log-bin | Yes | Yes | 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 | Yes | Global | No |
log-bin-use-v1-row-events | Yes | Yes | No | ||
- Variable: log_bin_use_v1_row_events | Yes | Global | No | ||
log-error | Yes | Yes | No | ||
- Variable: log_error | Yes | Global | No | ||
log-output | Yes | Yes | Yes | ||
- Variable: log_output | 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 | Global | 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_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 |
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 | Global | Yes |
ndb-distribution | Yes | Yes | Yes | ||
- Variable: ndb_distribution | 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-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_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 | Yes | Global | No |
server-id-bits | Yes | Yes | No | ||
- Variable: server_id_bits | Yes | Global | No | ||
shared_memory | Yes | Yes | Yes | Global | No |
shared_memory_base_name | 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 | ||
[a] This option is dynamic, but only the server should set this information. You should not set the value of this variable manually. [b] This option is dynamic, but only the server should set this information. You should not set the value of this variable manually. |