Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 33.8Mb
PDF (A4) - 34.0Mb
PDF (RPM) - 33.2Mb
EPUB - 8.5Mb
HTML Download (TGZ) - 8.2Mb
HTML Download (Zip) - 8.2Mb
HTML Download (RPM) - 7.1Mb
Eclipse Doc Plugin (TGZ) - 9.0Mb
Eclipse Doc Plugin (Zip) - 11.1Mb
Man Pages (TGZ) - 219.4Kb
Man Pages (Zip) - 322.3Kb
Info (Gzip) - 3.2Mb
Info (Zip) - 3.2Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  Server Option and Variable Reference

5.1.1 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.

For a version of this table that is specific to MySQL Cluster, see Section 18.3.2.5, “MySQL Cluster mysqld Option and Variable Reference”.

Table 5.1 Option/Variable Summary

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
abort-slave-event-countYesYes
Aborted_clients YesGlobalNo
Aborted_connects YesGlobalNo
allow-suspicious-udfsYesYes
ansiYesYes
audit-logYesYes
audit_log_buffer_sizeYesYesYes GlobalNo
audit_log_connection_policyYesYesYes GlobalYes
audit_log_current_session Yes BothNo
Audit_log_current_size YesGlobalNo
Audit_log_event_max_drop_size YesGlobalNo
Audit_log_events YesGlobalNo
Audit_log_events_filtered YesGlobalNo
Audit_log_events_lost YesGlobalNo
Audit_log_events_written YesGlobalNo
audit_log_exclude_accountsYesYesYes GlobalYes
audit_log_fileYesYesYes GlobalNo
audit_log_flush Yes GlobalYes
audit_log_formatYesYesYes GlobalNo
audit_log_include_accountsYesYesYes GlobalYes
audit_log_policyYesYesYes GlobalNo
audit_log_rotate_on_sizeYesYesYes GlobalYes
audit_log_statement_policyYesYesYes GlobalYes
audit_log_strategyYesYesYes GlobalNo
Audit_log_total_size YesGlobalNo
Audit_log_write_waits YesGlobalNo
auto_generate_certsYesYesYes GlobalNo
auto_increment_increment Yes BothYes
auto_increment_offset Yes BothYes
autocommitYesYesYes BothYes
automatic_sp_privileges Yes GlobalYes
avoid_temporal_upgradeYesYesYes GlobalYes
back_log Yes GlobalNo
basedirYesYesYes GlobalNo
big-tablesYesYes BothYes
- Variable: big_tables Yes BothYes
bind-addressYesYes GlobalNo
- Variable: bind_address Yes GlobalNo
Binlog_cache_disk_use YesGlobalNo
binlog_cache_sizeYesYesYes GlobalYes
Binlog_cache_use YesGlobalNo
binlog-checksumYesYes
binlog_checksum Yes GlobalYes
binlog_direct_non_transactional_updatesYesYesYes BothYes
binlog-do-dbYesYes
binlog_error_actionYesYesYes BothYes
binlog-formatYesYes BothYes
- Variable: binlog_format Yes BothYes
binlog_group_commit_sync_delayYesYesYes GlobalYes
binlog_group_commit_sync_no_delay_countYesYesYes GlobalYes
binlog_gtid_simple_recoveryYesYesYes GlobalNo
binlog-ignore-dbYesYes
binlog_max_flush_queue_time Yes GlobalYes
binlog_order_commits Yes GlobalYes
binlog-row-event-max-sizeYesYes
binlog_row_imageYesYesYes BothYes
binlog-rows-query-log-eventsYesYes
- Variable: binlog_rows_query_log_events
binlog_rows_query_log_events Yes BothYes
Binlog_stmt_cache_disk_use YesGlobalNo
binlog_stmt_cache_sizeYesYesYes GlobalYes
Binlog_stmt_cache_use YesGlobalNo
binlogging_impossible_modeYesYesYes BothYes
block_encryption_modeYesYesYes BothYes
bootstrapYesYes
bulk_insert_buffer_sizeYesYesYes BothYes
Bytes_received YesBothNo
Bytes_sent YesBothNo
character_set_client Yes BothYes
character-set-client-handshakeYesYes
character_set_connection Yes BothYes
character_set_database[a] Yes BothYes
character-set-filesystemYesYes BothYes
- Variable: character_set_filesystem Yes BothYes
character_set_results Yes BothYes
character-set-serverYesYes BothYes
- Variable: character_set_server Yes BothYes
character_set_system Yes GlobalNo
character-sets-dirYesYes GlobalNo
- Variable: character_sets_dir Yes GlobalNo
check_proxy_usersYesYesYes GlobalYes
chrootYesYes
collation_connection Yes BothYes
collation_database[b] Yes BothYes
collation-serverYesYes BothYes
- Variable: collation_server Yes BothYes
Com_admin_commands YesBothNo
Com_alter_db YesBothNo
Com_alter_db_upgrade YesBothNo
Com_alter_event YesBothNo
Com_alter_function YesBothNo
Com_alter_procedure YesBothNo
Com_alter_server YesBothNo
Com_alter_table YesBothNo
Com_alter_tablespace YesBothNo
Com_alter_user YesBothNo
Com_analyze YesBothNo
Com_assign_to_keycache YesBothNo
Com_begin YesBothNo
Com_binlog YesBothNo
Com_call_procedure YesBothNo
Com_change_db YesBothNo
Com_change_master YesBothNo
Com_change_repl_filter YesBothNo
Com_check YesBothNo
Com_checksum YesBothNo
Com_commit YesBothNo
Com_create_db YesBothNo
Com_create_event YesBothNo
Com_create_function YesBothNo
Com_create_index YesBothNo
Com_create_procedure YesBothNo
Com_create_server YesBothNo
Com_create_table YesBothNo
Com_create_trigger YesBothNo
Com_create_udf YesBothNo
Com_create_user YesBothNo
Com_create_view YesBothNo
Com_dealloc_sql YesBothNo
Com_delete YesBothNo
Com_delete_multi YesBothNo
Com_do YesBothNo
Com_drop_db YesBothNo
Com_drop_event YesBothNo
Com_drop_function YesBothNo
Com_drop_index YesBothNo
Com_drop_procedure YesBothNo
Com_drop_server YesBothNo
Com_drop_table YesBothNo
Com_drop_trigger YesBothNo
Com_drop_user YesBothNo
Com_drop_view YesBothNo
Com_empty_query YesBothNo
Com_execute_sql YesBothNo
Com_explain_other YesBothNo
Com_flush YesBothNo
Com_get_diagnostics YesBothNo
Com_grant YesBothNo
Com_ha_close YesBothNo
Com_ha_open YesBothNo
Com_ha_read YesBothNo
Com_help YesBothNo
Com_insert YesBothNo
Com_insert_select YesBothNo
Com_install_plugin YesBothNo
Com_kill YesBothNo
Com_load YesBothNo
Com_lock_tables YesBothNo
Com_optimize YesBothNo
Com_preload_keys YesBothNo
Com_prepare_sql YesBothNo
Com_purge YesBothNo
Com_purge_before_date YesBothNo
Com_release_savepoint YesBothNo
Com_rename_table YesBothNo
Com_rename_user YesBothNo
Com_repair YesBothNo
Com_replace YesBothNo
Com_replace_select YesBothNo
Com_reset YesBothNo
Com_resignal YesBothNo
Com_revoke YesBothNo
Com_revoke_all YesBothNo
Com_rollback YesBothNo
Com_rollback_to_savepoint YesBothNo
Com_savepoint YesBothNo
Com_select YesBothNo
Com_set_option YesBothNo
Com_show_authors YesBothNo
Com_show_binlog_events YesBothNo
Com_show_binlogs YesBothNo
Com_show_charsets YesBothNo
Com_show_collations YesBothNo
Com_show_contributors YesBothNo
Com_show_create_db YesBothNo
Com_show_create_event YesBothNo
Com_show_create_func YesBothNo
Com_show_create_proc YesBothNo
Com_show_create_table YesBothNo
Com_show_create_trigger YesBothNo
Com_show_create_user YesBothNo
Com_show_databases YesBothNo
Com_show_engine_logs YesBothNo
Com_show_engine_mutex YesBothNo
Com_show_engine_status YesBothNo
Com_show_errors YesBothNo
Com_show_events YesBothNo
Com_show_fields YesBothNo
Com_show_function_code YesBothNo
Com_show_function_status YesBothNo
Com_show_grants YesBothNo
Com_show_keys YesBothNo
Com_show_master_status YesBothNo
Com_show_ndb_status YesBothNo
Com_show_new_master YesBothNo
Com_show_open_tables YesBothNo
Com_show_plugins YesBothNo
Com_show_privileges YesBothNo
Com_show_procedure_code YesBothNo
Com_show_procedure_status YesBothNo
Com_show_processlist YesBothNo
Com_show_profile YesBothNo
Com_show_profiles YesBothNo
Com_show_relaylog_events YesBothNo
Com_show_slave_hosts YesBothNo
Com_show_slave_status YesBothNo
Com_show_slave_status_nonblocking YesBothNo
Com_show_status YesBothNo
Com_show_storage_engines YesBothNo
Com_show_table_status YesBothNo
Com_show_tables YesBothNo
Com_show_triggers YesBothNo
Com_show_variables YesBothNo
Com_show_warnings YesBothNo
Com_shutdown YesBothNo
Com_signal YesBothNo
Com_slave_start YesBothNo
Com_slave_stop YesBothNo
Com_stmt_close YesBothNo
Com_stmt_execute YesBothNo
Com_stmt_fetch YesBothNo
Com_stmt_prepare YesBothNo
Com_stmt_reprepare YesBothNo
Com_stmt_reset YesBothNo
Com_stmt_send_long_data YesBothNo
Com_truncate YesBothNo
Com_uninstall_plugin YesBothNo
Com_unlock_tables YesBothNo
Com_update YesBothNo
Com_update_multi YesBothNo
Com_xa_commit YesBothNo
Com_xa_end YesBothNo
Com_xa_prepare YesBothNo
Com_xa_recover YesBothNo
Com_xa_rollback YesBothNo
Com_xa_start YesBothNo
completion_typeYesYesYes BothYes
Compression YesSessionNo
concurrent_insertYesYesYes GlobalYes
connect_timeoutYesYesYes GlobalYes
Connection_errors_accept YesGlobalNo
Connection_errors_internal YesGlobalNo
Connection_errors_max_connections YesGlobalNo
Connection_errors_peer_addr YesGlobalNo
Connection_errors_select YesGlobalNo
Connection_errors_tcpwrap YesGlobalNo
Connections YesGlobalNo
consoleYesYes
core-fileYesYes
core_file Yes GlobalNo
Created_tmp_disk_tables YesBothNo
Created_tmp_files YesGlobalNo
Created_tmp_tables YesBothNo
daemon_memcached_enable_binlogYesYesYes GlobalNo
daemon_memcached_engine_lib_nameYesYesYes GlobalNo
daemon_memcached_engine_lib_pathYesYesYes GlobalNo
daemon_memcached_optionYesYesYes GlobalNo
daemon_memcached_r_batch_sizeYesYesYes GlobalNo
daemon_memcached_w_batch_sizeYesYesYes GlobalNo
daemonizeYesYes
datadirYesYesYes GlobalNo
date_format Yes GlobalNo
datetime_format Yes GlobalNo
debugYesYesYes BothYes
debug_sync Yes SessionYes
debug-sync-timeoutYesYes
default-authentication-pluginYesYes
default_authentication_pluginYesYesYes GlobalNo
default_password_lifetimeYesYesYes GlobalYes
default-storage-engineYesYes BothYes
- Variable: default_storage_engine Yes BothYes
default-time-zoneYesYes
default_tmp_storage_engineYesYesYes BothYes
default_week_formatYesYesYes BothYes
defaults-extra-fileYes
defaults-fileYes
defaults-group-suffixYes
delay-key-writeYesYes GlobalYes
- Variable: delay_key_write Yes GlobalYes
Delayed_errors YesGlobalNo
delayed_insert_limitYesYesYes GlobalYes
Delayed_insert_threads YesGlobalNo
delayed_insert_timeoutYesYesYes GlobalYes
delayed_queue_sizeYesYesYes GlobalYes
Delayed_writes YesGlobalNo
des-key-fileYesYes
disabled_storage_enginesYesYesYes GlobalNo
disconnect_on_expired_passwordYesYesYes SessionNo
disconnect-slave-event-countYesYes
div_precision_incrementYesYesYes BothYes
early-plugin-loadYesYes
enable-named-pipeYesYes
- Variable: named_pipe
end_markers_in_json Yes BothYes
enforce-gtid-consistencyYesYesYes GlobalVaries
enforce_gtid_consistencyYesYesYes GlobalVaries
eq_range_index_dive_limit Yes BothYes
error_count Yes SessionNo
event-schedulerYesYes GlobalYes
- Variable: event_scheduler Yes GlobalYes
executed-gtids-compression-periodYesYes
- Variable: executed_gtids_compression_period
executed_gtids_compression_period Yes GlobalYes
exit-infoYesYes
expire_logs_daysYesYesYes GlobalYes
explicit_defaults_for_timestampYesYesYes BothNo
external-lockingYesYes
- Variable: skip_external_locking
external_user Yes SessionNo
federatedYesYes
Firewall_access_denied YesGlobalNo
Firewall_access_granted YesGlobalNo
Firewall_cached_entries YesGlobalNo
flushYesYesYes GlobalYes
Flush_commands YesGlobalNo
flush_timeYesYesYes GlobalYes
foreign_key_checks Yes BothYes
ft_boolean_syntaxYesYesYes GlobalYes
ft_max_word_lenYesYesYes GlobalNo
ft_min_word_lenYesYesYes GlobalNo
ft_query_expansion_limitYesYesYes GlobalNo
ft_stopword_fileYesYesYes GlobalNo
gdbYesYes
general-logYesYes GlobalYes
- Variable: general_log Yes GlobalYes
general_log_fileYesYesYes GlobalYes
group_concat_max_lenYesYesYes BothYes
gtid_executed Yes VariesNo
gtid-executed-compression-periodYesYes
- Variable: gtid_executed_compression_period
gtid_executed_compression_period Yes GlobalYes
gtid-modeYesYes GlobalVaries
- Variable: gtid_mode Yes GlobalVaries
gtid_mode Yes GlobalVaries
gtid_next Yes SessionYes
gtid_owned Yes BothNo
gtid_purged Yes GlobalYes
Handler_commit YesBothNo
Handler_delete YesBothNo
Handler_discover YesBothNo
Handler_external_lock YesBothNo
Handler_mrr_init YesBothNo
Handler_prepare YesBothNo
Handler_read_first YesBothNo
Handler_read_key YesBothNo
Handler_read_last YesBothNo
Handler_read_next YesBothNo
Handler_read_prev YesBothNo
Handler_read_rnd YesBothNo
Handler_read_rnd_next YesBothNo
Handler_rollback YesBothNo
Handler_savepoint YesBothNo
Handler_savepoint_rollback YesBothNo
Handler_update YesBothNo
Handler_write YesBothNo
have_compress Yes GlobalNo
have_crypt Yes GlobalNo
have_dynamic_loading Yes GlobalNo
have_geometry Yes GlobalNo
have_openssl Yes GlobalNo
have_profiling Yes GlobalNo
have_query_cache Yes GlobalNo
have_rtree_keys Yes GlobalNo
have_ssl Yes GlobalNo
have_statement_timeout Yes GlobalNo
have_symlink Yes GlobalNo
helpYesYes
host_cache_size Yes GlobalYes
hostname Yes GlobalNo
identity Yes SessionYes
ignore-builtin-innodbYesYes GlobalNo
- Variable: ignore_builtin_innodb Yes GlobalNo
ignore-db-dirYesYes
ignore_db_dirs Yes GlobalNo
init_connectYesYesYes GlobalYes
init-fileYesYes GlobalNo
- Variable: init_file Yes GlobalNo
init_slaveYesYesYes GlobalYes
initializeYesYes
initialize-insecureYesYes
innodbYesYes
innodb_adaptive_flushingYesYesYes GlobalYes
innodb_adaptive_flushing_lwmYesYesYes GlobalYes
innodb_adaptive_hash_indexYesYesYes GlobalYes
innodb_adaptive_hash_index_partsYesYesYes GlobalNo
innodb_adaptive_max_sleep_delayYesYesYes GlobalYes
innodb_additional_mem_pool_sizeYesYesYes GlobalNo
innodb_api_bk_commit_intervalYesYesYes GlobalYes
innodb_api_disable_rowlockYesYesYes GlobalNo
innodb_api_enable_binlogYesYesYes GlobalNo
innodb_api_enable_mdlYesYesYes GlobalNo
innodb_api_trx_levelYesYesYes GlobalYes
innodb_autoextend_incrementYesYesYes GlobalYes
innodb_autoinc_lock_modeYesYesYes GlobalNo
Innodb_available_undo_logs YesGlobalNo
innodb_background_drop_list_emptyYesYesYes GlobalYes
Innodb_buffer_pool_bytes_data YesGlobalNo
Innodb_buffer_pool_bytes_dirty YesGlobalNo
innodb_buffer_pool_chunk_sizeYesYesYes GlobalNo
innodb_buffer_pool_dump_at_shutdownYesYesYes GlobalYes
innodb_buffer_pool_dump_nowYesYesYes GlobalYes
innodb_buffer_pool_dump_pctYesYesYes GlobalYes
Innodb_buffer_pool_dump_status YesGlobalNo
innodb_buffer_pool_filenameYesYesYes GlobalYes
innodb_buffer_pool_instancesYesYesYes GlobalNo
innodb_buffer_pool_load_abortYesYesYes GlobalYes
innodb_buffer_pool_load_at_startupYesYesYes GlobalNo
innodb_buffer_pool_load_nowYesYesYes GlobalYes
Innodb_buffer_pool_load_status YesGlobalNo
Innodb_buffer_pool_pages_data YesGlobalNo
Innodb_buffer_pool_pages_dirty YesGlobalNo
Innodb_buffer_pool_pages_flushed YesGlobalNo
Innodb_buffer_pool_pages_free YesGlobalNo
Innodb_buffer_pool_pages_latched YesGlobalNo
Innodb_buffer_pool_pages_misc YesGlobalNo
Innodb_buffer_pool_pages_total YesGlobalNo
Innodb_buffer_pool_read_ahead YesGlobalNo
Innodb_buffer_pool_read_ahead_evicted YesGlobalNo
Innodb_buffer_pool_read_requests YesGlobalNo
Innodb_buffer_pool_reads YesGlobalNo
Innodb_buffer_pool_resize_status YesGlobalNo
innodb_buffer_pool_sizeYesYesYes GlobalVaries
Innodb_buffer_pool_wait_free YesGlobalNo
Innodb_buffer_pool_write_requests YesGlobalNo
innodb_change_buffer_max_sizeYesYesYes GlobalYes
innodb_change_bufferingYesYesYes GlobalYes
innodb_change_buffering_debugYesYesYes GlobalYes
innodb_checksum_algorithmYesYesYes GlobalYes
innodb_checksumsYesYesYes GlobalNo
innodb_cmp_per_index_enabledYesYesYes GlobalYes
innodb_commit_concurrencyYesYesYes GlobalYes
innodb_compress_debugYesYesYes GlobalYes
innodb_compression_failure_threshold_pctYesYesYes GlobalYes
innodb_compression_levelYesYesYes GlobalYes
innodb_compression_pad_pct_maxYesYesYes GlobalYes
innodb_concurrency_ticketsYesYesYes GlobalYes
innodb_create_intrinsicYesYesYes SessionYes
innodb_data_file_pathYesYesYes GlobalNo
Innodb_data_fsyncs YesGlobalNo
innodb_data_home_dirYesYesYes GlobalNo
Innodb_data_pending_fsyncs YesGlobalNo
Innodb_data_pending_reads YesGlobalNo
Innodb_data_pending_writes YesGlobalNo
Innodb_data_read YesGlobalNo
Innodb_data_reads YesGlobalNo
Innodb_data_writes YesGlobalNo
Innodb_data_written YesGlobalNo
Innodb_dblwr_pages_written YesGlobalNo
Innodb_dblwr_writes YesGlobalNo
innodb_default_row_formatYesYesYes GlobalYes
innodb_disable_resize_buffer_pool_debugYesYesYes GlobalYes
innodb_disable_sort_file_cacheYesYesYes GlobalYes
innodb_doublewriteYesYesYes GlobalNo
innodb_fast_shutdownYesYesYes GlobalYes
innodb_fil_make_page_dirty_debugYesYesYes GlobalYes
innodb_file_formatYesYesYes GlobalYes
innodb_file_format_checkYesYesYes GlobalNo
innodb_file_format_maxYesYesYes GlobalYes
innodb_file_per_tableYesYesYes GlobalYes
innodb_fill_factorYesYesYes GlobalYes
innodb_flush_log_at_timeout Yes GlobalYes
innodb_flush_log_at_trx_commitYesYesYes GlobalYes
innodb_flush_methodYesYesYes GlobalNo
innodb_flush_neighborsYesYesYes GlobalYes
innodb_flush_syncYesYesYes GlobalYes
innodb_flushing_avg_loopsYesYesYes GlobalYes
innodb_force_load_corruptedYesYesYes GlobalNo
innodb_force_recoveryYesYesYes GlobalNo
innodb_ft_aux_tableYesYesYes GlobalYes
innodb_ft_cache_sizeYesYesYes GlobalNo
innodb_ft_enable_diag_printYesYesYes GlobalYes
innodb_ft_enable_stopwordYesYesYes GlobalYes
innodb_ft_max_token_sizeYesYesYes GlobalNo
innodb_ft_min_token_sizeYesYesYes GlobalNo
innodb_ft_num_word_optimizeYesYesYes GlobalYes
innodb_ft_result_cache_limitYesYesYes GlobalYes
innodb_ft_server_stopword_tableYesYesYes GlobalYes
innodb_ft_sort_pll_degreeYesYesYes GlobalNo
innodb_ft_total_cache_sizeYesYesYes GlobalNo
innodb_ft_user_stopword_tableYesYesYes BothYes
Innodb_have_atomic_builtins YesGlobalNo
innodb_io_capacityYesYesYes GlobalYes
innodb_io_capacity_maxYesYesYes GlobalYes
innodb_large_prefixYesYesYes GlobalYes
innodb_limit_optimistic_insert_debugYesYesYes GlobalYes
innodb_lock_wait_timeoutYesYesYes BothYes
innodb_locks_unsafe_for_binlogYesYesYes GlobalNo
innodb_log_buffer_sizeYesYesYes GlobalNo
innodb_log_checksum_algorithmYesYesYes GlobalYes
innodb_log_checksumsYesYesYes GlobalYes
innodb_log_compressed_pagesYesYesYes GlobalYes
innodb_log_file_sizeYesYesYes GlobalNo
innodb_log_files_in_groupYesYesYes GlobalNo
innodb_log_group_home_dirYesYesYes GlobalNo
Innodb_log_waits YesGlobalNo
innodb_log_write_ahead_sizeYesYesYes GlobalYes
Innodb_log_write_requests YesGlobalNo
Innodb_log_writes YesGlobalNo
innodb_lru_scan_depthYesYesYes GlobalYes
innodb_max_dirty_pages_pctYesYesYes GlobalYes
innodb_max_dirty_pages_pct_lwmYesYesYes GlobalYes
innodb_max_purge_lagYesYesYes GlobalYes
innodb_max_purge_lag_delayYesYesYes GlobalYes
innodb_max_undo_log_sizeYesYesYes GlobalYes
innodb_merge_threshold_set_all_debugYesYesYes GlobalYes
innodb_monitor_disableYesYesYes GlobalYes
innodb_monitor_enableYesYesYes GlobalYes
innodb_monitor_resetYesYesYes GlobalYes
innodb_monitor_reset_allYesYesYes GlobalYes
Innodb_num_open_files YesGlobalNo
innodb_numa_interleaveYesYesYes GlobalNo
innodb_old_blocks_pctYesYesYes GlobalYes
innodb_old_blocks_timeYesYesYes GlobalYes
innodb_online_alter_log_max_sizeYesYesYes GlobalYes
innodb_open_filesYesYesYes GlobalNo
innodb_optimize_fulltext_onlyYesYesYes GlobalYes
innodb_optimize_point_storageYesYesYes SessionYes
Innodb_os_log_fsyncs YesGlobalNo
Innodb_os_log_pending_fsyncs YesGlobalNo
Innodb_os_log_pending_writes YesGlobalNo
Innodb_os_log_written YesGlobalNo
innodb_page_cleanersYesYesYes GlobalNo
Innodb_page_size YesGlobalNo
innodb_page_sizeYesYesYes GlobalNo
Innodb_pages_created YesGlobalNo
Innodb_pages_read YesGlobalNo
Innodb_pages_written YesGlobalNo
innodb_print_all_deadlocksYesYesYes GlobalYes
innodb_purge_batch_sizeYesYesYes GlobalYes
innodb_purge_rseg_truncate_frequencyYesYesYes GlobalYes
innodb_purge_threadsYesYesYes GlobalNo
innodb_random_read_aheadYesYesYes GlobalYes
innodb_read_ahead_thresholdYesYesYes GlobalYes
innodb_read_io_threadsYesYesYes GlobalNo
innodb_read_onlyYesYesYes GlobalNo
innodb_replication_delayYesYesYes GlobalYes
innodb_rollback_on_timeoutYesYesYes GlobalNo
innodb_rollback_segmentsYesYesYes GlobalYes
Innodb_row_lock_current_waits YesGlobalNo
Innodb_row_lock_time YesGlobalNo
Innodb_row_lock_time_avg YesGlobalNo
Innodb_row_lock_time_max YesGlobalNo
Innodb_row_lock_waits YesGlobalNo
Innodb_rows_deleted YesGlobalNo
Innodb_rows_inserted YesGlobalNo
Innodb_rows_read YesGlobalNo
Innodb_rows_updated YesGlobalNo
innodb_saved_page_number_debugYesYesYes GlobalYes
innodb_sort_buffer_sizeYesYesYes GlobalNo
innodb_spin_wait_delayYesYesYes GlobalYes
innodb_stats_auto_recalcYesYesYes GlobalYes
innodb_stats_methodYesYesYes GlobalYes
innodb_stats_on_metadataYesYesYes GlobalYes
innodb_stats_persistentYesYesYes GlobalYes
innodb_stats_persistent_sample_pagesYesYesYes GlobalYes
innodb_stats_sample_pagesYesYesYes GlobalYes
innodb_stats_transient_sample_pagesYesYesYes GlobalYes
innodb-status-fileYesYes
innodb_status_outputYesYesYes GlobalYes
innodb_status_output_locksYesYesYes GlobalYes
innodb_strict_modeYesYesYes BothYes
innodb_support_xaYesYesYes BothYes
innodb_sync_array_sizeYesYesYes GlobalNo
innodb_sync_debugYesYesYes GlobalNo
innodb_sync_spin_loopsYesYesYes GlobalYes
innodb_table_locksYesYesYes BothYes
innodb_temp_data_file_pathYesYesYes GlobalNo
innodb_thread_concurrencyYesYesYes GlobalYes
innodb_thread_sleep_delayYesYesYes GlobalYes
innodb_tmpdirYesYesYes SessionYes
Innodb_truncated_status_writes YesGlobalNo
innodb_trx_purge_view_update_only_debugYesYesYes GlobalYes
innodb_trx_rseg_n_slots_debugYesYesYes GlobalYes
innodb_undo_directoryYesYesYes GlobalNo
innodb_undo_log_truncateYesYesYes GlobalYes
innodb_undo_logsYesYesYes GlobalYes
innodb_undo_tablespacesYesYesYes GlobalNo
innodb_use_native_aioYesYesYes GlobalNo
innodb_use_sys_mallocYesYesYes GlobalNo
innodb_version Yes GlobalNo
innodb_write_io_threadsYesYesYes GlobalNo
insert_id Yes SessionYes
installYes
install-manualYes
interactive_timeoutYesYesYes BothYes
internal_tmp_disk_storage_engineYesYesYes GlobalYes
join_buffer_sizeYesYesYes BothYes
keep_files_on_createYesYesYes BothYes
Key_blocks_not_flushed YesGlobalNo
Key_blocks_unused YesGlobalNo
Key_blocks_used YesGlobalNo
key_buffer_sizeYesYesYes GlobalYes
key_cache_age_thresholdYesYesYes GlobalYes
key_cache_block_sizeYesYesYes GlobalYes
key_cache_division_limitYesYesYes GlobalYes
Key_read_requests YesGlobalNo
Key_reads YesGlobalNo
Key_write_requests YesGlobalNo
Key_writes YesGlobalNo
keyring_file_dataYesYesYes GlobalYes
languageYesYesYes GlobalNo
large_files_support Yes GlobalNo
large_page_size Yes GlobalNo
large-pagesYesYes GlobalNo
- Variable: large_pages Yes GlobalNo
last_insert_id Yes SessionYes
Last_query_cost YesSessionNo
Last_query_partial_plans YesSessionNo
lc-messagesYesYes BothYes
- Variable: lc_messages Yes BothYes
lc-messages-dirYesYes GlobalNo
- Variable: lc_messages_dir Yes GlobalNo
lc_time_names Yes BothYes
license Yes GlobalNo
local_infile Yes GlobalYes
local-serviceYes
lock_wait_timeoutYesYesYes BothYes
Locked_connects YesGlobalNo
locked_in_memory Yes GlobalNo
log_backward_compatible_user_definitionsYesYesYes GlobalYes
log-binYesYesYes GlobalNo
log_bin Yes GlobalNo
log_bin_basename Yes GlobalNo
log-bin-indexYesYes
log_bin_index Yes GlobalNo
log-bin-trust-function-creatorsYesYes GlobalYes
- Variable: log_bin_trust_function_creators Yes GlobalYes
log-bin-use-v1-row-eventsYesYes GlobalNo
- Variable: log_bin_use_v1_row_events Yes GlobalNo
log_bin_use_v1_row_eventsYesYesYes GlobalNo
log_builtin_as_identified_by_passwordYesYesYes GlobalYes
log-errorYesYes GlobalNo
- Variable: log_error Yes GlobalNo
log_error_verbosityYesYesYes GlobalYes
log-isamYesYes
log-outputYesYes GlobalYes
- Variable: log_output Yes GlobalYes
log-queries-not-using-indexesYesYes GlobalYes
- Variable: log_queries_not_using_indexes Yes GlobalYes
log-rawYesYes
log-short-formatYesYes
log-slave-updatesYesYes GlobalNo
- Variable: log_slave_updates Yes GlobalNo
log_slave_updatesYesYesYes GlobalNo
log-slow-admin-statementsYesYes
log_slow_admin_statements Yes GlobalYes
log-slow-slave-statementsYesYes
log_slow_slave_statements Yes GlobalYes
log_statements_unsafe_for_binlog Yes GlobalYes
log_syslogYesYesYes GlobalYes
log_syslog_facilityYesYesYes GlobalYes
log_syslog_include_pidYesYesYes GlobalYes
log_syslog_tagYesYesYes GlobalYes
log-tcYesYes
log-tc-sizeYesYes
log_throttle_queries_not_using_indexes Yes GlobalYes
log_timestampsYesYesYes GlobalYes
log-warningsYesYes GlobalYes
- Variable: log_warnings Yes GlobalYes
long_query_timeYesYesYes BothYes
low-priority-updatesYesYes BothYes
- Variable: low_priority_updates Yes BothYes
lower_case_file_system Yes GlobalNo
lower_case_table_namesYesYesYes GlobalNo
master-info-fileYesYes
master-info-repositoryYesYes
- Variable: master_info_repository
master_info_repositoryYesYesYes GlobalYes
master-retry-countYesYes
master-verify-checksumYesYes
- Variable: master_verify_checksum
master_verify_checksum Yes GlobalYes
max_allowed_packetYesYesYes BothYes
max_binlog_cache_sizeYesYesYes GlobalYes
max-binlog-dump-eventsYesYes
max_binlog_sizeYesYesYes GlobalYes
max_binlog_stmt_cache_sizeYesYesYes GlobalYes
max_connect_errorsYesYesYes GlobalYes
max_connectionsYesYesYes GlobalYes
max_delayed_threadsYesYesYes BothYes
max_digest_lengthYesYesYes GlobalNo
max_error_countYesYesYes BothYes
max_execution_timeYesYesYes BothYes
Max_execution_time_exceeded YesBothNo
Max_execution_time_set YesBothNo
Max_execution_time_set_failed YesBothNo
max_heap_table_sizeYesYesYes BothYes
max_insert_delayed_threads Yes BothYes
max_join_sizeYesYesYes BothYes
max_length_for_sort_dataYesYesYes BothYes
max_points_in_geometryYesYesYes GlobalYes
max_prepared_stmt_countYesYesYes GlobalYes
max_relay_log_sizeYesYesYes GlobalYes
max_seeks_for_keyYesYesYes BothYes
max_sort_lengthYesYesYes BothYes
max_sp_recursion_depthYesYesYes BothYes
max_statement_time Yes BothYes
Max_statement_time_exceeded YesBothNo
Max_statement_time_set YesBothNo
Max_statement_time_set_failed YesBothNo
max_tmp_tables Yes BothYes
Max_used_connections YesGlobalNo
Max_used_connections_time YesGlobalNo
max_user_connectionsYesYesYes BothYes
max_write_lock_countYesYesYes GlobalYes
mecab_charset YesGlobalNo
mecab_rc_fileYesYesYes GlobalNo
memlockYesYes
- Variable: locked_in_memory
metadata_locks_cache_size Yes GlobalNo
metadata_locks_hash_instances Yes GlobalNo
min-examined-row-limitYesYesYes BothYes
multi_range_countYesYesYes BothYes
myisam-block-sizeYesYes
myisam_data_pointer_sizeYesYesYes GlobalYes
myisam_max_sort_file_sizeYesYesYes GlobalYes
myisam_mmap_sizeYesYesYes GlobalNo
myisam-recover-optionsYesYes
- Variable: myisam_recover_options
myisam_recover_options Yes GlobalNo
myisam_repair_threadsYesYesYes BothYes
myisam_sort_buffer_sizeYesYesYes BothYes
myisam_stats_methodYesYesYes BothYes
myisam_use_mmapYesYesYes GlobalYes
mysql_firewall_max_query_sizeYesYesYes GlobalNo
mysql_firewall_modeYesYesYes GlobalYes
mysql_firewall_traceYesYesYes GlobalYes
mysql_native_password_proxy_usersYesYesYes GlobalYes
named_pipe Yes GlobalNo
ndb-allow-copying-alter-tableYesYesYes BothYes
Ndb_api_bytes_received_count YesGlobalNo
Ndb_api_bytes_received_count_session YesSessionNo
Ndb_api_bytes_received_count_slave YesGlobalNo
Ndb_api_bytes_sent_count YesGlobalNo
Ndb_api_bytes_sent_count_slave YesGlobalNo
Ndb_api_event_bytes_count_injector YesGlobalNo
Ndb_api_event_data_count_injector YesGlobalNo
Ndb_api_event_nondata_count_injector YesGlobalNo
Ndb_api_pk_op_count YesGlobalNo
Ndb_api_pk_op_count_session YesSessionNo
Ndb_api_pk_op_count_slave YesGlobalNo
Ndb_api_pruned_scan_count YesGlobalNo
Ndb_api_pruned_scan_count_session YesSessionNo
Ndb_api_range_scan_count_slave YesGlobalNo
Ndb_api_read_row_count YesGlobalNo
Ndb_api_read_row_count_session YesSessionNo
Ndb_api_scan_batch_count_slave YesGlobalNo
Ndb_api_table_scan_count YesGlobalNo
Ndb_api_table_scan_count_session YesSessionNo
Ndb_api_trans_abort_count YesGlobalNo
Ndb_api_trans_abort_count_session YesSessionNo
Ndb_api_trans_abort_count_slave YesGlobalNo
Ndb_api_trans_close_count YesGlobalNo
Ndb_api_trans_close_count_session YesSessionNo
Ndb_api_trans_close_count_slave YesGlobalNo
Ndb_api_trans_commit_count YesGlobalNo
Ndb_api_trans_commit_count_session YesSessionNo
Ndb_api_trans_commit_count_slave YesGlobalNo
Ndb_api_trans_local_read_row_count_slave YesGlobalNo
Ndb_api_trans_start_count YesGlobalNo
Ndb_api_trans_start_count_session YesSessionNo
Ndb_api_trans_start_count_slave YesGlobalNo
Ndb_api_uk_op_count YesGlobalNo
Ndb_api_uk_op_count_slave YesGlobalNo
Ndb_api_wait_exec_complete_count YesGlobalNo
Ndb_api_wait_exec_complete_count_session YesSessionNo
Ndb_api_wait_exec_complete_count_slave YesGlobalNo
Ndb_api_wait_meta_request_count YesGlobalNo
Ndb_api_wait_meta_request_count_session YesSessionNo
Ndb_api_wait_nanos_count YesGlobalNo
Ndb_api_wait_nanos_count_session YesSessionNo
Ndb_api_wait_nanos_count_slave YesGlobalNo
Ndb_api_wait_scan_result_count YesGlobalNo
Ndb_api_wait_scan_result_count_session YesSessionNo
Ndb_api_wait_scan_result_count_slave YesGlobalNo
ndb_autoincrement_prefetch_szYesYesYes BothYes
ndb-batch-sizeYesYesYes GlobalNo
ndb-blob-read-batch-bytesYesYesYes BothYes
ndb-blob-write-batch-bytesYesYesYes BothYes
ndb_cache_check_timeYesYesYes GlobalYes
ndb_clear_apply_statusYes Yes GlobalYes
ndb-cluster-connection-poolYesYesYes GlobalNo
ndb-cluster-connection-pool-nodeidsYesYesYes GlobalNo
Ndb_cluster_node_id YesBothNo
Ndb_config_from_host YesBothNo
Ndb_config_from_port YesBothNo
Ndb_conflict_fn_epoch_trans YesGlobalNo
Ndb_conflict_fn_max YesGlobalNo
Ndb_conflict_fn_old YesGlobalNo
Ndb_conflict_trans_detect_iter_count YesGlobalNo
Ndb_conflict_trans_row_reject_count YesGlobalNo
ndb-connectstringYesYes
ndb-deferred-constraintsYesYes BothYes
- Variable: ndb_deferred_constraints Yes BothYes
ndb_deferred_constraintsYesYesYes BothYes
ndb-distributionYesYes GlobalYes
- Variable: ndb_distribution Yes GlobalYes
ndb_distributionYesYesYes GlobalYes
ndb_eventbuffer_free_percentYesYesYes GlobalYes
ndb_eventbuffer_max_allocYesYesYes GlobalYes
ndb_extra_loggingYesYesYes GlobalYes
ndb_force_sendYesYesYes BothYes
ndb_index_stat_enableYesYesYes BothYes
ndb_index_stat_optionYesYesYes BothYes
ndb_join_pushdown Yes BothYes
Ndb_last_commit_epoch_server YesGlobalNo
Ndb_last_commit_epoch_session YesSessionNo
ndb-log-apply-statusYesYes GlobalNo
- Variable: ndb_log_apply_status Yes GlobalNo
ndb_log_apply_statusYesYesYes GlobalNo
ndb_log_binYes Yes BothYes
ndb_log_binlog_indexYes Yes GlobalYes
ndb-log-empty-epochsYesYesYes GlobalYes
ndb_log_empty_epochsYesYesYes GlobalYes
ndb-log-exclusive-readsYesYes BothYes
- Variable: ndb_log_exclusive_reads Yes BothYes
ndb_log_exclusive_readsYesYesYes BothYes
ndb-log-origYesYes GlobalNo
- Variable: ndb_log_orig Yes GlobalNo
ndb_log_origYesYesYes GlobalNo
ndb-log-transaction-idYesYes GlobalNo
- Variable: ndb_log_transaction_id Yes GlobalNo
ndb_log_transaction_id Yes GlobalNo
ndb_log_updated_onlyYesYesYes GlobalYes
ndb-mgmd-hostYesYes
ndb-nodeidYesYes YesGlobalNo
Ndb_number_of_data_nodes YesGlobalNo
ndb_optimization_delay Yes GlobalYes
ndb_optimized_node_selectionYesYesYes GlobalNo
Ndb_pushed_queries_defined YesGlobalNo
Ndb_pushed_queries_executed YesGlobalNo
ndb-recv-thread-activation-thresholdYesYes
- Variable: ndb_recv_thread_activation_threshold
ndb_recv_thread_activation_threshold
ndb-recv-thread-cpu-maskYesYes
- Variable: ndb_recv_thread_cpu_mask
ndb_recv_thread_cpu_mask Yes GlobalYes
ndb_report_thresh_binlog_epoch_slipYesYes
ndb_report_thresh_binlog_mem_usageYesYes
Ndb_scan_count YesGlobalNo
ndb_show_foreign_key_mock_tablesYesYesYes GlobalYes
ndb_slave_conflict_roleYesYesYes GlobalYes
Ndb_slave_max_replicated_epoch Yes GlobalNo
ndb_table_no_logging Yes SessionYes
ndb_table_temporary Yes SessionYes
ndb-transid-mysql-connection-mapYes
ndb_use_copying_alter_table Yes BothNo
ndb_use_exact_count Yes BothYes
ndb_use_transactionsYesYesYes BothYes
ndb_version Yes GlobalNo
ndb_version_string Yes GlobalNo
ndb-wait-connectedYesYesYes GlobalNo
ndb-wait-setupYesYesYes GlobalNo
ndbclusterYesYes
- Variable: have_ndbcluster
ndbinfo_database Yes GlobalNo
ndbinfo_max_bytesYes Yes BothYes
ndbinfo_max_rowsYes Yes BothYes
ndbinfo_offline Yes GlobalYes
ndbinfo_show_hiddenYes Yes BothYes
ndbinfo_table_prefixYes Yes BothYes
ndbinfo_version Yes GlobalNo
net_buffer_lengthYesYesYes BothYes
net_read_timeoutYesYesYes BothYes
net_retry_countYesYesYes BothYes
net_write_timeoutYesYesYes BothYes
newYesYesYes BothYes
ngram_token_sizeYesYesYes GlobalNo
no-defaultsYes
Not_flushed_delayed_rows YesGlobalNo
offline_modeYesYesYes GlobalYes
oldYesYesYes GlobalNo
old-alter-tableYesYes BothYes
- Variable: old_alter_table Yes BothYes
old_passwords Yes BothYes
old-style-user-limitsYesYes
Ongoing_anonymous_gtid_violating_transaction_count YesGlobalNo
Ongoing_anonymous_transaction_count YesGlobalNo
Ongoing_automatic_gtid_violating_transaction_count YesGlobalNo
Open_files YesGlobalNo
open-files-limitYesYes GlobalNo
- Variable: open_files_limit Yes GlobalNo
Open_streams YesGlobalNo
Open_table_definitions YesGlobalNo
Open_tables YesBothNo
Opened_files YesGlobalNo
Opened_table_definitions YesBothNo
Opened_tables YesBothNo
optimizer_prune_levelYesYesYes BothYes
optimizer_search_depthYesYesYes BothYes
optimizer_switchYesYesYes BothYes
optimizer_trace Yes BothYes
optimizer_trace_features Yes BothYes
optimizer_trace_limit Yes BothYes
optimizer_trace_max_mem_size Yes BothYes
optimizer_trace_offset Yes BothYes
parser_max_mem_sizeYesYesYes BothYes
partitionYesYes
- Variable: have_partitioning
performance_schemaYesYesYes GlobalNo
Performance_schema_accounts_lost YesGlobalNo
performance_schema_accounts_sizeYesYesYes GlobalNo
Performance_schema_cond_classes_lost YesGlobalNo
Performance_schema_cond_instances_lost YesGlobalNo
performance-schema-consumer-events-stages-currentYesYes
performance-schema-consumer-events-stages-historyYesYes
performance-schema-consumer-events-stages-history-longYesYes
performance-schema-consumer-events-statements-currentYesYes
performance-schema-consumer-events-statements-historyYesYes
performance-schema-consumer-events-statements-history-longYesYes
performance-schema-consumer-events-transactions-currentYesYes
performance-schema-consumer-events-transactions-historyYesYes
performance-schema-consumer-events-transactions-history-longYesYes
performance-schema-consumer-events-waits-currentYesYes
performance-schema-consumer-events-waits-historyYesYes
performance-schema-consumer-events-waits-history-longYesYes
performance-schema-consumer-global-instrumentationYesYes
performance-schema-consumer-statements-digestYesYes
performance-schema-consumer-thread-instrumentationYesYes
Performance_schema_digest_lost YesGlobalNo
performance_schema_digests_sizeYesYesYes GlobalNo
performance_schema_events_stages_history_long_sizeYesYesYes GlobalNo
performance_schema_events_stages_history_sizeYesYesYes GlobalNo
performance_schema_events_statements_history_long_sizeYesYesYes GlobalNo
performance_schema_events_statements_history_sizeYesYesYes GlobalNo
performance_schema_events_transactions_history_long_sizeYesYesYes GlobalNo
performance_schema_events_transactions_history_sizeYesYesYes GlobalNo
performance_schema_events_waits_history_long_sizeYesYesYes GlobalNo
performance_schema_events_waits_history_sizeYesYesYes GlobalNo
Performance_schema_file_classes_lost YesGlobalNo
Performance_schema_file_handles_lost YesGlobalNo
Performance_schema_file_instances_lost YesGlobalNo
Performance_schema_hosts_lost YesGlobalNo
performance_schema_hosts_sizeYesYesYes GlobalNo
Performance_schema_index_stat_lost YesGlobalNo
performance-schema-instrumentYesYes
Performance_schema_locker_lost YesGlobalNo
performance_schema_max_cond_classesYesYesYes GlobalNo
performance_schema_max_cond_instancesYesYesYes GlobalNo
performance_schema_max_digest_lengthYesYesYes GlobalNo
performance_schema_max_file_classesYesYesYes GlobalNo
performance_schema_max_file_handlesYesYesYes GlobalNo
performance_schema_max_file_instancesYesYesYes GlobalNo
performance_schema_max_index_statYesYesYes GlobalNo
performance_schema_max_memory_classesYesYesYes GlobalNo
performance_schema_max_metadata_locksYesYesYes GlobalNo
performance_schema_max_mutex_classesYesYesYes GlobalNo
performance_schema_max_mutex_instancesYesYesYes GlobalNo
performance_schema_max_prepared_statements_instancesYesYesYes GlobalNo
performance_schema_max_program_instancesYesYesYes GlobalNo
performance_schema_max_rwlock_classesYesYesYes GlobalNo
performance_schema_max_rwlock_instancesYesYesYes GlobalNo
performance_schema_max_socket_classesYesYesYes GlobalNo
performance_schema_max_socket_instancesYesYesYes GlobalNo
performance_schema_max_sql_text_lengthYesYesYes GlobalNo
performance_schema_max_stage_classesYesYesYes GlobalNo
performance_schema_max_statement_classesYesYesYes GlobalNo
performance_schema_max_statement_stackYesYesYes GlobalNo
performance_schema_max_table_handlesYesYesYes GlobalNo
performance_schema_max_table_instancesYesYesYes GlobalNo
performance_schema_max_table_lock_statYesYesYes GlobalNo
performance_schema_max_thread_classesYesYesYes GlobalNo
performance_schema_max_thread_instancesYesYesYes GlobalNo
Performance_schema_memory_classes_lost YesGlobalNo
Performance_schema_metadata_lock_lost YesGlobalNo
Performance_schema_mutex_classes_lost YesGlobalNo
Performance_schema_mutex_instances_lost YesGlobalNo
Performance_schema_nested_statement_lost YesGlobalNo
Performance_schema_prepared_statements_lost YesGlobalNo
Performance_schema_program_lost YesGlobalNo
Performance_schema_rwlock_classes_lost YesGlobalNo
Performance_schema_rwlock_instances_lost YesGlobalNo
Performance_schema_session_connect_attrs_lost YesGlobalNo
performance_schema_session_connect_attrs_sizeYesYesYes GlobalNo
performance_schema_setup_actors_sizeYesYesYes GlobalNo
performance_schema_setup_objects_sizeYesYesYes GlobalNo
Performance_schema_socket_classes_lost YesGlobalNo
Performance_schema_socket_instances_lost YesGlobalNo
Performance_schema_stage_classes_lost YesGlobalNo
Performance_schema_statement_classes_lost YesGlobalNo
Performance_schema_table_handles_lost YesGlobalNo
Performance_schema_table_instances_lost YesGlobalNo
Performance_schema_table_lock_stat_lost YesGlobalNo
Performance_schema_thread_classes_lost YesGlobalNo
Performance_schema_thread_instances_lost YesGlobalNo
Performance_schema_users_lost YesGlobalNo
performance_schema_users_sizeYesYesYes GlobalNo
pid-fileYesYes GlobalNo
- Variable: pid_file Yes GlobalNo
pluginYesYes
plugin_dirYesYesYes GlobalNo
plugin-loadYesYes
plugin-load-addYesYes
portYesYesYes GlobalNo
port-open-timeoutYesYes
preload_buffer_sizeYesYesYes BothYes
Prepared_stmt_count YesGlobalNo
print-defaultsYes
profiling Yes BothYes
profiling_history_sizeYesYesYes BothYes
protocol_version Yes GlobalNo
proxy_user Yes SessionNo
pseudo_slave_mode Yes SessionYes
pseudo_thread_id Yes SessionYes
Qcache_free_blocks YesGlobalNo
Qcache_free_memory YesGlobalNo
Qcache_hits YesGlobalNo
Qcache_inserts YesGlobalNo
Qcache_lowmem_prunes YesGlobalNo
Qcache_not_cached YesGlobalNo
Qcache_queries_in_cache YesGlobalNo
Qcache_total_blocks YesGlobalNo
Queries YesBothNo
query_alloc_block_sizeYesYesYes BothYes
query_cache_limitYesYesYes GlobalYes
query_cache_min_res_unitYesYesYes GlobalYes
query_cache_sizeYesYesYes GlobalYes
query_cache_typeYesYesYes BothYes
query_cache_wlock_invalidateYesYesYes BothYes
query_prealloc_sizeYesYesYes BothYes
Questions YesBothNo
rand_seed1 Yes SessionYes
rand_seed2 Yes SessionYes
range_alloc_block_sizeYesYesYes BothYes
range_optimizer_max_mem_sizeYesYesYes BothYes
rbr_exec_mode Yes SessionYes
read_buffer_sizeYesYesYes BothYes
read_onlyYesYesYes GlobalYes
read_rnd_buffer_sizeYesYesYes BothYes
relay-logYesYes GlobalNo
- Variable: relay_log Yes GlobalNo
relay_log_basename Yes GlobalNo
relay-log-indexYesYes GlobalNo
- Variable: relay_log_index Yes GlobalNo
relay_log_indexYesYesYes GlobalNo
relay-log-info-fileYesYes
- Variable: relay_log_info_file
relay_log_info_fileYesYesYes GlobalNo
relay-log-info-repositoryYesYes
- Variable: relay_log_info_repository
relay_log_info_repository Yes GlobalYes
relay_log_purgeYesYesYes GlobalYes
relay-log-recoveryYesYes
- Variable: relay_log_recovery
relay_log_recoveryYesYesYes GlobalNo
relay_log_space_limitYesYesYes GlobalNo
removeYes
replicate-do-dbYesYes
replicate-do-tableYesYes
replicate-ignore-dbYesYes
replicate-ignore-tableYesYes
replicate-rewrite-dbYesYes
replicate-same-server-idYesYes
replicate-wild-do-tableYesYes
replicate-wild-ignore-tableYesYes
report-hostYesYes GlobalNo
- Variable: report_host Yes GlobalNo
report-passwordYesYes GlobalNo
- Variable: report_password Yes GlobalNo
report-portYesYes GlobalNo
- Variable: report_port Yes GlobalNo
report-userYesYes GlobalNo
- Variable: report_user Yes GlobalNo
require_secure_transportYesYesYes GlobalYes
rewriter_enabled Yes GlobalYes
Rewriter_number_loaded_rules YesGlobalNo
Rewriter_number_reloads YesGlobalNo
Rewriter_number_rewritten_queries YesGlobalNo
Rewriter_reload_error YesGlobalNo
rewriter_verbose Yes GlobalYes
Rpl_semi_sync_master_clients YesGlobalNo
rpl_semi_sync_master_enabled Yes GlobalYes
Rpl_semi_sync_master_net_avg_wait_time YesGlobalNo
Rpl_semi_sync_master_net_wait_time YesGlobalNo
Rpl_semi_sync_master_net_waits YesGlobalNo
Rpl_semi_sync_master_no_times YesGlobalNo
Rpl_semi_sync_master_no_tx YesGlobalNo
Rpl_semi_sync_master_status YesGlobalNo
Rpl_semi_sync_master_timefunc_failures YesGlobalNo
rpl_semi_sync_master_timeout Yes GlobalYes
rpl_semi_sync_master_trace_level Yes GlobalYes
Rpl_semi_sync_master_tx_avg_wait_time YesGlobalNo
Rpl_semi_sync_master_tx_wait_time YesGlobalNo
Rpl_semi_sync_master_tx_waits YesGlobalNo
rpl_semi_sync_master_wait_for_slave_count Yes GlobalYes
rpl_semi_sync_master_wait_no_slave Yes GlobalYes
rpl_semi_sync_master_wait_point Yes GlobalYes
Rpl_semi_sync_master_wait_pos_backtraverse YesGlobalNo
Rpl_semi_sync_master_wait_sessions YesGlobalNo
Rpl_semi_sync_master_yes_tx YesGlobalNo
rpl_semi_sync_slave_enabled Yes GlobalYes
Rpl_semi_sync_slave_status YesGlobalNo
rpl_semi_sync_slave_trace_level Yes GlobalYes
rpl_stop_slave_timeoutYesYesYes GlobalYes
Rsa_public_key YesGlobalNo
safe-user-createYesYes
secure-authYesYes GlobalYes
- Variable: secure_auth Yes GlobalYes
secure-file-privYesYes GlobalNo
- Variable: secure_file_priv Yes GlobalNo
Select_full_join YesBothNo
Select_full_range_join YesBothNo
Select_range YesBothNo
Select_range_check YesBothNo
Select_scan YesBothNo
server-idYesYes GlobalYes
- Variable: server_id Yes GlobalYes
server-id-bitsYesYes GlobalNo
- Variable: server_id_bits Yes GlobalNo
server_id_bitsYesYesYes GlobalNo
server_uuid Yes GlobalNo
session_track_gtidsYesYesYes BothYes
session_track_schemaYesYesYes BothYes
session_track_state_changeYesYesYes BothYes
session_track_system_variablesYesYesYes BothYes
sha256_password_auto_generate_rsa_keysYesYesYes GlobalNo
sha256_password_private_key_path Yes GlobalNo
sha256_password_proxy_usersYesYesYes GlobalYes
sha256_password_public_key_path Yes GlobalNo
shared_memoryYesYesYes GlobalNo
shared_memory_base_nameYesYesYes GlobalNo
show_compatibility_56YesYesYes GlobalYes
show_old_temporalsYesYesYes BothYes
show-slave-auth-infoYesYes
simplified_binlog_gtid_recoveryYesYesYes GlobalNo
skip-character-set-client-handshakeYesYes
skip-concurrent-insertYesYes
- Variable: concurrent_insert
skip-event-schedulerYesYes
skip_external_lockingYesYesYes GlobalNo
skip-grant-tablesYesYes
skip-host-cacheYesYes
skip-name-resolveYesYes GlobalNo
- Variable: skip_name_resolve Yes GlobalNo
skip-ndbclusterYesYes
skip-networkingYesYes GlobalNo
- Variable: skip_networking Yes GlobalNo
skip-newYesYes
skip-partitionYesYes
skip-show-databaseYesYes GlobalNo
- Variable: skip_show_database Yes GlobalNo
skip-slave-startYesYes
skip-sslYesYes
skip-stack-traceYesYes
skip-symbolic-linksYes
slave_allow_batchingYesYesYes GlobalYes
slave-checkpoint-groupYesYes
- Variable: slave_checkpoint_group
slave_checkpoint_groupYesYesYes GlobalYes
slave-checkpoint-periodYesYes
- Variable: slave_checkpoint_period
slave_checkpoint_periodYesYesYes GlobalYes
slave_compressed_protocolYesYesYes GlobalYes
slave_exec_modeYesYesYes GlobalYes
Slave_heartbeat_period YesGlobalNo
Slave_last_heartbeat YesGlobalNo
slave-load-tmpdirYesYes GlobalNo
- Variable: slave_load_tmpdir Yes GlobalNo
slave-max-allowed-packetYesYes
- Variable: slave_max_allowed_packet
slave_max_allowed_packet Yes GlobalYes
slave-net-timeoutYesYes GlobalYes
- Variable: slave_net_timeout Yes GlobalYes
Slave_open_temp_tables YesGlobalNo
slave-parallel-typeYesYes
- Variable: slave_parallel_type
slave_parallel_type Yes GlobalYes
slave-parallel-workersYesYes
- Variable: slave_parallel_workers
slave_parallel_workersYes Yes GlobalYes
slave-pending-jobs-size-maxYes
- Variable: slave_pending_jobs_size_max
slave_pending_jobs_size_max Yes GlobalYes
slave_preserve_commit_orderYes Yes GlobalYes
Slave_received_heartbeats YesGlobalNo
Slave_retried_transactions YesGlobalNo
slave-rows-search-algorithmsYesYes
- Variable: slave_rows_search_algorithms
slave_rows_search_algorithms Yes GlobalYes
Slave_running YesGlobalNo
slave-skip-errorsYesYes GlobalNo
- Variable: slave_skip_errors Yes GlobalNo
slave-sql-verify-checksumYesYes
slave_sql_verify_checksum Yes GlobalYes
slave_transaction_retriesYesYesYes GlobalYes
slave_type_conversionsYesYesYes GlobalNo
Slow_launch_threads YesBothNo
slow_launch_timeYesYesYes GlobalYes
Slow_queries YesBothNo
slow-query-logYesYes GlobalYes
- Variable: slow_query_log Yes GlobalYes
slow_query_log_fileYesYesYes GlobalYes
slow-start-timeoutYesYes
socketYesYesYes GlobalNo
sort_buffer_sizeYesYesYes BothYes
Sort_merge_passes YesBothNo
Sort_range YesBothNo
Sort_rows YesBothNo
Sort_scan YesBothNo
sporadic-binlog-dump-failYesYes
sql_auto_is_null Yes BothYes
sql_big_selects Yes BothYes
sql_buffer_result Yes BothYes
sql_log_bin Yes SessionYes
sql_log_off Yes BothYes
sql-modeYesYes BothYes
- Variable: sql_mode Yes BothYes
sql_notes Yes BothYes
sql_quote_show_create Yes BothYes
sql_safe_updates Yes BothYes
sql_select_limit Yes BothYes
sql_slave_skip_counter Yes GlobalYes
sql_warnings Yes BothYes
sslYesYes
Ssl_accept_renegotiates YesGlobalNo
Ssl_accepts YesGlobalNo
ssl-caYesYes GlobalNo
- Variable: ssl_ca Yes GlobalNo
Ssl_callback_cache_hits YesGlobalNo
ssl-capathYesYes GlobalNo
- Variable: ssl_capath Yes GlobalNo
ssl-certYesYes GlobalNo
- Variable: ssl_cert Yes GlobalNo
Ssl_cipher YesBothNo
ssl-cipherYesYes GlobalNo
- Variable: ssl_cipher Yes GlobalNo
Ssl_cipher_list YesBothNo
Ssl_client_connects YesGlobalNo
Ssl_connect_renegotiates YesGlobalNo
ssl-crlYesYes GlobalNo
- Variable: ssl_crl Yes GlobalNo
ssl-crlpathYesYes GlobalNo
- Variable: ssl_crlpath Yes GlobalNo
Ssl_ctx_verify_depth YesGlobalNo
Ssl_ctx_verify_mode YesGlobalNo
Ssl_default_timeout YesBothNo
Ssl_finished_accepts YesGlobalNo
Ssl_finished_connects YesGlobalNo
ssl-keyYesYes GlobalNo
- Variable: ssl_key Yes GlobalNo
Ssl_server_not_after YesBothNo
Ssl_server_not_before YesBothNo
Ssl_session_cache_hits YesGlobalNo
Ssl_session_cache_misses YesGlobalNo
Ssl_session_cache_mode YesGlobalNo
Ssl_session_cache_overflows YesGlobalNo
Ssl_session_cache_size YesGlobalNo
Ssl_session_cache_timeouts YesGlobalNo
Ssl_sessions_reused YesBothNo
Ssl_used_session_cache_entries YesGlobalNo
Ssl_verify_depth YesBothNo
Ssl_verify_mode YesBothNo
Ssl_version YesBothNo
standaloneYesYes
storage_engine Yes BothYes
stored_program_cacheYesYesYes GlobalYes
super-large-pagesYesYes
super_read_onlyYesYesYes GlobalYes
symbolic-linksYesYes
sync_binlogYesYesYes GlobalYes
sync_frmYesYesYes GlobalYes
sync_master_infoYesYesYes GlobalYes
sync_relay_logYesYesYes GlobalYes
sync_relay_log_infoYesYesYes GlobalYes
sysdate-is-nowYesYes
system_time_zone Yes GlobalNo
table_definition_cache Yes GlobalYes
Table_locks_immediate YesGlobalNo
Table_locks_waited YesGlobalNo
table_open_cache Yes GlobalYes
Table_open_cache_hits YesBothNo
table_open_cache_instances Yes GlobalNo
Table_open_cache_misses YesBothNo
Table_open_cache_overflows YesBothNo
tc-heuristic-recoverYesYes
Tc_log_max_pages_used YesGlobalNo
Tc_log_page_size YesGlobalNo
Tc_log_page_waits YesGlobalNo
temp-poolYesYes
thread_cache_sizeYesYesYes GlobalYes
thread_concurrencyYesYesYes GlobalNo
thread_handlingYesYesYes GlobalNo
thread_stackYesYesYes GlobalNo
Threads_cached YesGlobalNo
Threads_connected YesGlobalNo
Threads_created YesGlobalNo
Threads_running YesGlobalNo
time_format Yes GlobalNo
time_zone Yes BothYes
timed_mutexesYesYesYes GlobalYes
timestamp Yes SessionYes
tls_versionYesYesYes GlobalNo
tmp_table_sizeYesYesYes BothYes
tmpdirYesYesYes GlobalNo
transaction_alloc_block_sizeYesYesYes BothYes
transaction_allow_batching Yes SessionYes
transaction-isolationYesYes
- Variable: tx_isolation
transaction_prealloc_sizeYesYesYes BothYes
transaction-read-onlyYesYes
- Variable: tx_read_only
transaction_write_set_extractionYes Yes BothYes
tx_isolation Yes BothYes
tx_read_only Yes BothYes
unique_checks Yes BothYes
updatable_views_with_limitYesYesYes BothYes
Uptime YesGlobalNo
Uptime_since_flush_status YesGlobalNo
userYesYes
validate-passwordYesYes
validate_password_dictionary_file Yes GlobalVaries
validate_password_dictionary_file_last_parsed YesGlobalNo
validate_password_dictionary_file_words_count YesGlobalNo
validate_password_length Yes GlobalYes
validate_password_mixed_case_count Yes GlobalYes
validate_password_number_count Yes GlobalYes
validate_password_policy Yes GlobalYes
validate_password_special_char_count Yes GlobalYes
validate_user_plugins Yes GlobalNo
verboseYesYes
version Yes GlobalNo
version_comment Yes GlobalNo
version_compile_machine Yes GlobalNo
version_compile_os Yes GlobalNo
version_tokens_sessionYesYesYes BothYes
version_tokens_session_numberYesYesYes BothNo
wait_timeoutYesYesYes BothYes
warning_count Yes SessionNo

[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.



User Comments
Sign Up Login You must be logged in to post a comment.