Chapter 5 MySQL Server Administration


内容表

5.1 The MySQL Server
5.1.1 Configuring the Server
5.1.2 Server Configuration Defaults
5.1.3 Server Configuration Validation
5.1.4 Server Option, System Variable, and Status Variable Reference
5.1.5 Server System Variable Reference
5.1.6 Server Status Variable Reference
5.1.7 Server Command Options
5.1.8 Server System Variables
5.1.9 Using System Variables
5.1.10 Server Status Variables
5.1.11 Server SQL Modes
5.1.12 IPv6 Support
5.1.13 MySQL Server Time Zone Support
5.1.14 Server Tracking of Client Session State Changes
5.1.15 Server-Side Help
5.1.16 Server Response to Signals
5.1.17 The Server Shutdown Process
5.2 The MySQL Data Directory
5.3 The mysql System Database
5.4 MySQL Server Logs
5.4.1 Selecting General Query Log and Slow Query Log Output Destinations
5.4.2 The Error Log
5.4.3 The General Query Log
5.4.4 The Binary Log
5.4.5 The Slow Query Log
5.4.6 The DDL Log
5.4.7 Server Log Maintenance
5.5 MySQL Server Components
5.5.1 Installing and Uninstalling Components
5.5.2 Obtaining Server Component Information
5.5.3 Error Log Components
5.6 MySQL Server Plugins
5.6.1 Installing and Uninstalling Plugins
5.6.2 Obtaining Server Plugin Information
5.6.3 MySQL Enterprise Thread Pool
5.6.4 The Rewriter Query Rewrite Plugin
5.6.5 Version Tokens
5.7 MySQL Server User-Defined Functions
5.7.1 Installing and Uninstalling User-Defined Functions
5.7.2 Obtaining User-Defined Function Information
5.8 Running Multiple MySQL Instances on One Machine
5.8.1 Setting Up Multiple Data Directories
5.8.2 Running Multiple MySQL Instances on Windows
5.8.3 Running Multiple MySQL Instances on Unix
5.8.4 Using Client Programs in a Multiple-Server Environment

MySQL Server ( mysqld ) is the main program that does most of the work in a MySQL installation. This chapter provides an overview of MySQL Server and covers general server administration:

  • Server configuration

  • The data directory, particularly the mysql system database

  • The server log files

  • Management of multiple servers on a single machine

For additional information on administrative topics, see also:

5.1 The MySQL Server

mysqld is the MySQL server. The following discussion covers these MySQL server configuration topics:

  • Startup options that the server supports. You can specify these options on the command line, through configuration files, or both.

  • Server system variables. These variables reflect the current state and values of the startup options, some of which can be modified while the server is running.

  • Server status variables. These variables contain counters and statistics about runtime operation.

  • How to set the server SQL mode. This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations.

  • Configuring and using IPv6 support.

  • Configuring and using time zone support.

  • Server-side help capabilities.

  • The server shutdown process. There are performance and reliability considerations depending on the type of table (transactional or nontransactional) and whether you use replication.

For listings of MySQL server variables and options that have been added, deprecated, or removed in MySQL 8.0, see Section 1.5, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0” .

Note

Not all storage engines are supported by all MySQL server binaries and configurations. To find out how to determine which storage engines your MySQL server installation supports, see Section 13.7.6.16, “SHOW ENGINES Syntax” .

5.1.1 Configuring the Server

The MySQL server, mysqld , has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command:

shell> mysqld --verbose --help
                        

The command produces a list of all mysqld options and configurable system variables. Its output includes the default option and variable values and looks something like this:

abort-slave-event-count           0
allow-suspicious-udfs             FALSE
archive                           ON
auto-increment-increment          1
auto-increment-offset             1
autocommit                        TRUE
automatic-sp-privileges           TRUE
avoid-temporal-upgrade            FALSE
back-log                          80
basedir                           /home/jon/bin/mysql-8.0/
...
tmpdir                            /tmp
transaction-alloc-block-size      8192
transaction-isolation             REPEATABLE-READ
transaction-prealloc-size         4096
transaction-read-only             FALSE
transaction-write-set-extraction  OFF
updatable-views-with-limit        YES
validate-user-plugins             TRUE
verbose                           TRUE
wait-timeout                      28800
                        

To see the current system variable values actually used by the server as it runs, connect to it and execute this statement:

mysql> SHOW VARIABLES;
                        

To see some statistical and status indicators for a running server, execute this statement:

mysql> SHOW STATUS;
                        

System variable and status information also is available using the mysqladmin command:

shell> mysqladmin variables
shell> mysqladmin extended-status
                        

For a full description of all command options, system variables, and status variables, see these sections:

More detailed monitoring information is available from the Performance Schema; see Chapter 26, MySQL Performance Schema . In addition, the MySQL sys schema is a set of objects that provides convenient access to data collected by the Performance Schema; see Chapter 27, MySQL sys Schema .

If you specify an option on the command line for mysqld or mysqld_safe , it remains in effect only for that invocation of the server. To use the option every time the server runs, put it in an option file. See Section 4.2.7, “Using Option Files” .

5.1.2 Server Configuration Defaults

The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option files). It is also possible to change many parameters at runtime. For general instructions on setting parameters at startup or runtime, see Section 5.1.7, “Server Command Options” , and Section 5.1.8, “Server System Variables” .

On Windows, MySQL Installer interacts with the user and creates a file named my.ini in the base installation directory as the default option file.

Note

On Windows, the .ini or .cnf option file extension might not be displayed.

After completing the installation process, you can edit the default option file at any time to modify the parameters used by the server. For example, to use a parameter setting in the file that is commented with a # character at the beginning of the line, remove the # , and modify the parameter value if necessary. To disable a setting, either add a # to the beginning of the line or remove it.

For non-Windows platforms, no default option file is created during either the server installation or the data directory initialization process. Create your option file by following the instructions given in Section 4.2.7, “Using Option Files” . Without an option file, the server just starts with its default settings—see Section 5.1.2, “Server Configuration Defaults” on how to check those settings.

For additional information about option file format and syntax, see Section 4.2.7, “Using Option Files” .

5.1.3 Server Configuration Validation

As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode:

mysqld --validate-config
                        

If no errors are found, the server terminates with an exit code of 0. If an error is found, the server displays a diagnostic message and terminates with an exit code of 1. For example:

shell> mysqld --validate-config --no-such-option
2018-11-05T17:50:12.738919Z 0 [ERROR] [MY-000068] [Server] unknown
option '--no-such-option'.
2018-11-05T17:50:12.738962Z 0 [ERROR] [MY-010119] [Server] Aborting
                        

The server terminates as soon as any error is found. For additional checks to occur, correct the initial problem and run the server with --validate-config again.

For the preceding example, where use of --validate-config results in display of an error message, the server exit code is 1. Warnings and information messages may also be displayed, depending on the log_error_verbosity value, but do not produce immediate validation termination or an exit code of 1. For example, this command produces multiple warnings, both of which are displayed. But no error occurs, so the exit code is 0:

shell> mysqld --validate-config --log_error_verbosity=2
         --read-only=s --transaction_read_only=s
2018-11-05T15:43:18.445863Z 0 [Warning] [MY-000076] [Server] option
'read_only': boolean value 's' was not recognized. Set to OFF.
2018-11-05T15:43:18.445882Z 0 [Warning] [MY-000076] [Server] option
'transaction-read-only': boolean value 's' was not recognized. Set to OFF.
                        

This command produces the same warnings, but also an error, so the error message is displayed along with the warnings and the exit code is 1:

shell> mysqld --validate-config --log_error_verbosity=2
         --no-such-option --read-only=s --transaction_read_only=s
2018-11-05T15:43:53.152886Z 0 [Warning] [MY-000076] [Server] option
'read_only': boolean value 's' was not recognized. Set to OFF.
2018-11-05T15:43:53.152913Z 0 [Warning] [MY-000076] [Server] option
'transaction-read-only': boolean value 's' was not recognized. Set to OFF.
2018-11-05T15:43:53.164889Z 0 [ERROR] [MY-000068] [Server] unknown
option '--no-such-option'.
2018-11-05T15:43:53.165053Z 0 [ERROR] [MY-010119] [Server] Aborting
                        

The scope of the --validate-config option is limited to configuration checking that the server can perform without undergoing its normal startup process. As such, the configuration check does not initialize storage engines and other plugins, components, and so forth, and does not validate options associated with those uninitialized subsystems.

--validate-config can be used any time, but is particularly useful after an upgrade, to check whether any options previously used with the older server are considered by the upgraded server to be deprecated or obsolete. For example, the tx_read_only system variable was deprecated in MySQL 5.7 and removed in 8.0. Suppose that a MySQL 5.7 server was run using that system variable in its my.cnf file and then upgraded to MySQL 8.0. Running the upgraded server with --validate-config to check the configuration produces this result:

shell> mysqld --validate-config
2018-11-05T10:40:02.712141Z 0 [ERROR] [MY-000067] [Server] unknown variable
'tx_read_only=ON'.
2018-11-05T10:40:02.712178Z 0 [ERROR] [MY-010119] [Server] Aborting
                        

--validate-config can be used with the --defaults-file option to validate only the options in a specific file:

shell> mysqld --defaults-file=./my.cnf-test --validate-config
2018-11-05T10:40:02.712141Z 0 [ERROR] [MY-000067] [Server] unknown variable
'tx_read_only=ON'.
2018-11-05T10:40:02.712178Z 0 [ERROR] [MY-010119] [Server] Aborting
                        

Remember that --defaults-file , if specified, must be the first option on the command line. (Executing the preceding example with the option order reversed produces a message that --defaults-file itself is unknown.)

5.1.4 Server Option, System Variable, and Status Variable Reference

The following table lists all command-line options, system variables, and status variables applicable within mysqld .

The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in one unified list, with an indication of where each option or variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding option. For system and status variables, the scope of the variable (Var Scope) is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the options and variables. Where appropriate, direct links to further information about the items are provided.

For a version of this table that is specific to NDB Cluster, see Section 22.3.2.5, “NDB Cluster mysqld Option and Variable Reference” .

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

Name Cmd-Line Option File System Var Status Var Var Scope Dynamic
abort-slave-event-count Yes Yes
Aborted_clients Yes Global No
Aborted_connects Yes Global No
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_open_tables Yes Both No
Com_show_plugins Yes Both No
Com_show_privileges Yes Both No
Com_show_procedure_code Yes Both No
Com_show_procedure_status Yes Both No
Com_show_processlist Yes Both No
Com_show_profile Yes Both No
Com_show_profiles Yes Both No
Com_show_relaylog_events Yes Both No
Com_show_slave_hosts Yes Both No
Com_show_slave_status Yes Both No
Com_show_status Yes Both No
Com_show_storage_engines Yes Both No
Com_show_table_status Yes Both No
Com_show_tables Yes Both No
Com_show_triggers Yes Both No
Com_show_variables Yes Both No
Com_show_warnings Yes Both No
Com_shutdown Yes Both No
Com_signal Yes Both No
Com_slave_start Yes Both No
Com_slave_stop Yes Both No
Com_stmt_close Yes Both No
Com_stmt_execute Yes Both No
Com_stmt_fetch Yes Both No
Com_stmt_prepare Yes Both No
Com_stmt_reprepare Yes Both No
Com_stmt_reset Yes Both No
Com_stmt_send_long_data Yes Both No
Com_truncate Yes Both No
Com_uninstall_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 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_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_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-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
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