MYSQL 5.7 动态变量和静态可写变量大全 。

在运维和使用mysql 5.7 的时候往往会忽略一些系统变量导致可能需要重新配置。重新启动数据库才可以 。现提供下表供大家使用 ：

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
abort-slave-event-count Yes Yes        
Aborted_clients       Yes Global No
Aborted_connects       Yes Global No
allow-suspicious-udfs Yes Yes        
ansi Yes Yes        
audit-log Yes Yes        
audit_log_buffer_size Yes Yes Yes   Global No
audit_log_compression Yes Yes Yes   Global No
audit_log_connection_policy Yes Yes Yes   Global Yes
audit_log_current_session     Yes   Both No
Audit_log_current_size       Yes Global No
audit_log_encryption Yes Yes Yes   Global No
Audit_log_event_max_drop_size       Yes Global No
Audit_log_events       Yes Global No
Audit_log_events_filtered       Yes Global No
Audit_log_events_lost       Yes Global No
Audit_log_events_written       Yes Global No
audit_log_exclude_accounts Yes Yes Yes   Global Yes
audit_log_file Yes Yes Yes   Global No
audit_log_filter_id     Yes   Both No
audit_log_flush     Yes   Global Yes
audit_log_format Yes Yes Yes   Global No
audit_log_include_accounts Yes Yes Yes   Global Yes
audit_log_policy Yes Yes Yes   Global No
audit_log_read_buffer_size Yes Yes Yes   Varies Varies
audit_log_rotate_on_size Yes Yes Yes   Global Yes
audit_log_statement_policy Yes Yes Yes   Global Yes
audit_log_strategy Yes Yes Yes   Global No
Audit_log_total_size       Yes Global No
Audit_log_write_waits       Yes Global No
authentication_ldap_sasl_auth_method_name Yes Yes Yes   Global Yes
authentication_ldap_sasl_bind_base_dn Yes Yes Yes   Global Yes
authentication_ldap_sasl_bind_root_dn Yes Yes Yes   Global Yes
authentication_ldap_sasl_bind_root_pwd Yes Yes Yes   Global Yes
authentication_ldap_sasl_ca_path Yes Yes Yes   Global Yes
authentication_ldap_sasl_group_search_attr Yes Yes Yes   Global Yes
authentication_ldap_sasl_group_search_filter Yes Yes Yes   Global Yes
authentication_ldap_sasl_init_pool_size Yes Yes Yes   Global Yes
authentication_ldap_sasl_log_status Yes Yes Yes   Global Yes
authentication_ldap_sasl_max_pool_size Yes Yes Yes   Global Yes
authentication_ldap_sasl_server_host Yes Yes Yes   Global Yes
authentication_ldap_sasl_server_port Yes Yes Yes   Global Yes
authentication_ldap_sasl_tls Yes Yes Yes   Global Yes
authentication_ldap_sasl_user_search_attr Yes Yes Yes   Global Yes
authentication_ldap_simple_auth_method_name Yes Yes Yes   Global Yes
authentication_ldap_simple_bind_base_dn Yes Yes Yes   Global Yes
authentication_ldap_simple_bind_root_dn Yes Yes Yes   Global Yes
authentication_ldap_simple_bind_root_pwd Yes Yes Yes   Global Yes
authentication_ldap_simple_ca_path Yes Yes Yes   Global Yes
authentication_ldap_simple_group_search_attr Yes Yes Yes   Global Yes
authentication_ldap_simple_group_search_filter Yes Yes Yes   Global Yes
authentication_ldap_simple_init_pool_size Yes Yes Yes   Global Yes
authentication_ldap_simple_log_status Yes Yes Yes   Global Yes
authentication_ldap_simple_max_pool_size Yes Yes Yes   Global Yes
authentication_ldap_simple_server_host Yes Yes Yes   Global Yes
authentication_ldap_simple_server_port Yes Yes Yes   Global Yes
authentication_ldap_simple_tls Yes Yes Yes   Global Yes
authentication_ldap_simple_user_search_attr Yes Yes Yes   Global Yes
authentication_windows_log_level Yes Yes Yes   Global No
authentication_windows_use_principal_name Yes Yes Yes   Global No
auto_generate_certs Yes Yes Yes   Global No
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 Yes Yes   Global Yes
avoid_temporal_upgrade Yes Yes Yes   Global Yes
back_log Yes Yes Yes   Global No
basedir Yes Yes Yes   Global No
big_tables Yes Yes 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 Yes Yes   Global Yes
binlog_direct_non_transactional_updates Yes Yes Yes   Both Yes
binlog-do-db Yes Yes        
binlog_error_action Yes Yes Yes   Global Yes
binlog_format Yes Yes Yes   Both Yes
binlog_group_commit_sync_delay Yes Yes Yes   Global Yes
binlog_group_commit_sync_no_delay_count Yes Yes Yes   Global Yes
binlog_gtid_simple_recovery Yes Yes Yes   Global No
binlog-ignore-db Yes Yes        
binlog_max_flush_queue_time Yes Yes Yes   Global Yes
binlog_order_commits Yes Yes Yes   Global Yes
binlog-row-event-max-size Yes Yes        
binlog_row_image Yes Yes Yes   Both Yes
binlog_rows_query_log_events Yes Yes Yes   Both Yes
Binlog_stmt_cache_disk_use       Yes Global No
binlog_stmt_cache_size Yes Yes Yes   Global Yes
Binlog_stmt_cache_use       Yes Global No
binlog_transaction_dependency_history_size Yes Yes Yes   Global Yes
binlog_transaction_dependency_tracking Yes Yes Yes   Global Yes
block_encryption_mode Yes Yes Yes   Both Yes
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 (note 1)     Yes   Both Yes
character_set_filesystem Yes Yes Yes   Both Yes
character_set_results     Yes   Both Yes
character_set_server Yes Yes Yes   Both Yes
character_set_system     Yes   Global No
character_sets_dir Yes Yes Yes   Global No
check_proxy_users Yes Yes Yes   Global Yes
chroot Yes Yes        
collation_connection     Yes   Both Yes
collation_database (note 1)     Yes   Both Yes
collation_server Yes Yes 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_alter_user       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_change_repl_filter       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_explain_other       Yes Both No
Com_flush       Yes Both No
Com_get_diagnostics       Yes Both No
Com_grant       Yes Both No
Com_group_replication_start       Yes Global No
Com_group_replication_stop       Yes Global 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_create_user       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_master_status       Yes Both No
Com_show_ndb_status       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_shutdown       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_control_delay_generated       Yes Global No
connection_control_failed_connections_threshold Yes Yes Yes   Global Yes
connection_control_max_connection_delay Yes Yes Yes   Global Yes
connection_control_min_connection_delay 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_address       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        
core_file     Yes   Global No
Created_tmp_disk_tables       Yes Both No
Created_tmp_files       Yes Global No
Created_tmp_tables       Yes Both No
daemon_memcached_enable_binlog Yes Yes Yes   Global No
daemon_memcached_engine_lib_name Yes Yes Yes   Global No
daemon_memcached_engine_lib_path Yes Yes Yes   Global No
daemon_memcached_option Yes Yes Yes   Global No
daemon_memcached_r_batch_size Yes Yes Yes   Global No
daemon_memcached_w_batch_size Yes Yes Yes   Global No
daemonize Yes Yes        
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_authentication_plugin Yes Yes Yes   Global No
default_password_lifetime Yes Yes Yes   Global Yes
default_storage_engine Yes Yes 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 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        
disable-partition-engine-check Yes Yes        
disabled_storage_engines Yes Yes Yes   Global No
disconnect_on_expired_password Yes Yes Yes   Global No
disconnect-slave-event-count Yes Yes        
div_precision_increment Yes Yes Yes   Both Yes
early-plugin-load Yes Yes        
end_markers_in_json Yes Yes Yes   Both Yes
enforce_gtid_consistency Yes Yes Yes   Global Varies
eq_range_index_dive_limit Yes Yes Yes   Both Yes
error_count     Yes   Session No
event_scheduler Yes Yes Yes   Global Yes
exit-info Yes Yes        
expire_logs_days Yes Yes Yes   Global Yes
explicit_defaults_for_timestamp Yes Yes Yes   Both Yes
external-locking Yes Yes        
- Variable: skip_external_locking            
external_user     Yes   Session No
federated Yes Yes        
Firewall_access_denied       Yes Global No
Firewall_access_granted       Yes Global No
Firewall_cached_entries       Yes Global No
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 Yes   Global Yes
general_log_file Yes Yes Yes   Global Yes
group_concat_max_len Yes Yes Yes   Both Yes
group_replication_allow_local_disjoint_gtids_join Yes Yes Yes   Global Yes
group_replication_allow_local_lower_version_join Yes Yes Yes   Global Yes
group_replication_auto_increment_increment Yes Yes Yes   Global Yes
group_replication_bootstrap_group Yes Yes Yes   Global Yes
group_replication_components_stop_timeout Yes Yes Yes   Global Yes
group_replication_compression_threshold Yes Yes Yes   Global Yes
group_replication_enforce_update_everywhere_checks Yes Yes Yes   Global Yes
group_replication_exit_state_action Yes Yes Yes   Global Yes
group_replication_flow_control_applier_threshold Yes Yes Yes   Global Yes
group_replication_flow_control_certifier_threshold Yes Yes Yes   Global Yes
group_replication_flow_control_mode Yes Yes Yes   Global Yes
group_replication_force_members Yes Yes Yes   Global Yes
group_replication_group_name Yes Yes Yes   Global Yes
group_replication_group_seeds Yes Yes Yes   Global Yes
group_replication_gtid_assignment_block_size Yes Yes Yes   Global Yes
group_replication_ip_whitelist Yes Yes Yes   Global Yes
group_replication_local_address Yes Yes Yes   Global Yes
group_replication_member_weight Yes Yes Yes   Global Yes
group_replication_poll_spin_loops Yes Yes Yes   Global Yes
group_replication_primary_member       Yes Global No
group_replication_recovery_complete_at Yes Yes Yes   Global Yes
group_replication_recovery_reconnect_interval Yes Yes Yes   Global Yes
group_replication_recovery_retry_count Yes Yes Yes   Global Yes
group_replication_recovery_ssl_ca Yes Yes Yes   Global Yes
group_replication_recovery_ssl_capath Yes Yes Yes   Global Yes
group_replication_recovery_ssl_cert Yes Yes Yes   Global Yes
group_replication_recovery_ssl_cipher Yes Yes Yes   Global Yes
group_replication_recovery_ssl_crl Yes Yes Yes   Global Yes
group_replication_recovery_ssl_crlpath Yes Yes Yes   Global Yes
group_replication_recovery_ssl_key Yes Yes Yes   Global Yes
group_replication_recovery_ssl_verify_server_cert Yes Yes Yes   Global Yes
group_replication_recovery_use_ssl Yes Yes Yes   Global Yes
group_replication_single_primary_mode Yes Yes Yes   Global Yes
group_replication_ssl_mode Yes Yes Yes   Global Yes
group_replication_start_on_boot Yes Yes Yes   Global Yes
group_replication_transaction_size_limit Yes Yes Yes   Global Yes
group_replication_unreachable_majority_timeout Yes Yes Yes   Global Yes
gtid_executed     Yes   Varies No
gtid_executed_compression_period Yes Yes Yes   Global Yes
gtid_mode Yes Yes Yes   Global Varies
gtid_next     Yes   Session Yes
gtid_owned     Yes   Both No
gtid_purged     Yes   Global Yes
Handler_commit       Yes Both No
Handler_delete       Yes Both No
Handler_discover       Yes Both No
Handler_external_lock       Yes Both No
Handler_mrr_init       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_dynamic_loading     Yes   Global No
have_geometry     Yes   Global No
have_openssl     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_statement_timeout     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 Yes   Global No
ignore-db-dir Yes Yes        
ignore_db_dirs     Yes   Global No
init_connect Yes Yes Yes   Global Yes
init_file Yes Yes Yes   Global No
init_slave Yes Yes Yes   Global Yes
initialize Yes Yes        
initialize-insecure Yes Yes        
innodb Yes Yes        
innodb_adaptive_flushing Yes Yes Yes   Global Yes
innodb_adaptive_flushing_lwm Yes Yes Yes   Global Yes
innodb_adaptive_hash_index Yes Yes Yes   Global Yes
innodb_adaptive_hash_index_parts Yes Yes Yes   Global No
innodb_adaptive_max_sleep_delay Yes Yes Yes   Global Yes
innodb_api_bk_commit_interval Yes Yes Yes   Global Yes
innodb_api_disable_rowlock Yes Yes Yes   Global No
innodb_api_enable_binlog Yes Yes Yes   Global No
innodb_api_enable_mdl Yes Yes Yes   Global No
innodb_api_trx_level Yes Yes Yes   Global Yes
innodb_autoextend_increment Yes Yes Yes   Global Yes
innodb_autoinc_lock_mode Yes Yes Yes   Global No
Innodb_available_undo_logs       Yes Global No
innodb_background_drop_list_empty Yes Yes Yes   Global Yes
Innodb_buffer_pool_bytes_data       Yes Global No
Innodb_buffer_pool_bytes_dirty       Yes Global No
innodb_buffer_pool_chunk_size 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_pct 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 No
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_ahead_rnd       Yes Global No
Innodb_buffer_pool_read_requests       Yes Global No
Innodb_buffer_pool_reads       Yes Global No
Innodb_buffer_pool_resize_status       Yes Global No
innodb_buffer_pool_size Yes Yes Yes   Global Varies
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_change_buffering_debug Yes Yes Yes   Global Yes
innodb_checksum_algorithm Yes Yes Yes   Global Yes
innodb_checksums Yes Yes Yes   Global No
innodb_cmp_per_index_enabled Yes Yes Yes   Global Yes
innodb_commit_concurrency Yes Yes Yes   Global Yes
innodb_compress_debug Yes Yes Yes   Global Yes
innodb_compression_failure_threshold_pct Yes Yes Yes   Global Yes
innodb_compression_level Yes Yes Yes   Global Yes
innodb_compression_pad_pct_max 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_deadlock_detect Yes Yes Yes   Global Yes
innodb_default_row_format Yes Yes Yes   Global Yes
innodb_disable_resize_buffer_pool_debug Yes Yes Yes   Global Yes
innodb_disable_sort_file_cache Yes Yes Yes   Global Yes
innodb_doublewrite Yes Yes Yes   Global No
innodb_fast_shutdown Yes Yes Yes   Global Yes
innodb_fil_make_page_dirty_debug 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_fill_factor Yes Yes Yes   Global Yes
innodb_flush_log_at_timeout 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_flush_sync Yes Yes Yes   Global Yes
innodb_flushing_avg_loops 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   Global Yes
innodb_ft_cache_size Yes Yes Yes   Global No
innodb_ft_enable_diag_print Yes Yes Yes   Global Yes
innodb_ft_enable_stopword Yes Yes Yes   Both Yes
innodb_ft_max_token_size Yes Yes Yes   Global No
innodb_ft_min_token_size Yes Yes Yes   Global No
innodb_ft_num_word_optimize Yes Yes Yes   Global Yes
innodb_ft_result_cache_limit Yes Yes Yes   Global Yes
innodb_ft_server_stopword_table Yes Yes Yes   Global Yes
innodb_ft_sort_pll_degree Yes Yes Yes   Global No
innodb_ft_total_cache_size Yes Yes Yes   Global No
innodb_ft_user_stopword_table Yes Yes Yes   Both Yes
Innodb_have_atomic_builtins       Yes Global No
innodb_io_capacity Yes Yes Yes   Global Yes
innodb_io_capacity_max Yes Yes Yes   Global Yes
innodb_large_prefix Yes Yes Yes   Global Yes
innodb_limit_optimistic_insert_debug Yes Yes Yes   Global Yes
innodb_lock_wait_timeout Yes Yes Yes   Both Yes
innodb_locks_unsafe_for_binlog Yes Yes Yes   Global No
innodb_log_buffer_size Yes Yes Yes   Global No
innodb_log_checkpoint_now Yes Yes Yes   Global Yes
innodb_log_checksums Yes Yes Yes   Global Yes
innodb_log_compressed_pages Yes Yes Yes   Global Yes
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_ahead_size Yes Yes Yes   Global Yes
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_dirty_pages_pct_lwm Yes Yes Yes   Global Yes
innodb_max_purge_lag Yes Yes Yes   Global Yes
innodb_max_purge_lag_delay Yes Yes Yes   Global Yes
innodb_max_undo_log_size Yes Yes Yes   Global Yes
innodb_merge_threshold_set_all_debug Yes Yes Yes   Global Yes
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_numa_interleave Yes Yes Yes   Global No
innodb_old_blocks_pct Yes Yes Yes   Global Yes
innodb_old_blocks_time Yes Yes Yes   Global Yes
innodb_online_alter_log_max_size 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_cleaners Yes Yes Yes   Global No
Innodb_page_size       Yes Global No
innodb_page_size Yes Yes 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 Yes
innodb_purge_rseg_truncate_frequency Yes Yes Yes   Global Yes
innodb_purge_threads Yes Yes Yes   Global No
innodb_random_read_ahead Yes Yes Yes   Global Yes
innodb_read_ahead_threshold Yes Yes Yes   Global Yes
innodb_read_io_threads Yes Yes Yes   Global No
innodb_read_only 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_saved_page_number_debug Yes Yes Yes   Global Yes
innodb_sort_buffer_size Yes Yes Yes   Global No
innodb_spin_wait_delay Yes Yes Yes   Global Yes
innodb_stats_auto_recalc Yes Yes Yes   Global Yes
innodb_stats_include_delete_marked Yes Yes Yes   Global Yes
innodb_stats_method Yes Yes Yes   Global Yes
innodb_stats_on_metadata Yes Yes Yes   Global Yes
innodb_stats_persistent 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_status_output Yes Yes Yes   Global Yes
innodb_status_output_locks Yes Yes Yes   Global 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_debug Yes Yes Yes   Global No
innodb_sync_spin_loops Yes Yes Yes   Global Yes
innodb_table_locks Yes Yes Yes   Both Yes
innodb_temp_data_file_path Yes Yes Yes   Global No
innodb_thread_concurrency Yes Yes Yes   Global Yes
innodb_thread_sleep_delay Yes Yes Yes   Global Yes
innodb_tmpdir Yes Yes Yes   Both Yes
Innodb_truncated_status_writes       Yes Global No
innodb_trx_purge_view_update_only_debug Yes Yes Yes   Global Yes
innodb_trx_rseg_n_slots_debug Yes Yes Yes   Global Yes
innodb_undo_directory Yes Yes Yes   Global No
innodb_undo_log_truncate Yes Yes Yes   Global Yes
innodb_undo_logs Yes Yes Yes   Global Yes
innodb_undo_tablespaces Yes Yes Yes   Global No
innodb_use_native_aio 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
internal_tmp_disk_storage_engine Yes Yes Yes   Global 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
keyring_aws_cmk_id Yes Yes Yes   Global Yes
keyring_aws_conf_file Yes Yes Yes   Global No
keyring_aws_data_file Yes Yes Yes   Global No
keyring_aws_region Yes Yes Yes   Global Yes
keyring_encrypted_file_data Yes Yes Yes   Global Yes
keyring_encrypted_file_password Yes Yes Yes   Global Yes
keyring_file_data Yes Yes Yes   Global Yes
keyring-migration-destination Yes Yes        
keyring-migration-host Yes Yes        
keyring-migration-password Yes Yes        
keyring-migration-port Yes Yes        
keyring-migration-socket Yes Yes        
keyring-migration-source Yes Yes        
keyring-migration-user Yes Yes        
keyring_okv_conf_dir Yes Yes Yes   Global Yes
keyring_operations     Yes   Global Yes
language Yes Yes Yes   Global No
large_files_support     Yes   Global No
large_page_size     Yes   Global No
large_pages Yes Yes 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 Yes   Both Yes
lc_messages_dir Yes Yes Yes   Global No
lc_time_names Yes Yes Yes   Both Yes
license     Yes   Global No
local_infile Yes Yes Yes   Global Yes
local-service Yes          
lock_wait_timeout Yes Yes Yes   Both Yes
Locked_connects       Yes Global No
locked_in_memory     Yes   Global No
log-bin Yes Yes        
log_bin     Yes   Global No
log_bin_basename     Yes   Global No
log_bin_index Yes Yes Yes   Global No
log_bin_trust_function_creators Yes Yes Yes   Global Yes
log_bin_use_v1_row_events Yes Yes Yes   Global No
log_builtin_as_identified_by_password Yes Yes Yes   Global Yes
log_error Yes Yes Yes   Global No
log_error_verbosity Yes Yes Yes   Global Yes
log-isam Yes Yes        
log_output Yes Yes Yes   Global Yes
log_queries_not_using_indexes Yes Yes Yes   Global Yes
log-raw Yes Yes        
log-short-format Yes Yes        
log_slave_updates Yes Yes Yes   Global No
log_slow_admin_statements Yes Yes Yes   Global Yes
log_slow_slave_statements Yes Yes Yes   Global Yes
log_statements_unsafe_for_binlog Yes Yes Yes   Global Yes
log_syslog Yes Yes Yes   Global Yes
log_syslog_facility Yes Yes Yes   Global Yes
log_syslog_include_pid Yes Yes Yes   Global Yes
log_syslog_tag Yes Yes Yes   Global Yes
log-tc Yes Yes        
log-tc-size Yes Yes        
log_throttle_queries_not_using_indexes Yes Yes Yes   Global Yes
log_timestamps Yes Yes Yes   Global Yes
log_warnings Yes Yes Yes   Global Yes
long_query_time Yes Yes Yes   Both Yes
low_priority_updates Yes Yes Yes   Both Yes
lower_case_file_system     Yes   Global No
lower_case_table_names Yes Yes Yes   Global No
master-info-file Yes Yes        
master_info_repository Yes Yes Yes   Global Yes
master-retry-count Yes Yes        
master_verify_checksum Yes Yes Yes   Global Yes
max_allowed_packet Yes Yes Yes   Both 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_digest_length Yes Yes Yes   Global No
max_error_count Yes Yes Yes   Both Yes
max_execution_time Yes Yes Yes   Both Yes
Max_execution_time_exceeded       Yes Both No
Max_execution_time_set       Yes Both No
Max_execution_time_set_failed       Yes Both No
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_points_in_geometry 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   Both Yes
Max_used_connections       Yes Global No
Max_used_connections_time       Yes Global No
max_user_connections Yes Yes Yes   Both Yes
max_write_lock_count Yes Yes Yes   Global Yes
mecab_charset       Yes Global No
mecab_rc_file Yes Yes Yes   Global No
memlock Yes Yes        
- Variable: locked_in_memory            
metadata_locks_cache_size Yes Yes Yes   Global No
metadata_locks_hash_instances Yes Yes Yes   Global No
min_examined_row_limit Yes Yes Yes   Both Yes
multi_range_count 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 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
mysql_firewall_mode Yes Yes Yes   Global Yes
mysql_firewall_trace Yes Yes Yes   Global Yes
mysql_native_password_proxy_users Yes Yes Yes   Global Yes
mysqlx Yes Yes        
Mysqlx_address       Yes Global No
mysqlx_bind_address Yes Yes Yes   Global No
Mysqlx_bytes_received       Yes Both No
Mysqlx_bytes_sent       Yes Both No
mysqlx_connect_timeout Yes Yes Yes   Global Yes
Mysqlx_connection_accept_errors       Yes Both No
Mysqlx_connection_errors       Yes Both No
Mysqlx_connections_accepted       Yes Global No
Mysqlx_connections_closed       Yes Global No
Mysqlx_connections_rejected       Yes Global No
Mysqlx_crud_create_view       Yes Both No
Mysqlx_crud_delete       Yes Both No
Mysqlx_crud_drop_view       Yes Both No
Mysqlx_crud_find       Yes Both No
Mysqlx_crud_insert       Yes Both No
Mysqlx_crud_modify_view       Yes Both No
Mysqlx_crud_update       Yes Both No
Mysqlx_errors_sent       Yes Both No
Mysqlx_errors_unknown_message_type       Yes Both No
Mysqlx_expect_close       Yes Both No
Mysqlx_expect_open       Yes Both No
mysqlx_idle_worker_thread_timeout Yes Yes Yes   Global Yes
Mysqlx_init_error       Yes Both No
mysqlx_max_allowed_packet Yes Yes Yes   Global Yes
mysqlx_max_connections Yes Yes Yes   Global Yes
mysqlx_min_worker_threads Yes Yes Yes   Global Yes
Mysqlx_notice_other_sent       Yes Both No
Mysqlx_notice_warning_sent       Yes Both No
Mysqlx_port       Yes Global No
mysqlx_port Yes Yes Yes   Global No
mysqlx_port_open_timeout Yes Yes Yes   Global No
Mysqlx_rows_sent       Yes Both No
Mysqlx_sessions       Yes Global No
Mysqlx_sessions_accepted       Yes Global No
Mysqlx_sessions_closed       Yes Global No
Mysqlx_sessions_fatal_error       Yes Global No
Mysqlx_sessions_killed       Yes Global No
Mysqlx_sessions_rejected       Yes Global No
Mysqlx_socket       Yes Global No
mysqlx_socket Yes Yes Yes   Global No
Mysqlx_ssl_accept_renegotiates       Yes Global No
Mysqlx_ssl_accepts       Yes Global No
Mysqlx_ssl_active       Yes Both No
mysqlx_ssl_ca Yes Yes Yes   Global No
mysqlx_ssl_capath Yes Yes Yes   Global No
mysqlx_ssl_cert Yes Yes Yes   Global No
Mysqlx_ssl_cipher       Yes Both No
mysqlx_ssl_cipher Yes Yes Yes   Global No
Mysqlx_ssl_cipher_list       Yes Both No
mysqlx_ssl_crl Yes Yes Yes   Global No
mysqlx_ssl_crlpath Yes Yes Yes   Global No
Mysqlx_ssl_ctx_verify_depth       Yes Both No
Mysqlx_ssl_ctx_verify_mode       Yes Both No
Mysqlx_ssl_finished_accepts       Yes Global No
mysqlx_ssl_key Yes Yes Yes   Global No
Mysqlx_ssl_server_not_after       Yes Global No
Mysqlx_ssl_server_not_before       Yes Global No
Mysqlx_ssl_verify_depth       Yes Global No
Mysqlx_ssl_verify_mode       Yes Global No
Mysqlx_ssl_version       Yes Both No
Mysqlx_stmt_create_collection       Yes Both No
Mysqlx_stmt_create_collection_index       Yes Both No
Mysqlx_stmt_disable_notices       Yes Both No
Mysqlx_stmt_drop_collection       Yes Both No
Mysqlx_stmt_drop_collection_index       Yes Both No
Mysqlx_stmt_enable_notices       Yes Both No
Mysqlx_stmt_ensure_collection       Yes Both No
Mysqlx_stmt_execute_mysqlx       Yes Both No
Mysqlx_stmt_execute_sql       Yes Both No
Mysqlx_stmt_execute_xplugin       Yes Both No
Mysqlx_stmt_kill_client       Yes Both No
Mysqlx_stmt_list_clients       Yes Both No
Mysqlx_stmt_list_notices       Yes Both No
Mysqlx_stmt_list_objects       Yes Both No
Mysqlx_stmt_ping       Yes Both No
Mysqlx_worker_threads       Yes Global No
Mysqlx_worker_threads_active       Yes Global No
named_pipe Yes Yes Yes   Global No
named_pipe_full_access_group Yes Yes Yes   Global No
ndb_allow_copying_alter_table Yes Yes Yes   Both Yes
Ndb_api_adaptive_send_deferred_count       Yes Global No
Ndb_api_adaptive_send_deferred_count_session       Yes Global No
Ndb_api_adaptive_send_deferred_count_slave       Yes Global No
Ndb_api_adaptive_send_forced_count       Yes Global No
Ndb_api_adaptive_send_forced_count_session       Yes Global No
Ndb_api_adaptive_send_forced_count_slave       Yes Global No
Ndb_api_adaptive_send_unforced_count       Yes Global No
Ndb_api_adaptive_send_unforced_count_session       Yes Global No
Ndb_api_adaptive_send_unforced_count_slave       Yes Global No
Ndb_api_bytes_received_count       Yes Global No
Ndb_api_bytes_received_count_session       Yes Session No
Ndb_api_bytes_received_count_slave       Yes Global No
Ndb_api_bytes_sent_count       Yes Global No
Ndb_api_bytes_sent_count_session       Yes Session No
Ndb_api_bytes_sent_count_slave       Yes Global No
Ndb_api_event_bytes_count       Yes Global No
Ndb_api_event_bytes_count_injector       Yes Global No
Ndb_api_event_data_count       Yes Global No
Ndb_api_event_data_count_injector       Yes Global No
Ndb_api_event_nondata_count       Yes Global No
Ndb_api_event_nondata_count_injector       Yes Global No
Ndb_api_pk_op_count       Yes Global No
Ndb_api_pk_op_count_session       Yes Session No
Ndb_api_pk_op_count_slave       Yes Global No
Ndb_api_pruned_scan_count       Yes Global No
Ndb_api_pruned_scan_count_session       Yes Session No
Ndb_api_pruned_scan_count_slave       Yes Global No
Ndb_api_range_scan_count       Yes Global No
Ndb_api_range_scan_count_session       Yes Session No
Ndb_api_range_scan_count_slave       Yes Global No
Ndb_api_read_row_count       Yes Global No
Ndb_api_read_row_count_session       Yes Session No
Ndb_api_read_row_count_slave       Yes Global No
Ndb_api_scan_batch_count       Yes Global No
Ndb_api_scan_batch_count_session       Yes Session No
Ndb_api_scan_batch_count_slave       Yes Global No
Ndb_api_table_scan_count       Yes Global No
Ndb_api_table_scan_count_session       Yes Session No
Ndb_api_table_scan_count_slave       Yes Global No
Ndb_api_trans_abort_count       Yes Global No
Ndb_api_trans_abort_count_session       Yes Session No
Ndb_api_trans_abort_count_slave       Yes Global No
Ndb_api_trans_close_count       Yes Global No
Ndb_api_trans_close_count_session       Yes Session No
Ndb_api_trans_close_count_slave       Yes Global No
Ndb_api_trans_commit_count       Yes Global No
Ndb_api_trans_commit_count_session       Yes Session No
Ndb_api_trans_commit_count_slave       Yes Global No
Ndb_api_trans_local_read_row_count       Yes Global No
Ndb_api_trans_local_read_row_count_session       Yes Session No
Ndb_api_trans_local_read_row_count_slave       Yes Global No
Ndb_api_trans_start_count       Yes Global No
Ndb_api_trans_start_count_session       Yes Session No
Ndb_api_trans_start_count_slave       Yes Global No
Ndb_api_uk_op_count       Yes Global No
Ndb_api_uk_op_count_session       Yes Session No
Ndb_api_uk_op_count_slave       Yes Global No
Ndb_api_wait_exec_complete_count       Yes Global No
Ndb_api_wait_exec_complete_count_session       Yes Session No
Ndb_api_wait_exec_complete_count_slave       Yes Global No
Ndb_api_wait_meta_request_count       Yes Global No
Ndb_api_wait_meta_request_count_session       Yes Session No
Ndb_api_wait_meta_request_count_slave       Yes Global No
Ndb_api_wait_nanos_count       Yes Global No
Ndb_api_wait_nanos_count_session       Yes Session No
Ndb_api_wait_nanos_count_slave       Yes Global No
Ndb_api_wait_scan_result_count       Yes Global No
Ndb_api_wait_scan_result_count_session       Yes Session No
Ndb_api_wait_scan_result_count_slave       Yes Global No
ndb_autoincrement_prefetch_sz Yes Yes Yes   Both Yes
ndb_batch_size Yes Yes Yes   Global No
ndb_blob_read_batch_bytes Yes Yes Yes   Both Yes
ndb_blob_write_batch_bytes Yes Yes Yes   Both Yes
ndb_cache_check_time Yes Yes Yes   Global Yes
ndb_clear_apply_status Yes   Yes   Global Yes
ndb_cluster_connection_pool Yes Yes Yes   Global No
ndb_cluster_connection_pool_nodeids Yes Yes Yes   Global No
Ndb_cluster_node_id       Yes Global No
Ndb_config_from_host       Yes Both No
Ndb_config_from_port       Yes Both No
Ndb_conflict_fn_epoch       Yes Global No
Ndb_conflict_fn_epoch_trans       Yes Global No
Ndb_conflict_fn_epoch2       Yes Global No
Ndb_conflict_fn_epoch2_trans       Yes Global No
Ndb_conflict_fn_max       Yes Global No
Ndb_conflict_fn_old       Yes Global No
Ndb_conflict_last_conflict_epoch     Yes   Global No
Ndb_conflict_last_stable_epoch       Yes Global No
Ndb_conflict_reflected_op_discard_count       Yes Global No
Ndb_conflict_reflected_op_prepare_count       Yes Global No
Ndb_conflict_refresh_op_count       Yes Global No
Ndb_conflict_trans_conflict_commit_count       Yes Global No
Ndb_conflict_trans_detect_iter_count       Yes Global No
Ndb_conflict_trans_reject_count       Yes Global No
Ndb_conflict_trans_row_conflict_count       Yes Global No
Ndb_conflict_trans_row_reject_count       Yes Global No
ndb-connectstring Yes Yes        
ndb_data_node_neighbour Yes Yes Yes   Global Yes
ndb_default_column_format Yes Yes Yes   Global Yes
ndb_default_column_format Yes Yes Yes   Global Yes
ndb_deferred_constraints Yes Yes Yes   Both Yes
ndb_deferred_constraints Yes Yes Yes   Both Yes
ndb_distribution Yes Yes Yes   Global Yes
ndb_distribution Yes Yes Yes   Global Yes
Ndb_epoch_delete_delete_count       Yes Global No
ndb_eventbuffer_free_percent Yes Yes Yes   Global Yes
ndb_eventbuffer_max_alloc Yes Yes Yes   Global Yes
Ndb_execute_count       Yes Global No
ndb_extra_logging Yes Yes Yes   Global Yes
ndb_force_send Yes Yes Yes   Both Yes
ndb_fully_replicated Yes Yes Yes   Both Yes
ndb_index_stat_enable Yes Yes Yes   Both Yes
ndb_index_stat_option Yes Yes Yes   Both Yes
ndb_join_pushdown     Yes   Both Yes
Ndb_last_commit_epoch_server       Yes Global No
Ndb_last_commit_epoch_session       Yes Session No
ndb_log_apply_status Yes Yes Yes   Global No
ndb_log_apply_status Yes Yes Yes   Global No
ndb_log_bin Yes   Yes   Both Yes
ndb_log_binlog_index Yes   Yes   Global Yes
ndb_log_empty_epochs Yes Yes Yes   Global Yes
ndb_log_empty_epochs Yes Yes Yes   Global Yes
ndb_log_empty_update Yes Yes Yes   Global Yes
ndb_log_empty_update Yes Yes Yes   Global Yes
ndb_log_exclusive_reads Yes Yes Yes   Both Yes
ndb_log_exclusive_reads Yes Yes Yes   Both Yes
ndb_log_fail_terminate Yes Yes Yes   Global No
ndb_log_orig Yes Yes Yes   Global No
ndb_log_orig Yes Yes Yes   Global No
ndb_log_transaction_id Yes Yes Yes   Global No
ndb_log_transaction_id     Yes   Global No
ndb_log_update_as_write Yes Yes Yes   Global Yes
ndb_log_update_minimal Yes Yes Yes   Global Yes
ndb_log_updated_only Yes Yes Yes   Global Yes
ndb-mgmd-host Yes Yes        
ndb_nodeid Yes Yes   Yes Global No
Ndb_number_of_data_nodes       Yes Global No
ndb_optimization_delay Yes Yes Yes   Global Yes
ndb_optimized_node_selection Yes Yes Yes   Global No
Ndb_pruned_scan_count       Yes Global No
Ndb_pushed_queries_defined       Yes Global No
Ndb_pushed_queries_dropped       Yes Global No
Ndb_pushed_queries_executed       Yes Global No
Ndb_pushed_reads       Yes Global No
ndb_read_backup Yes Yes Yes   Global Yes
ndb_recv_thread_activation_threshold Yes Yes Yes   Global Yes
ndb_recv_thread_cpu_mask Yes Yes Yes   Global Yes
ndb_report_thresh_binlog_epoch_slip Yes Yes Yes   Global Yes
ndb_report_thresh_binlog_mem_usage Yes Yes Yes   Global Yes
ndb_row_checksum     Yes   Both Yes
Ndb_scan_count       Yes Global No
ndb_show_foreign_key_mock_tables Yes Yes Yes   Global Yes
ndb_slave_conflict_role Yes Yes Yes   Global Yes
Ndb_slave_max_replicated_epoch     Yes   Global No
Ndb_system_name     Yes   Global No
ndb_table_no_logging     Yes   Session Yes
ndb_table_temporary     Yes   Session Yes
ndb-transid-mysql-connection-map Yes          
ndb_use_copying_alter_table     Yes   Both No
ndb_use_exact_count     Yes   Both Yes
ndb_use_transactions Yes Yes Yes   Both Yes
ndb_version     Yes   Global No
ndb_version_string     Yes   Global No
ndb_wait_connected Yes Yes Yes   Global No
ndb_wait_setup Yes Yes Yes   Global No
ndbcluster Yes Yes        
ndbinfo_database     Yes   Global No
ndbinfo_max_bytes Yes   Yes   Both Yes
ndbinfo_max_rows Yes   Yes   Both Yes
ndbinfo_offline     Yes   Global Yes
ndbinfo_show_hidden Yes   Yes   Both Yes
ndbinfo_table_prefix     Yes   Global No
ndbinfo_version     Yes   Global No
net_buffer_length Yes Yes Yes   Both Yes
net_read_timeout Yes Yes Yes   Both Yes
net_retry_count Yes Yes Yes   Both Yes
net_write_timeout Yes Yes Yes   Both Yes
new Yes Yes Yes   Both Yes
ngram_token_size Yes Yes Yes   Global No
no-defaults Yes          
Not_flushed_delayed_rows       Yes Global No
offline_mode Yes Yes Yes   Global Yes
old Yes Yes Yes   Global No
old_alter_table Yes Yes Yes   Both Yes
old_passwords Yes Yes Yes   Both Yes
old-style-user-limits Yes Yes        
Ongoing_anonymous_gtid_violating_transaction_count       Yes Global No
Ongoing_anonymous_transaction_count       Yes Global No
Ongoing_automatic_gtid_violating_transaction_count       Yes Global No
Open_files       Yes Global No
open_files_limit Yes Yes 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_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 Yes Yes   Both Yes
optimizer_trace_features Yes Yes Yes   Both Yes
optimizer_trace_limit Yes Yes Yes   Both Yes
optimizer_trace_max_mem_size Yes Yes Yes   Both Yes
optimizer_trace_offset Yes Yes Yes   Both Yes
parser_max_mem_size Yes Yes Yes   Both Yes
partition Yes Yes        
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-events-stages-current Yes Yes        
performance-schema-consumer-events-stages-history Yes Yes        
performance-schema-consumer-events-stages-history-long Yes Yes        
performance-schema-consumer-events-statements-current Yes Yes        
performance-schema-consumer-events-statements-history Yes Yes        
performance-schema-consumer-events-statements-history-long Yes Yes        
performance-schema-consumer-events-transactions-current Yes Yes        
performance-schema-consumer-events-transactions-history Yes Yes        
performance-schema-consumer-events-transactions-history-long Yes Yes        
performance-schema-consumer-events-waits-current Yes Yes        
performance-schema-consumer-events-waits-history Yes Yes        
performance-schema-consumer-events-waits-history-long Yes Yes        
performance-schema-consumer-global-instrumentation Yes Yes        
performance-schema-consumer-statements-digest Yes Yes        
performance-schema-consumer-thread-instrumentation Yes Yes        
Performance_schema_digest_lost       Yes Global No
performance_schema_digests_size Yes Yes Yes   Global No
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_transactions_history_long_size Yes Yes Yes   Global No
performance_schema_events_transactions_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_index_stat_lost       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_digest_length 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_index_stat Yes Yes Yes   Global No
performance_schema_max_memory_classes Yes Yes Yes   Global No
performance_schema_max_metadata_locks 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_prepared_statements_instances Yes Yes Yes   Global No
performance_schema_max_program_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_sql_text_length 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_statement_stack 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_table_lock_stat 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_memory_classes_lost       Yes Global No
Performance_schema_metadata_lock_lost       Yes Global No
Performance_schema_mutex_classes_lost       Yes Global No
Performance_schema_mutex_instances_lost       Yes Global No
Performance_schema_nested_statement_lost       Yes Global No
Performance_schema_prepared_statements_lost       Yes Global No
Performance_schema_program_lost       Yes Global No
Performance_schema_rwlock_classes_lost       Yes Global No
Performance_schema_rwlock_instances_lost       Yes Global No
Performance_schema_session_connect_attrs_lost       Yes Global No
performance_schema_session_connect_attrs_size Yes Yes 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_table_lock_stat_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 Yes   Global No
plugin_dir Yes Yes Yes   Global No
plugin_load Yes Yes Yes   Global No
plugin_load_add Yes Yes Yes   Global No
plugin-xxx 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_slave_mode     Yes   Session Yes
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
range_optimizer_max_mem_size Yes Yes Yes   Both Yes
rbr_exec_mode     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 Yes   Global No
relay_log_basename     Yes   Global No
relay_log_index Yes Yes Yes   Global No
relay_log_info_file Yes Yes Yes   Global No
relay_log_info_repository Yes Yes Yes   Global Yes
relay_log_purge Yes Yes Yes   Global Yes
relay_log_recovery Yes Yes Yes   Global No
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        
replication_optimize_for_static_plugin_config Yes Yes Yes   Global Yes
replication_sender_observe_commit_only Yes Yes Yes   Global Yes
report_host Yes Yes Yes   Global No
report_password Yes Yes Yes   Global No
report_port Yes Yes Yes   Global No
report_user Yes Yes Yes   Global No
require_secure_transport Yes Yes Yes   Global Yes
rewriter_enabled     Yes   Global Yes
Rewriter_number_loaded_rules       Yes Global No
Rewriter_number_reloads       Yes Global No
Rewriter_number_rewritten_queries       Yes Global No
Rewriter_reload_error       Yes Global No
rewriter_verbose     Yes   Global Yes
Rpl_semi_sync_master_clients       Yes Global No
rpl_semi_sync_master_enabled Yes Yes 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 Yes Yes   Global Yes
rpl_semi_sync_master_trace_level Yes Yes 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_for_slave_count Yes Yes Yes   Global Yes
rpl_semi_sync_master_wait_no_slave Yes Yes Yes   Global Yes
rpl_semi_sync_master_wait_point Yes Yes 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 Yes Yes   Global Yes
Rpl_semi_sync_slave_status       Yes Global No
rpl_semi_sync_slave_trace_level Yes Yes Yes   Global Yes
rpl_stop_slave_timeout Yes Yes Yes   Global Yes
Rsa_public_key       Yes Global No
safe-user-create Yes Yes        
secure_auth Yes Yes Yes   Global Yes
secure_file_priv Yes Yes 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 Yes   Global Yes
server_id_bits Yes Yes Yes   Global No
server_uuid     Yes   Global No
session_track_gtids Yes Yes Yes   Both Yes
session_track_schema Yes Yes Yes   Both Yes
session_track_state_change Yes Yes Yes   Both Yes
session_track_system_variables Yes Yes Yes   Both Yes
session_track_transaction_info Yes Yes Yes   Both Yes
sha256_password_auto_generate_rsa_keys Yes Yes Yes   Global No
sha256_password_private_key_path Yes Yes Yes   Global No
sha256_password_proxy_users Yes Yes Yes   Global Yes
sha256_password_public_key_path Yes Yes Yes   Global No
shared_memory Yes Yes Yes   Global No
shared_memory_base_name Yes Yes Yes   Global No
show_compatibility_56 Yes Yes Yes   Global Yes
show_create_table_verbosity Yes Yes Yes   Both Yes
show_old_temporals Yes Yes Yes   Both Yes
show-slave-auth-info Yes Yes        
skip-character-set-client-handshake Yes Yes        
skip_external_locking Yes Yes Yes   Global No
skip-grant-tables Yes Yes        
skip-host-cache Yes Yes        
skip_name_resolve Yes Yes Yes   Global No
skip-ndbcluster Yes Yes        
skip_networking Yes Yes Yes   Global No
skip-new Yes Yes        
skip-partition Yes Yes        
skip_show_database Yes Yes Yes   Global No
skip-slave-start Yes Yes        
skip-ssl Yes Yes        
skip-stack-trace Yes Yes        
slave_allow_batching Yes Yes Yes   Global Yes
slave_checkpoint_group Yes Yes Yes   Global Yes
slave_checkpoint_period Yes Yes Yes   Global Yes
slave_compressed_protocol Yes Yes Yes   Global Yes
slave_exec_mode Yes Yes Yes   Global Yes
Slave_heartbeat_period       Yes Global No
Slave_last_heartbeat       Yes Global No
slave_load_tmpdir Yes Yes Yes   Global No
slave_max_allowed_packet Yes Yes Yes   Global Yes
slave_net_timeout Yes Yes Yes   Global Yes
Slave_open_temp_tables       Yes Global No
slave_parallel_type Yes Yes Yes   Global Yes
slave_parallel_workers Yes Yes Yes   Global Yes
slave_pending_jobs_size_max Yes Yes Yes   Global Yes
slave_preserve_commit_order Yes Yes Yes   Global Yes
Slave_received_heartbeats       Yes Global No
Slave_retried_transactions       Yes Global No
Slave_rows_last_search_algorithm_used       Yes Global No
slave_rows_search_algorithms Yes Yes Yes   Global Yes
Slave_running       Yes Global No
slave_skip_errors Yes Yes Yes   Global No
slave-sql-verify-checksum Yes Yes        
slave_sql_verify_checksum Yes Yes Yes   Global Yes
slave_transaction_retries Yes Yes Yes   Global Yes
slave_type_conversions Yes Yes Yes   Global Yes
Slow_launch_threads       Yes Both No
slow_launch_time Yes Yes Yes   Global Yes
Slow_queries       Yes Both No
slow_query_log Yes Yes 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_buffer_result     Yes   Both Yes
sql_log_bin     Yes   Session Yes
sql_log_off     Yes   Both Yes
sql_mode Yes Yes 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 Yes   Global No
Ssl_callback_cache_hits       Yes Global No
ssl_capath Yes Yes Yes   Global No
ssl_cert Yes Yes Yes   Global No
Ssl_cipher       Yes Both No
ssl_cipher Yes Yes Yes   Global No
Ssl_cipher_list       Yes Both No
Ssl_client_connects       Yes Global No
Ssl_connect_renegotiates       Yes Global No
ssl_crl Yes Yes Yes   Global No
ssl_crlpath Yes Yes 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 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_version       Yes Both No
standalone Yes Yes        
stored_program_cache Yes Yes Yes   Global Yes
super-large-pages Yes Yes        
super_read_only Yes Yes Yes   Global 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
Table_open_cache_hits       Yes Both No
table_open_cache_instances Yes Yes Yes   Global No
Table_open_cache_misses       Yes Both No
Table_open_cache_overflows       Yes Both No
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_handling Yes Yes Yes   Global No
thread_pool_algorithm Yes Yes Yes   Global No
thread_pool_high_priority_connection Yes Yes Yes   Both Yes
thread_pool_max_unused_threads Yes Yes Yes   Global Yes
thread_pool_prio_kickup_timer Yes Yes Yes   Both Yes
thread_pool_size Yes Yes Yes   Global No
thread_pool_stall_limit Yes Yes Yes   Global Yes
thread_stack Yes Yes Yes   Global No
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   Both Yes
timestamp     Yes   Session Yes
tls_version Yes Yes Yes   Global No
tmp_table_size Yes Yes Yes   Both Yes
tmpdir Yes Yes Yes   Global No
transaction_alloc_block_size Yes Yes Yes   Both Yes
transaction_allow_batching     Yes   Session Yes
transaction_isolation Yes Yes     Both Yes
- Variable: tx_isolation     Yes   Both Yes
transaction_prealloc_size Yes Yes Yes   Both Yes
transaction_read_only Yes Yes     Both Yes
- Variable: tx_read_only     Yes   Both Yes
transaction_write_set_extraction Yes Yes Yes   Both Yes
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        
validate-password Yes Yes        
validate_password_check_user_name Yes Yes Yes   Global Yes
validate_password_dictionary_file Yes Yes Yes   Global Varies
validate_password_dictionary_file_last_parsed       Yes Global No
validate_password_dictionary_file_words_count       Yes Global No
validate_password_length Yes Yes Yes   Global Yes
validate_password_mixed_case_count Yes Yes Yes   Global Yes
validate_password_number_count Yes Yes Yes   Global Yes
validate_password_policy Yes Yes Yes   Global Yes
validate_password_special_char_count Yes Yes Yes   Global Yes
validate_user_plugins Yes Yes Yes   Global No
verbose Yes Yes        
version     Yes   Global No
version_comment     Yes   Global No
version_compile_machine     Yes   Global No
version_compile_os     Yes   Global No
version_tokens_session Yes Yes Yes   Both Yes
version_tokens_session_number Yes Yes Yes   Both No
wait_timeout Yes Yes Yes   Both Yes
warning_count     Yes   Session No

 

Notes:

1. This option is dynamic, but should be set only by server. You should not set this variable manually.

5.1.4 Server System Variable Reference

The following table lists all system variables applicable within mysqld.

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

Table 5.2 System Variable Summary

NameCmd-LineOption FileSystem VarVar ScopeDynamic
audit_log_buffer_size Yes Yes Yes Global No
audit_log_compression Yes Yes Yes Global No
audit_log_connection_policy Yes Yes Yes Global Yes
audit_log_current_session     Yes Both No
audit_log_encryption Yes Yes Yes Global No
audit_log_exclude_accounts Yes Yes Yes Global Yes
audit_log_file Yes Yes Yes Global No
audit_log_filter_id     Yes Both No
audit_log_flush     Yes Global Yes
audit_log_format Yes Yes Yes Global No
audit_log_include_accounts Yes Yes Yes Global Yes
audit_log_policy Yes Yes Yes Global No
audit_log_read_buffer_size Yes Yes Yes Varies Varies
audit_log_rotate_on_size Yes Yes Yes Global Yes
audit_log_statement_policy Yes Yes Yes Global Yes
audit_log_strategy Yes Yes Yes Global No
authentication_ldap_sasl_auth_method_name Yes Yes Yes Global Yes
authentication_ldap_sasl_bind_base_dn Yes Yes Yes Global Yes
authentication_ldap_sasl_bind_root_dn Yes Yes Yes Global Yes
authentication_ldap_sasl_bind_root_pwd Yes Yes Yes Global Yes
authentication_ldap_sasl_ca_path Yes Yes Yes Global Yes
authentication_ldap_sasl_group_search_attr Yes Yes Yes Global Yes
authentication_ldap_sasl_group_search_filter Yes Yes Yes Global Yes
authentication_ldap_sasl_init_pool_size Yes Yes Yes Global Yes
authentication_ldap_sasl_log_status Yes Yes Yes Global Yes
authentication_ldap_sasl_max_pool_size Yes Yes Yes Global Yes
authentication_ldap_sasl_server_host Yes Yes Yes Global Yes
authentication_ldap_sasl_server_port Yes Yes Yes Global Yes
authentication_ldap_sasl_tls Yes Yes Yes Global Yes
authentication_ldap_sasl_user_search_attr Yes Yes Yes Global Yes
authentication_ldap_simple_auth_method_name Yes Yes Yes Global Yes
authentication_ldap_simple_bind_base_dn Yes Yes Yes Global Yes
authentication_ldap_simple_bind_root_dn Yes Yes Yes Global Yes
authentication_ldap_simple_bind_root_pwd Yes Yes Yes Global Yes
authentication_ldap_simple_ca_path Yes Yes Yes Global Yes
authentication_ldap_simple_group_search_attr Yes Yes Yes Global Yes
authentication_ldap_simple_group_search_filter Yes Yes Yes Global Yes
authentication_ldap_simple_init_pool_size Yes Yes Yes Global Yes
authentication_ldap_simple_log_status Yes Yes Yes Global Yes
authentication_ldap_simple_max_pool_size Yes Yes Yes Global Yes
authentication_ldap_simple_server_host Yes Yes Yes Global Yes
authentication_ldap_simple_server_port Yes Yes Yes Global Yes
authentication_ldap_simple_tls Yes Yes Yes Global Yes
authentication_ldap_simple_user_search_attr Yes Yes Yes Global Yes
authentication_windows_log_level Yes Yes Yes Global No
authentication_windows_use_principal_name Yes Yes Yes Global No
auto_generate_certs Yes Yes Yes Global No
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 Yes Yes Global Yes
avoid_temporal_upgrade Yes Yes Yes Global Yes
back_log Yes Yes Yes Global No
basedir Yes Yes Yes Global No
big_tables Yes Yes Yes Both Yes
bind_address Yes Yes Yes Global No
binlog_cache_size Yes Yes Yes Global Yes
binlog_checksum Yes Yes Yes Global Yes
binlog_direct_non_transactional_updates Yes Yes Yes Both Yes
binlog_error_action Yes Yes Yes Global Yes
binlog_format Yes Yes Yes Both Yes
binlog_group_commit_sync_delay Yes Yes Yes Global Yes
binlog_group_commit_sync_no_delay_count Yes Yes Yes Global Yes
binlog_gtid_simple_recovery Yes Yes Yes Global No
binlog_max_flush_queue_time Yes Yes Yes Global Yes
binlog_order_commits Yes Yes Yes Global Yes
binlog_row_image Yes Yes Yes Both Yes
binlog_rows_query_log_events Yes Yes Yes Both Yes
binlog_stmt_cache_size Yes Yes Yes Global Yes
binlog_transaction_dependency_history_size Yes Yes Yes Global Yes
binlog_transaction_dependency_tracking Yes Yes Yes Global Yes
block_encryption_mode Yes Yes Yes Both Yes
bulk_insert_buffer_size Yes Yes Yes Both Yes
character_set_client     Yes Both Yes
character_set_connection     Yes Both Yes
character_set_database (note 1)     Yes Both Yes
character_set_filesystem Yes Yes Yes Both Yes
character_set_results     Yes Both Yes
character_set_server Yes Yes Yes Both Yes
character_set_system     Yes Global No
character_sets_dir Yes Yes Yes Global No
check_proxy_users Yes Yes Yes Global Yes
collation_connection     Yes Both Yes
collation_database (note 1)     Yes Both Yes
collation_server Yes Yes Yes Both Yes
completion_type Yes Yes Yes Both Yes
concurrent_insert Yes Yes Yes Global Yes
connect_timeout Yes Yes Yes Global Yes
connection_control_failed_connections_threshold Yes Yes Yes Global Yes
connection_control_max_connection_delay Yes Yes Yes Global Yes
connection_control_min_connection_delay Yes Yes Yes Global Yes
core_file     Yes Global No
daemon_memcached_enable_binlog Yes Yes Yes Global No
daemon_memcached_engine_lib_name Yes Yes Yes Global No
daemon_memcached_engine_lib_path Yes Yes Yes Global No
daemon_memcached_option Yes Yes Yes Global No
daemon_memcached_r_batch_size Yes Yes Yes Global No
daemon_memcached_w_batch_size Yes Yes Yes Global 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
default_authentication_plugin Yes Yes Yes Global No
default_password_lifetime Yes Yes Yes Global Yes
default_storage_engine Yes Yes Yes Both Yes
default_tmp_storage_engine Yes Yes Yes Both Yes
default_week_format Yes Yes Yes Both Yes
delay_key_write Yes Yes Yes Global Yes
delayed_insert_limit Yes Yes Yes Global Yes
delayed_insert_timeout Yes Yes Yes Global Yes
delayed_queue_size Yes Yes Yes Global Yes
disabled_storage_engines Yes Yes Yes Global No
disconnect_on_expired_password Yes Yes Yes Global No
div_precision_increment Yes Yes Yes Both Yes
end_markers_in_json Yes Yes Yes Both Yes
enforce_gtid_consistency Yes Yes Yes Global Varies
eq_range_index_dive_limit Yes Yes Yes Both Yes
error_count     Yes Session No
event_scheduler Yes Yes Yes Global Yes
expire_logs_days Yes Yes Yes Global Yes
explicit_defaults_for_timestamp Yes Yes Yes Both Yes
external_user     Yes Session No
flush Yes Yes Yes Global Yes
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
general_log Yes Yes Yes Global Yes
general_log_file Yes Yes Yes Global Yes
group_concat_max_len Yes Yes Yes Both Yes
group_replication_allow_local_disjoint_gtids_join Yes Yes Yes Global Yes
group_replication_allow_local_lower_version_join Yes Yes Yes Global Yes
group_replication_auto_increment_increment Yes Yes Yes Global Yes
group_replication_bootstrap_group Yes Yes Yes Global Yes
group_replication_components_stop_timeout Yes Yes Yes Global Yes
group_replication_compression_threshold Yes Yes Yes Global Yes
group_replication_enforce_update_everywhere_checks Yes Yes Yes Global Yes
group_replication_exit_state_action Yes Yes Yes Global Yes
group_replication_flow_control_applier_threshold Yes Yes Yes Global Yes
group_replication_flow_control_certifier_threshold Yes Yes Yes Global Yes
group_replication_flow_control_mode Yes Yes Yes Global Yes
group_replication_force_members Yes Yes Yes Global Yes
group_replication_group_name Yes Yes Yes Global Yes
group_replication_group_seeds Yes Yes Yes Global Yes
group_replication_gtid_assignment_block_size Yes Yes Yes Global Yes
group_replication_ip_whitelist Yes Yes Yes Global Yes
group_replication_local_address Yes Yes Yes Global Yes
group_replication_member_weight Yes Yes Yes Global Yes
group_replication_poll_spin_loops Yes Yes Yes Global Yes
group_replication_recovery_complete_at Yes Yes Yes Global Yes
group_replication_recovery_reconnect_interval Yes Yes Yes Global Yes
group_replication_recovery_retry_count Yes Yes Yes Global Yes
group_replication_recovery_ssl_ca Yes Yes Yes Global Yes
group_replication_recovery_ssl_capath Yes Yes Yes Global Yes
group_replication_recovery_ssl_cert Yes Yes Yes Global Yes
group_replication_recovery_ssl_cipher Yes Yes Yes Global Yes
group_replication_recovery_ssl_crl Yes Yes Yes Global Yes
group_replication_recovery_ssl_crlpath Yes Yes Yes Global Yes
group_replication_recovery_ssl_key Yes Yes Yes Global Yes
group_replication_recovery_ssl_verify_server_cert Yes Yes Yes Global Yes
group_replication_recovery_use_ssl Yes Yes Yes Global Yes
group_replication_single_primary_mode Yes Yes Yes Global Yes
group_replication_ssl_mode Yes Yes Yes Global Yes
group_replication_start_on_boot Yes Yes Yes Global Yes
group_replication_transaction_size_limit Yes Yes Yes Global Yes
group_replication_unreachable_majority_timeout Yes Yes Yes Global Yes
gtid_executed     Yes Varies No
gtid_executed_compression_period Yes Yes Yes Global Yes
gtid_mode Yes Yes Yes Global Varies
gtid_next     Yes Session Yes
gtid_owned     Yes Both No
gtid_purged     Yes Global Yes
have_compress     Yes Global No
have_crypt     Yes Global No
have_dynamic_loading     Yes Global No
have_geometry     Yes Global No
have_openssl     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_statement_timeout     Yes Global No
have_symlink     Yes Global No
host_cache_size Yes Yes Yes Global Yes
hostname     Yes Global No
identity     Yes Session Yes
ignore_builtin_innodb Yes Yes Yes Global No
ignore_db_dirs     Yes Global No
init_connect Yes Yes Yes Global Yes
init_file Yes Yes Yes Global No
init_slave Yes Yes Yes Global Yes
innodb_adaptive_flushing Yes Yes Yes Global Yes
innodb_adaptive_flushing_lwm Yes Yes Yes Global Yes
innodb_adaptive_hash_index Yes Yes Yes Global Yes
innodb_adaptive_hash_index_parts Yes Yes Yes Global No
innodb_adaptive_max_sleep_delay Yes Yes Yes Global Yes
innodb_api_bk_commit_interval Yes Yes Yes Global Yes
innodb_api_disable_rowlock Yes Yes Yes Global No
innodb_api_enable_binlog Yes Yes Yes Global No
innodb_api_enable_mdl Yes Yes Yes Global No
innodb_api_trx_level Yes Yes Yes Global Yes
innodb_autoextend_increment Yes Yes Yes Global Yes
innodb_autoinc_lock_mode Yes Yes Yes Global No
innodb_background_drop_list_empty Yes Yes Yes Global Yes
innodb_buffer_pool_chunk_size 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_pct Yes Yes Yes Global Yes
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 No
innodb_buffer_pool_load_now Yes Yes Yes Global Yes
innodb_buffer_pool_size Yes Yes Yes Global Varies
innodb_change_buffer_max_size Yes Yes Yes Global Yes
innodb_change_buffering Yes Yes Yes Global Yes
innodb_change_buffering_debug Yes Yes Yes Global Yes
innodb_checksum_algorithm Yes Yes Yes Global Yes
innodb_checksums Yes Yes Yes Global No
innodb_cmp_per_index_enabled Yes Yes Yes Global Yes
innodb_commit_concurrency Yes Yes Yes Global Yes
innodb_compress_debug Yes Yes Yes Global Yes
innodb_compression_failure_threshold_pct Yes Yes Yes Global Yes
innodb_compression_level Yes Yes Yes Global Yes
innodb_compression_pad_pct_max Yes Yes Yes Global Yes
innodb_concurrency_tickets Yes Yes Yes Global Yes
innodb_data_file_path Yes Yes Yes Global No
innodb_data_home_dir Yes Yes Yes Global No
innodb_deadlock_detect Yes Yes Yes Global Yes
innodb_default_row_format Yes Yes Yes Global Yes
innodb_disable_resize_buffer_pool_debug Yes Yes Yes Global Yes
innodb_disable_sort_file_cache Yes Yes Yes Global Yes
innodb_doublewrite Yes Yes Yes Global No
innodb_fast_shutdown Yes Yes Yes Global Yes
innodb_fil_make_page_dirty_debug 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_fill_factor Yes Yes Yes Global Yes
innodb_flush_log_at_timeout 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_flush_sync Yes Yes Yes Global Yes
innodb_flushing_avg_loops 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 Global Yes
innodb_ft_cache_size Yes Yes Yes Global No
innodb_ft_enable_diag_print Yes Yes Yes Global Yes
innodb_ft_enable_stopword Yes Yes Yes Both Yes
innodb_ft_max_token_size Yes Yes Yes Global No
innodb_ft_min_token_size Yes Yes Yes Global No
innodb_ft_num_word_optimize Yes Yes Yes Global Yes
innodb_ft_result_cache_limit Yes Yes Yes Global Yes
innodb_ft_server_stopword_table Yes Yes Yes Global Yes
innodb_ft_sort_pll_degree Yes Yes Yes Global No
innodb_ft_total_cache_size Yes Yes Yes Global No
innodb_ft_user_stopword_table Yes Yes Yes Both Yes
innodb_io_capacity Yes Yes Yes Global Yes
innodb_io_capacity_max Yes Yes Yes Global Yes
innodb_large_prefix Yes Yes Yes Global Yes
innodb_limit_optimistic_insert_debug Yes Yes Yes Global Yes
innodb_lock_wait_timeout Yes Yes Yes Both Yes
innodb_locks_unsafe_for_binlog Yes Yes Yes Global No
innodb_log_buffer_size Yes Yes Yes Global No
innodb_log_checkpoint_now Yes Yes Yes Global Yes
innodb_log_checksums Yes Yes Yes Global Yes
innodb_log_compressed_pages Yes Yes Yes Global Yes
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_write_ahead_size Yes Yes Yes Global Yes
innodb_lru_scan_depth Yes Yes Yes Global Yes
innodb_max_dirty_pages_pct Yes Yes Yes Global Yes
innodb_max_dirty_pages_pct_lwm Yes Yes Yes Global Yes
innodb_max_purge_lag Yes Yes Yes Global Yes
innodb_max_purge_lag_delay Yes Yes Yes Global Yes
innodb_max_undo_log_size Yes Yes Yes Global Yes
innodb_merge_threshold_set_all_debug Yes Yes Yes Global Yes
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_numa_interleave Yes Yes Yes Global No
innodb_old_blocks_pct Yes Yes Yes Global Yes
innodb_old_blocks_time Yes Yes Yes Global Yes
innodb_online_alter_log_max_size Yes Yes Yes Global Yes
innodb_open_files Yes Yes Yes Global No
innodb_optimize_fulltext_only Yes Yes Yes Global Yes
innodb_page_cleaners Yes Yes Yes Global No
innodb_page_size Yes Yes Yes Global No
innodb_print_all_deadlocks Yes Yes Yes Global Yes
innodb_purge_batch_size Yes Yes Yes Global Yes
innodb_purge_rseg_truncate_frequency Yes Yes Yes Global Yes
innodb_purge_threads Yes Yes Yes Global No
innodb_random_read_ahead Yes Yes Yes Global Yes
innodb_read_ahead_threshold Yes Yes Yes Global Yes
innodb_read_io_threads Yes Yes Yes Global No
innodb_read_only 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_saved_page_number_debug Yes Yes Yes Global Yes
innodb_sort_buffer_size Yes Yes Yes Global No
innodb_spin_wait_delay Yes Yes Yes Global Yes
innodb_stats_auto_recalc Yes Yes Yes Global Yes
innodb_stats_include_delete_marked Yes Yes Yes Global Yes
innodb_stats_method Yes Yes Yes Global Yes
innodb_stats_on_metadata Yes Yes Yes Global Yes
innodb_stats_persistent 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_output Yes Yes Yes Global Yes
innodb_status_output_locks Yes Yes Yes Global 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_debug Yes Yes Yes Global No
innodb_sync_spin_loops Yes Yes Yes Global Yes
innodb_table_locks Yes Yes Yes Both Yes
innodb_temp_data_file_path Yes Yes Yes Global No
innodb_thread_concurrency Yes Yes Yes Global Yes
innodb_thread_sleep_delay Yes Yes Yes Global Yes
innodb_tmpdir Yes Yes Yes Both Yes
innodb_trx_purge_view_update_only_debug Yes Yes Yes Global Yes
innodb_trx_rseg_n_slots_debug Yes Yes Yes Global Yes
innodb_undo_directory Yes Yes Yes Global No
innodb_undo_log_truncate Yes Yes Yes Global Yes
innodb_undo_logs Yes Yes Yes Global Yes
innodb_undo_tablespaces Yes Yes Yes Global No
innodb_use_native_aio Yes Yes Yes Global No
innodb_version     Yes Global No
innodb_write_io_threads Yes Yes Yes Global No
insert_id     Yes Session Yes
interactive_timeout Yes Yes Yes Both Yes
internal_tmp_disk_storage_engine Yes Yes Yes Global Yes
join_buffer_size Yes Yes Yes Both Yes
keep_files_on_create Yes Yes Yes Both Yes
key_buffer_size Yes Yes Yes Global Yes
key_cache_age_threshold Yes Yes Yes Global Yes
key_cache_block_size Yes Yes Yes Global Yes
key_cache_division_limit Yes Yes Yes Global Yes
keyring_aws_cmk_id Yes Yes Yes Global Yes
keyring_aws_conf_file Yes Yes Yes Global No
keyring_aws_data_file Yes Yes Yes Global No
keyring_aws_region Yes Yes Yes Global Yes
keyring_encrypted_file_data Yes Yes Yes Global Yes
keyring_encrypted_file_password Yes Yes Yes Global Yes
keyring_file_data Yes Yes Yes Global Yes
keyring_okv_conf_dir Yes Yes Yes Global Yes
keyring_operations     Yes Global Yes
language Yes Yes Yes Global No
large_files_support     Yes Global No
large_page_size     Yes Global No
large_pages Yes Yes Yes Global No
last_insert_id     Yes Session Yes
lc_messages Yes Yes Yes Both Yes
lc_messages_dir Yes Yes Yes Global No
lc_time_names Yes Yes Yes Both Yes
license     Yes Global No
local_infile Yes Yes Yes Global Yes
lock_wait_timeout Yes Yes Yes Both Yes
locked_in_memory     Yes Global No
log_bin     Yes Global No
log_bin_basename     Yes Global No
log_bin_index Yes Yes Yes Global No
log_bin_trust_function_creators Yes Yes Yes Global Yes
log_bin_use_v1_row_events Yes Yes Yes Global No
log_builtin_as_identified_by_password Yes Yes Yes Global Yes
log_error Yes Yes Yes Global No
log_error_verbosity Yes Yes Yes Global Yes
log_output Yes Yes Yes Global Yes
log_queries_not_using_indexes Yes Yes Yes Global Yes
log_slave_updates Yes Yes Yes Global No
log_slow_admin_statements Yes Yes Yes Global Yes
log_slow_slave_statements Yes Yes Yes Global Yes
log_statements_unsafe_for_binlog Yes Yes Yes Global Yes
log_syslog Yes Yes Yes Global Yes
log_syslog_facility Yes Yes Yes Global Yes
log_syslog_include_pid Yes Yes Yes Global Yes
log_syslog_tag Yes Yes Yes Global Yes
log_throttle_queries_not_using_indexes Yes Yes Yes Global Yes
log_timestamps Yes Yes Yes Global Yes
log_warnings Yes Yes Yes Global Yes
long_query_time Yes Yes Yes Both Yes
low_priority_updates Yes Yes Yes Both Yes
lower_case_file_system     Yes Global No
lower_case_table_names Yes Yes Yes Global No
master_info_repository Yes Yes Yes Global Yes
master_verify_checksum Yes Yes Yes Global Yes
max_allowed_packet Yes Yes Yes Both Yes
max_binlog_cache_size Yes Yes Yes Global Yes
max_binlog_size Yes Yes Yes Global Yes
max_binlog_stmt_cache_size Yes Yes Yes Global Yes
max_connect_errors Yes Yes Yes Global Yes
max_connections Yes Yes Yes Global Yes
max_delayed_threads Yes Yes Yes Both Yes
max_digest_length Yes Yes Yes Global No
max_error_count Yes Yes Yes Both Yes
max_execution_time 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_points_in_geometry 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 Both Yes
max_user_connections Yes Yes Yes Both Yes
max_write_lock_count Yes Yes Yes Global Yes
mecab_rc_file Yes Yes Yes Global No
metadata_locks_cache_size Yes Yes Yes Global No
metadata_locks_hash_instances Yes Yes Yes Global No
min_examined_row_limit Yes Yes Yes Both Yes
multi_range_count Yes Yes Yes Both Yes
myisam_data_pointer_size Yes Yes Yes Global Yes
myisam_max_sort_file_size Yes Yes Yes Global Yes
myisam_mmap_size Yes Yes Yes Global No
myisam_recover_options Yes Yes 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
mysql_firewall_mode Yes Yes Yes Global Yes
mysql_firewall_trace Yes Yes Yes Global Yes
mysql_native_password_proxy_users Yes Yes Yes Global Yes
mysqlx_bind_address Yes Yes Yes Global No
mysqlx_connect_timeout Yes Yes Yes Global Yes
mysqlx_idle_worker_thread_timeout Yes Yes Yes Global Yes
mysqlx_max_allowed_packet Yes Yes Yes Global Yes
mysqlx_max_connections Yes Yes Yes Global Yes
mysqlx_min_worker_threads Yes Yes Yes Global Yes
mysqlx_port Yes Yes Yes Global No
mysqlx_port_open_timeout Yes Yes Yes Global No
mysqlx_socket Yes Yes Yes Global No
mysqlx_ssl_ca Yes Yes Yes Global No
mysqlx_ssl_capath Yes Yes Yes Global No
mysqlx_ssl_cert Yes Yes Yes Global No
mysqlx_ssl_cipher Yes Yes Yes Global No
mysqlx_ssl_crl Yes Yes Yes Global No
mysqlx_ssl_crlpath Yes Yes Yes Global No
mysqlx_ssl_key Yes Yes Yes Global No
named_pipe Yes Yes Yes Global No
named_pipe_full_access_group Yes Yes Yes Global No
ndb_allow_copying_alter_table Yes Yes Yes Both Yes
ndb_autoincrement_prefetch_sz Yes Yes Yes Both Yes
ndb_batch_size Yes Yes Yes Global No
ndb_blob_read_batch_bytes Yes Yes Yes Both Yes
ndb_blob_write_batch_bytes Yes Yes Yes Both Yes
ndb_cache_check_time Yes Yes Yes Global Yes
ndb_clear_apply_status Yes   Yes Global Yes
ndb_cluster_connection_pool Yes Yes Yes Global No
ndb_cluster_connection_pool_nodeids Yes Yes Yes Global No
Ndb_conflict_last_conflict_epoch     Yes Global No
ndb_data_node_neighbour Yes Yes Yes Global Yes
ndb_default_column_format Yes Yes Yes Global Yes
ndb_default_column_format Yes Yes Yes Global Yes
ndb_deferred_constraints Yes Yes Yes Both Yes
ndb_deferred_constraints Yes Yes Yes Both Yes
ndb_distribution Yes Yes Yes Global Yes
ndb_distribution Yes Yes Yes Global Yes
ndb_eventbuffer_free_percent Yes Yes Yes Global Yes
ndb_eventbuffer_max_alloc Yes Yes Yes Global Yes
ndb_extra_logging Yes Yes Yes Global Yes
ndb_force_send Yes Yes Yes Both Yes
ndb_fully_replicated Yes Yes Yes Both Yes
ndb_index_stat_enable Yes Yes Yes Both Yes
ndb_index_stat_option Yes Yes Yes Both Yes
ndb_join_pushdown     Yes Both Yes
ndb_log_apply_status Yes Yes Yes Global No
ndb_log_apply_status Yes Yes Yes Global No
ndb_log_bin Yes   Yes Both Yes
ndb_log_binlog_index Yes   Yes Global Yes
ndb_log_empty_epochs Yes Yes Yes Global Yes
ndb_log_empty_epochs Yes Yes Yes Global Yes
ndb_log_empty_update Yes Yes Yes Global Yes
ndb_log_empty_update Yes Yes Yes Global Yes
ndb_log_exclusive_reads Yes Yes Yes Both Yes
ndb_log_exclusive_reads Yes Yes Yes Both Yes
ndb_log_fail_terminate Yes Yes Yes Global No
ndb_log_orig Yes Yes Yes Global No
ndb_log_orig Yes Yes Yes Global No
ndb_log_transaction_id Yes Yes Yes Global No
ndb_log_transaction_id     Yes Global No
ndb_log_update_as_write Yes Yes Yes Global Yes
ndb_log_update_minimal Yes Yes Yes Global Yes
ndb_log_updated_only Yes Yes Yes Global Yes
ndb_optimization_delay Yes Yes Yes Global Yes
ndb_optimized_node_selection Yes Yes Yes Global No
ndb_read_backup Yes Yes Yes Global Yes
ndb_recv_thread_activation_threshold Yes Yes Yes Global Yes
ndb_recv_thread_cpu_mask Yes Yes Yes Global Yes
ndb_report_thresh_binlog_epoch_slip Yes Yes Yes Global Yes
ndb_report_thresh_binlog_mem_usage Yes Yes Yes Global Yes
ndb_row_checksum     Yes Both Yes
ndb_show_foreign_key_mock_tables Yes Yes Yes Global Yes
ndb_slave_conflict_role Yes Yes Yes Global Yes
Ndb_slave_max_replicated_epoch     Yes Global No
Ndb_system_name     Yes Global No
ndb_table_no_logging     Yes Session Yes
ndb_table_temporary     Yes Session Yes
ndb_use_copying_alter_table     Yes Both No
ndb_use_exact_count     Yes Both Yes
ndb_use_transactions Yes Yes Yes Both Yes
ndb_version     Yes Global No
ndb_version_string     Yes Global No
ndb_wait_connected Yes Yes Yes Global No
ndb_wait_setup Yes Yes Yes Global No
ndbinfo_database     Yes Global No
ndbinfo_max_bytes Yes   Yes Both Yes
ndbinfo_max_rows Yes   Yes Both Yes
ndbinfo_offline     Yes Global Yes
ndbinfo_show_hidden Yes   Yes Both Yes
ndbinfo_table_prefix     Yes Global No
ndbinfo_version     Yes Global No
net_buffer_length Yes Yes Yes Both Yes
net_read_timeout Yes Yes Yes Both Yes
net_retry_count Yes Yes Yes Both Yes
net_write_timeout Yes Yes Yes Both Yes
new Yes Yes Yes Both Yes
ngram_token_size Yes Yes Yes Global No
offline_mode Yes Yes Yes Global Yes
old Yes Yes Yes Global No
old_alter_table Yes Yes Yes Both Yes
old_passwords Yes Yes Yes Both Yes
open_files_limit Yes Yes Yes Global No
optimizer_prune_level Yes Yes Yes Both Yes
optimizer_search_depth Yes Yes Yes Both Yes
optimizer_switch Yes Yes Yes Both Yes
optimizer_trace Yes Yes Yes Both Yes
optimizer_trace_features Yes Yes Yes Both Yes
optimizer_trace_limit Yes Yes Yes Both Yes
optimizer_trace_max_mem_size Yes Yes Yes Both Yes
optimizer_trace_offset Yes Yes Yes Both Yes
parser_max_mem_size Yes Yes Yes Both Yes
performance_schema Yes Yes Yes Global No
performance_schema_accounts_size Yes Yes Yes Global No
performance_schema_digests_size Yes Yes Yes Global No
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_transactions_history_long_size Yes Yes Yes Global No
performance_schema_events_transactions_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_hosts_size Yes Yes Yes Global No
performance_schema_max_cond_classes Yes Yes Yes Global No
performance_schema_max_cond_instances Yes Yes Yes Global No
performance_schema_max_digest_length 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_index_stat Yes Yes Yes Global No
performance_schema_max_memory_classes Yes Yes Yes Global No
performance_schema_max_metadata_locks 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_prepared_statements_instances Yes Yes Yes Global No
performance_schema_max_program_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_sql_text_length 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_statement_stack 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_table_lock_stat 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_session_connect_attrs_size Yes Yes 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_users_size Yes Yes Yes Global No
pid_file Yes Yes Yes Global No
plugin_dir Yes Yes Yes Global No
plugin_load Yes Yes Yes Global No
plugin_load_add Yes Yes Yes Global No
port Yes Yes Yes Global No
preload_buffer_size Yes Yes Yes Both Yes
profiling     Yes Both Yes
profiling_history_size Yes Yes Yes Both Yes
protocol_version     Yes Global No
proxy_user     Yes Session No
pseudo_slave_mode     Yes Session Yes
pseudo_thread_id     Yes Session Yes
query_alloc_block_size Yes Yes Yes Both Yes
query_cache_limit Yes Yes Yes Global Yes
query_cache_min_res_unit Yes Yes Yes Global Yes
query_cache_size Yes Yes Yes Global Yes
query_cache_type Yes Yes Yes Both Yes
query_cache_wlock_invalidate Yes Yes Yes Both Yes
query_prealloc_size Yes Yes Yes Both Yes
rand_seed1     Yes Session Yes
rand_seed2     Yes Session Yes
range_alloc_block_size Yes Yes Yes Both Yes
range_optimizer_max_mem_size Yes Yes Yes Both Yes
rbr_exec_mode     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 Yes Global No
relay_log_basename     Yes Global No
relay_log_index Yes Yes Yes Global No
relay_log_info_file Yes Yes Yes Global No
relay_log_info_repository Yes Yes Yes Global Yes
relay_log_purge Yes Yes Yes Global Yes
relay_log_recovery Yes Yes Yes Global No
relay_log_space_limit Yes Yes Yes Global No
replication_optimize_for_static_plugin_config Yes Yes Yes Global Yes
replication_sender_observe_commit_only Yes Yes Yes Global Yes
report_host Yes Yes Yes Global No
report_password Yes Yes Yes Global No
report_port Yes Yes Yes Global No
report_user Yes Yes Yes Global No
require_secure_transport Yes Yes Yes Global Yes
rewriter_enabled     Yes Global Yes
rewriter_verbose     Yes Global Yes
rpl_semi_sync_master_enabled Yes Yes Yes Global Yes
rpl_semi_sync_master_timeout Yes Yes Yes Global Yes
rpl_semi_sync_master_trace_level Yes Yes Yes Global Yes
rpl_semi_sync_master_wait_for_slave_count Yes Yes Yes Global Yes
rpl_semi_sync_master_wait_no_slave Yes Yes Yes Global Yes
rpl_semi_sync_master_wait_point Yes Yes Yes Global Yes
rpl_semi_sync_slave_enabled Yes Yes Yes Global Yes
rpl_semi_sync_slave_trace_level Yes Yes Yes Global Yes
rpl_stop_slave_timeout Yes Yes Yes Global Yes
secure_auth Yes Yes Yes Global Yes
secure_file_priv Yes Yes Yes Global No
server_id Yes Yes Yes Global Yes
server_id_bits Yes Yes Yes Global No
server_uuid     Yes Global No
session_track_gtids Yes Yes Yes Both Yes
session_track_schema Yes Yes Yes Both Yes
session_track_state_change Yes Yes Yes Both Yes
session_track_system_variables Yes Yes Yes Both Yes
session_track_transaction_info Yes Yes Yes Both Yes
sha256_password_auto_generate_rsa_keys Yes Yes Yes Global No
sha256_password_private_key_path Yes Yes Yes Global No
sha256_password_proxy_users Yes Yes Yes Global Yes
sha256_password_public_key_path Yes Yes Yes Global No
shared_memory Yes Yes Yes Global No
shared_memory_base_name Yes Yes Yes Global No
show_compatibility_56 Yes Yes Yes Global Yes
show_create_table_verbosity Yes Yes Yes Both Yes
show_old_temporals Yes Yes Yes Both Yes
skip_external_locking Yes Yes Yes Global No
skip_name_resolve Yes Yes Yes Global No
skip_networking Yes Yes Yes Global No
skip_show_database Yes Yes Yes Global No
slave_allow_batching Yes Yes Yes Global Yes
slave_checkpoint_group Yes Yes Yes Global Yes
slave_checkpoint_period Yes Yes Yes Global Yes
slave_compressed_protocol Yes Yes Yes Global Yes
slave_exec_mode Yes Yes Yes Global Yes
slave_load_tmpdir Yes Yes Yes Global No
slave_max_allowed_packet Yes Yes Yes Global Yes
slave_net_timeout Yes Yes Yes Global Yes
slave_parallel_type Yes Yes Yes Global Yes
slave_parallel_workers Yes Yes Yes Global Yes
slave_pending_jobs_size_max Yes Yes Yes Global Yes
slave_preserve_commit_order Yes Yes Yes Global Yes
slave_rows_search_algorithms Yes Yes Yes Global Yes
slave_skip_errors Yes Yes Yes Global No
slave_sql_verify_checksum Yes Yes Yes Global Yes
slave_transaction_retries Yes Yes Yes Global Yes
slave_type_conversions Yes Yes Yes Global Yes
slow_launch_time Yes Yes Yes Global Yes
slow_query_log Yes Yes Yes Global Yes
slow_query_log_file Yes Yes Yes Global Yes
socket Yes Yes Yes Global No
sort_buffer_size Yes Yes Yes Both Yes
sql_auto_is_null     Yes Both Yes
sql_big_selects     Yes Both Yes
sql_buffer_result     Yes Both Yes
sql_log_bin     Yes Session Yes
sql_log_off     Yes Both Yes
sql_mode Yes Yes 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_ca Yes Yes Yes Global No
ssl_capath Yes Yes Yes Global No
ssl_cert Yes Yes Yes Global No
ssl_cipher Yes Yes Yes Global No
ssl_crl Yes Yes Yes Global No
ssl_crlpath Yes Yes Yes Global No
ssl_key Yes Yes Yes Global No
stored_program_cache Yes Yes Yes Global Yes
super_read_only Yes Yes Yes Global Yes
sync_binlog Yes Yes Yes Global Yes
sync_frm Yes Yes Yes Global Yes
sync_master_info Yes Yes Yes Global Yes
sync_relay_log Yes Yes Yes Global Yes
sync_relay_log_info Yes Yes Yes Global Yes
system_time_zone     Yes Global No
table_definition_cache Yes Yes Yes Global Yes
table_open_cache Yes Yes Yes Global Yes
table_open_cache_instances Yes Yes Yes Global No
thread_cache_size Yes Yes Yes Global Yes
thread_handling Yes Yes Yes Global No
thread_pool_algorithm Yes Yes Yes Global No
thread_pool_high_priority_connection Yes Yes Yes Both Yes
thread_pool_max_unused_threads Yes Yes Yes Global Yes
thread_pool_prio_kickup_timer Yes Yes Yes Both Yes
thread_pool_size Yes Yes Yes Global No
thread_pool_stall_limit Yes Yes Yes Global Yes
thread_stack Yes Yes Yes Global No
time_format     Yes Global No
time_zone     Yes Both Yes
timestamp     Yes Session Yes
tls_version Yes Yes Yes Global No
tmp_table_size Yes Yes Yes Both Yes
tmpdir Yes Yes Yes Global No
transaction_alloc_block_size Yes Yes Yes Both Yes
transaction_allow_batching     Yes Session Yes
transaction_isolation Yes Yes     Yes
- Variable: tx_isolation     Yes Both Yes
transaction_prealloc_size Yes Yes Yes Both Yes
transaction_read_only Yes Yes     Yes
- Variable: tx_read_only     Yes Both Yes
transaction_write_set_extraction Yes Yes Yes Both Yes
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
validate_password_check_user_name Yes Yes Yes Global Yes
validate_password_dictionary_file Yes Yes Yes Global Varies
validate_password_length Yes Yes Yes Global Yes
validate_password_mixed_case_count Yes Yes Yes Global Yes
validate_password_number_count Yes Yes Yes Global Yes
validate_password_policy Yes Yes Yes Global Yes
validate_password_special_char_count Yes Yes Yes Global Yes
validate_user_plugins Yes Yes Yes Global No
version     Yes Global No
version_comment     Yes Global No
version_compile_machine     Yes Global No
version_compile_os     Yes Global No
version_tokens_session Yes Yes Yes Both Yes
version_tokens_session_number Yes Yes Yes Both No
wait_timeout Yes Yes Yes Both Yes
warning_count     Yes Session No

Notes:

1. This option is dynamic, but should be set only by server. You should not set this variable manually.

5.1.5 Server Status Variable Reference

The following table lists all status variables applicable within mysqld.

The table lists each variable's data type and scope. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the variables. Where appropriate, direct links to further information about the items are provided.

Table 5.3 Status Variable Summary

Variable NameVariable TypeVariable Scope
Aborted_clients Integer Global
Aborted_connects Integer Global
Audit_log_current_size Integer Global
Audit_log_event_max_drop_size Integer Global
Audit_log_events Integer Global
Audit_log_events_filtered Integer Global
Audit_log_events_lost Integer Global
Audit_log_events_written Integer Global
Audit_log_total_size Integer Global
Audit_log_write_waits Integer Global
Binlog_cache_disk_use Integer Global
Binlog_cache_use Integer Global
Binlog_stmt_cache_disk_use Integer Global
Binlog_stmt_cache_use Integer Global
Bytes_received Integer Both
Bytes_sent Integer Both
Com_admin_commands Integer Both
Com_alter_db Integer Both
Com_alter_db_upgrade Integer Both
Com_alter_event Integer Both
Com_alter_function Integer Both
Com_alter_procedure Integer Both
Com_alter_server Integer Both
Com_alter_table Integer Both
Com_alter_tablespace Integer Both
Com_alter_user Integer Both
Com_analyze Integer Both
Com_assign_to_keycache Integer Both
Com_begin Integer Both
Com_binlog Integer Both
Com_call_procedure Integer Both
Com_change_db Integer Both
Com_change_master Integer Both
Com_change_repl_filter Integer Both
Com_check Integer Both
Com_checksum Integer Both
Com_commit Integer Both
Com_create_db Integer Both
Com_create_event Integer Both
Com_create_function Integer Both
Com_create_index Integer Both
Com_create_procedure Integer Both
Com_create_server Integer Both
Com_create_table Integer Both
Com_create_trigger Integer Both
Com_create_udf Integer Both
Com_create_user Integer Both
Com_create_view Integer Both
Com_dealloc_sql Integer Both
Com_delete Integer Both
Com_delete_multi Integer Both
Com_do Integer Both
Com_drop_db Integer Both
Com_drop_event Integer Both
Com_drop_function Integer Both
Com_drop_index Integer Both
Com_drop_procedure Integer Both
Com_drop_server Integer Both
Com_drop_table Integer Both
Com_drop_trigger Integer Both
Com_drop_user Integer Both
Com_drop_view Integer Both
Com_empty_query Integer Both
Com_execute_sql Integer Both
Com_explain_other Integer Both
Com_flush Integer Both
Com_get_diagnostics Integer Both
Com_grant Integer Both
Com_group_replication_start Integer Global
Com_group_replication_stop Integer Global
Com_ha_close Integer Both
Com_ha_open Integer Both
Com_ha_read Integer Both
Com_help Integer Both
Com_insert Integer Both
Com_insert_select Integer Both
Com_install_plugin Integer Both
Com_kill Integer Both
Com_load Integer Both
Com_lock_tables Integer Both
Com_optimize Integer Both
Com_preload_keys Integer Both
Com_prepare_sql Integer Both
Com_purge Integer Both
Com_purge_before_date Integer Both
Com_release_savepoint Integer Both
Com_rename_table Integer Both
Com_rename_user Integer Both
Com_repair Integer Both
Com_replace Integer Both
Com_replace_select Integer Both
Com_reset Integer Both
Com_resignal Integer Both
Com_revoke Integer Both
Com_revoke_all Integer Both
Com_rollback Integer Both
Com_rollback_to_savepoint Integer Both
Com_savepoint Integer Both
Com_select Integer Both
Com_set_option Integer Both
Com_show_authors Integer Both
Com_show_binlog_events Integer Both
Com_show_binlogs Integer Both
Com_show_charsets Integer Both
Com_show_collations Integer Both
Com_show_contributors Integer Both
Com_show_create_db Integer Both
Com_show_create_event Integer Both
Com_show_create_func Integer Both
Com_show_create_proc Integer Both
Com_show_create_table Integer Both
Com_show_create_trigger Integer Both
Com_show_create_user Integer Both
Com_show_databases Integer Both
Com_show_engine_logs Integer Both
Com_show_engine_mutex Integer Both
Com_show_engine_status Integer Both
Com_show_errors Integer Both
Com_show_events Integer Both
Com_show_fields Integer Both
Com_show_function_code Integer Both
Com_show_function_status Integer Both
Com_show_grants Integer Both
Com_show_keys Integer Both
Com_show_master_status Integer Both
Com_show_ndb_status Integer Both
Com_show_open_tables Integer Both
Com_show_plugins Integer Both
Com_show_privileges Integer Both
Com_show_procedure_code Integer Both
Com_show_procedure_status Integer Both
Com_show_processlist Integer Both
Com_show_profile Integer Both
Com_show_profiles Integer Both
Com_show_relaylog_events Integer Both
Com_show_slave_hosts Integer Both
Com_show_slave_status Integer Both
Com_show_status Integer Both
Com_show_storage_engines Integer Both
Com_show_table_status Integer Both
Com_show_tables Integer Both
Com_show_triggers Integer Both
Com_show_variables Integer Both
Com_show_warnings Integer Both
Com_shutdown Integer Both
Com_signal Integer Both
Com_slave_start Integer Both
Com_slave_stop Integer Both
Com_stmt_close Integer Both
Com_stmt_execute Integer Both
Com_stmt_fetch Integer Both
Com_stmt_prepare Integer Both
Com_stmt_reprepare Integer Both
Com_stmt_reset Integer Both
Com_stmt_send_long_data Integer Both
Com_truncate Integer Both
Com_uninstall_plugin Integer Both
Com_unlock_tables Integer Both
Com_update Integer Both
Com_update_multi Integer Both
Com_xa_commit Integer Both
Com_xa_end Integer Both
Com_xa_prepare Integer Both
Com_xa_recover Integer Both
Com_xa_rollback Integer Both
Com_xa_start Integer Both
Compression Integer Session
Connection_control_delay_generated Integer Global
Connection_errors_accept Integer Global
Connection_errors_internal Integer Global
Connection_errors_max_connections Integer Global
Connection_errors_peer_address Integer Global
Connection_errors_select Integer Global
Connection_errors_tcpwrap Integer Global
Connections Integer Global
Created_tmp_disk_tables Integer Both
Created_tmp_files Integer Global
Created_tmp_tables Integer Both
Delayed_errors Integer Global
Delayed_insert_threads Integer Global
Delayed_writes Integer Global
Firewall_access_denied Integer Global
Firewall_access_granted Integer Global
Firewall_cached_entries Integer Global
Flush_commands Integer Global
group_replication_primary_member String Global
Handler_commit Integer Both
Handler_delete Integer Both
Handler_discover Integer Both
Handler_external_lock Integer Both
Handler_mrr_init Integer Both
Handler_prepare Integer Both
Handler_read_first Integer Both
Handler_read_key Integer Both
Handler_read_last Integer Both
Handler_read_next Integer Both
Handler_read_prev Integer Both
Handler_read_rnd Integer Both
Handler_read_rnd_next Integer Both
Handler_rollback Integer Both
Handler_savepoint Integer Both
Handler_savepoint_rollback Integer Both
Handler_update Integer Both
Handler_write Integer Both
Innodb_available_undo_logs Integer Global
Innodb_buffer_pool_bytes_data Integer Global
Innodb_buffer_pool_bytes_dirty Integer Global
Innodb_buffer_pool_dump_status String Global
Innodb_buffer_pool_load_status String Global
Innodb_buffer_pool_pages_data Integer Global
Innodb_buffer_pool_pages_dirty Integer Global
Innodb_buffer_pool_pages_flushed Integer Global
Innodb_buffer_pool_pages_free Integer Global
Innodb_buffer_pool_pages_latched Integer Global
Innodb_buffer_pool_pages_misc Integer Global
Innodb_buffer_pool_pages_total Integer Global
Innodb_buffer_pool_read_ahead Integer Global
Innodb_buffer_pool_read_ahead_evicted Integer Global
Innodb_buffer_pool_read_ahead_rnd Integer Global
Innodb_buffer_pool_read_requests Integer Global
Innodb_buffer_pool_reads Integer Global
Innodb_buffer_pool_resize_status String Global
Innodb_buffer_pool_wait_free Integer Global
Innodb_buffer_pool_write_requests Integer Global
Innodb_data_fsyncs Integer Global
Innodb_data_pending_fsyncs Integer Global
Innodb_data_pending_reads Integer Global
Innodb_data_pending_writes Integer Global
Innodb_data_read Integer Global
Innodb_data_reads Integer Global
Innodb_data_writes Integer Global
Innodb_data_written Integer Global
Innodb_dblwr_pages_written Integer Global
Innodb_dblwr_writes Integer Global
Innodb_have_atomic_builtins Integer Global
Innodb_log_waits Integer Global
Innodb_log_write_requests Integer Global
Innodb_log_writes Integer Global
Innodb_num_open_files Integer Global
Innodb_os_log_fsyncs Integer Global
Innodb_os_log_pending_fsyncs Integer Global
Innodb_os_log_pending_writes Integer Global
Innodb_os_log_written Integer Global
Innodb_page_size Integer Global
Innodb_pages_created Integer Global
Innodb_pages_read Integer Global
Innodb_pages_written Integer Global
Innodb_row_lock_current_waits Integer Global
Innodb_row_lock_time Integer Global
Innodb_row_lock_time_avg Integer Global
Innodb_row_lock_time_max Integer Global
Innodb_row_lock_waits Integer Global
Innodb_rows_deleted Integer Global
Innodb_rows_inserted Integer Global
Innodb_rows_read Integer Global
Innodb_rows_updated Integer Global
Innodb_truncated_status_writes Integer Global
Key_blocks_not_flushed Integer Global
Key_blocks_unused Integer Global
Key_blocks_used Integer Global
Key_read_requests Integer Global
Key_reads Integer Global
Key_write_requests Integer Global
Key_writes Integer Global
Last_query_cost Numeric Session
Last_query_partial_plans Integer Session
Locked_connects Integer Global
Max_execution_time_exceeded Integer Both
Max_execution_time_set Integer Both
Max_execution_time_set_failed Integer Both
Max_used_connections Integer Global
Max_used_connections_time Datetime Global
mecab_charset String Global
Mysqlx_address String Global
Mysqlx_bytes_received Integer Both
Mysqlx_bytes_sent Integer Both
Mysqlx_connection_accept_errors Integer Both
Mysqlx_connection_errors Integer Both
Mysqlx_connections_accepted Integer Global
Mysqlx_connections_closed Integer Global
Mysqlx_connections_rejected Integer Global
Mysqlx_crud_create_view Integer Both
Mysqlx_crud_delete Integer Both
Mysqlx_crud_drop_view Integer Both
Mysqlx_crud_find Integer Both
Mysqlx_crud_insert Integer Both
Mysqlx_crud_modify_view Integer Both
Mysqlx_crud_update Integer Both
Mysqlx_errors_sent Integer Both
Mysqlx_errors_unknown_message_type Integer Both
Mysqlx_expect_close Integer Both
Mysqlx_expect_open Integer Both
Mysqlx_init_error Integer Both
Mysqlx_notice_other_sent Integer Both
Mysqlx_notice_warning_sent Integer Both
Mysqlx_port String Global
Mysqlx_rows_sent Integer Both
Mysqlx_sessions Integer Global
Mysqlx_sessions_accepted Integer Global
Mysqlx_sessions_closed Integer Global
Mysqlx_sessions_fatal_error Integer Global
Mysqlx_sessions_killed Integer Global
Mysqlx_sessions_rejected Integer Global
Mysqlx_socket String Global
Mysqlx_ssl_accept_renegotiates Integer Global
Mysqlx_ssl_accepts Integer Global
Mysqlx_ssl_active Integer Both
Mysqlx_ssl_cipher Integer Both
Mysqlx_ssl_cipher_list Integer Both
Mysqlx_ssl_ctx_verify_depth Integer Both
Mysqlx_ssl_ctx_verify_mode Integer Both
Mysqlx_ssl_finished_accepts Integer Global
Mysqlx_ssl_server_not_after Integer Global
Mysqlx_ssl_server_not_before Integer Global
Mysqlx_ssl_verify_depth Integer Global
Mysqlx_ssl_verify_mode Integer Global
Mysqlx_ssl_version Integer Both
Mysqlx_stmt_create_collection Integer Both
Mysqlx_stmt_create_collection_index Integer Both
Mysqlx_stmt_disable_notices Integer Both
Mysqlx_stmt_drop_collection Integer Both
Mysqlx_stmt_drop_collection_index Integer Both
Mysqlx_stmt_enable_notices Integer Both
Mysqlx_stmt_ensure_collection String Both
Mysqlx_stmt_execute_mysqlx Integer Both
Mysqlx_stmt_execute_sql Integer Both
Mysqlx_stmt_execute_xplugin Integer Both
Mysqlx_stmt_kill_client Integer Both
Mysqlx_stmt_list_clients Integer Both
Mysqlx_stmt_list_notices Integer Both
Mysqlx_stmt_list_objects Integer Both
Mysqlx_stmt_ping Integer Both
Mysqlx_worker_threads Integer Global
Mysqlx_worker_threads_active Integer Global
Ndb_api_adaptive_send_deferred_count Integer Global
Ndb_api_adaptive_send_deferred_count_slave Integer Global
Ndb_api_adaptive_send_deferred_count_slave Integer Global
Ndb_api_adaptive_send_forced_count Integer Global
Ndb_api_adaptive_send_forced_count_session Integer Global
Ndb_api_adaptive_send_forced_count_slave Integer Global
Ndb_api_adaptive_send_unforced_count Integer Global
Ndb_api_adaptive_send_unforced_count_session Integer Global
Ndb_api_adaptive_send_unforced_count_slave Integer Global
Ndb_api_bytes_received_count Integer Global
Ndb_api_bytes_received_count_session Integer Session
Ndb_api_bytes_received_count_slave Integer Global
Ndb_api_bytes_sent_count Integer Global
Ndb_api_bytes_sent_count_session Integer Session
Ndb_api_bytes_sent_count_slave Integer Global
Ndb_api_event_bytes_count Integer Global
Ndb_api_event_bytes_count_injector Integer Global
Ndb_api_event_data_count Integer Global
Ndb_api_event_data_count_injector Integer Global
Ndb_api_event_nondata_count Integer Global
Ndb_api_event_nondata_count_injector Integer Global
Ndb_api_pk_op_count Integer Global
Ndb_api_pk_op_count_session Integer Session
Ndb_api_pk_op_count_slave Integer Global
Ndb_api_pruned_scan_count Integer Global
Ndb_api_pruned_scan_count_session Integer Session
Ndb_api_pruned_scan_count_slave Integer Global
Ndb_api_range_scan_count Integer Global
Ndb_api_range_scan_count_session Integer Session
Ndb_api_range_scan_count_slave Integer Global
Ndb_api_read_row_count Integer Global
Ndb_api_read_row_count_session Integer Session
Ndb_api_read_row_count_slave Integer Global
Ndb_api_scan_batch_count Integer Global
Ndb_api_scan_batch_count_session Integer Session
Ndb_api_scan_batch_count_slave Integer Global
Ndb_api_table_scan_count Integer Global
Ndb_api_table_scan_count_session Integer Session
Ndb_api_table_scan_count_slave Integer Global
Ndb_api_trans_abort_count Integer Global
Ndb_api_trans_abort_count_session Integer Session
Ndb_api_trans_abort_count_slave Integer Global
Ndb_api_trans_close_count Integer Global
Ndb_api_trans_close_count_session Integer Session
Ndb_api_trans_close_count_slave Integer Global
Ndb_api_trans_commit_count Integer Global
Ndb_api_trans_commit_count_session Integer Session
Ndb_api_trans_commit_count_slave Integer Global
Ndb_api_trans_local_read_row_count Integer Global
Ndb_api_trans_local_read_row_count_session Integer Session
Ndb_api_trans_local_read_row_count_slave Integer Global
Ndb_api_trans_start_count Integer Global
Ndb_api_trans_start_count_session Integer Session
Ndb_api_trans_start_count_slave Integer Global
Ndb_api_uk_op_count Integer Global
Ndb_api_uk_op_count_session Integer Session
Ndb_api_uk_op_count_slave Integer Global
Ndb_api_wait_exec_complete_count Integer Global
Ndb_api_wait_exec_complete_count_session Integer Session
Ndb_api_wait_exec_complete_count_slave Integer Global
Ndb_api_wait_meta_request_count Integer Global
Ndb_api_wait_meta_request_count_session Integer Session
Ndb_api_wait_meta_request_count_slave Integer Global
Ndb_api_wait_nanos_count Integer Global
Ndb_api_wait_nanos_count_session Integer Session
Ndb_api_wait_nanos_count_slave Integer Global
Ndb_api_wait_scan_result_count Integer Global
Ndb_api_wait_scan_result_count_session Integer Session
Ndb_api_wait_scan_result_count_slave Integer Global
Ndb_cluster_node_id Integer Global
Ndb_config_from_host Integer Both
Ndb_config_from_port Integer Both
Ndb_conflict_fn_epoch Integer Global
Ndb_conflict_fn_epoch_trans Integer Global
Ndb_conflict_fn_epoch2 Integer Global
Ndb_conflict_fn_epoch2_trans Integer Global
Ndb_conflict_fn_max Integer Global
Ndb_conflict_fn_old Integer Global
Ndb_conflict_last_stable_epoch Integer Global
Ndb_conflict_reflected_op_discard_count Integer Global
Ndb_conflict_reflected_op_prepare_count Integer Global
Ndb_conflict_refresh_op_count Integer Global
Ndb_conflict_trans_conflict_commit_count Integer Global
Ndb_conflict_trans_detect_iter_count Integer Global
Ndb_conflict_trans_reject_count Integer Global
Ndb_conflict_trans_row_conflict_count Integer Global
Ndb_conflict_trans_row_reject_count Integer Global
Ndb_epoch_delete_delete_count Integer Global
Ndb_execute_count Integer Global
Ndb_last_commit_epoch_server Integer Global
Ndb_last_commit_epoch_session Integer Session
Ndb_cluster_node_id Integer Global
Ndb_number_of_data_nodes Integer Global
Ndb_pruned_scan_count Integer Global
Ndb_pushed_queries_defined Integer Global
Ndb_pushed_queries_dropped Integer Global
Ndb_pushed_queries_executed Integer Global
Ndb_pushed_reads Integer Global
Ndb_scan_count Integer Global
Not_flushed_delayed_rows Integer Global
Ongoing_anonymous_gtid_violating_transaction_count Integer Global
Ongoing_anonymous_transaction_count Integer Global
Ongoing_automatic_gtid_violating_transaction_count Integer Global
Open_files Integer Global
Open_streams Integer Global
Open_table_definitions Integer Global
Open_tables Integer Both
Opened_files Integer Global
Opened_table_definitions Integer Both
Opened_tables Integer Both
Performance_schema_accounts_lost Integer Global
Performance_schema_cond_classes_lost Integer Global
Performance_schema_cond_instances_lost Integer Global
Performance_schema_digest_lost Integer Global
Performance_schema_file_classes_lost Integer Global
Performance_schema_file_handles_lost Integer Global
Performance_schema_file_instances_lost Integer Global
Performance_schema_hosts_lost Integer Global
Performance_schema_index_stat_lost Integer Global
Performance_schema_locker_lost Integer Global
Performance_schema_memory_classes_lost Integer Global
Performance_schema_metadata_lock_lost Integer Global
Performance_schema_mutex_classes_lost Integer Global
Performance_schema_mutex_instances_lost Integer Global
Performance_schema_nested_statement_lost Integer Global
Performance_schema_prepared_statements_lost Integer Global
Performance_schema_program_lost Integer Global
Performance_schema_rwlock_classes_lost Integer Global
Performance_schema_rwlock_instances_lost Integer Global
Performance_schema_session_connect_attrs_lost Integer Global
Performance_schema_socket_classes_lost Integer Global
Performance_schema_socket_instances_lost Integer Global
Performance_schema_stage_classes_lost Integer Global
Performance_schema_statement_classes_lost Integer Global
Performance_schema_table_handles_lost Integer Global
Performance_schema_table_instances_lost Integer Global
Performance_schema_table_lock_stat_lost Integer Global
Performance_schema_thread_classes_lost Integer Global
Performance_schema_thread_instances_lost Integer Global
Performance_schema_users_lost Integer Global
Prepared_stmt_count Integer Global
Qcache_free_blocks Integer Global
Qcache_free_memory Integer Global
Qcache_hits Integer Global
Qcache_inserts Integer Global
Qcache_lowmem_prunes Integer Global
Qcache_not_cached Integer Global
Qcache_queries_in_cache Integer Global
Qcache_total_blocks Integer Global
Queries Integer Both
Questions Integer Both
Rewriter_number_loaded_rules Integer Global
Rewriter_number_reloads Integer Global
Rewriter_number_rewritten_queries Integer Global
Rewriter_reload_error Boolean Global
Rpl_semi_sync_master_clients Integer Global
Rpl_semi_sync_master_net_avg_wait_time Integer Global
Rpl_semi_sync_master_net_wait_time Integer Global
Rpl_semi_sync_master_net_waits Integer Global
Rpl_semi_sync_master_no_times Integer Global
Rpl_semi_sync_master_no_tx Integer Global
Rpl_semi_sync_master_status Boolean Global
Rpl_semi_sync_master_timefunc_failures Integer Global
Rpl_semi_sync_master_tx_avg_wait_time Integer Global
Rpl_semi_sync_master_tx_wait_time Integer Global
Rpl_semi_sync_master_tx_waits Integer Global
Rpl_semi_sync_master_wait_pos_backtraverse Integer Global
Rpl_semi_sync_master_wait_sessions Integer Global
Rpl_semi_sync_master_yes_tx Integer Global
Rpl_semi_sync_slave_status Boolean Global
Rsa_public_key String Global
Select_full_join Integer Both
Select_full_range_join Integer Both
Select_range Integer Both
Select_range_check Integer Both
Select_scan Integer Both
Slave_heartbeat_period Numeric Global
Slave_last_heartbeat Datetime Global
Slave_open_temp_tables Integer Global
Slave_received_heartbeats Integer Global
Slave_retried_transactions Integer Global
Slave_rows_last_search_algorithm_used String Global
Slave_running String Global
Slow_launch_threads Integer Both
Slow_queries Integer Both
Sort_merge_passes Integer Both
Sort_range Integer Both
Sort_rows Integer Both
Sort_scan Integer Both
Ssl_accept_renegotiates Integer Global
Ssl_accepts Integer Global
Ssl_callback_cache_hits Integer Global
Ssl_cipher String Both
Ssl_cipher_list String Both
Ssl_client_connects Integer Global
Ssl_connect_renegotiates Integer Global
Ssl_ctx_verify_depth Integer Global
Ssl_ctx_verify_mode Integer Global
Ssl_default_timeout Integer Both
Ssl_finished_accepts Integer Global
Ssl_finished_connects Integer Global
Ssl_server_not_after Integer Both
Ssl_server_not_before Integer Both
Ssl_session_cache_hits Integer Global
Ssl_session_cache_misses Integer Global
Ssl_session_cache_mode String Global
Ssl_session_cache_overflows Integer Global
Ssl_session_cache_size Integer Global
Ssl_session_cache_timeouts Integer Global
Ssl_sessions_reused Integer Both
Ssl_used_session_cache_entries Integer Global
Ssl_verify_depth Integer Both
Ssl_verify_mode Integer Both
Ssl_version String Both
Table_locks_immediate Integer Global
Table_locks_waited Integer Global
Table_open_cache_hits Integer Both
Table_open_cache_misses Integer Both
Table_open_cache_overflows Integer Both
Tc_log_max_pages_used Integer Global
Tc_log_page_size Integer Global
Tc_log_page_waits Integer Global
Threads_cached Integer Global
Threads_connected Integer Global
Threads_created Integer Global
Threads_running Integer Global
Uptime Integer Global
Uptime_since_flush_status Integer Global
validate_password_dictionary_file_last_parsed Datetime Global
validate_password_dictionary_file_words_count Integer Global

posted @   seasonzone  阅读(622)  评论(0)  编辑  收藏  举报
编辑推荐：
· .NET Core 中如何实现缓存的预热？
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列：向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列：如何用heaptrack跟踪.NET程序的非托管内存泄露
阅读排行：
· TypeScript + Deepseek 打造卜卦网站：技术与玄学的结合
· Manus的开源复刻OpenManus初探
· 三行代码完成国际化适配，妙~啊~
· .NET Core 中如何实现缓存的预热？
· 阿里巴巴 QwQ-32B真的超越了 DeepSeek R-1吗？
点击右上角即可分享
微信分享提示