MySQL 5.7服务器系统变量参考

2023-12-27 06:09:24

?官网地址:MySQL :: MySQL 5.7 Reference Manual :: 5.1.4 Server System Variable Reference

欢迎关注留言,我是收集整理小能手,工具翻译,仅供参考,笔芯笔芯.

MySQL 5.7 参考手册??/??...??/??服务器系统变量参考

5.1.4 服务器系统变量参考

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

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

表 5.2 系统变量汇总

NameCmd-LineOption FileSystem VarVar ScopeDynamic
audit_log_buffer_sizeYesYesYesGlobalNo
audit_log_compressionYesYesYesGlobalNo
audit_log_connection_policyYesYesYesGlobalYes
audit_log_current_sessionYesBothNo
audit_log_disableYesYesYesGlobalYes
audit_log_encryptionYesYesYesGlobalNo
audit_log_exclude_accountsYesYesYesGlobalYes
audit_log_fileYesYesYesGlobalNo
audit_log_filter_idYesBothNo
audit_log_flushYesGlobalYes
audit_log_formatYesYesYesGlobalNo
audit_log_format_unix_timestampYesYesYesGlobalYes
audit_log_include_accountsYesYesYesGlobalYes
audit_log_policyYesYesYesGlobalNo
audit_log_read_buffer_sizeYesYesYesVariesVaries
audit_log_rotate_on_sizeYesYesYesGlobalYes
audit_log_statement_policyYesYesYesGlobalYes
audit_log_strategyYesYesYesGlobalNo
authentication_ldap_sasl_auth_method_nameYesYesYesGlobalYes
authentication_ldap_sasl_bind_base_dnYesYesYesGlobalYes
authentication_ldap_sasl_bind_root_dnYesYesYesGlobalYes
authentication_ldap_sasl_bind_root_pwdYesYesYesGlobalYes
authentication_ldap_sasl_ca_pathYesYesYesGlobalYes
authentication_ldap_sasl_group_search_attrYesYesYesGlobalYes
authentication_ldap_sasl_group_search_filterYesYesYesGlobalYes
authentication_ldap_sasl_init_pool_sizeYesYesYesGlobalYes
authentication_ldap_sasl_log_statusYesYesYesGlobalYes
authentication_ldap_sasl_max_pool_sizeYesYesYesGlobalYes
authentication_ldap_sasl_server_hostYesYesYesGlobalYes
authentication_ldap_sasl_server_portYesYesYesGlobalYes
authentication_ldap_sasl_tlsYesYesYesGlobalYes
authentication_ldap_sasl_user_search_attrYesYesYesGlobalYes
authentication_ldap_simple_auth_method_nameYesYesYesGlobalYes
authentication_ldap_simple_bind_base_dnYesYesYesGlobalYes
authentication_ldap_simple_bind_root_dnYesYesYesGlobalYes
authentication_ldap_simple_bind_root_pwdYesYesYesGlobalYes
authentication_ldap_simple_ca_pathYesYesYesGlobalYes
authentication_ldap_simple_group_search_attrYesYesYesGlobalYes
authentication_ldap_simple_group_search_filterYesYesYesGlobalYes
authentication_ldap_simple_init_pool_sizeYesYesYesGlobalYes
authentication_ldap_simple_log_statusYesYesYesGlobalYes
authentication_ldap_simple_max_pool_sizeYesYesYesGlobalYes
authentication_ldap_simple_server_hostYesYesYesGlobalYes
authentication_ldap_simple_server_portYesYesYesGlobalYes
authentication_ldap_simple_tlsYesYesYesGlobalYes
authentication_ldap_simple_user_search_attrYesYesYesGlobalYes
authentication_windows_log_levelYesYesYesGlobalNo
authentication_windows_use_principal_nameYesYesYesGlobalNo
auto_generate_certsYesYesYesGlobalNo
auto_increment_incrementYesYesYesBothYes
auto_increment_offsetYesYesYesBothYes
autocommitYesYesYesBothYes
automatic_sp_privilegesYesYesYesGlobalYes
avoid_temporal_upgradeYesYesYesGlobalYes
back_logYesYesYesGlobalNo
basedirYesYesYesGlobalNo
big_tablesYesYesYesBothYes
bind_addressYesYesYesGlobalNo
binlog_cache_sizeYesYesYesGlobalYes
binlog_checksumYesYesYesGlobalYes
binlog_direct_non_transactional_updatesYesYesYesBothYes
binlog_error_actionYesYesYesGlobalYes
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_row_imageYesYesYesBothYes
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
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
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
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
date_formatYesGlobalNo
datetime_formatYesGlobalNo
debugYesYesYesBothYes
debug_syncYesSessionYes
default_authentication_pluginYesYesYesGlobalNo
default_password_lifetimeYesYesYesGlobalYes
default_storage_engineYesYesYesBothYes
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
end_markers_in_jsonYesYesYesBothYes
enforce_gtid_consistencyYesYesYesGlobalVaries
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
group_concat_max_lenYesYesYesBothYes
group_replication_allow_local_disjoint_gtids_joinYesYesYesGlobalYes
group_replication_allow_local_lower_version_joinYesYesYesGlobalYes
group_replication_auto_increment_incrementYesYesYesGlobalYes
group_replication_bootstrap_groupYesYesYesGlobalYes
group_replication_components_stop_timeoutYesYesYesGlobalYes
group_replication_compression_thresholdYesYesYesGlobalYes
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_modeYesYesYesGlobalYes
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_weightYesYesYesGlobalYes
group_replication_poll_spin_loopsYesYesYesGlobalYes
group_replication_recovery_complete_atYesYesYesGlobalYes
group_replication_recovery_reconnect_intervalYesYesYesGlobalYes
group_replication_recovery_retry_countYesYesYesGlobalYes
group_replication_recovery_ssl_caYesYesYesGlobalYes
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_use_sslYesYesYesGlobalYes
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_modeYesYesYesGlobalVaries
gtid_nextYesSessionYes
gtid_ownedYesBothNo
gtid_purgedYesGlobalYes
have_compressYesGlobalNo
have_cryptYesGlobalNo
have_dynamic_loadingYesGlobalNo
have_geometryYesGlobalNo
have_opensslYesGlobalNo
have_profilingYesGlobalNo
have_query_cacheYesGlobalNo
have_rtree_keysYesGlobalNo
have_sslYesGlobalNo
have_statement_timeoutYesGlobalNo
have_symlinkYesGlobalNo
host_cache_sizeYesYesYesGlobalYes
hostnameYesGlobalNo
identityYesSessionYes
ignore_builtin_innodbYesYesYesGlobalNo
ignore_db_dirsYesGlobalNo
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_dump_at_shutdownYesYesYesGlobalYes
innodb_buffer_pool_dump_nowYesYesYesGlobalYes
innodb_buffer_pool_dump_pctYesYesYesGlobalYes
innodb_buffer_pool_filenameYesYesYesGlobalYes
innodb_buffer_pool_instancesYesYesYesGlobalNo
innodb_buffer_pool_load_abortYesYesYesGlobalYes
innodb_buffer_pool_load_at_startupYesYesYesGlobalNo
innodb_buffer_pool_load_nowYesYesYesGlobalYes
innodb_buffer_pool_sizeYesYesYesGlobalVaries
innodb_change_buffer_max_sizeYesYesYesGlobalYes
innodb_change_bufferingYesYesYesGlobalYes
innodb_change_buffering_debugYesYesYesGlobalYes
innodb_checksum_algorithmYesYesYesGlobalYes
innodb_checksumsYesYesYesGlobalNo
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_deadlock_detectYesYesYesGlobalYes
innodb_default_row_formatYesYesYesGlobalYes
innodb_disable_resize_buffer_pool_debugYesYesYesGlobalYes
innodb_disable_sort_file_cacheYesYesYesGlobalYes
innodb_doublewriteYesYesYesGlobalNo
innodb_fast_shutdownYesYesYesGlobalYes
innodb_fil_make_page_dirty_debugYesYesYesGlobalYes
innodb_file_formatYesYesYesGlobalYes
innodb_file_format_checkYesYesYesGlobalNo
innodb_file_format_maxYesYesYesGlobalYes
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_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_io_capacityYesYesYesGlobalYes
innodb_io_capacity_maxYesYesYesGlobalYes
innodb_large_prefixYesYesYesGlobalYes
innodb_limit_optimistic_insert_debugYesYesYesGlobalYes
innodb_lock_wait_timeoutYesYesYesBothYes
innodb_locks_unsafe_for_binlogYesYesYesGlobalNo
innodb_log_buffer_sizeYesYesYesGlobalNo
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_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_print_all_deadlocksYesYesYesGlobalYes
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_replication_delayYesYesYesGlobalYes
innodb_rollback_on_timeoutYesYesYesGlobalNo
innodb_rollback_segmentsYesYesYesGlobalYes
innodb_saved_page_number_debugYesYesYesGlobalYes
innodb_sort_buffer_sizeYesYesYesGlobalNo
innodb_spin_wait_delayYesYesYesGlobalYes
innodb_stats_auto_recalcYesYesYesGlobalYes
innodb_stats_include_delete_markedYesYesYesGlobalYes
innodb_stats_methodYesYesYesGlobalYes
innodb_stats_on_metadataYesYesYesGlobalYes
innodb_stats_persistentYesYesYesGlobalYes
innodb_stats_persistent_sample_pagesYesYesYesGlobalYes
innodb_stats_sample_pagesYesYesYesGlobalYes
innodb_stats_transient_sample_pagesYesYesYesGlobalYes
innodb_status_outputYesYesYesGlobalYes
innodb_status_output_locksYesYesYesGlobalYes
innodb_strict_modeYesYesYesBothYes
innodb_support_xaYesYesYesBothYes
innodb_sync_array_sizeYesYesYesGlobalNo
innodb_sync_debugYesYesYesGlobalNo
innodb_sync_spin_loopsYesYesYesGlobalYes
innodb_table_locksYesYesYesBothYes
innodb_temp_data_file_pathYesYesYesGlobalNo
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_truncateYesYesYesGlobalYes
innodb_undo_logsYesYesYesGlobalYes
innodb_undo_tablespacesYesYesYesGlobalNo
innodb_use_native_aioYesYesYesGlobalNo
innodb_versionYesGlobalNo
innodb_write_io_threadsYesYesYesGlobalNo
insert_idYesSessionYes
interactive_timeoutYesYesYesBothYes
internal_tmp_disk_storage_engineYesYesYesGlobalYes
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_dataYesYesYesGlobalYes
keyring_encrypted_file_passwordYesYesYesGlobalYes
keyring_file_dataYesYesYesGlobalYes
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_wait_timeoutYesYesYesBothYes
locked_in_memoryYesGlobalNo
log_binYesGlobalNo
log_bin_basenameYesGlobalNo
log_bin_indexYesYesYesGlobalNo
log_bin_trust_function_creatorsYesYesYesGlobalYes
log_bin_use_v1_row_eventsYesYesYesGlobalYes
log_builtin_as_identified_by_passwordYesYesYesGlobalYes
log_errorYesYesYesGlobalNo
log_error_verbosityYesYesYesGlobalYes
log_outputYesYesYesGlobalYes
log_queries_not_using_indexesYesYesYesGlobalYes
log_slave_updatesYesYesYesGlobalNo
log_slow_admin_statementsYesYesYesGlobalYes
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
log_warningsYesYesYesGlobalYes
long_query_timeYesYesYesBothYes
low_priority_updatesYesYesYesBothYes
lower_case_file_systemYesGlobalNo
lower_case_table_namesYesYesYesGlobalNo
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_dataYesYesYesBothYes
max_points_in_geometryYesYesYesBothYes
max_prepared_stmt_countYesYesYesGlobalYes
max_relay_log_sizeYesYesYesGlobalYes
max_seeks_for_keyYesYesYesBothYes
max_sort_lengthYesYesYesBothYes
max_sp_recursion_depthYesYesYesBothYes
max_tmp_tablesYesBothYes
max_user_connectionsYesYesYesBothYes
max_write_lock_countYesYesYesGlobalYes
mecab_rc_fileYesYesYesGlobalNo
metadata_locks_cache_sizeYesYesYesGlobalNo
metadata_locks_hash_instancesYesYesYesGlobalNo
min_examined_row_limitYesYesYesBothYes
multi_range_countYesYesYesBothYes
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_connect_timeoutYesYesYesGlobalYes
mysqlx_idle_worker_thread_timeoutYesYesYesGlobalYes
mysqlx_max_allowed_packetYesYesYesGlobalYes
mysqlx_max_connectionsYesYesYesGlobalYes
mysqlx_min_worker_threadsYesYesYesGlobalYes
mysqlx_portYesYesYesGlobalNo
mysqlx_port_open_timeoutYesYesYesGlobalNo
mysqlx_socketYesYesYesGlobalNo
mysqlx_ssl_caYesYesYesGlobalNo
mysqlx_ssl_capathYesYesYesGlobalNo
mysqlx_ssl_certYesYesYesGlobalNo
mysqlx_ssl_cipherYesYesYesGlobalNo
mysqlx_ssl_crlYesYesYesGlobalNo
mysqlx_ssl_crlpathYesYesYesGlobalNo
mysqlx_ssl_keyYesYesYesGlobalNo
named_pipeYesYesYesGlobalNo
named_pipe_full_access_groupYesYesYesGlobalNo
ndb_allow_copying_alter_tableYesYesYesBothYes
ndb_autoincrement_prefetch_szYesYesYesBothYes
ndb_batch_sizeYesYesYesBothYes
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_data_node_neighbourYesYesYesGlobalYes
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_binYesYesBothNo
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_fail_terminateYesYesYesGlobalNo
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_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_show_foreign_key_mock_tablesYesYesYesGlobalYes
ndb_slave_conflict_roleYesYesYesGlobalYes
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_prefixYesGlobalNo
ndbinfo_versionYesGlobalNo
net_buffer_lengthYesYesYesBothYes
net_read_timeoutYesYesYesBothYes
net_retry_countYesYesYesBothYes
net_write_timeoutYesYesYesBothYes
newYesYesYesBothYes
ngram_token_sizeYesYesYesGlobalNo
offline_modeYesYesYesGlobalYes
oldYesYesYesGlobalNo
old_alter_tableYesYesYesBothYes
old_passwordsYesYesYesBothYes
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
parser_max_mem_sizeYesYesYesBothYes
performance_schemaYesYesYesGlobalNo
performance_schema_accounts_sizeYesYesYesGlobalNo
performance_schema_digests_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_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_show_processlistYesYesYesGlobalYes
performance_schema_users_sizeYesYesYesGlobalNo
pid_fileYesYesYesGlobalNo
plugin_dirYesYesYesGlobalNo
portYesYesYesGlobalNo
preload_buffer_sizeYesYesYesBothYes
profilingYesBothYes
profiling_history_sizeYesYesYesBothYes
protocol_versionYesGlobalNo
proxy_userYesSessionNo
pseudo_slave_modeYesSessionYes
pseudo_thread_idYesSessionYes
query_alloc_block_sizeYesYesYesBothYes
query_cache_limitYesYesYesGlobalYes
query_cache_min_res_unitYesYesYesGlobalYes
query_cache_sizeYesYesYesGlobalYes
query_cache_typeYesYesYesBothYes
query_cache_wlock_invalidateYesYesYesBothYes
query_prealloc_sizeYesYesYesBothYes
rand_seed1YesSessionYes
rand_seed2YesSessionYes
range_alloc_block_sizeYesYesYesBothYes
range_optimizer_max_mem_sizeYesYesYesBothYes
rbr_exec_modeYesSessionYes
read_buffer_sizeYesYesYesBothYes
read_onlyYesYesYesGlobalYes
read_rnd_buffer_sizeYesYesYesBothYes
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
replication_optimize_for_static_plugin_configYesYesYesGlobalYes
replication_sender_observe_commit_onlyYesYesYesGlobalYes
report_hostYesYesYesGlobalNo
report_passwordYesYesYesGlobalNo
report_portYesYesYesGlobalNo
report_userYesYesYesGlobalNo
require_secure_transportYesYesYesGlobalYes
rewriter_enabledYesGlobalYes
rewriter_verboseYesGlobalYes
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
secure_authYesYesYesGlobalYes
secure_file_privYesYesYesGlobalNo
server_idYesYesYesGlobalYes
server_id_bitsYesYesYesGlobalNo
server_uuidYesGlobalNo
session_track_gtidsYesYesYesBothYes
session_track_schemaYesYesYesBothYes
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_compatibility_56YesYesYesGlobalYes
show_create_table_verbosityYesYesYesBothYes
show_old_temporalsYesYesYesBothYes
skip_external_lockingYesYesYesGlobalNo
skip_name_resolveYesYesYesGlobalNo
skip_networkingYesYesYesGlobalNo
skip_show_databaseYesYesYesGlobalNo
skip_slave_startYesYesYesGlobalNo
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_conversionsYesYesYesGlobalYes
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_safe_updatesYesBothYes
sql_select_limitYesBothYes
sql_slave_skip_counterYesGlobalYes
sql_warningsYesBothYes
ssl_caYesYesYesGlobalNo
ssl_capathYesYesYesGlobalNo
ssl_certYesYesYesGlobalNo
ssl_cipherYesYesYesGlobalNo
ssl_crlYesYesYesGlobalNo
ssl_crlpathYesYesYesGlobalNo
ssl_keyYesYesYesGlobalNo
stored_program_cacheYesYesYesGlobalYes
super_read_onlyYesYesYesGlobalYes
sync_binlogYesYesYesGlobalYes
sync_frmYesYesYesGlobalYes
sync_master_infoYesYesYesGlobalYes
sync_relay_logYesYesYesGlobalYes
sync_relay_log_infoYesYesYesGlobalYes
system_time_zoneYesGlobalNo
table_definition_cacheYesYesYesGlobalYes
table_open_cacheYesYesYesGlobalYes
table_open_cache_instancesYesYesYesGlobalNo
thread_cache_sizeYesYesYesGlobalYes
thread_handlingYesYesYesGlobalNo
thread_pool_algorithmYesYesYesGlobalNo
thread_pool_high_priority_connectionYesYesYesBothYes
thread_pool_max_unused_threadsYesYesYesGlobalYes
thread_pool_prio_kickup_timerYesYesYesGlobalYes
thread_pool_sizeYesYesYesGlobalNo
thread_pool_stall_limitYesYesYesGlobalYes
thread_stackYesYesYesGlobalNo
time_formatYesGlobalNo
time_zoneYesBothYes
timestampYesSessionYes
tls_versionYesYesYesGlobalNo
tmp_table_sizeYesYesYesBothYes
tmpdirYesYesYesGlobalNo
transaction_alloc_block_sizeYesYesYesBothYes
transaction_allow_batchingYesSessionYes
transaction_isolationYesYesYes
-?Variable:?tx_isolationYesBothYes
transaction_prealloc_sizeYesYesYesBothYes
transaction_read_onlyYesYesYes
-?Variable:?tx_read_onlyYesBothYes
transaction_write_set_extractionYesYesYesBothYes
tx_isolationYesBothYes
tx_read_onlyYesBothYes
unique_checksYesBothYes
updatable_views_with_limitYesYesYesBothYes
validate_password_check_user_nameYesYesYesGlobalYes
validate_password_dictionary_fileYesYesYesGlobalVaries
validate_password_lengthYesYesYesGlobalYes
validate_password_mixed_case_countYesYesYesGlobalYes
validate_password_number_countYesYesYesGlobalYes
validate_password_policyYesYesYesGlobalYes
validate_password_special_char_countYesYesYesGlobalYes
versionYesGlobalNo
version_commentYesGlobalNo
version_compile_machineYesGlobalNo
version_compile_osYesGlobalNo
version_tokens_sessionYesYesYesBothYes
version_tokens_session_numberYesYesYesBothNo
wait_timeoutYesYesYesBothYes
warning_countYesSessionNo
?

Notes:

1. 该选项是动态的,但只能由服务器设置。您不应手动设置此变量。

文章来源:https://blog.csdn.net/a309450028a/article/details/135219428
本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。