5.1.3 服务器选项,系统变量和状态变量参考

下 table 列出了适用于mysqld的所有命令行选项,系统变量和状态变量。

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

有关该 table 特定于 NDB Cluster 的版本,请参见第 21.3.2.5 节“ NDB 群集 mysqld 选项和变量参考”

table5.1 命令行选项,系统变量和状态变量摘要

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
abort-slave-event-countYesYes
Aborted_clientsYesGlobalNo
Aborted_connectsYesGlobalNo
allow-suspicious-udfsYesYes
ansiYesYes
audit-logYesYes
audit_log_buffer_sizeYesYesYesGlobalNo
audit_log_compressionYesYesYesGlobalNo
audit_log_connection_policyYesYesYesGlobalYes
audit_log_current_sessionYesBothNo
Audit_log_current_sizeYesGlobalNo
audit_log_encryptionYesYesYesGlobalNo
Audit_log_event_max_drop_sizeYesGlobalNo
Audit_log_eventsYesGlobalNo
Audit_log_events_filteredYesGlobalNo
Audit_log_events_lostYesGlobalNo
Audit_log_events_writtenYesGlobalNo
audit_log_exclude_accountsYesYesYesGlobalYes
audit_log_fileYesYesYesGlobalNo
audit_log_filter_idYesBothNo
audit_log_flushYesGlobalYes
audit_log_formatYesYesYesGlobalNo
audit_log_include_accountsYesYesYesGlobalYes
audit_log_policyYesYesYesGlobalNo
audit_log_read_buffer_sizeYesYesYesVariesVaries
audit_log_rotate_on_sizeYesYesYesGlobalYes
audit_log_statement_policyYesYesYesGlobalYes
audit_log_strategyYesYesYesGlobalNo
Audit_log_total_sizeYesGlobalNo
Audit_log_write_waitsYesGlobalNo
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_disk_useYesGlobalNo
binlog_cache_sizeYesYesYesGlobalYes
Binlog_cache_useYesGlobalNo
binlog-checksumYesYes
binlog_checksumYesYesYesGlobalYes
binlog_direct_non_transactional_updatesYesYesYesBothYes
binlog-do-dbYesYes
binlog_error_actionYesYesYesGlobalYes
binlog_formatYesYesYesBothYes
binlog_group_commit_sync_delayYesYesYesGlobalYes
binlog_group_commit_sync_no_delay_countYesYesYesGlobalYes
binlog_gtid_simple_recoveryYesYesYesGlobalNo
binlog-ignore-dbYesYes
binlog_max_flush_queue_timeYesYesYesGlobalYes
binlog_order_commitsYesYesYesGlobalYes
binlog-row-event-max-sizeYesYes
binlog_row_imageYesYesYesBothYes
binlog_rows_query_log_eventsYesYesYesBothYes
Binlog_stmt_cache_disk_useYesGlobalNo
binlog_stmt_cache_sizeYesYesYesGlobalYes
Binlog_stmt_cache_useYesGlobalNo
binlog_transaction_dependency_history_sizeYesYesYesGlobalYes
binlog_transaction_dependency_trackingYesYesYesGlobalYes
block_encryption_modeYesYesYesBothYes
bootstrapYesYes
bulk_insert_buffer_sizeYesYesYesBothYes
Bytes_receivedYesBothNo
Bytes_sentYesBothNo
character_set_clientYesBothYes
character-set-client-handshakeYesYes
character_set_connectionYesBothYes
character_set_database(Comments1)YesBothYes
character_set_filesystemYesYesYesBothYes
character_set_resultsYesBothYes
character_set_serverYesYesYesBothYes
character_set_systemYesGlobalNo
character_sets_dirYesYesYesGlobalNo
check_proxy_usersYesYesYesGlobalYes
chrootYesYes
collation_connectionYesBothYes
collation_database(Comments1)YesBothYes
collation_serverYesYesYesBothYes
Com_admin_commandsYesBothNo
Com_alter_dbYesBothNo
Com_alter_db_upgradeYesBothNo
Com_alter_eventYesBothNo
Com_alter_functionYesBothNo
Com_alter_procedureYesBothNo
Com_alter_serverYesBothNo
Com_alter_tableYesBothNo
Com_alter_tablespaceYesBothNo
Com_alter_userYesBothNo
Com_analyzeYesBothNo
Com_assign_to_keycacheYesBothNo
Com_beginYesBothNo
Com_binlogYesBothNo
Com_call_procedureYesBothNo
Com_change_dbYesBothNo
Com_change_masterYesBothNo
Com_change_repl_filterYesBothNo
Com_checkYesBothNo
Com_checksumYesBothNo
Com_commitYesBothNo
Com_create_dbYesBothNo
Com_create_eventYesBothNo
Com_create_functionYesBothNo
Com_create_indexYesBothNo
Com_create_procedureYesBothNo
Com_create_serverYesBothNo
Com_create_tableYesBothNo
Com_create_triggerYesBothNo
Com_create_udfYesBothNo
Com_create_userYesBothNo
Com_create_viewYesBothNo
Com_dealloc_sqlYesBothNo
Com_deleteYesBothNo
Com_delete_multiYesBothNo
Com_doYesBothNo
Com_drop_dbYesBothNo
Com_drop_eventYesBothNo
Com_drop_functionYesBothNo
Com_drop_indexYesBothNo
Com_drop_procedureYesBothNo
Com_drop_serverYesBothNo
Com_drop_tableYesBothNo
Com_drop_triggerYesBothNo
Com_drop_userYesBothNo
Com_drop_viewYesBothNo
Com_empty_queryYesBothNo
Com_execute_sqlYesBothNo
Com_explain_otherYesBothNo
Com_flushYesBothNo
Com_get_diagnosticsYesBothNo
Com_grantYesBothNo
Com_group_replication_startYesGlobalNo
Com_group_replication_stopYesGlobalNo
Com_ha_closeYesBothNo
Com_ha_openYesBothNo
Com_ha_readYesBothNo
Com_helpYesBothNo
Com_insertYesBothNo
Com_insert_selectYesBothNo
Com_install_pluginYesBothNo
Com_killYesBothNo
Com_loadYesBothNo
Com_lock_tablesYesBothNo
Com_optimizeYesBothNo
Com_preload_keysYesBothNo
Com_prepare_sqlYesBothNo
Com_purgeYesBothNo
Com_purge_before_dateYesBothNo
Com_release_savepointYesBothNo
Com_rename_tableYesBothNo
Com_rename_userYesBothNo
Com_repairYesBothNo
Com_replaceYesBothNo
Com_replace_selectYesBothNo
Com_resetYesBothNo
Com_resignalYesBothNo
Com_revokeYesBothNo
Com_revoke_allYesBothNo
Com_rollbackYesBothNo
Com_rollback_to_savepointYesBothNo
Com_savepointYesBothNo
Com_selectYesBothNo
Com_set_optionYesBothNo
Com_show_authorsYesBothNo
Com_show_binlog_eventsYesBothNo
Com_show_binlogsYesBothNo
Com_show_charsetsYesBothNo
Com_show_collationsYesBothNo
Com_show_contributorsYesBothNo
Com_show_create_dbYesBothNo
Com_show_create_eventYesBothNo
Com_show_create_funcYesBothNo
Com_show_create_procYesBothNo
Com_show_create_tableYesBothNo
Com_show_create_triggerYesBothNo
Com_show_create_userYesBothNo
Com_show_databasesYesBothNo
Com_show_engine_logsYesBothNo
Com_show_engine_mutexYesBothNo
Com_show_engine_statusYesBothNo
Com_show_errorsYesBothNo
Com_show_eventsYesBothNo
Com_show_fieldsYesBothNo
Com_show_function_codeYesBothNo
Com_show_function_statusYesBothNo
Com_show_grantsYesBothNo
Com_show_keysYesBothNo
Com_show_master_statusYesBothNo
Com_show_ndb_statusYesBothNo
Com_show_open_tablesYesBothNo
Com_show_pluginsYesBothNo
Com_show_privilegesYesBothNo
Com_show_procedure_codeYesBothNo
Com_show_procedure_statusYesBothNo
Com_show_processlistYesBothNo
Com_show_profileYesBothNo
Com_show_profilesYesBothNo
Com_show_relaylog_eventsYesBothNo
Com_show_slave_hostsYesBothNo
Com_show_slave_statusYesBothNo
Com_show_statusYesBothNo
Com_show_storage_enginesYesBothNo
Com_show_table_statusYesBothNo
Com_show_tablesYesBothNo
Com_show_triggersYesBothNo
Com_show_variablesYesBothNo
Com_show_warningsYesBothNo
Com_shutdownYesBothNo
Com_signalYesBothNo
Com_slave_startYesBothNo
Com_slave_stopYesBothNo
Com_stmt_closeYesBothNo
Com_stmt_executeYesBothNo
Com_stmt_fetchYesBothNo
Com_stmt_prepareYesBothNo
Com_stmt_reprepareYesBothNo
Com_stmt_resetYesBothNo
Com_stmt_send_long_dataYesBothNo
Com_truncateYesBothNo
Com_uninstall_pluginYesBothNo
Com_unlock_tablesYesBothNo
Com_updateYesBothNo
Com_update_multiYesBothNo
Com_xa_commitYesBothNo
Com_xa_endYesBothNo
Com_xa_prepareYesBothNo
Com_xa_recoverYesBothNo
Com_xa_rollbackYesBothNo
Com_xa_startYesBothNo
completion_typeYesYesYesBothYes
CompressionYesSessionNo
concurrent_insertYesYesYesGlobalYes
connect_timeoutYesYesYesGlobalYes
Connection_control_delay_generatedYesGlobalNo
connection_control_failed_connections_thresholdYesYesYesGlobalYes
connection_control_max_connection_delayYesYesYesGlobalYes
connection_control_min_connection_delayYesYesYesGlobalYes
Connection_errors_acceptYesGlobalNo
Connection_errors_internalYesGlobalNo
Connection_errors_max_connectionsYesGlobalNo
Connection_errors_peer_addressYesGlobalNo
Connection_errors_selectYesGlobalNo
Connection_errors_tcpwrapYesGlobalNo
ConnectionsYesGlobalNo
consoleYesYes
core-fileYesYes
core_fileYesGlobalNo
Created_tmp_disk_tablesYesBothNo
Created_tmp_filesYesGlobalNo
Created_tmp_tablesYesBothNo
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
daemonizeYesYes
datadirYesYesYesGlobalNo
date_formatYesGlobalNo
datetime_formatYesGlobalNo
debugYesYesYesBothYes
debug_syncYesSessionYes
debug-sync-timeoutYesYes
default_authentication_pluginYesYesYesGlobalNo
default_password_lifetimeYesYesYesGlobalYes
default_storage_engineYesYesYesBothYes
default-time-zoneYesYes
default_tmp_storage_engineYesYesYesBothYes
default_week_formatYesYesYesBothYes
defaults-extra-fileYes
defaults-fileYes
defaults-group-suffixYes
delay_key_writeYesYesYesGlobalYes
Delayed_errorsYesGlobalNo
delayed_insert_limitYesYesYesGlobalYes
Delayed_insert_threadsYesGlobalNo
delayed_insert_timeoutYesYesYesGlobalYes
delayed_queue_sizeYesYesYesGlobalYes
Delayed_writesYesGlobalNo
des-key-fileYesYes
disable-partition-engine-checkYesYes
disabled_storage_enginesYesYesYesGlobalNo
disconnect_on_expired_passwordYesYesYesGlobalNo
disconnect-slave-event-countYesYes
div_precision_incrementYesYesYesBothYes
early-plugin-loadYesYes
end_markers_in_jsonYesYesYesBothYes
enforce_gtid_consistencyYesYesYesGlobalVaries
eq_range_index_dive_limitYesYesYesBothYes
error_countYesSessionNo
event_schedulerYesYesYesGlobalYes
exit-infoYesYes
expire_logs_daysYesYesYesGlobalYes
explicit_defaults_for_timestampYesYesYesBothYes
external-lockingYesYes
-变量skip_external_locking
external_userYesSessionNo
federatedYesYes
Firewall_access_deniedYesGlobalNo
Firewall_access_grantedYesGlobalNo
Firewall_cached_entriesYesGlobalNo
flushYesYesYesGlobalYes
Flush_commandsYesGlobalNo
flush_timeYesYesYesGlobalYes
foreign_key_checksYesBothYes
ft_boolean_syntaxYesYesYesGlobalYes
ft_max_word_lenYesYesYesGlobalNo
ft_min_word_lenYesYesYesGlobalNo
ft_query_expansion_limitYesYesYesGlobalNo
ft_stopword_fileYesYesYesGlobalNo
gdbYesYes
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_primary_memberYesGlobalNo
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
Handler_commitYesBothNo
Handler_deleteYesBothNo
Handler_discoverYesBothNo
Handler_external_lockYesBothNo
Handler_mrr_initYesBothNo
Handler_prepareYesBothNo
Handler_read_firstYesBothNo
Handler_read_keyYesBothNo
Handler_read_lastYesBothNo
Handler_read_nextYesBothNo
Handler_read_prevYesBothNo
Handler_read_rndYesBothNo
Handler_read_rnd_nextYesBothNo
Handler_rollbackYesBothNo
Handler_savepointYesBothNo
Handler_savepoint_rollbackYesBothNo
Handler_updateYesBothNo
Handler_writeYesBothNo
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
helpYesYes
host_cache_sizeYesYesYesGlobalYes
hostnameYesGlobalNo
identityYesSessionYes
ignore_builtin_innodbYesYesYesGlobalNo
ignore-db-dirYesYes
ignore_db_dirsYesGlobalNo
init_connectYesYesYesGlobalYes
init_fileYesYesYesGlobalNo
init_slaveYesYesYesGlobalYes
initializeYesYes
initialize-insecureYesYes
innodbYesYes
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_available_undo_logsYesGlobalNo
innodb_background_drop_list_emptyYesYesYesGlobalYes
Innodb_buffer_pool_bytes_dataYesGlobalNo
Innodb_buffer_pool_bytes_dirtyYesGlobalNo
innodb_buffer_pool_chunk_sizeYesYesYesGlobalNo
innodb_buffer_pool_dump_at_shutdownYesYesYesGlobalYes
innodb_buffer_pool_dump_nowYesYesYesGlobalYes
innodb_buffer_pool_dump_pctYesYesYesGlobalYes
Innodb_buffer_pool_dump_statusYesGlobalNo
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_load_statusYesGlobalNo
Innodb_buffer_pool_pages_dataYesGlobalNo
Innodb_buffer_pool_pages_dirtyYesGlobalNo
Innodb_buffer_pool_pages_flushedYesGlobalNo
Innodb_buffer_pool_pages_freeYesGlobalNo
Innodb_buffer_pool_pages_latchedYesGlobalNo
Innodb_buffer_pool_pages_miscYesGlobalNo
Innodb_buffer_pool_pages_totalYesGlobalNo
Innodb_buffer_pool_read_aheadYesGlobalNo
Innodb_buffer_pool_read_ahead_evictedYesGlobalNo
Innodb_buffer_pool_read_ahead_rndYesGlobalNo
Innodb_buffer_pool_read_requestsYesGlobalNo
Innodb_buffer_pool_readsYesGlobalNo
Innodb_buffer_pool_resize_statusYesGlobalNo
innodb_buffer_pool_sizeYesYesYesGlobalVaries
Innodb_buffer_pool_wait_freeYesGlobalNo
Innodb_buffer_pool_write_requestsYesGlobalNo
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_fsyncsYesGlobalNo
innodb_data_home_dirYesYesYesGlobalNo
Innodb_data_pending_fsyncsYesGlobalNo
Innodb_data_pending_readsYesGlobalNo
Innodb_data_pending_writesYesGlobalNo
Innodb_data_readYesGlobalNo
Innodb_data_readsYesGlobalNo
Innodb_data_writesYesGlobalNo
Innodb_data_writtenYesGlobalNo
Innodb_dblwr_pages_writtenYesGlobalNo
Innodb_dblwr_writesYesGlobalNo
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_have_atomic_builtinsYesGlobalNo
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_waitsYesGlobalNo
innodb_log_write_ahead_sizeYesYesYesGlobalYes
Innodb_log_write_requestsYesGlobalNo
Innodb_log_writesYesGlobalNo
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_num_open_filesYesGlobalNo
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_os_log_fsyncsYesGlobalNo
Innodb_os_log_pending_fsyncsYesGlobalNo
Innodb_os_log_pending_writesYesGlobalNo
Innodb_os_log_writtenYesGlobalNo
innodb_page_cleanersYesYesYesGlobalNo
Innodb_page_sizeYesGlobalNo
innodb_page_sizeYesYesYesGlobalNo
Innodb_pages_createdYesGlobalNo
Innodb_pages_readYesGlobalNo
Innodb_pages_writtenYesGlobalNo
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_row_lock_current_waitsYesGlobalNo
Innodb_row_lock_timeYesGlobalNo
Innodb_row_lock_time_avgYesGlobalNo
Innodb_row_lock_time_maxYesGlobalNo
Innodb_row_lock_waitsYesGlobalNo
Innodb_rows_deletedYesGlobalNo
Innodb_rows_insertedYesGlobalNo
Innodb_rows_readYesGlobalNo
Innodb_rows_updatedYesGlobalNo
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-fileYesYes
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_truncated_status_writesYesGlobalNo
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
installYes
install-manualYes
interactive_timeoutYesYesYesBothYes
internal_tmp_disk_storage_engineYesYesYesGlobalYes
join_buffer_sizeYesYesYesBothYes
keep_files_on_createYesYesYesBothYes
Key_blocks_not_flushedYesGlobalNo
Key_blocks_unusedYesGlobalNo
Key_blocks_usedYesGlobalNo
key_buffer_sizeYesYesYesGlobalYes
key_cache_age_thresholdYesYesYesGlobalYes
key_cache_block_sizeYesYesYesGlobalYes
key_cache_division_limitYesYesYesGlobalYes
Key_read_requestsYesGlobalNo
Key_readsYesGlobalNo
Key_write_requestsYesGlobalNo
Key_writesYesGlobalNo
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-migration-destinationYesYes
keyring-migration-hostYesYes
keyring-migration-passwordYesYes
keyring-migration-portYesYes
keyring-migration-socketYesYes
keyring-migration-sourceYesYes
keyring-migration-userYesYes
keyring_okv_conf_dirYesYesYesGlobalYes
keyring_operationsYesGlobalYes
languageYesYesYesGlobalNo
large_files_supportYesGlobalNo
large_page_sizeYesGlobalNo
large_pagesYesYesYesGlobalNo
last_insert_idYesSessionYes
Last_query_costYesSessionNo
Last_query_partial_plansYesSessionNo
lc_messagesYesYesYesBothYes
lc_messages_dirYesYesYesGlobalNo
lc_time_namesYesYesYesBothYes
licenseYesGlobalNo
local_infileYesYesYesGlobalYes
local-serviceYes
lock_wait_timeoutYesYesYesBothYes
Locked_connectsYesGlobalNo
locked_in_memoryYesGlobalNo
log-binYesYes
log_binYesGlobalNo
log_bin_basenameYesGlobalNo
log_bin_indexYesYesYesGlobalNo
log_bin_trust_function_creatorsYesYesYesGlobalYes
log_bin_use_v1_row_eventsYesYesYesGlobalNo
log_builtin_as_identified_by_passwordYesYesYesGlobalYes
log_errorYesYesYesGlobalNo
log_error_verbosityYesYesYesGlobalYes
log-isamYesYes
log_outputYesYesYesGlobalYes
log_queries_not_using_indexesYesYesYesGlobalYes
log-rawYesYes
log-short-formatYesYes
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-tcYesYes
log-tc-sizeYesYes
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-fileYesYes
master_info_repositoryYesYesYesGlobalYes
master-retry-countYesYes
master_verify_checksumYesYesYesGlobalYes
max_allowed_packetYesYesYesBothYes
max_binlog_cache_sizeYesYesYesGlobalYes
max-binlog-dump-eventsYesYes
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_execution_time_exceededYesBothNo
Max_execution_time_setYesBothNo
Max_execution_time_set_failedYesBothNo
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_used_connectionsYesGlobalNo
Max_used_connections_timeYesGlobalNo
max_user_connectionsYesYesYesBothYes
max_write_lock_countYesYesYesGlobalYes
mecab_charsetYesGlobalNo
mecab_rc_fileYesYesYesGlobalNo
memlockYesYes
-变量locked_in_memory
metadata_locks_cache_sizeYesYesYesGlobalNo
metadata_locks_hash_instancesYesYesYesGlobalNo
min_examined_row_limitYesYesYesBothYes
multi_range_countYesYesYesBothYes
myisam-block-sizeYesYes
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
mysqlxYesYes
Mysqlx_addressYesGlobalNo
mysqlx_bind_addressYesYesYesGlobalNo
Mysqlx_bytes_receivedYesBothNo
Mysqlx_bytes_sentYesBothNo
mysqlx_connect_timeoutYesYesYesGlobalYes
Mysqlx_connection_accept_errorsYesBothNo
Mysqlx_connection_errorsYesBothNo
Mysqlx_connections_acceptedYesGlobalNo
Mysqlx_connections_closedYesGlobalNo
Mysqlx_connections_rejectedYesGlobalNo
Mysqlx_crud_create_viewYesBothNo
Mysqlx_crud_deleteYesBothNo
Mysqlx_crud_drop_viewYesBothNo
Mysqlx_crud_findYesBothNo
Mysqlx_crud_insertYesBothNo
Mysqlx_crud_modify_viewYesBothNo
Mysqlx_crud_updateYesBothNo
Mysqlx_errors_sentYesBothNo
Mysqlx_errors_unknown_message_typeYesBothNo
Mysqlx_expect_closeYesBothNo
Mysqlx_expect_openYesBothNo
mysqlx_idle_worker_thread_timeoutYesYesYesGlobalYes
Mysqlx_init_errorYesBothNo
mysqlx_max_allowed_packetYesYesYesGlobalYes
mysqlx_max_connectionsYesYesYesGlobalYes
mysqlx_min_worker_threadsYesYesYesGlobalYes
Mysqlx_notice_other_sentYesBothNo
Mysqlx_notice_warning_sentYesBothNo
Mysqlx_portYesGlobalNo
mysqlx_portYesYesYesGlobalNo
mysqlx_port_open_timeoutYesYesYesGlobalNo
Mysqlx_rows_sentYesBothNo
Mysqlx_sessionsYesGlobalNo
Mysqlx_sessions_acceptedYesGlobalNo
Mysqlx_sessions_closedYesGlobalNo
Mysqlx_sessions_fatal_errorYesGlobalNo
Mysqlx_sessions_killedYesGlobalNo
Mysqlx_sessions_rejectedYesGlobalNo
Mysqlx_socketYesGlobalNo
mysqlx_socketYesYesYesGlobalNo
Mysqlx_ssl_accept_renegotiatesYesGlobalNo
Mysqlx_ssl_acceptsYesGlobalNo
Mysqlx_ssl_activeYesBothNo
mysqlx_ssl_caYesYesYesGlobalNo
mysqlx_ssl_capathYesYesYesGlobalNo
mysqlx_ssl_certYesYesYesGlobalNo
Mysqlx_ssl_cipherYesBothNo
mysqlx_ssl_cipherYesYesYesGlobalNo
Mysqlx_ssl_cipher_listYesBothNo
mysqlx_ssl_crlYesYesYesGlobalNo
mysqlx_ssl_crlpathYesYesYesGlobalNo
Mysqlx_ssl_ctx_verify_depthYesBothNo
Mysqlx_ssl_ctx_verify_modeYesBothNo
Mysqlx_ssl_finished_acceptsYesGlobalNo
mysqlx_ssl_keyYesYesYesGlobalNo
Mysqlx_ssl_server_not_afterYesGlobalNo
Mysqlx_ssl_server_not_beforeYesGlobalNo
Mysqlx_ssl_verify_depthYesGlobalNo
Mysqlx_ssl_verify_modeYesGlobalNo
Mysqlx_ssl_versionYesBothNo
Mysqlx_stmt_create_collectionYesBothNo
Mysqlx_stmt_create_collection_indexYesBothNo
Mysqlx_stmt_disable_noticesYesBothNo
Mysqlx_stmt_drop_collectionYesBothNo
Mysqlx_stmt_drop_collection_indexYesBothNo
Mysqlx_stmt_enable_noticesYesBothNo
Mysqlx_stmt_ensure_collectionYesBothNo
Mysqlx_stmt_execute_mysqlxYesBothNo
Mysqlx_stmt_execute_sqlYesBothNo
Mysqlx_stmt_execute_xpluginYesBothNo
Mysqlx_stmt_kill_clientYesBothNo
Mysqlx_stmt_list_clientsYesBothNo
Mysqlx_stmt_list_noticesYesBothNo
Mysqlx_stmt_list_objectsYesBothNo
Mysqlx_stmt_pingYesBothNo
Mysqlx_worker_threadsYesGlobalNo
Mysqlx_worker_threads_activeYesGlobalNo
named_pipeYesYesYesGlobalNo
named_pipe_full_access_groupYesYesYesGlobalNo
ndb_allow_copying_alter_tableYesYesYesBothYes
Ndb_api_bytes_received_countYesGlobalNo
Ndb_api_bytes_received_count_sessionYesSessionNo
Ndb_api_bytes_received_count_slaveYesGlobalNo
Ndb_api_bytes_sent_countYesGlobalNo
Ndb_api_bytes_sent_count_sessionYesSessionNo
Ndb_api_bytes_sent_count_slaveYesGlobalNo
Ndb_api_event_bytes_countYesGlobalNo
Ndb_api_event_bytes_count_injectorYesGlobalNo
Ndb_api_event_data_countYesGlobalNo
Ndb_api_event_data_count_injectorYesGlobalNo
Ndb_api_event_nondata_countYesGlobalNo
Ndb_api_event_nondata_count_injectorYesGlobalNo
Ndb_api_pk_op_countYesGlobalNo
Ndb_api_pk_op_count_sessionYesSessionNo
Ndb_api_pk_op_count_slaveYesGlobalNo
Ndb_api_pruned_scan_countYesGlobalNo
Ndb_api_pruned_scan_count_sessionYesSessionNo
Ndb_api_pruned_scan_count_slaveYesGlobalNo
Ndb_api_range_scan_countYesGlobalNo
Ndb_api_range_scan_count_sessionYesSessionNo
Ndb_api_range_scan_count_slaveYesGlobalNo
Ndb_api_read_row_countYesGlobalNo
Ndb_api_read_row_count_sessionYesSessionNo
Ndb_api_read_row_count_slaveYesGlobalNo
Ndb_api_scan_batch_countYesGlobalNo
Ndb_api_scan_batch_count_sessionYesSessionNo
Ndb_api_scan_batch_count_slaveYesGlobalNo
Ndb_api_table_scan_countYesGlobalNo
Ndb_api_table_scan_count_sessionYesSessionNo
Ndb_api_table_scan_count_slaveYesGlobalNo
Ndb_api_trans_abort_countYesGlobalNo
Ndb_api_trans_abort_count_sessionYesSessionNo
Ndb_api_trans_abort_count_slaveYesGlobalNo
Ndb_api_trans_close_countYesGlobalNo
Ndb_api_trans_close_count_sessionYesSessionNo
Ndb_api_trans_close_count_slaveYesGlobalNo
Ndb_api_trans_commit_countYesGlobalNo
Ndb_api_trans_commit_count_sessionYesSessionNo
Ndb_api_trans_commit_count_slaveYesGlobalNo
Ndb_api_trans_local_read_row_countYesGlobalNo
Ndb_api_trans_local_read_row_count_sessionYesSessionNo
Ndb_api_trans_local_read_row_count_slaveYesGlobalNo
Ndb_api_trans_start_countYesGlobalNo
Ndb_api_trans_start_count_sessionYesSessionNo
Ndb_api_trans_start_count_slaveYesGlobalNo
Ndb_api_uk_op_countYesGlobalNo
Ndb_api_uk_op_count_sessionYesSessionNo
Ndb_api_uk_op_count_slaveYesGlobalNo
Ndb_api_wait_exec_complete_countYesGlobalNo
Ndb_api_wait_exec_complete_count_sessionYesSessionNo
Ndb_api_wait_exec_complete_count_slaveYesGlobalNo
Ndb_api_wait_meta_request_countYesGlobalNo
Ndb_api_wait_meta_request_count_sessionYesSessionNo
Ndb_api_wait_meta_request_count_slaveYesGlobalNo
Ndb_api_wait_nanos_countYesGlobalNo
Ndb_api_wait_nanos_count_sessionYesSessionNo
Ndb_api_wait_nanos_count_slaveYesGlobalNo
Ndb_api_wait_scan_result_countYesGlobalNo
Ndb_api_wait_scan_result_count_sessionYesSessionNo
Ndb_api_wait_scan_result_count_slaveYesGlobalNo
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_cluster_node_idYesGlobalNo
Ndb_config_from_hostYesBothNo
Ndb_config_from_portYesBothNo
Ndb_conflict_fn_epochYesGlobalNo
Ndb_conflict_fn_epoch_transYesGlobalNo
Ndb_conflict_fn_epoch2YesGlobalNo
Ndb_conflict_fn_epoch2_transYesGlobalNo
Ndb_conflict_fn_maxYesGlobalNo
Ndb_conflict_fn_oldYesGlobalNo
Ndb_conflict_last_conflict_epochYesGlobalNo
Ndb_conflict_last_stable_epochYesGlobalNo
Ndb_conflict_reflected_op_discard_countYesGlobalNo
Ndb_conflict_reflected_op_prepare_countYesGlobalNo
Ndb_conflict_refresh_op_countYesGlobalNo
Ndb_conflict_trans_conflict_commit_countYesGlobalNo
Ndb_conflict_trans_detect_iter_countYesGlobalNo
Ndb_conflict_trans_reject_countYesGlobalNo
Ndb_conflict_trans_row_conflict_countYesGlobalNo
Ndb_conflict_trans_row_reject_countYesGlobalNo
ndb-connectstringYesYes
ndb_data_node_neighbourYesYesYesGlobalYes
ndb_default_column_formatYesYesYesGlobalYes
ndb_default_column_formatYesYesYesGlobalYes
ndb_deferred_constraintsYesYesYesBothYes
ndb_deferred_constraintsYesYesYesBothYes
ndb_distributionYesYesYesGlobalYes
ndb_distributionYesYesYesGlobalYes
Ndb_epoch_delete_delete_countYesGlobalNo
ndb_eventbuffer_free_percentYesYesYesGlobalYes
ndb_eventbuffer_max_allocYesYesYesGlobalYes
Ndb_execute_countYesGlobalNo
ndb_extra_loggingYesYesYesGlobalYes
ndb_force_sendYesYesYesBothYes
ndb_fully_replicatedYesYesYesBothYes
ndb_index_stat_enableYesYesYesBothYes
ndb_index_stat_optionYesYesYesBothYes
ndb_join_pushdownYesBothYes
Ndb_last_commit_epoch_serverYesGlobalNo
Ndb_last_commit_epoch_sessionYesSessionNo
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_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-mgmd-hostYesYes
ndb_nodeidYesYesYesGlobalNo
Ndb_number_of_data_nodesYesGlobalNo
ndb_optimization_delayYesYesYesGlobalYes
ndb_optimized_node_selectionYesYesYesGlobalNo
Ndb_pruned_scan_countYesGlobalNo
Ndb_pushed_queries_definedYesGlobalNo
Ndb_pushed_queries_droppedYesGlobalNo
Ndb_pushed_queries_executedYesGlobalNo
Ndb_pushed_readsYesGlobalNo
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_scan_countYesGlobalNo
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-transid-mysql-connection-mapYes
ndb_use_copying_alter_tableYesBothNo
ndb_use_exact_countYesBothYes
ndb_use_transactionsYesYesYesBothYes
ndb_versionYesGlobalNo
ndb_version_stringYesGlobalNo
ndb_wait_connectedYesYesYesGlobalNo
ndb_wait_setupYesYesYesGlobalNo
ndbclusterYesYes
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
no-defaultsYes
Not_flushed_delayed_rowsYesGlobalNo
offline_modeYesYesYesGlobalYes
oldYesYesYesGlobalNo
old_alter_tableYesYesYesBothYes
old_passwordsYesYesYesBothYes
old-style-user-limitsYesYes
Ongoing_anonymous_gtid_violating_transaction_countYesGlobalNo
Ongoing_anonymous_transaction_countYesGlobalNo
Ongoing_automatic_gtid_violating_transaction_countYesGlobalNo
Open_filesYesGlobalNo
open_files_limitYesYesYesGlobalNo
Open_streamsYesGlobalNo
Open_table_definitionsYesGlobalNo
Open_tablesYesBothNo
Opened_filesYesGlobalNo
Opened_table_definitionsYesBothNo
Opened_tablesYesBothNo
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
partitionYesYes
performance_schemaYesYesYesGlobalNo
Performance_schema_accounts_lostYesGlobalNo
performance_schema_accounts_sizeYesYesYesGlobalNo
Performance_schema_cond_classes_lostYesGlobalNo
Performance_schema_cond_instances_lostYesGlobalNo
performance-schema-consumer-events-stages-currentYesYes
performance-schema-consumer-events-stages-historyYesYes
performance-schema-consumer-events-stages-history-longYesYes
performance-schema-consumer-events-statements-currentYesYes
performance-schema-consumer-events-statements-historyYesYes
performance-schema-consumer-events-statements-history-longYesYes
performance-schema-consumer-events-transactions-currentYesYes
performance-schema-consumer-events-transactions-historyYesYes
performance-schema-consumer-events-transactions-history-longYesYes
performance-schema-consumer-events-waits-currentYesYes
performance-schema-consumer-events-waits-historyYesYes
performance-schema-consumer-events-waits-history-longYesYes
performance-schema-consumer-global-instrumentationYesYes
performance-schema-consumer-statements-digestYesYes
performance-schema-consumer-thread-instrumentationYesYes
Performance_schema_digest_lostYesGlobalNo
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_file_classes_lostYesGlobalNo
Performance_schema_file_handles_lostYesGlobalNo
Performance_schema_file_instances_lostYesGlobalNo
Performance_schema_hosts_lostYesGlobalNo
performance_schema_hosts_sizeYesYesYesGlobalNo
Performance_schema_index_stat_lostYesGlobalNo
performance-schema-instrumentYesYes
Performance_schema_locker_lostYesGlobalNo
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_memory_classes_lostYesGlobalNo
Performance_schema_metadata_lock_lostYesGlobalNo
Performance_schema_mutex_classes_lostYesGlobalNo
Performance_schema_mutex_instances_lostYesGlobalNo
Performance_schema_nested_statement_lostYesGlobalNo
Performance_schema_prepared_statements_lostYesGlobalNo
Performance_schema_program_lostYesGlobalNo
Performance_schema_rwlock_classes_lostYesGlobalNo
Performance_schema_rwlock_instances_lostYesGlobalNo
Performance_schema_session_connect_attrs_lostYesGlobalNo
performance_schema_session_connect_attrs_sizeYesYesYesGlobalNo
performance_schema_setup_actors_sizeYesYesYesGlobalNo
performance_schema_setup_objects_sizeYesYesYesGlobalNo
Performance_schema_socket_classes_lostYesGlobalNo
Performance_schema_socket_instances_lostYesGlobalNo
Performance_schema_stage_classes_lostYesGlobalNo
Performance_schema_statement_classes_lostYesGlobalNo
Performance_schema_table_handles_lostYesGlobalNo
Performance_schema_table_instances_lostYesGlobalNo
Performance_schema_table_lock_stat_lostYesGlobalNo
Performance_schema_thread_classes_lostYesGlobalNo
Performance_schema_thread_instances_lostYesGlobalNo
Performance_schema_users_lostYesGlobalNo
performance_schema_users_sizeYesYesYesGlobalNo
pid_fileYesYesYesGlobalNo
plugin_dirYesYesYesGlobalNo
plugin_loadYesYesYesGlobalNo
plugin_load_addYesYesYesGlobalNo
plugin-xxxYesYes
portYesYesYesGlobalNo
port-open-timeoutYesYes
preload_buffer_sizeYesYesYesBothYes
Prepared_stmt_countYesGlobalNo
print-defaultsYes
profilingYesBothYes
profiling_history_sizeYesYesYesBothYes
protocol_versionYesGlobalNo
proxy_userYesSessionNo
pseudo_slave_modeYesSessionYes
pseudo_thread_idYesSessionYes
Qcache_free_blocksYesGlobalNo
Qcache_free_memoryYesGlobalNo
Qcache_hitsYesGlobalNo
Qcache_insertsYesGlobalNo
Qcache_lowmem_prunesYesGlobalNo
Qcache_not_cachedYesGlobalNo
Qcache_queries_in_cacheYesGlobalNo
Qcache_total_blocksYesGlobalNo
QueriesYesBothNo
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
QuestionsYesBothNo
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
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
removeYes
replicate-do-dbYesYes
replicate-do-tableYesYes
replicate-ignore-dbYesYes
replicate-ignore-tableYesYes
replicate-rewrite-dbYesYes
replicate-same-server-idYesYes
replicate-wild-do-tableYesYes
replicate-wild-ignore-tableYesYes
report_hostYesYesYesGlobalNo
report_passwordYesYesYesGlobalNo
report_portYesYesYesGlobalNo
report_userYesYesYesGlobalNo
require_secure_transportYesYesYesGlobalYes
rewriter_enabledYesGlobalYes
Rewriter_number_loaded_rulesYesGlobalNo
Rewriter_number_reloadsYesGlobalNo
Rewriter_number_rewritten_queriesYesGlobalNo
Rewriter_reload_errorYesGlobalNo
rewriter_verboseYesGlobalYes
Rpl_semi_sync_master_clientsYesGlobalNo
rpl_semi_sync_master_enabledYesYesYesGlobalYes
Rpl_semi_sync_master_net_avg_wait_timeYesGlobalNo
Rpl_semi_sync_master_net_wait_timeYesGlobalNo
Rpl_semi_sync_master_net_waitsYesGlobalNo
Rpl_semi_sync_master_no_timesYesGlobalNo
Rpl_semi_sync_master_no_txYesGlobalNo
Rpl_semi_sync_master_statusYesGlobalNo
Rpl_semi_sync_master_timefunc_failuresYesGlobalNo
rpl_semi_sync_master_timeoutYesYesYesGlobalYes
rpl_semi_sync_master_trace_levelYesYesYesGlobalYes
Rpl_semi_sync_master_tx_avg_wait_timeYesGlobalNo
Rpl_semi_sync_master_tx_wait_timeYesGlobalNo
Rpl_semi_sync_master_tx_waitsYesGlobalNo
rpl_semi_sync_master_wait_for_slave_countYesYesYesGlobalYes
rpl_semi_sync_master_wait_no_slaveYesYesYesGlobalYes
rpl_semi_sync_master_wait_pointYesYesYesGlobalYes
Rpl_semi_sync_master_wait_pos_backtraverseYesGlobalNo
Rpl_semi_sync_master_wait_sessionsYesGlobalNo
Rpl_semi_sync_master_yes_txYesGlobalNo
rpl_semi_sync_slave_enabledYesYesYesGlobalYes
Rpl_semi_sync_slave_statusYesGlobalNo
rpl_semi_sync_slave_trace_levelYesYesYesGlobalYes
rpl_stop_slave_timeoutYesYesYesGlobalYes
Rsa_public_keyYesGlobalNo
safe-user-createYesYes
secure_authYesYesYesGlobalYes
secure_file_privYesYesYesGlobalNo
Select_full_joinYesBothNo
Select_full_range_joinYesBothNo
Select_rangeYesBothNo
Select_range_checkYesBothNo
Select_scanYesBothNo
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
show-slave-auth-infoYesYes
skip-character-set-client-handshakeYesYes
skip_external_lockingYesYesYesGlobalNo
skip-grant-tablesYesYes
skip-host-cacheYesYes
skip_name_resolveYesYesYesGlobalNo
skip-ndbclusterYesYes
skip_networkingYesYesYesGlobalNo
skip-newYesYes
skip-partitionYesYes
skip_show_databaseYesYesYesGlobalNo
skip-slave-startYesYes
skip-sslYesYes
skip-stack-traceYesYes
slave_allow_batchingYesYesYesGlobalYes
slave_checkpoint_groupYesYesYesGlobalYes
slave_checkpoint_periodYesYesYesGlobalYes
slave_compressed_protocolYesYesYesGlobalYes
slave_exec_modeYesYesYesGlobalYes
Slave_heartbeat_periodYesGlobalNo
Slave_last_heartbeatYesGlobalNo
slave_load_tmpdirYesYesYesGlobalNo
slave_max_allowed_packetYesYesYesGlobalYes
slave_net_timeoutYesYesYesGlobalYes
Slave_open_temp_tablesYesGlobalNo
slave_parallel_typeYesYesYesGlobalYes
slave_parallel_workersYesYesYesGlobalYes
slave_pending_jobs_size_maxYesYesYesGlobalYes
slave_preserve_commit_orderYesYesYesGlobalYes
Slave_received_heartbeatsYesGlobalNo
Slave_retried_transactionsYesGlobalNo
Slave_rows_last_search_algorithm_usedYesGlobalNo
slave_rows_search_algorithmsYesYesYesGlobalYes
Slave_runningYesGlobalNo
slave_skip_errorsYesYesYesGlobalNo
slave-sql-verify-checksumYesYes
slave_sql_verify_checksumYesYesYesGlobalYes
slave_transaction_retriesYesYesYesGlobalYes
slave_type_conversionsYesYesYesGlobalNo
Slow_launch_threadsYesBothNo
slow_launch_timeYesYesYesGlobalYes
Slow_queriesYesBothNo
slow_query_logYesYesYesGlobalYes
slow_query_log_fileYesYesYesGlobalYes
slow-start-timeoutYesYes
socketYesYesYesGlobalNo
sort_buffer_sizeYesYesYesBothYes
Sort_merge_passesYesBothNo
Sort_rangeYesBothNo
Sort_rowsYesBothNo
Sort_scanYesBothNo
sporadic-binlog-dump-failYesYes
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
sslYesYes
Ssl_accept_renegotiatesYesGlobalNo
Ssl_acceptsYesGlobalNo
ssl_caYesYesYesGlobalNo
Ssl_callback_cache_hitsYesGlobalNo
ssl_capathYesYesYesGlobalNo
ssl_certYesYesYesGlobalNo
Ssl_cipherYesBothNo
ssl_cipherYesYesYesGlobalNo
Ssl_cipher_listYesBothNo
Ssl_client_connectsYesGlobalNo
Ssl_connect_renegotiatesYesGlobalNo
ssl_crlYesYesYesGlobalNo
ssl_crlpathYesYesYesGlobalNo
Ssl_ctx_verify_depthYesGlobalNo
Ssl_ctx_verify_modeYesGlobalNo
Ssl_default_timeoutYesBothNo
Ssl_finished_acceptsYesGlobalNo
Ssl_finished_connectsYesGlobalNo
ssl_keyYesYesYesGlobalNo
Ssl_server_not_afterYesBothNo
Ssl_server_not_beforeYesBothNo
Ssl_session_cache_hitsYesGlobalNo
Ssl_session_cache_missesYesGlobalNo
Ssl_session_cache_modeYesGlobalNo
Ssl_session_cache_overflowsYesGlobalNo
Ssl_session_cache_sizeYesGlobalNo
Ssl_session_cache_timeoutsYesGlobalNo
Ssl_sessions_reusedYesBothNo
Ssl_used_session_cache_entriesYesGlobalNo
Ssl_verify_depthYesBothNo
Ssl_verify_modeYesBothNo
Ssl_versionYesBothNo
standaloneYesYes
stored_program_cacheYesYesYesGlobalYes
super-large-pagesYesYes
super_read_onlyYesYesYesGlobalYes
symbolic-linksYesYes
sync_binlogYesYesYesGlobalYes
sync_frmYesYesYesGlobalYes
sync_master_infoYesYesYesGlobalYes
sync_relay_logYesYesYesGlobalYes
sync_relay_log_infoYesYesYesGlobalYes
sysdate-is-nowYesYes
system_time_zoneYesGlobalNo
table_definition_cacheYesYesYesGlobalYes
Table_locks_immediateYesGlobalNo
Table_locks_waitedYesGlobalNo
table_open_cacheYesYesYesGlobalYes
Table_open_cache_hitsYesBothNo
table_open_cache_instancesYesYesYesGlobalNo
Table_open_cache_missesYesBothNo
Table_open_cache_overflowsYesBothNo
tc-heuristic-recoverYesYes
Tc_log_max_pages_usedYesGlobalNo
Tc_log_page_sizeYesGlobalNo
Tc_log_page_waitsYesGlobalNo
temp-poolYesYes
thread_cache_sizeYesYesYesGlobalYes
thread_handlingYesYesYesGlobalNo
thread_pool_algorithmYesYesYesGlobalNo
thread_pool_high_priority_connectionYesYesYesBothYes
thread_pool_max_unused_threadsYesYesYesGlobalYes
thread_pool_prio_kickup_timerYesYesYesBothYes
thread_pool_sizeYesYesYesGlobalNo
thread_pool_stall_limitYesYesYesGlobalYes
thread_stackYesYesYesGlobalNo
Threads_cachedYesGlobalNo
Threads_connectedYesGlobalNo
Threads_createdYesGlobalNo
Threads_runningYesGlobalNo
time_formatYesGlobalNo
time_zoneYesBothYes
timestampYesSessionYes
tls_versionYesYesYesGlobalNo
tmp_table_sizeYesYesYesBothYes
tmpdirYesYesYesGlobalNo
transaction_alloc_block_sizeYesYesYesBothYes
transaction_allow_batchingYesSessionYes
transaction_isolationYesYesBothYes
-变量tx_isolationYesBothYes
transaction_prealloc_sizeYesYesYesBothYes
transaction_read_onlyYesYesBothYes
-变量tx_read_onlyYesBothYes
transaction_write_set_extractionYesYesYesBothYes
tx_isolationYesBothYes
tx_read_onlyYesBothYes
unique_checksYesBothYes
updatable_views_with_limitYesYesYesBothYes
UptimeYesGlobalNo
Uptime_since_flush_statusYesGlobalNo
userYesYes
validate-passwordYesYes
validate_password_check_user_nameYesYesYesGlobalYes
validate_password_dictionary_fileYesYesYesGlobalVaries
validate_password_dictionary_file_last_parsedYesGlobalNo
validate_password_dictionary_file_words_countYesGlobalNo
validate_password_lengthYesYesYesGlobalYes
validate_password_mixed_case_countYesYesYesGlobalYes
validate_password_number_countYesYesYesGlobalYes
validate_password_policyYesYesYesGlobalYes
validate_password_special_char_countYesYesYesGlobalYes
validate_user_pluginsYesYesYesGlobalNo
verboseYesYes
versionYesGlobalNo
version_commentYesGlobalNo
version_compile_machineYesGlobalNo
version_compile_osYesGlobalNo
version_tokens_sessionYesYesYesBothYes
version_tokens_session_numberYesYesYesBothNo
wait_timeoutYesYesYesBothYes
warning_countYesSessionNo

Notes:

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