• 首页
  • css3教程
  • html5教程
  • jQuery手册
  • vue手册
  • php手册
  • MySQL手册
  • apache手册
  • redis手册
  • MySQL服务器系统变量(mysqld)

    下表列出了适用于的所有系统变量mysqld

    该表在一个统一列表中列出了命令行选项(Cmd-line),在配置文件中有效的选项(Option file),服务器系统变量(System Var)和状态变量(Status var),并指出了每个选项的位置或变量有效。如果在命令行或选项文件中设置的服务器选项与相应系统变量的名称不同,则将在相应选项的下方立即标记变量名称。变量的范围(Var Scope)是全局,会话或两者。有关设置和使用变量的详细信息,请参见相应的项目描述。在适当的地方,提供了指向有关该项目的更多信息的直接链接。

    表5.2系统变量摘要

    NameCmd-LineOption FileSystem VarVar ScopeDynamic
    ctivate_all_roles_on_loginYesYesYesGlobalYes
    dmin_addressYesYesYesGlobalNo
    dmin_portYesYesYesGlobalNo
    udit_log_buffer_sizeYesYesYesGlobalNo
    udit_log_compressionYesYesYesGlobalNo
    udit_log_connection_policyYesYesYesGlobalYes
    udit_log_current_sessionYesBothNo
    udit_log_encryptionYesYesYesGlobalNo
    udit_log_exclude_accountsYesYesYesGlobalYes
    udit_log_fileYesYesYesGlobalNo
    udit_log_filter_idYesBothNo
    udit_log_flushYesGlobalYes
    udit_log_formatYesYesYesGlobalNo
    udit_log_include_accountsYesYesYesGlobalYes
    udit_log_password_history_keep_daysYesYesYesGlobalYes
    udit_log_policyYesYesYesGlobalNo
    udit_log_read_buffer_sizeYesYesYesVariesVaries
    udit_log_rotate_on_sizeYesYesYesGlobalYes
    udit_log_statement_policyYesYesYesGlobalYes
    udit_log_strategyYesYesYesGlobalNo
    uthentication_ldap_sasl_auth_method_nameYesYesYesGlobalYes
    uthentication_ldap_sasl_bind_base_dnYesYesYesGlobalYes
    uthentication_ldap_sasl_bind_root_dnYesYesYesGlobalYes
    uthentication_ldap_sasl_bind_root_pwdYesYesYesGlobalYes
    uthentication_ldap_sasl_ca_pathYesYesYesGlobalYes
    uthentication_ldap_sasl_group_search_attrYesYesYesGlobalYes
    uthentication_ldap_sasl_group_search_filterYesYesYesGlobalYes
    uthentication_ldap_sasl_init_pool_sizeYesYesYesGlobalYes
    uthentication_ldap_sasl_log_statusYesYesYesGlobalYes
    uthentication_ldap_sasl_max_pool_sizeYesYesYesGlobalYes
    uthentication_ldap_sasl_server_hostYesYesYesGlobalYes
    uthentication_ldap_sasl_server_portYesYesYesGlobalYes
    uthentication_ldap_sasl_tlsYesYesYesGlobalYes
    uthentication_ldap_sasl_user_search_attrYesYesYesGlobalYes
    uthentication_ldap_simple_auth_method_nameYesYesYesGlobalYes
    uthentication_ldap_simple_bind_base_dnYesYesYesGlobalYes
    uthentication_ldap_simple_bind_root_dnYesYesYesGlobalYes
    uthentication_ldap_simple_bind_root_pwdYesYesYesGlobalYes
    uthentication_ldap_simple_ca_pathYesYesYesGlobalYes
    uthentication_ldap_simple_group_search_attrYesYesYesGlobalYes
    uthentication_ldap_simple_group_search_filterYesYesYesGlobalYes
    uthentication_ldap_simple_init_pool_sizeYesYesYesGlobalYes
    uthentication_ldap_simple_log_statusYesYesYesGlobalYes
    uthentication_ldap_simple_max_pool_sizeYesYesYesGlobalYes
    uthentication_ldap_simple_server_hostYesYesYesGlobalYes
    uthentication_ldap_simple_server_portYesYesYesGlobalYes
    uthentication_ldap_simple_tlsYesYesYesGlobalYes
    uthentication_ldap_simple_user_search_attrYesYesYesGlobalYes
    uthentication_windows_log_levelYesYesYesGlobalNo
    uthentication_windows_use_principal_nameYesYesYesGlobalNo
    uto_generate_certsYesYesYesGlobalNo
    uto_increment_incrementYesYesYesBothYes
    uto_increment_offsetYesYesYesBothYes
    utocommitYesYesYesBothYes
    utomatic_sp_privilegesYesYesYesGlobalYes
    void_temporal_upgradeYesYesYesGlobalYes
    back_logYesYesYesGlobalNo
    basedirYesYesYesGlobalNo
    big_tablesYesYesYesBothYes
    bind_addressYesYesYesGlobalNo
    binlog_cache_sizeYesYesYesGlobalYes
    binlog_checksumYesYesYesGlobalYes
    binlog_direct_non_transactional_updatesYesYesYesBothYes
    binlog_encryptionYesYesYesGlobalYes
    binlog_error_actionYesYesYesGlobalYes
    binlog_expire_logs_secondsYesYesYesGlobalYes
    binlog_formatYesYesYesBothYes
    binlog_group_commit_sync_delayYesYesYesGlobalYes
    binlog_group_commit_sync_no_delay_countYesYesYesGlobalYes
    binlog_gtid_simple_recoveryYesYesYesGlobalNo
    binlog_max_flush_queue_timeYesYesYesGlobalYes
    binlog_order_commitsYesYesYesGlobalYes
    binlog_rotate_encryption_master_key_at_startupYesYesYesGlobalNo
    binlog_row_event_max_sizeYesYesYesGlobalNo
    binlog_row_imageYesYesYesBothYes
    binlog_row_metadat YesYesYesGlobalYes
    binlog_row_value_optionsYesYesYesBothYes
    binlog_rows_query_log_eventsYesYesYesBothYes
    binlog_stmt_cache_sizeYesYesYesGlobalYes
    binlog_transaction_dependency_history_sizeYesYesYesGlobalYes
    binlog_transaction_dependency_trackingYesYesYesGlobalYes
    block_encryption_modeYesYesYesBothYes
    bulk_insert_buffer_sizeYesYesYesBothYes
    caching_sha2_password_auto_generate_rsa_keysYesYesYesGlobalNo
    caching_sha2_password_private_key_pathYesYesYesGlobalNo
    caching_sha2_password_public_key_pathYesYesYesGlobalNo
    character_set_clientYesBothYes
    character_set_connectionYesBothYes
    character_set_database(note 1)YesBothYes
    character_set_filesystemYesYesYesBothYes
    character_set_resultsYesBothYes
    character_set_serverYesYesYesBothYes
    character_set_systemYesGlobalNo
    character_sets_dirYesYesYesGlobalNo
    check_proxy_usersYesYesYesGlobalYes
    clone_autotune_concurrencyYesYesYesGlobalYes
    clone_buffer_sizeYesYesYesGlobalYes
    clone_ddl_timeoutYesYesYesGlobalYes
    clone_enable_compressionYesYesYesGlobalYes
    clone_max_concurrencyYesYesYesGlobalYes
    clone_max_data_bandwidthYesYesYesGlobalYes
    clone_max_network_bandwidthYesYesYesGlobalYes
    clone_ssl_c YesYesYesGlobalYes
    clone_ssl_certYesYesYesGlobalYes
    clone_ssl_keyYesYesYesGlobalYes
    clone_valid_donor_listYesYesYesGlobalYes
    collation_connectionYesBothYes
    collation_database(note 1)YesBothYes
    collation_serverYesYesYesBothYes
    completion_typeYesYesYesBothYes
    concurrent_insertYesYesYesGlobalYes
    connect_timeoutYesYesYesGlobalYes
    connection_control_failed_connections_thresholdYesYesYesGlobalYes
    connection_control_max_connection_delayYesYesYesGlobalYes
    connection_control_min_connection_delayYesYesYesGlobalYes
    core_fileYesGlobalNo
    create_admin_listener_threadYesYesYesGlobalNo
    cte_max_recursion_depthYesYesYesBothYes
    daemon_memcached_enable_binlogYesYesYesGlobalNo
    daemon_memcached_engine_lib_nameYesYesYesGlobalNo
    daemon_memcached_engine_lib_pathYesYesYesGlobalNo
    daemon_memcached_optionYesYesYesGlobalNo
    daemon_memcached_r_batch_sizeYesYesYesGlobalNo
    daemon_memcached_w_batch_sizeYesYesYesGlobalNo
    datadirYesYesYesGlobalNo
    debugYesYesYesBothYes
    debug_syncYesSessionYes
    default_authentication_pluginYesYesYesGlobalNo
    default_collation_for_utf8mb4YesBothYes
    default_password_lifetimeYesYesYesGlobalYes
    default_storage_engineYesYesYesBothYes
    default_table_encryptionYesYesYesBothYes
    default_tmp_storage_engineYesYesYesBothYes
    default_week_formatYesYesYesBothYes
    delay_key_writeYesYesYesGlobalYes
    delayed_insert_limitYesYesYesGlobalYes
    delayed_insert_timeoutYesYesYesGlobalYes
    delayed_queue_sizeYesYesYesGlobalYes
    disabled_storage_enginesYesYesYesGlobalNo
    disconnect_on_expired_passwordYesYesYesGlobalNo
    div_precision_incrementYesYesYesBothYes
    dragnet.log_error_filter_rulesYesYesYesGlobalYes
    end_markers_in_jsonYesYesYesBothYes
    enforce_gtid_consistencyYesYesYesGlobalYes
    eq_range_index_dive_limitYesYesYesBothYes
    error_countYesSessionNo
    event_schedulerYesYesYesGlobalYes
    expire_logs_daysYesYesYesGlobalYes
    explicit_defaults_for_timestampYesYesYesBothYes
    external_userYesSessionNo
    flushYesYesYesGlobalYes
    flush_timeYesYesYesGlobalYes
    foreign_key_checksYesBothYes
    ft_boolean_syntaxYesYesYesGlobalYes
    ft_max_word_lenYesYesYesGlobalNo
    ft_min_word_lenYesYesYesGlobalNo
    ft_query_expansion_limitYesYesYesGlobalNo
    ft_stopword_fileYesYesYesGlobalNo
    general_logYesYesYesGlobalYes
    general_log_fileYesYesYesGlobalYes
    generated_random_password_lengthYesYesYesBothYes
    group_concat_max_lenYesYesYesBothYes
    group_replication_allow_local_lower_version_joinYesYesYesGlobalYes
    group_replication_auto_increment_incrementYesYesYesGlobalYes
    group_replication_autorejoin_triesYesYesYesGlobalYes
    group_replication_bootstrap_groupYesYesYesGlobalYes
    group_replication_clone_thresholdYesYesYesGlobalYes
    group_replication_communication_debug_optionsYesYesYesGlobalYes
    group_replication_communication_max_message_sizeYesYesYesGlobalYes
    group_replication_components_stop_timeoutYesYesYesGlobalYes
    group_replication_compression_thresholdYesYesYesGlobalYes
    group_replication_consistencyYesYesYesBothYes
    group_replication_enforce_update_everywhere_checksYesYesYesGlobalYes
    group_replication_exit_state_actionYesYesYesGlobalYes
    group_replication_flow_control_applier_thresholdYesYesYesGlobalYes
    group_replication_flow_control_certifier_thresholdYesYesYesGlobalYes
    group_replication_flow_control_hold_percentYesYesYesGlobalYes
    group_replication_flow_control_max_commit_quot YesYesYesGlobalYes
    group_replication_flow_control_member_quota_percentYesYesYesGlobalYes
    group_replication_flow_control_min_quot YesYesYesGlobalYes
    group_replication_flow_control_min_recovery_quot YesYesYesGlobalYes
    group_replication_flow_control_modeYesYesYesGlobalYes
    group_replication_flow_control_periodYesYesYesGlobalYes
    group_replication_flow_control_release_percentYesYesYesGlobalYes
    group_replication_force_membersYesYesYesGlobalYes
    group_replication_group_nameYesYesYesGlobalYes
    group_replication_group_seedsYesYesYesGlobalYes
    group_replication_gtid_assignment_block_sizeYesYesYesGlobalYes
    group_replication_ip_whitelistYesYesYesGlobalYes
    group_replication_local_addressYesYesYesGlobalYes
    group_replication_member_expel_timeoutYesYesYesGlobalYes
    group_replication_member_weightYesYesYesGlobalYes
    group_replication_message_cache_sizeYesYesYesGlobalYes
    group_replication_poll_spin_loopsYesYesYesGlobalYes
    group_replication_recovery_complete_atYesYesYesGlobalYes
    group_replication_recovery_compression_algorithmYesYesYesGlobalYes
    group_replication_recovery_get_public_keyYesYesYesGlobalYes
    group_replication_recovery_public_key_pathYesYesYesGlobalYes
    group_replication_recovery_reconnect_intervalYesYesYesGlobalYes
    group_replication_recovery_retry_countYesYesYesGlobalYes
    group_replication_recovery_ssl_c YesYesYesGlobalYes
    group_replication_recovery_ssl_capathYesYesYesGlobalYes
    group_replication_recovery_ssl_certYesYesYesGlobalYes
    group_replication_recovery_ssl_cipherYesYesYesGlobalYes
    group_replication_recovery_ssl_crlYesYesYesGlobalYes
    group_replication_recovery_ssl_crlpathYesYesYesGlobalYes
    group_replication_recovery_ssl_keyYesYesYesGlobalYes
    group_replication_recovery_ssl_verify_server_certYesYesYesGlobalYes
    group_replication_recovery_tls_ciphersuitesYesYesYesGlobalYes
    group_replication_recovery_tls_versionYesYesYesGlobalYes
    group_replication_recovery_use_sslYesYesYesGlobalYes
    group_replication_recovery_zstd_compression_levelYesYesYesGlobalYes
    group_replication_single_primary_modeYesYesYesGlobalYes
    group_replication_ssl_modeYesYesYesGlobalYes
    group_replication_start_on_bootYesYesYesGlobalYes
    group_replication_transaction_size_limitYesYesYesGlobalYes
    group_replication_unreachable_majority_timeoutYesYesYesGlobalYes
    gtid_executedYesVariesNo
    gtid_executed_compression_periodYesYesYesGlobalYes
    gtid_modeYesYesYesGlobalYes
    gtid_nextYesSessionYes
    gtid_ownedYesBothNo
    gtid_purgedYesGlobalYes
    have_compressYesGlobalNo
    have_dynamic_loadingYesGlobalNo
    have_geometryYesGlobalNo
    have_opensslYesGlobalNo
    have_profilingYesGlobalNo
    have_query_cacheYesGlobalNo
    have_rtree_keysYesGlobalNo
    have_sslYesGlobalNo
    have_statement_timeoutYesGlobalNo
    have_symlinkYesGlobalNo
    histogram_generation_max_mem_sizeYesYesYesBothYes
    host_cache_sizeYesYesYesGlobalYes
    hostnameYesGlobalNo
    identityYesSessionYes
    immediate_server_versionYesSessionYes
    information_schema_stats_expiryYesYesYesBothYes
    init_connectYesYesYesGlobalYes
    init_fileYesYesYesGlobalNo
    init_slaveYesYesYesGlobalYes
    innodb_adaptive_flushingYesYesYesGlobalYes
    innodb_adaptive_flushing_lwmYesYesYesGlobalYes
    innodb_adaptive_hash_indexYesYesYesGlobalYes
    innodb_adaptive_hash_index_partsYesYesYesGlobalNo
    innodb_adaptive_max_sleep_delayYesYesYesGlobalYes
    innodb_api_bk_commit_intervalYesYesYesGlobalYes
    innodb_api_disable_rowlockYesYesYesGlobalNo
    innodb_api_enable_binlogYesYesYesGlobalNo
    innodb_api_enable_mdlYesYesYesGlobalNo
    innodb_api_trx_levelYesYesYesGlobalYes
    innodb_autoextend_incrementYesYesYesGlobalYes
    innodb_autoinc_lock_modeYesYesYesGlobalNo
    innodb_background_drop_list_emptyYesYesYesGlobalYes
    innodb_buffer_pool_chunk_sizeYesYesYesGlobalNo
    innodb_buffer_pool_debugYesYesYesGlobalNo
    innodb_buffer_pool_dump_at_shutdownYesYesYesGlobalYes
    innodb_buffer_pool_dump_nowYesYesYesGlobalYes
    innodb_buffer_pool_dump_pctYesYesYesGlobalYes
    innodb_buffer_pool_filenameYesYesYesGlobalYes
    innodb_buffer_pool_in_core_fileYesYesYesGlobalYes
    innodb_buffer_pool_instancesYesYesYesGlobalNo
    innodb_buffer_pool_load_abortYesYesYesGlobalYes
    innodb_buffer_pool_load_at_startupYesYesYesGlobalNo
    innodb_buffer_pool_load_nowYesYesYesGlobalYes
    innodb_buffer_pool_sizeYesYesYesGlobalYes
    innodb_change_buffer_max_sizeYesYesYesGlobalYes
    innodb_change_bufferingYesYesYesGlobalYes
    innodb_change_buffering_debugYesYesYesGlobalYes
    innodb_checkpoint_disabledYesYesYesGlobalYes
    innodb_checksum_algorithmYesYesYesGlobalYes
    innodb_cmp_per_index_enabledYesYesYesGlobalYes
    innodb_commit_concurrencyYesYesYesGlobalYes
    innodb_compress_debugYesYesYesGlobalYes
    innodb_compression_failure_threshold_pctYesYesYesGlobalYes
    innodb_compression_levelYesYesYesGlobalYes
    innodb_compression_pad_pct_maxYesYesYesGlobalYes
    innodb_concurrency_ticketsYesYesYesGlobalYes
    innodb_data_file_pathYesYesYesGlobalNo
    innodb_data_home_dirYesYesYesGlobalNo
    innodb_ddl_log_crash_reset_debugYesYesYesGlobalYes
    innodb_deadlock_detectYesYesYesGlobalYes
    innodb_dedicated_serverYesYesYesGlobalNo
    innodb_default_row_formatYesYesYesGlobalYes
    innodb_directoriesYesYesYesGlobalNo
    innodb_disable_sort_file_cacheYesYesYesGlobalYes
    innodb_doublewriteYesYesYesGlobalNo
    innodb_fast_shutdownYesYesYesGlobalYes
    innodb_fil_make_page_dirty_debugYesYesYesGlobalYes
    innodb_file_per_tableYesYesYesGlobalYes
    innodb_fill_factorYesYesYesGlobalYes
    innodb_flush_log_at_timeoutYesYesYesGlobalYes
    innodb_flush_log_at_trx_commitYesYesYesGlobalYes
    innodb_flush_methodYesYesYesGlobalNo
    innodb_flush_neighborsYesYesYesGlobalYes
    innodb_flush_syncYesYesYesGlobalYes
    innodb_flushing_avg_loopsYesYesYesGlobalYes
    innodb_force_load_corruptedYesYesYesGlobalNo
    innodb_force_recoveryYesYesYesGlobalNo
    innodb_fsync_thresholdYesYesYesGlobalYes
    innodb_ft_aux_tableYesGlobalYes
    innodb_ft_cache_sizeYesYesYesGlobalNo
    innodb_ft_enable_diag_printYesYesYesGlobalYes
    innodb_ft_enable_stopwordYesYesYesBothYes
    innodb_ft_max_token_sizeYesYesYesGlobalNo
    innodb_ft_min_token_sizeYesYesYesGlobalNo
    innodb_ft_num_word_optimizeYesYesYesGlobalYes
    innodb_ft_result_cache_limitYesYesYesGlobalYes
    innodb_ft_server_stopword_tableYesYesYesGlobalYes
    innodb_ft_sort_pll_degreeYesYesYesGlobalNo
    innodb_ft_total_cache_sizeYesYesYesGlobalNo
    innodb_ft_user_stopword_tableYesYesYesBothYes
    innodb_idle_flush_pctYesYesYesGlobalYes
    innodb_io_capacityYesYesYesGlobalYes
    innodb_io_capacity_maxYesYesYesGlobalYes
    innodb_limit_optimistic_insert_debugYesYesYesGlobalYes
    innodb_lock_wait_timeoutYesYesYesBothYes
    innodb_log_buffer_sizeYesYesYesGlobalVaries
    innodb_log_checkpoint_fuzzy_nowYesYesYesGlobalYes
    innodb_log_checkpoint_nowYesYesYesGlobalYes
    innodb_log_checksumsYesYesYesGlobalYes
    innodb_log_compressed_pagesYesYesYesGlobalYes
    innodb_log_file_sizeYesYesYesGlobalNo
    innodb_log_files_in_groupYesYesYesGlobalNo
    innodb_log_group_home_dirYesYesYesGlobalNo
    innodb_log_spin_cpu_abs_lwmYesYesYesGlobalYes
    innodb_log_spin_cpu_pct_hwmYesYesYesGlobalYes
    innodb_log_wait_for_flush_spin_hwmYesYesYesGlobalYes
    innodb_log_write_ahead_sizeYesYesYesGlobalYes
    innodb_lru_scan_depthYesYesYesGlobalYes
    innodb_max_dirty_pages_pctYesYesYesGlobalYes
    innodb_max_dirty_pages_pct_lwmYesYesYesGlobalYes
    innodb_max_purge_lagYesYesYesGlobalYes
    innodb_max_purge_lag_delayYesYesYesGlobalYes
    innodb_max_undo_log_sizeYesYesYesGlobalYes
    innodb_merge_threshold_set_all_debugYesYesYesGlobalYes
    innodb_monitor_disableYesYesYesGlobalYes
    innodb_monitor_enableYesYesYesGlobalYes
    innodb_monitor_resetYesYesYesGlobalYes
    innodb_monitor_reset_allYesYesYesGlobalYes
    innodb_numa_interleaveYesYesYesGlobalNo
    innodb_old_blocks_pctYesYesYesGlobalYes
    innodb_old_blocks_timeYesYesYesGlobalYes
    innodb_online_alter_log_max_sizeYesYesYesGlobalYes
    innodb_open_filesYesYesYesGlobalNo
    innodb_optimize_fulltext_onlyYesYesYesGlobalYes
    innodb_page_cleanersYesYesYesGlobalNo
    innodb_page_sizeYesYesYesGlobalNo
    innodb_parallel_read_threadsYesYesYesSessionYes
    innodb_print_all_deadlocksYesYesYesGlobalYes
    innodb_print_ddl_logsYesYesYesGlobalYes
    innodb_purge_batch_sizeYesYesYesGlobalYes
    innodb_purge_rseg_truncate_frequencyYesYesYesGlobalYes
    innodb_purge_threadsYesYesYesGlobalNo
    innodb_random_read_aheadYesYesYesGlobalYes
    innodb_read_ahead_thresholdYesYesYesGlobalYes
    innodb_read_io_threadsYesYesYesGlobalNo
    innodb_read_onlyYesYesYesGlobalNo
    innodb_redo_log_archive_dirsYesYesYesGlobalYes
    innodb_redo_log_encryptYesYesYesGlobalYes
    innodb_replication_delayYesYesYesGlobalYes
    innodb_rollback_on_timeoutYesYesYesGlobalNo
    innodb_rollback_segmentsYesYesYesGlobalYes
    innodb_saved_page_number_debugYesYesYesGlobalYes
    innodb_sort_buffer_sizeYesYesYesGlobalNo
    innodb_spin_wait_delayYesYesYesGlobalYes
    innodb_spin_wait_pause_multiplierYesYesYesGlobalYes
    innodb_stats_auto_recalcYesYesYesGlobalYes
    innodb_stats_include_delete_markedYesYesYesGlobalYes
    innodb_stats_methodYesYesYesGlobalYes
    innodb_stats_on_metadat YesYesYesGlobalYes
    innodb_stats_persistentYesYesYesGlobalYes
    innodb_stats_persistent_sample_pagesYesYesYesGlobalYes
    innodb_stats_transient_sample_pagesYesYesYesGlobalYes
    innodb_status_outputYesYesYesGlobalYes
    innodb_status_output_locksYesYesYesGlobalYes
    innodb_strict_modeYesYesYesBothYes
    innodb_sync_array_sizeYesYesYesGlobalNo
    innodb_sync_debugYesYesYesGlobalNo
    innodb_sync_spin_loopsYesYesYesGlobalYes
    innodb_table_locksYesYesYesBothYes
    innodb_temp_data_file_pathYesYesYesGlobalNo
    innodb_temp_tablespaces_dirYesYesYesGlobalNo
    innodb_thread_concurrencyYesYesYesGlobalYes
    innodb_thread_sleep_delayYesYesYesGlobalYes
    innodb_tmpdirYesYesYesBothYes
    innodb_trx_purge_view_update_only_debugYesYesYesGlobalYes
    innodb_trx_rseg_n_slots_debugYesYesYesGlobalYes
    innodb_undo_directoryYesYesYesGlobalNo
    innodb_undo_log_encryptYesYesYesGlobalYes
    innodb_undo_log_truncateYesYesYesGlobalYes
    innodb_undo_tablespacesYesYesYesGlobalVaries
    innodb_use_native_aioYesYesYesGlobalNo
    innodb_versionYesGlobalNo
    innodb_write_io_threadsYesYesYesGlobalNo
    insert_idYesSessionYes
    interactive_timeoutYesYesYesBothYes
    internal_tmp_disk_storage_engineYesYesYesGlobalYes
    internal_tmp_mem_storage_engineYesYesYesBothYes
    join_buffer_sizeYesYesYesBothYes
    keep_files_on_createYesYesYesBothYes
    key_buffer_sizeYesYesYesGlobalYes
    key_cache_age_thresholdYesYesYesGlobalYes
    key_cache_block_sizeYesYesYesGlobalYes
    key_cache_division_limitYesYesYesGlobalYes
    keyring_aws_cmk_idYesYesYesGlobalYes
    keyring_aws_conf_fileYesYesYesGlobalNo
    keyring_aws_data_fileYesYesYesGlobalNo
    keyring_aws_regionYesYesYesGlobalYes
    keyring_encrypted_file_dat YesYesYesGlobalYes
    keyring_encrypted_file_passwordYesYesYesGlobalYes
    keyring_file_dat YesYesYesGlobalYes
    keyring_hashicorp_auth_pathYesYesYesGlobalYes
    keyring_hashicorp_ca_pathYesYesYesGlobalYes
    keyring_hashicorp_cachingYesYesYesGlobalYes
    keyring_hashicorp_commit_auth_pathYesGlobalNo
    keyring_hashicorp_commit_ca_pathYesGlobalNo
    keyring_hashicorp_commit_cachingYesGlobalNo
    keyring_hashicorp_commit_role_idYesGlobalNo
    keyring_hashicorp_commit_server_urlYesGlobalNo
    keyring_hashicorp_commit_store_pathYesGlobalNo
    keyring_hashicorp_role_idYesYesYesGlobalYes
    keyring_hashicorp_secret_idYesYesYesGlobalYes
    keyring_hashicorp_server_urlYesYesYesGlobalYes
    keyring_hashicorp_store_pathYesYesYesGlobalYes
    keyring_okv_conf_dirYesYesYesGlobalYes
    keyring_operationsYesGlobalYes
    languageYesYesYesGlobalNo
    large_files_supportYesGlobalNo
    large_page_sizeYesGlobalNo
    large_pagesYesYesYesGlobalNo
    last_insert_idYesSessionYes
    lc_messagesYesYesYesBothYes
    lc_messages_dirYesYesYesGlobalNo
    lc_time_namesYesYesYesBothYes
    licenseYesGlobalNo
    local_infileYesYesYesGlobalYes
    lock_orderYesYesYesGlobalNo
    lock_order_debug_loopYesYesYesGlobalNo
    lock_order_debug_missing_arcYesYesYesGlobalNo
    lock_order_debug_missing_keyYesYesYesGlobalNo
    lock_order_debug_missing_unlockYesYesYesGlobalNo
    lock_order_dependenciesYesYesYesGlobalNo
    lock_order_extra_dependenciesYesYesYesGlobalNo
    lock_order_output_directoryYesYesYesGlobalNo
    lock_order_print_txtYesYesYesGlobalNo
    lock_order_trace_loopYesYesYesGlobalNo
    lock_order_trace_missing_arcYesYesYesGlobalNo
    lock_order_trace_missing_keyYesYesYesGlobalNo
    lock_order_trace_missing_unlockYesYesYesGlobalNo
    lock_wait_timeoutYesYesYesBothYes
    locked_in_memoryYesGlobalNo
    log_binYesGlobalNo
    log_bin_basenameYesGlobalNo
    log_bin_indexYesYesYesGlobalNo
    log_bin_trust_function_creatorsYesYesYesGlobalYes
    log_bin_use_v1_row_eventsYesYesYesGlobalNo
    log_errorYesYesYesGlobalNo
    log_error_servicesYesYesYesGlobalYes
    log_error_suppression_listYesYesYesGlobalYes
    log_error_verbosityYesYesYesGlobalYes
    log_outputYesYesYesGlobalYes
    log_queries_not_using_indexesYesYesYesGlobalYes
    log_rawYesYesYesGlobalYes
    log_slave_updatesYesYesYesGlobalNo
    log_slow_admin_statementsYesYesYesGlobalYes
    log_slow_extr YesYesYesGlobalYes
    log_slow_slave_statementsYesYesYesGlobalYes
    log_statements_unsafe_for_binlogYesYesYesGlobalYes
    log_syslogYesYesYesGlobalYes
    log_syslog_facilityYesYesYesGlobalYes
    log_syslog_include_pidYesYesYesGlobalYes
    log_syslog_tagYesYesYesGlobalYes
    log_throttle_queries_not_using_indexesYesYesYesGlobalYes
    log_timestampsYesYesYesGlobalYes
    long_query_timeYesYesYesBothYes
    low_priority_updatesYesYesYesBothYes
    lower_case_file_systemYesGlobalNo
    lower_case_table_namesYesYesYesGlobalNo
    mandatory_rolesYesYesYesGlobalYes
    master_info_repositoryYesYesYesGlobalYes
    master_verify_checksumYesYesYesGlobalYes
    max_allowed_packetYesYesYesBothYes
    max_binlog_cache_sizeYesYesYesGlobalYes
    max_binlog_sizeYesYesYesGlobalYes
    max_binlog_stmt_cache_sizeYesYesYesGlobalYes
    max_connect_errorsYesYesYesGlobalYes
    max_connectionsYesYesYesGlobalYes
    max_delayed_threadsYesYesYesBothYes
    max_digest_lengthYesYesYesGlobalNo
    max_error_countYesYesYesBothYes
    max_execution_timeYesYesYesBothYes
    max_heap_table_sizeYesYesYesBothYes
    max_insert_delayed_threadsYesBothYes
    max_join_sizeYesYesYesBothYes
    max_length_for_sort_dat YesYesYesBothYes
    max_points_in_geometryYesYesYesBothYes
    max_prepared_stmt_countYesYesYesGlobalYes
    max_relay_log_sizeYesYesYesGlobalYes
    max_seeks_for_keyYesYesYesBothYes
    max_sort_lengthYesYesYesBothYes
    max_sp_recursion_depthYesYesYesBothYes
    max_user_connectionsYesYesYesBothYes
    max_write_lock_countYesYesYesGlobalYes
    mecab_rc_fileYesYesYesGlobalNo
    metadata_locks_cache_sizeYesYesYesGlobalNo
    metadata_locks_hash_instancesYesYesYesGlobalNo
    min_examined_row_limitYesYesYesBothYes
    myisam_data_pointer_sizeYesYesYesGlobalYes
    myisam_max_sort_file_sizeYesYesYesGlobalYes
    myisam_mmap_sizeYesYesYesGlobalNo
    myisam_recover_optionsYesYesYesGlobalNo
    myisam_repair_threadsYesYesYesBothYes
    myisam_sort_buffer_sizeYesYesYesBothYes
    myisam_stats_methodYesYesYesBothYes
    myisam_use_mmapYesYesYesGlobalYes
    mysql_firewall_modeYesYesYesGlobalYes
    mysql_firewall_traceYesYesYesGlobalYes
    mysql_native_password_proxy_usersYesYesYesGlobalYes
    mysqlx_bind_addressYesYesYesGlobalNo
    mysqlx_compression_algorithmsYesYesYesGlobalYes
    mysqlx_connect_timeoutYesYesYesGlobalYes
    mysqlx_document_id_unique_prefixYesYesYesGlobalYes
    mysqlx_enable_hello_noticeYesYesYesGlobalYes
    mysqlx_idle_worker_thread_timeoutYesYesYesGlobalYes
    mysqlx_interactive_timeoutYesYesYesGlobalYes
    mysqlx_max_allowed_packetYesYesYesGlobalYes
    mysqlx_max_connectionsYesYesYesGlobalYes
    mysqlx_min_worker_threadsYesYesYesGlobalYes
    mysqlx_portYesYesYesGlobalNo
    mysqlx_port_open_timeoutYesYesYesGlobalNo
    mysqlx_read_timeoutYesYesYesSessionYes
    mysqlx_socketYesYesYesGlobalNo
    mysqlx_ssl_c YesYesYesGlobalNo
    mysqlx_ssl_capathYesYesYesGlobalNo
    mysqlx_ssl_certYesYesYesGlobalNo
    mysqlx_ssl_cipherYesYesYesGlobalNo
    mysqlx_ssl_crlYesYesYesGlobalNo
    mysqlx_ssl_crlpathYesYesYesGlobalNo
    mysqlx_ssl_keyYesYesYesGlobalNo
    mysqlx_wait_timeoutYesYesYesSessionYes
    mysqlx_write_timeoutYesYesYesSessionYes
    named_pipeYesYesYesGlobalNo
    named_pipe_full_access_groupYesYesYesGlobalNo
    ndb_allow_copying_alter_tableYesYesYesBothYes
    ndb_autoincrement_prefetch_szYesYesYesBothYes
    ndb_batch_sizeYesYesYesGlobalNo
    ndb_blob_read_batch_bytesYesYesYesBothYes
    ndb_blob_write_batch_bytesYesYesYesBothYes
    ndb_cache_check_timeYesYesYesGlobalYes
    ndb_clear_apply_statusYesYesGlobalYes
    ndb_cluster_connection_poolYesYesYesGlobalNo
    ndb_cluster_connection_pool_nodeidsYesYesYesGlobalNo
    Ndb_conflict_last_conflict_epochYesGlobalNo
    ndb_data_node_neighbourYesYesYesGlobalYes
    ndb_dbg_check_sharesYesYesYesBothYes
    ndb_default_column_formatYesYesYesGlobalYes
    ndb_default_column_formatYesYesYesGlobalYes
    ndb_deferred_constraintsYesYesYesBothYes
    ndb_deferred_constraintsYesYesYesBothYes
    ndb_distributionYesYesYesGlobalYes
    ndb_distributionYesYesYesGlobalYes
    ndb_eventbuffer_free_percentYesYesYesGlobalYes
    ndb_eventbuffer_max_allocYesYesYesGlobalYes
    ndb_extra_loggingYesYesYesGlobalYes
    ndb_force_sendYesYesYesBothYes
    ndb_fully_replicatedYesYesYesBothYes
    ndb_index_stat_enableYesYesYesBothYes
    ndb_index_stat_optionYesYesYesBothYes
    ndb_join_pushdownYesBothYes
    ndb_log_apply_statusYesYesYesGlobalNo
    ndb_log_apply_statusYesYesYesGlobalNo
    ndb_log_binYesYesBothYes
    ndb_log_binlog_indexYesYesGlobalYes
    ndb_log_empty_epochsYesYesYesGlobalYes
    ndb_log_empty_epochsYesYesYesGlobalYes
    ndb_log_empty_updateYesYesYesGlobalYes
    ndb_log_empty_updateYesYesYesGlobalYes
    ndb_log_exclusive_readsYesYesYesBothYes
    ndb_log_exclusive_readsYesYesYesBothYes
    ndb_log_origYesYesYesGlobalNo
    ndb_log_origYesYesYesGlobalNo
    ndb_log_transaction_idYesYesYesGlobalNo
    ndb_log_transaction_idYesGlobalNo
    ndb_log_update_as_writeYesYesYesGlobalYes
    ndb_log_update_minimalYesYesYesGlobalYes
    ndb_log_updated_onlyYesYesYesGlobalYes
    ndb_metadata_checkYesYesYesGlobalYes
    ndb_metadata_check_intervalYesYesYesGlobalYes
    ndb_metadata_syncYesGlobalYes
    ndb_optimization_delayYesYesYesGlobalYes
    ndb_optimized_node_selectionYesYesYesGlobalNo
    ndb_read_backupYesYesYesGlobalYes
    ndb_recv_thread_activation_thresholdYesYesYesGlobalYes
    ndb_recv_thread_cpu_maskYesYesYesGlobalYes
    ndb_report_thresh_binlog_epoch_slipYesYesYesGlobalYes
    ndb_report_thresh_binlog_mem_usageYesYesYesGlobalYes
    ndb_row_checksumYesBothYes
    ndb_schema_dist_lock_wait_timeoutYesYesYesGlobalYes
    ndb_schema_dist_timeoutYesYesYesGlobalNo
    ndb_schema_dist_timeoutYesYesYesGlobalNo
    ndb_schema_dist_upgrade_allowedYesYesYesGlobalNo
    ndb_show_foreign_key_mock_tablesYesYesYesGlobalYes
    ndb_slave_conflict_roleYesYesYesGlobalYes
    Ndb_slave_max_replicated_epochYesGlobalNo
    Ndb_system_nameYesGlobalNo
    ndb_table_no_loggingYesSessionYes
    ndb_table_temporaryYesSessionYes
    ndb_use_copying_alter_tableYesBothNo
    ndb_use_exact_countYesBothYes
    ndb_use_transactionsYesYesYesBothYes
    ndb_versionYesGlobalNo
    ndb_version_stringYesGlobalNo
    ndb_wait_connectedYesYesYesGlobalNo
    ndb_wait_setupYesYesYesGlobalNo
    ndbinfo_databaseYesGlobalNo
    ndbinfo_max_bytesYesYesBothYes
    ndbinfo_max_rowsYesYesBothYes
    ndbinfo_offlineYesGlobalYes
    ndbinfo_show_hiddenYesYesBothYes
    ndbinfo_table_prefixYesYesBothYes
    ndbinfo_versionYesGlobalNo
    net_buffer_lengthYesYesYesBothYes
    net_read_timeoutYesYesYesBothYes
    net_retry_countYesYesYesBothYes
    net_write_timeoutYesYesYesBothYes
    newYesYesYesBothYes
    ngram_token_sizeYesYesYesGlobalNo
    offline_modeYesYesYesGlobalYes
    oldYesYesYesGlobalNo
    old_alter_tableYesYesYesBothYes
    open_files_limitYesYesYesGlobalNo
    optimizer_prune_levelYesYesYesBothYes
    optimizer_search_depthYesYesYesBothYes
    optimizer_switchYesYesYesBothYes
    optimizer_traceYesYesYesBothYes
    optimizer_trace_featuresYesYesYesBothYes
    optimizer_trace_limitYesYesYesBothYes
    optimizer_trace_max_mem_sizeYesYesYesBothYes
    optimizer_trace_offsetYesYesYesBothYes
    original_commit_timestampYesSessionYes
    original_server_versionYesSessionYes
    parser_max_mem_sizeYesYesYesBothYes
    partial_revokesYesYesYesGlobalYes
    password_historyYesYesYesGlobalYes
    password_require_currentYesYesYesGlobalYes
    password_reuse_intervalYesYesYesGlobalYes
    performance_schem YesYesYesGlobalNo
    performance_schema_accounts_sizeYesYesYesGlobalNo
    performance_schema_digests_sizeYesYesYesGlobalNo
    performance_schema_error_sizeYesYesYesGlobalNo
    performance_schema_events_stages_history_long_sizeYesYesYesGlobalNo
    performance_schema_events_stages_history_sizeYesYesYesGlobalNo
    performance_schema_events_statements_history_long_sizeYesYesYesGlobalNo
    performance_schema_events_statements_history_sizeYesYesYesGlobalNo
    performance_schema_events_transactions_history_long_sizeYesYesYesGlobalNo
    performance_schema_events_transactions_history_sizeYesYesYesGlobalNo
    performance_schema_events_waits_history_long_sizeYesYesYesGlobalNo
    performance_schema_events_waits_history_sizeYesYesYesGlobalNo
    performance_schema_hosts_sizeYesYesYesGlobalNo
    performance_schema_max_cond_classesYesYesYesGlobalNo
    performance_schema_max_cond_instancesYesYesYesGlobalNo
    performance_schema_max_digest_lengthYesYesYesGlobalNo
    performance_schema_max_digest_sample_ageYesYesYesGlobalYes
    performance_schema_max_file_classesYesYesYesGlobalNo
    performance_schema_max_file_handlesYesYesYesGlobalNo
    performance_schema_max_file_instancesYesYesYesGlobalNo
    performance_schema_max_index_statYesYesYesGlobalNo
    performance_schema_max_memory_classesYesYesYesGlobalNo
    performance_schema_max_metadata_locksYesYesYesGlobalNo
    performance_schema_max_mutex_classesYesYesYesGlobalNo
    performance_schema_max_mutex_instancesYesYesYesGlobalNo
    performance_schema_max_prepared_statements_instancesYesYesYesGlobalNo
    performance_schema_max_program_instancesYesYesYesGlobalNo
    performance_schema_max_rwlock_classesYesYesYesGlobalNo
    performance_schema_max_rwlock_instancesYesYesYesGlobalNo
    performance_schema_max_socket_classesYesYesYesGlobalNo
    performance_schema_max_socket_instancesYesYesYesGlobalNo
    performance_schema_max_sql_text_lengthYesYesYesGlobalNo
    performance_schema_max_stage_classesYesYesYesGlobalNo
    performance_schema_max_statement_classesYesYesYesGlobalNo
    performance_schema_max_statement_stackYesYesYesGlobalNo
    performance_schema_max_table_handlesYesYesYesGlobalNo
    performance_schema_max_table_instancesYesYesYesGlobalNo
    performance_schema_max_table_lock_statYesYesYesGlobalNo
    performance_schema_max_thread_classesYesYesYesGlobalNo
    performance_schema_max_thread_instancesYesYesYesGlobalNo
    performance_schema_session_connect_attrs_sizeYesYesYesGlobalNo
    performance_schema_setup_actors_sizeYesYesYesGlobalNo
    performance_schema_setup_objects_sizeYesYesYesGlobalNo
    performance_schema_users_sizeYesYesYesGlobalNo
    persist_only_admin_x509_subjectYesYesYesGlobalNo
    persisted_globals_loadYesYesYesGlobalNo
    pid_fileYesYesYesGlobalNo
    plugin_dirYesYesYesGlobalNo
    plugin_loadYesYesYesGlobalNo
    plugin_load_addYesYesYesGlobalNo
    portYesYesYesGlobalNo
    preload_buffer_sizeYesYesYesBothYes
    print_identified_with_as_hexYesYesYesBothYes
    profilingYesBothYes
    profiling_history_sizeYesYesYesBothYes
    protocol_compression_algorithmsYesYesYesGlobalYes
    protocol_versionYesGlobalNo
    proxy_userYesSessionNo
    pseudo_slave_modeYesSessionYes
    pseudo_thread_idYesSessionYes
    query_alloc_block_sizeYesYesYesBothYes
    query_prealloc_sizeYesYesYesBothYes
    rand_seed1YesSessionYes
    rand_seed2YesSessionYes
    range_alloc_block_sizeYesYesYesBothYes
    range_optimizer_max_mem_sizeYesYesYesBothYes
    rbr_exec_modeYesBothYes
    read_buffer_sizeYesYesYesBothYes
    read_onlyYesYesYesGlobalYes
    read_rnd_buffer_sizeYesYesYesBothYes
    regexp_stack_limitYesYesYesGlobalYes
    regexp_time_limitYesYesYesGlobalYes
    relay_logYesYesYesGlobalNo
    relay_log_basenameYesGlobalNo
    relay_log_indexYesYesYesGlobalNo
    relay_log_info_fileYesYesYesGlobalNo
    relay_log_info_repositoryYesYesYesGlobalYes
    relay_log_purgeYesYesYesGlobalYes
    relay_log_recoveryYesYesYesGlobalNo
    relay_log_space_limitYesYesYesGlobalNo
    report_hostYesYesYesGlobalNo
    report_passwordYesYesYesGlobalNo
    report_portYesYesYesGlobalNo
    report_userYesYesYesGlobalNo
    require_row_formatYesSessionYes
    require_secure_transportYesYesYesGlobalYes
    resultset_metadat YesSessionYes
    rewriter_enabledYesGlobalYes
    rewriter_verboseYesGlobalYes
    rpl_read_sizeYesYesYesGlobalYes
    rpl_semi_sync_master_enabledYesYesYesGlobalYes
    rpl_semi_sync_master_timeoutYesYesYesGlobalYes
    rpl_semi_sync_master_trace_levelYesYesYesGlobalYes
    rpl_semi_sync_master_wait_for_slave_countYesYesYesGlobalYes
    rpl_semi_sync_master_wait_no_slaveYesYesYesGlobalYes
    rpl_semi_sync_master_wait_pointYesYesYesGlobalYes
    rpl_semi_sync_slave_enabledYesYesYesGlobalYes
    rpl_semi_sync_slave_trace_levelYesYesYesGlobalYes
    rpl_stop_slave_timeoutYesYesYesGlobalYes
    schema_definition_cacheYesYesYesGlobalYes
    secondary_engine_cost_thresholdYesSessionYes
    secure_file_privYesYesYesGlobalNo
    server_idYesYesYesGlobalYes
    server_id_bitsYesYesYesGlobalNo
    server_uuidYesGlobalNo
    session_track_gtidsYesYesYesBothYes
    session_track_schem YesYesYesBothYes
    session_track_state_changeYesYesYesBothYes
    session_track_system_variablesYesYesYesBothYes
    session_track_transaction_infoYesYesYesBothYes
    sha256_password_auto_generate_rsa_keysYesYesYesGlobalNo
    sha256_password_private_key_pathYesYesYesGlobalNo
    sha256_password_proxy_usersYesYesYesGlobalYes
    sha256_password_public_key_pathYesYesYesGlobalNo
    shared_memoryYesYesYesGlobalNo
    shared_memory_base_nameYesYesYesGlobalNo
    show_create_table_skip_secondary_engineYesYesYesSessionYes
    show_create_table_verbosityYesYesYesBothYes
    show_old_temporalsYesYesYesBothYes
    skip_external_lockingYesYesYesGlobalNo
    skip_name_resolveYesYesYesGlobalNo
    skip_networkingYesYesYesGlobalNo
    skip_show_databaseYesYesYesGlobalNo
    slave_allow_batchingYesYesYesGlobalYes
    slave_checkpoint_groupYesYesYesGlobalYes
    slave_checkpoint_periodYesYesYesGlobalYes
    slave_compressed_protocolYesYesYesGlobalYes
    slave_exec_modeYesYesYesGlobalYes
    slave_load_tmpdirYesYesYesGlobalNo
    slave_max_allowed_packetYesYesYesGlobalYes
    slave_net_timeoutYesYesYesGlobalYes
    slave_parallel_typeYesYesYesGlobalYes
    slave_parallel_workersYesYesYesGlobalYes
    slave_pending_jobs_size_maxYesYesYesGlobalYes
    slave_preserve_commit_orderYesYesYesGlobalYes
    slave_rows_search_algorithmsYesYesYesGlobalYes
    slave_skip_errorsYesYesYesGlobalNo
    slave_sql_verify_checksumYesYesYesGlobalYes
    slave_transaction_retriesYesYesYesGlobalYes
    slave_type_conversionsYesYesYesGlobalNo
    slow_launch_timeYesYesYesGlobalYes
    slow_query_logYesYesYesGlobalYes
    slow_query_log_fileYesYesYesGlobalYes
    socketYesYesYesGlobalNo
    sort_buffer_sizeYesYesYesBothYes
    sql_auto_is_nullYesBothYes
    sql_big_selectsYesBothYes
    sql_buffer_resultYesBothYes
    sql_log_binYesSessionYes
    sql_log_offYesBothYes
    sql_modeYesYesYesBothYes
    sql_notesYesBothYes
    sql_quote_show_createYesBothYes
    sql_require_primary_keyYesYesYesBothYes
    sql_safe_updatesYesBothYes
    sql_select_limitYesBothYes
    sql_slave_skip_counterYesGlobalYes
    sql_warningsYesBothYes
    ssl_c YesYesYesGlobalVaries
    ssl_capathYesYesYesGlobalVaries
    ssl_certYesYesYesGlobalVaries
    ssl_cipherYesYesYesGlobalVaries
    ssl_crlYesYesYesGlobalVaries
    ssl_crlpathYesYesYesGlobalVaries
    ssl_fips_modeYesYesYesGlobalYes
    ssl_keyYesYesYesGlobalVaries
    stored_program_cacheYesYesYesGlobalYes
    stored_program_definition_cacheYesYesYesGlobalYes
    super_read_onlyYesYesYesGlobalYes
    sync_binlogYesYesYesGlobalYes
    sync_master_infoYesYesYesGlobalYes
    sync_relay_logYesYesYesGlobalYes
    sync_relay_log_infoYesYesYesGlobalYes
    syseventlog.facilityYesYesYesGlobalYes
    syseventlog.include_pidYesYesYesGlobalYes
    syseventlog.tagYesYesYesGlobalYes
    system_time_zoneYesGlobalNo
    table_definition_cacheYesYesYesGlobalYes
    table_encryption_privilege_checkYesYesYesGlobalYes
    table_open_cacheYesYesYesGlobalYes
    table_open_cache_instancesYesYesYesGlobalNo
    tablespace_definition_cacheYesYesYesGlobalYes
    temptable_max_ramYesYesYesGlobalYes
    temptable_use_mmapYesYesYesGlobalYes
    thread_cache_sizeYesYesYesGlobalYes
    thread_handlingYesYesYesGlobalNo
    thread_pool_algorithmYesYesYesGlobalNo
    thread_pool_high_priority_connectionYesYesYesBothYes
    thread_pool_max_active_query_threadsYesYesYesGlobalYes
    thread_pool_max_unused_threadsYesYesYesGlobalYes
    thread_pool_prio_kickup_timerYesYesYesBothYes
    thread_pool_sizeYesYesYesGlobalNo
    thread_pool_stall_limitYesYesYesGlobalYes
    thread_stackYesYesYesGlobalNo
    time_zoneYesBothYes
    timestampYesSessionYes
    tls_ciphersuitesYesYesYesGlobalYes
    tls_versionYesYesYesGlobalVaries
    tmp_table_sizeYesYesYesBothYes
    tmpdirYesYesYesGlobalNo
    transaction_alloc_block_sizeYesYesYesBothYes
    transaction_allow_batchingYesSessionYes
    transaction_isolationYesYesYesBothYes
    transaction_prealloc_sizeYesYesYesBothYes
    transaction_read_onlyYesYesYesBothYes
    transaction_write_set_extractionYesYesYesBothYes
    unique_checksYesBothYes
    updatable_views_with_limitYesYesYesBothYes
    use_secondary_engineYesSessionYes
    validate_password_check_user_nameYesYesYesGlobalYes
    validate_password_dictionary_fileYesYesYesGlobalYes
    validate_password_lengthYesYesYesGlobalYes
    validate_password_mixed_case_countYesYesYesGlobalYes
    validate_password_number_countYesYesYesGlobalYes
    validate_password_policyYesYesYesGlobalYes
    validate_password_special_char_countYesYesYesGlobalYes
    validate_password.check_user_nameYesYesYesGlobalYes
    validate_password.dictionary_fileYesYesYesGlobalYes
    validate_password.lengthYesYesYesGlobalYes
    validate_password.mixed_case_countYesYesYesGlobalYes
    validate_password.number_countYesYesYesGlobalYes
    validate_password.policyYesYesYesGlobalYes
    validate_password.special_char_countYesYesYesGlobalYes
    validate_user_pluginsYesYesYesGlobalNo
    versionYesGlobalNo
    version_commentYesGlobalNo
    version_compile_machineYesGlobalNo
    version_compile_osYesGlobalNo
    version_compile_zlibYesGlobalNo
    version_tokens_sessionYesYesYesBothYes
    version_tokens_session_numberYesYesYesBothNo
    wait_timeoutYesYesYesBothYes
    warning_countYesSessionNo
    windowing_use_high_precisionYesYesYesBothYes

    注意:此选项是动态的,但只有服务器应设置此信息。您不应手动设置此变量的值。