System Variable Index
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W
audit_log_buffer_size
audit_log_compression
audit_log_connection_policy
audit_log_current_session
audit_log_encryption
audit_log_exclude_accounts
audit_log_file
audit_log_filter_id
audit_log_flush
audit_log_format
audit_log_include_accounts
audit_log_policy
audit_log_read_buffer_size
audit_log_rotate_on_size
audit_log_statement_policy
audit_log_strategy
authentication_ldap_sasl_auth_method_name
authentication_ldap_sasl_bind_base_dn
authentication_ldap_sasl_bind_root_dn
authentication_ldap_sasl_bind_root_pwd
authentication_ldap_sasl_ca_path
authentication_ldap_sasl_group_search_attr
authentication_ldap_sasl_group_search_filter
authentication_ldap_sasl_init_pool_size
authentication_ldap_sasl_log_status
authentication_ldap_sasl_max_pool_size
authentication_ldap_sasl_server_host
authentication_ldap_sasl_server_port
authentication_ldap_sasl_tls
authentication_ldap_sasl_user_search_attr
authentication_ldap_simple_auth_method_name
authentication_ldap_simple_bind_base_dn
authentication_ldap_simple_bind_root_dn
authentication_ldap_simple_bind_root_pwd
authentication_ldap_simple_ca_path
authentication_ldap_simple_group_search_attr
authentication_ldap_simple_group_search_filter
authentication_ldap_simple_init_pool_size
authentication_ldap_simple_log_status
authentication_ldap_simple_max_pool_size
authentication_ldap_simple_server_host
authentication_ldap_simple_server_port
authentication_ldap_simple_tls
authentication_ldap_simple_user_search_attr
authentication_windows_log_level
authentication_windows_use_principal_name
auto_generate_certs
auto_increment_increment
- Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
- Section 17.8, “Frequently Asked Questions”
- Section 17.6, “Group Replication System Variables”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.1, “MySQL 5.7 FAQ: General”
- Section 21.4.14, “ndb_import — Import CSV Data Into NDB”
- Section 16.4.1.37, “Replication and Variables”
- Section 16.1.6.2, “Replication Source Options and Variables”
- Section 3.6.9, “Using AUTO_INCREMENT”
auto_increment_offset
- Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
- Section 17.8, “Frequently Asked Questions”
- Section 17.6, “Group Replication System Variables”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.1, “MySQL 5.7 FAQ: General”
- Section 21.4.14, “ndb_import — Import CSV Data Into NDB”
- Section 16.4.1.37, “Replication and Variables”
- Section 16.1.6.2, “Replication Source Options and Variables”
- Section 3.6.9, “Using AUTO_INCREMENT”
autocommit
- Section 14.7.2.2, “autocommit, Commit, and Rollback”
- Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
- Section 14.7.5.2, “Deadlock Detection and Rollback”
- Section 13.2.2, “DELETE Statement”
- Section 14.7, “InnoDB Locking and Transaction Model”
- Section 14.15, “InnoDB Startup Options and System Variables”
- Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
- Section 14.7.2.4, “Locking Reads”
- Section 14.7.3, “Locks Set by Different SQL Statements in InnoDB”
- Section 14.6.1.4, “Moving or Copying InnoDB Tables”
- Section 27.7.6.65, “mysql_session_track_get_first()”
- Section 21.3.3.9.2, “NDB Cluster System Variables”
- Section 8.5.3, “Optimizing InnoDB Read-Only Transactions”
- Section 25.12.7, “Performance Schema Transaction Tables”
- Section 14.8.10, “Purge Configuration”
- Section 16.4.1.33, “Replication and Transactions”
- Section 16.1.3.6, “Restrictions on Replication with GTIDs”
- Section 5.1.7, “Server System Variables”
- Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
- Section 24.32.27, “The INFORMATION_SCHEMA INNODB_TRX Table”
- Section 5.5.3.3, “Thread Pool Operation”
- Section 14.7.2.1, “Transaction Isolation Levels”
automatic_sp_privileges
avoid_temporal_upgrade
basedir
big_tables
bind_address
- Section B.4.2.2, “Can't connect to [local] MySQL server”
- Section 5.1.12.2, “Configuring the MySQL Server to Permit IPv6 Connections”
- Section 5.1.12.4, “Connecting Using IPv6 Nonlocal Host Addresses”
- Section 5.1.12.3, “Connecting Using the IPv6 Local Host Address”
- Section 17.5.1, “Group Replication IP Address Allowlisting”
- Section 5.1.12, “IPv6 Support”
- Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
- Section 5.1.12.5, “Obtaining an IPv6 Address from a Broker”
- Section 5.7, “Running Multiple MySQL Instances on One Machine”
- Section 5.1.7, “Server System Variables”
- Section 21.5.14.30, “The ndbinfo processes Table”
- Section 6.2.17, “Troubleshooting Problems Connecting to MySQL”
- Section 19.4.2.2, “X Plugin Options and System Variables”
binlog
binlog_cache_size
binlog_checksum
binlog_direct_non_transactional_updates
binlog_error_action
binlog_format
- Section 16.1.6.4, “Binary Logging Options and Variables”
- Section 2.11.3, “Changes in MySQL 5.7”
- Section 12.6, “Date and Time Functions”
- Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 16.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”
- Section 16.2.5.2, “Evaluation of Table-Level Replication Options”
- Section 16.1.3.2, “GTID Life Cycle”
- Section 12.15, “Information Functions”
- Section 16.2.5.3, “Interactions Between Replication Filtering Options”
- Section 12.14, “Locking Functions”
- Section 5.4.4.4, “Logging Format for Changes to mysql Database Tables”
- Section 12.5.2, “Mathematical Functions”
- Section 12.21, “Miscellaneous Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.14, “MySQL 5.7 FAQ: Replication”
- Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 16.1.6.3, “Replica Server Options and Variables”
- Section 16.4.1.2, “Replication and BLACKHOLE Tables”
- Section 16.4.1.18, “Replication and LOAD DATA”
- Section 16.4.1.20, “Replication and MEMORY Tables”
- Section 16.4.1.29, “Replication and Temporary Tables”
- Section 16.4.1.33, “Replication and Transactions”
- Section 16.2.1, “Replication Formats”
- Section 16.4.1.21, “Replication of the mysql System Database”
- Section 16.1.3.6, “Restrictions on Replication with GTIDs”
- Section 13.3.7.3, “Restrictions on XA Transactions”
- Section B.3.1, “Server Error Message Reference”
- Section 5.4.4.2, “Setting The Binary Log Format”
- Section 23.7, “Stored Program Binary Logging”
- Section 5.1.8.1, “System Variable Privileges”
- Section 15.6, “The BLACKHOLE Storage Engine”
- Section 5.4.3, “The General Query Log”
- Section 14.21.6, “The InnoDB memcached Plugin and Replication”
- Section 5.4.5, “The Slow Query Log”
- Section 14.7.2.1, “Transaction Isolation Levels”
- Section 16.4.3, “Upgrading a Replication Setup”
- Section 16.2.1.2, “Usage of Row-Based Logging and Replication”
binlog_group_commit_sync_delay
binlog_group_commit_sync_no_delay_count
binlog_gtid_simple_recovery
binlog_max_flush_queue_time
binlog_order_commits
binlog_row_image
binlog_rows_query_log_events
binlog_stmt_cache_size
binlog_transaction_dependency_history_size
binlog_transaction_dependency_tracking
block_encryption_mode
bulk_insert_buffer_size
character_set_client
- Section 27.7.8.1, “C API Prepared Statement Type Codes”
- Section 10.15, “Character Set Configuration”
- Section 10.4, “Connection Character Sets and Collations”
- Section 13.2.6, “LOAD DATA Statement”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 27.7.6.65, “mysql_session_track_get_first()”
- Section 16.4.1.37, “Replication and Variables”
- Section 5.1.7, “Server System Variables”
- Section 13.7.4.2, “SET CHARACTER SET Statement”
- Section 13.7.4.3, “SET NAMES Statement”
- Section 13.7.5.7, “SHOW CREATE EVENT Statement”
- Section 13.7.5.9, “SHOW CREATE PROCEDURE Statement”
- Section 13.7.5.11, “SHOW CREATE TRIGGER Statement”
- Section 13.7.5.13, “SHOW CREATE VIEW Statement”
- Section 13.7.5.18, “SHOW EVENTS Statement”
- Section 13.7.5.28, “SHOW PROCEDURE STATUS Statement”
- Section 13.7.5.38, “SHOW TRIGGERS Statement”
- Section 5.4.4, “The Binary Log”
- Section 24.8, “The INFORMATION_SCHEMA EVENTS Table”
- Section 24.21, “The INFORMATION_SCHEMA ROUTINES Table”
- Section 24.29, “The INFORMATION_SCHEMA TRIGGERS Table”
- Section 24.31, “The INFORMATION_SCHEMA VIEWS Table”
- Section 5.5.4.2, “Using the Rewriter Query Rewrite Plugin”
character_set_connection
- Section 12.10, “Cast Functions and Operators”
- Section 12.7.3, “Character Set and Collation of Function Results”
- Section 10.3.8, “Character Set Introducers”
- Section 10.2.1, “Character Set Repertoire”
- Section 10.3.6, “Character String Literal Character Set and Collation”
- Section 10.8.4, “Collation Coercibility in Expressions”
- Section 10.4, “Connection Character Sets and Collations”
- Section 12.6, “Date and Time Functions”
- Section 12.13, “Encryption and Compression Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 10.16, “MySQL Server Locale Support”
- Section 27.7.6.65, “mysql_session_track_get_first()”
- Section 16.4.1.37, “Replication and Variables”
- Section 5.1.7, “Server System Variables”
- Section 13.7.4.2, “SET CHARACTER SET Statement”
- Section 13.7.4.3, “SET NAMES Statement”
- Section 9.1.1, “String Literals”
- Section 12.2, “Type Conversion in Expression Evaluation”
character_set_database
- Section 13.1.8, “ALTER TABLE Statement”
- Section 10.4, “Connection Character Sets and Collations”
- Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
- Section 10.3.3, “Database Character Set and Collation”
- Section 13.2.6, “LOAD DATA Statement”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.37, “Replication and Variables”
- Section 5.1.7, “Server System Variables”
- Section 13.7.4.2, “SET CHARACTER SET Statement”
- Section 1.4, “What Is New in MySQL 5.7”
character_set_filesystem
character_set_results
- Section 27.7.4, “C API Data Structures”
- Section 10.4, “Connection Character Sets and Collations”
- Section 10.6, “Error Message Character Set”
- Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 27.7.6.65, “mysql_session_track_get_first()”
- Section 5.1.7, “Server System Variables”
- Section 13.7.4.2, “SET CHARACTER SET Statement”
- Section 13.7.4.3, “SET NAMES Statement”
- Section 10.2.2, “UTF-8 for Metadata”
character_set_server
- Section 10.15, “Character Set Configuration”
- Section 10.4, “Connection Character Sets and Collations”
- Section 10.3.3, “Database Character Set and Collation”
- Section 12.9.4, “Full-Text Stopwords”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.3, “Replication and Character Sets”
- Section 16.4.1.37, “Replication and Variables”
- Section 10.3.2, “Server Character Set and Collation”
- Section 5.1.7, “Server System Variables”
character_set_system
character_sets_dir
check_proxy_users
collation_connection
- Section 12.10, “Cast Functions and Operators”
- Section 12.7.3, “Character Set and Collation of Function Results”
- Section 10.3.8, “Character Set Introducers”
- Section 10.3.6, “Character String Literal Character Set and Collation”
- Section 10.8.4, “Collation Coercibility in Expressions”
- Section 10.4, “Connection Character Sets and Collations”
- Section 12.6, “Date and Time Functions”
- Section 12.13, “Encryption and Compression Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.37, “Replication and Variables”
- Section 5.1.7, “Server System Variables”
- Section 13.7.4.3, “SET NAMES Statement”
- Section 13.7.5.7, “SHOW CREATE EVENT Statement”
- Section 13.7.5.9, “SHOW CREATE PROCEDURE Statement”
- Section 13.7.5.11, “SHOW CREATE TRIGGER Statement”
- Section 13.7.5.13, “SHOW CREATE VIEW Statement”
- Section 13.7.5.18, “SHOW EVENTS Statement”
- Section 13.7.5.28, “SHOW PROCEDURE STATUS Statement”
- Section 13.7.5.38, “SHOW TRIGGERS Statement”
- Section 5.4.4, “The Binary Log”
- Section 24.8, “The INFORMATION_SCHEMA EVENTS Table”
- Section 24.21, “The INFORMATION_SCHEMA ROUTINES Table”
- Section 24.29, “The INFORMATION_SCHEMA TRIGGERS Table”
- Section 24.31, “The INFORMATION_SCHEMA VIEWS Table”
- Section 12.2, “Type Conversion in Expression Evaluation”
collation_database
- Section 10.4, “Connection Character Sets and Collations”
- Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
- Section 10.3.3, “Database Character Set and Collation”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.37, “Replication and Variables”
- Section 5.1.7, “Server System Variables”
- Section 5.4.4, “The Binary Log”
- Section 1.4, “What Is New in MySQL 5.7”
collation_server
- Section 10.4, “Connection Character Sets and Collations”
- Section 10.3.3, “Database Character Set and Collation”
- Section 12.9.4, “Full-Text Stopwords”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.37, “Replication and Variables”
- Section 10.3.2, “Server Character Set and Collation”
- Section 5.1.7, “Server System Variables”
- Section 5.4.4, “The Binary Log”
completion_type
concurrent_insert
connect_timeout
connection_control_failed_connections_threshold
connection_control_max_connection_delay
connection_control_min_connection_delay
core_file
daemon_memcached_enable_binlog
daemon_memcached_engine_lib_name
daemon_memcached_engine_lib_path
daemon_memcached_option
- Section 14.21.2, “InnoDB memcached Architecture”
- Section 14.15, “InnoDB Startup Options and System Variables”
- Section 14.21.4, “Security Considerations for the InnoDB memcached Plugin”
- Section 14.21.3, “Setting Up the InnoDB memcached Plugin”
- Section 14.21.8, “Troubleshooting the InnoDB memcached Plugin”
daemon_memcached_r_batch_size
- Section 14.21.2, “InnoDB memcached Architecture”
- Section 14.15, “InnoDB Startup Options and System Variables”
- Section 14.21.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
- Section 14.21.3, “Setting Up the InnoDB memcached Plugin”
- Section 14.21.6, “The InnoDB memcached Plugin and Replication”
- Section 14.21.5.3, “Tuning InnoDB memcached Plugin Performance”
daemon_memcached_w_batch_size
- Section 14.21.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
- Section 14.21.2, “InnoDB memcached Architecture”
- Section 14.15, “InnoDB Startup Options and System Variables”
- Section 14.21.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
- Section 14.21.3, “Setting Up the InnoDB memcached Plugin”
- Section 14.21.6, “The InnoDB memcached Plugin and Replication”
- Section 14.21.5.3, “Tuning InnoDB memcached Plugin Performance”
datadir
- Section 17.2.1.2, “Configuring an Instance for Group Replication”
- Section 13.1.19, “CREATE TABLESPACE Statement”
- Section 14.8.1, “InnoDB Startup Configuration”
- Section 14.15, “InnoDB Startup Options and System Variables”
- Section 2.4.3, “Installing a MySQL Launch Daemon”
- Section 2.3, “Installing MySQL on Microsoft Windows”
- MySQL Glossary
- Section 5.1.6, “Server Command Options”
- Section 5.1.7, “Server System Variables”
- Section 24.9, “The INFORMATION_SCHEMA FILES Table”
date_format
datetime_format
debug_sync
default
default_authentication_plugin
default_password_lifetime
default_storage_engine
- Section 13.1.15, “CREATE LOGFILE GROUP Statement”
- Section 13.1.18, “CREATE TABLE Statement”
- Section 13.1.19, “CREATE TABLESPACE Statement”
- Section 13.1.30, “DROP TABLESPACE Statement”
- Section 14.6.3.3, “General Tablespaces”
- Section 5.5.1, “Installing and Uninstalling Plugins”
- Section 16.4.1.37, “Replication and Variables”
- Section 5.1.7, “Server System Variables”
- Section 15.1, “Setting the Storage Engine”
- Section 16.3.3, “Using Replication with Different Source and Replica Storage Engines”
- Section 1.4, “What Is New in MySQL 5.7”
default_table_encryption
default_tmp_storage_engine
default_week_format
delay_key_write
delayed_insert_limit
delayed_insert_timeout
delayed_queue_size
disabled_storage_engines
- Section 17.2.1.2, “Configuring an Instance for Group Replication”
- Section 17.7.1, “Group Replication Requirements”
- Section A.2, “MySQL 5.7 FAQ: Storage Engines”
- Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
- Section 5.1.6, “Server Command Options”
- Section B.3.1, “Server Error Message Reference”
- Section 5.1.7, “Server System Variables”
disconnect_on_expired_password
div_precision_increment
end_markers_in_json
enforce_gtid_consistency
eq_range_index_dive_limit
error_count
event_scheduler
expire_logs_days
explicit_defaults_for_timestamp
external_user
foreign_key_checks
- Section 13.1.8, “ALTER TABLE Statement”
- Section 13.1.18.5, “FOREIGN KEY Constraints”
- Section 14.6.1.3, “Importing InnoDB Tables”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 21.3.3.9.2, “NDB Cluster System Variables”
- Section 14.13.1, “Online DDL Operations”
- Section 16.4.1.37, “Replication and Variables”
- Section 5.1.10, “Server SQL Modes”
- Section 5.1.7, “Server System Variables”
- Section 5.4.4, “The Binary Log”
ft_boolean_syntax
ft_max_word_len
- Section 12.9.2, “Boolean Full-Text Searches”
- Section 16.1.2.4.2, “Creating a Data Snapshot Using Raw Data Files”
- Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 12.9.8, “ngram Full-Text Parser”
- Section 5.1.7, “Server System Variables”
- Section 28.2.4.4, “Writing Full-Text Parser Plugins”
ft_min_word_len
- Section 12.9.2, “Boolean Full-Text Searches”
- Section 16.1.2.4.2, “Creating a Data Snapshot Using Raw Data Files”
- Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 12.9.9, “MeCab Full-Text Parser Plugin”
- Section 12.9.1, “Natural Language Full-Text Searches”
- Section 12.9.8, “ngram Full-Text Parser”
- Section 5.1.7, “Server System Variables”
- Section 28.2.4.4, “Writing Full-Text Parser Plugins”
ft_query_expansion_limit
ft_stopword_file
general_log
general_log_file
group_concat_max_len
group_replication_allow_local_disjoint_gtids_join
group_replication_allow_local_lower_version_join
group_replication_auto_increment_increment
group_replication_bootstrap_group
group_replication_components_stop_timeout
group_replication_compression_threshold
group_replication_enforce_update_everywhere_checks
group_replication_exit_state_action
group_replication_flow_control_applier_threshold
group_replication_flow_control_certifier_threshold
group_replication_flow_control_hold_percent
group_replication_flow_control_max_commit_quota
group_replication_flow_control_member_quota_percent
group_replication_flow_control_min_quota
group_replication_flow_control_min_recovery_quota
group_replication_flow_control_mode
group_replication_flow_control_period
group_replication_force_members
group_replication_group_name
group_replication_group_seeds
group_replication_gtid_assignment_block_size
group_replication_ip_whitelist
group_replication_local_address
- Section 17.2.1.2, “Configuring an Instance for Group Replication”
- Section 17.2.2, “Deploying Group Replication Locally”
- Section 17.8, “Frequently Asked Questions”
- Section 17.5.1, “Group Replication IP Address Allowlisting”
- Section 17.6, “Group Replication System Variables”
- Section 6.5.5.2, “Setting the TCP Port Context for MySQL Features”
- Section 25.12.11.7, “The replication_group_members Table”
- Section 20.4, “Working with InnoDB Cluster”