The following table lists all system variables applicable within mysqld.
The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding option. The scope of the variable (Var Scope) is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the variables. Where appropriate, direct links to further information about the items are provided.
activate_all_roles_on_login
Yes |
Yes |
Yes |
Global |
Yes |
| admin_address |
Yes |
Yes |
Yes |
Global |
No |
|---|
| admin_port |
Yes |
Yes |
Yes |
Global |
No |
|---|
| admin_ssl_ca |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_ssl_capath |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_ssl_cert |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_ssl_cipher |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_ssl_crl |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_ssl_crlpath |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_ssl_key |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_tls_ciphersuites |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| admin_tls_version |
Yes |
Yes |
Yes |
Global |
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_disable |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| audit_log_encryption |
Yes |
Yes |
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_max_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| audit_log_password_history_keep_days |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| audit_log_policy |
Yes |
Yes |
Yes |
Global |
No |
|---|
| audit_log_prune_seconds |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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 |
|---|
| authentication_fido_rp_id |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| authentication_kerberos_service_key_tab |
Yes |
Yes |
Yes |
Global |
No |
|---|
| authentication_kerberos_service_principal |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_referral |
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_referral |
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_policy |
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_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_checksum |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_direct_non_transactional_updates |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| binlog_encryption |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_error_action |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_expire_logs_auto_purge |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_expire_logs_seconds |
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_max_flush_queue_time |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_order_commits |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_rotate_encryption_master_key_at_startup |
Yes |
Yes |
Yes |
Global |
No |
|---|
| binlog_row_event_max_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| binlog_row_image |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| binlog_row_metadata |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_row_value_options |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| binlog_rows_query_log_events |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| binlog_stmt_cache_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| binlog_transaction_compression |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| binlog_transaction_compression_level_zstd |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| 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 |
|---|
| bulk_insert_buffer_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| caching_sha2_password_auto_generate_rsa_keys |
Yes |
Yes |
Yes |
Global |
No |
|---|
| caching_sha2_password_digest_rounds |
Yes |
Yes |
Yes |
Global |
No |
|---|
| caching_sha2_password_private_key_path |
Yes |
Yes |
Yes |
Global |
No |
|---|
| caching_sha2_password_public_key_path |
Yes |
Yes |
Yes |
Global |
No |
|---|
| character_set_client |
|
|
Yes |
Both |
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 |
|---|
| clone_autotune_concurrency |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_block_ddl |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_buffer_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_ddl_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_donor_timeout_after_network_failure |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_enable_compression |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_max_concurrency |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_max_data_bandwidth |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_max_network_bandwidth |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_ssl_ca |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_ssl_cert |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_ssl_key |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| clone_valid_donor_list |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| collation_connection |
|
|
Yes |
Both |
Yes |
|---|
| collation_database (note 1) |
|
|
Yes |
Both |
Yes |
|---|
| collation_server |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| completion_type |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| concurrent_insert |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| connect_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_memory_chunk_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| connection_memory_limit |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| core_file |
|
|
Yes |
Global |
No |
|---|
| create_admin_listener_thread |
Yes |
Yes |
Yes |
Global |
No |
|---|
| cte_max_recursion_depth |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| 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 |
|---|
| datadir |
Yes |
Yes |
Yes |
Global |
No |
|---|
| debug |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| debug_sync |
|
|
Yes |
Session |
Yes |
|---|
| default_authentication_plugin |
Yes |
Yes |
Yes |
Global |
No |
|---|
| default_collation_for_utf8mb4 |
|
|
Yes |
Both |
Yes |
|---|
| default_password_lifetime |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| default_storage_engine |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| default_table_encryption |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| default_tmp_storage_engine |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| default_week_format |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| delay_key_write |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| delayed_insert_limit |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| delayed_insert_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| delayed_queue_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| disabled_storage_engines |
Yes |
Yes |
Yes |
Global |
No |
|---|
| disconnect_on_expired_password |
Yes |
Yes |
Yes |
Global |
No |
|---|
| div_precision_increment |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| dragnet.log_error_filter_rules |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| end_markers_in_json |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| enforce_gtid_consistency |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| eq_range_index_dive_limit |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| error_count |
|
|
Yes |
Session |
No |
|---|
| event_scheduler |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| expire_logs_days |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| explicit_defaults_for_timestamp |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| external_user |
|
|
Yes |
Session |
No |
|---|
| flush |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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 |
|---|
| general_log |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| general_log_file |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| generated_random_password_length |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| global_connection_memory_limit |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| global_connection_memory_tracking |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| group_concat_max_len |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| group_replication_advertise_recovery_endpoints |
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_autorejoin_tries |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_bootstrap_group |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_clone_threshold |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_communication_debug_options |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_communication_max_message_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_communication_stack |
|
|
Yes |
Global |
No |
|---|
| group_replication_components_stop_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_compression_threshold |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_consistency |
Yes |
Yes |
Yes |
Both |
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_hold_percent |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_flow_control_max_commit_quota |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_flow_control_member_quota_percent |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_flow_control_min_quota |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_flow_control_min_recovery_quota |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_flow_control_mode |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_flow_control_period |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_flow_control_release_percent |
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_allowlist |
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_expel_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_member_weight |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_message_cache_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_paxos_single_leader |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_poll_spin_loops |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_recovery_complete_at |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_recovery_compression_algorithms |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_recovery_get_public_key |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_recovery_public_key_path |
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_tls_ciphersuites |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_recovery_tls_version |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_recovery_use_ssl |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| group_replication_recovery_zstd_compression_level |
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_tls_source |
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 |
|---|
| group_replication_view_change_uuid |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| gtid_executed |
|
|
Yes |
Global |
No |
|---|
| gtid_executed_compression_period |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| gtid_mode |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| gtid_next |
|
|
Yes |
Session |
Yes |
|---|
| gtid_owned |
|
|
Yes |
Both |
No |
|---|
| gtid_purged |
|
|
Yes |
Global |
Yes |
|---|
| have_compress |
|
|
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 |
|---|
| histogram_generation_max_mem_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| host_cache_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| hostname |
|
|
Yes |
Global |
No |
|---|
| identity |
|
|
Yes |
Session |
Yes |
|---|
| immediate_server_version |
|
|
Yes |
Session |
Yes |
|---|
| information_schema_stats_expiry |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| init_connect |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| init_file |
Yes |
Yes |
Yes |
Global |
No |
|---|
| init_replica |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| init_slave |
Yes |
Yes |
Yes |
Global |
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_background_drop_list_empty |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_buffer_pool_chunk_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_buffer_pool_debug |
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_filename |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_buffer_pool_in_core_file |
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_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_checkpoint_disabled |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_checksum_algorithm |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_home_dir |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_ddl_buffer_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| innodb_ddl_log_crash_reset_debug |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_ddl_threads |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| innodb_deadlock_detect |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_dedicated_server |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_default_row_format |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_directories |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_disable_sort_file_cache |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_doublewrite |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_doublewrite_batch_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_doublewrite_dir |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_doublewrite_files |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_doublewrite_pages |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_extend_and_initialize |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_fast_shutdown |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_fil_make_page_dirty_debug |
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_fsync_threshold |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_idle_flush_pct |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_io_capacity |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_io_capacity_max |
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_log_buffer_size |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| innodb_log_checkpoint_fuzzy_now |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_spin_cpu_abs_lwm |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_log_spin_cpu_pct_hwm |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_log_wait_for_flush_spin_hwm |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_log_write_ahead_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_log_writer_threads |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_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 |
Varies |
|---|
| innodb_optimize_fulltext_only |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_page_cleaners |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_page_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_parallel_read_threads |
Yes |
Yes |
Yes |
Session |
Yes |
|---|
| innodb_print_all_deadlocks |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_print_ddl_logs |
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_redo_log_archive_dirs |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_redo_log_encrypt |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_saved_page_number_debug |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_segment_reserve_factor |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_sort_buffer_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_spin_wait_delay |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_spin_wait_pause_multiplier |
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_transient_sample_pages |
Yes |
Yes |
Yes |
Global |
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_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_temp_tablespaces_dir |
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_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_encrypt |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_undo_log_truncate |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_undo_tablespaces |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| innodb_use_fdatasync |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| innodb_use_native_aio |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_validate_tablespace_paths |
Yes |
Yes |
Yes |
Global |
No |
|---|
| innodb_version |
|
|
Yes |
Global |
No |
|---|
| innodb_write_io_threads |
Yes |
Yes |
Yes |
Global |
No |
|---|
| insert_id |
|
|
Yes |
Session |
Yes |
|---|
| interactive_timeout |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| internal_tmp_disk_storage_engine |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| internal_tmp_mem_storage_engine |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| join_buffer_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| keep_files_on_create |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| 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 |
|---|
| 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_hashicorp_auth_path |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| keyring_hashicorp_ca_path |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| keyring_hashicorp_caching |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| keyring_hashicorp_commit_auth_path |
|
|
Yes |
Global |
No |
|---|
| keyring_hashicorp_commit_ca_path |
|
|
Yes |
Global |
No |
|---|
| keyring_hashicorp_commit_caching |
|
|
Yes |
Global |
No |
|---|
| keyring_hashicorp_commit_role_id |
|
|
Yes |
Global |
No |
|---|
| keyring_hashicorp_commit_server_url |
|
|
Yes |
Global |
No |
|---|
| keyring_hashicorp_commit_store_path |
|
|
Yes |
Global |
No |
|---|
| keyring_hashicorp_role_id |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| keyring_hashicorp_secret_id |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| keyring_hashicorp_server_url |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| keyring_hashicorp_store_path |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| keyring_oci_ca_certificate |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_compartment |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_encryption_endpoint |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_key_file |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_key_fingerprint |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_management_endpoint |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_master_key |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_secrets_endpoint |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_tenancy |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_user |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_vaults_endpoint |
Yes |
Yes |
Yes |
Global |
No |
|---|
| keyring_oci_virtual_vault |
Yes |
Yes |
Yes |
Global |
No |
|---|
| 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 |
|---|
| 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 |
|---|
| lock_order |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_debug_loop |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_debug_missing_arc |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_debug_missing_key |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_debug_missing_unlock |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_dependencies |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_extra_dependencies |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_output_directory |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_print_txt |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_trace_loop |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_trace_missing_arc |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_trace_missing_key |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_order_trace_missing_unlock |
Yes |
Yes |
Yes |
Global |
No |
|---|
| lock_wait_timeout |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| locked_in_memory |
|
|
Yes |
Global |
No |
|---|
| 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_error |
Yes |
Yes |
Yes |
Global |
No |
|---|
| log_error_services |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_error_suppression_list |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_error_verbosity |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_output |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_queries_not_using_indexes |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_raw |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_replica_updates |
Yes |
Yes |
Yes |
Global |
No |
|---|
| log_slave_updates |
Yes |
Yes |
Yes |
Global |
No |
|---|
| log_slow_admin_statements |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_slow_extra |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_slow_replica_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_throttle_queries_not_using_indexes |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| log_timestamps |
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 |
|---|
| mandatory_roles |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| master_info_repository |
Yes |
Yes |
Yes |
Global |
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_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_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_user_connections |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| max_write_lock_count |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mecab_rc_file |
Yes |
Yes |
Yes |
Global |
No |
|---|
| 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 |
|---|
| 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_bind_address |
Yes |
Yes |
Yes |
Global |
No |
|---|
| mysqlx_compression_algorithms |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_connect_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_deflate_default_compression_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_deflate_max_client_compression_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_document_id_unique_prefix |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_enable_hello_notice |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_idle_worker_thread_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_interactive_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_lz4_default_compression_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_lz4_max_client_compression_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_port |
Yes |
Yes |
Yes |
Global |
No |
|---|
| mysqlx_port_open_timeout |
Yes |
Yes |
Yes |
Global |
No |
|---|
| mysqlx_read_timeout |
Yes |
Yes |
Yes |
Session |
Yes |
|---|
| mysqlx_socket |
Yes |
Yes |
Yes |
Global |
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 |
Yes |
Yes |
Global |
No |
|---|
| mysqlx_ssl_crl |
Yes |
Yes |
Yes |
Global |
No |
|---|
| mysqlx_ssl_crlpath |
Yes |
Yes |
Yes |
Global |
No |
|---|
| mysqlx_ssl_key |
Yes |
Yes |
Yes |
Global |
No |
|---|
| mysqlx_wait_timeout |
Yes |
Yes |
Yes |
Session |
Yes |
|---|
| mysqlx_write_timeout |
Yes |
Yes |
Yes |
Session |
Yes |
|---|
| mysqlx_zstd_default_compression_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| mysqlx_zstd_max_client_compression_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_applier_allow_skip_epoch |
Yes |
Yes |
Yes |
Global |
No |
|---|
| ndb_autoincrement_prefetch_sz |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| ndb_batch_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| 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_conflict_last_conflict_epoch |
|
|
Yes |
Global |
No |
|---|
| ndb_conflict_role |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ndb_data_node_neighbour |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ndb_dbg_check_shares |
Yes |
Yes |
Yes |
Both |
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_eventbuffer_free_percent |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ndb_eventbuffer_max_alloc |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_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_metadata_check |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ndb_metadata_check_interval |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ndb_metadata_sync |
|
|
Yes |
Global |
Yes |
|---|
| ndb_optimization_delay |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ndb_optimized_node_selection |
Yes |
Yes |
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_replica_max_replicated_epoch |
|
|
Yes |
Global |
No |
|---|
| 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_schema_dist_lock_wait_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ndb_schema_dist_timeout |
Yes |
Yes |
Yes |
Global |
No |
|---|
| ndb_schema_dist_timeout |
Yes |
Yes |
Yes |
Global |
No |
|---|
| ndb_schema_dist_upgrade_allowed |
Yes |
Yes |
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_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 |
|---|
| 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 |
|---|
| offline_mode |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| old |
Yes |
Yes |
Yes |
Global |
No |
|---|
| old_alter_table |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| open_files_limit |
Yes |
Yes |
Yes |
Global |
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 |
|---|
| original_commit_timestamp |
|
|
Yes |
Session |
Yes |
|---|
| original_server_version |
|
|
Yes |
Session |
Yes |
|---|
| parser_max_mem_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| partial_revokes |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| password_history |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| password_require_current |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| password_reuse_interval |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| performance_schema |
Yes |
Yes |
Yes |
Global |
No |
|---|
| performance_schema_accounts_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| performance_schema_digests_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| performance_schema_error_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_hosts_size |
Yes |
Yes |
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_digest_sample_age |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_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_users_size |
Yes |
Yes |
Yes |
Global |
No |
|---|
| persist_only_admin_x509_subject |
Yes |
Yes |
Yes |
Global |
No |
|---|
| persisted_globals_load |
Yes |
Yes |
Yes |
Global |
No |
|---|
| pid_file |
Yes |
Yes |
Yes |
Global |
No |
|---|
| plugin_dir |
Yes |
Yes |
Yes |
Global |
No |
|---|
| plugin_load |
Yes |
Yes |
Yes |
Global |
No |
|---|
| plugin_load_add |
Yes |
Yes |
Yes |
Global |
No |
|---|
| port |
Yes |
Yes |
Yes |
Global |
No |
|---|
| preload_buffer_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| print_identified_with_as_hex |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| profiling |
|
|
Yes |
Both |
Yes |
|---|
| profiling_history_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| protocol_compression_algorithms |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| protocol_version |
|
|
Yes |
Global |
No |
|---|
| proxy_user |
|
|
Yes |
Session |
No |
|---|
| pseudo_replica_mode |
|
|
Yes |
Session |
Yes |
|---|
| pseudo_slave_mode |
|
|
Yes |
Session |
Yes |
|---|
| pseudo_thread_id |
|
|
Yes |
Session |
Yes |
|---|
| query_alloc_block_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| query_prealloc_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| 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 |
|---|
| regexp_stack_limit |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| regexp_time_limit |
Yes |
Yes |
Yes |
Global |
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 |
|---|
| replica_allow_batching |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_checkpoint_group |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_checkpoint_period |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_compressed_protocol |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_exec_mode |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_load_tmpdir |
Yes |
Yes |
Yes |
Global |
No |
|---|
| replica_max_allowed_packet |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_net_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_parallel_type |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_parallel_workers |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_pending_jobs_size_max |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_preserve_commit_order |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_skip_errors |
Yes |
Yes |
Yes |
Global |
No |
|---|
| replica_sql_verify_checksum |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_transaction_retries |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| replica_type_conversions |
Yes |
Yes |
Yes |
Global |
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_row_format |
|
|
Yes |
Session |
Yes |
|---|
| require_secure_transport |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| resultset_metadata |
|
|
Yes |
Session |
Yes |
|---|
| rewriter_enabled |
|
|
Yes |
Global |
Yes |
|---|
| rewriter_verbose |
|
|
Yes |
Global |
Yes |
|---|
| rpl_read_size |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_master_enabled |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_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_replica_enabled |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_replica_trace_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_slave_enabled |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_slave_trace_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_source_enabled |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_source_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_source_trace_level |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_source_wait_for_replica_count |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_source_wait_no_replica |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_semi_sync_source_wait_point |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_stop_replica_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| rpl_stop_slave_timeout |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| schema_definition_cache |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| secondary_engine_cost_threshold |
|
|
Yes |
Session |
Yes |
|---|
| secure_file_priv |
Yes |
Yes |
Yes |
Global |
No |
|---|
| select_into_buffer_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| select_into_disk_sync |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| select_into_disk_sync_delay |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| 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_create_table_skip_secondary_engine |
Yes |
Yes |
Yes |
Session |
Yes |
|---|
| show_create_table_verbosity |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| show_old_temporals |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| skip_external_locking |
Yes |
Yes |
Yes |
Global |
No |
|---|
| skip_name_resolve |
Yes |
Yes |
Yes |
Global |
No |
|---|
| skip_networking |
Yes |
Yes |
Yes |
Global |
No |
|---|
| skip_replica_start |
Yes |
Yes |
Yes |
Global |
No |
|---|
| skip_show_database |
Yes |
Yes |
Yes |
Global |
No |
|---|
| skip_slave_start |
Yes |
Yes |
Yes |
Global |
No |
|---|
| 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_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_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_rows_search_algorithms |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| slave_skip_errors |
Yes |
Yes |
Yes |
Global |
No |
|---|
| 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_time |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| slow_query_log |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| slow_query_log_file |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| socket |
Yes |
Yes |
Yes |
Global |
No |
|---|
| sort_buffer_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| source_verify_checksum |
Yes |
Yes |
Yes |
Global |
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_replica_skip_counter |
|
|
Yes |
Global |
Yes |
|---|
| sql_require_primary_key |
Yes |
Yes |
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_ca |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| ssl_capath |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| ssl_cert |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| ssl_cipher |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| ssl_crl |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| ssl_crlpath |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| ssl_fips_mode |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| ssl_key |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| stored_program_cache |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| stored_program_definition_cache |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| super_read_only |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| sync_binlog |
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 |
|---|
| sync_source_info |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| syseventlog.facility |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| syseventlog.include_pid |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| syseventlog.tag |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| system_time_zone |
|
|
Yes |
Global |
No |
|---|
| table_definition_cache |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| table_encryption_privilege_check |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| table_open_cache |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| table_open_cache_instances |
Yes |
Yes |
Yes |
Global |
No |
|---|
| tablespace_definition_cache |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| temptable_max_mmap |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| temptable_max_ram |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| temptable_use_mmap |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| terminology_use_previous |
Yes |
Yes |
Yes |
Both |
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_active_query_threads |
Yes |
Yes |
Yes |
Global |
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 |
|---|
| time_zone |
|
|
Yes |
Both |
Yes |
|---|
| timestamp |
|
|
Yes |
Session |
Yes |
|---|
| tls_ciphersuites |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| tls_version |
Yes |
Yes |
Yes |
Global |
Varies |
|---|
| 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 |
Yes |
Both |
Yes |
|---|
| transaction_prealloc_size |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| transaction_read_only |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| transaction_write_set_extraction |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| unique_checks |
|
|
Yes |
Both |
Yes |
|---|
| updatable_views_with_limit |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| use_secondary_engine |
|
|
Yes |
Session |
Yes |
|---|
| validate_password_check_user_name |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| validate_password_dictionary_file |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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_password.check_user_name |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| validate_password.dictionary_file |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| 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 |
|---|
| version |
|
|
Yes |
Global |
No |
|---|
| version_comment |
|
|
Yes |
Global |
No |
|---|
| version_compile_machine |
|
|
Yes |
Global |
No |
|---|
| version_compile_os |
|
|
Yes |
Global |
No |
|---|
| version_compile_zlib |
|
|
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 |
|---|
| windowing_use_high_precision |
Yes |
Yes |
Yes |
Both |
Yes |
|---|
| xa_detach_on_prepare |
Yes |
Yes |
Yes |
Global |
Yes |
|---|
| Name | Cmd-Line | Option File | System Var | Var Scope | Dynamic |
|---|
Notes:
1. This option is dynamic, but should be set only by server. You should not set this variable manually.