abort-slave-event-count |
Yes |
Yes |
|
|
|
|
Aborted_clients |
|
|
|
Yes |
Global |
No |
Aborted_connects |
|
|
|
Yes |
Global |
No |
Acl_cache_items_count |
|
|
|
Yes |
Global |
No |
activate_all_roles_on_login |
Yes |
Yes |
Yes |
|
Global |
Yes |
admin_address |
Yes |
Yes |
Yes |
|
Global |
No |
admin_port |
Yes |
Yes |
Yes |
|
Global |
No |
allow-suspicious-udfs |
Yes |
Yes |
|
|
|
|
ansi |
Yes |
Yes |
|
|
|
|
audit-log |
Yes |
Yes |
|
|
|
|
audit_log_buffer_size |
Yes |
Yes |
Yes |
|
Global |
No |
audit_log_compression |
Yes |
Yes |
Yes |
|
Global |
No |
audit_log_connection_policy |
Yes |
Yes |
Yes |
|
Global |
Yes |
audit_log_current_session |
|
|
Yes |
|
Both |
No |
Audit_log_current_size |
|
|
|
Yes |
Global |
No |
audit_log_encryption |
Yes |
Yes |
Yes |
|
Global |
No |
Audit_log_event_max_drop_size |
|
|
|
Yes |
Global |
No |
Audit_log_events |
|
|
|
Yes |
Global |
No |
Audit_log_events_filtered |
|
|
|
Yes |
Global |
No |
Audit_log_events_lost |
|
|
|
Yes |
Global |
No |
Audit_log_events_written |
|
|
|
Yes |
Global |
No |
audit_log_exclude_accounts |
Yes |
Yes |
Yes |
|
Global |
Yes |
audit_log_file |
Yes |
Yes |
Yes |
|
Global |
No |
audit_log_filter_id |
|
|
Yes |
|
Both |
No |
audit_log_flush |
|
|
Yes |
|
Global |
Yes |
audit_log_format |
Yes |
Yes |
Yes |
|
Global |
No |
audit_log_include_accounts |
Yes |
Yes |
Yes |
|
Global |
Yes |
audit_log_policy |
Yes |
Yes |
Yes |
|
Global |
No |
audit_log_read_buffer_size |
Yes |
Yes |
Yes |
|
Varies |
Varies |
audit_log_rotate_on_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
audit_log_statement_policy |
Yes |
Yes |
Yes |
|
Global |
Yes |
audit_log_strategy |
Yes |
Yes |
Yes |
|
Global |
No |
Audit_log_total_size |
|
|
|
Yes |
Global |
No |
Audit_log_write_waits |
|
|
|
Yes |
Global |
No |
authentication_ldap_sasl_auth_method_name |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_bind_base_dn |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_bind_root_dn |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_bind_root_pwd |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_ca_path |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_group_search_attr |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_group_search_filter |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_init_pool_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_log_status |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_max_pool_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_server_host |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_server_port |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_tls |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_sasl_user_search_attr |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_auth_method_name |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_bind_base_dn |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_bind_root_dn |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_bind_root_pwd |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_ca_path |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_group_search_attr |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_group_search_filter |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_init_pool_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_log_status |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_max_pool_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_server_host |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_server_port |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_tls |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_ldap_simple_user_search_attr |
Yes |
Yes |
Yes |
|
Global |
Yes |
authentication_windows_log_level |
Yes |
Yes |
Yes |
|
Global |
No |
authentication_windows_use_principal_name |
Yes |
Yes |
Yes |
|
Global |
No |
auto_generate_certs |
Yes |
Yes |
Yes |
|
Global |
No |
auto_increment_increment |
|
|
Yes |
|
Both |
Yes |
auto_increment_offset |
|
|
Yes |
|
Both |
Yes |
autocommit |
Yes |
Yes |
Yes |
|
Both |
Yes |
automatic_sp_privileges |
|
|
Yes |
|
Global |
Yes |
avoid_temporal_upgrade |
Yes |
Yes |
Yes |
|
Global |
Yes |
back_log |
|
|
Yes |
|
Global |
No |
basedir |
Yes |
Yes |
Yes |
|
Global |
No |
big-tables |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: big_tables |
|
|
Yes |
|
Both |
Yes |
bind-address |
Yes |
Yes |
|
|
Global |
No |
- Variable: bind_address |
|
|
Yes |
|
Global |
No |
Binlog_cache_disk_use |
|
|
|
Yes |
Global |
No |
binlog_cache_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
Binlog_cache_use |
|
|
|
Yes |
Global |
No |
binlog-checksum |
Yes |
Yes |
|
|
|
|
binlog_checksum |
|
|
Yes |
|
Global |
Yes |
binlog_direct_non_transactional_updates |
Yes |
Yes |
Yes |
|
Both |
Yes |
binlog-do-db |
Yes |
Yes |
|
|
|
|
binlog_encryption |
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 |
|
|
Both |
Yes |
- Variable: binlog_format |
|
|
Yes |
|
Both |
Yes |
binlog_group_commit_sync_delay |
Yes |
Yes |
Yes |
|
Global |
Yes |
binlog_group_commit_sync_no_delay_count |
Yes |
Yes |
Yes |
|
Global |
Yes |
binlog_gtid_simple_recovery |
Yes |
Yes |
Yes |
|
Global |
No |
binlog-ignore-db |
Yes |
Yes |
|
|
|
|
binlog_max_flush_queue_time |
|
|
Yes |
|
Global |
Yes |
binlog_order_commits |
|
|
Yes |
|
Global |
Yes |
binlog_rotate_encryption_master_key_at_startup |
Yes |
|
Yes |
|
Global |
No |
binlog-row-event-max-size |
Yes |
Yes |
|
|
|
|
- Variable: binlog_row_event_max_size |
|
|
|
|
|
|
binlog_row_event_max_size |
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 |
|
|
|
|
- Variable: binlog_rows_query_log_events |
|
|
|
|
|
|
binlog_rows_query_log_events |
Yes |
Yes |
Yes |
|
Both |
Yes |
Binlog_stmt_cache_disk_use |
|
|
|
Yes |
Global |
No |
binlog_stmt_cache_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
Binlog_stmt_cache_use |
|
|
|
Yes |
Global |
No |
binlog_transaction_dependency_history_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
binlog_transaction_dependency_tracking |
Yes |
Yes |
Yes |
|
Global |
Yes |
block_encryption_mode |
Yes |
Yes |
Yes |
|
Both |
Yes |
bulk_insert_buffer_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
Bytes_received |
|
|
|
Yes |
Both |
No |
Bytes_sent |
|
|
|
Yes |
Both |
No |
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 |
Caching_sha2_password_rsa_public_key |
|
|
|
Yes |
Global |
No |
character_set_client |
|
|
Yes |
|
Both |
Yes |
character-set-client-handshake |
Yes |
Yes |
|
|
|
|
character_set_connection |
|
|
Yes |
|
Both |
Yes |
character_set_database (note 1) |
|
|
Yes |
|
Both |
Yes |
character-set-filesystem |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: character_set_filesystem |
|
|
Yes |
|
Both |
Yes |
character_set_results |
|
|
Yes |
|
Both |
Yes |
character-set-server |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: character_set_server |
|
|
Yes |
|
Both |
Yes |
character_set_system |
|
|
Yes |
|
Global |
No |
character-sets-dir |
Yes |
Yes |
|
|
Global |
No |
- Variable: character_sets_dir |
|
|
Yes |
|
Global |
No |
check_proxy_users |
Yes |
Yes |
Yes |
|
Global |
Yes |
chroot |
Yes |
Yes |
|
|
|
|
collation_connection |
|
|
Yes |
|
Both |
Yes |
collation_database (note 1) |
|
|
Yes |
|
Both |
Yes |
collation-server |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: collation_server |
|
|
Yes |
|
Both |
Yes |
Com_admin_commands |
|
|
|
Yes |
Both |
No |
Com_alter_db |
|
|
|
Yes |
Both |
No |
Com_alter_event |
|
|
|
Yes |
Both |
No |
Com_alter_function |
|
|
|
Yes |
Both |
No |
Com_alter_procedure |
|
|
|
Yes |
Both |
No |
Com_alter_resource_group |
|
|
|
Yes |
Global |
No |
Com_alter_server |
|
|
|
Yes |
Both |
No |
Com_alter_table |
|
|
|
Yes |
Both |
No |
Com_alter_tablespace |
|
|
|
Yes |
Both |
No |
Com_alter_user |
|
|
|
Yes |
Both |
No |
Com_alter_user_default_role |
|
|
|
Yes |
Global |
No |
Com_analyze |
|
|
|
Yes |
Both |
No |
Com_assign_to_keycache |
|
|
|
Yes |
Both |
No |
Com_begin |
|
|
|
Yes |
Both |
No |
Com_binlog |
|
|
|
Yes |
Both |
No |
Com_call_procedure |
|
|
|
Yes |
Both |
No |
Com_change_db |
|
|
|
Yes |
Both |
No |
Com_change_master |
|
|
|
Yes |
Both |
No |
Com_change_repl_filter |
|
|
|
Yes |
Both |
No |
Com_check |
|
|
|
Yes |
Both |
No |
Com_checksum |
|
|
|
Yes |
Both |
No |
Com_commit |
|
|
|
Yes |
Both |
No |
Com_create_db |
|
|
|
Yes |
Both |
No |
Com_create_event |
|
|
|
Yes |
Both |
No |
Com_create_function |
|
|
|
Yes |
Both |
No |
Com_create_index |
|
|
|
Yes |
Both |
No |
Com_create_procedure |
|
|
|
Yes |
Both |
No |
Com_create_resource_group |
|
|
|
Yes |
Global |
No |
Com_create_role |
|
|
|
Yes |
Global |
No |
Com_create_server |
|
|
|
Yes |
Both |
No |
Com_create_table |
|
|
|
Yes |
Both |
No |
Com_create_trigger |
|
|
|
Yes |
Both |
No |
Com_create_udf |
|
|
|
Yes |
Both |
No |
Com_create_user |
|
|
|
Yes |
Both |
No |
Com_create_view |
|
|
|
Yes |
Both |
No |
Com_dealloc_sql |
|
|
|
Yes |
Both |
No |
Com_delete |
|
|
|
Yes |
Both |
No |
Com_delete_multi |
|
|
|
Yes |
Both |
No |
Com_do |
|
|
|
Yes |
Both |
No |
Com_drop_db |
|
|
|
Yes |
Both |
No |
Com_drop_event |
|
|
|
Yes |
Both |
No |
Com_drop_function |
|
|
|
Yes |
Both |
No |
Com_drop_index |
|
|
|
Yes |
Both |
No |
Com_drop_procedure |
|
|
|
Yes |
Both |
No |
Com_drop_resource_group |
|
|
|
Yes |
Global |
No |
Com_drop_role |
|
|
|
Yes |
Global |
No |
Com_drop_server |
|
|
|
Yes |
Both |
No |
Com_drop_table |
|
|
|
Yes |
Both |
No |
Com_drop_trigger |
|
|
|
Yes |
Both |
No |
Com_drop_user |
|
|
|
Yes |
Both |
No |
Com_drop_view |
|
|
|
Yes |
Both |
No |
Com_empty_query |
|
|
|
Yes |
Both |
No |
Com_execute_sql |
|
|
|
Yes |
Both |
No |
Com_explain_other |
|
|
|
Yes |
Both |
No |
Com_flush |
|
|
|
Yes |
Both |
No |
Com_get_diagnostics |
|
|
|
Yes |
Both |
No |
Com_grant |
|
|
|
Yes |
Both |
No |
Com_grant_roles |
|
|
|
Yes |
Global |
No |
Com_group_replication_start |
|
|
|
Yes |
Global |
No |
Com_group_replication_stop |
|
|
|
Yes |
Global |
No |
Com_ha_close |
|
|
|
Yes |
Both |
No |
Com_ha_open |
|
|
|
Yes |
Both |
No |
Com_ha_read |
|
|
|
Yes |
Both |
No |
Com_help |
|
|
|
Yes |
Both |
No |
Com_insert |
|
|
|
Yes |
Both |
No |
Com_insert_select |
|
|
|
Yes |
Both |
No |
Com_install_component |
|
|
|
Yes |
Global |
No |
Com_install_plugin |
|
|
|
Yes |
Both |
No |
Com_kill |
|
|
|
Yes |
Both |
No |
Com_load |
|
|
|
Yes |
Both |
No |
Com_lock_tables |
|
|
|
Yes |
Both |
No |
Com_optimize |
|
|
|
Yes |
Both |
No |
Com_preload_keys |
|
|
|
Yes |
Both |
No |
Com_prepare_sql |
|
|
|
Yes |
Both |
No |
Com_purge |
|
|
|
Yes |
Both |
No |
Com_purge_before_date |
|
|
|
Yes |
Both |
No |
Com_release_savepoint |
|
|
|
Yes |
Both |
No |
Com_rename_table |
|
|
|
Yes |
Both |
No |
Com_rename_user |
|
|
|
Yes |
Both |
No |
Com_repair |
|
|
|
Yes |
Both |
No |
Com_replace |
|
|
|
Yes |
Both |
No |
Com_replace_select |
|
|
|
Yes |
Both |
No |
Com_reset |
|
|
|
Yes |
Both |
No |
Com_resignal |
|
|
|
Yes |
Both |
No |
Com_revoke |
|
|
|
Yes |
Both |
No |
Com_revoke_all |
|
|
|
Yes |
Both |
No |
Com_revoke_roles |
|
|
|
Yes |
Global |
No |
Com_rollback |
|
|
|
Yes |
Both |
No |
Com_rollback_to_savepoint |
|
|
|
Yes |
Both |
No |
Com_savepoint |
|
|
|
Yes |
Both |
No |
Com_select |
|
|
|
Yes |
Both |
No |
Com_set_option |
|
|
|
Yes |
Both |
No |
Com_set_resource_group |
|
|
|
Yes |
Global |
No |
Com_set_role |
|
|
|
Yes |
Global |
No |
Com_show_authors |
|
|
|
Yes |
Both |
No |
Com_show_binlog_events |
|
|
|
Yes |
Both |
No |
Com_show_binlogs |
|
|
|
Yes |
Both |
No |
Com_show_charsets |
|
|
|
Yes |
Both |
No |
Com_show_collations |
|
|
|
Yes |
Both |
No |
Com_show_contributors |
|
|
|
Yes |
Both |
No |
Com_show_create_db |
|
|
|
Yes |
Both |
No |
Com_show_create_event |
|
|
|
Yes |
Both |
No |
Com_show_create_func |
|
|
|
Yes |
Both |
No |
Com_show_create_proc |
|
|
|
Yes |
Both |
No |
Com_show_create_table |
|
|
|
Yes |
Both |
No |
Com_show_create_trigger |
|
|
|
Yes |
Both |
No |
Com_show_create_user |
|
|
|
Yes |
Both |
No |
Com_show_databases |
|
|
|
Yes |
Both |
No |
Com_show_engine_logs |
|
|
|
Yes |
Both |
No |
Com_show_engine_mutex |
|
|
|
Yes |
Both |
No |
Com_show_engine_status |
|
|
|
Yes |
Both |
No |
Com_show_errors |
|
|
|
Yes |
Both |
No |
Com_show_events |
|
|
|
Yes |
Both |
No |
Com_show_fields |
|
|
|
Yes |
Both |
No |
Com_show_function_code |
|
|
|
Yes |
Both |
No |
Com_show_function_status |
|
|
|
Yes |
Both |
No |
Com_show_grants |
|
|
|
Yes |
Both |
No |
Com_show_keys |
|
|
|
Yes |
Both |
No |
Com_show_master_status |
|
|
|
Yes |
Both |
No |
Com_show_ndb_status |
|
|
|
Yes |
Both |
No |
Com_show_new_master |
|
|
|
Yes |
Both |
No |
Com_show_open_tables |
|
|
|
Yes |
Both |
No |
Com_show_plugins |
|
|
|
Yes |
Both |
No |
Com_show_privileges |
|
|
|
Yes |
Both |
No |
Com_show_procedure_code |
|
|
|
Yes |
Both |
No |
Com_show_procedure_status |
|
|
|
Yes |
Both |
No |
Com_show_processlist |
|
|
|
Yes |
Both |
No |
Com_show_profile |
|
|
|
Yes |
Both |
No |
Com_show_profiles |
|
|
|
Yes |
Both |
No |
Com_show_relaylog_events |
|
|
|
Yes |
Both |
No |
Com_show_slave_hosts |
|
|
|
Yes |
Both |
No |
Com_show_slave_status |
|
|
|
Yes |
Both |
No |
Com_show_slave_status_nonblocking |
|
|
|
Yes |
Both |
No |
Com_show_status |
|
|
|
Yes |
Both |
No |
Com_show_storage_engines |
|
|
|
Yes |
Both |
No |
Com_show_table_status |
|
|
|
Yes |
Both |
No |
Com_show_tables |
|
|
|
Yes |
Both |
No |
Com_show_triggers |
|
|
|
Yes |
Both |
No |
Com_show_variables |
|
|
|
Yes |
Both |
No |
Com_show_warnings |
|
|
|
Yes |
Both |
No |
Com_shutdown |
|
|
|
Yes |
Both |
No |
Com_signal |
|
|
|
Yes |
Both |
No |
Com_slave_start |
|
|
|
Yes |
Both |
No |
Com_slave_stop |
|
|
|
Yes |
Both |
No |
Com_stmt_close |
|
|
|
Yes |
Both |
No |
Com_stmt_execute |
|
|
|
Yes |
Both |
No |
Com_stmt_fetch |
|
|
|
Yes |
Both |
No |
Com_stmt_prepare |
|
|
|
Yes |
Both |
No |
Com_stmt_reprepare |
|
|
|
Yes |
Both |
No |
Com_stmt_reset |
|
|
|
Yes |
Both |
No |
Com_stmt_send_long_data |
|
|
|
Yes |
Both |
No |
Com_truncate |
|
|
|
Yes |
Both |
No |
Com_uninstall_component |
|
|
|
Yes |
Global |
No |
Com_uninstall_plugin |
|
|
|
Yes |
Both |
No |
Com_unlock_tables |
|
|
|
Yes |
Both |
No |
Com_update |
|
|
|
Yes |
Both |
No |
Com_update_multi |
|
|
|
Yes |
Both |
No |
Com_xa_commit |
|
|
|
Yes |
Both |
No |
Com_xa_end |
|
|
|
Yes |
Both |
No |
Com_xa_prepare |
|
|
|
Yes |
Both |
No |
Com_xa_recover |
|
|
|
Yes |
Both |
No |
Com_xa_rollback |
|
|
|
Yes |
Both |
No |
Com_xa_start |
|
|
|
Yes |
Both |
No |
completion_type |
Yes |
Yes |
Yes |
|
Both |
Yes |
Compression |
|
|
|
Yes |
Session |
No |
concurrent_insert |
Yes |
Yes |
Yes |
|
Global |
Yes |
connect_timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
Connection_control_delay_generated |
|
|
|
Yes |
Global |
No |
connection_control_failed_connections_threshold |
Yes |
Yes |
Yes |
|
Global |
Yes |
connection_control_max_connection_delay |
Yes |
Yes |
Yes |
|
Global |
Yes |
connection_control_min_connection_delay |
Yes |
Yes |
Yes |
|
Global |
Yes |
Connection_errors_accept |
|
|
|
Yes |
Global |
No |
Connection_errors_internal |
|
|
|
Yes |
Global |
No |
Connection_errors_max_connections |
|
|
|
Yes |
Global |
No |
Connection_errors_peer_address |
|
|
|
Yes |
Global |
No |
Connection_errors_select |
|
|
|
Yes |
Global |
No |
Connection_errors_tcpwrap |
|
|
|
Yes |
Global |
No |
Connections |
|
|
|
Yes |
Global |
No |
console |
Yes |
Yes |
|
|
|
|
core-file |
Yes |
Yes |
|
|
|
|
core_file |
|
|
Yes |
|
Global |
No |
create_admin_listener_thread |
Yes |
Yes |
Yes |
|
Global |
No |
Created_tmp_disk_tables |
|
|
|
Yes |
Both |
No |
Created_tmp_files |
|
|
|
Yes |
Global |
No |
Created_tmp_tables |
|
|
|
Yes |
Both |
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 |
daemonize |
Yes |
Yes |
|
|
|
|
datadir |
Yes |
Yes |
Yes |
|
Global |
No |
date_format |
|
|
Yes |
|
Global |
No |
datetime_format |
|
|
Yes |
|
Global |
No |
debug |
Yes |
Yes |
Yes |
|
Both |
Yes |
debug_sync |
|
|
Yes |
|
Session |
Yes |
debug-sync-timeout |
Yes |
Yes |
|
|
|
|
default_authentication_plugin |
Yes |
Yes |
Yes |
|
Global |
No |
default_collation_for_utf8mb4 |
|
Yes |
Yes |
|
Both |
Yes |
default_password_lifetime |
Yes |
Yes |
Yes |
|
Global |
Yes |
default-storage-engine |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: default_storage_engine |
|
|
Yes |
|
Both |
Yes |
default-time-zone |
Yes |
Yes |
|
|
|
|
default_tmp_storage_engine |
Yes |
Yes |
Yes |
|
Both |
Yes |
default_week_format |
Yes |
Yes |
Yes |
|
Both |
Yes |
defaults-extra-file |
Yes |
|
|
|
|
|
defaults-file |
Yes |
|
|
|
|
|
defaults-group-suffix |
Yes |
|
|
|
|
|
delay-key-write |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: delay_key_write |
|
|
Yes |
|
Global |
Yes |
Delayed_errors |
|
|
|
Yes |
Global |
No |
delayed_insert_limit |
Yes |
Yes |
Yes |
|
Global |
Yes |
Delayed_insert_threads |
|
|
|
Yes |
Global |
No |
delayed_insert_timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
delayed_queue_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
Delayed_writes |
|
|
|
Yes |
Global |
No |
des-key-file |
Yes |
Yes |
|
|
|
|
disabled_storage_engines |
Yes |
Yes |
Yes |
|
Global |
No |
disconnect_on_expired_password |
Yes |
Yes |
Yes |
|
Global |
No |
disconnect-slave-event-count |
Yes |
Yes |
|
|
|
|
div_precision_increment |
Yes |
Yes |
Yes |
|
Both |
Yes |
dragnet.log_error_filter_rules |
Yes |
Yes |
Yes |
|
Global |
Yes |
dragnet.Status |
|
|
|
Yes |
Global |
No |
early-plugin-load |
Yes |
Yes |
|
|
|
|
enable-named-pipe |
Yes |
Yes |
|
|
|
|
- Variable: named_pipe |
|
|
|
|
|
|
end_markers_in_json |
|
|
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 |
|
Both |
Yes |
error_count |
|
|
Yes |
|
Session |
No |
event-scheduler |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: event_scheduler |
|
|
Yes |
|
Global |
Yes |
executed-gtids-compression-period |
Yes |
Yes |
|
|
|
|
- Variable: executed_gtids_compression_period |
|
|
|
|
|
|
executed_gtids_compression_period |
|
|
Yes |
|
Global |
Yes |
exit-info |
Yes |
Yes |
|
|
|
|
expire_logs_days |
Yes |
Yes |
Yes |
|
Global |
Yes |
explicit_defaults_for_timestamp |
Yes |
Yes |
Yes |
|
Both |
Yes |
external-locking |
Yes |
Yes |
|
|
|
|
- Variable: skip_external_locking |
|
|
|
|
|
|
external_user |
|
|
Yes |
|
Session |
No |
federated |
Yes |
Yes |
|
|
|
|
Firewall_access_denied |
|
|
|
Yes |
Global |
No |
Firewall_access_granted |
|
|
|
Yes |
Global |
No |
Firewall_cached_entries |
|
|
|
Yes |
Global |
No |
flush |
Yes |
Yes |
Yes |
|
Global |
Yes |
Flush_commands |
|
|
|
Yes |
Global |
No |
flush_time |
Yes |
Yes |
Yes |
|
Global |
Yes |
foreign_key_checks |
|
|
Yes |
|
Both |
Yes |
ft_boolean_syntax |
Yes |
Yes |
Yes |
|
Global |
Yes |
ft_max_word_len |
Yes |
Yes |
Yes |
|
Global |
No |
ft_min_word_len |
Yes |
Yes |
Yes |
|
Global |
No |
ft_query_expansion_limit |
Yes |
Yes |
Yes |
|
Global |
No |
ft_stopword_file |
Yes |
Yes |
Yes |
|
Global |
No |
gdb |
Yes |
Yes |
|
|
|
|
general-log |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: general_log |
|
|
Yes |
|
Global |
Yes |
general_log_file |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_concat_max_len |
Yes |
Yes |
Yes |
|
Both |
Yes |
group_replication_allow_local_disjoint_gtids_join |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_allow_local_lower_version_join |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_auto_increment_increment |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_bootstrap_group |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_communication_debug_options |
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 |
|
Global |
Yes |
group_replication_enforce_update_everywhere_checks |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_exit_state_action |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_flow_control_applier_threshold |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_flow_control_certifier_threshold |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_flow_control_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_poll_spin_loops |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_primary_member |
|
|
|
Yes |
Global |
No |
group_replication_recovery_complete_at |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_recovery_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_single_primary_mode |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_ssl_mode |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_start_on_boot |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_transaction_size_limit |
Yes |
Yes |
Yes |
|
Global |
Yes |
group_replication_unreachable_majority_timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
gtid_executed |
|
|
Yes |
|
Varies |
No |
gtid-executed-compression-period |
Yes |
Yes |
|
|
|
|
- Variable: gtid_executed_compression_period |
|
|
|
|
|
|
gtid_executed_compression_period |
|
|
Yes |
|
Global |
Yes |
gtid-mode |
Yes |
Yes |
|
|
Global |
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 |
Handler_commit |
|
|
|
Yes |
Both |
No |
Handler_delete |
|
|
|
Yes |
Both |
No |
Handler_discover |
|
|
|
Yes |
Both |
No |
Handler_external_lock |
|
|
|
Yes |
Both |
No |
Handler_mrr_init |
|
|
|
Yes |
Both |
No |
Handler_prepare |
|
|
|
Yes |
Both |
No |
Handler_read_first |
|
|
|
Yes |
Both |
No |
Handler_read_key |
|
|
|
Yes |
Both |
No |
Handler_read_last |
|
|
|
Yes |
Both |
No |
Handler_read_next |
|
|
|
Yes |
Both |
No |
Handler_read_prev |
|
|
|
Yes |
Both |
No |
Handler_read_rnd |
|
|
|
Yes |
Both |
No |
Handler_read_rnd_next |
|
|
|
Yes |
Both |
No |
Handler_rollback |
|
|
|
Yes |
Both |
No |
Handler_savepoint |
|
|
|
Yes |
Both |
No |
Handler_savepoint_rollback |
|
|
|
Yes |
Both |
No |
Handler_update |
|
|
|
Yes |
Both |
No |
Handler_write |
|
|
|
Yes |
Both |
No |
have_compress |
|
|
Yes |
|
Global |
No |
have_crypt |
|
|
Yes |
|
Global |
No |
have_dynamic_loading |
|
|
Yes |
|
Global |
No |
have_geometry |
|
|
Yes |
|
Global |
No |
have_openssl |
|
|
Yes |
|
Global |
No |
have_profiling |
|
|
Yes |
|
Global |
No |
have_query_cache |
|
|
Yes |
|
Global |
No |
have_rtree_keys |
|
|
Yes |
|
Global |
No |
have_ssl |
|
|
Yes |
|
Global |
No |
have_statement_timeout |
|
|
Yes |
|
Global |
No |
have_symlink |
|
|
Yes |
|
Global |
No |
help |
Yes |
Yes |
|
|
|
|
histogram_generation_max_mem_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
host_cache_size |
|
|
Yes |
|
Global |
Yes |
hostname |
|
|
Yes |
|
Global |
No |
identity |
|
|
Yes |
|
Session |
Yes |
ignore-builtin-innodb |
Yes |
Yes |
|
|
Global |
No |
- Variable: ignore_builtin_innodb |
|
|
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 |
|
|
Global |
No |
- Variable: init_file |
|
|
Yes |
|
Global |
No |
init_slave |
Yes |
Yes |
Yes |
|
Global |
Yes |
initialize |
Yes |
Yes |
|
|
|
|
initialize-insecure |
Yes |
Yes |
|
|
|
|
innodb |
Yes |
Yes |
|
|
|
|
innodb_adaptive_flushing |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_adaptive_flushing_lwm |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_adaptive_hash_index |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_adaptive_hash_index_parts |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_adaptive_max_sleep_delay |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_api_bk_commit_interval |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_api_disable_rowlock |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_api_enable_binlog |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_api_enable_mdl |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_api_trx_level |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_autoextend_increment |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_autoinc_lock_mode |
Yes |
Yes |
Yes |
|
Global |
No |
Innodb_available_undo_logs |
|
|
|
Yes |
Global |
No |
innodb_background_drop_list_empty |
Yes |
Yes |
Yes |
|
Global |
Yes |
Innodb_buffer_pool_bytes_data |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_bytes_dirty |
|
|
|
Yes |
Global |
No |
innodb_buffer_pool_chunk_size |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_buffer_pool_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_dump_status |
|
|
|
Yes |
Global |
No |
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_load_status |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_pages_data |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_pages_dirty |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_pages_flushed |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_pages_free |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_pages_latched |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_pages_misc |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_pages_total |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_read_ahead |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_read_ahead_evicted |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_read_ahead_rnd |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_read_requests |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_reads |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_resize_status |
|
|
|
Yes |
Global |
No |
innodb_buffer_pool_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
Innodb_buffer_pool_wait_free |
|
|
|
Yes |
Global |
No |
Innodb_buffer_pool_write_requests |
|
|
|
Yes |
Global |
No |
innodb_change_buffer_max_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_change_buffering |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_change_buffering_debug |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_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_fsyncs |
|
|
|
Yes |
Global |
No |
innodb_data_home_dir |
Yes |
Yes |
Yes |
|
Global |
No |
Innodb_data_pending_fsyncs |
|
|
|
Yes |
Global |
No |
Innodb_data_pending_reads |
|
|
|
Yes |
Global |
No |
Innodb_data_pending_writes |
|
|
|
Yes |
Global |
No |
Innodb_data_read |
|
|
|
Yes |
Global |
No |
Innodb_data_reads |
|
|
|
Yes |
Global |
No |
Innodb_data_writes |
|
|
|
Yes |
Global |
No |
Innodb_data_written |
|
|
|
Yes |
Global |
No |
Innodb_dblwr_pages_written |
|
|
|
Yes |
Global |
No |
Innodb_dblwr_writes |
|
|
|
Yes |
Global |
No |
innodb_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 |
|
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_have_atomic_builtins |
|
|
|
Yes |
Global |
No |
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_waits |
|
|
|
Yes |
Global |
No |
innodb_log_write_ahead_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
Innodb_log_write_requests |
|
|
|
Yes |
Global |
No |
Innodb_log_writes |
|
|
|
Yes |
Global |
No |
innodb_lru_scan_depth |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_max_dirty_pages_pct |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_max_dirty_pages_pct_lwm |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_max_purge_lag |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_max_purge_lag_delay |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_max_undo_log_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_merge_threshold_set_all_debug |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_monitor_disable |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_monitor_enable |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_monitor_reset |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_monitor_reset_all |
Yes |
Yes |
Yes |
|
Global |
Yes |
Innodb_num_open_files |
|
|
|
Yes |
Global |
No |
innodb_numa_interleave |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_old_blocks_pct |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_old_blocks_time |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_online_alter_log_max_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_open_files |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_optimize_fulltext_only |
Yes |
Yes |
Yes |
|
Global |
Yes |
Innodb_os_log_fsyncs |
|
|
|
Yes |
Global |
No |
Innodb_os_log_pending_fsyncs |
|
|
|
Yes |
Global |
No |
Innodb_os_log_pending_writes |
|
|
|
Yes |
Global |
No |
Innodb_os_log_written |
|
|
|
Yes |
Global |
No |
innodb_page_cleaners |
Yes |
Yes |
Yes |
|
Global |
No |
Innodb_page_size |
|
|
|
Yes |
Global |
No |
innodb_page_size |
Yes |
Yes |
Yes |
|
Global |
No |
Innodb_pages_created |
|
|
|
Yes |
Global |
No |
Innodb_pages_read |
|
|
|
Yes |
Global |
No |
Innodb_pages_written |
|
|
|
Yes |
Global |
No |
innodb_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_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_row_lock_current_waits |
|
|
|
Yes |
Global |
No |
Innodb_row_lock_time |
|
|
|
Yes |
Global |
No |
Innodb_row_lock_time_avg |
|
|
|
Yes |
Global |
No |
Innodb_row_lock_time_max |
|
|
|
Yes |
Global |
No |
Innodb_row_lock_waits |
|
|
|
Yes |
Global |
No |
Innodb_rows_deleted |
|
|
|
Yes |
Global |
No |
Innodb_rows_inserted |
|
|
|
Yes |
Global |
No |
Innodb_rows_read |
|
|
|
Yes |
Global |
No |
Innodb_rows_updated |
|
|
|
Yes |
Global |
No |
innodb_saved_page_number_debug |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_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_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-file |
Yes |
Yes |
|
|
|
|
innodb_status_output |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_status_output_locks |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_strict_mode |
Yes |
Yes |
Yes |
|
Both |
Yes |
innodb_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_truncated_status_writes |
|
|
|
Yes |
Global |
No |
innodb_trx_purge_view_update_only_debug |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_trx_rseg_n_slots_debug |
Yes |
Yes |
Yes |
|
Global |
Yes |
innodb_undo_directory |
Yes |
Yes |
Yes |
|
Global |
No |
innodb_undo_log_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 |
install |
Yes |
|
|
|
|
|
install-manual |
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_blocks_not_flushed |
|
|
|
Yes |
Global |
No |
Key_blocks_unused |
|
|
|
Yes |
Global |
No |
Key_blocks_used |
|
|
|
Yes |
Global |
No |
key_buffer_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
key_cache_age_threshold |
Yes |
Yes |
Yes |
|
Global |
Yes |
key_cache_block_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
key_cache_division_limit |
Yes |
Yes |
Yes |
|
Global |
Yes |
Key_read_requests |
|
|
|
Yes |
Global |
No |
Key_reads |
|
|
|
Yes |
Global |
No |
Key_write_requests |
|
|
|
Yes |
Global |
No |
Key_writes |
|
|
|
Yes |
Global |
No |
keyring_aws_cmk_id |
Yes |
Yes |
Yes |
|
Global |
Yes |
keyring_aws_conf_file |
Yes |
Yes |
Yes |
|
Global |
No |
keyring_aws_data_file |
Yes |
Yes |
Yes |
|
Global |
No |
keyring_aws_region |
Yes |
Yes |
Yes |
|
Global |
Yes |
keyring_encrypted_file_data |
Yes |
Yes |
Yes |
|
Global |
Yes |
keyring_encrypted_file_password |
Yes |
Yes |
Yes |
|
Global |
Yes |
keyring_file_data |
Yes |
Yes |
Yes |
|
Global |
Yes |
keyring-migration-destination |
Yes |
Yes |
|
|
|
|
keyring-migration-host |
Yes |
Yes |
|
|
|
|
keyring-migration-password |
Yes |
Yes |
|
|
|
|
keyring-migration-port |
Yes |
Yes |
|
|
|
|
keyring-migration-socket |
Yes |
Yes |
|
|
|
|
keyring-migration-source |
Yes |
Yes |
|
|
|
|
keyring-migration-user |
Yes |
Yes |
|
|
|
|
keyring_okv_conf_dir |
Yes |
Yes |
Yes |
|
Global |
Yes |
keyring_operations |
|
|
Yes |
|
Global |
Yes |
language |
Yes |
Yes |
Yes |
|
Global |
No |
large_files_support |
|
|
Yes |
|
Global |
No |
large_page_size |
|
|
Yes |
|
Global |
No |
large-pages |
Yes |
Yes |
|
|
Global |
No |
- Variable: large_pages |
|
|
Yes |
|
Global |
No |
last_insert_id |
|
|
Yes |
|
Session |
Yes |
Last_query_cost |
|
|
|
Yes |
Session |
No |
Last_query_partial_plans |
|
|
|
Yes |
Session |
No |
lc-messages |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: lc_messages |
|
|
Yes |
|
Both |
Yes |
lc-messages-dir |
Yes |
Yes |
|
|
Global |
No |
- Variable: lc_messages_dir |
|
|
Yes |
|
Global |
No |
lc_time_names |
|
|
Yes |
|
Both |
Yes |
license |
|
|
Yes |
|
Global |
No |
local_infile |
|
|
Yes |
|
Global |
Yes |
local-service |
Yes |
|
|
|
|
|
lock_wait_timeout |
Yes |
Yes |
Yes |
|
Both |
Yes |
Locked_connects |
|
|
|
Yes |
Global |
No |
locked_in_memory |
|
|
Yes |
|
Global |
No |
log-bin |
Yes |
Yes |
Yes |
|
Global |
No |
log_bin |
|
|
Yes |
|
Global |
No |
log_bin_basename |
|
|
Yes |
|
Global |
No |
log-bin-index |
Yes |
Yes |
|
|
|
|
log_bin_index |
|
|
Yes |
|
Global |
No |
log-bin-trust-function-creators |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: log_bin_trust_function_creators |
|
|
Yes |
|
Global |
Yes |
log-bin-use-v1-row-events |
Yes |
Yes |
|
|
Global |
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 |
|
|
Global |
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-isam |
Yes |
Yes |
|
|
|
|
log_output |
Yes |
Yes |
Yes |
|
Global |
Yes |
log-queries-not-using-indexes |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: log_queries_not_using_indexes |
|
|
Yes |
|
Global |
Yes |
log-raw |
Yes |
Yes |
|
|
|
|
log-short-format |
Yes |
Yes |
|
|
|
|
log-slave-updates |
Yes |
Yes |
|
|
Global |
No |
- Variable: log_slave_updates |
|
|
Yes |
|
Global |
No |
log_slave_updates |
Yes |
Yes |
Yes |
|
Global |
No |
log_slow_admin_statements |
|
|
Yes |
|
Global |
Yes |
log_slow_extra |
Yes |
Yes |
Yes |
|
Global |
Yes |
log_slow_slave_statements |
|
|
Yes |
|
Global |
Yes |
log_statements_unsafe_for_binlog |
|
|
Yes |
|
Global |
Yes |
log_syslog |
Yes |
Yes |
Yes |
|
Global |
Yes |
log_syslog_facility |
Yes |
Yes |
Yes |
|
Global |
Yes |
log_syslog_include_pid |
Yes |
Yes |
Yes |
|
Global |
Yes |
log_syslog_tag |
Yes |
Yes |
Yes |
|
Global |
Yes |
log-tc |
Yes |
Yes |
|
|
|
|
log-tc-size |
Yes |
Yes |
|
|
|
|
log_throttle_queries_not_using_indexes |
|
|
Yes |
|
Global |
Yes |
log_timestamps |
Yes |
Yes |
Yes |
|
Global |
Yes |
log-warnings |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: log_warnings |
|
|
Yes |
|
Global |
Yes |
long_query_time |
Yes |
Yes |
Yes |
|
Both |
Yes |
low-priority-updates |
Yes |
Yes |
|
|
Both |
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-file |
Yes |
Yes |
|
|
|
|
master-info-repository |
Yes |
Yes |
|
|
|
|
- Variable: master_info_repository |
|
|
|
|
|
|
master_info_repository |
Yes |
Yes |
Yes |
|
Global |
Yes |
master-retry-count |
Yes |
Yes |
|
|
|
|
master-verify-checksum |
Yes |
Yes |
|
|
|
|
- Variable: master_verify_checksum |
|
|
|
|
|
|
master_verify_checksum |
|
|
Yes |
|
Global |
Yes |
max_allowed_packet |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_binlog_cache_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
max-binlog-dump-events |
Yes |
Yes |
|
|
|
|
max_binlog_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
max_binlog_stmt_cache_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
max_connect_errors |
Yes |
Yes |
Yes |
|
Global |
Yes |
max_connections |
Yes |
Yes |
Yes |
|
Global |
Yes |
max_delayed_threads |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_digest_length |
Yes |
Yes |
Yes |
|
Global |
No |
max_error_count |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_execution_time |
Yes |
Yes |
Yes |
|
Both |
Yes |
Max_execution_time_exceeded |
|
|
|
Yes |
Both |
No |
Max_execution_time_set |
|
|
|
Yes |
Both |
No |
Max_execution_time_set_failed |
|
|
|
Yes |
Both |
No |
max_heap_table_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_insert_delayed_threads |
|
|
Yes |
|
Both |
Yes |
max_join_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_length_for_sort_data |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_points_in_geometry |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_prepared_stmt_count |
Yes |
Yes |
Yes |
|
Global |
Yes |
max_relay_log_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
max_seeks_for_key |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_sort_length |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_sp_recursion_depth |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_tmp_tables |
|
|
Yes |
|
Both |
Yes |
Max_used_connections |
|
|
|
Yes |
Global |
No |
Max_used_connections_time |
|
|
|
Yes |
Global |
No |
max_user_connections |
Yes |
Yes |
Yes |
|
Both |
Yes |
max_write_lock_count |
Yes |
Yes |
Yes |
|
Global |
Yes |
mecab_charset |
|
|
|
Yes |
Global |
No |
mecab_rc_file |
Yes |
Yes |
Yes |
|
Global |
No |
memlock |
Yes |
Yes |
|
|
|
|
- Variable: locked_in_memory |
|
|
|
|
|
|
metadata_locks_cache_size |
|
|
Yes |
|
Global |
No |
metadata_locks_hash_instances |
|
|
Yes |
|
Global |
No |
min-examined-row-limit |
Yes |
Yes |
Yes |
|
Both |
Yes |
multi_range_count |
Yes |
Yes |
Yes |
|
Both |
Yes |
myisam-block-size |
Yes |
Yes |
|
|
|
|
myisam_data_pointer_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
myisam_max_sort_file_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
myisam_mmap_size |
Yes |
Yes |
Yes |
|
Global |
No |
myisam-recover-options |
Yes |
Yes |
|
|
|
|
- Variable: myisam_recover_options |
|
|
|
|
|
|
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 |
Yes |
Yes |
Yes |
|
Global |
No |
Mysqlx_aborted_clients |
|
|
|
Yes |
Global |
No |
Mysqlx_address |
|
|
|
Yes |
Global |
No |
mysqlx-bind-address |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx_bind_address |
Yes |
Yes |
Yes |
|
Global |
No |
Mysqlx_bytes_received |
|
|
|
Yes |
Both |
No |
Mysqlx_bytes_sent |
|
|
|
Yes |
Both |
No |
mysqlx-connect-timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
mysqlx_connect_timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
Mysqlx_connection_accept_errors |
|
|
|
Yes |
Both |
No |
Mysqlx_connection_errors |
|
|
|
Yes |
Both |
No |
Mysqlx_connections_accepted |
|
|
|
Yes |
Global |
No |
Mysqlx_connections_closed |
|
|
|
Yes |
Global |
No |
Mysqlx_connections_rejected |
|
|
|
Yes |
Global |
No |
Mysqlx_crud_create_view |
|
|
|
Yes |
Both |
No |
Mysqlx_crud_delete |
|
|
|
Yes |
Both |
No |
Mysqlx_crud_drop_view |
|
|
|
Yes |
Both |
No |
Mysqlx_crud_find |
|
|
|
Yes |
Both |
No |
Mysqlx_crud_insert |
|
|
|
Yes |
Both |
No |
Mysqlx_crud_modify_view |
|
|
|
Yes |
Both |
No |
Mysqlx_crud_update |
|
|
|
Yes |
Both |
No |
mysqlx_document_id_unique_prefix |
Yes |
Yes |
Yes |
|
Global |
Yes |
Mysqlx_errors_sent |
|
|
|
Yes |
Both |
No |
Mysqlx_errors_unknown_message_type |
|
|
|
Yes |
Both |
No |
Mysqlx_expect_close |
|
|
|
Yes |
Both |
No |
Mysqlx_expect_open |
|
|
|
Yes |
Both |
No |
mysqlx-idle-worker-thread-timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
mysqlx_idle_worker_thread_timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
Mysqlx_init_error |
|
|
|
Yes |
Both |
No |
mysqlx-interactive-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_allowed_packet |
Yes |
Yes |
Yes |
|
Global |
Yes |
mysqlx-max-connections |
Yes |
Yes |
Yes |
|
Global |
Yes |
mysqlx_max_connections |
Yes |
Yes |
Yes |
|
Global |
Yes |
mysqlx-min-worker-threads |
Yes |
Yes |
Yes |
|
Global |
Yes |
mysqlx_min_worker_threads |
Yes |
Yes |
Yes |
|
Global |
Yes |
Mysqlx_notice_global_sent |
|
|
|
Yes |
Both |
No |
Mysqlx_notice_other_sent |
|
|
|
Yes |
Both |
No |
Mysqlx_notice_warning_sent |
|
|
|
Yes |
Both |
No |
Mysqlx_notified_by_group_replication |
|
|
|
Yes |
Both |
No |
Mysqlx_port |
|
|
|
Yes |
Global |
No |
mysqlx-port |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx_port |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx-port-open-timeout |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx_port_open_timeout |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx-read-timeout |
Yes |
Yes |
Yes |
|
Session |
Yes |
mysqlx_read_timeout |
Yes |
Yes |
Yes |
|
Session |
Yes |
Mysqlx_rows_sent |
|
|
|
Yes |
Both |
No |
Mysqlx_sessions |
|
|
|
Yes |
Global |
No |
Mysqlx_sessions_accepted |
|
|
|
Yes |
Global |
No |
Mysqlx_sessions_closed |
|
|
|
Yes |
Global |
No |
Mysqlx_sessions_fatal_error |
|
|
|
Yes |
Global |
No |
Mysqlx_sessions_killed |
|
|
|
Yes |
Global |
No |
Mysqlx_sessions_rejected |
|
|
|
Yes |
Global |
No |
Mysqlx_socket |
|
|
|
Yes |
Global |
No |
mysqlx-socket |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx_socket |
Yes |
Yes |
Yes |
|
Global |
No |
Mysqlx_ssl_accept_renegotiates |
|
|
|
Yes |
Global |
No |
Mysqlx_ssl_accepts |
|
|
|
Yes |
Global |
No |
Mysqlx_ssl_active |
|
|
|
Yes |
Both |
No |
mysqlx-ssl-ca |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx-ssl-capath |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx-ssl-cert |
Yes |
Yes |
Yes |
|
Global |
No |
Mysqlx_ssl_cipher |
|
|
|
Yes |
Both |
No |
mysqlx-ssl-cipher |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx_ssl_cipher |
Yes |
Yes |
Yes |
|
Global |
No |
Mysqlx_ssl_cipher_list |
|
|
|
Yes |
Both |
No |
mysqlx-ssl-crl |
Yes |
Yes |
Yes |
|
Global |
No |
mysqlx-ssl-crlpath |
Yes |
Yes |
Yes |
|
Global |
No |
Mysqlx_ssl_ctx_verify_depth |
|
|
|
Yes |
Both |
No |
Mysqlx_ssl_ctx_verify_mode |
|
|
|
Yes |
Both |
No |
Mysqlx_ssl_finished_accepts |
|
|
|
Yes |
Global |
No |
mysqlx-ssl-key |
Yes |
Yes |
Yes |
|
Global |
No |
Mysqlx_ssl_server_not_after |
|
|
|
Yes |
Global |
No |
Mysqlx_ssl_server_not_before |
|
|
|
Yes |
Global |
No |
Mysqlx_ssl_verify_depth |
|
|
|
Yes |
Global |
No |
Mysqlx_ssl_verify_mode |
|
|
|
Yes |
Global |
No |
Mysqlx_ssl_version |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_create_collection |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_create_collection_index |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_disable_notices |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_drop_collection |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_drop_collection_index |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_enable_notices |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_ensure_collection |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_execute_mysqlx |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_execute_sql |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_execute_xplugin |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_kill_client |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_list_clients |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_list_notices |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_list_objects |
|
|
|
Yes |
Both |
No |
Mysqlx_stmt_ping |
|
|
|
Yes |
Both |
No |
mysqlx-wait-timeout |
Yes |
Yes |
Yes |
|
Session |
Yes |
mysqlx_wait_timeout |
Yes |
Yes |
Yes |
|
Session |
Yes |
Mysqlx_worker_threads |
|
|
|
Yes |
Global |
No |
Mysqlx_worker_threads_active |
|
|
|
Yes |
Global |
No |
mysqlx-write-timeout |
Yes |
Yes |
Yes |
|
Session |
Yes |
mysqlx_write_timeout |
Yes |
Yes |
Yes |
|
Session |
Yes |
named_pipe |
|
|
Yes |
|
Global |
No |
named_pipe_full_access_group |
|
|
Yes |
|
Global |
No |
ndb-allow-copying-alter-table |
Yes |
Yes |
Yes |
|
Both |
Yes |
Ndb_api_bytes_received_count |
|
|
|
Yes |
Global |
No |
Ndb_api_bytes_received_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_bytes_received_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_bytes_sent_count |
|
|
|
Yes |
Global |
No |
Ndb_api_bytes_sent_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_bytes_sent_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_event_bytes_count |
|
|
|
Yes |
Global |
No |
Ndb_api_event_bytes_count_injector |
|
|
|
Yes |
Global |
No |
Ndb_api_event_data_count |
|
|
|
Yes |
Global |
No |
Ndb_api_event_data_count_injector |
|
|
|
Yes |
Global |
No |
Ndb_api_event_nondata_count |
|
|
|
Yes |
Global |
No |
Ndb_api_event_nondata_count_injector |
|
|
|
Yes |
Global |
No |
Ndb_api_pk_op_count |
|
|
|
Yes |
Global |
No |
Ndb_api_pk_op_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_pk_op_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_pruned_scan_count |
|
|
|
Yes |
Global |
No |
Ndb_api_pruned_scan_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_pruned_scan_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_range_scan_count |
|
|
|
Yes |
Global |
No |
Ndb_api_range_scan_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_range_scan_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_read_row_count |
|
|
|
Yes |
Global |
No |
Ndb_api_read_row_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_read_row_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_scan_batch_count |
|
|
|
Yes |
Global |
No |
Ndb_api_scan_batch_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_scan_batch_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_table_scan_count |
|
|
|
Yes |
Global |
No |
Ndb_api_table_scan_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_table_scan_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_abort_count |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_abort_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_trans_abort_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_close_count |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_close_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_trans_close_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_commit_count |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_commit_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_trans_commit_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_local_read_row_count |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_local_read_row_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_trans_local_read_row_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_start_count |
|
|
|
Yes |
Global |
No |
Ndb_api_trans_start_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_trans_start_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_uk_op_count |
|
|
|
Yes |
Global |
No |
Ndb_api_uk_op_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_uk_op_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_exec_complete_count |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_exec_complete_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_wait_exec_complete_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_meta_request_count |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_meta_request_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_wait_meta_request_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_nanos_count |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_nanos_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_wait_nanos_count_slave |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_scan_result_count |
|
|
|
Yes |
Global |
No |
Ndb_api_wait_scan_result_count_session |
|
|
|
Yes |
Session |
No |
Ndb_api_wait_scan_result_count_slave |
|
|
|
Yes |
Global |
No |
ndb_autoincrement_prefetch_sz |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb-batch-size |
Yes |
Yes |
Yes |
|
Global |
No |
ndb-blob-write-batch-bytes |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb_cache_check_time |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb_clear_apply_status |
Yes |
|
Yes |
|
Global |
Yes |
ndb-cluster-connection-pool |
Yes |
Yes |
Yes |
|
Global |
No |
ndb-cluster-connection-pool-nodeids |
Yes |
Yes |
Yes |
|
Global |
No |
Ndb_cluster_node_id |
|
|
|
Yes |
Both |
No |
Ndb_config_from_host |
|
|
|
Yes |
Both |
No |
Ndb_config_from_port |
|
|
|
Yes |
Both |
No |
Ndb_conflict_fn_epoch |
|
|
|
Yes |
Global |
No |
Ndb_conflict_fn_epoch_trans |
|
|
|
Yes |
Global |
No |
Ndb_conflict_fn_epoch2 |
|
|
|
Yes |
Global |
No |
Ndb_conflict_fn_epoch2_trans |
|
|
|
Yes |
Global |
No |
Ndb_conflict_fn_max |
|
|
|
Yes |
Global |
No |
Ndb_conflict_fn_old |
|
|
|
Yes |
Global |
No |
Ndb_conflict_last_conflict_epoch |
|
|
Yes |
|
Global |
No |
Ndb_conflict_last_stable_epoch |
|
|
|
Yes |
Global |
No |
Ndb_conflict_reflected_op_discard_count |
|
|
|
Yes |
Global |
No |
Ndb_conflict_reflected_op_prepare_count |
|
|
|
Yes |
Global |
No |
Ndb_conflict_refresh_op_count |
|
|
|
Yes |
Global |
No |
Ndb_conflict_trans_conflict_commit_count |
|
|
|
Yes |
Global |
No |
Ndb_conflict_trans_detect_iter_count |
|
|
|
Yes |
Global |
No |
Ndb_conflict_trans_reject_count |
|
|
|
Yes |
Global |
No |
Ndb_conflict_trans_row_conflict_count |
|
|
|
Yes |
Global |
No |
Ndb_conflict_trans_row_reject_count |
|
|
|
Yes |
Global |
No |
ndb-connectstring |
Yes |
Yes |
|
|
|
|
ndb_data_node_neighbour |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb-default-column-format |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: ndb_default_column_format |
|
|
Yes |
|
Global |
Yes |
ndb_default_column_format |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb-deferred-constraints |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: ndb_deferred_constraints |
|
|
Yes |
|
Both |
Yes |
ndb_deferred_constraints |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb-distribution |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: ndb_distribution |
|
|
Yes |
|
Global |
Yes |
ndb_distribution |
Yes |
Yes |
Yes |
|
Global |
Yes |
Ndb_epoch_delete_delete_count |
|
|
|
Yes |
Global |
No |
ndb_eventbuffer_free_percent |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb_eventbuffer_max_alloc |
Yes |
Yes |
Yes |
|
Global |
Yes |
Ndb_execute_count |
|
|
|
Yes |
Global |
No |
ndb_extra_logging |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb_force_send |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb_fully_replicated |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb_index_stat_enable |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb_index_stat_option |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb_join_pushdown |
|
|
Yes |
|
Both |
Yes |
Ndb_last_commit_epoch_server |
|
|
|
Yes |
Global |
No |
Ndb_last_commit_epoch_session |
|
|
|
Yes |
Session |
No |
ndb-log-apply-status |
Yes |
Yes |
|
|
Global |
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 |
|
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 |
|
|
Both |
Yes |
- Variable: ndb_log_exclusive_reads |
|
|
Yes |
|
Both |
Yes |
ndb_log_exclusive_reads |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb-log-orig |
Yes |
Yes |
|
|
Global |
No |
- Variable: ndb_log_orig |
|
|
Yes |
|
Global |
No |
ndb_log_orig |
Yes |
Yes |
Yes |
|
Global |
No |
ndb-log-transaction-id |
Yes |
Yes |
|
|
Global |
No |
- Variable: ndb_log_transaction_id |
|
|
Yes |
|
Global |
No |
ndb_log_transaction_id |
|
|
Yes |
|
Global |
No |
ndb-log-update-as-write |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb-log-update-minimal |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb_log_updated_only |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb-mgmd-host |
Yes |
Yes |
|
|
|
|
ndb-nodeid |
Yes |
Yes |
|
Yes |
Global |
No |
Ndb_number_of_data_nodes |
|
|
|
Yes |
Global |
No |
ndb_optimization_delay |
|
|
Yes |
|
Global |
Yes |
ndb_optimized_node_selection |
Yes |
Yes |
Yes |
|
Global |
No |
Ndb_pruned_scan_count |
|
|
|
Yes |
Global |
No |
Ndb_pushed_queries_defined |
|
|
|
Yes |
Global |
No |
Ndb_pushed_queries_dropped |
|
|
|
Yes |
Global |
No |
Ndb_pushed_queries_executed |
|
|
|
Yes |
Global |
No |
Ndb_pushed_reads |
|
|
|
Yes |
Global |
No |
ndb_read_backup |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb-recv-thread-activation-threshold |
Yes |
Yes |
|
|
|
|
- Variable: ndb_recv_thread_activation_threshold |
|
|
|
|
|
|
ndb_recv_thread_activation_threshold |
|
|
Yes |
|
Global |
Yes |
ndb-recv-thread-cpu-mask |
Yes |
Yes |
|
|
|
|
- Variable: ndb_recv_thread_cpu_mask |
|
|
|
|
|
|
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_scan_count |
|
|
|
Yes |
Global |
No |
ndb_show_foreign_key_mock_tables |
Yes |
Yes |
Yes |
|
Global |
Yes |
ndb_slave_conflict_role |
Yes |
Yes |
Yes |
|
Global |
Yes |
Ndb_slave_max_replicated_epoch |
|
|
Yes |
|
Global |
No |
Ndb_system_name |
|
|
Yes |
|
Global |
No |
ndb_table_no_logging |
|
|
Yes |
|
Session |
Yes |
ndb_table_temporary |
|
|
Yes |
|
Session |
Yes |
ndb-transid-mysql-connection-map |
Yes |
|
|
|
|
|
ndb_use_copying_alter_table |
|
|
Yes |
|
Both |
No |
ndb_use_exact_count |
|
|
Yes |
|
Both |
Yes |
ndb_use_transactions |
Yes |
Yes |
Yes |
|
Both |
Yes |
ndb_version |
|
|
Yes |
|
Global |
No |
ndb_version_string |
|
|
Yes |
|
Global |
No |
ndb-wait-connected |
Yes |
Yes |
Yes |
|
Global |
No |
ndb-wait-setup |
Yes |
Yes |
Yes |
|
Global |
No |
ndbcluster |
Yes |
Yes |
|
|
|
|
ndbinfo_database |
|
|
Yes |
|
Global |
No |
ndbinfo_max_bytes |
Yes |
|
Yes |
|
Both |
Yes |
ndbinfo_max_rows |
Yes |
|
Yes |
|
Both |
Yes |
ndbinfo_offline |
|
|
Yes |
|
Global |
Yes |
ndbinfo_show_hidden |
Yes |
|
Yes |
|
Both |
Yes |
ndbinfo_table_prefix |
Yes |
|
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 |
no-dd-upgrade |
Yes |
Yes |
|
|
|
|
no-defaults |
Yes |
|
|
|
|
|
no-monitor |
Yes |
Yes |
|
|
|
|
Not_flushed_delayed_rows |
|
|
|
Yes |
Global |
No |
offline_mode |
Yes |
Yes |
Yes |
|
Global |
Yes |
old |
Yes |
Yes |
Yes |
|
Global |
No |
old-alter-table |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: old_alter_table |
|
|
Yes |
|
Both |
Yes |
old_passwords |
|
|
Yes |
|
Both |
Yes |
old-style-user-limits |
Yes |
Yes |
|
|
|
|
Ongoing_anonymous_gtid_violating_transaction_count |
|
|
|
Yes |
Global |
No |
Ongoing_anonymous_transaction_count |
|
|
|
Yes |
Global |
No |
Ongoing_automatic_gtid_violating_transaction_count |
|
|
|
Yes |
Global |
No |
Open_files |
|
|
|
Yes |
Global |
No |
open-files-limit |
Yes |
Yes |
|
|
Global |
No |
- Variable: open_files_limit |
|
|
Yes |
|
Global |
No |
Open_streams |
|
|
|
Yes |
Global |
No |
Open_table_definitions |
|
|
|
Yes |
Global |
No |
Open_tables |
|
|
|
Yes |
Both |
No |
Opened_files |
|
|
|
Yes |
Global |
No |
Opened_table_definitions |
|
|
|
Yes |
Both |
No |
Opened_tables |
|
|
|
Yes |
Both |
No |
optimizer_prune_level |
Yes |
Yes |
Yes |
|
Both |
Yes |
optimizer_search_depth |
Yes |
Yes |
Yes |
|
Both |
Yes |
optimizer_switch |
Yes |
Yes |
Yes |
|
Both |
Yes |
optimizer_trace |
|
|
Yes |
|
Both |
Yes |
optimizer_trace_features |
|
|
Yes |
|
Both |
Yes |
optimizer_trace_limit |
|
|
Yes |
|
Both |
Yes |
optimizer_trace_max_mem_size |
|
|
Yes |
|
Both |
Yes |
optimizer_trace_offset |
|
|
Yes |
|
Both |
Yes |
original_commit_timestamp |
|
|
Yes |
|
Session |
Yes |
original_server_version |
|
|
Yes |
|
Session |
Yes |
parser_max_mem_size |
Yes |
Yes |
Yes |
|
Both |
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_lost |
|
|
|
Yes |
Global |
No |
performance_schema_accounts_size |
Yes |
Yes |
Yes |
|
Global |
No |
Performance_schema_cond_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_cond_instances_lost |
|
|
|
Yes |
Global |
No |
performance-schema-consumer-events-stages-current |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-stages-history |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-stages-history-long |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-statements-current |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-statements-history |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-statements-history-long |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-transactions-current |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-transactions-history |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-transactions-history-long |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-waits-current |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-waits-history |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-events-waits-history-long |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-global-instrumentation |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-statements-digest |
Yes |
Yes |
|
|
|
|
performance-schema-consumer-thread-instrumentation |
Yes |
Yes |
|
|
|
|
Performance_schema_digest_lost |
|
|
|
Yes |
Global |
No |
performance_schema_digests_size |
Yes |
Yes |
Yes |
|
Global |
No |
performance_schema_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_file_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_file_handles_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_file_instances_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_hosts_lost |
|
|
|
Yes |
Global |
No |
performance_schema_hosts_size |
Yes |
Yes |
Yes |
|
Global |
No |
Performance_schema_index_stat_lost |
|
|
|
Yes |
Global |
No |
performance-schema-instrument |
Yes |
Yes |
|
|
|
|
Performance_schema_locker_lost |
|
|
|
Yes |
Global |
No |
performance_schema_max_cond_classes |
Yes |
Yes |
Yes |
|
Global |
No |
performance_schema_max_cond_instances |
Yes |
Yes |
Yes |
|
Global |
No |
performance_schema_max_digest_length |
Yes |
Yes |
Yes |
|
Global |
No |
performance_schema_max_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_memory_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_metadata_lock_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_mutex_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_mutex_instances_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_nested_statement_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_prepared_statements_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_program_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_rwlock_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_rwlock_instances_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_session_connect_attrs_longest_seen |
|
|
|
Yes |
Global |
No |
Performance_schema_session_connect_attrs_lost |
|
|
|
Yes |
Global |
No |
performance_schema_session_connect_attrs_size |
Yes |
Yes |
Yes |
|
Global |
No |
performance_schema_setup_actors_size |
Yes |
Yes |
Yes |
|
Global |
No |
performance_schema_setup_objects_size |
Yes |
Yes |
Yes |
|
Global |
No |
Performance_schema_socket_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_socket_instances_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_stage_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_statement_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_table_handles_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_table_instances_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_table_lock_stat_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_thread_classes_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_thread_instances_lost |
|
|
|
Yes |
Global |
No |
Performance_schema_users_lost |
|
|
|
Yes |
Global |
No |
performance_schema_users_size |
Yes |
Yes |
Yes |
|
Global |
No |
persist_only_admin_x509_subject |
Yes |
Yes |
Yes |
|
Global |
No |
persisted_globals_load |
Yes |
Yes |
Yes |
|
Global |
No |
pid-file |
Yes |
Yes |
|
|
Global |
No |
- Variable: pid_file |
|
|
Yes |
|
Global |
No |
plugin |
Yes |
Yes |
|
|
|
|
plugin_dir |
Yes |
Yes |
Yes |
|
Global |
No |
plugin-load |
Yes |
Yes |
|
|
|
|
plugin-load-add |
Yes |
Yes |
|
|
|
|
port |
Yes |
Yes |
Yes |
|
Global |
No |
port-open-timeout |
Yes |
Yes |
|
|
|
|
preload_buffer_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
Prepared_stmt_count |
|
|
|
Yes |
Global |
No |
print-defaults |
Yes |
|
|
|
|
|
profiling |
|
|
Yes |
|
Both |
Yes |
profiling_history_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
protocol_version |
|
|
Yes |
|
Global |
No |
proxy_user |
|
|
Yes |
|
Session |
No |
pseudo_slave_mode |
|
|
Yes |
|
Session |
Yes |
pseudo_thread_id |
|
|
Yes |
|
Session |
Yes |
Qcache_free_blocks |
|
|
|
Yes |
Global |
No |
Qcache_free_memory |
|
|
|
Yes |
Global |
No |
Qcache_hits |
|
|
|
Yes |
Global |
No |
Qcache_inserts |
|
|
|
Yes |
Global |
No |
Qcache_lowmem_prunes |
|
|
|
Yes |
Global |
No |
Qcache_not_cached |
|
|
|
Yes |
Global |
No |
Qcache_queries_in_cache |
|
|
|
Yes |
Global |
No |
Qcache_total_blocks |
|
|
|
Yes |
Global |
No |
Queries |
|
|
|
Yes |
Both |
No |
query_alloc_block_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
query_cache_limit |
Yes |
Yes |
Yes |
|
Global |
Yes |
query_cache_min_res_unit |
Yes |
Yes |
Yes |
|
Global |
Yes |
query_cache_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
query_cache_type |
Yes |
Yes |
Yes |
|
Both |
Yes |
query_cache_wlock_invalidate |
Yes |
Yes |
Yes |
|
Both |
Yes |
query_prealloc_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
Questions |
|
|
|
Yes |
Both |
No |
rand_seed1 |
|
|
Yes |
|
Session |
Yes |
rand_seed2 |
|
|
Yes |
|
Session |
Yes |
range_alloc_block_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
range_optimizer_max_mem_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
rbr_exec_mode |
|
|
Yes |
|
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 |
|
|
Global |
No |
- Variable: relay_log |
|
|
Yes |
|
Global |
No |
relay_log_basename |
|
|
Yes |
|
Global |
No |
relay-log-index |
Yes |
Yes |
|
|
Global |
No |
- Variable: relay_log_index |
|
|
Yes |
|
Global |
No |
relay_log_index |
Yes |
Yes |
Yes |
|
Global |
No |
relay-log-info-file |
Yes |
Yes |
|
|
|
|
- Variable: relay_log_info_file |
|
|
|
|
|
|
relay_log_info_file |
Yes |
Yes |
Yes |
|
Global |
No |
relay-log-info-repository |
Yes |
Yes |
|
|
|
|
- Variable: relay_log_info_repository |
|
|
|
|
|
|
relay_log_info_repository |
|
|
Yes |
|
Global |
Yes |
relay_log_purge |
Yes |
Yes |
Yes |
|
Global |
Yes |
relay-log-recovery |
Yes |
Yes |
|
|
|
|
- Variable: relay_log_recovery |
|
|
|
|
|
|
relay_log_recovery |
Yes |
Yes |
Yes |
|
Global |
No |
relay_log_space_limit |
Yes |
Yes |
Yes |
|
Global |
No |
remove |
Yes |
|
|
|
|
|
replicate-do-db |
Yes |
Yes |
|
|
|
|
replicate-do-table |
Yes |
Yes |
|
|
|
|
replicate-ignore-db |
Yes |
Yes |
|
|
|
|
replicate-ignore-table |
Yes |
Yes |
|
|
|
|
replicate-rewrite-db |
Yes |
Yes |
|
|
|
|
replicate-same-server-id |
Yes |
Yes |
|
|
|
|
replicate-wild-do-table |
Yes |
Yes |
|
|
|
|
replicate-wild-ignore-table |
Yes |
Yes |
|
|
|
|
report-host |
Yes |
Yes |
|
|
Global |
No |
- Variable: report_host |
|
|
Yes |
|
Global |
No |
report-password |
Yes |
Yes |
|
|
Global |
No |
- Variable: report_password |
|
|
Yes |
|
Global |
No |
report-port |
Yes |
Yes |
|
|
Global |
No |
- Variable: report_port |
|
|
Yes |
|
Global |
No |
report-user |
Yes |
Yes |
|
|
Global |
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_number_loaded_rules |
|
|
|
Yes |
Global |
No |
Rewriter_number_reloads |
|
|
|
Yes |
Global |
No |
Rewriter_number_rewritten_queries |
|
|
|
Yes |
Global |
No |
Rewriter_reload_error |
|
|
|
Yes |
Global |
No |
rewriter_verbose |
|
|
Yes |
|
Global |
Yes |
rpl_read_size |
Yes |
Yes |
Yes |
|
Global |
Yes |
Rpl_semi_sync_master_clients |
|
|
|
Yes |
Global |
No |
rpl_semi_sync_master_enabled |
|
|
Yes |
|
Global |
Yes |
Rpl_semi_sync_master_net_avg_wait_time |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_net_wait_time |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_net_waits |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_no_times |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_no_tx |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_status |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_timefunc_failures |
|
|
|
Yes |
Global |
No |
rpl_semi_sync_master_timeout |
|
|
Yes |
|
Global |
Yes |
rpl_semi_sync_master_trace_level |
|
|
Yes |
|
Global |
Yes |
Rpl_semi_sync_master_tx_avg_wait_time |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_tx_wait_time |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_tx_waits |
|
|
|
Yes |
Global |
No |
rpl_semi_sync_master_wait_for_slave_count |
|
|
Yes |
|
Global |
Yes |
rpl_semi_sync_master_wait_no_slave |
|
|
Yes |
|
Global |
Yes |
rpl_semi_sync_master_wait_point |
|
|
Yes |
|
Global |
Yes |
Rpl_semi_sync_master_wait_pos_backtraverse |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_wait_sessions |
|
|
|
Yes |
Global |
No |
Rpl_semi_sync_master_yes_tx |
|
|
|
Yes |
Global |
No |
rpl_semi_sync_slave_enabled |
|
|
Yes |
|
Global |
Yes |
Rpl_semi_sync_slave_status |
|
|
|
Yes |
Global |
No |
rpl_semi_sync_slave_trace_level |
|
|
Yes |
|
Global |
Yes |
rpl_stop_slave_timeout |
Yes |
Yes |
Yes |
|
Global |
Yes |
Rsa_public_key |
|
|
|
Yes |
Global |
No |
safe-user-create |
Yes |
Yes |
|
|
|
|
schema_definition_cache |
Yes |
Yes |
Yes |
|
Global |
Yes |
Secondary_engine_execution_count |
|
|
|
Yes |
Both |
No |
secure-auth |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: secure_auth |
|
|
Yes |
|
Global |
Yes |
secure-file-priv |
Yes |
Yes |
|
|
Global |
No |
- Variable: secure_file_priv |
|
|
Yes |
|
Global |
No |
Select_full_join |
|
|
|
Yes |
Both |
No |
Select_full_range_join |
|
|
|
Yes |
Both |
No |
Select_range |
|
|
|
Yes |
Both |
No |
Select_range_check |
|
|
|
Yes |
Both |
No |
Select_scan |
|
|
|
Yes |
Both |
No |
server-id |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: server_id |
|
|
Yes |
|
Global |
Yes |
server-id-bits |
Yes |
Yes |
|
|
Global |
No |
- Variable: server_id_bits |
|
|
Yes |
|
Global |
No |
server_id_bits |
Yes |
Yes |
Yes |
|
Global |
No |
server_uuid |
|
|
Yes |
|
Global |
No |
session_track_gtids |
Yes |
Yes |
Yes |
|
Both |
Yes |
session_track_schema |
Yes |
Yes |
Yes |
|
Both |
Yes |
session_track_state_change |
Yes |
Yes |
Yes |
|
Both |
Yes |
session_track_system_variables |
Yes |
Yes |
Yes |
|
Both |
Yes |
session_track_transaction_info |
Yes |
Yes |
Yes |
|
Both |
Yes |
sha256_password_auto_generate_rsa_keys |
Yes |
Yes |
Yes |
|
Global |
No |
sha256_password_private_key_path |
Yes |
Yes |
Yes |
|
Global |
No |
sha256_password_proxy_users |
Yes |
Yes |
Yes |
|
Global |
Yes |
sha256_password_public_key_path |
Yes |
Yes |
Yes |
|
Global |
No |
shared_memory |
Yes |
Yes |
Yes |
|
Global |
No |
shared_memory_base_name |
Yes |
Yes |
Yes |
|
Global |
No |
show_compatibility_56 |
Yes |
Yes |
Yes |
|
Global |
Yes |
show_create_table_verbosity |
Yes |
Yes |
Yes |
|
Both |
Yes |
show_old_temporals |
Yes |
Yes |
Yes |
|
Both |
Yes |
show-slave-auth-info |
Yes |
Yes |
|
|
|
|
simplified_binlog_gtid_recovery |
Yes |
Yes |
Yes |
|
Global |
No |
skip-character-set-client-handshake |
Yes |
Yes |
|
|
|
|
skip-concurrent-insert |
Yes |
Yes |
|
|
|
|
- Variable: concurrent_insert |
|
|
|
|
|
|
skip-event-scheduler |
Yes |
Yes |
|
|
|
|
skip_external_locking |
Yes |
Yes |
Yes |
|
Global |
No |
skip-grant-tables |
Yes |
Yes |
|
|
|
|
skip-host-cache |
Yes |
Yes |
|
|
|
|
skip-name-resolve |
Yes |
Yes |
|
|
Global |
No |
- Variable: skip_name_resolve |
|
|
Yes |
|
Global |
No |
skip-ndbcluster |
Yes |
Yes |
|
|
|
|
skip-networking |
Yes |
Yes |
|
|
Global |
No |
- Variable: skip_networking |
|
|
Yes |
|
Global |
No |
skip-new |
Yes |
Yes |
|
|
|
|
skip-show-database |
Yes |
Yes |
|
|
Global |
No |
- Variable: skip_show_database |
|
|
Yes |
|
Global |
No |
skip-slave-start |
Yes |
Yes |
|
|
|
|
skip-ssl |
Yes |
Yes |
|
|
|
|
skip-stack-trace |
Yes |
Yes |
|
|
|
|
slave_allow_batching |
Yes |
Yes |
Yes |
|
Global |
Yes |
slave-checkpoint-group |
Yes |
Yes |
|
|
|
|
- Variable: slave_checkpoint_group |
|
|
|
|
|
|
slave_checkpoint_group |
Yes |
Yes |
Yes |
|
Global |
Yes |
slave-checkpoint-period |
Yes |
Yes |
|
|
|
|
- Variable: slave_checkpoint_period |
|
|
|
|
|
|
slave_checkpoint_period |
Yes |
Yes |
Yes |
|
Global |
Yes |
slave_compressed_protocol |
Yes |
Yes |
Yes |
|
Global |
Yes |
slave_exec_mode |
Yes |
Yes |
Yes |
|
Global |
Yes |
Slave_heartbeat_period |
|
|
|
Yes |
Global |
No |
Slave_last_heartbeat |
|
|
|
Yes |
Global |
No |
slave-load-tmpdir |
Yes |
Yes |
|
|
Global |
No |
- Variable: slave_load_tmpdir |
|
|
Yes |
|
Global |
No |
slave-max-allowed-packet |
Yes |
Yes |
|
|
|
|
- Variable: slave_max_allowed_packet |
|
|
|
|
|
|
slave_max_allowed_packet |
|
|
Yes |
|
Global |
Yes |
slave-net-timeout |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: slave_net_timeout |
|
|
Yes |
|
Global |
Yes |
Slave_open_temp_tables |
|
|
|
Yes |
Global |
No |
slave-parallel-type |
Yes |
Yes |
|
|
|
|
- Variable: slave_parallel_type |
|
|
|
|
|
|
slave_parallel_type |
|
|
Yes |
|
Global |
Yes |
slave-parallel-workers |
Yes |
Yes |
|
|
|
|
- Variable: slave_parallel_workers |
|
|
|
|
|
|
slave_parallel_workers |
Yes |
|
Yes |
|
Global |
Yes |
slave-pending-jobs-size-max |
Yes |
|
|
|
|
|
- Variable: slave_pending_jobs_size_max |
|
|
|
|
|
|
slave_pending_jobs_size_max |
Yes |
|
Yes |
|
Global |
Yes |
slave_preserve_commit_order |
Yes |
|
Yes |
|
Global |
Yes |
Slave_received_heartbeats |
|
|
|
Yes |
Global |
No |
Slave_retried_transactions |
|
|
|
Yes |
Global |
No |
Slave_rows_last_search_algorithm_used |
|
|
|
Yes |
Global |
No |
slave-rows-search-algorithms |
Yes |
Yes |
|
|
|
|
- Variable: slave_rows_search_algorithms |
|
|
|
|
|
|
slave_rows_search_algorithms |
|
|
Yes |
|
Global |
Yes |
Slave_running |
|
|
|
Yes |
Global |
No |
slave-skip-errors |
Yes |
Yes |
|
|
Global |
No |
- Variable: slave_skip_errors |
|
|
Yes |
|
Global |
No |
slave-sql-verify-checksum |
Yes |
Yes |
|
|
|
|
slave_sql_verify_checksum |
|
|
Yes |
|
Global |
Yes |
slave_transaction_retries |
Yes |
Yes |
Yes |
|
Global |
Yes |
slave_type_conversions |
Yes |
Yes |
Yes |
|
Global |
No |
Slow_launch_threads |
|
|
|
Yes |
Both |
No |
slow_launch_time |
Yes |
Yes |
Yes |
|
Global |
Yes |
Slow_queries |
|
|
|
Yes |
Both |
No |
slow-query-log |
Yes |
Yes |
|
|
Global |
Yes |
- Variable: slow_query_log |
|
|
Yes |
|
Global |
Yes |
slow_query_log_file |
Yes |
Yes |
Yes |
|
Global |
Yes |
slow-start-timeout |
Yes |
Yes |
|
|
|
|
socket |
Yes |
Yes |
Yes |
|
Global |
No |
sort_buffer_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
Sort_merge_passes |
|
|
|
Yes |
Both |
No |
Sort_range |
|
|
|
Yes |
Both |
No |
Sort_rows |
|
|
|
Yes |
Both |
No |
Sort_scan |
|
|
|
Yes |
Both |
No |
sporadic-binlog-dump-fail |
Yes |
Yes |
|
|
|
|
sql_auto_is_null |
|
|
Yes |
|
Both |
Yes |
sql_big_selects |
|
|
Yes |
|
Both |
Yes |
sql_buffer_result |
|
|
Yes |
|
Both |
Yes |
sql_log_bin |
|
|
Yes |
|
Session |
Yes |
sql_log_off |
|
|
Yes |
|
Both |
Yes |
sql-mode |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: sql_mode |
|
|
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 |
Yes |
Yes |
|
|
|
|
Ssl_accept_renegotiates |
|
|
|
Yes |
Global |
No |
Ssl_accepts |
|
|
|
Yes |
Global |
No |
ssl-ca |
Yes |
Yes |
|
|
Global |
No |
- Variable: ssl_ca |
|
|
Yes |
|
Global |
No |
Ssl_callback_cache_hits |
|
|
|
Yes |
Global |
No |
ssl-capath |
Yes |
Yes |
|
|
Global |
No |
- Variable: ssl_capath |
|
|
Yes |
|
Global |
No |
ssl-cert |
Yes |
Yes |
|
|
Global |
No |
- Variable: ssl_cert |
|
|
Yes |
|
Global |
No |
Ssl_cipher |
|
|
|
Yes |
Both |
No |
ssl-cipher |
Yes |
Yes |
|
|
Global |
No |
- Variable: ssl_cipher |
|
|
Yes |
|
Global |
No |
Ssl_cipher_list |
|
|
|
Yes |
Both |
No |
Ssl_client_connects |
|
|
|
Yes |
Global |
No |
Ssl_connect_renegotiates |
|
|
|
Yes |
Global |
No |
ssl-crl |
Yes |
Yes |
|
|
Global |
No |
- Variable: ssl_crl |
|
|
Yes |
|
Global |
No |
ssl-crlpath |
Yes |
Yes |
|
|
Global |
No |
- Variable: ssl_crlpath |
|
|
Yes |
|
Global |
No |
Ssl_ctx_verify_depth |
|
|
|
Yes |
Global |
No |
Ssl_ctx_verify_mode |
|
|
|
Yes |
Global |
No |
Ssl_default_timeout |
|
|
|
Yes |
Both |
No |
Ssl_finished_accepts |
|
|
|
Yes |
Global |
No |
Ssl_finished_connects |
|
|
|
Yes |
Global |
No |
ssl_fips_mode |
Yes |
Yes |
Yes |
|
Global |
Yes |
ssl-key |
Yes |
Yes |
|
|
Global |
No |
- Variable: ssl_key |
|
|
Yes |
|
Global |
No |
Ssl_server_not_after |
|
|
|
Yes |
Both |
No |
Ssl_server_not_before |
|
|
|
Yes |
Both |
No |
Ssl_session_cache_hits |
|
|
|
Yes |
Global |
No |
Ssl_session_cache_misses |
|
|
|
Yes |
Global |
No |
Ssl_session_cache_mode |
|
|
|
Yes |
Global |
No |
Ssl_session_cache_overflows |
|
|
|
Yes |
Global |
No |
Ssl_session_cache_size |
|
|
|
Yes |
Global |
No |
Ssl_session_cache_timeouts |
|
|
|
Yes |
Global |
No |
Ssl_sessions_reused |
|
|
|
Yes |
Both |
No |
Ssl_used_session_cache_entries |
|
|
|
Yes |
Global |
No |
Ssl_verify_depth |
|
|
|
Yes |
Both |
No |
Ssl_verify_mode |
|
|
|
Yes |
Both |
No |
Ssl_version |
|
|
|
Yes |
Both |
No |
standalone |
Yes |
Yes |
|
|
|
|
stored_program_cache |
Yes |
Yes |
Yes |
|
Global |
Yes |
stored_program_definition_cache |
Yes |
Yes |
Yes |
|
Global |
Yes |
super-large-pages |
Yes |
Yes |
|
|
|
|
super_read_only |
Yes |
Yes |
Yes |
|
Global |
Yes |
symbolic-links |
Yes |
Yes |
|
|
|
|
sync_binlog |
Yes |
Yes |
Yes |
|
Global |
Yes |
sync_master_info |
Yes |
Yes |
Yes |
|
Global |
Yes |
sync_relay_log |
Yes |
Yes |
Yes |
|
Global |
Yes |
sync_relay_log_info |
Yes |
Yes |
Yes |
|
Global |
Yes |
sysdate-is-now |
Yes |
Yes |
|
|
|
|
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 |
|
Global |
Yes |
Table_locks_immediate |
|
|
|
Yes |
Global |
No |
Table_locks_waited |
|
|
|
Yes |
Global |
No |
table_open_cache |
|
|
Yes |
|
Global |
Yes |
Table_open_cache_hits |
|
|
|
Yes |
Both |
No |
table_open_cache_instances |
|
|
Yes |
|
Global |
No |
Table_open_cache_misses |
|
|
|
Yes |
Both |
No |
Table_open_cache_overflows |
|
|
|
Yes |
Both |
No |
tablespace_definition_cache |
Yes |
Yes |
Yes |
|
Global |
Yes |
tc-heuristic-recover |
Yes |
Yes |
|
|
|
|
Tc_log_max_pages_used |
|
|
|
Yes |
Global |
No |
Tc_log_page_size |
|
|
|
Yes |
Global |
No |
Tc_log_page_waits |
|
|
|
Yes |
Global |
No |
temp-pool |
Yes |
Yes |
|
|
|
|
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 |
Threads_cached |
|
|
|
Yes |
Global |
No |
Threads_connected |
|
|
|
Yes |
Global |
No |
Threads_created |
|
|
|
Yes |
Global |
No |
Threads_running |
|
|
|
Yes |
Global |
No |
time_format |
|
|
Yes |
|
Global |
No |
time_zone |
|
|
Yes |
|
Both |
Yes |
timestamp |
|
|
Yes |
|
Session |
Yes |
tls_version |
Yes |
Yes |
Yes |
|
Global |
No |
tmp_table_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
tmpdir |
Yes |
Yes |
Yes |
|
Global |
No |
transaction_alloc_block_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
transaction_allow_batching |
|
|
Yes |
|
Session |
Yes |
transaction-isolation |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: transaction_isolation |
|
|
Yes |
|
Both |
Yes |
transaction_prealloc_size |
Yes |
Yes |
Yes |
|
Both |
Yes |
transaction-read-only |
Yes |
Yes |
|
|
Both |
Yes |
- Variable: transaction_read_only |
|
|
Yes |
|
Both |
Yes |
transaction_write_set_extraction |
Yes |
|
Yes |
|
Both |
Yes |
tx_isolation |
|
|
Yes |
|
Both |
Yes |
tx_read_only |
|
|
Yes |
|
Both |
Yes |
unique_checks |
|
|
Yes |
|
Both |
Yes |
updatable_views_with_limit |
Yes |
Yes |
Yes |
|
Both |
Yes |
Uptime |
|
|
|
Yes |
Global |
No |
Uptime_since_flush_status |
|
|
|
Yes |
Global |
No |
use_secondary_engine |
|
|
Yes |
|
Session |
Yes |
user |
Yes |
Yes |
|
|
|
|
validate-config |
Yes |
Yes |
|
|
|
|
validate-password |
Yes |
Yes |
|
|
|
|
validate_password_check_user_name |
Yes |
Yes |
Yes |
|
Global |
Yes |
validate_password_dictionary_file |
|
|
Yes |
|
Global |
Yes |
validate_password_dictionary_file_last_parsed |
|
|
|
Yes |
Global |
No |
validate_password_dictionary_file_words_count |
|
|
|
Yes |
Global |
No |
validate_password_length |
|
|
Yes |
|
Global |
Yes |
validate_password_mixed_case_count |
|
|
Yes |
|
Global |
Yes |
validate_password_number_count |
|
|
Yes |
|
Global |
Yes |
validate_password_policy |
|
|
Yes |
|
Global |
Yes |
validate_password_special_char_count |
|
|
Yes |
|
Global |
Yes |
validate_password.check_user_name |
Yes |
Yes |
Yes |
|
Global |
Yes |
validate_password.dictionary_file |
|
|
Yes |
|
Global |
Yes |
validate_password.dictionary_file_last_parsed |
|
|
|
Yes |
Global |
No |
validate_password.dictionary_file_words_count |
|
|
|
Yes |
Global |
No |
validate_password.length |
|
|
Yes |
|
Global |
Yes |
validate_password.mixed_case_count |
|
|
Yes |
|
Global |
Yes |
validate_password.number_count |
|
|
Yes |
|
Global |
Yes |
validate_password.policy |
|
|
Yes |
|
Global |
Yes |
validate_password.special_char_count |
|
|
Yes |
|
Global |
Yes |
validate_user_plugins |
|
|
Yes |
|
Global |
No |
verbose |
Yes |
Yes |
|
|
|
|
version |
|
|
Yes |
|
Global |
No |
version_comment |
|
|
Yes |
|
Global |
No |
version_compile_machine |
|
|
Yes |
|
Global |
No |
version_compile_os |
|
|
Yes |
|
Global |
No |
version_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 |