Server Option and Variable Reference
The following table provides a list of all the command line options, server and status 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 notification of where each option/variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding server system or status variable, the variable name is noted immediately below the corresponding option. For status variables, the scope of the variable is shown (Scope) as either global, session, or both. Please see the corresponding sections for details on setting and using the options and variables. Where appropriate, a direct link to further information on the item as available.
Table 5.1. Option/Variable Summary
Name | Cmd-Line | Option file | System Var | Status Var | Var Scope | Dynamic |
---|---|---|---|---|---|---|
abort-slave-event-count | Yes | Yes | ||||
Aborted_clients | Yes | Global | No | |||
Aborted_connects | Yes | Global | No | |||
allow-suspicious-udfs | Yes | Yes | ||||
ansi | Yes | Yes | ||||
auto_increment_increment | Yes | Yes | Yes | Both | Yes | |
auto_increment_offset | Yes | Yes | Yes | Both | Yes | |
autocommit | Yes | Yes | Yes | Both | Yes | |
automatic_sp_privileges | Yes | Global | Yes | |||
back_log | Yes | Yes | Yes | Global | No | |
basedir | Yes | Yes | Yes | Global | No | |
big-tables | Yes | Yes | Both | Yes | ||
- Variable: big_tables | Yes | Both | Yes | |||
bind-address | Yes | Yes | Yes | Global | No | |
Binlog_cache_disk_use | Yes | Global | No | |||
binlog_cache_size | Yes | Yes | Yes | Global | Yes | |
Binlog_cache_use | Yes | Global | No | |||
binlog-checksum | Yes | Yes | ||||
binlog_checksum | Yes | Global | Yes | |||
binlog_direct_non_transactional_updates | Yes | Yes | Yes | Both | Yes | |
binlog-do-db | Yes | Yes | ||||
binlog-format | Yes | Yes | Both | Yes | ||
- Variable: binlog_format | Yes | Both | Yes | |||
binlog-ignore-db | Yes | Yes | ||||
binlog-row-event-max-size | Yes | Yes | ||||
binlog_row_image | Yes | Yes | Both | Yes | ||
binlog_rows_query_log_events | Yes | Both | Yes | |||
binlog-rows-query-log-events | Yes | Yes | ||||
- Variable: binlog_rows_query_log_events | ||||||
Binlog_stmt_cache_disk_use | Yes | Global | No | |||
binlog_stmt_cache_size | Yes | Yes | Yes | Global | Yes | |
Binlog_stmt_cache_use | Yes | Global | No | |||
bootstrap | Yes | Yes | ||||
bulk_insert_buffer_size | Yes | Yes | Yes | Both | Yes | |
Bytes_received | Yes | Both | No | |||
Bytes_sent | Yes | Both | No | |||
character_set_client | Yes | Both | Yes | |||
character-set-client-handshake | Yes | Yes | ||||
character_set_connection | Yes | Both | Yes | |||
character_set_database[a] | Yes | Both | Yes | |||
character-set-filesystem | Yes | Yes | Both | Yes | ||
- Variable: character_set_filesystem | Yes | Both | Yes | |||
character_set_results | Yes | Both | Yes | |||
character-set-server | Yes | Yes | Both | Yes | ||
- Variable: character_set_server | Yes | Both | Yes | |||
character_set_system | Yes | Global | No | |||
character-sets-dir | Yes | Yes | Global | No | ||
- Variable: character_sets_dir | Yes | Global | No | |||
chroot | Yes | Yes | ||||
collation_connection | Yes | Both | Yes | |||
collation_database[b] | Yes | Both | Yes | |||
collation-server | Yes | Yes | Both | Yes | ||
- Variable: collation_server | Yes | Both | Yes | |||
Com_admin_commands | Yes | Both | No | |||
Com_alter_db | Yes | Both | No | |||
Com_alter_db_upgrade | Yes | Both | No | |||
Com_alter_event | Yes | Both | No | |||
Com_alter_function | Yes | Both | No | |||
Com_alter_procedure | Yes | Both | No | |||
Com_alter_server | Yes | Both | No | |||
Com_alter_table | Yes | Both | No | |||
Com_alter_tablespace | Yes | Both | No | |||
Com_analyze | Yes | Both | No | |||
Com_assign_to_keycache | Yes | Both | No | |||
Com_begin | Yes | Both | No | |||
Com_binlog | Yes | Both | No | |||
Com_call_procedure | Yes | Both | No | |||
Com_change_db | Yes | Both | No | |||
Com_change_master | Yes | Both | No | |||
Com_check | Yes | Both | No | |||
Com_checksum | Yes | Both | No | |||
Com_commit | Yes | Both | No | |||
Com_create_db | Yes | Both | No | |||
Com_create_event | Yes | Both | No | |||
Com_create_function | Yes | Both | No | |||
Com_create_index | Yes | Both | No | |||
Com_create_procedure | Yes | Both | No | |||
Com_create_server | Yes | Both | No | |||
Com_create_table | Yes | Both | No | |||
Com_create_trigger | Yes | Both | No | |||
Com_create_udf | Yes | Both | No | |||
Com_create_user | Yes | Both | No | |||
Com_create_view | Yes | Both | No | |||
Com_dealloc_sql | Yes | Both | No | |||
Com_delete | Yes | Both | No | |||
Com_delete_multi | Yes | Both | No | |||
Com_do | Yes | Both | No | |||
Com_drop_db | Yes | Both | No | |||
Com_drop_event | Yes | Both | No | |||
Com_drop_function | Yes | Both | No | |||
Com_drop_index | Yes | Both | No | |||
Com_drop_procedure | Yes | Both | No | |||
Com_drop_server | Yes | Both | No | |||
Com_drop_table | Yes | Both | No | |||
Com_drop_trigger | Yes | Both | No | |||
Com_drop_user | Yes | Both | No | |||
Com_drop_view | Yes | Both | No | |||
Com_empty_query | Yes | Both | No | |||
Com_execute_sql | Yes | Both | No | |||
Com_flush | Yes | Both | No | |||
Com_grant | Yes | Both | No | |||
Com_ha_close | Yes | Both | No | |||
Com_ha_open | Yes | Both | No | |||
Com_ha_read | Yes | Both | No | |||
Com_help | Yes | Both | No | |||
Com_insert | Yes | Both | No | |||
Com_insert_select | Yes | Both | No | |||
Com_install_plugin | Yes | Both | No | |||
Com_kill | Yes | Both | No | |||
Com_load | Yes | Both | No | |||
Com_lock_tables | Yes | Both | No | |||
Com_optimize | Yes | Both | No | |||
Com_preload_keys | Yes | Both | No | |||
Com_prepare_sql | Yes | Both | No | |||
Com_purge | Yes | Both | No | |||
Com_purge_before_date | Yes | Both | No | |||
Com_release_savepoint | Yes | Both | No | |||
Com_rename_table | Yes | Both | No | |||
Com_rename_user | Yes | Both | No | |||
Com_repair | Yes | Both | No | |||
Com_replace | Yes | Both | No | |||
Com_replace_select | Yes | Both | No | |||
Com_reset | Yes | Both | No | |||
Com_resignal | Yes | Both | No | |||
Com_revoke | Yes | Both | No | |||
Com_revoke_all | Yes | Both | No | |||
Com_rollback | Yes | Both | No | |||
Com_rollback_to_savepoint | Yes | Both | No | |||
Com_savepoint | Yes | Both | No | |||
Com_select | Yes | Both | No | |||
Com_set_option | Yes | Both | No | |||
Com_show_authors | Yes | Both | No | |||
Com_show_binlog_events | Yes | Both | No | |||
Com_show_binlogs | Yes | Both | No | |||
Com_show_charsets | Yes | Both | No | |||
Com_show_collations | Yes | Both | No | |||
Com_show_contributors | Yes | Both | No | |||
Com_show_create_db | Yes | Both | No | |||
Com_show_create_event | Yes | Both | No | |||
Com_show_create_func | Yes | Both | No | |||
Com_show_create_proc | Yes | Both | No | |||
Com_show_create_table | Yes | Both | No | |||
Com_show_create_trigger | Yes | Both | No | |||
Com_show_databases | Yes | Both | No | |||
Com_show_engine_logs | Yes | Both | No | |||
Com_show_engine_mutex | Yes | Both | No | |||
Com_show_engine_status | Yes | Both | No | |||
Com_show_errors | Yes | Both | No | |||
Com_show_events | Yes | Both | No | |||
Com_show_fields | Yes | Both | No | |||
Com_show_function_code | Yes | Both | No | |||
Com_show_function_status | Yes | Both | No | |||
Com_show_grants | Yes | Both | No | |||
Com_show_keys | Yes | Both | No | |||
Com_show_logs | Yes | Both | No | |||
Com_show_master_status | Yes | Both | No | |||
Com_show_new_master | Yes | Both | No | |||
Com_show_open_tables | Yes | Both | No | |||
Com_show_plugins | Yes | Both | No | |||
Com_show_privileges | Yes | Both | No | |||
Com_show_procedure_code | Yes | Both | No | |||
Com_show_procedure_status | Yes | Both | No | |||
Com_show_processlist | Yes | Both | No | |||
Com_show_profile | Yes | Both | No | |||
Com_show_profiles | Yes | Both | No | |||
Com_show_relaylog_events | Yes | Both | No | |||
Com_show_slave_hosts | Yes | Both | No | |||
Com_show_slave_status | Yes | Both | No | |||
Com_show_status | Yes | Both | No | |||
Com_show_storage_engines | Yes | Both | No | |||
Com_show_table_status | Yes | Both | No | |||
Com_show_tables | Yes | Both | No | |||
Com_show_triggers | Yes | Both | No | |||
Com_show_variables | Yes | Both | No | |||
Com_show_warnings | Yes | Both | No | |||
Com_signal | Yes | Both | No | |||
Com_slave_start | Yes | Both | No | |||
Com_slave_stop | Yes | Both | No | |||
Com_stmt_close | Yes | Both | No | |||
Com_stmt_execute | Yes | Both | No | |||
Com_stmt_fetch | Yes | Both | No | |||
Com_stmt_prepare | Yes | Both | No | |||
Com_stmt_reprepare | Yes | Both | No | |||
Com_stmt_reset | Yes | Both | No | |||
Com_stmt_send_long_data | Yes | Both | No | |||
Com_truncate | Yes | Both | No | |||
Com_uninstall_plugin | Yes | Both | No | |||
Com_unlock_tables | Yes | Both | No | |||
Com_update | Yes | Both | No | |||
Com_update_multi | Yes | Both | No | |||
Com_xa_commit | Yes | Both | No | |||
Com_xa_end | Yes | Both | No | |||
Com_xa_prepare | Yes | Both | No | |||
Com_xa_recover | Yes | Both | No | |||
Com_xa_rollback | Yes | Both | No | |||
Com_xa_start | Yes | Both | No | |||
completion_type | Yes | Yes | Yes | Both | Yes | |
Compression | Yes | Session | No | |||
concurrent_insert | Yes | Yes | Yes | Global | Yes | |
connect_timeout | Yes | Yes | Yes | Global | Yes | |
Connection_errors_accept | Yes | Global | No | |||
Connection_errors_internal | Yes | Global | No | |||
Connection_errors_max_connections | Yes | Global | No | |||
Connection_errors_peer_addr | Yes | Global | No | |||
Connection_errors_select | Yes | Global | No | |||
Connection_errors_tcpwrap | Yes | Global | No | |||
Connections | Yes | Global | No | |||
console | Yes | Yes | ||||
core-file | Yes | Yes | ||||
Created_tmp_disk_tables | Yes | Both | No | |||
Created_tmp_files | Yes | Global | No | |||
Created_tmp_tables | Yes | Both | No | |||
datadir | Yes | Yes | Yes | Global | No | |
date_format | Yes | Global | No | |||
datetime_format | Yes | Global | No | |||
debug | Yes | Yes | Yes | Both | Yes | |
debug_sync | Yes | Session | Yes | |||
debug-sync-timeout | Yes | Yes | ||||
default-storage-engine | Yes | Yes | Both | Yes | ||
- Variable: default_storage_engine | Yes | Both | Yes | |||
default-time-zone | Yes | Yes | ||||
default_tmp_storage_engine | Yes | Yes | Yes | Both | Yes | |
default_week_format | Yes | Yes | Yes | Both | Yes | |
defaults-extra-file | Yes | |||||
defaults-file | Yes | |||||
defaults-group-suffix | Yes | |||||
delay-key-write | Yes | Yes | Global | Yes | ||
- Variable: delay_key_write | Yes | Global | Yes | |||
Delayed_errors | Yes | Global | No | |||
delayed_insert_limit | Yes | Yes | Yes | Global | Yes | |
Delayed_insert_threads | Yes | Global | No | |||
delayed_insert_timeout | Yes | Yes | Yes | Global | Yes | |
delayed_queue_size | Yes | Yes | Yes | Global | Yes | |
Delayed_writes | Yes | Global | No | |||
des-key-file | Yes | Yes | ||||
disconnect-slave-event-count | Yes | Yes | ||||
div_precision_increment | Yes | Yes | Yes | Both | Yes | |
enable-named-pipe | Yes | Yes | ||||
- Variable: named_pipe | ||||||
end_markers_in_json | Yes | Both | Yes | |||
engine-condition-pushdown | Yes | Yes | Both | Yes | ||
- Variable: engine_condition_pushdown | Yes | Both | Yes | |||
eq_range_index_dive_limit | Yes | Yes | Yes | Both | Yes | |
error_count | Yes | Session | No | |||
event-scheduler | Yes | Yes | Global | Yes | ||
- Variable: event_scheduler | Yes | Global | Yes | |||
exit-info | Yes | Yes | ||||
expire_logs_days | Yes | Yes | Yes | Global | Yes | |
external-locking | Yes | Yes | ||||
- Variable: skip_external_locking | ||||||
external_user | Yes | Session | No | |||
federated | Yes | Yes | ||||
flush | Yes | Yes | Yes | Global | Yes | |
Flush_commands | Yes | Global | No | |||
flush_time | Yes | Yes | Yes | Global | Yes | |
foreign_key_checks | Yes | Both | 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 | |
gdb | Yes | Yes | ||||
general-log | Yes | Yes | Global | Yes | ||
- Variable: general_log | Yes | Global | Yes | |||
general_log_file | Yes | Yes | Yes | Global | Yes | |
group_concat_max_len | Yes | Yes | Yes | Both | Yes | |
Handler_commit | Yes | Both | No | |||
Handler_delete | Yes | Both | No | |||
Handler_discover | Yes | Both | No | |||
Handler_external_lock | Yes | Both | No | |||
Handler_prepare | Yes | Both | No | |||
Handler_read_first | Yes | Both | No | |||
Handler_read_key | Yes | Both | No | |||
Handler_read_last | Yes | Both | No | |||
Handler_read_next | Yes | Both | No | |||
Handler_read_prev | Yes | Both | No | |||
Handler_read_rnd | Yes | Both | No | |||
Handler_read_rnd_next | Yes | Both | No | |||
Handler_rollback | Yes | Both | No | |||
Handler_savepoint | Yes | Both | No | |||
Handler_savepoint_rollback | Yes | Both | No | |||
Handler_update | Yes | Both | No | |||
Handler_write | Yes | Both | No | |||
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 | |||
help | Yes | Yes | ||||
host_cache_size | Yes | Yes | Yes | Global | Yes | |
hostname | Yes | Global | No | |||
identity | Yes | Session | Yes | |||
ignore-builtin-innodb | Yes | Yes | Global | No | ||
- Variable: ignore_builtin_innodb | Yes | Global | No | |||
ignore-db-dir | Yes | Yes | ||||
- Variable: ignore_db_dirs | ||||||
init_connect | Yes | Yes | Yes | Global | Yes | |
init-file | Yes | Yes | Global | No | ||
- Variable: init_file | Yes | Global | No | |||
init_slave | Yes | Yes | Yes | Global | Yes | |
innodb | Yes | Yes | ||||
innodb_adaptive_flushing | Yes | Yes | Yes | Global | Yes | |
innodb_adaptive_hash_index | Yes | Yes | Yes | Global | Yes | |
innodb_adaptive_max_sleep_delay | Yes | Yes | Yes | Global | Yes | |
innodb_additional_mem_pool_size | Yes | Yes | Yes | Global | No | |
innodb_analyze_is_persistent | Yes | Yes | Yes | Global | Yes | |
innodb_autoextend_increment | Yes | Yes | Yes | Global | Yes | |
innodb_autoinc_lock_mode | Yes | Yes | Yes | Global | No | |
innodb_buffer_pool_dump_at_shutdown | Yes | Yes | Yes | Global | Yes | |
innodb_buffer_pool_dump_now | Yes | Yes | Yes | Global | Yes | |
Innodb_buffer_pool_dump_status | Yes | Global | No | |||
innodb_buffer_pool_filename | Yes | Yes | Yes | Global | Yes | |
innodb_buffer_pool_instances | Yes | Yes | Yes | Global | No | |
innodb_buffer_pool_load_abort | Yes | Yes | Yes | Global | Yes | |
innodb_buffer_pool_load_at_startup | Yes | Yes | Yes | Global | Yes | |
innodb_buffer_pool_load_now | Yes | Yes | Yes | Global | Yes | |
Innodb_buffer_pool_load_status | Yes | Global | No | |||
Innodb_buffer_pool_pages_data | Yes | Global | No | |||
Innodb_buffer_pool_pages_dirty | Yes | Global | No | |||
Innodb_buffer_pool_pages_flushed | Yes | Global | No | |||
Innodb_buffer_pool_pages_free | Yes | Global | No | |||
Innodb_buffer_pool_pages_latched | Yes | Global | No | |||
Innodb_buffer_pool_pages_misc | Yes | Global | No | |||
Innodb_buffer_pool_pages_total | Yes | Global | No | |||
Innodb_buffer_pool_read_ahead | Yes | Global | No | |||
Innodb_buffer_pool_read_ahead_evicted | Yes | Global | No | |||
Innodb_buffer_pool_read_requests | Yes | Global | No | |||
Innodb_buffer_pool_reads | Yes | Global | No | |||
innodb_buffer_pool_size | Yes | Yes | Yes | Global | No | |
Innodb_buffer_pool_wait_free | Yes | Global | No | |||
Innodb_buffer_pool_write_requests | Yes | Global | No | |||
innodb_change_buffer_max_size | Yes | Yes | Yes | Global | Yes | |
innodb_change_buffering | Yes | Yes | Yes | Global | Yes | |
innodb_checksum_algorithm | 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_fsyncs | Yes | Global | No | |||
innodb_data_home_dir | Yes | Yes | Yes | Global | No | |
Innodb_data_pending_fsyncs | Yes | Global | No | |||
Innodb_data_pending_reads | Yes | Global | No | |||
Innodb_data_pending_writes | Yes | Global | No | |||
Innodb_data_read | Yes | Global | No | |||
Innodb_data_reads | Yes | Global | No | |||
Innodb_data_writes | Yes | Global | No | |||
Innodb_data_written | Yes | Global | No | |||
Innodb_dblwr_pages_written | Yes | Global | No | |||
Innodb_dblwr_writes | 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 | No | |
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_flush_neighbors | Yes | Yes | Yes | Global | Yes | |
innodb_force_load_corrupted | Yes | Yes | Yes | Global | No | |
innodb_force_recovery | Yes | Yes | Yes | Global | No | |
innodb_ft_aux_table | Yes | Yes | Yes | Global | Yes | |
innodb_ft_cache_size | Yes | Yes | Yes | Global | Yes | |
innodb_ft_enable_stopword | Yes | Yes | Yes | Global | Yes | |
innodb_ft_max_token_size | Yes | Yes | Yes | Global | Yes | |
innodb_ft_min_token_size | Yes | Yes | Yes | Global | Yes | |
innodb_ft_num_word_optimize | Yes | Yes | Yes | Global | Yes | |
innodb_ft_server_stopword_table | Yes | Yes | Yes | Global | Yes | |
innodb_ft_sort_pll_degree | Yes | Yes | Yes | Global | Yes | |
innodb_ft_user_stopword_table | Yes | Yes | Yes | Global | Yes | |
Innodb_have_atomic_builtins | 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_log_waits | Yes | Global | No | |||
Innodb_log_write_requests | Yes | Global | No | |||
Innodb_log_writes | Yes | Global | No | |||
innodb_lru_scan_depth | Yes | Yes | Yes | Global | Yes | |
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_monitor_disable | Yes | Yes | Yes | Global | Yes | |
innodb_monitor_enable | Yes | Yes | Yes | Global | Yes | |
innodb_monitor_reset | Yes | Yes | Yes | Global | Yes | |
innodb_monitor_reset_all | Yes | Yes | Yes | Global | Yes | |
Innodb_num_open_files | 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_optimize_fulltext_only | Yes | Yes | Yes | Global | Yes | |
Innodb_os_log_fsyncs | Yes | Global | No | |||
Innodb_os_log_pending_fsyncs | Yes | Global | No | |||
Innodb_os_log_pending_writes | Yes | Global | No | |||
Innodb_os_log_written | Yes | Global | No | |||
innodb_page_size | Yes | Yes | Yes | Global | No | |
Innodb_page_size | Yes | Global | No | |||
Innodb_pages_created | Yes | Global | No | |||
Innodb_pages_read | Yes | Global | No | |||
Innodb_pages_written | Yes | Global | No | |||
innodb_print_all_deadlocks | Yes | Yes | Yes | Global | Yes | |
innodb_purge_batch_size | Yes | Yes | Yes | Global | No | |
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_row_lock_current_waits | Yes | Global | No | |||
Innodb_row_lock_time | Yes | Global | No | |||
Innodb_row_lock_time_avg | Yes | Global | No | |||
Innodb_row_lock_time_max | Yes | Global | No | |||
Innodb_row_lock_waits | Yes | Global | No | |||
Innodb_rows_deleted | Yes | Global | No | |||
Innodb_rows_inserted | Yes | Global | No | |||
Innodb_rows_read | Yes | Global | No | |||
Innodb_rows_updated | Yes | Global | No | |||
innodb_sort_buffer_size | Yes | Yes | Yes | Global | Yes | |
innodb_spin_wait_delay | Yes | Yes | Yes | Global | Yes | |
innodb_stats_method | Yes | Yes | Yes | Both | Yes | |
innodb_stats_on_metadata | Yes | Yes | Yes | Global | Yes | |
innodb_stats_persistent_sample_pages | Yes | Yes | Yes | Global | Yes | |
innodb_stats_sample_pages | Yes | Yes | Yes | Global | Yes | |
innodb_stats_transient_sample_pages | Yes | Yes | Yes | Global | Yes | |
innodb-status-file | Yes | Yes | ||||
innodb_strict_mode | Yes | Yes | Yes | Both | Yes | |
innodb_support_xa | Yes | Yes | Yes | Both | Yes | |
innodb_sync_array_size | Yes | Yes | Yes | Global | No | |
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_truncated_status_writes | Yes | Global | No | |||
innodb_undo_directory | Yes | Yes | Yes | Global | Yes | |
innodb_undo_logs | Yes | Yes | Yes | Global | Yes | |
innodb_undo_tablespaces | 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 | |||
install | Yes | |||||
install-manual | 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_blocks_not_flushed | Yes | Global | No | |||
Key_blocks_unused | Yes | Global | No | |||
Key_blocks_used | Yes | Global | No | |||
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 | |
Key_read_requests | Yes | Global | No | |||
Key_reads | Yes | Global | No | |||
Key_write_requests | Yes | Global | No | |||
Key_writes | Yes | Global | No | |||
language | Yes | Yes | Yes | Global | No | |
large_files_support | Yes | Global | No | |||
large_page_size | Yes | Global | No | |||
large-pages | Yes | Yes | Global | No | ||
- Variable: large_pages | Yes | Global | No | |||
last_insert_id | Yes | Session | Yes | |||
Last_query_cost | Yes | Session | No | |||
Last_query_partial_plans | Yes | Session | No | |||
lc-messages | Yes | Yes | Both | Yes | ||
- Variable: lc_messages | Yes | Both | Yes | |||
lc-messages-dir | Yes | Yes | Global | No | ||
- Variable: lc_messages_dir | Yes | Global | No | |||
lc_time_names | Yes | Both | Yes | |||
license | Yes | Global | No | |||
local_infile | Yes | Global | Yes | |||
local-infile | Yes | Yes | ||||
- Variable: local_infile | ||||||
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_basename | Yes | Global | No | |||
log-bin-index | Yes | Yes | ||||
log-error | Yes | Yes | Global | No | ||
- Variable: log_error | Yes | Global | No | |||
log-isam | Yes | Yes | ||||
log-output | Yes | Yes | Global | Yes | ||
- Variable: log_output | Yes | Global | Yes | |||
log-queries-not-using-indexes | Yes | Yes | Global | Yes | ||
- Variable: log_queries_not_using_indexes | Yes | Global | Yes | |||
log-raw | Yes | Yes | ||||
log-short-format | Yes | Yes | ||||
log-slave-updates | Yes | Yes | Global | No | ||
- Variable: log_slave_updates | Yes | Global | No | |||
log-slow-admin-statements | Yes | Yes | ||||
log-slow-queries | Yes | Yes | Global | Yes | ||
- Variable: log_slow_queries | Yes | Global | Yes | |||
log-slow-slave-statements | Yes | Yes | ||||
log-tc | Yes | Yes | ||||
log-tc-size | Yes | Yes | ||||
log_throttle_queries_not_using_indexes | Yes | Global | Yes | |||
log-warnings | Yes | Yes | Global | Yes | ||
- Variable: log_warnings | Yes | Global | Yes | |||
long_query_time | Yes | Yes | Yes | Both | Yes | |
low-priority-updates | Yes | Yes | Both | Yes | ||
- Variable: low_priority_updates | Yes | Both | Yes | |||
lower_case_file_system | Yes | Yes | Yes | Global | No | |
lower_case_table_names | Yes | Yes | Yes | Global | No | |
master-info-file | Yes | Yes | ||||
master_info_repository | Yes | Global | No | |||
master-info-repository | Yes | Yes | ||||
- Variable: master_info_repository | ||||||
master-retry-count | Yes | Yes | ||||
master_verify_checksum | Yes | Global | Yes | |||
master-verify-checksum | Yes | Yes | ||||
- Variable: master_verify_checksum | ||||||
max_allowed_packet | Yes | Yes | Yes | Global | Yes | |
max_binlog_cache_size | Yes | Yes | Yes | Global | Yes | |
max-binlog-dump-events | Yes | 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_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 | Yes | Yes | Both | Yes | |
Max_used_connections | Yes | Global | No | |||
max_user_connections | Yes | Yes | Yes | Both | Yes | |
max_write_lock_count | Yes | Yes | Yes | Global | Yes | |
memlock | Yes | Yes | Yes | Global | No | |
metadata_locks_cache_size | Yes | Global | No | |||
min-examined-row-limit | Yes | Yes | Yes | Both | Yes | |
myisam-block-size | Yes | 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 | Yes | ||||
- Variable: myisam_recover_options | ||||||
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_conflict_fn_max | Yes | Global | No | |||
Ndb_conflict_fn_old | Yes | Global | No | |||
Ndb_number_of_data_nodes | 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 | |
no-defaults | Yes | |||||
Not_flushed_delayed_rows | Yes | Global | No | |||
old | Yes | Yes | Yes | Global | No | |
old-alter-table | Yes | Yes | Both | Yes | ||
- Variable: old_alter_table | Yes | Both | Yes | |||
old-passwords | Yes | Yes | Both | Yes | ||
- Variable: old_passwords | Yes | Both | Yes | |||
old-style-user-limits | Yes | Yes | ||||
one-thread | Yes | Yes | ||||
Open_files | Yes | Global | No | |||
open-files-limit | Yes | Yes | Global | No | ||
- Variable: open_files_limit | Yes | Global | No | |||
Open_streams | Yes | Global | No | |||
Open_table_definitions | Yes | Global | No | |||
Open_tables | Yes | Both | No | |||
Opened_files | Yes | Global | No | |||
Opened_table_definitions | Yes | Both | No | |||
Opened_tables | Yes | Both | No | |||
optimizer_join_cache_level | Yes | Yes | Yes | Both | Yes | |
optimizer_prune_level | Yes | Yes | Yes | Both | Yes | |
optimizer_search_depth | Yes | Yes | Yes | Both | Yes | |
optimizer_switch | Yes | Yes | Yes | Both | Yes | |
optimizer_trace | Yes | Both | Yes | |||
optimizer_trace_features | Yes | Both | Yes | |||
optimizer_trace_limit | Yes | Both | Yes | |||
optimizer_trace_max_mem_size | Yes | Both | Yes | |||
optimizer_trace_offset | Yes | Both | Yes | |||
partition | Yes | Yes | Global | No | ||
- Variable: have_partitioning | Yes | Global | No | |||
performance_schema | Yes | Yes | Yes | Global | No | |
Performance_schema_accounts_lost | Yes | Global | No | |||
performance_schema_accounts_size | Yes | Yes | Yes | Global | No | |
Performance_schema_cond_classes_lost | Yes | Global | No | |||
Performance_schema_cond_instances_lost | Yes | Global | No | |||
performance_schema_consumer_xxx | Yes | Yes | ||||
performance_schema_events_stages_history_long_size | Yes | Yes | Yes | Global | No | |
performance_schema_events_stages_history_size | Yes | Yes | Yes | Global | No | |
performance_schema_events_statements_history_long_size | Yes | Yes | Yes | Global | No | |
performance_schema_events_statements_history_size | 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_file_classes_lost | Yes | Global | No | |||
Performance_schema_file_handles_lost | Yes | Global | No | |||
Performance_schema_file_instances_lost | Yes | Global | No | |||
Performance_schema_hosts_lost | Yes | Global | No | |||
performance_schema_hosts_size | Yes | Yes | Yes | Global | No | |
performance_schema_instrument | Yes | Yes | ||||
Performance_schema_locker_lost | 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_socket_classes | Yes | Yes | Yes | Global | No | |
performance_schema_max_socket_instances | Yes | Yes | Yes | Global | No | |
performance_schema_max_stage_classes | Yes | Yes | Yes | Global | No | |
performance_schema_max_statement_classes | 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 | |
Performance_schema_mutex_classes_lost | Yes | Global | No | |||
Performance_schema_mutex_instances_lost | Yes | Global | No | |||
Performance_schema_rwlock_classes_lost | Yes | Global | No | |||
Performance_schema_rwlock_instances_lost | Yes | Global | No | |||
performance_schema_setup_actors_size | Yes | Yes | Yes | Global | No | |
performance_schema_setup_objects_size | Yes | Yes | Yes | Global | No | |
Performance_schema_socket_classes_lost | Yes | Global | No | |||
Performance_schema_socket_instances_lost | Yes | Global | No | |||
Performance_schema_stage_classes_lost | Yes | Global | No | |||
Performance_schema_statement_classes_lost | Yes | Global | No | |||
Performance_schema_table_handles_lost | Yes | Global | No | |||
Performance_schema_table_instances_lost | Yes | Global | No | |||
Performance_schema_thread_classes_lost | Yes | Global | No | |||
Performance_schema_thread_instances_lost | Yes | Global | No | |||
Performance_schema_users_lost | Yes | Global | No | |||
performance_schema_users_size | Yes | Yes | Yes | Global | No | |
pid-file | Yes | Yes | Global | No | ||
- Variable: pid_file | Yes | Global | No | |||
plugin | Yes | Yes | ||||
plugin_dir | Yes | Yes | Yes | Global | No | |
plugin-load | Yes | Yes | ||||
plugin-load-add | Yes | Yes | ||||
port | Yes | Yes | Yes | Global | No | |
port-open-timeout | Yes | Yes | ||||
preload_buffer_size | Yes | Yes | Yes | Both | Yes | |
Prepared_stmt_count | Yes | Global | No | |||
print-defaults | Yes | |||||
profiling | Yes | Both | Yes | |||
profiling_history_size | Yes | Yes | Yes | Both | Yes | |
protocol_version | Yes | Global | No | |||
proxy_user | Yes | Session | No | |||
pseudo_thread_id | Yes | Session | Yes | |||
Qcache_free_blocks | Yes | Global | No | |||
Qcache_free_memory | Yes | Global | No | |||
Qcache_hits | Yes | Global | No | |||
Qcache_inserts | Yes | Global | No | |||
Qcache_lowmem_prunes | Yes | Global | No | |||
Qcache_not_cached | Yes | Global | No | |||
Qcache_queries_in_cache | Yes | Global | No | |||
Qcache_total_blocks | Yes | Global | No | |||
Queries | Yes | Both | No | |||
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 | |
Questions | Yes | Both | No | |||
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 | ||||
relay_log_basename | Yes | Global | No | |||
relay-log-index | Yes | Yes | Both | No | ||
- Variable: relay_log_index | Yes | Both | No | |||
relay_log_index | Yes | Yes | Yes | Global | No | |
relay-log-info-file | Yes | Yes | ||||
- Variable: relay_log_info_file | ||||||
relay_log_info_file | Yes | Yes | Yes | Global | No | |
relay-log-info-repository | Yes | Yes | ||||
- Variable: relay_log_info_repository | ||||||
relay_log_info_repository | 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 | |
remove | Yes | |||||
replicate-do-db | Yes | Yes | ||||
replicate-do-table | Yes | Yes | ||||
replicate-ignore-db | Yes | Yes | ||||
replicate-ignore-table | Yes | Yes | ||||
replicate-rewrite-db | Yes | Yes | ||||
replicate-same-server-id | Yes | Yes | ||||
replicate-wild-do-table | Yes | Yes | ||||
replicate-wild-ignore-table | Yes | Yes | ||||
report-host | Yes | Yes | Global | No | ||
- Variable: report_host | Yes | Global | No | |||
report-password | Yes | Yes | Global | No | ||
- Variable: report_password | Yes | Global | No | |||
report-port | Yes | Yes | Global | No | ||
- Variable: report_port | Yes | Global | No | |||
report-user | Yes | Yes | Global | No | ||
- Variable: report_user | Yes | Global | No | |||
Rpl_semi_sync_master_clients | Yes | Global | No | |||
rpl_semi_sync_master_enabled | Yes | Global | Yes | |||
Rpl_semi_sync_master_net_avg_wait_time | Yes | Global | No | |||
Rpl_semi_sync_master_net_wait_time | Yes | Global | No | |||
Rpl_semi_sync_master_net_waits | Yes | Global | No | |||
Rpl_semi_sync_master_no_times | Yes | Global | No | |||
Rpl_semi_sync_master_no_tx | Yes | Global | No | |||
Rpl_semi_sync_master_status | Yes | Global | No | |||
Rpl_semi_sync_master_timefunc_failures | Yes | Global | No | |||
rpl_semi_sync_master_timeout | Yes | Global | Yes | |||
rpl_semi_sync_master_trace_level | Yes | Global | Yes | |||
Rpl_semi_sync_master_tx_avg_wait_time | Yes | Global | No | |||
Rpl_semi_sync_master_tx_wait_time | Yes | Global | No | |||
Rpl_semi_sync_master_tx_waits | Yes | Global | No | |||
rpl_semi_sync_master_wait_no_slave | Yes | Global | Yes | |||
Rpl_semi_sync_master_wait_pos_backtraverse | Yes | Global | No | |||
Rpl_semi_sync_master_wait_sessions | Yes | Global | No | |||
Rpl_semi_sync_master_yes_tx | Yes | Global | No | |||
rpl_semi_sync_slave_enabled | Yes | Global | Yes | |||
Rpl_semi_sync_slave_status | Yes | Global | No | |||
rpl_semi_sync_slave_trace_level | Yes | Global | Yes | |||
safe-mode | Yes | Yes | ||||
safe-user-create | Yes | Yes | ||||
secure-auth | Yes | Yes | Global | Yes | ||
- Variable: secure_auth | Yes | Global | Yes | |||
secure-file-priv | Yes | Yes | Global | No | ||
- Variable: secure_file_priv | Yes | Global | No | |||
Select_full_join | Yes | Both | No | |||
Select_full_range_join | Yes | Both | No | |||
Select_range | Yes | Both | No | |||
Select_range_check | Yes | Both | No | |||
Select_scan | Yes | Both | No | |||
server-id | Yes | Yes | Global | Yes | ||
- Variable: server_id | Yes | Global | Yes | |||
server_uuid | Yes | Global | No | |||
shared_memory | Yes | Global | No | |||
shared_memory_base_name | Yes | Global | No | |||
show-slave-auth-info | Yes | Yes | ||||
skip-character-set-client-handshake | Yes | Yes | ||||
skip-concurrent-insert | Yes | Yes | ||||
- Variable: concurrent_insert | ||||||
skip-event-scheduler | Yes | Yes | ||||
skip-external-locking | Yes | Yes | Global | No | ||
- Variable: skip_external_locking | Yes | Global | No | |||
skip-grant-tables | Yes | Yes | ||||
skip-host-cache | Yes | Yes | ||||
skip-log-warnings | Yes | |||||
skip-name-resolve | Yes | Yes | Global | No | ||
- Variable: skip_name_resolve | Yes | Global | No | |||
skip-networking | Yes | Yes | Global | No | ||
- Variable: skip_networking | Yes | Global | No | |||
skip-new | Yes | Yes | ||||
skip-partition | Yes | Yes | ||||
skip-show-database | Yes | Yes | Global | No | ||
- Variable: skip_show_database | Yes | Global | No | |||
skip-slave-start | Yes | Yes | ||||
skip-ssl | Yes | Yes | ||||
skip-stack-trace | Yes | Yes | ||||
skip-symbolic-links | Yes | |||||
skip-thread-priority | Yes | Yes | ||||
slave_compressed_protocol | Yes | Yes | Yes | Global | Yes | |
slave_exec_mode | Yes | Global | Yes | |||
Slave_heartbeat_period | Yes | Global | No | |||
Slave_last_heartbeat | Yes | Global | No | |||
slave-load-tmpdir | Yes | Yes | Global | No | ||
- Variable: slave_load_tmpdir | Yes | Global | No | |||
slave-net-timeout | Yes | Yes | Global | Yes | ||
- Variable: slave_net_timeout | Yes | Global | Yes | |||
Slave_open_temp_tables | Yes | Global | No | |||
slave_parallel_workers | Yes | Global | Yes | |||
slave-parallel-workers | Yes | Yes | ||||
- Variable: slave_parallel_workers | ||||||
Slave_received_heartbeats | Yes | Global | No | |||
Slave_retried_transactions | Yes | Global | No | |||
Slave_running | Yes | Global | No | |||
slave-skip-errors | Yes | Yes | Global | No | ||
- Variable: slave_skip_errors | Yes | Global | No | |||
slave_sql_verify_checksum | Yes | Global | Yes | |||
slave-sql-verify-checksum | Yes | Yes | ||||
slave_transaction_retries | Yes | Yes | Yes | Global | Yes | |
slave_type_conversions | Yes | Yes | Yes | Global | No | |
Slow_launch_threads | Yes | Both | No | |||
slow_launch_time | Yes | Yes | Yes | Global | Yes | |
Slow_queries | Yes | Both | No | |||
slow-query-log | Yes | Yes | Global | Yes | ||
- Variable: slow_query_log | Yes | Global | Yes | |||
slow_query_log_file | Yes | Yes | Yes | Global | Yes | |
slow-start-timeout | Yes | Yes | ||||
socket | Yes | Yes | Yes | Global | No | |
sort_buffer_size | Yes | Yes | Yes | Both | Yes | |
Sort_merge_passes | Yes | Both | No | |||
Sort_range | Yes | Both | No | |||
Sort_rows | Yes | Both | No | |||
Sort_scan | Yes | Both | No | |||
sporadic-binlog-dump-fail | Yes | Yes | ||||
sql_auto_is_null | Yes | Both | Yes | |||
sql_big_selects | Yes | Both | Yes | |||
sql_big_tables | Yes | Both | Yes | |||
sql_buffer_result | Yes | Both | Yes | |||
sql_log_bin | Yes | Both | Yes | |||
sql_log_off | Yes | Both | Yes | |||
sql_low_priority_updates | Yes | Both | Yes | |||
sql_max_join_size | Yes | Both | Yes | |||
sql-mode | Yes | Yes | Both | Yes | ||
- Variable: sql_mode | Yes | Both | Yes | |||
sql_notes | Yes | Both | Yes | |||
sql_quote_show_create | Yes | Both | Yes | |||
sql_safe_updates | Yes | Both | Yes | |||
sql_select_limit | Yes | Both | Yes | |||
sql_slave_skip_counter | Yes | Global | Yes | |||
sql_warnings | Yes | Both | Yes | |||
ssl | Yes | Yes | ||||
Ssl_accept_renegotiates | Yes | Global | No | |||
Ssl_accepts | Yes | Global | No | |||
ssl-ca | Yes | Yes | Global | No | ||
- Variable: ssl_ca | Yes | Global | No | |||
Ssl_callback_cache_hits | Yes | Global | No | |||
ssl-capath | Yes | Yes | Global | No | ||
- Variable: ssl_capath | Yes | Global | No | |||
ssl-cert | Yes | Yes | Global | No | ||
- Variable: ssl_cert | Yes | Global | No | |||
ssl-cipher | Yes | Yes | Global | No | ||
- Variable: ssl_cipher | Yes | Global | No | |||
Ssl_cipher | Yes | Both | No | |||
Ssl_cipher_list | Yes | Both | No | |||
Ssl_client_connects | Yes | Global | No | |||
Ssl_connect_renegotiates | Yes | Global | No | |||
ssl-crl | Yes | Yes | Global | No | ||
- Variable: ssl_crl | Yes | Global | No | |||
ssl-crlpath | Yes | Yes | Global | No | ||
- Variable: ssl_crlpath | Yes | Global | No | |||
Ssl_ctx_verify_depth | Yes | Global | No | |||
Ssl_ctx_verify_mode | Yes | Global | No | |||
Ssl_default_timeout | Yes | Both | No | |||
Ssl_finished_accepts | Yes | Global | No | |||
Ssl_finished_connects | Yes | Global | No | |||
ssl-key | Yes | Yes | Global | No | ||
- Variable: ssl_key | Yes | Global | No | |||
Ssl_server_not_after | Yes | Both | No | |||
Ssl_server_not_before | Yes | Both | No | |||
Ssl_session_cache_hits | Yes | Global | No | |||
Ssl_session_cache_misses | Yes | Global | No | |||
Ssl_session_cache_mode | Yes | Global | No | |||
Ssl_session_cache_overflows | Yes | Global | No | |||
Ssl_session_cache_size | Yes | Global | No | |||
Ssl_session_cache_timeouts | Yes | Global | No | |||
Ssl_sessions_reused | Yes | Both | No | |||
Ssl_used_session_cache_entries | Yes | Global | No | |||
Ssl_verify_depth | Yes | Both | No | |||
Ssl_verify_mode | Yes | Both | No | |||
ssl-verify-server-cert | Yes | Yes | ||||
Ssl_version | Yes | Both | No | |||
standalone | Yes | Yes | ||||
storage_engine | Yes | Both | Yes | |||
symbolic-links | Yes | 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 | |
sysdate-is-now | Yes | Yes | ||||
system_time_zone | Yes | Global | No | |||
table_definition_cache | Yes | Yes | Yes | Global | Yes | |
Table_locks_immediate | Yes | Global | No | |||
Table_locks_waited | Yes | Global | No | |||
table_open_cache | Yes | Yes | Yes | Global | Yes | |
tc-heuristic-recover | Yes | Yes | ||||
Tc_log_max_pages_used | Yes | Global | No | |||
Tc_log_page_size | Yes | Global | No | |||
Tc_log_page_waits | Yes | Global | No | |||
temp-pool | Yes | Yes | ||||
thread_cache_size | Yes | Yes | Yes | Global | Yes | |
thread_concurrency | Yes | Yes | Yes | Global | No | |
thread_handling | Yes | Yes | Yes | Global | No | |
thread_stack | Yes | Yes | Yes | Global | No | |
Threads_cached | Yes | Global | No | |||
Threads_connected | Yes | Global | No | |||
Threads_created | Yes | Global | No | |||
Threads_running | Yes | Global | No | |||
time_format | Yes | Global | No | |||
time_zone | Yes | Yes | 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-isolation | Yes | Yes | ||||
- Variable: tx_isolation | ||||||
transaction_prealloc_size | Yes | Yes | Yes | Both | Yes | |
transaction-read-only | Yes | Yes | ||||
- Variable: tx_read_only | ||||||
tx_isolation | Yes | Both | Yes | |||
tx_read_only | Yes | Both | Yes | |||
unique_checks | Yes | Both | Yes | |||
updatable_views_with_limit | Yes | Yes | Yes | Both | Yes | |
Uptime | Yes | Global | No | |||
Uptime_since_flush_status | Yes | Global | No | |||
user | Yes | Yes | ||||
verbose | Yes | 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. Retornar |