Mysql5.7服务器选项、系统变量和状态变量参考
官网地址：MySQL :: MySQL 5.7 Reference Manual :: 5.1.3 Server Option, System Variable, and Status Variable Reference
欢迎关注留言，我是收集整理小能手，工具翻译，仅供参考，笔芯笔芯.
下表列出了适用于 mysqld.
该表在一个统一列表中列出了命令行选项 (Cmd-line)、配置文件中有效的选项 (Option file)、服务器系统变量 (System Var) 和状态变量 (Status var)，并指示每个选项的位置或变量有效。如果在命令行或选项文件中设置的服务器选项与相应系统变量的名称不同，则变量名称会紧邻相应选项下方注明。对于系统变量和状态变量，变量的范围 (Var Scope) 是 Global、Session 或两者。有关选项和变量的设置和使用的详细信息，请参阅相应项目的说明。在适当的情况下，提供有关该项目的更多信息的直接链接。
有关此表特定于 NDB Cluster 的版本，请参阅 第 21.4.2.5 节，“NDB Cluster mysqld 选项和变量参考”。
表 5.1 命令行选项、系统变量和状态变量摘要
| Name | Cmd-Line | Option File | System Var | Status Var | Var Scope | Dynamic |
|---|---|---|---|---|---|---|
| abort-slave-event-count | Yes | Yes | ||||
| Aborted_clients | Yes | Global | No | |||
| Aborted_connects | Yes | Global | No | |||
| allow-suspicious-udfs | Yes | Yes | ||||
| ansi | Yes | Yes | ||||
| audit-log | Yes | Yes | ||||
| audit_log_buffer_size | Yes | Yes | Yes | Global | No | |
| audit_log_compression | Yes | Yes | Yes | Global | No | |
| audit_log_connection_policy | Yes | Yes | Yes | Global | Yes | |
| audit_log_current_session | Yes | Both | No | |||
| Audit_log_current_size | Yes | Global | No | |||
| audit_log_disable | Yes | Yes | Yes | Global | Yes | |
| audit_log_encryption | Yes | Yes | Yes | Global | No | |
| Audit_log_event_max_drop_size | Yes | Global | No | |||
| Audit_log_events | Yes | Global | No | |||
| Audit_log_events_filtered | Yes | Global | No | |||
| Audit_log_events_lost | Yes | Global | No | |||
| Audit_log_events_written | Yes | Global | No | |||
| audit_log_exclude_accounts | Yes | Yes | Yes | Global | Yes | |
| audit_log_file | Yes | Yes | Yes | Global | No | |
| audit_log_filter_id | Yes | Both | No | |||
| audit_log_flush | Yes | Global | Yes | |||
| audit_log_format | Yes | Yes | Yes | Global | No | |
| audit_log_format_unix_timestamp | Yes | Yes | Yes | Global | Yes | |
| audit_log_include_accounts | Yes | Yes | Yes | Global | Yes | |
| audit_log_policy | Yes | Yes | Yes | Global | No | |
| audit_log_read_buffer_size | Yes | Yes | Yes | Varies | Varies | |
| audit_log_rotate_on_size | Yes | Yes | Yes | Global | Yes | |
| audit_log_statement_policy | Yes | Yes | Yes | Global | Yes | |
| audit_log_strategy | Yes | Yes | Yes | Global | No | |
| Audit_log_total_size | Yes | Global | No | |||
| Audit_log_write_waits | Yes | Global | No | |||
| authentication_ldap_sasl_auth_method_name | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_bind_base_dn | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_bind_root_dn | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_bind_root_pwd | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_ca_path | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_group_search_attr | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_group_search_filter | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_init_pool_size | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_log_status | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_max_pool_size | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_server_host | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_server_port | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_tls | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_sasl_user_search_attr | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_auth_method_name | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_bind_base_dn | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_bind_root_dn | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_bind_root_pwd | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_ca_path | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_group_search_attr | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_group_search_filter | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_init_pool_size | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_log_status | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_max_pool_size | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_server_host | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_server_port | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_tls | Yes | Yes | Yes | Global | Yes | |
| authentication_ldap_simple_user_search_attr | Yes | Yes | Yes | Global | Yes | |
| authentication_windows_log_level | Yes | Yes | Yes | Global | No | |
| authentication_windows_use_principal_name | Yes | Yes | Yes | Global | No | |
| auto_generate_certs | Yes | Yes | Yes | Global | No | |
| auto_increment_increment | Yes | Yes | Yes | Both | Yes | |
| auto_increment_offset | Yes | Yes | Yes | Both | Yes | |
| autocommit | Yes | Yes | Yes | Both | Yes | |
| automatic_sp_privileges | Yes | Yes | Yes | Global | Yes | |
| avoid_temporal_upgrade | Yes | Yes | Yes | Global | Yes | |
| back_log | Yes | Yes | Yes | Global | No | |
| basedir | Yes | Yes | Yes | Global | No | |
| big_tables | Yes | Yes | Yes | Both | Yes | |
| bind_address | Yes | Yes | Yes | Global | No | |
| Binlog_cache_disk_use | Yes | Global | No | |||
| binlog_cache_size | Yes | Yes | Yes | Global | Yes | |
| Binlog_cache_use | Yes | Global | No | |||
| binlog-checksum | Yes | Yes | ||||
| binlog_checksum | Yes | Yes | Yes | Global | Yes | |
| binlog_direct_non_transactional_updates | Yes | Yes | Yes | Both | Yes | |
| binlog-do-db | Yes | Yes | ||||
| binlog_error_action | Yes | Yes | Yes | Global | Yes | |
| binlog_format | Yes | Yes | Yes | Both | Yes | |
| binlog_group_commit_sync_delay | Yes | Yes | Yes | Global | Yes | |
| binlog_group_commit_sync_no_delay_count | Yes | Yes | Yes | Global | Yes | |
| binlog_gtid_simple_recovery | Yes | Yes | Yes | Global | No | |
| binlog-ignore-db | Yes | Yes | ||||
| binlog_max_flush_queue_time | Yes | Yes | Yes | Global | Yes | |
| binlog_order_commits | Yes | Yes | Yes | Global | Yes | |
| binlog-row-event-max-size | Yes | Yes | ||||
| binlog_row_image | Yes | Yes | Yes | Both | Yes | |
| binlog_rows_query_log_events | Yes | Yes | Yes | Both | Yes | |
| Binlog_stmt_cache_disk_use | Yes | Global | No | |||
| binlog_stmt_cache_size | Yes | Yes | Yes | Global | Yes | |
| Binlog_stmt_cache_use | Yes | Global | No | |||
| binlog_transaction_dependency_history_size | Yes | Yes | Yes | Global | Yes | |
| binlog_transaction_dependency_tracking | Yes | Yes | Yes | Global | Yes | |
| block_encryption_mode | Yes | Yes | Yes | Both | Yes | |
| bootstrap | Yes | Yes | ||||
| bulk_insert_buffer_size | Yes | Yes | Yes | Both | Yes | |
| Bytes_received | Yes | Both | No | |||
| Bytes_sent | Yes | Both | No | |||
| character_set_client | Yes | Both | Yes | |||
| character-set-client-handshake | Yes | Yes | ||||
| character_set_connection | Yes | Both | Yes | |||
| character_set_database (note 1) | Yes | Both | Yes | |||
| character_set_filesystem | Yes | Yes | Yes | Both | Yes | |
| character_set_results | Yes | Both | Yes | |||
| character_set_server | Yes | Yes | Yes | Both | Yes | |
| character_set_system | Yes | Global | No | |||
| character_sets_dir | Yes | Yes | Yes | Global | No | |
| check_proxy_users | Yes | Yes | Yes | Global | Yes | |
| chroot | Yes | Yes | ||||
| collation_connection | Yes | Both | Yes | |||
| collation_database (note 1) | Yes | Both | Yes | |||
| collation_server | Yes | Yes | Yes | Both | Yes | |
| Com_admin_commands | Yes | Both | No | |||
| Com_alter_db | Yes | Both | No | |||
| Com_alter_db_upgrade | Yes | Both | No | |||
| Com_alter_event | Yes | Both | No | |||
| Com_alter_function | Yes | Both | No | |||
| Com_alter_procedure | Yes | Both | No | |||
| Com_alter_server | Yes | Both | No | |||
| Com_alter_table | Yes | Both | No | |||
| Com_alter_tablespace | Yes | Both | No | |||
| Com_alter_user | Yes | Both | No | |||
| Com_analyze | Yes | Both | No | |||
| Com_assign_to_keycache | Yes | Both | No | |||
| Com_begin | Yes | Both | No | |||
| Com_binlog | Yes | Both | No | |||
| Com_call_procedure | Yes | Both | No | |||
| Com_change_db | Yes | Both | No | |||
| Com_change_master | Yes | Both | No | |||
| Com_change_repl_filter | Yes | Both | No | |||
| Com_check | Yes | Both | No | |||
| Com_checksum | Yes | Both | No | |||
| Com_commit | Yes | Both | No | |||
| Com_create_db | Yes | Both | No | |||
| Com_create_event | Yes | Both | No | |||
| Com_create_function | Yes | Both | No | |||
| Com_create_index | Yes | Both | No | |||
| Com_create_procedure | Yes | Both | No | |||
| Com_create_server | Yes | Both | No | |||
| Com_create_table | Yes | Both | No | |||
| Com_create_trigger | Yes | Both | No | |||
| Com_create_udf | Yes | Both | No | |||
| Com_create_user | Yes | Both | No | |||
| Com_create_view | Yes | Both | No | |||
| Com_dealloc_sql | Yes | Both | No | |||
| Com_delete | Yes | Both | No | |||
| Com_delete_multi | Yes | Both | No | |||
| Com_do | Yes | Both | No | |||
| Com_drop_db | Yes | Both | No | |||
| Com_drop_event | Yes | Both | No | |||
| Com_drop_function | Yes | Both | No | |||
| Com_drop_index | Yes | Both | No | |||
| Com_drop_procedure | Yes | Both | No | |||
| Com_drop_server | Yes | Both | No | |||
| Com_drop_table | Yes | Both | No | |||
| Com_drop_trigger | Yes | Both | No | |||
| Com_drop_user | Yes | Both | No | |||
| Com_drop_view | Yes | Both | No | |||
| Com_empty_query | Yes | Both | No | |||
| Com_execute_sql | Yes | Both | No | |||
| Com_explain_other | Yes | Both | No | |||
| Com_flush | Yes | Both | No | |||
| Com_get_diagnostics | Yes | Both | No | |||
| Com_grant | Yes | Both | No | |||
| Com_group_replication_start | Yes | Global | No | |||
| Com_group_replication_stop | Yes | Global | No | |||
| Com_ha_close | Yes | Both | No | |||
| Com_ha_open | Yes | Both | No | |||
| Com_ha_read | Yes | Both | No | |||
| Com_help | Yes | Both | No | |||
| Com_insert | Yes | Both | No | |||
| Com_insert_select | Yes | Both | No | |||
| Com_install_plugin | Yes | Both | No | |||
| Com_kill | Yes | Both | No | |||
| Com_load | Yes | Both | No | |||
| Com_lock_tables | Yes | Both | No | |||
| Com_optimize | Yes | Both | No | |||
| Com_preload_keys | Yes | Both | No | |||
| Com_prepare_sql | Yes | Both | No | |||
| Com_purge | Yes | Both | No | |||
| Com_purge_before_date | Yes | Both | No | |||
| Com_release_savepoint | Yes | Both | No | |||
| Com_rename_table | Yes | Both | No | |||
| Com_rename_user | Yes | Both | No | |||
| Com_repair | Yes | Both | No | |||
| Com_replace | Yes | Both | No | |||
| Com_replace_select | Yes | Both | No | |||
| Com_reset | Yes | Both | No | |||
| Com_resignal | Yes | Both | No | |||
| Com_revoke | Yes | Both | No | |||
| Com_revoke_all | Yes | Both | No | |||
| Com_rollback | Yes | Both | No | |||
| Com_rollback_to_savepoint | Yes | Both | No | |||
| Com_savepoint | Yes | Both | No | |||
| Com_select | Yes | Both | No | |||
| Com_set_option | Yes | Both | No | |||
| Com_show_authors | Yes | Both | No | |||
| Com_show_binlog_events | Yes | Both | No | |||
| Com_show_binlogs | Yes | Both | No | |||
| Com_show_charsets | Yes | Both | No | |||
| Com_show_collations | Yes | Both | No | |||
| Com_show_contributors | Yes | Both | No | |||
| Com_show_create_db | Yes | Both | No | |||
| Com_show_create_event | Yes | Both | No | |||
| Com_show_create_func | Yes | Both | No | |||
| Com_show_create_proc | Yes | Both | No | |||
| Com_show_create_table | Yes | Both | No | |||
| Com_show_create_trigger | Yes | Both | No | |||
| Com_show_create_user | Yes | Both | No | |||
| Com_show_databases | Yes | Both | No | |||
| Com_show_engine_logs | Yes | Both | No | |||
| Com_show_engine_mutex | Yes | Both | No | |||
| Com_show_engine_status | Yes | Both | No | |||
| Com_show_errors | Yes | Both | No | |||
| Com_show_events | Yes | Both | No | |||
| Com_show_fields | Yes | Both | No | |||
| Com_show_function_code | Yes | Both | No | |||
| Com_show_function_status | Yes | Both | No | |||
| Com_show_grants | Yes | Both | No | |||
| Com_show_keys | Yes | Both | No | |||
| Com_show_master_status | Yes | Both | No | |||
| Com_show_ndb_status | Yes | Both | No | |||
| Com_show_open_tables | Yes | Both | No | |||
| Com_show_plugins | Yes | Both | No | |||
| Com_show_privileges | Yes | Both | No | |||
| Com_show_procedure_code | Yes | Both | No | |||
| Com_show_procedure_status | Yes | Both | No | |||
| Com_show_processlist | Yes | Both | No | |||
| Com_show_profile | Yes | Both | No | |||
| Com_show_profiles | Yes | Both | No | |||
| Com_show_relaylog_events | Yes | Both | No | |||
| Com_show_slave_hosts | Yes | Both | No | |||
| Com_show_slave_status | Yes | Both | No | |||
| Com_show_status | Yes | Both | No | |||
| Com_show_storage_engines | Yes | Both | No | |||
| Com_show_table_status | Yes | Both | No | |||
| Com_show_tables | Yes | Both | No | |||
| Com_show_triggers | Yes | Both | No | |||
| Com_show_variables | Yes | Both | No | |||
| Com_show_warnings | Yes | Both | No | |||
| Com_shutdown | Yes | Both | No | |||
| Com_signal | Yes | Both | No | |||
| Com_slave_start | Yes | Both | No | |||
| Com_slave_stop | Yes | Both | No | |||
| Com_stmt_close | Yes | Both | No | |||
| Com_stmt_execute | Yes | Both | No | |||
| Com_stmt_fetch | Yes | Both | No | |||
| Com_stmt_prepare | Yes | Both | No | |||
| Com_stmt_reprepare | Yes | Both | No | |||
| Com_stmt_reset | Yes | Both | No | |||
| Com_stmt_send_long_data | Yes | Both | No | |||
| Com_truncate | Yes | Both | No | |||
| Com_uninstall_plugin | Yes | Both | No | |||
| Com_unlock_tables | Yes | Both | No | |||
| Com_update | Yes | Both | No | |||
| Com_update_multi | Yes | Both | No | |||
| Com_xa_commit | Yes | Both | No | |||
| Com_xa_end | Yes | Both | No | |||
| Com_xa_prepare | Yes | Both | No | |||
| Com_xa_recover | Yes | Both | No | |||
| Com_xa_rollback | Yes | Both | No | |||
| Com_xa_start | Yes | Both | No | |||
| completion_type | Yes | Yes | Yes | Both | Yes | |
| Compression | Yes | Session | No | |||
| concurrent_insert | Yes | Yes | Yes | Global | Yes | |
| connect_timeout | Yes | Yes | Yes | Global | Yes | |
| Connection_control_delay_generated | Yes | Global | No | |||
| connection_control_failed_connections_threshold | Yes | Yes | Yes | Global | Yes | |
| connection_control_max_connection_delay | Yes | Yes | Yes | Global | Yes | |
| connection_control_min_connection_delay | Yes | Yes | Yes | Global | Yes | |
| Connection_errors_accept | Yes | Global | No | |||
| Connection_errors_internal | Yes | Global | No | |||
| Connection_errors_max_connections | Yes | Global | No | |||
| Connection_errors_peer_address | Yes | Global | No | |||
| Connection_errors_select | Yes | Global | No | |||
| Connection_errors_tcpwrap | Yes | Global | No | |||
| Connections | Yes | Global | No | |||
| console | Yes | Yes | ||||
| core-file | Yes | Yes | ||||
| core_file | Yes | Global | No | |||
| Created_tmp_disk_tables | Yes | Both | No | |||
| Created_tmp_files | Yes | Global | No | |||
| Created_tmp_tables | Yes | Both | No | |||
| daemon_memcached_enable_binlog | Yes | Yes | Yes | Global | No | |
| daemon_memcached_engine_lib_name | Yes | Yes | Yes | Global | No | |
| daemon_memcached_engine_lib_path | Yes | Yes | Yes | Global | No | |
| daemon_memcached_option | Yes | Yes | Yes | Global | No | |
| daemon_memcached_r_batch_size | Yes | Yes | Yes | Global | No | |
| daemon_memcached_w_batch_size | Yes | Yes | Yes | Global | No | |
| daemonize | Yes | Yes | ||||
| datadir | Yes | Yes | Yes | Global | No | |
| date_format | Yes | Global | No | |||
| datetime_format | Yes | Global | No | |||
| debug | Yes | Yes | Yes | Both | Yes | |
| debug_sync | Yes | Session | Yes | |||
| debug-sync-timeout | Yes | Yes | ||||
| default_authentication_plugin | Yes | Yes | Yes | Global | No | |
| default_password_lifetime | Yes | Yes | Yes | Global | Yes | |
| default_storage_engine | Yes | Yes | Yes | Both | Yes | |
| default-time-zone | Yes | Yes | ||||
| default_tmp_storage_engine | Yes | Yes | Yes | Both | Yes | |
| default_week_format | Yes | Yes | Yes | Both | Yes | |
| defaults-extra-file | Yes | |||||
| defaults-file | Yes | |||||
| defaults-group-suffix | Yes | |||||
| delay_key_write | Yes | Yes | Yes | Global | Yes | |
| Delayed_errors | Yes | Global | No | |||
| delayed_insert_limit | Yes | Yes | Yes | Global | Yes | |
| Delayed_insert_threads | Yes | Global | No | |||
| delayed_insert_timeout | Yes | Yes | Yes | Global | Yes | |
| delayed_queue_size | Yes | Yes | Yes | Global | Yes | |
| Delayed_writes | Yes | Global | No | |||
| des-key-file | Yes | Yes | ||||
| disable-partition-engine-check | Yes | Yes | ||||
| disabled_storage_engines | Yes | Yes | Yes | Global | No | |
| disconnect_on_expired_password | Yes | Yes | Yes | Global | No | |
| disconnect-slave-event-count | Yes | Yes | ||||
| div_precision_increment | Yes | Yes | Yes | Both | Yes | |
| early-plugin-load | Yes | Yes | ||||
| end_markers_in_json | Yes | Yes | Yes | Both | Yes | |
| enforce_gtid_consistency | Yes | Yes | Yes | Global | Varies | |
| eq_range_index_dive_limit | Yes | Yes | Yes | Both | Yes | |
| error_count | Yes | Session | No | |||
| event_scheduler | Yes | Yes | Yes | Global | Yes | |
| exit-info | Yes | Yes | ||||
| expire_logs_days | Yes | Yes | Yes | Global | Yes | |
| explicit_defaults_for_timestamp | Yes | Yes | Yes | Both | Yes | |
| external-locking | Yes | Yes | ||||
| - Variable: skip_external_locking | ||||||
| external_user | Yes | Session | No | |||
| federated | Yes | Yes | ||||
| Firewall_access_denied | Yes | Global | No | |||
| Firewall_access_granted | Yes | Global | No | |||
| Firewall_cached_entries | Yes | Global | No | |||
| flush | Yes | Yes | Yes | Global | Yes | |
| Flush_commands | Yes | Global | No | |||
| flush_time | Yes | Yes | Yes | Global | Yes | |
| foreign_key_checks | Yes | Both | Yes | |||
| ft_boolean_syntax | Yes | Yes | Yes | Global | Yes | |
| ft_max_word_len | Yes | Yes | Yes | Global | No | |
| ft_min_word_len | Yes | Yes | Yes | Global | No | |
| ft_query_expansion_limit | Yes | Yes | Yes | Global | No | |
| ft_stopword_file | Yes | Yes | Yes | Global | No | |
| gdb | Yes | Yes | ||||
| general_log | Yes | Yes | Yes | Global | Yes | |
| general_log_file | Yes | Yes | Yes | Global | Yes | |
| group_concat_max_len | Yes | Yes | Yes | Both | Yes | |
| group_replication_allow_local_disjoint_gtids_join | Yes | Yes | Yes | Global | Yes | |
| group_replication_allow_local_lower_version_join | Yes | Yes | Yes | Global | Yes | |
| group_replication_auto_increment_increment | Yes | Yes | Yes | Global | Yes | |
| group_replication_bootstrap_group | Yes | Yes | Yes | Global | Yes | |
| group_replication_components_stop_timeout | Yes | Yes | Yes | Global | Yes | |
| group_replication_compression_threshold | Yes | Yes | Yes | Global | Yes | |
| group_replication_enforce_update_everywhere_checks | Yes | Yes | Yes | Global | Yes | |
| group_replication_exit_state_action | Yes | Yes | Yes | Global | Yes | |
| group_replication_flow_control_applier_threshold | Yes | Yes | Yes | Global | Yes | |
| group_replication_flow_control_certifier_threshold | Yes | Yes | Yes | Global | Yes | |
| group_replication_flow_control_mode | Yes | Yes | Yes | Global | Yes | |
| group_replication_force_members | Yes | Yes | Yes | Global | Yes | |
| group_replication_group_name | Yes | Yes | Yes | Global | Yes | |
| group_replication_group_seeds | Yes | Yes | Yes | Global | Yes | |
| group_replication_gtid_assignment_block_size | Yes | Yes | Yes | Global | Yes | |
| group_replication_ip_whitelist | Yes | Yes | Yes | Global | Yes | |
| group_replication_local_address | Yes | Yes | Yes | Global | Yes | |
| group_replication_member_weight | Yes | Yes | Yes | Global | Yes | |
| group_replication_poll_spin_loops | Yes | Yes | Yes | Global | Yes | |
| group_replication_primary_member | Yes | Global | No | |||
| group_replication_recovery_complete_at | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_reconnect_interval | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_retry_count | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_ca | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_capath | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_cert | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_cipher | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_crl | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_crlpath | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_key | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_ssl_verify_server_cert | Yes | Yes | Yes | Global | Yes | |
| group_replication_recovery_use_ssl | Yes | Yes | Yes | Global | Yes | |
| group_replication_single_primary_mode | Yes | Yes | Yes | Global | Yes | |
| group_replication_ssl_mode | Yes | Yes | Yes | Global | Yes | |
| group_replication_start_on_boot | Yes | Yes | Yes | Global | Yes | |
| group_replication_transaction_size_limit | Yes | Yes | Yes | Global | Yes | |
| group_replication_unreachable_majority_timeout | Yes | Yes | Yes | Global | Yes | |
| gtid_executed | Yes | Varies | No | |||
| gtid_executed_compression_period | Yes | Yes | Yes | Global | Yes | |
| gtid_mode | Yes | Yes | Yes | Global | Varies | |
| gtid_next | Yes | Session | Yes | |||
| gtid_owned | Yes | Both | No | |||
| gtid_purged | Yes | Global | Yes | |||
| Handler_commit | Yes | Both | No | |||
| Handler_delete | Yes | Both | No | |||
| Handler_discover | Yes | Both | No | |||
| Handler_external_lock | Yes | Both | No | |||
| Handler_mrr_init | Yes | Both | No | |||
| Handler_prepare | Yes | Both | No | |||
| Handler_read_first | Yes | Both | No | |||
| Handler_read_key | Yes | Both | No | |||
| Handler_read_last | Yes | Both | No | |||
| Handler_read_next | Yes | Both | No | |||
| Handler_read_prev | Yes | Both | No | |||
| Handler_read_rnd | Yes | Both | No | |||
| Handler_read_rnd_next | Yes | Both | No | |||
| Handler_rollback | Yes | Both | No | |||
| Handler_savepoint | Yes | Both | No | |||
| Handler_savepoint_rollback | Yes | Both | No | |||
| Handler_update | Yes | Both | No | |||
| Handler_write | Yes | Both | No | |||
| have_compress | Yes | Global | No | |||
| have_crypt | Yes | Global | No | |||
| have_dynamic_loading | Yes | Global | No | |||
| have_geometry | Yes | Global | No | |||
| have_openssl | Yes | Global | No | |||
| have_profiling | Yes | Global | No | |||
| have_query_cache | Yes | Global | No | |||
| have_rtree_keys | Yes | Global | No | |||
| have_ssl | Yes | Global | No | |||
| have_statement_timeout | Yes | Global | No | |||
| have_symlink | Yes | Global | No | |||
| help | Yes | Yes | ||||
| host_cache_size | Yes | Yes | Yes | Global | Yes | |
| hostname | Yes | Global | No | |||
| identity | Yes | Session | Yes | |||
| ignore_builtin_innodb | Yes | Yes | Yes | Global | No | |
| ignore-db-dir | Yes | Yes | ||||
| ignore_db_dirs | Yes | Global | No | |||
| init_connect | Yes | Yes | Yes | Global | Yes | |
| init_file | Yes | Yes | Yes | Global | No | |
| init_slave | Yes | Yes | Yes | Global | Yes | |
| initialize | Yes | Yes | ||||
| initialize-insecure | Yes | Yes | ||||
| innodb | Yes | Yes | ||||
| innodb_adaptive_flushing | Yes | Yes | Yes | Global | Yes | |
| innodb_adaptive_flushing_lwm | Yes | Yes | Yes | Global | Yes | |
| innodb_adaptive_hash_index | Yes | Yes | Yes | Global | Yes | |
| innodb_adaptive_hash_index_parts | Yes | Yes | Yes | Global | No | |
| innodb_adaptive_max_sleep_delay | Yes | Yes | Yes | Global | Yes | |
| innodb_api_bk_commit_interval | Yes | Yes | Yes | Global | Yes | |
| innodb_api_disable_rowlock | Yes | Yes | Yes | Global | No | |
| innodb_api_enable_binlog | Yes | Yes | Yes | Global | No | |
| innodb_api_enable_mdl | Yes | Yes | Yes | Global | No | |
| innodb_api_trx_level | Yes | Yes | Yes | Global | Yes | |
| innodb_autoextend_increment | Yes | Yes | Yes | Global | Yes | |
| innodb_autoinc_lock_mode | Yes | Yes | Yes | Global | No | |
| Innodb_available_undo_logs | Yes | Global | No | |||
| innodb_background_drop_list_empty | Yes | Yes | Yes | Global | Yes | |
| Innodb_buffer_pool_bytes_data | Yes | Global | No | |||
| Innodb_buffer_pool_bytes_dirty | Yes | Global | No | |||
| innodb_buffer_pool_chunk_size | Yes | Yes | Yes | Global | No | |
| innodb_buffer_pool_dump_at_shutdown | Yes | Yes | Yes | Global | Yes | |
| innodb_buffer_pool_dump_now | Yes | Yes | Yes | Global | Yes | |
| innodb_buffer_pool_dump_pct | Yes | Yes | Yes | Global | Yes | |
| Innodb_buffer_pool_dump_status | Yes | Global | No | |||
| innodb_buffer_pool_filename | Yes | Yes | Yes | Global | Yes | |
| innodb_buffer_pool_instances | Yes | Yes | Yes | Global | No | |
| innodb_buffer_pool_load_abort | Yes | Yes | Yes | Global | Yes | |
| innodb_buffer_pool_load_at_startup | Yes | Yes | Yes | Global | No | |
| innodb_buffer_pool_load_now | Yes | Yes | Yes | Global | Yes | |
| Innodb_buffer_pool_load_status | Yes | Global | No | |||
| Innodb_buffer_pool_pages_data | Yes | Global | No | |||
| Innodb_buffer_pool_pages_dirty | Yes | Global | No | |||
| Innodb_buffer_pool_pages_flushed | Yes | Global | No | |||
| Innodb_buffer_pool_pages_free | Yes | Global | No | |||
| Innodb_buffer_pool_pages_latched | Yes | Global | No | |||
| Innodb_buffer_pool_pages_misc | Yes | Global | No | |||
| Innodb_buffer_pool_pages_total | Yes | Global | No | |||
| Innodb_buffer_pool_read_ahead | Yes | Global | No | |||
| Innodb_buffer_pool_read_ahead_evicted | Yes | Global | No | |||
| Innodb_buffer_pool_read_ahead_rnd | Yes | Global | No | |||
| Innodb_buffer_pool_read_requests | Yes | Global | No | |||
| Innodb_buffer_pool_reads | Yes | Global | No | |||
| Innodb_buffer_pool_resize_status | Yes | Global | No | |||
| innodb_buffer_pool_size | Yes | Yes | Yes | Global | Varies | |
| Innodb_buffer_pool_wait_free | Yes | Global | No | |||
| Innodb_buffer_pool_write_requests | Yes | Global | No | |||
| innodb_change_buffer_max_size | Yes | Yes | Yes | Global | Yes | |
| innodb_change_buffering | Yes | Yes | Yes | Global | Yes | |
| innodb_change_buffering_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_checksum_algorithm | Yes | Yes | Yes | Global | Yes | |
| innodb_checksums | Yes | Yes | Yes | Global | No | |
| innodb_cmp_per_index_enabled | Yes | Yes | Yes | Global | Yes | |
| innodb_commit_concurrency | Yes | Yes | Yes | Global | Yes | |
| innodb_compress_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_compression_failure_threshold_pct | Yes | Yes | Yes | Global | Yes | |
| innodb_compression_level | Yes | Yes | Yes | Global | Yes | |
| innodb_compression_pad_pct_max | Yes | Yes | Yes | Global | Yes | |
| innodb_concurrency_tickets | Yes | Yes | Yes | Global | Yes | |
| innodb_data_file_path | Yes | Yes | Yes | Global | No | |
| Innodb_data_fsyncs | Yes | Global | No | |||
| innodb_data_home_dir | Yes | Yes | Yes | Global | No | |
| Innodb_data_pending_fsyncs | Yes | Global | No | |||
| Innodb_data_pending_reads | Yes | Global | No | |||
| Innodb_data_pending_writes | Yes | Global | No | |||
| Innodb_data_read | Yes | Global | No | |||
| Innodb_data_reads | Yes | Global | No | |||
| Innodb_data_writes | Yes | Global | No | |||
| Innodb_data_written | Yes | Global | No | |||
| Innodb_dblwr_pages_written | Yes | Global | No | |||
| Innodb_dblwr_writes | Yes | Global | No | |||
| innodb_deadlock_detect | Yes | Yes | Yes | Global | Yes | |
| innodb_default_row_format | Yes | Yes | Yes | Global | Yes | |
| innodb_disable_resize_buffer_pool_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_disable_sort_file_cache | Yes | Yes | Yes | Global | Yes | |
| innodb_doublewrite | Yes | Yes | Yes | Global | No | |
| innodb_fast_shutdown | Yes | Yes | Yes | Global | Yes | |
| innodb_fil_make_page_dirty_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_file_format | Yes | Yes | Yes | Global | Yes | |
| innodb_file_format_check | Yes | Yes | Yes | Global | No | |
| innodb_file_format_max | Yes | Yes | Yes | Global | Yes | |
| innodb_file_per_table | Yes | Yes | Yes | Global | Yes | |
| innodb_fill_factor | Yes | Yes | Yes | Global | Yes | |
| innodb_flush_log_at_timeout | Yes | Yes | Yes | Global | Yes | |
| innodb_flush_log_at_trx_commit | Yes | Yes | Yes | Global | Yes | |
| innodb_flush_method | Yes | Yes | Yes | Global | No | |
| innodb_flush_neighbors | Yes | Yes | Yes | Global | Yes | |
| innodb_flush_sync | Yes | Yes | Yes | Global | Yes | |
| innodb_flushing_avg_loops | Yes | Yes | Yes | Global | Yes | |
| innodb_force_load_corrupted | Yes | Yes | Yes | Global | No | |
| innodb_force_recovery | Yes | Yes | Yes | Global | No | |
| innodb_ft_aux_table | Yes | Global | Yes | |||
| innodb_ft_cache_size | Yes | Yes | Yes | Global | No | |
| innodb_ft_enable_diag_print | Yes | Yes | Yes | Global | Yes | |
| innodb_ft_enable_stopword | Yes | Yes | Yes | Both | Yes | |
| innodb_ft_max_token_size | Yes | Yes | Yes | Global | No | |
| innodb_ft_min_token_size | Yes | Yes | Yes | Global | No | |
| innodb_ft_num_word_optimize | Yes | Yes | Yes | Global | Yes | |
| innodb_ft_result_cache_limit | Yes | Yes | Yes | Global | Yes | |
| innodb_ft_server_stopword_table | Yes | Yes | Yes | Global | Yes | |
| innodb_ft_sort_pll_degree | Yes | Yes | Yes | Global | No | |
| innodb_ft_total_cache_size | Yes | Yes | Yes | Global | No | |
| innodb_ft_user_stopword_table | Yes | Yes | Yes | Both | Yes | |
| Innodb_have_atomic_builtins | Yes | Global | No | |||
| innodb_io_capacity | Yes | Yes | Yes | Global | Yes | |
| innodb_io_capacity_max | Yes | Yes | Yes | Global | Yes | |
| innodb_large_prefix | Yes | Yes | Yes | Global | Yes | |
| innodb_limit_optimistic_insert_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_lock_wait_timeout | Yes | Yes | Yes | Both | Yes | |
| innodb_locks_unsafe_for_binlog | Yes | Yes | Yes | Global | No | |
| innodb_log_buffer_size | Yes | Yes | Yes | Global | No | |
| innodb_log_checkpoint_now | Yes | Yes | Yes | Global | Yes | |
| innodb_log_checksums | Yes | Yes | Yes | Global | Yes | |
| innodb_log_compressed_pages | Yes | Yes | Yes | Global | Yes | |
| innodb_log_file_size | Yes | Yes | Yes | Global | No | |
| innodb_log_files_in_group | Yes | Yes | Yes | Global | No | |
| innodb_log_group_home_dir | Yes | Yes | Yes | Global | No | |
| Innodb_log_waits | Yes | Global | No | |||
| innodb_log_write_ahead_size | Yes | Yes | Yes | Global | Yes | |
| Innodb_log_write_requests | Yes | Global | No | |||
| Innodb_log_writes | Yes | Global | No | |||
| innodb_lru_scan_depth | Yes | Yes | Yes | Global | Yes | |
| innodb_max_dirty_pages_pct | Yes | Yes | Yes | Global | Yes | |
| innodb_max_dirty_pages_pct_lwm | Yes | Yes | Yes | Global | Yes | |
| innodb_max_purge_lag | Yes | Yes | Yes | Global | Yes | |
| innodb_max_purge_lag_delay | Yes | Yes | Yes | Global | Yes | |
| innodb_max_undo_log_size | Yes | Yes | Yes | Global | Yes | |
| innodb_merge_threshold_set_all_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_monitor_disable | Yes | Yes | Yes | Global | Yes | |
| innodb_monitor_enable | Yes | Yes | Yes | Global | Yes | |
| innodb_monitor_reset | Yes | Yes | Yes | Global | Yes | |
| innodb_monitor_reset_all | Yes | Yes | Yes | Global | Yes | |
| Innodb_num_open_files | Yes | Global | No | |||
| innodb_numa_interleave | Yes | Yes | Yes | Global | No | |
| innodb_old_blocks_pct | Yes | Yes | Yes | Global | Yes | |
| innodb_old_blocks_time | Yes | Yes | Yes | Global | Yes | |
| innodb_online_alter_log_max_size | Yes | Yes | Yes | Global | Yes | |
| innodb_open_files | Yes | Yes | Yes | Global | No | |
| innodb_optimize_fulltext_only | Yes | Yes | Yes | Global | Yes | |
| Innodb_os_log_fsyncs | Yes | Global | No | |||
| Innodb_os_log_pending_fsyncs | Yes | Global | No | |||
| Innodb_os_log_pending_writes | Yes | Global | No | |||
| Innodb_os_log_written | Yes | Global | No | |||
| innodb_page_cleaners | Yes | Yes | Yes | Global | No | |
| Innodb_page_size | Yes | Global | No | |||
| innodb_page_size | Yes | Yes | Yes | Global | No | |
| Innodb_pages_created | Yes | Global | No | |||
| Innodb_pages_read | Yes | Global | No | |||
| Innodb_pages_written | Yes | Global | No | |||
| innodb_print_all_deadlocks | Yes | Yes | Yes | Global | Yes | |
| innodb_purge_batch_size | Yes | Yes | Yes | Global | Yes | |
| innodb_purge_rseg_truncate_frequency | Yes | Yes | Yes | Global | Yes | |
| innodb_purge_threads | Yes | Yes | Yes | Global | No | |
| innodb_random_read_ahead | Yes | Yes | Yes | Global | Yes | |
| innodb_read_ahead_threshold | Yes | Yes | Yes | Global | Yes | |
| innodb_read_io_threads | Yes | Yes | Yes | Global | No | |
| innodb_read_only | Yes | Yes | Yes | Global | No | |
| innodb_replication_delay | Yes | Yes | Yes | Global | Yes | |
| innodb_rollback_on_timeout | Yes | Yes | Yes | Global | No | |
| innodb_rollback_segments | Yes | Yes | Yes | Global | Yes | |
| Innodb_row_lock_current_waits | Yes | Global | No | |||
| Innodb_row_lock_time | Yes | Global | No | |||
| Innodb_row_lock_time_avg | Yes | Global | No | |||
| Innodb_row_lock_time_max | Yes | Global | No | |||
| Innodb_row_lock_waits | Yes | Global | No | |||
| Innodb_rows_deleted | Yes | Global | No | |||
| Innodb_rows_inserted | Yes | Global | No | |||
| Innodb_rows_read | Yes | Global | No | |||
| Innodb_rows_updated | Yes | Global | No | |||
| innodb_saved_page_number_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_sort_buffer_size | Yes | Yes | Yes | Global | No | |
| innodb_spin_wait_delay | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_auto_recalc | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_include_delete_marked | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_method | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_on_metadata | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_persistent | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_persistent_sample_pages | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_sample_pages | Yes | Yes | Yes | Global | Yes | |
| innodb_stats_transient_sample_pages | Yes | Yes | Yes | Global | Yes | |
| innodb-status-file | Yes | Yes | ||||
| innodb_status_output | Yes | Yes | Yes | Global | Yes | |
| innodb_status_output_locks | Yes | Yes | Yes | Global | Yes | |
| innodb_strict_mode | Yes | Yes | Yes | Both | Yes | |
| innodb_support_xa | Yes | Yes | Yes | Both | Yes | |
| innodb_sync_array_size | Yes | Yes | Yes | Global | No | |
| innodb_sync_debug | Yes | Yes | Yes | Global | No | |
| innodb_sync_spin_loops | Yes | Yes | Yes | Global | Yes | |
| innodb_table_locks | Yes | Yes | Yes | Both | Yes | |
| innodb_temp_data_file_path | Yes | Yes | Yes | Global | No | |
| innodb_thread_concurrency | Yes | Yes | Yes | Global | Yes | |
| innodb_thread_sleep_delay | Yes | Yes | Yes | Global | Yes | |
| innodb_tmpdir | Yes | Yes | Yes | Both | Yes | |
| Innodb_truncated_status_writes | Yes | Global | No | |||
| innodb_trx_purge_view_update_only_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_trx_rseg_n_slots_debug | Yes | Yes | Yes | Global | Yes | |
| innodb_undo_directory | Yes | Yes | Yes | Global | No | |
| innodb_undo_log_truncate | Yes | Yes | Yes | Global | Yes | |
| innodb_undo_logs | Yes | Yes | Yes | Global | Yes | |
| innodb_undo_tablespaces | Yes | Yes | Yes | Global | No | |
| innodb_use_native_aio | Yes | Yes | Yes | Global | No | |
| innodb_version | Yes | Global | No | |||
| innodb_write_io_threads | Yes | Yes | Yes | Global | No | |
| insert_id | Yes | Session | Yes | |||
| install | Yes | |||||
| install-manual | Yes | |||||
| interactive_timeout | Yes | Yes | Yes | Both | Yes | |
| internal_tmp_disk_storage_engine | Yes | Yes | Yes | Global | Yes | |
| join_buffer_size | Yes | Yes | Yes | Both | Yes | |
| keep_files_on_create | Yes | Yes | Yes | Both | Yes | |
| Key_blocks_not_flushed | Yes | Global | No | |||
| Key_blocks_unused | Yes | Global | No | |||
| Key_blocks_used | Yes | Global | No | |||
| key_buffer_size | Yes | Yes | Yes | Global | Yes | |
| key_cache_age_threshold | Yes | Yes | Yes | Global | Yes | |
| key_cache_block_size | Yes | Yes | Yes | Global | Yes | |
| key_cache_division_limit | Yes | Yes | Yes | Global | Yes | |
| Key_read_requests | Yes | Global | No | |||
| Key_reads | Yes | Global | No | |||
| Key_write_requests | Yes | Global | No | |||
| Key_writes | Yes | Global | No | |||
| keyring_aws_cmk_id | Yes | Yes | Yes | Global | Yes | |
| keyring_aws_conf_file | Yes | Yes | Yes | Global | No | |
| keyring_aws_data_file | Yes | Yes | Yes | Global | No | |
| keyring_aws_region | Yes | Yes | Yes | Global | Yes | |
| keyring_encrypted_file_data | Yes | Yes | Yes | Global | Yes | |
| keyring_encrypted_file_password | Yes | Yes | Yes | Global | Yes | |
| keyring_file_data | Yes | Yes | Yes | Global | Yes | |
| keyring-migration-destination | Yes | Yes | ||||
| keyring-migration-host | Yes | Yes | ||||
| keyring-migration-password | Yes | Yes | ||||
| keyring-migration-port | Yes | Yes | ||||
| keyring-migration-socket | Yes | Yes | ||||
| keyring-migration-source | Yes | Yes | ||||
| keyring-migration-user | Yes | Yes | ||||
| keyring_okv_conf_dir | Yes | Yes | Yes | Global | Yes | |
| keyring_operations | Yes | Global | Yes | |||
| language | Yes | Yes | Yes | Global | No | |
| large_files_support | Yes | Global | No | |||
| large_page_size | Yes | Global | No | |||
| large_pages | Yes | Yes | Yes | Global | No | |
| last_insert_id | Yes | Session | Yes | |||
| Last_query_cost | Yes | Session | No | |||
| Last_query_partial_plans | Yes | Session | No | |||
| lc_messages | Yes | Yes | Yes | Both | Yes | |
| lc_messages_dir | Yes | Yes | Yes | Global | No | |
| lc_time_names | Yes | Yes | Yes | Both | Yes | |
| license | Yes | Global | No | |||
| local_infile | Yes | Yes | Yes | Global | Yes | |
| local-service | Yes | |||||
| lock_wait_timeout | Yes | Yes | Yes | Both | Yes | |
| Locked_connects | Yes | Global | No | |||
| locked_in_memory | Yes | Global | No | |||
| log-bin | Yes | Yes | ||||
| log_bin | Yes | Global | No | |||
| log_bin_basename | Yes | Global | No | |||
| log_bin_index | Yes | Yes | Yes | Global | No | |
| log_bin_trust_function_creators | Yes | Yes | Yes | Global | Yes | |
| log_bin_use_v1_row_events | Yes | Yes | Yes | Global | Yes | |
| log_builtin_as_identified_by_password | Yes | Yes | Yes | Global | Yes | |
| log_error | Yes | Yes | Yes | Global | No | |
| log_error_verbosity | Yes | Yes | Yes | Global | Yes | |
| log-isam | Yes | Yes | ||||
| log_output | Yes | Yes | Yes | Global | Yes | |
| log_queries_not_using_indexes | Yes | Yes | Yes | Global | Yes | |
| log-raw | Yes | Yes | ||||
| log-short-format | Yes | Yes | ||||
| log_slave_updates | Yes | Yes | Yes | Global | No | |
| log_slow_admin_statements | Yes | Yes | Yes | Global | Yes | |
| log_slow_slave_statements | Yes | Yes | Yes | Global | Yes | |
| log_statements_unsafe_for_binlog | Yes | Yes | Yes | Global | Yes | |
| log_syslog | Yes | Yes | Yes | Global | Yes | |
| log_syslog_facility | Yes | Yes | Yes | Global | Yes | |
| log_syslog_include_pid | Yes | Yes | Yes | Global | Yes | |
| log_syslog_tag | Yes | Yes | Yes | Global | Yes | |
| log-tc | Yes | Yes | ||||
| log-tc-size | Yes | Yes | ||||
| log_throttle_queries_not_using_indexes | Yes | Yes | Yes | Global | Yes | |
| log_timestamps | Yes | Yes | Yes | Global | Yes | |
| log_warnings | Yes | Yes | Yes | Global | Yes | |
| long_query_time | Yes | Yes | Yes | Both | Yes | |
| low_priority_updates | Yes | Yes | Yes | Both | Yes | |
| lower_case_file_system | Yes | Global | No | |||
| lower_case_table_names | Yes | Yes | Yes | Global | No | |
| master-info-file | Yes | Yes | ||||
| master_info_repository | Yes | Yes | Yes | Global | Yes | |
| master-retry-count | Yes | Yes | ||||
| master_verify_checksum | Yes | Yes | Yes | Global | Yes | |
| max_allowed_packet | Yes | Yes | Yes | Both | Yes | |
| max_binlog_cache_size | Yes | Yes | Yes | Global | Yes | |
| max-binlog-dump-events | Yes | Yes | ||||
| max_binlog_size | Yes | Yes | Yes | Global | Yes | |
| max_binlog_stmt_cache_size | Yes | Yes | Yes | Global | Yes | |
| max_connect_errors | Yes | Yes | Yes | Global | Yes | |
| max_connections | Yes | Yes | Yes | Global | Yes | |
| max_delayed_threads | Yes | Yes | Yes | Both | Yes | |
| max_digest_length | Yes | Yes | Yes | Global | No | |
| max_error_count | Yes | Yes | Yes | Both | Yes | |
| max_execution_time | Yes | Yes | Yes | Both | Yes | |
| Max_execution_time_exceeded | Yes | Both | No | |||
| Max_execution_time_set | Yes | Both | No | |||
| Max_execution_time_set_failed | Yes | Both | No | |||
| max_heap_table_size | Yes | Yes | Yes | Both | Yes | |
| max_insert_delayed_threads | Yes | Both | Yes | |||
| max_join_size | Yes | Yes | Yes | Both | Yes | |
| max_length_for_sort_data | Yes | Yes | Yes | Both | Yes | |
| max_points_in_geometry | Yes | Yes | Yes | Both | Yes | |
| max_prepared_stmt_count | Yes | Yes | Yes | Global | Yes | |
| max_relay_log_size | Yes | Yes | Yes | Global | Yes | |
| max_seeks_for_key | Yes | Yes | Yes | Both | Yes | |
| max_sort_length | Yes | Yes | Yes | Both | Yes | |
| max_sp_recursion_depth | Yes | Yes | Yes | Both | Yes | |
| max_tmp_tables | Yes | Both | Yes | |||
| Max_used_connections | Yes | Global | No | |||
| Max_used_connections_time | Yes | Global | No | |||
| max_user_connections | Yes | Yes | Yes | Both | Yes | |
| max_write_lock_count | Yes | Yes | Yes | Global | Yes | |
| mecab_charset | Yes | Global | No | |||
| mecab_rc_file | Yes | Yes | Yes | Global | No | |
| memlock | Yes | Yes | ||||
| - Variable: locked_in_memory | ||||||
| metadata_locks_cache_size | Yes | Yes | Yes | Global | No | |
| metadata_locks_hash_instances | Yes | Yes | Yes | Global | No | |
| min_examined_row_limit | Yes | Yes | Yes | Both | Yes | |
| multi_range_count | Yes | Yes | Yes | Both | Yes | |
| myisam-block-size | Yes | Yes | ||||
| myisam_data_pointer_size | Yes | Yes | Yes | Global | Yes | |
| myisam_max_sort_file_size | Yes | Yes | Yes | Global | Yes | |
| myisam_mmap_size | Yes | Yes | Yes | Global | No | |
| myisam_recover_options | Yes | Yes | Yes | Global | No | |
| myisam_repair_threads | Yes | Yes | Yes | Both | Yes | |
| myisam_sort_buffer_size | Yes | Yes | Yes | Both | Yes | |
| myisam_stats_method | Yes | Yes | Yes | Both | Yes | |
| myisam_use_mmap | Yes | Yes | Yes | Global | Yes | |
| mysql_firewall_mode | Yes | Yes | Yes | Global | Yes | |
| mysql_firewall_trace | Yes | Yes | Yes | Global | Yes | |
| mysql_native_password_proxy_users | Yes | Yes | Yes | Global | Yes | |
| mysqlx | Yes | Yes | ||||
| Mysqlx_address | Yes | Global | No | |||
| mysqlx_bind_address | Yes | Yes | Yes | Global | No | |
| Mysqlx_bytes_received | Yes | Both | No | |||
| Mysqlx_bytes_sent | Yes | Both | No | |||
| mysqlx_connect_timeout | Yes | Yes | Yes | Global | Yes | |
| Mysqlx_connection_accept_errors | Yes | Both | No | |||
| Mysqlx_connection_errors | Yes | Both | No | |||
| Mysqlx_connections_accepted | Yes | Global | No | |||
| Mysqlx_connections_closed | Yes | Global | No | |||
| Mysqlx_connections_rejected | Yes | Global | No | |||
| Mysqlx_crud_create_view | Yes | Both | No | |||
| Mysqlx_crud_delete | Yes | Both | No | |||
| Mysqlx_crud_drop_view | Yes | Both | No | |||
| Mysqlx_crud_find | Yes | Both | No | |||
| Mysqlx_crud_insert | Yes | Both | No | |||
| Mysqlx_crud_modify_view | Yes | Both | No | |||
| Mysqlx_crud_update | Yes | Both | No | |||
| Mysqlx_errors_sent | Yes | Both | No | |||
| Mysqlx_errors_unknown_message_type | Yes | Both | No | |||
| Mysqlx_expect_close | Yes | Both | No | |||
| Mysqlx_expect_open | Yes | Both | No | |||
| mysqlx_idle_worker_thread_timeout | Yes | Yes | Yes | Global | Yes | |
| Mysqlx_init_error | Yes | Both | No | |||
| mysqlx_max_allowed_packet | Yes | Yes | Yes | Global | Yes | |
| mysqlx_max_connections | Yes | Yes | Yes | Global | Yes | |
| mysqlx_min_worker_threads | Yes | Yes | Yes | Global | Yes | |
| Mysqlx_notice_other_sent | Yes | Both | No | |||
| Mysqlx_notice_warning_sent | Yes | Both | No | |||
| Mysqlx_port | Yes | Global | No | |||
| mysqlx_port | Yes | Yes | Yes | Global | No | |
| mysqlx_port_open_timeout | Yes | Yes | Yes | Global | No | |
| Mysqlx_rows_sent | Yes | Both | No | |||
| Mysqlx_sessions | Yes | Global | No | |||
| Mysqlx_sessions_accepted | Yes | Global | No | |||
| Mysqlx_sessions_closed | Yes | Global | No | |||
| Mysqlx_sessions_fatal_error | Yes | Global | No | |||
| Mysqlx_sessions_killed | Yes | Global | No | |||
| Mysqlx_sessions_rejected | Yes | Global | No | |||
| Mysqlx_socket | Yes | Global | No | |||
| mysqlx_socket | Yes | Yes | Yes | Global | No | |
| Mysqlx_ssl_accept_renegotiates | Yes | Global | No | |||
| Mysqlx_ssl_accepts | Yes | Global | No | |||
| Mysqlx_ssl_active | Yes | Both | No | |||
| mysqlx_ssl_ca | Yes | Yes | Yes | Global | No | |
| mysqlx_ssl_capath | Yes | Yes | Yes | Global | No | |
| mysqlx_ssl_cert | Yes | Yes | Yes | Global | No | |
| Mysqlx_ssl_cipher | Yes | Both | No | |||
| mysqlx_ssl_cipher | Yes | Yes | Yes | Global | No | |
| Mysqlx_ssl_cipher_list | Yes | Both | No | |||
| mysqlx_ssl_crl | Yes | Yes | Yes | Global | No | |
| mysqlx_ssl_crlpath | Yes | Yes | Yes | Global | No | |
| Mysqlx_ssl_ctx_verify_depth | Yes | Both | No | |||
| Mysqlx_ssl_ctx_verify_mode | Yes | Both | No | |||
| Mysqlx_ssl_finished_accepts | Yes | Global | No | |||
| mysqlx_ssl_key | Yes | Yes | Yes | Global | No | |
| Mysqlx_ssl_server_not_after | Yes | Global | No | |||
| Mysqlx_ssl_server_not_before | Yes | Global | No | |||
| Mysqlx_ssl_verify_depth | Yes | Global | No | |||
| Mysqlx_ssl_verify_mode | Yes | Global | No | |||
| Mysqlx_ssl_version | Yes | Both | No | |||
| Mysqlx_stmt_create_collection | Yes | Both | No | |||
| Mysqlx_stmt_create_collection_index | Yes | Both | No | |||
| Mysqlx_stmt_disable_notices | Yes | Both | No | |||
| Mysqlx_stmt_drop_collection | Yes | Both | No | |||
| Mysqlx_stmt_drop_collection_index | Yes | Both | No | |||
| Mysqlx_stmt_enable_notices | Yes | Both | No | |||
| Mysqlx_stmt_ensure_collection | Yes | Both | No | |||
| Mysqlx_stmt_execute_mysqlx | Yes | Both | No | |||
| Mysqlx_stmt_execute_sql | Yes | Both | No | |||
| Mysqlx_stmt_execute_xplugin | Yes | Both | No | |||
| Mysqlx_stmt_kill_client | Yes | Both | No | |||
| Mysqlx_stmt_list_clients | Yes | Both | No | |||
| Mysqlx_stmt_list_notices | Yes | Both | No | |||
| Mysqlx_stmt_list_objects | Yes | Both | No | |||
| Mysqlx_stmt_ping | Yes | Both | No | |||
| Mysqlx_worker_threads | Yes | Global | No | |||
| Mysqlx_worker_threads_active | Yes | Global | No | |||
| named_pipe | Yes | Yes | Yes | Global | No | |
| named_pipe_full_access_group | Yes | Yes | Yes | Global | No | |
| ndb_allow_copying_alter_table | Yes | Yes | Yes | Both | Yes | |
| Ndb_api_adaptive_send_deferred_count | Yes | Global | No | |||
| Ndb_api_adaptive_send_deferred_count_session | Yes | Global | No | |||
| Ndb_api_adaptive_send_deferred_count_slave | Yes | Global | No | |||
| Ndb_api_adaptive_send_forced_count | Yes | Global | No | |||
| Ndb_api_adaptive_send_forced_count_session | Yes | Global | No | |||
| Ndb_api_adaptive_send_forced_count_slave | Yes | Global | No | |||
| Ndb_api_adaptive_send_unforced_count | Yes | Global | No | |||
| Ndb_api_adaptive_send_unforced_count_session | Yes | Global | No | |||
| Ndb_api_adaptive_send_unforced_count_slave | Yes | Global | No | |||
| Ndb_api_bytes_received_count | Yes | Global | No | |||
| Ndb_api_bytes_received_count_session | Yes | Session | No | |||
| Ndb_api_bytes_received_count_slave | Yes | Global | No | |||
| Ndb_api_bytes_sent_count | Yes | Global | No | |||
| Ndb_api_bytes_sent_count_session | Yes | Session | No | |||
| Ndb_api_bytes_sent_count_slave | Yes | Global | No | |||
| Ndb_api_event_bytes_count | Yes | Global | No | |||
| Ndb_api_event_bytes_count_injector | Yes | Global | No | |||
| Ndb_api_event_data_count | Yes | Global | No | |||
| Ndb_api_event_data_count_injector | Yes | Global | No | |||
| Ndb_api_event_nondata_count | Yes | Global | No | |||
| Ndb_api_event_nondata_count_injector | Yes | Global | No | |||
| Ndb_api_pk_op_count | Yes | Global | No | |||
| Ndb_api_pk_op_count_session | Yes | Session | No | |||
| Ndb_api_pk_op_count_slave | Yes | Global | No | |||
| Ndb_api_pruned_scan_count | Yes | Global | No | |||
| Ndb_api_pruned_scan_count_session | Yes | Session | No | |||
| Ndb_api_pruned_scan_count_slave | Yes | Global | No | |||
| Ndb_api_range_scan_count | Yes | Global | No | |||
| Ndb_api_range_scan_count_session | Yes | Session | No | |||
| Ndb_api_range_scan_count_slave | Yes | Global | No | |||
| Ndb_api_read_row_count | Yes | Global | No | |||
| Ndb_api_read_row_count_session | Yes | Session | No | |||
| Ndb_api_read_row_count_slave | Yes | Global | No | |||
| Ndb_api_scan_batch_count | Yes | Global | No | |||
| Ndb_api_scan_batch_count_session | Yes | Session | No | |||
| Ndb_api_scan_batch_count_slave | Yes | Global | No | |||
| Ndb_api_table_scan_count | Yes | Global | No | |||
| Ndb_api_table_scan_count_session | Yes | Session | No | |||
| Ndb_api_table_scan_count_slave | Yes | Global | No | |||
| Ndb_api_trans_abort_count | Yes | Global | No | |||
| Ndb_api_trans_abort_count_session | Yes | Session | No | |||
| Ndb_api_trans_abort_count_slave | Yes | Global | No | |||
| Ndb_api_trans_close_count | Yes | Global | No | |||
| Ndb_api_trans_close_count_session | Yes | Session | No | |||
| Ndb_api_trans_close_count_slave | Yes | Global | No | |||
| Ndb_api_trans_commit_count | Yes | Global | No | |||
| Ndb_api_trans_commit_count_session | Yes | Session | No | |||
| Ndb_api_trans_commit_count_slave | Yes | Global | No | |||
| Ndb_api_trans_local_read_row_count | Yes | Global | No | |||
| Ndb_api_trans_local_read_row_count_session | Yes | Session | No | |||
| Ndb_api_trans_local_read_row_count_slave | Yes | Global | No | |||
| Ndb_api_trans_start_count | Yes | Global | No | |||
| Ndb_api_trans_start_count_session | Yes | Session | No | |||
| Ndb_api_trans_start_count_slave | Yes | Global | No | |||
| Ndb_api_uk_op_count | Yes | Global | No | |||
| Ndb_api_uk_op_count_session | Yes | Session | No | |||
| Ndb_api_uk_op_count_slave | Yes | Global | No | |||
| Ndb_api_wait_exec_complete_count | Yes | Global | No | |||
| Ndb_api_wait_exec_complete_count_session | Yes | Session | No | |||
| Ndb_api_wait_exec_complete_count_slave | Yes | Global | No | |||
| Ndb_api_wait_meta_request_count | Yes | Global | No | |||
| Ndb_api_wait_meta_request_count_session | Yes | Session | No | |||
| Ndb_api_wait_meta_request_count_slave | Yes | Global | No | |||
| Ndb_api_wait_nanos_count | Yes | Global | No | |||
| Ndb_api_wait_nanos_count_session | Yes | Session | No | |||
| Ndb_api_wait_nanos_count_slave | Yes | Global | No | |||
| Ndb_api_wait_scan_result_count | Yes | Global | No | |||
| Ndb_api_wait_scan_result_count_session | Yes | Session | No | |||
| Ndb_api_wait_scan_result_count_slave | Yes | Global | No | |||
| ndb_autoincrement_prefetch_sz | Yes | Yes | Yes | Both | Yes | |
| ndb_batch_size | Yes | Yes | Yes | Both | Yes | |
| ndb_blob_read_batch_bytes | Yes | Yes | Yes | Both | Yes | |
| ndb_blob_write_batch_bytes | Yes | Yes | Yes | Both | Yes | |
| ndb_cache_check_time | Yes | Yes | Yes | Global | Yes | |
| ndb_clear_apply_status | Yes | Yes | Global | Yes | ||
| ndb_cluster_connection_pool | Yes | Yes | Yes | Global | No | |
| ndb_cluster_connection_pool_nodeids | Yes | Yes | Yes | Global | No | |
| Ndb_cluster_node_id | Yes | Global | No | |||
| Ndb_config_from_host | Yes | Both | No | |||
| Ndb_config_from_port | Yes | Both | No | |||
| Ndb_conflict_fn_epoch | Yes | Global | No | |||
| Ndb_conflict_fn_epoch_trans | Yes | Global | No | |||
| Ndb_conflict_fn_epoch2 | Yes | Global | No | |||
| Ndb_conflict_fn_epoch2_trans | Yes | Global | No | |||
| Ndb_conflict_fn_max | Yes | Global | No | |||
| Ndb_conflict_fn_max_del_win | Yes | Global | No | |||
| Ndb_conflict_fn_old | Yes | Global | No | |||
| Ndb_conflict_last_conflict_epoch | Yes | Global | No | |||
| Ndb_conflict_last_stable_epoch | Yes | Global | No | |||
| Ndb_conflict_reflected_op_discard_count | Yes | Global | No | |||
| Ndb_conflict_reflected_op_prepare_count | Yes | Global | No | |||
| Ndb_conflict_refresh_op_count | Yes | Global | No | |||
| Ndb_conflict_trans_conflict_commit_count | Yes | Global | No | |||
| Ndb_conflict_trans_detect_iter_count | Yes | Global | No | |||
| Ndb_conflict_trans_reject_count | Yes | Global | No | |||
| Ndb_conflict_trans_row_conflict_count | Yes | Global | No | |||
| Ndb_conflict_trans_row_reject_count | Yes | Global | No | |||
| ndb-connectstring | Yes | Yes | ||||
| ndb_data_node_neighbour | Yes | Yes | Yes | Global | Yes | |
| ndb_default_column_format | Yes | Yes | Yes | Global | Yes | |
| ndb_default_column_format | Yes | Yes | Yes | Global | Yes | |
| ndb_deferred_constraints | Yes | Yes | Yes | Both | Yes | |
| ndb_deferred_constraints | Yes | Yes | Yes | Both | Yes | |
| ndb_distribution | Yes | Yes | Yes | Global | Yes | |
| ndb_distribution | Yes | Yes | Yes | Global | Yes | |
| Ndb_epoch_delete_delete_count | Yes | Global | No | |||
| ndb_eventbuffer_free_percent | Yes | Yes | Yes | Global | Yes | |
| ndb_eventbuffer_max_alloc | Yes | Yes | Yes | Global | Yes | |
| Ndb_execute_count | Yes | Global | No | |||
| ndb_extra_logging | Yes | Yes | Yes | Global | Yes | |
| ndb_force_send | Yes | Yes | Yes | Both | Yes | |
| ndb_fully_replicated | Yes | Yes | Yes | Both | Yes | |
| ndb_index_stat_enable | Yes | Yes | Yes | Both | Yes | |
| ndb_index_stat_option | Yes | Yes | Yes | Both | Yes | |
| ndb_join_pushdown | Yes | Both | Yes | |||
| Ndb_last_commit_epoch_server | Yes | Global | No | |||
| Ndb_last_commit_epoch_session | Yes | Session | No | |||
| ndb_log_apply_status | Yes | Yes | Yes | Global | No | |
| ndb_log_apply_status | Yes | Yes | Yes | Global | No | |
| ndb_log_bin | Yes | Yes | Both | No | ||
| ndb_log_binlog_index | Yes | Yes | Global | Yes | ||
| ndb_log_empty_epochs | Yes | Yes | Yes | Global | Yes | |
| ndb_log_empty_epochs | Yes | Yes | Yes | Global | Yes | |
| ndb_log_empty_update | Yes | Yes | Yes | Global | Yes | |
| ndb_log_empty_update | Yes | Yes | Yes | Global | Yes | |
| ndb_log_exclusive_reads | Yes | Yes | Yes | Both | Yes | |
| ndb_log_exclusive_reads | Yes | Yes | Yes | Both | Yes | |
| ndb_log_fail_terminate | Yes | Yes | Yes | Global | No | |
| ndb_log_orig | Yes | Yes | Yes | Global | No | |
| ndb_log_orig | Yes | Yes | Yes | Global | No | |
| ndb_log_transaction_id | Yes | Yes | Yes | Global | No | |
| ndb_log_transaction_id | Yes | Global | No | |||
| ndb_log_update_as_write | Yes | Yes | Yes | Global | Yes | |
| ndb_log_update_minimal | Yes | Yes | Yes | Global | Yes | |
| ndb_log_updated_only | Yes | Yes | Yes | Global | Yes | |
| ndb-mgmd-host | Yes | Yes | ||||
| ndb_nodeid | Yes | Yes | Yes | Global | No | |
| Ndb_number_of_data_nodes | Yes | Global | No | |||
| ndb_optimization_delay | Yes | Yes | Yes | Global | Yes | |
| ndb-optimized-node-selection | Yes | |||||
| ndb_optimized_node_selection | Yes | Yes | Yes | Global | No | |
| Ndb_pruned_scan_count | Yes | Global | No | |||
| Ndb_pushed_queries_defined | Yes | Global | No | |||
| Ndb_pushed_queries_dropped | Yes | Global | No | |||
| Ndb_pushed_queries_executed | Yes | Global | No | |||
| Ndb_pushed_reads | Yes | Global | No | |||
| ndb_read_backup | Yes | Yes | Yes | Global | Yes | |
| ndb_recv_thread_activation_threshold | Yes | Yes | Yes | Global | Yes | |
| ndb_recv_thread_cpu_mask | Yes | Yes | Yes | Global | Yes | |
| ndb_report_thresh_binlog_epoch_slip | Yes | Yes | Yes | Global | Yes | |
| ndb_report_thresh_binlog_mem_usage | Yes | Yes | Yes | Global | Yes | |
| ndb_row_checksum | Yes | Both | Yes | |||
| Ndb_scan_count | Yes | Global | No | |||
| ndb_show_foreign_key_mock_tables | Yes | Yes | Yes | Global | Yes | |
| ndb_slave_conflict_role | Yes | Yes | Yes | Global | Yes | |
| Ndb_slave_max_replicated_epoch | Yes | Global | No | |||
| Ndb_system_name | Yes | Global | No | |||
| ndb_table_no_logging | Yes | Session | Yes | |||
| ndb_table_temporary | Yes | Session | Yes | |||
| ndb-transid-mysql-connection-map | Yes | |||||
| ndb_use_copying_alter_table | Yes | Both | No | |||
| ndb_use_exact_count | Yes | Both | Yes | |||
| ndb_use_transactions | Yes | Yes | Yes | Both | Yes | |
| ndb_version | Yes | Global | No | |||
| ndb_version_string | Yes | Global | No | |||
| ndb_wait_connected | Yes | Yes | Yes | Global | No | |
| ndb_wait_setup | Yes | Yes | Yes | Global | No | |
| ndbcluster | Yes | Yes | ||||
| ndbinfo_database | Yes | Global | No | |||
| ndbinfo_max_bytes | Yes | Yes | Both | Yes | ||
| ndbinfo_max_rows | Yes | Yes | Both | Yes | ||
| ndbinfo_offline | Yes | Global | Yes | |||
| ndbinfo_show_hidden | Yes | Yes | Both | Yes | ||
| ndbinfo_table_prefix | Yes | Global | No | |||
| ndbinfo_version | Yes | Global | No | |||
| net_buffer_length | Yes | Yes | Yes | Both | Yes | |
| net_read_timeout | Yes | Yes | Yes | Both | Yes | |
| net_retry_count | Yes | Yes | Yes | Both | Yes | |
| net_write_timeout | Yes | Yes | Yes | Both | Yes | |
| new | Yes | Yes | Yes | Both | Yes | |
| ngram_token_size | Yes | Yes | Yes | Global | No | |
| no-defaults | Yes | |||||
| Not_flushed_delayed_rows | Yes | Global | No | |||
| offline_mode | Yes | Yes | Yes | Global | Yes | |
| old | Yes | Yes | Yes | Global | No | |
| old_alter_table | Yes | Yes | Yes | Both | Yes | |
| old_passwords | Yes | Yes | Yes | Both | Yes | |
| old-style-user-limits | Yes | Yes | ||||
| Ongoing_anonymous_gtid_violating_transaction_count | Yes | Global | No | |||
| Ongoing_anonymous_transaction_count | Yes | Global | No | |||
| Ongoing_automatic_gtid_violating_transaction_count | Yes | Global | No | |||
| Open_files | Yes | Global | No | |||
| open_files_limit | Yes | Yes | Yes | Global | No | |
| Open_streams | Yes | Global | No | |||
| Open_table_definitions | Yes | Global | No | |||
| Open_tables | Yes | Both | No | |||
| Opened_files | Yes | Global | No | |||
| Opened_table_definitions | Yes | Both | No | |||
| Opened_tables | Yes | Both | No | |||
| optimizer_prune_level | Yes | Yes | Yes | Both | Yes | |
| optimizer_search_depth | Yes | Yes | Yes | Both | Yes | |
| optimizer_switch | Yes | Yes | Yes | Both | Yes | |
| optimizer_trace | Yes | Yes | Yes | Both | Yes | |
| optimizer_trace_features | Yes | Yes | Yes | Both | Yes | |
| optimizer_trace_limit | Yes | Yes | Yes | Both | Yes | |
| optimizer_trace_max_mem_size | Yes | Yes | Yes | Both | Yes | |
| optimizer_trace_offset | Yes | Yes | Yes | Both | Yes | |
| parser_max_mem_size | Yes | Yes | Yes | Both | Yes | |
| partition | Yes | Yes | ||||
| performance_schema | Yes | Yes | Yes | Global | No | |
| Performance_schema_accounts_lost | Yes | Global | No | |||
| performance_schema_accounts_size | Yes | Yes | Yes | Global | No | |
| Performance_schema_cond_classes_lost | Yes | Global | No | |||
| Performance_schema_cond_instances_lost | Yes | Global | No | |||
| performance-schema-consumer-events-stages-current | Yes | Yes | ||||
| performance-schema-consumer-events-stages-history | Yes | Yes | ||||
| performance-schema-consumer-events-stages-history-long | Yes | Yes | ||||
| performance-schema-consumer-events-statements-current | Yes | Yes | ||||
| performance-schema-consumer-events-statements-history | Yes | Yes | ||||
| performance-schema-consumer-events-statements-history-long | Yes | Yes | ||||
| performance-schema-consumer-events-transactions-current | Yes | Yes | ||||
| performance-schema-consumer-events-transactions-history | Yes | Yes | ||||
| performance-schema-consumer-events-transactions-history-long | Yes | Yes | ||||
| performance-schema-consumer-events-waits-current | Yes | Yes | ||||
| performance-schema-consumer-events-waits-history | Yes | Yes | ||||
| performance-schema-consumer-events-waits-history-long | Yes | Yes | ||||
| performance-schema-consumer-global-instrumentation | Yes | Yes | ||||
| performance-schema-consumer-statements-digest | Yes | Yes | ||||
| performance-schema-consumer-thread-instrumentation | Yes | Yes | ||||
| Performance_schema_digest_lost | Yes | Global | No | |||
| performance_schema_digests_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_stages_history_long_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_stages_history_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_statements_history_long_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_statements_history_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_transactions_history_long_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_transactions_history_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_waits_history_long_size | Yes | Yes | Yes | Global | No | |
| performance_schema_events_waits_history_size | Yes | Yes | Yes | Global | No | |
| Performance_schema_file_classes_lost | Yes | Global | No | |||
| Performance_schema_file_handles_lost | Yes | Global | No | |||
| Performance_schema_file_instances_lost | Yes | Global | No | |||
| Performance_schema_hosts_lost | Yes | Global | No | |||
| performance_schema_hosts_size | Yes | Yes | Yes | Global | No | |
| Performance_schema_index_stat_lost | Yes | Global | No | |||
| performance-schema-instrument | Yes | Yes | ||||
| Performance_schema_locker_lost | Yes | Global | No | |||
| performance_schema_max_cond_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_cond_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_digest_length | Yes | Yes | Yes | Global | No | |
| performance_schema_max_file_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_file_handles | Yes | Yes | Yes | Global | No | |
| performance_schema_max_file_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_index_stat | Yes | Yes | Yes | Global | No | |
| performance_schema_max_memory_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_metadata_locks | Yes | Yes | Yes | Global | No | |
| performance_schema_max_mutex_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_mutex_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_prepared_statements_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_program_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_rwlock_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_rwlock_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_socket_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_socket_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_sql_text_length | Yes | Yes | Yes | Global | No | |
| performance_schema_max_stage_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_statement_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_statement_stack | Yes | Yes | Yes | Global | No | |
| performance_schema_max_table_handles | Yes | Yes | Yes | Global | No | |
| performance_schema_max_table_instances | Yes | Yes | Yes | Global | No | |
| performance_schema_max_table_lock_stat | Yes | Yes | Yes | Global | No | |
| performance_schema_max_thread_classes | Yes | Yes | Yes | Global | No | |
| performance_schema_max_thread_instances | Yes | Yes | Yes | Global | No | |
| Performance_schema_memory_classes_lost | Yes | Global | No | |||
| Performance_schema_metadata_lock_lost | Yes | Global | No | |||
| Performance_schema_mutex_classes_lost | Yes | Global | No | |||
| Performance_schema_mutex_instances_lost | Yes | Global | No | |||
| Performance_schema_nested_statement_lost | Yes | Global | No | |||
| Performance_schema_prepared_statements_lost | Yes | Global | No | |||
| Performance_schema_program_lost | Yes | Global | No | |||
| Performance_schema_rwlock_classes_lost | Yes | Global | No | |||
| Performance_schema_rwlock_instances_lost | Yes | Global | No | |||
| Performance_schema_session_connect_attrs_lost | Yes | Global | No | |||
| performance_schema_session_connect_attrs_size | Yes | Yes | Yes | Global | No | |
| performance_schema_setup_actors_size | Yes | Yes | Yes | Global | No | |
| performance_schema_setup_objects_size | Yes | Yes | Yes | Global | No | |
| performance_schema_show_processlist | Yes | Yes | Yes | Global | Yes | |
| Performance_schema_socket_classes_lost | Yes | Global | No | |||
| Performance_schema_socket_instances_lost | Yes | Global | No | |||
| Performance_schema_stage_classes_lost | Yes | Global | No | |||
| Performance_schema_statement_classes_lost | Yes | Global | No | |||
| Performance_schema_table_handles_lost | Yes | Global | No | |||
| Performance_schema_table_instances_lost | Yes | Global | No | |||
| Performance_schema_table_lock_stat_lost | Yes | Global | No | |||
| Performance_schema_thread_classes_lost | Yes | Global | No | |||
| Performance_schema_thread_instances_lost | Yes | Global | No | |||
| Performance_schema_users_lost | Yes | Global | No | |||
| performance_schema_users_size | Yes | Yes | Yes | Global | No | |
| pid_file | Yes | Yes | Yes | Global | No | |
| plugin_dir | Yes | Yes | Yes | Global | No | |
| plugin-load | Yes | Yes | ||||
| plugin-load-add | Yes | Yes | ||||
| plugin-xxx | Yes | Yes | ||||
| port | Yes | Yes | Yes | Global | No | |
| port-open-timeout | Yes | Yes | ||||
| preload_buffer_size | Yes | Yes | Yes | Both | Yes | |
| Prepared_stmt_count | Yes | Global | No | |||
| print-defaults | Yes | |||||
| profiling | Yes | Both | Yes | |||
| profiling_history_size | Yes | Yes | Yes | Both | Yes | |
| protocol_version | Yes | Global | No | |||
| proxy_user | Yes | Session | No | |||
| pseudo_slave_mode | Yes | Session | Yes | |||
| pseudo_thread_id | Yes | Session | Yes | |||
| Qcache_free_blocks | Yes | Global | No | |||
| Qcache_free_memory | Yes | Global | No | |||
| Qcache_hits | Yes | Global | No | |||
| Qcache_inserts | Yes | Global | No | |||
| Qcache_lowmem_prunes | Yes | Global | No | |||
| Qcache_not_cached | Yes | Global | No | |||
| Qcache_queries_in_cache | Yes | Global | No | |||
| Qcache_total_blocks | Yes | Global | No | |||
| Queries | Yes | Both | No | |||
| query_alloc_block_size | Yes | Yes | Yes | Both | Yes | |
| query_cache_limit | Yes | Yes | Yes | Global | Yes | |
| query_cache_min_res_unit | Yes | Yes | Yes | Global | Yes | |
| query_cache_size | Yes | Yes | Yes | Global | Yes | |
| query_cache_type | Yes | Yes | Yes | Both | Yes | |
| query_cache_wlock_invalidate | Yes | Yes | Yes | Both | Yes | |
| query_prealloc_size | Yes | Yes | Yes | Both | Yes | |
| Questions | Yes | Both | No | |||
| rand_seed1 | Yes | Session | Yes | |||
| rand_seed2 | Yes | Session | Yes | |||
| range_alloc_block_size | Yes | Yes | Yes | Both | Yes | |
| range_optimizer_max_mem_size | Yes | Yes | Yes | Both | Yes | |
| rbr_exec_mode | Yes | Session | Yes | |||
| read_buffer_size | Yes | Yes | Yes | Both | Yes | |
| read_only | Yes | Yes | Yes | Global | Yes | |
| read_rnd_buffer_size | Yes | Yes | Yes | Both | Yes | |
| relay_log | Yes | Yes | Yes | Global | No | |
| relay_log_basename | Yes | Global | No | |||
| relay_log_index | Yes | Yes | Yes | Global | No | |
| relay_log_info_file | Yes | Yes | Yes | Global | No | |
| relay_log_info_repository | Yes | Yes | Yes | Global | Yes | |
| relay_log_purge | Yes | Yes | Yes | Global | Yes | |
| relay_log_recovery | Yes | Yes | Yes | Global | No | |
| relay_log_space_limit | Yes | Yes | Yes | Global | No | |
| remove | Yes | |||||
| replicate-do-db | Yes | Yes | ||||
| replicate-do-table | Yes | Yes | ||||
| replicate-ignore-db | Yes | Yes | ||||
| replicate-ignore-table | Yes | Yes | ||||
| replicate-rewrite-db | Yes | Yes | ||||
| replicate-same-server-id | Yes | Yes | ||||
| replicate-wild-do-table | Yes | Yes | ||||
| replicate-wild-ignore-table | Yes | Yes | ||||
| replication_optimize_for_static_plugin_config | Yes | Yes | Yes | Global | Yes | |
| replication_sender_observe_commit_only | Yes | Yes | Yes | Global | Yes | |
| report_host | Yes | Yes | Yes | Global | No | |
| report_password | Yes | Yes | Yes | Global | No | |
| report_port | Yes | Yes | Yes | Global | No | |
| report_user | Yes | Yes | Yes | Global | No | |
| require_secure_transport | Yes | Yes | Yes | Global | Yes | |
| rewriter_enabled | Yes | Global | Yes | |||
| Rewriter_number_loaded_rules | Yes | Global | No | |||
| Rewriter_number_reloads | Yes | Global | No | |||
| Rewriter_number_rewritten_queries | Yes | Global | No | |||
| Rewriter_reload_error | Yes | Global | No | |||
| rewriter_verbose | Yes | Global | Yes | |||
| Rpl_semi_sync_master_clients | Yes | Global | No | |||
| rpl_semi_sync_master_enabled | Yes | Yes | Yes | Global | Yes | |
| Rpl_semi_sync_master_net_avg_wait_time | Yes | Global | No | |||
| Rpl_semi_sync_master_net_wait_time | Yes | Global | No | |||
| Rpl_semi_sync_master_net_waits | Yes | Global | No | |||
| Rpl_semi_sync_master_no_times | Yes | Global | No | |||
| Rpl_semi_sync_master_no_tx | Yes | Global | No | |||
| Rpl_semi_sync_master_status | Yes | Global | No | |||
| Rpl_semi_sync_master_timefunc_failures | Yes | Global | No | |||
| rpl_semi_sync_master_timeout | Yes | Yes | Yes | Global | Yes | |
| rpl_semi_sync_master_trace_level | Yes | Yes | Yes | Global | Yes | |
| Rpl_semi_sync_master_tx_avg_wait_time | Yes | Global | No | |||
| Rpl_semi_sync_master_tx_wait_time | Yes | Global | No | |||
| Rpl_semi_sync_master_tx_waits | Yes | Global | No | |||
| rpl_semi_sync_master_wait_for_slave_count | Yes | Yes | Yes | Global | Yes | |
| rpl_semi_sync_master_wait_no_slave | Yes | Yes | Yes | Global | Yes | |
| rpl_semi_sync_master_wait_point | Yes | Yes | Yes | Global | Yes | |
| Rpl_semi_sync_master_wait_pos_backtraverse | Yes | Global | No | |||
| Rpl_semi_sync_master_wait_sessions | Yes | Global | No | |||
| Rpl_semi_sync_master_yes_tx | Yes | Global | No | |||
| rpl_semi_sync_slave_enabled | Yes | Yes | Yes | Global | Yes | |
| Rpl_semi_sync_slave_status | Yes | Global | No | |||
| rpl_semi_sync_slave_trace_level | Yes | Yes | Yes | Global | Yes | |
| rpl_stop_slave_timeout | Yes | Yes | Yes | Global | Yes | |
| Rsa_public_key | Yes | Global | No | |||
| safe-user-create | Yes | Yes | ||||
| secure_auth | Yes | Yes | Yes | Global | Yes | |
| secure_file_priv | Yes | Yes | Yes | Global | No | |
| Select_full_join | Yes | Both | No | |||
| Select_full_range_join | Yes | Both | No | |||
| Select_range | Yes | Both | No | |||
| Select_range_check | Yes | Both | No | |||
| Select_scan | Yes | Both | No | |||
| server_id | Yes | Yes | Yes | Global | Yes | |
| server_id_bits | Yes | Yes | Yes | Global | No | |
| server_uuid | Yes | Global | No | |||
| session_track_gtids | Yes | Yes | Yes | Both | Yes | |
| session_track_schema | Yes | Yes | Yes | Both | Yes | |
| session_track_state_change | Yes | Yes | Yes | Both | Yes | |
| session_track_system_variables | Yes | Yes | Yes | Both | Yes | |
| session_track_transaction_info | Yes | Yes | Yes | Both | Yes | |
| sha256_password_auto_generate_rsa_keys | Yes | Yes | Yes | Global | No | |
| sha256_password_private_key_path | Yes | Yes | Yes | Global | No | |
| sha256_password_proxy_users | Yes | Yes | Yes | Global | Yes | |
| sha256_password_public_key_path | Yes | Yes | Yes | Global | No | |
| shared_memory | Yes | Yes | Yes | Global | No | |
| shared_memory_base_name | Yes | Yes | Yes | Global | No | |
| show_compatibility_56 | Yes | Yes | Yes | Global | Yes | |
| show_create_table_verbosity | Yes | Yes | Yes | Both | Yes | |
| show_old_temporals | Yes | Yes | Yes | Both | Yes | |
| show-slave-auth-info | Yes | Yes | ||||
| skip-character-set-client-handshake | Yes | Yes | ||||
| skip_external_locking | Yes | Yes | Yes | Global | No | |
| skip-grant-tables | Yes | Yes | ||||
| skip-host-cache | Yes | Yes | ||||
| skip_name_resolve | Yes | Yes | Yes | Global | No | |
| skip-ndbcluster | Yes | Yes | ||||
| skip_networking | Yes | Yes | Yes | Global | No | |
| skip-new | Yes | Yes | ||||
| skip-partition | Yes | Yes | ||||
| skip_show_database | Yes | Yes | Yes | Global | No | |
| skip_slave_start | Yes | Yes | Yes | Global | No | |
| skip-ssl | Yes | Yes | ||||
| skip-stack-trace | Yes | Yes | ||||
| slave_allow_batching | Yes | Yes | Yes | Global | Yes | |
| slave_checkpoint_group | Yes | Yes | Yes | Global | Yes | |
| slave_checkpoint_period | Yes | Yes | Yes | Global | Yes | |
| slave_compressed_protocol | Yes | Yes | Yes | Global | Yes | |
| slave_exec_mode | Yes | Yes | Yes | Global | Yes | |
| Slave_heartbeat_period | Yes | Global | No | |||
| Slave_last_heartbeat | Yes | Global | No | |||
| slave_load_tmpdir | Yes | Yes | Yes | Global | No | |
| slave_max_allowed_packet | Yes | Yes | Yes | Global | Yes | |
| slave_net_timeout | Yes | Yes | Yes | Global | Yes | |
| Slave_open_temp_tables | Yes | Global | No | |||
| slave_parallel_type | Yes | Yes | Yes | Global | Yes | |
| slave_parallel_workers | Yes | Yes | Yes | Global | Yes | |
| slave_pending_jobs_size_max | Yes | Yes | Yes | Global | Yes | |
| slave_preserve_commit_order | Yes | Yes | Yes | Global | Yes | |
| Slave_received_heartbeats | Yes | Global | No | |||
| Slave_retried_transactions | Yes | Global | No | |||
| Slave_rows_last_search_algorithm_used | Yes | Global | No | |||
| slave_rows_search_algorithms | Yes | Yes | Yes | Global | Yes | |
| Slave_running | Yes | Global | No | |||
| slave_skip_errors | Yes | Yes | Yes | Global | No | |
| slave-sql-verify-checksum | Yes | Yes | ||||
| slave_sql_verify_checksum | Yes | Yes | Yes | Global | Yes | |
| slave_transaction_retries | Yes | Yes | Yes | Global | Yes | |
| slave_type_conversions | Yes | Yes | Yes | Global | Yes | |
| Slow_launch_threads | Yes | Both | No | |||
| slow_launch_time | Yes | Yes | Yes | Global | Yes | |
| Slow_queries | Yes | Both | No | |||
| slow_query_log | Yes | Yes | Yes | Global | Yes | |
| slow_query_log_file | Yes | Yes | Yes | Global | Yes | |
| slow-start-timeout | Yes | Yes | ||||
| socket | Yes | Yes | Yes | Global | No | |
| sort_buffer_size | Yes | Yes | Yes | Both | Yes | |
| Sort_merge_passes | Yes | Both | No | |||
| Sort_range | Yes | Both | No | |||
| Sort_rows | Yes | Both | No | |||
| Sort_scan | Yes | Both | No | |||
| sporadic-binlog-dump-fail | Yes | Yes | ||||
| sql_auto_is_null | Yes | Both | Yes | |||
| sql_big_selects | Yes | Both | Yes | |||
| sql_buffer_result | Yes | Both | Yes | |||
| sql_log_bin | Yes | Session | Yes | |||
| sql_log_off | Yes | Both | Yes | |||
| sql_mode | Yes | Yes | Yes | Both | Yes | |
| sql_notes | Yes | Both | Yes | |||
| sql_quote_show_create | Yes | Both | Yes | |||
| sql_safe_updates | Yes | Both | Yes | |||
| sql_select_limit | Yes | Both | Yes | |||
| sql_slave_skip_counter | Yes | Global | Yes | |||
| sql_warnings | Yes | Both | Yes | |||
| ssl | Yes | Yes | ||||
| Ssl_accept_renegotiates | Yes | Global | No | |||
| Ssl_accepts | Yes | Global | No | |||
| ssl_ca | Yes | Yes | Yes | Global | No | |
| Ssl_callback_cache_hits | Yes | Global | No | |||
| ssl_capath | Yes | Yes | Yes | Global | No | |
| ssl_cert | Yes | Yes | Yes | Global | No | |
| Ssl_cipher | Yes | Both | No | |||
| ssl_cipher | Yes | Yes | Yes | Global | No | |
| Ssl_cipher_list | Yes | Both | No | |||
| Ssl_client_connects | Yes | Global | No | |||
| Ssl_connect_renegotiates | Yes | Global | No | |||
| ssl_crl | Yes | Yes | Yes | Global | No | |
| ssl_crlpath | Yes | Yes | Yes | Global | No | |
| Ssl_ctx_verify_depth | Yes | Global | No | |||
| Ssl_ctx_verify_mode | Yes | Global | No | |||
| Ssl_default_timeout | Yes | Both | No | |||
| Ssl_finished_accepts | Yes | Global | No | |||
| Ssl_finished_connects | Yes | Global | No | |||
| ssl_key | Yes | Yes | Yes | Global | No | |
| Ssl_server_not_after | Yes | Both | No | |||
| Ssl_server_not_before | Yes | Both | No | |||
| Ssl_session_cache_hits | Yes | Global | No | |||
| Ssl_session_cache_misses | Yes | Global | No | |||
| Ssl_session_cache_mode | Yes | Global | No | |||
| Ssl_session_cache_overflows | Yes | Global | No | |||
| Ssl_session_cache_size | Yes | Global | No | |||
| Ssl_session_cache_timeouts | Yes | Global | No | |||
| Ssl_sessions_reused | Yes | Session | No | |||
| Ssl_used_session_cache_entries | Yes | Global | No | |||
| Ssl_verify_depth | Yes | Both | No | |||
| Ssl_verify_mode | Yes | Both | No | |||
| Ssl_version | Yes | Both | No | |||
| standalone | Yes | Yes | ||||
| stored_program_cache | Yes | Yes | Yes | Global | Yes | |
| super-large-pages | Yes | Yes | ||||
| super_read_only | Yes | Yes | Yes | Global | Yes | |
| symbolic-links | Yes | Yes | ||||
| sync_binlog | Yes | Yes | Yes | Global | Yes | |
| sync_frm | Yes | Yes | Yes | Global | Yes | |
| sync_master_info | Yes | Yes | Yes | Global | Yes | |
| sync_relay_log | Yes | Yes | Yes | Global | Yes | |
| sync_relay_log_info | Yes | Yes | Yes | Global | Yes | |
| sysdate-is-now | Yes | Yes | ||||
| system_time_zone | Yes | Global | No | |||
| table_definition_cache | Yes | Yes | Yes | Global | Yes | |
| Table_locks_immediate | Yes | Global | No | |||
| Table_locks_waited | Yes | Global | No | |||
| table_open_cache | Yes | Yes | Yes | Global | Yes | |
| Table_open_cache_hits | Yes | Both | No | |||
| table_open_cache_instances | Yes | Yes | Yes | Global | No | |
| Table_open_cache_misses | Yes | Both | No | |||
| Table_open_cache_overflows | Yes | Both | No | |||
| tc-heuristic-recover | Yes | Yes | ||||
| Tc_log_max_pages_used | Yes | Global | No | |||
| Tc_log_page_size | Yes | Global | No | |||
| Tc_log_page_waits | Yes | Global | No | |||
| temp-pool | Yes | Yes | ||||
| thread_cache_size | Yes | Yes | Yes | Global | Yes | |
| thread_handling | Yes | Yes | Yes | Global | No | |
| thread_pool_algorithm | Yes | Yes | Yes | Global | No | |
| thread_pool_high_priority_connection | Yes | Yes | Yes | Both | Yes | |
| thread_pool_max_unused_threads | Yes | Yes | Yes | Global | Yes | |
| thread_pool_prio_kickup_timer | Yes | Yes | Yes | Global | Yes | |
| thread_pool_size | Yes | Yes | Yes | Global | No | |
| thread_pool_stall_limit | Yes | Yes | Yes | Global | Yes | |
| thread_stack | Yes | Yes | Yes | Global | No | |
| Threads_cached | Yes | Global | No | |||
| Threads_connected | Yes | Global | No | |||
| Threads_created | Yes | Global | No | |||
| Threads_running | Yes | Global | No | |||
| time_format | Yes | Global | No | |||
| time_zone | Yes | Both | Yes | |||
| timestamp | Yes | Session | Yes | |||
| tls_version | Yes | Yes | Yes | Global | No | |
| tmp_table_size | Yes | Yes | Yes | Both | Yes | |
| tmpdir | Yes | Yes | Yes | Global | No | |
| transaction_alloc_block_size | Yes | Yes | Yes | Both | Yes | |
| transaction_allow_batching | Yes | Session | Yes | |||
| transaction_isolation | Yes | Yes | Both | Yes | ||
| - Variable: tx_isolation | Yes | Both | Yes | |||
| transaction_prealloc_size | Yes | Yes | Yes | Both | Yes | |
| transaction_read_only | Yes | Yes | Both | Yes | ||
| - Variable: tx_read_only | Yes | Both | Yes | |||
| transaction_write_set_extraction | Yes | Yes | Yes | Both | Yes | |
| tx_isolation | Yes | Both | Yes | |||
| tx_read_only | Yes | Both | Yes | |||
| unique_checks | Yes | Both | Yes | |||
| updatable_views_with_limit | Yes | Yes | Yes | Both | Yes | |
| Uptime | Yes | Global | No | |||
| Uptime_since_flush_status | Yes | Global | No | |||
| user | Yes | Yes | ||||
| validate-password | Yes | Yes | ||||
| validate_password_check_user_name | Yes | Yes | Yes | Global | Yes | |
| validate_password_dictionary_file | Yes | Yes | Yes | Global | Varies | |
| validate_password_dictionary_file_last_parsed | Yes | Global | No | |||
| validate_password_dictionary_file_words_count | Yes | Global | No | |||
| validate_password_length | Yes | Yes | Yes | Global | Yes | |
| validate_password_mixed_case_count | Yes | Yes | Yes | Global | Yes | |
| validate_password_number_count | Yes | Yes | Yes | Global | Yes | |
| validate_password_policy | Yes | Yes | Yes | Global | Yes | |
| validate_password_special_char_count | Yes | Yes | Yes | Global | Yes | |
| validate-user-plugins | Yes | Yes | ||||
| verbose | Yes | Yes | ||||
| version | Yes | Global | No | |||
| version_comment | Yes | Global | No | |||
| version_compile_machine | Yes | Global | No | |||
| version_compile_os | Yes | Global | No | |||
| version_tokens_session | Yes | Yes | Yes | Both | Yes | |
| version_tokens_session_number | Yes | Yes | Yes | Both | No | |
| wait_timeout | Yes | Yes | Yes | Both | Yes | |
| warning_count | Yes | Session | No |
Notes:
1. This option is dynamic, but should be set only by server. You should not set this variable manually.
相关文章：
Mysql5.7服务器选项、系统变量和状态变量参考
官网地址：MySQL :: MySQL 5.7 Reference Manual :: 5.1.3 Server Option, System Variable, and Status Variable Reference 欢迎关注留言，我是收集整理小能手，工具翻译，仅供参考，笔芯笔芯. MySQL 5.7 参考手册 / ..…...
【Qt-Qss-Style】
Qt编程指南 ■ Qss■ Style■ setStyleSheet ■ style.qss■ border■ 去除弹框背景圆角■ QProgressBar样式表 ■ Qss Qt 支持很多种常见 符号 “>”代表直属子部件，说明两个控件之间是父子关系。 “#”代表后面的字段是前面控件类型的名称，当然也可…...
基于yolov8，制作停车位计数器(附源码)
大家好，YOLO(You Only Look Once) 是由Joseph Redmon和Ali开发的一种对象检测和图像分割模型。 YOLO的第一个版本于2015年发布，由于其高速度和准确性，瞬间得到了广大AI爱好者的喜爱。 Ultralytics YOLOv8则是一款前沿、最先进(SOTA)的模型&a…...
C++设计模式：单例模式（饿汉式、懒汉式）
单例模式是什么？ 单例模式是一种创建型的软件设计模式。通过单例模式的设计，使得创建的类在当前进程中只有唯一一个实例，并提供一个全局性的访问点，这样可以规避因频繁创建对象而导致的内存飙升情况。 单例模式有三个要点 私有化…...
Django 访问前端页面一直在转异常：ReferenceError:axios is not defined
访问：http://127.0.0.1:8080/ my.html 一、异常： 二、原因 提示：axios找不到！！ 查看代码<script src"https://unpkg.com/axios/dist/axios.min.js"></script>无法访问到官网 三、解决 Using j…...
C语言中关于指针的理解
#include <stdio.h> int main() {int a11;int *p&a; //因为a是整型的，所以我们定义指针p的时候要和a的类型一样char b;char *pa&b; //同理，b是字符型，所以这里的pa也要用字符型return 0; }因为*p指向的是地址&…...
MySQL MVCC精讲
版本链 我们前面说过，对于使用InnoDB存储引擎的表来说，它的聚簇索引记录中都包含两个必要的隐藏列（row_id并不是必要的，我们创建的表中有主键或者非NULL的UNIQUE键时都不会包含row_id列）： trx_idÿ…...
如何快速删除pdf周围的空白
问题：写论文往往需要pdf格式的图片，但pdf往往四周存在大量空白需要手动截图很麻烦 解决： 打开命令行输入：pdfcrop 图片名.pdf...
蓝桥杯c/c++程序设计——数位排序
数位排序【第十三届】【省赛】【C组】 题目描述 小蓝对一个数的数位之和很感兴趣，今天他要按照数位之和给数排序。 当两个数各个数位之和不同时，将数位和较小的排在前面，当数位之和相等时，将数值小的排在前面。 例如࿰…...
【通讯录案例-搭建登录界面 Objective-C语言】
一、来看我们这个通讯录案例 1.接下来啊，我们来做这个通讯录案例， 然后呢，做这么一个应用程序啊， 我们第一步呢，先把界面儿搭了， 然后呢，搭之前，简单的来分析一下， 首先呢，这是，中间儿的这一块儿， 1）有个“账户”、“密码”，这一块儿， 这是一个什么控制器，…...
二叉搜索树、AVL、红黑树、B树
文章目录 二叉搜索树2. avl树3. 红黑树 b树和b树比较适合与磁盘打交道的，磁盘操作耗时，这些树 矮，红黑树、avL树高，比较适合与内存打交道。 二叉搜索树 找一个节点的前驱和后继： 前驱：如果节点有左子树&a…...
格密码：傅里叶矩阵
目录 一. 铺垫性介绍 1.1 傅里叶级数 1.2 傅里叶矩阵的来源 二. 格基与傅里叶矩阵 2.1 傅里叶矩阵详细解释 2.2 格基与傅里叶矩阵 写在前面：有关傅里叶变换的解释太多了，这篇博客主要总结傅里叶矩阵在格密码中的运用。对于有一定傅里叶变换基础的同…...
flex--伸缩性
1.flex-basis flex-basis 设置的是主轴方向的基准长度，会让宽度或高度失效。 备注：主轴横向：宽度失效；主轴纵向：高度失效 作用：浏览器根据这个属性设置的值，计算主轴上是否有多余空间&#x…...
linux中主从复制的架构和读写分离的方式
读写分离 互相主从架构注意点 双主双从架构注意点 一主多从架构注意点 读写分离概念部署jdk环境上传文件，解压文件配置环境变量 部署mycat环境mycat配置文件给所有数据库创建访问用户配置 server.xml配置 schema.xml启动mycat查看启动端口日志负载均衡测试 遇到的问…...
Ubuntu 22.04.3 Server 设置静态IP 通过修改yaml配置文件方法
目录 1.查看网卡信息 2.修改yaml配置文件 3.应用新的网络配置 4.重新启动网络服务 文章内容 本文介绍Ubuntu 22.04.3 Server系统通过修改yaml配置文件配置静态 ip 的方法。 1.查看网卡信息 使用ifconfig命令查看网卡信息获取网卡名称 如果出现Command ifconfig not fo…...
EasyCVR无人机推流+人数统计AI算法，助力公共场所人群密度管控
一、背景与需求 在公共场所和大型活动的管理中，人数统计和人群密度控制是非常重要的安全问题。传统的方法可能存在效率低下或准确度不足的情况，无法满足现代社会的需求。TSINGSEE青犀可以利用无人机推流AI人流量统计算法，基于计算机视觉技术…...
Kotlin 接口
Kotlin 的接口可以既包含抽象方法的声明也包含实现；接口无法保存状态；可以有属性但必须声明为抽象或提供访问器实现 1、定义 使用关键字 interface 来定义接口 interface MyInterface {fun bar()fun foo() {// 可选的方法体} } 2、 实现接口 一个类…...
Qt前端技术：5.QSS
这个是表示QFrame中的pushButton中的子类和它子类的子类都将背景变为red 写成大于的时候表示只有直接的子类对象才会变 这个图中的QGroupBox和QPushButton都是QFrame的直接的子类 这个中的QGroupBox是QFrame的直接的子类但是QPushButton 是QGroupBox的子类，QPushB…...
在Centos7中利用Shell脚本：实现MySQL的数据备份
目录 自动化备份MySQL 一.备份数据库脚本 1.创建备份目录 2.创建脚本文件 3.新建配置文件（连接数据库的配置文件） 4.给文件权限(mysql_backup.sh) 编辑 5.执行命令 (mysql_backup.sh) 编辑 二.数据库通过备份恢复 1.创建脚…...
大一C语言查缺补漏 12.24
遗留问题： 6-1 1 在C语言中，如果要保留小数的话，一定要除以2.0，而不是2。 设整型变量m,n,a,b的值均为1，执行表达式（m a>b）||(n a<b)后，表达式的值以及变量m和n的值是&#…...
华为云AI开发平台ModelArts
华为云ModelArts：重塑AI开发流程的“智能引擎”与“创新加速器”！ 在人工智能浪潮席卷全球的2025年，企业拥抱AI的意愿空前高涨，但技术门槛高、流程复杂、资源投入巨大的现实，却让许多创新构想止步于实验室。数据科学家…...
rknn优化教程（二）
文章目录 1. 前述2. 三方库的封装2.1 xrepo中的库2.2 xrepo之外的库2.2.1 opencv2.2.2 rknnrt2.2.3 spdlog 3. rknn_engine库 1. 前述 OK，开始写第二篇的内容了。这篇博客主要能写一下： 如何给一些三方库按照xmake方式进行封装，供调用如何按…...
JavaScript 中的 ES|QL：利用 Apache Arrow 工具
作者：来自 Elastic Jeffrey Rengifo 学习如何将 ES|QL 与 JavaScript 的 Apache Arrow 客户端工具一起使用。 想获得 Elastic 认证吗？了解下一期 Elasticsearch Engineer 培训的时间吧！ Elasticsearch 拥有众多新功能，助你为自己…...
2021-03-15 iview一些问题
1.iview 在使用tree组件时，发现没有set类的方法，只有get，那么要改变tree值，只能遍历treeData，递归修改treeData的checked，发现无法更改，原因在于check模式下，子元素的勾选状态跟父节…...
)
GitHub 趋势日报 (2025年06月08日)
📊 由 TrendForge 系统生成 | 🌐 https://trendforge.devlive.org/ 🌐 本日报中的项目描述已自动翻译为中文 📈 今日获星趋势图 今日获星趋势图 884 cognee 566 dify 414 HumanSystemOptimization 414 omni-tools 321 note-gen …...
【Go语言基础【13】】函数、闭包、方法
文章目录 零、概述一、函数基础1、函数基础概念2、参数传递机制3、返回值特性3.1. 多返回值3.2. 命名返回值3.3. 错误处理 二、函数类型与高阶函数1. 函数类型定义2. 高阶函数（函数作为参数、返回值） 三、匿名函数与闭包1. 匿名函数（Lambda函…...
C语言中提供的第三方库之哈希表实现
一. 简介 前面一篇文章简单学习了C语言中第三方库（uthash库）提供对哈希表的操作，文章如下： C语言中提供的第三方库uthash常用接口-CSDN博客 本文简单学习一下第三方库 uthash库对哈希表的操作。 二. uthash库哈希表操作示例 u…...
解析奥地利 XARION激光超声检测系统：无膜光学麦克风 + 无耦合剂的技术协同优势及多元应用
在工业制造领域，无损检测（NDT)的精度与效率直接影响产品质量与生产安全。奥地利 XARION开发的激光超声精密检测系统，以非接触式光学麦克风技术为核心，打破传统检测瓶颈，为半导体、航空航天、汽车制造等行业提供了高灵敏…...
LLaMA-Factory 微调 Qwen2-VL 进行人脸情感识别（二）
在上一篇文章中，我们详细介绍了如何使用LLaMA-Factory框架对Qwen2-VL大模型进行微调，以实现人脸情感识别的功能。本篇文章将聚焦于微调完成后，如何调用这个模型进行人脸情感识别的具体代码实现，包括详细的步骤和注释。 模型调用步骤 环境准备：确保安装了必要的Python库。…...
五子棋测试用例
一.项目背景 1.1 项目简介 传统棋类文化的推广 五子棋是一种古老的棋类游戏，有着深厚的文化底蕴。通过将五子棋制作成网页游戏，可以让更多的人了解和接触到这一传统棋类文化。无论是国内还是国外的玩家，都可以通过网页五子棋感受到东方棋类…...