activate_all_roles_on_login |
Yes |
Yes |
Yes |
Global |
Yes |
admin_address |
Yes |
Yes |
Yes |
Global |
No |
admin_port |
Yes |
Yes |
Yes |
Global |
No |
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_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_include_accounts |
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_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_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_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_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_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_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_buffer_size |
Yes |
Yes |
Yes |
Global |
Yes |
clone_ddl_timeout |
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 |
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 |
date_format |
|
|
Yes |
Global |
No |
datetime_format |
|
|
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 |
- Variable: default_storage_engine |
|
|
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 |
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 |
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_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_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_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_poll_spin_loops |
Yes |
Yes |
Yes |
Global |
Yes |
group_replication_recovery_complete_at |
Yes |
Yes |
Yes |
Global |
Yes |
group_replication_recovery_compression_algorithm |
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_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_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 |
Global |
Yes |
gtid-mode |
Yes |
Yes |
|
|
Yes |
- Variable: gtid_mode |
|
|
Yes |
Global |
Yes |
gtid_mode |
|
|
Yes |
Global |
Yes |
gtid_next |
|
|
Yes |
Session |
Yes |
gtid_owned |
|
|
Yes |
Both |
No |
gtid_purged |
|
|
Yes |
Global |
Yes |
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 |
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 |
ignore-builtin-innodb |
Yes |
Yes |
Yes |
Global |
No |
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_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_log_crash_reset_debug |
Yes |
Yes |
Yes |
Global |
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_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_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_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 |
No |
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_scan_directories |
Yes |
Yes |
Yes |
Global |
No |
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_logs |
Yes |
Yes |
Yes |
Global |
Yes |
innodb_undo_tablespaces |
Yes |
Yes |
Yes |
Global |
Varies |
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 |
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_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 |
|
|
No |
- Variable: large_pages |
|
|
Yes |
Global |
No |
last_insert_id |
|
|
Yes |
Session |
Yes |
lc-messages |
Yes |
Yes |
|
|
Yes |
- Variable: lc_messages |
|
|
Yes |
Both |
Yes |
lc-messages-dir |
Yes |
Yes |
|
|
No |
- Variable: lc_messages_dir |
|
|
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 |
- Variable: log_bin_trust_function_creators |
|
|
Yes |
Global |
Yes |
log-bin-use-v1-row-events |
Yes |
Yes |
|
|
No |
- Variable: log_bin_use_v1_row_events |
|
|
Yes |
Global |
No |
log_bin_use_v1_row_events |
Yes |
Yes |
Yes |
Global |
No |
log_builtin_as_identified_by_password |
Yes |
Yes |
Yes |
Global |
Yes |
log-error |
Yes |
Yes |
|
|
No |
- Variable: log_error |
|
|
Yes |
Global |
No |
log_error_filter_rules |
Yes |
Yes |
Yes |
Global |
Yes |
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 |
- Variable: log_queries_not_using_indexes |
|
|
Yes |
Global |
Yes |
log-slave-updates |
Yes |
Yes |
|
|
No |
- Variable: log_slave_updates |
|
|
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_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 |
log-warnings |
Yes |
Yes |
|
|
Yes |
- Variable: log_warnings |
|
|
Yes |
Global |
Yes |
long_query_time |
Yes |
Yes |
Yes |
Both |
Yes |
low-priority-updates |
Yes |
Yes |
|
|
Yes |
- Variable: low_priority_updates |
|
|
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_tmp_tables |
|
|
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 |
- Variable: min_examined_row_limit |
|
|
Yes |
Both |
Yes |
multi_range_count |
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 |
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_connect_timeout |
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_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 |
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_autoincrement_prefetch_sz |
Yes |
Yes |
Yes |
Both |
Yes |
ndb-batch-size |
Yes |
Yes |
|
|
No |
- Variable: ndb_batch_size |
|
|
Yes |
Global |
No |
ndb-blob-read-batch-bytes |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_blob_read_batch_bytes |
|
|
Yes |
Both |
Yes |
ndb-blob-write-batch-bytes |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_blob_write_batch_bytes |
|
|
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_data_node_neighbour |
Yes |
Yes |
Yes |
Global |
Yes |
ndb-default-column-format |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_default_column_format |
|
|
Yes |
Global |
Yes |
ndb_default_column_format |
Yes |
Yes |
Yes |
Global |
Yes |
ndb-deferred-constraints |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_deferred_constraints |
|
|
Yes |
Both |
Yes |
ndb_deferred_constraints |
Yes |
Yes |
Yes |
Both |
Yes |
ndb-distribution |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_distribution |
|
|
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 |
|
|
No |
- Variable: ndb_log_apply_status |
|
|
Yes |
Global |
No |
ndb_log_apply_status |
Yes |
Yes |
Yes |
Global |
No |
ndb_log_bin |
Yes |
|
Yes |
Both |
Yes |
ndb_log_binlog_index |
Yes |
|
Yes |
Global |
Yes |
ndb-log-empty-epochs |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_log_empty_epochs |
|
|
Yes |
Global |
Yes |
ndb_log_empty_epochs |
Yes |
Yes |
Yes |
Global |
Yes |
ndb-log-empty-update |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_log_empty_update |
|
|
Yes |
Global |
Yes |
ndb_log_empty_update |
Yes |
Yes |
Yes |
Global |
Yes |
ndb-log-exclusive-reads |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_log_exclusive_reads |
|
|
Yes |
Both |
Yes |
ndb_log_exclusive_reads |
Yes |
Yes |
Yes |
Both |
Yes |
ndb-log-orig |
Yes |
Yes |
|
|
No |
- Variable: ndb_log_orig |
|
|
Yes |
Global |
No |
ndb_log_orig |
Yes |
Yes |
Yes |
Global |
No |
ndb-log-transaction-id |
Yes |
Yes |
|
|
No |
- Variable: ndb_log_transaction_id |
|
|
Yes |
Global |
No |
ndb_log_transaction_id |
|
|
Yes |
Global |
No |
ndb-log-update-as-write |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_log_update_as_write |
|
|
Yes |
Global |
Yes |
ndb-log-update-minimal |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_log_update_minimal |
|
|
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-optimization-delay |
Yes |
Yes |
|
|
Yes |
- Variable: ndb_optimization_delay |
|
|
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 |
Global |
Yes |
ndb_recv_thread_cpu_mask |
|
|
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-schema-dist-timeout |
Yes |
Yes |
|
|
No |
- Variable: ndb_schema_dist_timeout |
|
|
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 |
|
Yes |
Both |
Yes |
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 |
old_passwords |
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_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 |
|
|
No |
- Variable: pid_file |
|
|
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_slave_mode |
|
|
Yes |
Session |
Yes |
pseudo_thread_id |
|
|
Yes |
Session |
Yes |
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 |
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 |
Both |
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 |
|
|
No |
- Variable: relay_log |
|
|
Yes |
Global |
No |
relay_log_basename |
|
|
Yes |
Global |
No |
relay-log-index |
Yes |
Yes |
|
|
No |
- Variable: relay_log_index |
|
|
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 |
report-host |
Yes |
Yes |
|
|
No |
- Variable: report_host |
|
|
Yes |
Global |
No |
report-password |
Yes |
Yes |
|
|
No |
- Variable: report_password |
|
|
Yes |
Global |
No |
report-port |
Yes |
Yes |
|
|
No |
- Variable: report_port |
|
|
Yes |
Global |
No |
report-user |
Yes |
Yes |
|
|
No |
- Variable: report_user |
|
|
Yes |
Global |
No |
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_slave_enabled |
Yes |
Yes |
Yes |
Global |
Yes |
rpl_semi_sync_slave_trace_level |
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-auth |
Yes |
Yes |
|
|
Yes |
- Variable: secure_auth |
|
|
Yes |
Global |
Yes |
secure-file-priv |
Yes |
Yes |
|
|
No |
- Variable: secure_file_priv |
|
|
Yes |
Global |
No |
server-id |
Yes |
Yes |
|
|
Yes |
- Variable: server_id |
|
|
Yes |
Global |
Yes |
server-id-bits |
Yes |
Yes |
|
|
No |
- Variable: server_id_bits |
|
|
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 |
skip_external_locking |
Yes |
Yes |
Yes |
Global |
No |
skip-name-resolve |
Yes |
Yes |
|
|
No |
- Variable: skip_name_resolve |
|
|
Yes |
Global |
No |
skip-networking |
Yes |
Yes |
|
|
No |
- Variable: skip_networking |
|
|
Yes |
Global |
No |
skip-show-database |
Yes |
Yes |
|
|
No |
- Variable: skip_show_database |
|
|
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 |
|
|
No |
- Variable: slave_load_tmpdir |
|
|
Yes |
Global |
No |
slave_max_allowed_packet |
Yes |
Yes |
Yes |
Global |
Yes |
slave-net-timeout |
Yes |
Yes |
|
|
Yes |
- Variable: slave_net_timeout |
|
|
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 |
No |
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 |
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_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 |
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_ram |
Yes |
Yes |
Yes |
Global |
Yes |
temptable_use_mmap |
Yes |
Yes |
Yes |
Global |
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 |
Both |
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_format |
|
|
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 |
- Variable: transaction_isolation |
|
|
Yes |
Both |
Yes |
transaction_prealloc_size |
Yes |
Yes |
Yes |
Both |
Yes |
transaction-read-only |
Yes |
Yes |
|
|
Yes |
- Variable: transaction_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 |
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 |
validate_user_plugins |
Yes |
Yes |
Yes |
Global |
No |
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 |