Skip to main content

4.服务器选项、系统变量和状态变量参考

提示:

官网参考文档:https://dev.mysql.com/doc/refman/8.3/en/server-option-variable-reference.html

下表列出了 mysqld 中适用的所有命令行选项、系统变量和状态变量。

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

Table 7.1 Command-Line Option, System Variable, and Status Variable Summary

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
Aborted_clientsYesGlobalNo
Aborted_connectsYesGlobalNo
Acl_cache_items_countYesGlobalNo
activate_all_roles_on_loginYesYesYesGlobalYes
admin_addressYesYesYesGlobalNo
admin_portYesYesYesGlobalNo
admin-sslYesYes
admin_ssl_caYesYesYesGlobalYes
admin_ssl_capathYesYesYesGlobalYes
admin_ssl_certYesYesYesGlobalYes
admin_ssl_cipherYesYesYesGlobalYes
admin_ssl_crlYesYesYesGlobalYes
admin_ssl_crlpathYesYesYesGlobalYes
admin_ssl_keyYesYesYesGlobalYes
admin_tls_ciphersuitesYesYesYesGlobalYes
admin_tls_versionYesYesYesGlobalYes
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_databaseYesYesYesGlobalNo
Audit_log_direct_writesYesGlobalNo
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_flush_interval_secondsYesYesGlobalNo
audit_log_formatYesYesYesGlobalNo
audit_log_format_unix_timestampYesYesYesGlobalYes
audit_log_include_accountsYesYesYesGlobalYes
audit_log_max_sizeYesYesYesGlobalYes
audit_log_password_history_keep_daysYesYesYesGlobalYes
audit_log_policyYesYesYesGlobalNo
audit_log_prune_secondsYesYesYesGlobalYes
audit_log_read_buffer_sizeYesYesYesBothYes
audit_log_rotate_on_sizeYesYesYesGlobalYes
audit_log_statement_policyYesYesYesGlobalYes
audit_log_strategyYesYesYesGlobalNo
Audit_log_total_sizeYesGlobalNo
Audit_log_write_waitsYesGlobalNo
authentication_fido_rp_idYesYesYesGlobalYes
authentication_kerberos_service_key_tabYesYesYesGlobalNo
authentication_kerberos_service_principalYesYesYesGlobalYes
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_connect_timeoutYesYesYesGlobalYes
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_referralYesYesYesGlobalYes
authentication_ldap_sasl_response_timeoutYesYesYesGlobalYes
authentication_ldap_sasl_server_hostYesYesYesGlobalYes
authentication_ldap_sasl_server_portYesYesYesGlobalYes
Authentication_ldap_sasl_supported_methodsYesGlobalNo
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_connect_timeoutYesYesYesGlobalYes
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_referralYesYesYesGlobalYes
authentication_ldap_simple_response_timeoutYesYesYesGlobalYes
authentication_ldap_simple_server_hostYesYesYesGlobalYes
authentication_ldap_simple_server_portYesYesYesGlobalYes
authentication_ldap_simple_tlsYesYesYesGlobalYes
authentication_ldap_simple_user_search_attrYesYesYesGlobalYes
authentication_policyYesYesYesGlobalYes
authentication_webauthn_rp_idYesYesYesGlobalYes
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_encryptionYesYesYesGlobalYes
binlog_error_actionYesYesYesGlobalYes
binlog_expire_logs_auto_purgeYesYesYesGlobalYes
binlog_expire_logs_secondsYesYesYesGlobalYes
binlog_formatYesYesYesBothYes
binlog_group_commit_sync_delayYesYesYesGlobalYes
binlog_group_commit_sync_no_delay_countYesYesYesGlobalYes
binlog-ignore-dbYesYes
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_metadataYesYesYesGlobalYes
binlog_row_value_optionsYesYesYesBothYes
binlog_rows_query_log_eventsYesYesYesBothYes
Binlog_stmt_cache_disk_useYesGlobalNo
binlog_stmt_cache_sizeYesYesYesGlobalYes
Binlog_stmt_cache_useYesGlobalNo
binlog_transaction_compressionYesYesYesBothYes
binlog_transaction_compression_level_zstdYesYesYesBothYes
binlog_transaction_dependency_history_sizeYesYesYesGlobalYes
binlog_transaction_dependency_trackingYesYesYesGlobalYes
block_encryption_modeYesYesYesBothYes
build_idYesGlobalNo
bulk_insert_buffer_sizeYesYesYesBothYes
Bytes_receivedYesBothNo
Bytes_sentYesBothNo
caching_sha2_password_auto_generate_rsa_keysYesYesYesGlobalNo
caching_sha2_password_digest_roundsYesYesYesGlobalNo
caching_sha2_password_private_key_pathYesYesYesGlobalNo
caching_sha2_password_public_key_pathYesYesYesGlobalNo
Caching_sha2_password_rsa_public_keyYesGlobalNo
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
chrootYesYes
clone_autotune_concurrencyYesYesYesGlobalYes
clone_block_ddlYesYesYesGlobalYes
clone_buffer_sizeYesYesYesGlobalYes
clone_ddl_timeoutYesYesYesGlobalYes
clone_delay_after_data_dropYesYesYesGlobalYes
clone_donor_timeout_after_network_failureYesYesYesGlobalYes
clone_enable_compressionYesYesYesGlobalYes
clone_max_concurrencyYesYesYesGlobalYes
clone_max_data_bandwidthYesYesYesGlobalYes
clone_max_network_bandwidthYesYesYesGlobalYes
clone_ssl_caYesYesYesGlobalYes
clone_ssl_certYesYesYesGlobalYes
clone_ssl_keyYesYesYesGlobalYes
clone_valid_donor_listYesYesYesGlobalYes
collation_connectionYesBothYes
collation_database (note 1)YesBothYes
collation_serverYesYesYesBothYes
Com_admin_commandsYesBothNo
Com_alter_dbYesBothNo
Com_alter_eventYesBothNo
Com_alter_functionYesBothNo
Com_alter_procedureYesBothNo
Com_alter_resource_groupYesGlobalNo
Com_alter_serverYesBothNo
Com_alter_tableYesBothNo
Com_alter_tablespaceYesBothNo
Com_alter_userYesBothNo
Com_alter_user_default_roleYesGlobalNo
Com_analyzeYesBothNo
Com_assign_to_keycacheYesBothNo
Com_beginYesBothNo
Com_binlogYesBothNo
Com_call_procedureYesBothNo
Com_change_dbYesBothNo
Com_change_masterYesBothNo
Com_change_repl_filterYesBothNo
Com_change_replication_sourceYesBothNo
Com_checkYesBothNo
Com_checksumYesBothNo
Com_cloneYesGlobalNo
Com_commitYesBothNo
Com_create_dbYesBothNo
Com_create_eventYesBothNo
Com_create_functionYesBothNo
Com_create_indexYesBothNo
Com_create_procedureYesBothNo
Com_create_resource_groupYesGlobalNo
Com_create_roleYesGlobalNo
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_resource_groupYesGlobalNo
Com_drop_roleYesGlobalNo
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_grant_rolesYesGlobalNo
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_componentYesGlobalNo
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_replica_startYesBothNo
Com_replica_stopYesBothNo
Com_resetYesBothNo
Com_resignalYesBothNo
Com_restartYesBothNo
Com_revokeYesBothNo
Com_revoke_allYesBothNo
Com_revoke_rolesYesGlobalNo
Com_rollbackYesBothNo
Com_rollback_to_savepointYesBothNo
Com_savepointYesBothNo
Com_selectYesBothNo
Com_set_optionYesBothNo
Com_set_resource_groupYesGlobalNo
Com_set_roleYesGlobalNo
Com_show_authorsYesBothNo
Com_show_binary_log_statusYesBothNo
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_replica_statusYesBothNo
Com_show_replicasYesBothNo
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_componentYesGlobalNo
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
component_masking.dictionaries_flush_interval_secondsYesYesYesGlobalNo
component_masking.masking_databaseYesYesYesGlobalNo
component_scheduler.enabledYesYesYesGlobalYes
CompressionYesSessionNo
Compression_algorithmYesGlobalNo
Compression_levelYesGlobalNo
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
connection_memory_chunk_sizeYesYesYesBothYes
connection_memory_limitYesYesYesBothYes
ConnectionsYesGlobalNo
consoleYesYes
core-fileYesYes
core_fileYesGlobalNo
create_admin_listener_threadYesYesYesGlobalNo
Created_tmp_disk_tablesYesBothNo
Created_tmp_filesYesGlobalNo
Created_tmp_tablesYesBothNo
cte_max_recursion_depthYesYesYesBothYes
Current_tls_caYesGlobalNo
Current_tls_capathYesGlobalNo
Current_tls_certYesGlobalNo
Current_tls_cipherYesGlobalNo
Current_tls_ciphersuitesYesGlobalNo
Current_tls_crlYesGlobalNo
Current_tls_crlpathYesGlobalNo
Current_tls_keyYesGlobalNo
Current_tls_versionYesGlobalNo
daemonizeYesYes
datadirYesYesYesGlobalNo
ddl-rewriterYesYes
debugYesYesYesBothYes
debug_syncYesSessionYes
debug-sync-timeoutYesYes
default_authentication_pluginYesYesYesGlobalNo
default_collation_for_utf8mb4YesBothYes
default_password_lifetimeYesYesYesGlobalYes
default_storage_engineYesYesYesBothYes
default_table_encryptionYesYesYesBothYes
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
Deprecated_use_i_s_processlist_countYesGlobalNo
Deprecated_use_i_s_processlist_last_timestampYesGlobalNo
disabled_storage_enginesYesYesYesGlobalNo
disconnect_on_expired_passwordYesYesYesGlobalNo
div_precision_incrementYesYesYesBothYes
dragnet.log_error_filter_rulesYesYesYesGlobalYes
dragnet.StatusYesGlobalNo
early-plugin-loadYesYes
end_markers_in_jsonYesYesYesBothYes
enforce_gtid_consistencyYesYesYesGlobalYes
enterprise_encryption.maximum_rsa_key_sizeYesYesYesGlobalYes
enterprise_encryption.rsa_support_legacy_paddingYesYesYesGlobalYes
eq_range_index_dive_limitYesYesYesBothYes
error_countYesSessionNo
Error_log_buffered_bytesYesGlobalNo
Error_log_buffered_eventsYesGlobalNo
Error_log_expired_eventsYesGlobalNo
Error_log_latest_writeYesGlobalNo
event_schedulerYesYesYesGlobalYes
exit-infoYesYes
explain_formatYesYesYesBothYes
explain_json_format_versionYesYesYesBothYes
explicit_defaults_for_timestampYesYesYesBothYes
external-lockingYesYes
-Variable: 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
generated_random_password_lengthYesYesYesBothYes
Global_connection_memoryYesGlobalNo
global_connection_memory_limitYesYesYesGlobalYes
global_connection_memory_trackingYesYesYesBothYes
Gr_all_consensus_proposals_countYesBothNo
Gr_all_consensus_time_sumYesBothNo
Gr_certification_garbage_collector_countYesBothNo
Gr_certification_garbage_collector_time_sumYesBothNo
Gr_consensus_bytes_received_sumYesBothNo
Gr_consensus_bytes_sent_sumYesBothNo
Gr_control_messages_sent_bytes_sumYesBothNo
Gr_control_messages_sent_countYesBothNo
Gr_control_messages_sent_roundtrip_time_sumYesBothNo
Gr_data_messages_sent_bytes_sumYesBothNo
Gr_data_messages_sent_countYesBothNo
Gr_data_messages_sent_roundtrip_time_sumYesBothNo
Gr_empty_consensus_proposals_countYesBothNo
Gr_extended_consensus_countYesBothNo
Gr_last_consensus_end_timestampYesBothNo
Gr_total_messages_sent_countYesBothNo
Gr_transactions_consistency_after_sync_countYesBothNo
Gr_transactions_consistency_after_sync_time_sumYesBothNo
Gr_transactions_consistency_after_termination_countYesBothNo
Gr_transactions_consistency_after_termination_time_sumYesBothNo
Gr_transactions_consistency_before_begin_countYesBothNo
Gr_transactions_consistency_before_begin_time_sumYesBothNo
group_concat_max_lenYesYesYesBothYes
group_replication_advertise_recovery_endpointsYesYesYesGlobalYes
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_communication_stackYesGlobalNo
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_quotaYesYesYesGlobalYes
group_replication_flow_control_member_quota_percentYesYesYesGlobalYes
group_replication_flow_control_min_quotaYesYesYesGlobalYes
group_replication_flow_control_min_recovery_quotaYesYesYesGlobalYes
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_allowlistYesYesYesGlobalYes
group_replication_local_addressYesYesYesGlobalYes
group_replication_member_expel_timeoutYesYesYesGlobalYes
group_replication_message_cache_sizeYesYesYesGlobalYes
group_replication_paxos_single_leaderYesYesYesGlobalYes
group_replication_poll_spin_loopsYesYesYesGlobalYes
group_replication_recovery_complete_atYesYesYesGlobalYes
group_replication_recovery_compression_algorithmsYesYesYesGlobalYes
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_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_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_tls_sourceYesYesYesGlobalYes
group_replication_transaction_size_limitYesYesYesGlobalYes
group_replication_unreachable_majority_timeoutYesYesYesGlobalYes
group_replication_view_change_uuidYesYesYesGlobalYes
gtid_executedYesGlobalNo
gtid_executed_compression_periodYesYesYesGlobalYes
gtid_modeYesYesYesGlobalYes
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_dynamic_loadingYesGlobalNo
have_geometryYesGlobalNo
have_opensslYesGlobalNo
have_profilingYesGlobalNo
have_query_cacheYesGlobalNo
have_rtree_keysYesGlobalNo
have_sslYesGlobalNo
have_statement_timeoutYesGlobalNo
have_symlinkYesGlobalNo
helpYesYes
histogram_generation_max_mem_sizeYesYesYesBothYes
host_cache_sizeYesYesYesGlobalYes
hostnameYesGlobalNo
identityYesSessionYes
immediate_server_versionYesSessionYes
information_schema_stats_expiryYesYesYesBothYes
init_connectYesYesYesGlobalYes
init_fileYesYesYesGlobalNo
init_replicaYesYesYesGlobalYes
init_slaveYesYesYesGlobalYes
initializeYesYes
initialize-insecureYesYes
innodb_adaptive_flushingYesYesYesGlobalYes
innodb_adaptive_flushing_lwmYesYesYesGlobalYes
innodb_adaptive_hash_indexYesYesYesGlobalYes
innodb_adaptive_hash_index_partsYesYesYesGlobalNo
innodb_adaptive_max_sleep_delayYesYesYesGlobalYes
innodb_autoextend_incrementYesYesYesGlobalYes
innodb_autoinc_lock_modeYesYesYesGlobalNo
innodb_background_drop_list_emptyYesYesYesGlobalYes
Innodb_buffer_pool_bytes_dataYesGlobalNo
Innodb_buffer_pool_bytes_dirtyYesGlobalNo
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_dump_statusYesGlobalNo
innodb_buffer_pool_filenameYesYesYesGlobalYes
innodb_buffer_pool_in_core_fileYesYesYesGlobalYes
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_requestsYesGlobalNo
Innodb_buffer_pool_readsYesGlobalNo
Innodb_buffer_pool_resize_statusYesGlobalNo
Innodb_buffer_pool_resize_status_codeYesGlobalNo
Innodb_buffer_pool_resize_status_progressYesGlobalNo
innodb_buffer_pool_sizeYesYesYesGlobalYes
Innodb_buffer_pool_wait_freeYesGlobalNo
Innodb_buffer_pool_write_requestsYesGlobalNo
innodb_change_buffer_max_sizeYesYesYesGlobalYes
innodb_change_bufferingYesYesYesGlobalYes
innodb_checkpoint_disabledYesYesYesGlobalYes
innodb_checksum_algorithmYesYesYesGlobalYes
innodb_commit_concurrencyYesYesYesGlobalYes
innodb_compress_debugYesYesYesGlobalYes
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_ddl_buffer_sizeYesYesYesBothYes
innodb_ddl_log_crash_reset_debugYesYesYesGlobalYes
innodb_ddl_threadsYesYesYesBothYes
innodb_deadlock_detectYesYesYesGlobalYes
innodb_dedicated_serverYesYesYesGlobalNo
innodb_default_row_formatYesYesYesGlobalYes
innodb_directoriesYesYesYesGlobalNo
innodb_disable_sort_file_cacheYesYesYesGlobalYes
innodb_doublewriteYesYesYesGlobalYes
innodb_doublewrite_batch_sizeYesYesYesGlobalNo
innodb_doublewrite_dirYesYesYesGlobalNo
innodb_doublewrite_filesYesYesYesGlobalNo
innodb_doublewrite_pagesYesYesYesGlobalNo
innodb_extend_and_initializeYesYesYesGlobalYes
innodb_fast_shutdownYesYesYesGlobalYes
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_have_atomic_builtinsYesGlobalNo
innodb_idle_flush_pctYesYesYesGlobalYes
innodb_io_capacityYesYesYesGlobalYes
innodb_io_capacity_maxYesYesYesGlobalYes
innodb_limit_optimistic_insert_debugYesYesYesGlobalYes
innodb_lock_wait_timeoutYesYesYesBothYes
innodb_log_buffer_sizeYesYesYesGlobalYes
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_waitsYesGlobalNo
innodb_log_write_ahead_sizeYesYesYesGlobalYes
Innodb_log_write_requestsYesGlobalNo
innodb_log_writer_threadsYesYesYesGlobalYes
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_filesYesYesYesGlobalYes
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_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_redo_log_archive_dirsYesYesYesGlobalYes
innodb_redo_log_capacityYesYesYesGlobalYes
Innodb_redo_log_capacity_resizedYesGlobalNo
Innodb_redo_log_checkpoint_lsnYesGlobalNo
Innodb_redo_log_current_lsnYesGlobalNo
Innodb_redo_log_enabledYesGlobalNo
innodb_redo_log_encryptYesYesYesGlobalYes
Innodb_redo_log_flushed_to_disk_lsnYesGlobalNo
Innodb_redo_log_logical_sizeYesGlobalNo
Innodb_redo_log_physical_sizeYesGlobalNo
Innodb_redo_log_read_onlyYesGlobalNo
Innodb_redo_log_resize_statusYesGlobalNo
Innodb_redo_log_uuidYesGlobalNo
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_segment_reserve_factorYesYesYesGlobalYes
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_metadataYesYesYesGlobalYes
innodb_stats_persistentYesYesYesGlobalYes
innodb_stats_persistent_sample_pagesYesYesYesGlobalYes
innodb_stats_transient_sample_pagesYesYesYesGlobalYes
innodb-status-fileYesYes
innodb_status_outputYesYesYesGlobalYes
innodb_status_output_locksYesYesYesGlobalYes
innodb_strict_modeYesYesYesBothYes
innodb_sync_array_sizeYesYesYesGlobalNo
innodb_sync_debugYesYesYesGlobalNo
innodb_sync_spin_loopsYesYesYesGlobalYes
Innodb_system_rows_deletedYesGlobalNo
Innodb_system_rows_insertedYesGlobalNo
Innodb_system_rows_readYesGlobalNo
innodb_table_locksYesYesYesBothYes
innodb_temp_data_file_pathYesYesYesGlobalNo
innodb_temp_tablespaces_dirYesYesYesGlobalNo
innodb_thread_concurrencyYesYesYesGlobalYes
innodb_thread_sleep_delayYesYesYesGlobalYes
innodb_tmpdirYesYesYesBothYes
Innodb_truncated_status_writesYesGlobalNo
innodb_undo_directoryYesYesYesGlobalNo
innodb_undo_log_encryptYesYesYesGlobalYes
innodb_undo_log_truncateYesYesYesGlobalYes
innodb_undo_tablespacesYesYesYesGlobalYes
Innodb_undo_tablespaces_activeYesGlobalNo
Innodb_undo_tablespaces_explicitYesGlobalNo
Innodb_undo_tablespaces_implicitYesGlobalNo
Innodb_undo_tablespaces_totalYesGlobalNo
innodb_use_fdatasyncYesYesYesGlobalYes
innodb_use_native_aioYesYesYesGlobalNo
innodb_validate_tablespace_pathsYesYesYesGlobalNo
innodb_versionYesGlobalNo
innodb_write_io_threadsYesYesYesGlobalNo
insert_idYesSessionYes
installYes
install-manualYes
interactive_timeoutYesYesYesBothYes
internal_tmp_mem_storage_engineYesYesYesBothYes
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_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-migration-destinationYesYes
keyring-migration-hostYesYes
keyring-migration-passwordYesYes
keyring-migration-portYesYes
keyring-migration-socketYesYes
keyring-migration-sourceYesYes
keyring-migration-to-componentYesYes
keyring-migration-userYesYes
keyring_oci_ca_certificateYesYesYesGlobalNo
keyring_oci_compartmentYesYesYesGlobalNo
keyring_oci_encryption_endpointYesYesYesGlobalNo
keyring_oci_key_fileYesYesYesGlobalNo
keyring_oci_key_fingerprintYesYesYesGlobalNo
keyring_oci_management_endpointYesYesYesGlobalNo
keyring_oci_master_keyYesYesYesGlobalNo
keyring_oci_secrets_endpointYesYesYesGlobalNo
keyring_oci_tenancyYesYesYesGlobalNo
keyring_oci_userYesYesYesGlobalNo
keyring_oci_vaults_endpointYesYesYesGlobalNo
keyring_oci_virtual_vaultYesYesYesGlobalNo
keyring_okv_conf_dirYesYesYesGlobalYes
keyring_operationsYesGlobalYes
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_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_connectsYesGlobalNo
locked_in_memoryYesGlobalNo
log-binYesYes
log_binYesGlobalNo
log_bin_basenameYesGlobalNo
log_bin_indexYesYesYesGlobalNo
log_bin_trust_function_creatorsYesYesYesGlobalYes
log_errorYesYesYesGlobalNo
log_error_servicesYesYesYesGlobalYes
log_error_suppression_listYesYesYesGlobalYes
log_error_verbosityYesYesYesGlobalYes
log-isamYesYes
log_outputYesYesYesGlobalYes
log_queries_not_using_indexesYesYesYesGlobalYes
log_rawYesYesYesGlobalYes
log_replica_updatesYesYesYesGlobalNo
log-short-formatYesYes
log_slave_updatesYesYesYesGlobalNo
log_slow_admin_statementsYesYesYesGlobalYes
log_slow_extraYesYesYesGlobalYes
log_slow_replica_statementsYesYesYesGlobalYes
log_slow_slave_statementsYesYesYesGlobalYes
log_statements_unsafe_for_binlogYesYesYesGlobalYes
log-tcYesYes
log-tc-sizeYesYes
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-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_used_connectionsYesGlobalNo
Max_used_connections_timeYesGlobalNo
max_user_connectionsYesYesYesBothYes
max_write_lock_countYesYesYesGlobalYes
mecab_charsetYesGlobalNo
mecab_rc_fileYesYesYesGlobalNo
memlockYesYes
-Variable: locked_in_memory
min_examined_row_limitYesYesYesBothYes
myisam-block-sizeYesYes
myisam_data_pointer_sizeYesYesYesGlobalYes
myisam_max_sort_file_sizeYesYesYesGlobalYes
myisam_mmap_sizeYesYesYesGlobalNo
myisam_recover_optionsYesYesYesGlobalNo
myisam_sort_buffer_sizeYesYesYesBothYes
myisam_stats_methodYesYesYesBothYes
myisam_use_mmapYesYesYesGlobalYes
mysql_firewall_databaseYesYesYesGlobalNo
mysql_firewall_modeYesYesYesGlobalYes
mysql_firewall_reload_interval_secondsYesYesYesGlobalNo
mysql_firewall_traceYesYesYesGlobalYes
mysql_native_password_proxy_usersYesYesYesGlobalYes
mysqlxYesYes
Mysqlx_aborted_clientsYesGlobalNo
Mysqlx_addressYesGlobalNo
mysqlx_bind_addressYesYesYesGlobalNo
Mysqlx_bytes_receivedYesBothNo
Mysqlx_bytes_received_compressed_payloadYesBothNo
Mysqlx_bytes_received_uncompressed_frameYesBothNo
Mysqlx_bytes_sentYesBothNo
Mysqlx_bytes_sent_compressed_payloadYesBothNo
Mysqlx_bytes_sent_uncompressed_frameYesBothNo
Mysqlx_compression_algorithmYesSessionNo
mysqlx_compression_algorithmsYesYesYesGlobalYes
Mysqlx_compression_levelYesSessionNo
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_cursor_closeYesBothNo
Mysqlx_cursor_fetchYesBothNo
Mysqlx_cursor_openYesBothNo
mysqlx_deflate_default_compression_levelYesYesYesGlobalYes
mysqlx_deflate_max_client_compression_levelYesYesYesGlobalYes
mysqlx_document_id_unique_prefixYesYesYesGlobalYes
mysqlx_enable_hello_noticeYesYesYesGlobalYes
Mysqlx_errors_sentYesBothNo
Mysqlx_errors_unknown_message_typeYesBothNo
Mysqlx_expect_closeYesBothNo
Mysqlx_expect_openYesBothNo
mysqlx_idle_worker_thread_timeoutYesYesYesGlobalYes
Mysqlx_init_errorYesBothNo
mysqlx_interactive_timeoutYesYesYesGlobalYes
mysqlx_lz4_default_compression_levelYesYesYesGlobalYes
mysqlx_lz4_max_client_compression_levelYesYesYesGlobalYes
mysqlx_max_allowed_packetYesYesYesGlobalYes
mysqlx_max_connectionsYesYesYesGlobalYes
Mysqlx_messages_sentYesBothNo
mysqlx_min_worker_threadsYesYesYesGlobalYes
Mysqlx_notice_global_sentYesBothNo
Mysqlx_notice_other_sentYesBothNo
Mysqlx_notice_warning_sentYesBothNo
Mysqlx_notified_by_group_replicationYesBothNo
Mysqlx_portYesGlobalNo
mysqlx_portYesYesYesGlobalNo
mysqlx_port_open_timeoutYesYesYesGlobalNo
Mysqlx_prep_deallocateYesBothNo
Mysqlx_prep_executeYesBothNo
Mysqlx_prep_prepareYesBothNo
mysqlx_read_timeoutYesYesYesSessionYes
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_get_collection_optionsYesBothNo
Mysqlx_stmt_kill_clientYesBothNo
Mysqlx_stmt_list_clientsYesBothNo
Mysqlx_stmt_list_noticesYesBothNo
Mysqlx_stmt_list_objectsYesBothNo
Mysqlx_stmt_modify_collection_optionsYesBothNo
Mysqlx_stmt_pingYesBothNo
mysqlx_wait_timeoutYesYesYesSessionYes
Mysqlx_worker_threadsYesGlobalNo
Mysqlx_worker_threads_activeYesGlobalNo
mysqlx_write_timeoutYesYesYesSessionYes
mysqlx_zstd_default_compression_levelYesYesYesGlobalYes
mysqlx_zstd_max_client_compression_levelYesYesYesGlobalYes
named_pipeYesYesYesGlobalNo
named_pipe_full_access_groupYesYesYesGlobalNo
ndb_allow_copying_alter_tableYesYesYesBothYes
Ndb_api_adaptive_send_deferred_countYesGlobalNo
Ndb_api_adaptive_send_deferred_count_replicaYesGlobalNo
Ndb_api_adaptive_send_deferred_count_sessionYesGlobalNo
Ndb_api_adaptive_send_deferred_count_slaveYesGlobalNo
Ndb_api_adaptive_send_forced_countYesGlobalNo
Ndb_api_adaptive_send_forced_count_replicaYesGlobalNo
Ndb_api_adaptive_send_forced_count_sessionYesGlobalNo
Ndb_api_adaptive_send_forced_count_slaveYesGlobalNo
Ndb_api_adaptive_send_unforced_countYesGlobalNo
Ndb_api_adaptive_send_unforced_count_replicaYesGlobalNo
Ndb_api_adaptive_send_unforced_count_sessionYesGlobalNo
Ndb_api_adaptive_send_unforced_count_slaveYesGlobalNo
Ndb_api_bytes_received_countYesGlobalNo
Ndb_api_bytes_received_count_replicaYesGlobalNo
Ndb_api_bytes_received_count_sessionYesSessionNo
Ndb_api_bytes_received_count_slaveYesGlobalNo
Ndb_api_bytes_sent_countYesGlobalNo
Ndb_api_bytes_sent_count_replicaYesGlobalNo
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_replicaYesGlobalNo
Ndb_api_pk_op_count_sessionYesSessionNo
Ndb_api_pk_op_count_slaveYesGlobalNo
Ndb_api_pruned_scan_countYesGlobalNo
Ndb_api_pruned_scan_count_replicaYesGlobalNo
Ndb_api_pruned_scan_count_sessionYesSessionNo
Ndb_api_pruned_scan_count_slaveYesGlobalNo
Ndb_api_range_scan_countYesGlobalNo
Ndb_api_range_scan_count_replicaYesGlobalNo
Ndb_api_range_scan_count_sessionYesSessionNo
Ndb_api_range_scan_count_slaveYesGlobalNo
Ndb_api_read_row_countYesGlobalNo
Ndb_api_read_row_count_replicaYesGlobalNo
Ndb_api_read_row_count_sessionYesSessionNo
Ndb_api_read_row_count_slaveYesGlobalNo
Ndb_api_scan_batch_countYesGlobalNo
Ndb_api_scan_batch_count_replicaYesGlobalNo
Ndb_api_scan_batch_count_sessionYesSessionNo
Ndb_api_scan_batch_count_slaveYesGlobalNo
Ndb_api_table_scan_countYesGlobalNo
Ndb_api_table_scan_count_replicaYesGlobalNo
Ndb_api_table_scan_count_sessionYesSessionNo
Ndb_api_table_scan_count_slaveYesGlobalNo
Ndb_api_trans_abort_countYesGlobalNo
Ndb_api_trans_abort_count_replicaYesGlobalNo
Ndb_api_trans_abort_count_sessionYesSessionNo
Ndb_api_trans_abort_count_slaveYesGlobalNo
Ndb_api_trans_close_countYesGlobalNo
Ndb_api_trans_close_count_replicaYesGlobalNo
Ndb_api_trans_close_count_sessionYesSessionNo
Ndb_api_trans_close_count_slaveYesGlobalNo
Ndb_api_trans_commit_countYesGlobalNo
Ndb_api_trans_commit_count_replicaYesGlobalNo
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_replicaYesGlobalNo
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_replicaYesGlobalNo
Ndb_api_trans_start_count_sessionYesSessionNo
Ndb_api_trans_start_count_slaveYesGlobalNo
Ndb_api_uk_op_countYesGlobalNo
Ndb_api_uk_op_count_replicaYesGlobalNo
Ndb_api_uk_op_count_sessionYesSessionNo
Ndb_api_uk_op_count_slaveYesGlobalNo
Ndb_api_wait_exec_complete_countYesGlobalNo
Ndb_api_wait_exec_complete_count_replicaYesGlobalNo
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_replicaYesGlobalNo
Ndb_api_wait_meta_request_count_sessionYesSessionNo
Ndb_api_wait_meta_request_count_slaveYesGlobalNo
Ndb_api_wait_nanos_countYesGlobalNo
Ndb_api_wait_nanos_count_replicaYesGlobalNo
Ndb_api_wait_nanos_count_sessionYesSessionNo
Ndb_api_wait_nanos_count_slaveYesGlobalNo
Ndb_api_wait_scan_result_countYesGlobalNo
Ndb_api_wait_scan_result_count_replicaYesGlobalNo
Ndb_api_wait_scan_result_count_sessionYesSessionNo
Ndb_api_wait_scan_result_count_slaveYesGlobalNo
ndb_applier_allow_skip_epochYesYesYesGlobalNo
ndb_autoincrement_prefetch_szYesYesYesBothYes
ndb_batch_sizeYesYesYesBothYes
ndb_blob_read_batch_bytesYesYesYesBothYes
ndb_blob_write_batch_bytesYesYesYesBothYes
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_config_generationYesGlobalNo
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_max_del_winYesGlobalNo
Ndb_conflict_fn_max_del_win_insYesGlobalNo
Ndb_conflict_fn_max_insYesGlobalNo
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_roleYesYesYesGlobalYes
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_dbg_check_sharesYesYesYesBothYes
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_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_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_compressionYesYesYesGlobalYes
ndb_log_transaction_compression_level_zstdYesYesYesGlobalYes
ndb_log_transaction_dependencyYesYesYesGlobalNo
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_detected_countYesGlobalNo
Ndb_metadata_excluded_countYesGlobalNo
ndb_metadata_syncYesGlobalYes
Ndb_metadata_synced_countYesGlobalNo
ndb_mgm_tlsYesYesGlobalNo
-Variable: yesYesGlobalNo
ndb-mgmd-hostYesYes
ndb_nodeidYesYesYesGlobalNo
Ndb_number_of_data_nodesYesGlobalNo
ndb_optimization_delayYesYesYesGlobalYes
ndb-optimized-node-selectionYes
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_replica_batch_sizeYesYesYesGlobalYes
ndb_replica_blob_write_batch_bytesYesYesYesGlobalYes
Ndb_replica_max_replicated_epochYesGlobalNo
ndb_report_thresh_binlog_epoch_slipYesYesYesGlobalYes
ndb_report_thresh_binlog_mem_usageYesYesYesGlobalYes
ndb_row_checksumYesBothYes
Ndb_scan_countYesGlobalNo
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_tls_search_pathYesYesGlobalNo
-Variable: yesYesGlobalNo
Ndb_trans_hint_count_sessionYesBothNo
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
ndbinfoYes
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
no-dd-upgradeYesYes
no-defaultsYes
no-monitorYesYes
Not_flushed_delayed_rowsYesGlobalNo
offline_modeYesYesYesGlobalYes
oldYesYesYesGlobalNo
old_alter_tableYesYesYesBothYes
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
original_commit_timestampYesSessionYes
original_server_versionYesSessionYes
parser_max_mem_sizeYesYesYesBothYes
partial_revokesYesYesYesGlobalYes
password_historyYesYesYesGlobalYes
password_require_currentYesYesYesGlobalYes
password_reuse_intervalYesYesYesGlobalYes
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-cpuYesYes
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_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_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_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_meter_classesYesYesYesGlobalNo
performance_schema_max_metric_classesYesYesYesGlobalNo
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_meter_lostYesGlobalNo
Performance_schema_metric_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_longest_seenYesGlobalNo
Performance_schema_session_connect_attrs_lostYesGlobalNo
performance_schema_session_connect_attrs_sizeYesYesYesGlobalNo
performance_schema_setup_actors_sizeYesYesYesGlobalNo
performance_schema_setup_objects_sizeYesYesYesGlobalNo
performance_schema_show_processlistYesYesYesGlobalYes
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
persist_only_admin_x509_subjectYesYesYesGlobalNo
persist_sensitive_variables_in_plaintextYesYesYesGlobalNo
persisted_globals_loadYesYesYesGlobalNo
pid_fileYesYesYesGlobalNo
plugin_dirYesYesYesGlobalNo
plugin-loadYesYes
plugin-load-addYesYes
plugin-xxxYesYes
portYesYesYesGlobalNo
port-open-timeoutYesYes
preload_buffer_sizeYesYesYesBothYes
Prepared_stmt_countYesGlobalNo
print-defaultsYes
print_identified_with_as_hexYesYesYesBothYes
profilingYesBothYes
profiling_history_sizeYesYesYesBothYes
protocol_compression_algorithmsYesYesYesGlobalYes
protocol_versionYesGlobalNo
proxy_userYesSessionNo
pseudo_replica_modeYesSessionYes
pseudo_slave_modeYesSessionYes
pseudo_thread_idYesSessionYes
QueriesYesBothNo
query_alloc_block_sizeYesYesYesBothYes
query_prealloc_sizeYesYesYesBothYes
QuestionsYesBothNo
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
regexp_stack_limitYesYesYesGlobalYes
regexp_time_limitYesYesYesGlobalYes
relay_logYesYesYesGlobalNo
relay_log_basenameYesGlobalNo
relay_log_indexYesYesYesGlobalNo
relay_log_purgeYesYesYesGlobalYes
relay_log_recoveryYesYesYesGlobalNo
relay_log_space_limitYesYesYesGlobalNo
removeYes
replica_allow_batchingYesYesYesGlobalYes
replica_checkpoint_groupYesYesYesGlobalYes
replica_checkpoint_periodYesYesYesGlobalYes
replica_compressed_protocolYesYesYesGlobalYes
replica_exec_modeYesYesYesGlobalYes
replica_load_tmpdirYesYesYesGlobalNo
replica_max_allowed_packetYesYesYesGlobalYes
replica_net_timeoutYesYesYesGlobalYes
Replica_open_temp_tablesYesGlobalNo
replica_parallel_typeYesYesYesGlobalYes
replica_parallel_workersYesYesYesGlobalYes
replica_pending_jobs_size_maxYesYesYesGlobalYes
replica_preserve_commit_orderYesYesYesGlobalYes
replica_skip_errorsYesYesYesGlobalNo
replica_sql_verify_checksumYesYesYesGlobalYes
replica_transaction_retriesYesYesYesGlobalYes
replica_type_conversionsYesYesYesGlobalYes
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
replication_optimize_for_static_plugin_configYesYesYesGlobalYes
replication_sender_observe_commit_onlyYesYesYesGlobalYes
report_hostYesYesYesGlobalNo
report_passwordYesYesYesGlobalNo
report_portYesYesYesGlobalNo
report_userYesYesYesGlobalNo
require_row_formatYesSessionYes
require_secure_transportYesYesYesGlobalYes
Resource_group_supportedYesGlobalNo
resultset_metadataYesSessionYes
rewriter_enabledYesGlobalYes
rewriter_enabled_for_threads_without_privilege_checksYesGlobalYes
Rewriter_number_loaded_rulesYesGlobalNo
Rewriter_number_reloadsYesGlobalNo
Rewriter_number_rewritten_queriesYesGlobalNo
Rewriter_reload_errorYesGlobalNo
rewriter_verboseYesGlobalYes
rpl_read_sizeYesYesYesGlobalYes
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_replica_enabledYesYesYesGlobalYes
Rpl_semi_sync_replica_statusYesGlobalNo
rpl_semi_sync_replica_trace_levelYesYesYesGlobalYes
rpl_semi_sync_slave_enabledYesYesYesGlobalYes
Rpl_semi_sync_slave_statusYesGlobalNo
rpl_semi_sync_slave_trace_levelYesYesYesGlobalYes
Rpl_semi_sync_source_clientsYesGlobalNo
rpl_semi_sync_source_enabledYesYesYesGlobalYes
Rpl_semi_sync_source_net_avg_wait_timeYesGlobalNo
Rpl_semi_sync_source_net_wait_timeYesGlobalNo
Rpl_semi_sync_source_net_waitsYesGlobalNo
Rpl_semi_sync_source_no_timesYesGlobalNo
Rpl_semi_sync_source_no_txYesGlobalNo
Rpl_semi_sync_source_statusYesGlobalNo
Rpl_semi_sync_source_timefunc_failuresYesGlobalNo
rpl_semi_sync_source_timeoutYesYesYesGlobalYes
rpl_semi_sync_source_trace_levelYesYesYesGlobalYes
Rpl_semi_sync_source_tx_avg_wait_timeYesGlobalNo
Rpl_semi_sync_source_tx_wait_timeYesGlobalNo
Rpl_semi_sync_source_tx_waitsYesGlobalNo
rpl_semi_sync_source_wait_for_replica_countYesYesYesGlobalYes
rpl_semi_sync_source_wait_no_replicaYesYesYesGlobalYes
rpl_semi_sync_source_wait_pointYesYesYesGlobalYes
Rpl_semi_sync_source_wait_pos_backtraverseYesGlobalNo
Rpl_semi_sync_source_wait_sessionsYesGlobalNo
Rpl_semi_sync_source_yes_txYesGlobalNo
rpl_stop_replica_timeoutYesYesYesGlobalYes
rpl_stop_slave_timeoutYesYesYesGlobalYes
Rsa_public_keyYesGlobalNo
safe-user-createYesYes
schema_definition_cacheYesYesYesGlobalYes
secondary_engine_cost_thresholdYesSessionYes
Secondary_engine_execution_countYesBothNo
secure_file_privYesYesYesGlobalNo
Select_full_joinYesBothNo
Select_full_range_joinYesBothNo
select_into_buffer_sizeYesYesYesBothYes
select_into_disk_syncYesYesYesBothYes
select_into_disk_sync_delayYesYesYesBothYes
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
set_operations_buffer_sizeYesYesYesBothYes
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_gipk_in_create_table_and_information_schemaYesYesYesBothYes
show_old_temporalsYesYesYesBothYes
show-replica-auth-infoYesYes
show-slave-auth-infoYesYes
skip_external_lockingYesYesYesGlobalNo
skip-grant-tablesYesYes
skip_name_resolveYesYesYesGlobalNo
skip-ndbclusterYesYes
skip_networkingYesYesYesGlobalNo
skip-newYesYes
skip_replica_startYesYesYesGlobalNo
skip_show_databaseYesYesYesGlobalNo
skip_slave_startYesYesYesGlobalNo
skip-sslYesYes
skip-stack-traceYesYes
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_open_temp_tablesYesGlobalNo
slave_parallel_typeYesYesYesGlobalYes
slave_parallel_workersYesYesYesGlobalYes
slave_pending_jobs_size_maxYesYesYesGlobalYes
slave_preserve_commit_orderYesYesYesGlobalYes
Slave_rows_last_search_algorithm_usedYesGlobalNo
slave_skip_errorsYesYesYesGlobalNo
slave-sql-verify-checksumYesYes
slave_sql_verify_checksumYesYesYesGlobalYes
slave_transaction_retriesYesYesYesGlobalYes
slave_type_conversionsYesYesYesGlobalYes
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
source_verify_checksumYesYesYesGlobalYes
sporadic-binlog-dump-failYesYes
sql_auto_is_nullYesBothYes
sql_big_selectsYesBothYes
sql_buffer_resultYesBothYes
sql_generate_invisible_primary_keyYesYesYesBothYes
sql_log_binYesSessionYes
sql_log_offYesBothYes
sql_modeYesYesYesBothYes
sql_notesYesBothYes
sql_quote_show_createYesBothYes
sql_replica_skip_counterYesGlobalYes
sql_require_primary_keyYesYesYesBothYes
sql_safe_updatesYesBothYes
sql_select_limitYesBothYes
sql_slave_skip_counterYesGlobalYes
sql_warningsYesBothYes
sslYesYes
Ssl_accept_renegotiatesYesGlobalNo
Ssl_acceptsYesGlobalNo
ssl_caYesYesYesGlobalYes
Ssl_callback_cache_hitsYesGlobalNo
ssl_capathYesYesYesGlobalYes
ssl_certYesYesYesGlobalYes
Ssl_cipherYesBothNo
ssl_cipherYesYesYesGlobalYes
Ssl_cipher_listYesBothNo
Ssl_client_connectsYesGlobalNo
Ssl_connect_renegotiatesYesGlobalNo
ssl_crlYesYesYesGlobalYes
ssl_crlpathYesYesYesGlobalYes
Ssl_ctx_verify_depthYesGlobalNo
Ssl_ctx_verify_modeYesGlobalNo
Ssl_default_timeoutYesBothNo
Ssl_finished_acceptsYesGlobalNo
Ssl_finished_connectsYesGlobalNo
ssl_fips_modeYesYesYesGlobalNo
ssl_keyYesYesYesGlobalYes
Ssl_server_not_afterYesBothNo
Ssl_server_not_beforeYesBothNo
Ssl_session_cache_hitsYesGlobalNo
Ssl_session_cache_missesYesGlobalNo
Ssl_session_cache_modeYesGlobalNo
ssl_session_cache_modeYesYesYesGlobalYes
Ssl_session_cache_overflowsYesGlobalNo
Ssl_session_cache_sizeYesGlobalNo
Ssl_session_cache_timeoutYesGlobalNo
ssl_session_cache_timeoutYesYesYesGlobalYes
Ssl_session_cache_timeoutsYesGlobalNo
Ssl_sessions_reusedYesSessionNo
Ssl_used_session_cache_entriesYesGlobalNo
Ssl_verify_depthYesBothNo
Ssl_verify_modeYesBothNo
Ssl_versionYesBothNo
standaloneYesYes
stored_program_cacheYesYesYesGlobalYes
stored_program_definition_cacheYesYesYesGlobalYes
super-large-pagesYesYes
super_read_onlyYesYesYesGlobalYes
symbolic-linksYesYes
sync_binlogYesYesYesGlobalYes
sync_master_infoYesYesYesGlobalYes
sync_relay_logYesYesYesGlobalYes
sync_relay_log_infoYesYesYesGlobalYes
sync_source_infoYesYesYesGlobalYes
sysdate-is-nowYesYes
syseventlog.facilityYesYesYesGlobalYes
syseventlog.include_pidYesYesYesGlobalYes
syseventlog.tagYesYesYesGlobalYes
system_time_zoneYesGlobalNo
table_definition_cacheYesYesYesGlobalYes
table_encryption_privilege_checkYesYesYesGlobalYes
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
tablespace_definition_cacheYesYesYesGlobalYes
tc-heuristic-recoverYesYes
Tc_log_max_pages_usedYesGlobalNo
Tc_log_page_sizeYesGlobalNo
Tc_log_page_waitsYesGlobalNo
Telemetry_metrics_supportedYesGlobalNo
Telemetry_traces_supportedYesGlobalNo
telemetry.live_sessionsYesGlobalNo
telemetry.metrics_reader_frequency_1YesGlobalNo
telemetry.metrics_reader_frequency_2YesGlobalNo
telemetry.metrics_reader_frequency_3YesGlobalNo
telemetry.otel_bsp_max_export_batch_sizeYesGlobalNo
telemetry.otel_bsp_max_queue_sizeYesGlobalNo
telemetry.otel_bsp_schedule_delayYesGlobalNo
telemetry.otel_exporter_otlp_metrics_certificatesYesGlobalNo
telemetry.otel_exporter_otlp_metrics_cipherYesGlobalNo
telemetry.otel_exporter_otlp_metrics_cipher_suiteYesGlobalNo
telemetry.otel_exporter_otlp_metrics_client_certificatesYesGlobalNo
telemetry.otel_exporter_otlp_metrics_client_keyYesGlobalNo
telemetry.otel_exporter_otlp_metrics_compressionYesGlobalNo
telemetry.otel_exporter_otlp_metrics_endpointYesGlobalNo
telemetry.otel_exporter_otlp_metrics_headersYesGlobalNo
telemetry.otel_exporter_otlp_metrics_max_tlsYesGlobalNo
telemetry.otel_exporter_otlp_metrics_min_tlsYesGlobalNo
telemetry.otel_exporter_otlp_metrics_protocolYesGlobalNo
telemetry.otel_exporter_otlp_metrics_timeoutYesGlobalNo
telemetry.otel_exporter_otlp_traces_certificatesYesGlobalNo
telemetry.otel_exporter_otlp_traces_cipherYesGlobalNo
telemetry.otel_exporter_otlp_traces_cipher_suiteYesGlobalNo
telemetry.otel_exporter_otlp_traces_client_certificatesYesGlobalNo
telemetry.otel_exporter_otlp_traces_client_keyYesGlobalNo
telemetry.otel_exporter_otlp_traces_compressionYesGlobalNo
telemetry.otel_exporter_otlp_traces_endpointYesGlobalNo
telemetry.otel_exporter_otlp_traces_headersYesGlobalNo
telemetry.otel_exporter_otlp_traces_max_tlsYesGlobalNo
telemetry.otel_exporter_otlp_traces_min_tlsYesGlobalNo
telemetry.otel_exporter_otlp_traces_protocolYesGlobalNo
telemetry.otel_exporter_otlp_traces_timeoutYesGlobalNo
telemetry.otel_log_levelYesGlobalYes
telemetry.otel_resource_attributesYesGlobalNo
telemetry.query_text_enabledYesGlobalYes
telemetry.trace_enabledYesGlobalYes
temptable_max_mmapYesYesYesGlobalYes
temptable_max_ramYesYesYesGlobalYes
temptable_use_mmapYesYesYesGlobalYes
terminology_use_previousYesYesYesBothYes
thread_cache_sizeYesYesYesGlobalYes
thread_handlingYesYesYesGlobalNo
thread_pool_algorithmYesYesYesGlobalNo
thread_pool_dedicated_listenersYesYesYesGlobalNo
thread_pool_high_priority_connectionYesYesYesBothYes
thread_pool_max_active_query_threadsYesYesYesGlobalYes
thread_pool_max_transactions_limitYesYesYesGlobalYes
thread_pool_max_unused_threadsYesYesYesGlobalYes
thread_pool_prio_kickup_timerYesYesYesGlobalYes
thread_pool_query_threads_per_groupYesYesYesGlobalYes
thread_pool_sizeYesYesYesGlobalNo
thread_pool_stall_limitYesYesYesGlobalYes
thread_pool_transaction_delayYesYesYesGlobalYes
thread_stackYesYesYesGlobalNo
Threads_cachedYesGlobalNo
Threads_connectedYesGlobalNo
Threads_createdYesGlobalNo
Threads_runningYesGlobalNo
time_zoneYesBothYes
timestampYesSessionYes
tls_certificates_enforced_validationYesYesGlobalNo
tls_ciphersuitesYesYesYesGlobalYes
Tls_library_versionYesGlobalNo
Tls_sni_server_nameYesSessionNo
tls_versionYesYesYesGlobalYes
tmp_table_sizeYesYesYesBothYes
tmpdirYesYesYesGlobalNo
transaction_alloc_block_sizeYesYesYesBothYes
transaction_allow_batchingYesSessionYes
transaction_isolationYesYesYesBothYes
transaction_prealloc_sizeYesYesYesBothYes
transaction_read_onlyYesYesYesBothYes
unique_checksYesBothYes
updatable_views_with_limitYesYesYesBothYes
upgradeYesYes
UptimeYesGlobalNo
Uptime_since_flush_statusYesGlobalNo
use_secondary_engineYesSessionYes
userYesYes
validate-configYesYes
validate-passwordYesYes
validate_password_check_user_nameYesYesYesGlobalYes
validate_password_dictionary_fileYesYesYesGlobalYes
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_password.changed_characters_percentageYesYesYesGlobalYes
validate_password.check_user_nameYesYesYesGlobalYes
validate_password.dictionary_fileYesYesYesGlobalYes
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-pluginsYesYes
verboseYesYes
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
xa_detach_on_prepareYesYesYesBothYes

Notes:

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