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

A

[index top]

activate_all_roles_on_login

Section 17.3.3, “Replication Privilege Checks”
Section 5.1.8, “Server System Variables”
Section 13.7.1.11, “SET ROLE Statement”
Section 13.7.7.21, “SHOW GRANTS Statement”
Section 6.2.10, “Using Roles”

admin_address

Section 5.1.12.2, “Administrative Connection Management”
Section 5.1.14, “Network Namespace Support”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 5.1.8, “Server System Variables”

admin_port

Section 5.1.12.2, “Administrative Connection Management”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 5.1.8, “Server System Variables”

admin_ssl_ca

Section 5.1.8, “Server System Variables”

admin_ssl_capath

Section 5.1.8, “Server System Variables”

admin_ssl_cert

Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

admin_ssl_cipher

Section 5.1.8, “Server System Variables”

admin_ssl_crl

Section 5.1.8, “Server System Variables”

admin_ssl_crlpath

Section 5.1.8, “Server System Variables”

admin_ssl_key

Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

admin_tls_ciphersuites

Section 5.1.8, “Server System Variables”

admin_tls_version

Section 5.1.12.2, “Administrative Connection Management”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

audit_log_buffer_size

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_compression

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_connection_policy

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.9, “Legacy Mode Audit Log Filtering”
Section 6.4.5.8, “Writing Audit Log Filter Definitions”

audit_log_current_session

Section 6.4.5.10, “Audit Log Reference”

audit_log_encryption

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_exclude_accounts

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.9, “Legacy Mode Audit Log Filtering”
Section 6.4.5.8, “Writing Audit Log Filter Definitions”

audit_log_file

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”
Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
Section 6.4.5, “MySQL Enterprise Audit”
Section 6.4.5.3, “MySQL Enterprise Audit Security Considerations”
Section 6.4.5.6, “Reading Audit Log Files”

audit_log_filter_id

Section 6.4.5.7, “Audit Log Filtering”
Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.8, “Writing Audit Log Filter Definitions”

audit_log_flush

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_format

Section 6.4.5.4, “Audit Log File Formats”
Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”
Section 6.4.5, “MySQL Enterprise Audit”
Section 6.4.6, “The Audit Message Component”

audit_log_include_accounts

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.9, “Legacy Mode Audit Log Filtering”
Section 6.4.5.8, “Writing Audit Log Filter Definitions”

audit_log_password_history_keep_days

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_policy

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.9, “Legacy Mode Audit Log Filtering”
Section 5.1.9, “Using System Variables”
Section 6.4.5.8, “Writing Audit Log Filter Definitions”

audit_log_prune_seconds

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_read_buffer_size

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.6, “Reading Audit Log Files”

audit_log_rotate_on_size

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_statement_policy

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.9, “Legacy Mode Audit Log Filtering”
Section 6.4.5.8, “Writing Audit Log Filter Definitions”

audit_log_strategy

Section 6.4.5.10, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

authentication_ldap_sasl_auth_method_name

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_bind_base_dn

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_bind_root_dn

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_bind_root_pwd

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_ca_path

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_group_search_attr

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_group_search_filter

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_init_pool_size

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_log_status

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_max_pool_size

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_referral

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_server_host

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_server_port

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_tls

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_sasl_user_search_attr

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_auth_method_name

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_bind_base_dn

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_bind_root_dn

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_bind_root_pwd

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_ca_path

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_group_search_attr

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_group_search_filter

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_init_pool_size

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_log_status

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_max_pool_size

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_referral

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_server_host

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_server_port

Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_tls

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_ldap_simple_user_search_attr

Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.4.1.11, “Pluggable Authentication System Variables”

authentication_windows_log_level

Section 5.1.8, “Server System Variables”
Section 6.4.1.6, “Windows Pluggable Authentication”

authentication_windows_use_principal_name

Section 5.1.8, “Server System Variables”
Section 6.4.1.6, “Windows Pluggable Authentication”

auto_generate_certs

Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 5.1.8, “Server System Variables”

auto_increment_increment

Section 15.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.1, “MySQL 8.0 FAQ: General”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 17.5.1.39, “Replication and Variables”
Section 17.1.6.2, “Replication Source Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

auto_increment_offset

Section 15.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.1, “MySQL 8.0 FAQ: General”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 17.5.1.39, “Replication and Variables”
Section 17.1.6.2, “Replication Source Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

AUTOCOMMIT

Section 17.5.1.35, “Replication and Transactions”

autocommit

Section 13.1.10, “ALTER TABLESPACE Statement”
Section 15.7.2.2, “autocommit, Commit, and Rollback”
Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 15.7.5.2, “Deadlock Detection”
Section 13.2.2, “DELETE Statement”
Section 15.6.3.3, “General Tablespaces”
Section 15.2, “InnoDB and the ACID Model”
Section 15.7, “InnoDB Locking and Transaction Model”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 15.7.2.4, “Locking Reads”
Section 15.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section 15.6.1.4, “Moving or Copying InnoDB Tables”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 8.5.3, “Optimizing InnoDB Read-Only Transactions”
Section 27.12.7, “Performance Schema Transaction Tables”
Section 15.8.9, “Purge Configuration”
Section 17.5.1.31, “Replication and Temporary Tables”
Section 17.5.1.35, “Replication and Transactions”
Section 17.1.3.7, “Restrictions on Replication with GTIDs”
Section 5.1.8, “Server System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 26.51.29, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 5.6.3.3, “Thread Pool Operation”
Section 15.7.2.1, “Transaction Isolation Levels”

automatic_sp_privileges

Section 13.1.7, “ALTER PROCEDURE Statement”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 25.2.2, “Stored Routines and MySQL Privileges”

avoid_temporal_upgrade

Section 13.7.3.2, “CHECK TABLE Statement”
Section 13.7.3.5, “REPAIR TABLE Statement”
Section 5.1.8, “Server System Variables”

B

[index top]

back_log

Section 2.11.4, “Changes in MySQL 8.0”
Section 5.1.8, “Server System Variables”

basedir

Section 13.7.4.4, “INSTALL PLUGIN Statement”
Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

big_tables

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.8, “Server System Variables”

bind_address

Section B.3.2.2, “Can't connect to [local] MySQL server”
Section 5.1.13.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 5.1.13.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.13.3, “Connecting Using the IPv6 Local Host Address”
Section 18.5.1, “Group Replication IP Address Permissions”
Section 5.1.13, “IPv6 Support”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1.14, “Network Namespace Support”
Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
Section 5.1.13.5, “Obtaining an IPv6 Address from a Broker”
Section 5.8, “Running Multiple MySQL Instances on One Machine”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 5.1.8, “Server System Variables”
Section 18.4.5, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”
Section 23.5.14.41, “The ndbinfo processes Table”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 20.5.6.2, “X Plugin Options and System Variables”

binlog

Section 18.9.1, “Group Replication Requirements”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

binlog_cache_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 5.1.10, “Server Status Variables”
Section 5.4.4, “The Binary Log”

binlog_checksum

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 18.9.2, “Group Replication Limitations”
MySQL Glossary
Section 17.5.1.35, “Replication and Transactions”
Section 5.4.4, “The Binary Log”

binlog_direct_non_transactional_updates

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.5.1.35, “Replication and Transactions”

binlog_encryption

Section 13.1.5, “ALTER INSTANCE Statement”
Section 17.3.2.3, “Binary Log Master Key Rotation”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.3.2, “Encrypting Binary Log Files and Relay Log Files”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.3, “Replication Security”
Section 13.7.7.1, “SHOW BINARY LOGS Statement”
Section 5.4.4, “The Binary Log”

binlog_error_action

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.3.1, “GTID Format and Storage”
Section 5.4.4, “The Binary Log”

binlog_expire_logs_seconds

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.1.3.3, “GTID Auto-Positioning”
Section 13.4.1.1, “PURGE BINARY LOGS Statement”
Section 5.4.6, “Server Log Maintenance”

binlog_format

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 11.6, “Data Type Default Values”
Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 17.2.5.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.5.2, “Evaluation of Table-Level Replication Options”
Section 6.2.3, “Grant Tables”
Section 17.1.3.2, “GTID Life Cycle”
Section 12.16, “Information Functions”
Section 17.2.5.3, “Interactions Between Replication Filtering Options”
Section 13.2.7, “LOAD DATA Statement”
Section 12.15, “Locking Functions”
Section 5.4.4.4, “Logging Format for Changes to mysql Database Tables”
Section 12.6.2, “Mathematical Functions”
Section 12.24, “Miscellaneous Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.14, “MySQL 8.0 FAQ: Replication”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 24.3.5, “Obtaining Information About Partitions”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.2, “Replication and BLACKHOLE Tables”
Section 17.5.1.19, “Replication and LOAD DATA”
Section 17.5.1.21, “Replication and MEMORY Tables”
Section 17.5.1.31, “Replication and Temporary Tables”
Section 17.5.1.35, “Replication and Transactions”
Section 17.2.1, “Replication Formats”
Section 17.5.1.22, “Replication of the mysql System Schema”
Section 17.3.3, “Replication Privilege Checks”
Section 17.1.3.7, “Restrictions on Replication with GTIDs”
Section 13.3.8.3, “Restrictions on XA Transactions”
Section 17.3.2.1, “Scope of Binary Log Encryption”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 25.7, “Stored Program Binary Logging”
Section 5.1.9.1, “System Variable Privileges”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 5.4.3, “The General Query Log”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”
Section 5.4.5, “The Slow Query Log”
Section 15.7.2.1, “Transaction Isolation Levels”
Section 17.5.3, “Upgrading a Replication Setup”
Section 17.2.1.2, “Usage of Row-Based Logging and Replication”

binlog_group_commit_sync_delay

Section 17.1.6.4, “Binary Logging Options and Variables”

binlog_group_commit_sync_no_delay_count

Section 17.1.6.4, “Binary Logging Options and Variables”

binlog_gtid_simple_recovery

Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.3.2, “GTID Life Cycle”

binlog_max_flush_queue_time

Section 17.1.6.4, “Binary Logging Options and Variables”

binlog_order_commits

Section 17.1.6.4, “Binary Logging Options and Variables”

binlog_rotate_encryption_master_key_at_startup

Section 17.3.2.3, “Binary Log Master Key Rotation”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 6.2.2, “Privileges Provided by MySQL”

binlog_row_event_max_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 5.4.4.2, “Setting The Binary Log Format”

binlog_row_image

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.1.20.10, “Invisible Columns”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

binlog_row_metadata

Section 17.1.6.4, “Binary Logging Options and Variables”

binlog_row_value_options

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.5.1.17, “Replication of JSON Documents”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

binlog_rows_query_log_events

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.4.3, “Monitoring Row-based Replication”
Section 4.6.8.2, “mysqlbinlog Row Event Display”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”

binlog_stmt_cache_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 5.1.10, “Server Status Variables”

binlog_transaction_compression

Section 5.4.4.5, “Binary Log Transaction Compression”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 5.4.4.5.2, “Combining Compressed and Uncompressed Transaction Payloads”
Section 18.6.3, “Message Compression”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 27.12.11.12, “The binary_log_transaction_compression_stats Table”

binlog_transaction_compression_level_zstd

Section 5.4.4.5, “Binary Log Transaction Compression”
Section 17.1.6.4, “Binary Logging Options and Variables”

binlog_transaction_dependency_history_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 8.12.3.1, “How MySQL Uses Memory”

binlog_transaction_dependency_tracking

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 18.9.1, “Group Replication Requirements”
Section 17.1.6.3, “Replica Server Options and Variables”

block_encryption_mode

Section 12.14, “Encryption and Compression Functions”
Section 5.1.8, “Server System Variables”

bulk_insert_buffer_size

Section 16.2.1, “MyISAM Startup Options”
Section 8.2.5.1, “Optimizing INSERT Statements”
Section 5.1.8, “Server System Variables”

C

[index top]

caching_sha

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

character_set_client

Section 10.15, “Character Set Configuration”
Section 10.4, “Connection Character Sets and Collations”
Section 13.2.7, “LOAD DATA Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 9.6, “Query Attributes”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 13.7.6.2, “SET CHARACTER SET Statement”
Section 13.7.6.3, “SET NAMES Statement”
Section 13.7.7.7, “SHOW CREATE EVENT Statement”
Section 13.7.7.9, “SHOW CREATE PROCEDURE Statement”
Section 13.7.7.11, “SHOW CREATE TRIGGER Statement”
Section 13.7.7.13, “SHOW CREATE VIEW Statement”
Section 13.7.7.18, “SHOW EVENTS Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 13.7.7.40, “SHOW TRIGGERS Statement”
Section 5.4.4, “The Binary Log”
Section 26.14, “The INFORMATION_SCHEMA EVENTS Table”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”
Section 26.45, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 26.48, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.6.4.2, “Using the Rewriter Query Rewrite Plugin”

character_set_connection

Section 12.11, “Cast Functions and Operators”
Section 12.8.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.7, “Date and Time Functions”
Section 12.14, “Encryption and Compression Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 10.16, “MySQL Server Locale Support”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 13.7.6.2, “SET CHARACTER SET Statement”
Section 13.7.6.3, “SET NAMES Statement”
Section 9.1.1, “String Literals”
Section 12.3, “Type Conversion in Expression Evaluation”

character_set_database

Section 13.1.9, “ALTER TABLE Statement”
Section 2.11.4, “Changes in MySQL 8.0”
Section 10.4, “Connection Character Sets and Collations”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 10.3.3, “Database Character Set and Collation”
Section 13.2.7, “LOAD DATA Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 13.7.6.2, “SET CHARACTER SET Statement”
Section 23.1.4, “What is New in NDB Cluster”

character_set_filesystem

Section 13.2.7, “LOAD DATA Statement”
Section 13.2.10.1, “SELECT ... INTO Statement”
Section 5.1.8, “Server System Variables”
Section 12.8, “String Functions and Operators”

character_set_results

Section 10.4, “Connection Character Sets and Collations”
Section 10.6, “Error Message Character Set”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.8, “Server System Variables”
Section 13.7.6.2, “SET CHARACTER SET Statement”
Section 13.7.6.3, “SET NAMES Statement”
Section 10.2.2, “UTF-8 for Metadata”

character_set_server

Section 2.11.4, “Changes in MySQL 8.0”
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.10.4, “Full-Text Stopwords”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.3, “Replication and Character Sets”
Section 17.5.1.39, “Replication and Variables”
Section 10.3.2, “Server Character Set and Collation”
Section 5.1.8, “Server System Variables”

character_set_system

Section 10.15, “Character Set Configuration”
Section 5.1.8, “Server System Variables”
Section 10.2.2, “UTF-8 for Metadata”

character_sets_dir

Section 10.14.3, “Adding a Simple Collation to an 8-Bit Character Set”
Section 10.14.4.1, “Defining a UCA Collation Using LDML Syntax”
Section 5.1.8, “Server System Variables”

check_proxy_users

Section 6.2.18, “Proxy Users”
Section 5.1.8, “Server System Variables”

clone_autotune_concurrency

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.9, “Monitoring Cloning Operations”

clone_buffer_size

Section 5.6.7.12, “Clone System Variables”

clone_ddl_timeout

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.8, “Remote Cloning Operation Failure Handling”

clone_donor_timeout_after_network_failure

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.8, “Remote Cloning Operation Failure Handling”

clone_enable_compression

Section 5.6.7.12, “Clone System Variables”
Section 18.4.3.1.2, “Compression for Distributed Recovery”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”

clone_max_concurrency

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.9, “Monitoring Cloning Operations”

clone_max_data_bandwidth

Section 5.6.7.12, “Clone System Variables”
Section 27.12.17.2, “The clone_progress Table”

clone_max_network_bandwidth

Section 5.6.7.12, “Clone System Variables”

clone_ssl_ca

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.3, “Cloning Remote Data”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

clone_ssl_cert

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.3, “Cloning Remote Data”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

clone_ssl_key

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.3, “Cloning Remote Data”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

clone_valid_donor_list

Section 5.6.7.12, “Clone System Variables”
Section 5.6.7.3, “Cloning Remote Data”
Section 18.4.3.2.1, “Prerequisites for Cloning”

collation_connection

Section 12.11, “Cast Functions and Operators”
Section 12.8.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.7, “Date and Time Functions”
Section 12.14, “Encryption and Compression Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 13.5.1, “PREPARE Statement”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 13.7.6.3, “SET NAMES Statement”
Section 13.7.7.7, “SHOW CREATE EVENT Statement”
Section 13.7.7.9, “SHOW CREATE PROCEDURE Statement”
Section 13.7.7.11, “SHOW CREATE TRIGGER Statement”
Section 13.7.7.13, “SHOW CREATE VIEW Statement”
Section 13.7.7.18, “SHOW EVENTS Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 13.7.7.40, “SHOW TRIGGERS Statement”
Section 5.4.4, “The Binary Log”
Section 26.14, “The INFORMATION_SCHEMA EVENTS Table”
Section 26.30, “The INFORMATION_SCHEMA ROUTINES Table”
Section 26.45, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 26.48, “The INFORMATION_SCHEMA VIEWS Table”
Section 12.3, “Type Conversion in Expression Evaluation”

collation_database

Section 2.11.4, “Changes in MySQL 8.0”
Section 10.4, “Connection Character Sets and Collations”
Section 13.1.17, “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 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 5.4.4, “The Binary Log”
Section 23.1.4, “What is New in NDB Cluster”

collation_server

Section 2.11.4, “Changes in MySQL 8.0”
Section 10.4, “Connection Character Sets and Collations”
Section 10.3.3, “Database Character Set and Collation”
Section 12.10.4, “Full-Text Stopwords”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 10.3.2, “Server Character Set and Collation”
Section 5.1.8, “Server System Variables”
Section 5.4.4, “The Binary Log”

completion_type

Section 5.1.8, “Server System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”

concurrent_insert

Section 8.11.3, “Concurrent Inserts”
Section 8.11.1, “Internal Locking Methods”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

connect_timeout

Section B.3.2.9, “Communication Errors and Aborted Connections”
Section B.3.2.3, “Lost connection to MySQL server”
Section 5.1.8, “Server System Variables”
Section 20.5.6.2, “X Plugin Options and System Variables”

connection_control_failed_connections_threshold

Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 6.4.2.2, “Connection-Control System and Status Variables”
Section 26.53.1, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”

connection_control_max_connection_delay

Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 6.4.2.2, “Connection-Control System and Status Variables”

connection_control_min_connection_delay

Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 6.4.2.2, “Connection-Control System and Status Variables”

core_file

Section 15.8.3.7, “Excluding Buffer Pool Pages from Core Files”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

create_admin_listener_thread

Section 5.1.12.2, “Administrative Connection Management”
Section 5.1.8, “Server System Variables”

cte_max_recursion_depth

Section 5.1.8, “Server System Variables”
Section 13.2.15, “WITH (Common Table Expressions)”

D

[index top]

daemon_memcached_enable_binlog

Section 15.14, “InnoDB Startup Options and System Variables”

daemon_memcached_engine_lib_name

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”

daemon_memcached_engine_lib_path

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”

daemon_memcached_option

Section 15.20.2, “InnoDB memcached Architecture”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.20.5, “Security Considerations for the InnoDB memcached Plugin”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 15.20.9, “Troubleshooting the InnoDB memcached Plugin”

daemon_memcached_r_batch_size

Section 15.20.2, “InnoDB memcached Architecture”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.20.6.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”

daemon_memcached_w_batch_size

Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.20.6.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”

datadir

Section 2.11.4, “Changes in MySQL 8.0”
Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 15.6.1.2, “Creating Tables Externally”
Section 15.6.3.3, “General Tablespaces”
Section 15.18.2, “InnoDB Recovery”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
Section 2.3, “Installing MySQL on Microsoft Windows”
Section 15.6.3.6, “Moving Tablespace Files While the Server is Offline”
MySQL Glossary
Section 15.6.5, “Redo Log”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 13.1.37, “TRUNCATE TABLE Statement”
Section 15.6.3.4, “Undo Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

debug

Section 5.1.8, “Server System Variables”
Section 5.9.4, “The DBUG Package”

debug_sync

Section 27.12.14.2, “Performance Schema variables_info Table”
Section 5.1.8, “Server System Variables”

default

Section 18.9.1, “Group Replication Requirements”
Section 16.1, “Setting the Storage Engine”
Section 15.1.4, “Testing and Benchmarking with InnoDB”

default_authentication_plugin

Section 13.7.1.1, “ALTER USER Statement”
Section 6.4.1, “Authentication Plugins”
Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 2.11.4, “Changes in MySQL 8.0”
Section 13.7.1.3, “CREATE USER Statement”
Section 6.2.17, “Pluggable Authentication”
Section 5.1.8, “Server System Variables”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”

default_collation_for_utf

Section 5.1.8, “Server System Variables”

default_password_lifetime

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 6.2.3, “Grant Tables”
Section 6.2.15, “Password Management”
Section 5.1.8, “Server System Variables”

default_storage_engine

Section 13.1.16, “CREATE LOGFILE GROUP Statement”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 13.1.33, “DROP TABLESPACE Statement”
Section 15.6.3.3, “General Tablespaces”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 24.2.2, “LIST Partitioning”
Section 24.1, “Overview of Partitioning in MySQL”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 16.1, “Setting the Storage Engine”
Section 17.4.4, “Using Replication with Different Source and Replica Storage Engines”

default_table_encryption

Section 13.1.2, “ALTER DATABASE Statement”
Section 13.1.10, “ALTER TABLESPACE Statement”
Section 13.1.12, “CREATE DATABASE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 18.8, “Group Replication System Variables”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 5.1.8, “Server System Variables”
Section 5.1.9.1, “System Variable Privileges”
Section 1.3, “What Is New in MySQL 8.0”

default_tmp_storage_engine

Section 5.6.1, “Installing and Uninstalling Plugins”
Section 5.1.8, “Server System Variables”
Section 16.1, “Setting the Storage Engine”

default_week_format

Section 12.7, “Date and Time Functions”
Section 24.6.3, “Partitioning Limitations Relating to Functions”
Section 5.1.8, “Server System Variables”

delay_key_write

Section 13.1.20, “CREATE TABLE Statement”
Section 8.11.5, “External Locking”
Section A.14, “MySQL 8.0 FAQ: Replication”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section B.3.3.3, “What to Do If MySQL Keeps Crashing”

delayed_insert_limit

Section 5.1.8, “Server System Variables”

delayed_insert_timeout

Section 5.1.8, “Server System Variables”

delayed_queue_size

Section 5.1.8, “Server System Variables”

disabled_storage_engines

Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.9.1, “Group Replication Requirements”
Section A.2, “MySQL 8.0 FAQ: Storage Engines”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

disconnect_on_expired_password

Section 6.2.16, “Server Handling of Expired Passwords”
Section 5.1.8, “Server System Variables”

div_precision_increment

Section 12.6.1, “Arithmetic Operators”
Section 5.1.8, “Server System Variables”

dragnet

Section 5.5.3, “Error Log Components”
Section 5.5, “MySQL Components”
Section 5.4.2.6, “Rule-Based Error Log Filtering (log_filter_dragnet)”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 5.4.2.4, “Types of Error Log Filtering”
Section 5.1.9, “Using System Variables”

E

[index top]

end_markers_in_json

Section 5.1.8, “Server System Variables”

enforce_gtid_consistency

Section 17.1.4.3, “Disabling GTID Transactions Online”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 18.9.1, “Group Replication Requirements”
Section 17.5.1.31, “Replication and Temporary Tables”
Section 17.1.4.1, “Replication Mode Concepts”
Section 17.1.3.7, “Restrictions on Replication with GTIDs”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”

eq_range_index_dive_limit

Section 8.2.1.2, “Range Optimization”
Section 5.1.8, “Server System Variables”

error_count

Section B.2, “Error Information Interfaces”
Section 13.5, “Prepared Statements”
Section 5.1.8, “Server System Variables”
Section 13.7.7.17, “SHOW ERRORS Statement”
Section 13.6.7.7, “The MySQL Diagnostics Area”

event

Section 15.8.2, “Configuring InnoDB for Read-Only Operation”

event_scheduler

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 2.11.4, “Changes in MySQL 8.0”
Section 25.4.2, “Event Scheduler Configuration”
Section 5.1.8, “Server System Variables”
Section 17.1.2.6.2, “Setting Up Replication with Existing Data”
Section 25.4.6, “The Event Scheduler and MySQL Privileges”

expire_logs_days

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 2.11.4, “Changes in MySQL 8.0”

explicit_defaults_for_timestamp

Section 11.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 2.11.4, “Changes in MySQL 8.0”
Section 13.1.20.8, “CREATE TABLE and Generated Columns”
Section 11.6, “Data Type Default Values”
Section 11.2.1, “Date and Time Data Type Syntax”
Section 5.1.8, “Server System Variables”

external_user

Section 6.4.5.4, “Audit Log File Formats”
Section 6.2.18, “Proxy Users”
Section 5.1.8, “Server System Variables”

F

[index top]

flush

Section 5.1.8, “Server System Variables”

flush_time

Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

foreign_key_checks

Section 13.1.9, “ALTER TABLE Statement”
Section 13.1.20.5, “FOREIGN KEY Constraints”
Section 15.6.1.3, “Importing InnoDB Tables”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 15.12.1, “Online DDL Operations”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.11, “Server SQL Modes”
Section 5.1.8, “Server System Variables”
Section 5.4.4, “The Binary Log”

ft_boolean_syntax

Section 12.10.2, “Boolean Full-Text Searches”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.8, “Server System Variables”

ft_max_word_len

Section 12.10.2, “Boolean Full-Text Searches”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.8, “ngram Full-Text Parser”
Section 5.1.8, “Server System Variables”

ft_min_word_len

Section 12.10.2, “Boolean Full-Text Searches”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.9, “MeCab Full-Text Parser Plugin”
Section 12.10.1, “Natural Language Full-Text Searches”
Section 12.10.8, “ngram Full-Text Parser”
Section 5.1.8, “Server System Variables”

ft_query_expansion_limit

Section 5.1.8, “Server System Variables”

ft_stopword_file

Section 12.10.2, “Boolean Full-Text Searches”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.4, “Full-Text Stopwords”
Section 12.10.1, “Natural Language Full-Text Searches”
Section 5.1.8, “Server System Variables”

G

[index top]

general_log

MySQL Glossary
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 5.4.3, “The General Query Log”

general_log_file

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 5.4.3, “The General Query Log”
Section 1.3, “What Is New in MySQL 8.0”

generated_random_password_length

Section 6.2.15, “Password Management”
Section 5.1.8, “Server System Variables”

group_concat_max_len

Section 12.20.1, “Aggregate Function Descriptions”
Section 5.1.8, “Server System Variables”

group_replication_advertise_recovery_endpoints

Section 18.4.3.1, “Connections for Distributed Recovery”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 18.4.5, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”

group_replication_allow_local_lower_version_join

Section 18.8, “Group Replication System Variables”
Section 18.7.1.1, “Member Versions During Upgrades”

group_replication_auto_increment_increment

Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 17.1.6.2, “Replication Source Options and Variables”

group_replication_autorejoin_tries

Section 18.6.6.3, “Auto-Rejoin”
Section 2.11.4, “Changes in MySQL 8.0”
Section 18.6.6.4, “Exit Action”
Section 18.6.6.1, “Expel Timeout”
Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 18.6.6.2, “Unreachable Majority Timeout”

group_replication_bootstrap_group

Section 18.2.1.6.1, “Adding a Second Instance”
Section 18.2.1.5, “Bootstrapping the Group”
Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.8, “Group Replication System Variables”
Section 18.1.3, “Multi-Primary and Single-Primary Modes”

group_replication_clone_threshold

Section 18.4.3.2, “Cloning for Distributed Recovery”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.5, “How Distributed Recovery Works”
Section 18.4.3.2.2, “Threshold for Cloning”

group_replication_communication_debug_options

Section 18.8, “Group Replication System Variables”

group_replication_communication_max_message_size

Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.6.4, “Message Fragmentation”

group_replication_components_stop_timeout

Section 18.8, “Group Replication System Variables”

group_replication_compression_threshold

Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.6.3, “Message Compression”
Section 5.4.4.5.3, “Monitoring Binary Log Transaction Compression”

group_replication_consistency

Section 18.4.2.2, “Configuring Transaction Consistency Guarantees”
Section 18.8, “Group Replication System Variables”
Section 18.1.3.2, “Multi-Primary Mode”
Section 6.2.2, “Privileges Provided by MySQL”
Section 18.1.3.1, “Single-Primary Mode”
Section 18.4.2.1, “Understanding Transaction Consistency Guarantees”

group_replication_enforce_update_everywhere_checks

Section 18.4.1.2, “Changing a Group's Mode”
Section 13.4.3.4, “Functions which Configure the Group Replication Mode”
Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.1.3.1, “Single-Primary Mode”
Section 18.1.3.2.1, “Transaction Checks”

group_replication_exit_state_action

Section 18.6.6.3, “Auto-Rejoin”
Section 2.11.4, “Changes in MySQL 8.0”
Section 18.6.6.4, “Exit Action”
Section 18.6.6.1, “Expel Timeout”
Section 18.4.3.4, “Fault Tolerance for Distributed Recovery”
Section 18.3.1, “Group Replication Server States”
Section 18.8, “Group Replication System Variables”
Section 18.6.6.2, “Unreachable Majority Timeout”

group_replication_flow_control_applier_threshold

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_certifier_threshold

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_hold_percent

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_max_commit_quota

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_member_quota_percent

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_min_quota

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_min_recovery_quota

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_mode

Section 18.8, “Group Replication System Variables”

group_replication_flow_control_period

Section 18.8, “Group Replication System Variables”
Section 18.3.3, “The replication_group_member_stats Table”

group_replication_flow_control_release_percent

Section 18.8, “Group Replication System Variables”

group_replication_force_members

Section 18.8, “Group Replication System Variables”
Section 18.4.4, “Network Partitioning”

group_replication_group_name

Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 13.4.2.11, “Functions which Configure the Source List”
Section 18.8, “Group Replication System Variables”
Section 17.4.9, “Switching Sources with Asynchronous Connection Failover”
Section 27.12.11.3, “The replication_asynchronous_connection_failover Table”

group_replication_group_seeds

Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.4.3.1, “Connections for Distributed Recovery”
Section 18.2.2, “Deploying Group Replication Locally”
Section 18.5.1, “Group Replication IP Address Permissions”
Section 18.8, “Group Replication System Variables”
Section 18.4.5, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”

group_replication_gtid_assignment_block_size

Section 18.8, “Group Replication System Variables”

group_replication_ip_allowlist

Section 18.5.1, “Group Replication IP Address Permissions”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 18.4.5, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”

group_replication_ip_whitelist

Section 18.5.1, “Group Replication IP Address Permissions”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 18.4.5, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”

group_replication_local_address

Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.4.3.1, “Connections for Distributed Recovery”
Section 18.2.2, “Deploying Group Replication Locally”
Section 18.10, “Frequently Asked Questions”
Section 18.5.1, “Group Replication IP Address Permissions”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 6.7.5.2, “Setting the TCP Port Context for MySQL Features”
Section 18.4.5, “Support For IPv6 And For Mixed IPv6 And IPv4 Groups”
Section 27.12.11.10, “The replication_group_members Table”

group_replication_member_expel_timeout

Section 2.11.4, “Changes in MySQL 8.0”
Section 18.6.6.4, “Exit Action”
Section 18.6.6.1, “Expel Timeout”
Section 18.10, “Frequently Asked Questions”
Section 18.1.4.1, “Group Membership”
Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.6.5.1, “Increasing the cache size”
Section 18.6.4, “Message Fragmentation”
Section 18.6.6, “Responses to Failure Detection and Network Partitioning”
Section 18.6.5, “XCom Cache Management”

group_replication_member_weight

Section 18.8, “Group Replication System Variables”
Section 18.1.3.1.1, “Primary Election Algorithm”

group_replication_message_cache_size

Section 18.6.6.1, “Expel Timeout”
Section 18.8, “Group Replication System Variables”
Section 18.6.5.1, “Increasing the cache size”
Section 18.6.5.2, “Reducing the cache size”
Section 18.6.5, “XCom Cache Management”

group_replication_poll_spin_loops

Section 18.6.1, “Fine Tuning the Group Communication Thread”
Section 18.8, “Group Replication System Variables”

group_replication_recovery_complete_at

Section 18.4.3.3, “Configuring Distributed Recovery”
Section 18.8, “Group Replication System Variables”

group_replication_recovery_compression_algorithm

Section 18.4.3.1.2, “Compression for Distributed Recovery”
Section 4.2.8, “Connection Compression Control”
Section 18.8, “Group Replication System Variables”
Section 18.6.3, “Message Compression”
Section 5.4.4.5.3, “Monitoring Binary Log Transaction Compression”

group_replication_recovery_get_public_key

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 18.8, “Group Replication System Variables”
Section 18.5.3.1.1, “Replication User With The Caching SHA-2 Authentication Plugin”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

group_replication_recovery_public_key_path

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 18.8, “Group Replication System Variables”
Section 18.5.3.1.1, “Replication User With The Caching SHA-2 Authentication Plugin”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

group_replication_recovery_reconnect_interval

Section 18.4.3.3, “Configuring Distributed Recovery”
Section 18.8, “Group Replication System Variables”

group_replication_recovery_retry_count

Section 18.4.3.3, “Configuring Distributed Recovery”
Section 18.4.3.4, “Fault Tolerance for Distributed Recovery”
Section 18.8, “Group Replication System Variables”

group_replication_recovery_ssl_ca

Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

group_replication_recovery_ssl_capath

Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”

group_replication_recovery_ssl_cert

Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

group_replication_recovery_ssl_cipher

Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”

group_replication_recovery_ssl_crl

Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”

group_replication_recovery_ssl_crlpath

Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”

group_replication_recovery_ssl_key

Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

group_replication_recovery_ssl_verify_server_cert

Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”

group_replication_recovery_tls_ciphersuites

Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”

group_replication_recovery_tls_version

Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”

group_replication_recovery_use_ssl

Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

group_replication_recovery_zstd_compression_level

Section 18.4.3.1.2, “Compression for Distributed Recovery”
Section 4.2.8, “Connection Compression Control”
Section 18.8, “Group Replication System Variables”
Section 18.6.3, “Message Compression”
Section 5.4.4.5.3, “Monitoring Binary Log Transaction Compression”

group_replication_single_primary_mode

Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.1.3, “Multi-Primary and Single-Primary Modes”
Section 18.1.3.2, “Multi-Primary Mode”
Section 18.1.3.1, “Single-Primary Mode”

group_replication_ssl_mode

Section 18.8, “Group Replication System Variables”
Section 18.5.3.2, “Secure Socket Layer (SSL) Connections for Distributed Recovery”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 18.4.3.1.4, “SSL and Authentication for Distributed Recovery”

group_replication_start_on_boot

Section 18.4.3.2.3, “Cloning Operations”
Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.6.6.4, “Exit Action”
Section 18.6.6.1, “Expel Timeout”
Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 18.4.3.2.1, “Prerequisites for Cloning”
Section 18.5.3.1.3, “Providing Replication User Credentials Securely”
Section 13.4.3.1, “START GROUP_REPLICATION Statement”
Section 18.7.3.2, “Upgrading a Group Replication Member”
Section 18.2.1.3, “User Credentials For Distributed Recovery”

group_replication_tls_source

Section 18.8, “Group Replication System Variables”

group_replication_transaction_size_limit

Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.6.4, “Message Fragmentation”

group_replication_unreachable_majority_timeout

Section 2.11.4, “Changes in MySQL 8.0”
Section 18.6.6.4, “Exit Action”
Section 18.8, “Group Replication System Variables”
Section 18.6.6.2, “Unreachable Majority Timeout”

gtid_executed

Section 5.6.7.6, “Cloning for Replication”
Section 2.11.14, “Copying MySQL Databases to Another Machine”
Section 17.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.3.3, “GTID Auto-Positioning”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.1.3.2, “GTID Life Cycle”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 27.12.11, “Performance Schema Replication Tables”
Section 17.1.5.2, “Provisioning a Multi-Source Replica for GTID-Based Replication”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.5.4, “Replication Channel Based Filters”
Section 17.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”
Section 17.1.4.1, “Replication Mode Concepts”
Section 13.4.1.2, “RESET MASTER Statement”
Section 17.1.3.7, “Restrictions on Replication with GTIDs”
Section 5.1.8, “Server System Variables”
Section 13.7.7.23, “SHOW MASTER STATUS Statement”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”
Section 17.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 27.12.19.7, “The log_status Table”
Section 18.4.3.2.2, “Threshold for Cloning”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”

gtid_executed_compression_period

Section 2.11.4, “Changes in MySQL 8.0”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.3.1, “GTID Format and Storage”

GTID_MODE

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 17.1.3.3, “GTID Auto-Positioning”
Section 17.2.1.2, “Usage of Row-Based Logging and Replication”

gtid_mode

Section 17.1.5.3, “Adding GTID-Based Sources to a Multi-Source Replica”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 5.6.7.6, “Cloning for Replication”
Section 2.11.14, “Copying MySQL Databases to Another Machine”
Section 17.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 17.1.4.3, “Disabling GTID Transactions Online”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 17.1.4.2, “Enabling GTID Transactions Online”
Section 12.19, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 18.9.1, “Group Replication Requirements”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.4.2, “Handling an Unexpected Halt of a Replica”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”
Section 17.1.4.1, “Replication Mode Concepts”
Section 13.4.1.2, “RESET MASTER Statement”
Section 13.4.2.5, “RESET REPLICA | SLAVE Statement”
Section 17.1.3.7, “Restrictions on Replication with GTIDs”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 17.1.7.3, “Skipping Transactions”
Section 17.1.7.3.1, “Skipping Transactions With GTIDs”
Section 17.1.7.3.2.1, “Skipping Transactions With SET GLOBAL sql_slave_skip_counter
Section 17.1.7.3.2, “Skipping Transactions Without GTIDs”
Section 17.4.9, “Switching Sources with Asynchronous Connection Failover”
Section 27.12.7.1, “The events_transactions_current Table”
Section 17.5.3, “Upgrading a Replication Setup”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”

gtid_next

Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.1.3.2, “GTID Life Cycle”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 17.1.4.1, “Replication Mode Concepts”
Section 5.1.10, “Server Status Variables”
Section 13.4.2.7, “START REPLICA | SLAVE Statement”
Section 13.4.2.9, “STOP REPLICA | SLAVE Statement”
Section 27.12.7.1, “The events_transactions_current Table”

gtid_owned

Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.3.2, “GTID Life Cycle”

gtid_purged

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 17.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.3.3, “GTID Auto-Positioning”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.1.3.2, “GTID Life Cycle”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.1.5.2, “Provisioning a Multi-Source Replica for GTID-Based Replication”
Section 17.1.4.1, “Replication Mode Concepts”
Section 13.4.1.2, “RESET MASTER Statement”
Section 17.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 18.4.3.2.2, “Threshold for Cloning”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”

H

[index top]

have_compress

Section 5.1.8, “Server System Variables”

have_dynamic_loading

Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.8, “Server System Variables”

have_geometry

Section 5.1.8, “Server System Variables”

have_openssl

Section 5.1.8, “Server System Variables”

have_profiling

Section 5.1.8, “Server System Variables”

have_query_cache

Section 5.1.8, “Server System Variables”

have_rtree_keys

Section 5.1.8, “Server System Variables”

have_ssl

Section 2.9.6, “Configuring SSL Library Support”
Section 5.1.8, “Server System Variables”

have_statement_timeout

Section 5.1.8, “Server System Variables”

have_symlink

Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 8.12.2.2, “Using Symbolic Links for MyISAM Tables on Unix”

histogram_generation_max_mem_size

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 5.1.8, “Server System Variables”

host_cache_size

Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 27.12.19.5, “The host_cache Table”

hostname

Section 13.7.5, “CLONE Statement”
Section 5.6.7.3, “Cloning Remote Data”
Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.4.3.1, “Connections for Distributed Recovery”
Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 18.5.3, “Securing Distributed Recovery Connections”
Section 5.1.8, “Server System Variables”
Section 27.12.11.10, “The replication_group_members Table”

I

[index top]

identity

Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”

immediate_server_version

Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 17.5.2, “Replication Compatibility Between MySQL Versions”
Section 17.1.6.2, “Replication Source Options and Variables”

information_schema_stats_expiry

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 14.7, “Data Dictionary Usage Differences”
Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 5.1.8, “Server System Variables”
Section 26.34, “The INFORMATION_SCHEMA STATISTICS Table”
Section 26.38, “The INFORMATION_SCHEMA TABLES Table”
Section 1.3, “What Is New in MySQL 8.0”

init_connect

Section 10.5, “Configuring Application Character Set and Collation”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.1.8, “Server System Variables”
Section 27.12.19.5, “The host_cache Table”

init_file

Section 13.1.2, “ALTER DATABASE Statement”
Section 2.10.1, “Initializing the Data Directory”
Section 8.10.2.2, “Multiple Key Caches”
Section 27.4, “Performance Schema Runtime Configuration”
Section 27.12.14.2, “Performance Schema variables_info Table”
Section 17.5.1.21, “Replication and MEMORY Tables”
Section B.3.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.3.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 16.3, “The MEMORY Storage Engine”

init_slave

Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 17.1.6.3, “Replica Server Options and Variables”

innodb

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
Section 15.8.3.7, “Excluding Buffer Pool Pages from Core Files”
Section A.16, “MySQL 8.0 FAQ: InnoDB Change Buffer”

innodb_adaptive_flushing

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_adaptive_flushing_lwm

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_adaptive_hash_index

Section 15.5.3, “Adaptive Hash Index”
Section 15.8.4, “Configuring Thread Concurrency for InnoDB”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.9, “Optimizing InnoDB Configuration Variables”
Section 13.1.37, “TRUNCATE TABLE Statement”

innodb_adaptive_hash_index_parts

Section 15.5.3, “Adaptive Hash Index”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.29, “The INFORMATION_SCHEMA INNODB_TRX Table”

innodb_adaptive_max_sleep_delay

Section 15.8.4, “Configuring Thread Concurrency for InnoDB”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_api_bk_commit_interval

Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_api_disable_rowlock

Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_api_enable_binlog

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”

innodb_api_enable_mdl

Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_api_trx_level

Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_autoextend_increment

Section 15.6.3.2, “File-Per-Table Tablespaces”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.6.3.1, “The System Tablespace”

innodb_autoinc_lock_mode

Section 15.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
Section 8.5.5, “Bulk Data Loading for InnoDB Tables”
Section 2.11.4, “Changes in MySQL 8.0”
Section 12.16, “Information Functions”
Section 15.7.1, “InnoDB Locking”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.7.3, “Locks Set by Different SQL Statements in InnoDB”
MySQL Glossary
Section 1.3, “What Is New in MySQL 8.0”

innodb_background_drop_list_empty

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_chunk_size

Section 15.8.3.1, “Configuring InnoDB Buffer Pool Size”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_dump_at_shutdown

Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”

innodb_buffer_pool_dump_now

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”

innodb_buffer_pool_dump_pct

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”

innodb_buffer_pool_filename

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”

innodb_buffer_pool_in_core_file

Section 15.8.3.7, “Excluding Buffer Pool Pages from Core Files”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.7, “Server Command Options”

innodb_buffer_pool_instances

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.8.3.1, “Configuring InnoDB Buffer Pool Size”
Section 15.8.3.2, “Configuring Multiple Buffer Pool Instances”
Section 15.6.4, “Doublewrite Buffer”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”

innodb_buffer_pool_load_abort

Section 15.14, “InnoDB Startup Options and System Variables”
Section 5.1.10, “Server Status Variables”

innodb_buffer_pool_load_at_startup

Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”
Section 5.1.10, “Server Status Variables”

innodb_buffer_pool_load_now

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”
Section 5.1.10, “Server Status Variables”

innodb_buffer_pool_size

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.9.1.6, “Compression for OLTP Workloads”
Section 15.8.3.1, “Configuring InnoDB Buffer Pool Size”
Section 15.8.3.2, “Configuring Multiple Buffer Pool Instances”
Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 5.1.10, “Server Status Variables”
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”
Section 1.3, “What Is New in MySQL 8.0”

innodb_change_buffer_max_size

Section 15.5.2, “Change Buffer”
Section 15.14, “InnoDB Startup Options and System Variables”
Section A.16, “MySQL 8.0 FAQ: InnoDB Change Buffer”
MySQL Glossary

innodb_change_buffering

Section 15.5.2, “Change Buffer”
Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.2, “Optimizing InnoDB Transaction Management”

innodb_change_buffering_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_checkpoint_disabled

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_checksum_algorithm

Section 15.1.1, “Benefits of Using InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_checksums

MySQL Glossary

innodb_cmp_per_index_enabled

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”
Section 26.51.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 15.9.1.3, “Tuning Compression for InnoDB Tables”

innodb_commit_concurrency

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_compress_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_compression_failure_threshold_pct

Section 15.9.1.6, “Compression for OLTP Workloads”
Section 15.9.1.5, “How Compression Works for InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.9.1.3, “Tuning Compression for InnoDB Tables”

innodb_compression_level

Section 15.9.1.6, “Compression for OLTP Workloads”
Section 15.9.1.5, “How Compression Works for InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.9.1.3, “Tuning Compression for InnoDB Tables”

innodb_compression_pad_pct_max

Section 15.9.1.6, “Compression for OLTP Workloads”
Section 15.9.1.5, “How Compression Works for InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.9.1.3, “Tuning Compression for InnoDB Tables”

innodb_concurrency_tickets

Section 15.8.4, “Configuring Thread Concurrency for InnoDB”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.9, “Optimizing InnoDB Configuration Variables”
Section 26.51.29, “The INFORMATION_SCHEMA INNODB_TRX Table”

innodb_data_file_path

Section 5.6.7.3, “Cloning Remote Data”
Section 15.11.2, “File Space Management”
Section 2.10.1, “Initializing the Data Directory”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 15.6.3.1, “The System Tablespace”
Section 15.21.1, “Troubleshooting InnoDB I/O Problems”

innodb_data_home_dir

Section 2.11.4, “Changes in MySQL 8.0”
Section 5.6.7.3, “Cloning Remote Data”
Section 15.6.1.2, “Creating Tables Externally”
Section 15.6.4, “Doublewrite Buffer”
Section 15.6.3.3, “General Tablespaces”
Section 2.10.1, “Initializing the Data Directory”
Section 15.18.2, “InnoDB Recovery”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.3.6, “Moving Tablespace Files While the Server is Offline”
Section 15.6.5, “Redo Log”
Section 15.6.3.5, “Temporary Tablespaces”
Section 15.21.1, “Troubleshooting InnoDB I/O Problems”
Section 13.1.37, “TRUNCATE TABLE Statement”
Section 15.6.3.4, “Undo Tablespaces”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”
Section 1.3, “What Is New in MySQL 8.0”

innodb_ddl_log_crash_reset_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_deadlock_detect

Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 15.7.5.2, “Deadlock Detection”
Section 15.7.5, “Deadlocks in InnoDB”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.11.1, “Internal Locking Methods”
MySQL Glossary
Section 1.3, “What Is New in MySQL 8.0”

innodb_dedicated_server

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_default_row_format

Section 13.1.20, “CREATE TABLE Statement”
Section 15.6.1.1, “Creating InnoDB Tables”
Section 15.6.1.3, “Importing InnoDB Tables”
Section 15.10, “InnoDB Row Formats”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.4.1, “Optimizing Data Size”

innodb_directories

Section 2.11.4, “Changes in MySQL 8.0”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 15.6.1.2, “Creating Tables Externally”
Section 15.6.3.7, “Disabling Tablespace Path Validation”
Section 15.6.3.3, “General Tablespaces”
Section 15.18.2, “InnoDB Recovery”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.3.6, “Moving Tablespace Files While the Server is Offline”
Section 15.6.5, “Redo Log”
Section 13.1.37, “TRUNCATE TABLE Statement”
Section 15.6.3.4, “Undo Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

innodb_disable_sort_file_cache

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_doublewrite

Section 15.6.4, “Doublewrite Buffer”
Section 15.11.1, “InnoDB Disk I/O”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”

innodb_doublewrite_batch_size

Section 15.6.4, “Doublewrite Buffer”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_doublewrite_dir

Section 15.6.4, “Doublewrite Buffer”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_doublewrite_files

Section 15.6.4, “Doublewrite Buffer”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_doublewrite_pages

Section 15.6.4, “Doublewrite Buffer”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_extend_and_initialize

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.3.8, “Optimizing Tablespace Space Allocation on Linux”
Section 1.3, “What Is New in MySQL 8.0”

innodb_fast_shutdown

Section 15.18.2, “InnoDB Recovery”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 2.11.5, “Preparing Your Installation for Upgrade”
Section 5.1.19, “The Server Shutdown Process”
Section 2.11.12, “Upgrade Troubleshooting”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”

innodb_fil_make_page_dirty_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_file_per

Section 13.1.20.2, “CREATE TEMPORARY TABLE Statement”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_file_per_table

Section 15.1.2, “Best Practices for InnoDB Tables”
Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.20.3, “CREATE TABLE ... LIKE Statement”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 15.9.1.2, “Creating Compressed Tables”
Section 15.6.1.1, “Creating InnoDB Tables”
Section 15.6.1.2, “Creating Tables Externally”
Section 15.11.2, “File Space Management”
Section 15.6.3.2, “File-Per-Table Tablespaces”
Section 13.1.20.1, “Files Created by CREATE TABLE”
Section 13.7.8.3, “FLUSH Statement”
Section 15.9.1.5, “How Compression Works for InnoDB Tables”
Section 15.6.1.3, “Importing InnoDB Tables”
Section 15.2, “InnoDB and the ACID Model”
Section 15.10, “InnoDB Row Formats”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 13.7.3.4, “OPTIMIZE TABLE Statement”
Section 15.11.5, “Reclaiming Disk Space with TRUNCATE TABLE”
Section 17.4.6, “Replicating Different Databases to Different Replicas”
Section 24.6, “Restrictions and Limitations on Partitioning”
Section 15.9.1.7, “SQL Compression Syntax Warnings and Errors”
Section 15.21.3, “Troubleshooting InnoDB Data Dictionary Operations”

innodb_fill_factor

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.2.3, “Sorted Index Builds”
Section 15.6.2.2, “The Physical Structure of an InnoDB Index”

innodb_flush_log_at_timeout

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.5.4, “Log Buffer”

innodb_flush_log_at_trx_commit

Section 13.1.1, “Atomic Data Definition Statement Support”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.4.2, “Handling an Unexpected Halt of a Replica”
Section 15.2, “InnoDB and the ACID Model”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.5.4, “Log Buffer”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 17.5.1.28, “Replication and Source or Replica Shutdowns”
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”

innodb_flush_method

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.6.4, “Doublewrite Buffer”
Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
Section 15.6.3.2, “File-Per-Table Tablespaces”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 5.1.10, “Server Status Variables”
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”
Section 1.3, “What Is New in MySQL 8.0”

innodb_flush_neighbors

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_flush_sync

Section 15.8.7, “Configuring InnoDB I/O Capacity”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_flushing_avg_loops

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_force_load_corrupted

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_force_recovery

Section 13.1.32, “DROP TABLE Statement”
Section 15.21.2, “Forcing InnoDB Recovery”
Section 1.6, “How to Report Bugs or Problems”
Section 15.18.2, “InnoDB Recovery”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 2.11.13, “Rebuilding or Repairing Tables or Indexes”

innodb_fsync_threshold

Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_ft_aux_table

Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 26.51.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 26.51.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 26.51.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 26.51.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

innodb_ft_cache_size

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 26.51.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”

innodb_ft_enable_diag_print

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_ft_enable_stopword

Section 12.10.2, “Boolean Full-Text Searches”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 12.10.1, “Natural Language Full-Text Searches”

innodb_ft_max_token_size

Section 12.10.2, “Boolean Full-Text Searches”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.4, “Full-Text Stopwords”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 12.10.8, “ngram Full-Text Parser”

innodb_ft_min_token_size

Section 12.10.2, “Boolean Full-Text Searches”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.4, “Full-Text Stopwords”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 12.10.9, “MeCab Full-Text Parser Plugin”
Section 12.10.1, “Natural Language Full-Text Searches”
Section 12.10.8, “ngram Full-Text Parser”

innodb_ft_num_word_optimize

Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 13.7.3.4, “OPTIMIZE TABLE Statement”

innodb_ft_result_cache_limit

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_ft_server_stopword_table

Section 12.10.2, “Boolean Full-Text Searches”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.4, “Full-Text Stopwords”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 12.10.1, “Natural Language Full-Text Searches”
Section 26.51.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

innodb_ft_sort_pll_degree

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_ft_total_cache_size

Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”

innodb_ft_user_stopword_table

Section 12.10.2, “Boolean Full-Text Searches”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.4, “Full-Text Stopwords”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 12.10.1, “Natural Language Full-Text Searches”
Section 26.51.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

innodb_idle_flush_pct

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 1.3, “What Is New in MySQL 8.0”

innodb_io_capacity

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.8.7, “Configuring InnoDB I/O Capacity”
Section 15.14, “InnoDB Startup Options and System Variables”
Section A.16, “MySQL 8.0 FAQ: InnoDB Change Buffer”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_io_capacity_max

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.8.7, “Configuring InnoDB I/O Capacity”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_limit_optimistic_insert_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_lock_wait_timeout

Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 15.7.5.2, “Deadlock Detection”
Section 15.7.5, “Deadlocks in InnoDB”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.11.1, “Internal Locking Methods”
MySQL Glossary
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.32, “Replication Retries and Timeouts”
Section 1.3, “What Is New in MySQL 8.0”

innodb_log_buffer_size

Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.5.4, “Log Buffer”
MySQL Glossary
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 1.3, “What Is New in MySQL 8.0”

innodb_log_checkpoint_fuzzy_now

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_log_checkpoint_now

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_log_checksums

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_log_compressed_pages

Section 15.9.1.6, “Compression for OLTP Workloads”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_log_file_size

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
Section 2.10.1, “Initializing the Data Directory”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 15.6.5, “Redo Log”
Section 5.1.9, “Using System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_log_files_in_group

Section 15.8.12, “Enabling Automatic Configuration for a Dedicated MySQL Server”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 15.6.5, “Redo Log”

innodb_log_group_home_dir

Section 5.6.7.3, “Cloning Remote Data”
Section 2.10.1, “Initializing the Data Directory”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.6.5, “Redo Log”
Section 15.6.3.4, “Undo Tablespaces”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”

innodb_log_spin_cpu_abs_lwm

Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 1.3, “What Is New in MySQL 8.0”

innodb_log_spin_cpu_pct_hwm

Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 1.3, “What Is New in MySQL 8.0”

innodb_log_wait_for_flush_spin_hwm

Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 1.3, “What Is New in MySQL 8.0”

innodb_log_write_ahead_size

Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.4, “Optimizing InnoDB Redo Logging”

innodb_log_writer_threads

Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.4, “Optimizing InnoDB Redo Logging”

innodb_lru_scan_depth

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_max_dirty_pages_pct

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 1.3, “What Is New in MySQL 8.0”

innodb_max_dirty_pages_pct_lwm

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_max_purge_lag

Section 15.3, “InnoDB Multi-Versioning”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.8.9, “Purge Configuration”

innodb_max_purge_lag_delay

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.9, “Purge Configuration”

innodb_max_undo_log_size

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.3.4, “Undo Tablespaces”

innodb_merge_threshold_set_all_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_monitor_disable

Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 13.7.7.15, “SHOW ENGINE Statement”
Section 26.51.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_monitor_enable

Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 13.7.7.15, “SHOW ENGINE Statement”
Section 26.51.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_monitor_reset

Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_monitor_reset_all

Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 26.51.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_numa_interleave

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_old_blocks_pct

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.3.3, “Making the Buffer Pool Scan Resistant”
MySQL Glossary

innodb_old_blocks_time

Section 15.5.1, “Buffer Pool”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.3.3, “Making the Buffer Pool Scan Resistant”

innodb_online_alter_log_max_size

Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.12.5, “Online DDL Failure Conditions”
Section 15.12.3, “Online DDL Space Requirements”

innodb_open_files

Section 15.14, “InnoDB Startup Options and System Variables”
Section 5.1.8, “Server System Variables”

innodb_optimize_fulltext_only

Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 15.6.2.4, “InnoDB FULLTEXT Indexes”
Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 13.7.3.4, “OPTIMIZE TABLE Statement”
Section 26.51.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

innodb_page_cleaners

Section 15.8.3.5, “Configuring Buffer Pool Flushing”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary

innodb_page_size

Section 5.6.7.3, “Cloning Remote Data”
Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 15.9.1.2, “Creating Compressed Tables”
Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 15.8.3.7, “Excluding Buffer Pool Pages from Core Files”
Section 15.11.2, “File Space Management”
Section 15.6.3.3, “General Tablespaces”
Section 15.9.1.5, “How Compression Works for InnoDB Tables”
Section 15.6.1.3, “Importing InnoDB Tables”
Section 15.22, “InnoDB Limits”
Section 15.9.2, “InnoDB Page Compression”
Section 15.23, “InnoDB Restrictions and Limitations”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.4.7, “Limits on Table Column Count and Row Size”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 15.9.1.1, “Overview of Table Compression”
Section 15.6.3.9, “Tablespace AUTOEXTEND_SIZE Configuration”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 15.6.2.2, “The Physical Structure of an InnoDB Index”
Section 15.6.3.1, “The System Tablespace”
Section 15.20.9, “Troubleshooting the InnoDB memcached Plugin”
Section 15.6.3.4, “Undo Tablespaces”

innodb_parallel_read_threads

Section 13.7.3.2, “CHECK TABLE Statement”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_print_all_deadlocks

Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 15.7.5, “Deadlocks in InnoDB”
Section 15.7.5.3, “How to Minimize and Handle Deadlocks”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.21, “InnoDB Troubleshooting”

innodb_print_ddl_logs

Section 13.1.1, “Atomic Data Definition Statement Support”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_purge_batch_size

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.9, “Purge Configuration”

innodb_purge_rseg_truncate_frequency

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.9, “Purge Configuration”
Section 15.6.3.4, “Undo Tablespaces”

innodb_purge_threads

Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.8.9, “Purge Configuration”

innodb_random_read_ahead

Section 15.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary

innodb_read_ahead_threshold

Section 15.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_read_io_threads

Section 15.8.5, “Configuring the Number of Background InnoDB I/O Threads”
Section 15.17.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.6, “Using Asynchronous I/O on Linux”

innodb_read_only

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
Section 14.7, “Data Dictionary Usage Differences”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 5.1.8, “Server System Variables”
Section 26.34, “The INFORMATION_SCHEMA STATISTICS Table”
Section 26.38, “The INFORMATION_SCHEMA TABLES Table”

innodb_redo_log_archive_dirs

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.5, “Redo Log”

innodb_redo_log_encrypt

Section 5.6.7.4, “Cloning Encrypted Data”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_replication_delay

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_rollback_on_timeout

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_rollback_segments

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.6, “Undo Logs”
Section 15.6.3.4, “Undo Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

innodb_saved_page_number_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_sort_buffer_size

Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.12.3, “Online DDL Space Requirements”

innodb_spin_wait_delay

Section 15.8.8, “Configuring Spin Lock Polling”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_spin_wait_pause_multiplier

Section 15.8.8, “Configuring Spin Lock Polling”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_stats_auto_recalc

Section 15.8.10.1.1, “Configuring Automatic Statistics Calculation for Persistent Optimizer Statistics”
Section 15.8.10, “Configuring Optimizer Statistics for InnoDB”
Section 15.8.10.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 13.1.20, “CREATE TABLE Statement”
Section 15.8.10.1.6, “InnoDB Persistent Statistics Tables Example”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_stats_include_delete_marked

Section 15.8.10.1.4, “Including Delete-marked Records in Persistent Statistics Calculations”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_stats_method

Section 8.3.8, “InnoDB and MyISAM Index Statistics Collection”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary

innodb_stats_on_metadata

Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_stats_persistent

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 15.8.10, “Configuring Optimizer Statistics for InnoDB”
Section 15.8.10.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 15.8.10.1, “Configuring Persistent Optimizer Statistics Parameters”
Section 13.1.15, “CREATE INDEX Statement”
Section 13.1.20, “CREATE TABLE Statement”
Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.5.10, “Optimizing InnoDB for Systems with Many Tables”

innodb_stats_persistent_sample_pages

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 15.8.10.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 15.8.10.1.3, “Configuring the Number of Sampled Pages for InnoDB Optimizer Statistics”
Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_stats_sample_pages

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_stats_transient_sample_pages

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 15.8.10.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_status_output

Section 15.17.2, “Enabling InnoDB Monitors”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_status_output_locks

Section 15.17.2, “Enabling InnoDB Monitors”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_strict_mode

Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 13.1.20.2, “CREATE TEMPORARY TABLE Statement”
Section 15.9.1.2, “Creating Compressed Tables”
Section 15.9.1.5, “How Compression Works for InnoDB Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 5.1.11, “Server SQL Modes”
Section 15.9.1.7, “SQL Compression Syntax Warnings and Errors”
Section 1.3, “What Is New in MySQL 8.0”

innodb_sync_array_size

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_sync_debug

Section 15.14, “InnoDB Startup Options and System Variables”
Section 2.9.7, “MySQL Source-Configuration Options”

innodb_sync_spin_loops

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_table_locks

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.7.3, “Locks Set by Different SQL Statements in InnoDB”

innodb_temp_data_file_path

Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.6.3.5, “Temporary Tablespaces”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”

innodb_temp_tablespaces_dir

Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.5, “Redo Log”
Section 15.6.3.5, “Temporary Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

innodb_thread_concurrency

Section 15.8.4, “Configuring Thread Concurrency for InnoDB”
Section 15.17.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 15.14, “InnoDB Startup Options and System Variables”
Section A.15, “MySQL 8.0 FAQ: MySQL Enterprise Thread Pool”
Section 8.5.9, “Optimizing InnoDB Configuration Variables”

innodb_thread_sleep_delay

Section 15.8.4, “Configuring Thread Concurrency for InnoDB”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_tmpdir

Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.12.5, “Online DDL Failure Conditions”
Section 15.12.3, “Online DDL Space Requirements”
Section 15.6.5, “Redo Log”

innodb_trx_purge_view_update_only_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_trx_rseg_n_slots_debug

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_undo_directory

Section 2.11.4, “Changes in MySQL 8.0”
Section 5.6.7.3, “Cloning Remote Data”
Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 15.6.1.2, “Creating Tables Externally”
Section 15.6.3.3, “General Tablespaces”
Section 15.18.2, “InnoDB Recovery”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.3.6, “Moving Tablespace Files While the Server is Offline”
Section 15.6.5, “Redo Log”
Section 15.6.3.4, “Undo Tablespaces”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”
Section 1.3, “What Is New in MySQL 8.0”

innodb_undo_log_encrypt

Section 5.6.7.4, “Cloning Encrypted Data”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 15.14, “InnoDB Startup Options and System Variables”

innodb_undo_log_truncate

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.6.3.4, “Undo Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

innodb_undo_tablespaces

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.8.2, “Configuring InnoDB for Read-Only Operation”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 15.6.3.4, “Undo Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

innodb_use_fdatasync

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_use_native_aio

Section 2.11.4, “Changes in MySQL 8.0”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 15.8.6, “Using Asynchronous I/O on Linux”

innodb_validate_tablespace_paths

Section 15.6.3.7, “Disabling Tablespace Path Validation”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 1.3, “What Is New in MySQL 8.0”

innodb_version

Section 15.14, “InnoDB Startup Options and System Variables”

innodb_write_io_threads

Section 15.8.5, “Configuring the Number of Background InnoDB I/O Threads”
Section 15.6.4, “Doublewrite Buffer”
Section 15.17.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.8.6, “Using Asynchronous I/O on Linux”

insert_id

Section 16.8.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.1.8, “Server System Variables”

interactive_timeout

Section B.3.2.9, “Communication Errors and Aborted Connections”
Section 5.1.8, “Server System Variables”

internal_tmp_disk_storage_engine

Section 8.12.3.1, “How MySQL Uses Memory”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section 5.1.8, “Server System Variables”
Section 15.6.3.5, “Temporary Tablespaces”
Section 1.3, “What Is New in MySQL 8.0”

internal_tmp_mem_storage_engine

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

J

[index top]

join_buffer_size

Section 8.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
Section 8.2.1.4, “Hash Join Optimization”
Section 8.2.1.7, “Nested-Loop Join Algorithms”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

K

[index top]

keep_files_on_create

Section 5.1.8, “Server System Variables”

key_buffer_size

Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 8.8.5, “Estimating Query Performance”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 15.8.1, “InnoDB Startup Configuration”
Section B.3.7, “Known Issues in MySQL”
Section 8.10.2.2, “Multiple Key Caches”
Section 8.2.5.3, “Optimizing DELETE Statements”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 8.10.2.6, “Restructuring a Key Cache”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 5.1.9.5, “Structured System Variables”
Section 8.10.2, “The MyISAM Key Cache”

key_cache_age_threshold

Section 8.10.2.3, “Midpoint Insertion Strategy”
Section 5.1.8, “Server System Variables”
Section 5.1.9.5, “Structured System Variables”

key_cache_block_size

Section 8.10.2.5, “Key Cache Block Size”
Section 8.10.2.6, “Restructuring a Key Cache”
Section 5.1.8, “Server System Variables”
Section 5.1.9.5, “Structured System Variables”

key_cache_division_limit

Section 8.10.2.3, “Midpoint Insertion Strategy”
Section 5.1.8, “Server System Variables”
Section 5.1.9.5, “Structured System Variables”

keyring_aws_cmk_id

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.11, “Plugin-Specific Keyring Key-Management Functions”
Section 6.4.4.5, “Using the keyring_aws Amazon Web Services Keyring Plugin”

keyring_aws_conf_file

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.5, “Using the keyring_aws Amazon Web Services Keyring Plugin”

keyring_aws_data_file

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.11, “Plugin-Specific Keyring Key-Management Functions”
Section 6.4.4.5, “Using the keyring_aws Amazon Web Services Keyring Plugin”

keyring_aws_region

Section 6.4.4.13, “Keyring System Variables”

keyring_encrypted_file_data

Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 6.4.4.13, “Keyring System Variables”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 6.4.4.3, “Using the keyring_encrypted_file Keyring Plugin”

keyring_encrypted_file_password

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.3, “Using the keyring_encrypted_file Keyring Plugin”

keyring_file_data

Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.9, “Migrating Keys Between Keyring Keystores”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 6.4.4.2, “Using the keyring_file File-Based Plugin”

keyring_hashicorp_auth_path

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_ca_path

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_caching

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_commit_auth_path

Section 6.4.4.13, “Keyring System Variables”

keyring_hashicorp_commit_ca_path

Section 6.4.4.13, “Keyring System Variables”

keyring_hashicorp_commit_caching

Section 6.4.4.13, “Keyring System Variables”

keyring_hashicorp_commit_role_id

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_commit_server_url

Section 6.4.4.13, “Keyring System Variables”

keyring_hashicorp_commit_store_path

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_role_id

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_secret_id

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_server_url

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_hashicorp_store_path

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

keyring_oci_ca_certificate

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_compartment

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_encryption_endpoint

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_key_file

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_key_fingerprint

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_management_endpoint

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_master_key

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_secrets_endpoint

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_tenancy

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_user

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_vaults_endpoint

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_oci_virtual_vault

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.7, “Using the Oracle Cloud Infrastructure Vault Keyring Plugin”

keyring_okv_conf_dir

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.4, “Using the keyring_okv KMIP Plugin”

keyring_operations

Section 6.4.4.13, “Keyring System Variables”
Section 6.4.4.9, “Migrating Keys Between Keyring Keystores”

L

[index top]

large_files_support

Section 24.6, “Restrictions and Limitations on Partitioning”
Section 5.1.8, “Server System Variables”

large_page_size

Section 5.1.8, “Server System Variables”

large_pages

Section 5.1.8, “Server System Variables”

last_insert_id

Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”

lc_messages

Section 5.1.8, “Server System Variables”
Section 10.12, “Setting the Error Message Language”

lc_messages_dir

Section 5.1.8, “Server System Variables”
Section 10.12, “Setting the Error Message Language”

lc_time_names

Section 12.7, “Date and Time Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 10.16, “MySQL Server Locale Support”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 12.8, “String Functions and Operators”

license

Section 5.1.8, “Server System Variables”

local

Section 13.2.8, “LOAD XML Statement”

local_infile

Section 13.2.7, “LOAD DATA Statement”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”
Section 5.1.8, “Server System Variables”

lock_order

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_debug_loop

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_debug_missing_arc

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_debug_missing_key

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_debug_missing_unlock

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_dependencies

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_extra_dependencies

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_output_directory

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_print_txt

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_trace_loop

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_trace_missing_arc

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_trace_missing_key

Section 5.9.3, “The LOCK_ORDER Tool”

lock_order_trace_missing_unlock

Section 5.9.3, “The LOCK_ORDER Tool”

lock_wait_timeout

Section 13.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements”
Section 5.1.8, “Server System Variables”

locked_in_memory

Section 5.1.8, “Server System Variables”

log

Section 2.11.4, “Changes in MySQL 8.0”
Section 18.9.1, “Group Replication Requirements”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 17.2.2.3, “Startup Options and Replication Channels”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”

log_bin

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 2.11.4, “Changes in MySQL 8.0”
Section 17.5.5, “How to Report Replication Bugs or Problems”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”
Section 13.4.1.2, “RESET MASTER Statement”
Section 17.1.2.1, “Setting the Replication Source Configuration”
Section 5.4.4, “The Binary Log”

log_bin_basename

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 5.4.4, “The Binary Log”

log_bin_index

Section 17.1.6.4, “Binary Logging Options and Variables”

log_bin_trust_function_creators

Section 17.1.6.4, “Binary Logging Options and Variables”
Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”
Section 25.7, “Stored Program Binary Logging”

log_bin_use_v

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.6.11, “NDB Cluster Replication Conflict Resolution”

log_error

Section 5.4.2.2, “Default Error Log Destination Configuration”
Section 5.5.3, “Error Log Components”
Section 5.4.2.7, “Error Logging in JSON Format”
Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

log_error_services

Section 5.4.2.2, “Default Error Log Destination Configuration”
Section 5.5.3, “Error Log Components”
Section 5.4.2.1, “Error Log Configuration”
Section 5.4.2.7, “Error Logging in JSON Format”
Section 5.4.2.8, “Error Logging to the System Log”
Section 5.4.2.6, “Rule-Based Error Log Filtering (log_filter_dragnet)”
Section 5.1.8, “Server System Variables”
Section 27.12.19.1, “The error_log Table”
Section 1.3, “What Is New in MySQL 8.0”

log_error_suppression_list

Section 5.5.3, “Error Log Components”
Section 5.4.2.1, “Error Log Configuration”
Section 5.4.2.5, “Priority-Based Error Log Filtering (log_filter_internal)”
Section 5.1.8, “Server System Variables”
Section 5.4.2.4, “Types of Error Log Filtering”

log_error_verbosity

Section 2.11.4, “Changes in MySQL 8.0”
Section B.3.2.9, “Communication Errors and Aborted Connections”
Section 15.6.3.7, “Disabling Tablespace Path Validation”
Section 5.5.3, “Error Log Components”
Section 5.4.2.1, “Error Log Configuration”
Section 5.4.2.9, “Error Log Output Format”
Section 5.4.2.8, “Error Logging to the System Log”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 18.3, “Monitoring Group Replication”
Section B.3.2.7, “MySQL server has gone away”
Section 27.12.9, “Performance Schema Connection Attribute Tables”
Section 27.15, “Performance Schema System Variables”
Section 5.4.2.5, “Priority-Based Error Log Filtering (log_filter_internal)”
Section 5.4.2.6, “Rule-Based Error Log Filtering (log_filter_dragnet)”
Section 5.1.7, “Server Command Options”
Section 5.1.3, “Server Configuration Validation”
Section 5.1.8, “Server System Variables”
Section 5.4.2.4, “Types of Error Log Filtering”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”
Section 1.3, “What Is New in MySQL 8.0”

log_output

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 5.4.3, “The General Query Log”
Section 5.4.5, “The Slow Query Log”

log_queries_not_using_indexes

Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

log_raw

Section 5.1.8, “Server System Variables”

log_slave_updates

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.4.7, “Improving Replication Performance”
Section 23.6.3, “Known Issues in NDB Cluster Replication”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.6.10, “NDB Cluster Replication: Bidrectional and Circular Replication”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”
Section 17.1.2.2, “Setting the Replica Configuration”
Section 17.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 5.4.4, “The Binary Log”

log_slow_admin_statements

Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

log_slow_extra

Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

log_slow_slave_statements

Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.4.5, “The Slow Query Log”

log_statements_unsafe_for_binlog

Section 17.1.6.4, “Binary Logging Options and Variables”

log_syslog

Section 5.1.8, “Server System Variables”

log_syslog_facility

Section 5.4.2.8, “Error Logging to the System Log”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.8, “Server System Variables”

log_syslog_include_pid

Section 5.4.2.8, “Error Logging to the System Log”
Section 5.1.8, “Server System Variables”

log_syslog_tag

Section 5.4.2.8, “Error Logging to the System Log”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.1.8, “Server System Variables”

log_throttle_queries_not_using_indexes

Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

log_timestamps

Section 5.4.2.9, “Error Log Output Format”
Section 5.1.8, “Server System Variables”
Section 27.12.19.1, “The error_log Table”
Section 5.4.3, “The General Query Log”
Section 5.4.5, “The Slow Query Log”

long_query_time

Section 5.4, “MySQL Server Logs”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

low_priority_updates

Section A.14, “MySQL 8.0 FAQ: Replication”
Section 5.1.8, “Server System Variables”
Section 8.11.2, “Table Locking Issues”

lower

Section 18.9.1, “Group Replication Requirements”

lower_case_file_system

Section 5.1.8, “Server System Variables”

lower_case_table_names

Section 2.3.3.3.1.6, “Advanced Options”
Section 2.11.4, “Changes in MySQL 8.0”
Section 13.1.20.5, “FOREIGN KEY Constraints”
Section 13.7.1.6, “GRANT Statement”
Section 18.8, “Group Replication System Variables”
Section 17.2.5, “How Servers Evaluate Replication Filtering Rules”
Section 1.6, “How to Report Bugs or Problems”
Section 9.2.3, “Identifier Case Sensitivity”
Section 13.2.5, “IMPORT TABLE Statement”
Section 15.6.1.3, “Importing InnoDB Tables”
Section 15.6.1.4, “Moving or Copying InnoDB Tables”
Section 18.7.3.1, “Online Upgrade Considerations”
Section 2.11.5, “Preparing Your Installation for Upgrade”
Section 17.5.1.39, “Replication and Variables”
Section 13.7.1.8, “REVOKE Statement”
Section 5.1.8, “Server System Variables”
Section 13.7.7.39, “SHOW TABLES Statement”
Section 26.51.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”
Section 26.51.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”
Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”
Section 23.1.4, “What is New in NDB Cluster”

M

[index top]

mandatory_roles

Section 6.2.11, “Account Categories”
Section 13.7.1.4, “DROP ROLE Statement”
Section 13.7.1.5, “DROP USER Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.8, “REVOKE Statement”
Section 5.1.8, “Server System Variables”
Section 13.7.1.11, “SET ROLE Statement”
Section 13.7.7.21, “SHOW GRANTS Statement”
Section 5.1.9.1, “System Variable Privileges”
Section 6.2.10, “Using Roles”

master

Section 2.11.4, “Changes in MySQL 8.0”

master_info_repository

Section 2.11.4, “Changes in MySQL 8.0”
Section 5.6.7.6, “Cloning for Replication”
Section 18.9.1, “Group Replication Requirements”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.4.2, “Replication Metadata Repositories”
Section 13.4.2.5, “RESET REPLICA | SLAVE Statement”
Section 17.2.2.3, “Startup Options and Replication Channels”
Section 1.3, “What Is New in MySQL 8.0”

master_verify_checksum

Section 17.1.6.4, “Binary Logging Options and Variables”
MySQL Glossary
Section 5.4.4, “The Binary Log”

max_allowed_packet

Section 12.20.1, “Aggregate Function Descriptions”
Section 5.4.4.5.1, “Behaviors When Binary Log Transaction Compression is Enabled”
Section 2.11.4, “Changes in MySQL 8.0”
Section 5.6.7.3, “Cloning Remote Data”
Section B.3.2.9, “Communication Errors and Aborted Connections”
Section 12.4.2, “Comparison Functions and Operators”
Section 11.7, “Data Type Storage Requirements”
Section B.3.4.6, “Deleting Rows from Related Tables”
Section 8.12.3.1, “How MySQL Uses Memory”
Section B.3.2.3, “Lost connection to MySQL server”
Section B.3.2.7, “MySQL server has gone away”
Section 23.6.11, “NDB Cluster Replication Conflict Resolution”
Section B.3.2.8, “Packet Too Large”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.20, “Replication and max_allowed_packet”
Section 5.1.8, “Server System Variables”
Section 12.8, “String Functions and Operators”
Section 11.3.4, “The BLOB and TEXT Types”
Section 11.5, “The JSON Data Type”
Section 5.6.6.3, “Using Version Tokens”
Section 20.5.6.2, “X Plugin Options and System Variables”

max_binlog_cache_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 5.4.4, “The Binary Log”

max_binlog_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.1.3.1, “GTID Format and Storage”
Section 5.4, “MySQL Server Logs”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.4.6, “Server Log Maintenance”
Section 5.4.4, “The Binary Log”
Section 17.2.4.1, “The Relay Log”

max_binlog_stmt_cache_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 8.12.3.1, “How MySQL Uses Memory”

max_connect_errors

Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 5.1.8, “Server System Variables”
Section 27.12.19.5, “The host_cache Table”

max_connections

Section 5.1.12.2, “Administrative Connection Management”
Section 2.11.4, “Changes in MySQL 8.0”
Section 5.1.12.1, “Connection Interfaces”
Section 5.9.1.4, “Debugging mysqld under gdb”
Section 14.4, “Dictionary Object Cache”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 27.15, “Performance Schema System Variables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 27.12.19.9, “The processlist Table”
Section 5.6.3.3, “Thread Pool Operation”
Section B.3.2.5, “Too many connections”
Section 1.3, “What Is New in MySQL 8.0”
Section 20.5.6.2, “X Plugin Options and System Variables”

max_delayed_threads

Section 5.1.8, “Server System Variables”

max_digest_length

Section 12.14, “Encryption and Compression Functions”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 27.10, “Performance Schema Statement Digests and Sampling”
Section 27.15, “Performance Schema System Variables”
Section 5.1.8, “Server System Variables”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”

max_error_count

Section 2.11.4, “Changes in MySQL 8.0”
Section 13.2.7, “LOAD DATA Statement”
Section 13.6.7.4, “RESIGNAL Statement”
Section 5.1.8, “Server System Variables”
Section 13.7.7.17, “SHOW ERRORS Statement”
Section 13.7.7.42, “SHOW WARNINGS Statement”
Section 13.6.7.7, “The MySQL Diagnostics Area”

max_execution_time

Section 8.9.3, “Optimizer Hints”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 13.2.15, “WITH (Common Table Expressions)”

max_heap_table_size

Section 8.12.3.1, “How MySQL Uses Memory”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 8.4.6, “Limits on Table Size”
Section 17.5.1.21, “Replication and MEMORY Tables”
Section 17.5.1.39, “Replication and Variables”
Section 13.6.6.5, “Restrictions on Server-Side Cursors”
Section 5.1.8, “Server System Variables”
Section 16.3, “The MEMORY Storage Engine”

max_insert_delayed_threads

Section 5.1.8, “Server System Variables”

max_join_size

Section 8.8.2, “EXPLAIN Output Format”
Section 4.5.1.6, “mysql Client Tips”
Section 5.1.8, “Server System Variables”
Section 13.7.6.1, “SET Syntax for Variable Assignment”

max_length_for_sort_data

Section 8.2.1.16, “ORDER BY Optimization”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

max_points_in_geometry

Section 5.1.8, “Server System Variables”
Section 12.17.8, “Spatial Operator Functions”

max_prepared_stmt_count

Section 8.10.3, “Caching of Prepared Statements and Stored Programs”
Section 13.5.3, “DEALLOCATE PREPARE Statement”
Section 27.15, “Performance Schema System Variables”
Section 13.5, “Prepared Statements”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

max_relay_log_size

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.4.1, “The Relay Log”

max_seeks_for_key

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 5.1.8, “Server System Variables”

max_sort_length

Section B.3.7, “Known Issues in MySQL”
Section 8.2.1.16, “ORDER BY Optimization”
Section 13.2.10, “SELECT Statement”
Section 5.1.8, “Server System Variables”
Section 11.3.4, “The BLOB and TEXT Types”
Section 11.5, “The JSON Data Type”

max_sp_recursion_depth

Section 5.1.8, “Server System Variables”
Section 25.2.1, “Stored Routine Syntax”

max_user_connections

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 13.7.8.3, “FLUSH Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.8, “Server System Variables”
Section 6.2.20, “Setting Account Resource Limits”

max_write_lock_count

Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 8.11.4, “Metadata Locking”
Section 5.1.8, “Server System Variables”
Section 8.11.2, “Table Locking Issues”

mecab_rc_file

Section 12.10.9, “MeCab Full-Text Parser Plugin”
Section 5.1.8, “Server System Variables”

metadata_locks_cache_size

Section 5.1.8, “Server System Variables”

metadata_locks_hash_instances

Section 5.1.8, “Server System Variables”

min_examined_row_limit

Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

myisam_data_pointer_size

Section 13.1.20, “CREATE TABLE Statement”
Section 8.4.6, “Limits on Table Size”
Section 5.1.8, “Server System Variables”

myisam_max_sort_file_size

Section 16.2.1, “MyISAM Startup Options”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 5.1.8, “Server System Variables”

myisam_mmap_size

Section 5.1.8, “Server System Variables”

myisam_recover_options

Section 16.2.1, “MyISAM Startup Options”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 5.1.8, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section B.3.2.17, “Table-Corruption Issues”
Section 16.2, “The MyISAM Storage Engine”
Section 5.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

myisam_repair_threads

Section 5.1.8, “Server System Variables”

myisam_sort_buffer_size

Section 13.1.9, “ALTER TABLE Statement”
Section 16.2.1, “MyISAM Startup Options”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 5.1.8, “Server System Variables”

myisam_stats_method

Section 8.3.8, “InnoDB and MyISAM Index Statistics Collection”
Section 5.1.8, “Server System Variables”

myisam_use_mmap

Section 8.12.3.1, “How MySQL Uses Memory”
Section 5.1.8, “Server System Variables”

mysql_firewall_mode

Section 6.4.7.4, “MySQL Enterprise Firewall Reference”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”

mysql_firewall_trace

Section 6.4.7.4, “MySQL Enterprise Firewall Reference”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”

mysql_native_password_proxy_users

Section 6.2.18, “Proxy Users”
Section 5.1.8, “Server System Variables”

mysqlx_bind_address

Section 5.1.14, “Network Namespace Support”
Section 20.5.6.2, “X Plugin Options and System Variables”
Section 20.5.6.3, “X Plugin Status Variables”

mysqlx_compression_algorithms

Section 20.5.5, “Connection Compression with X Plugin”
Section 20.5.6.2, “X Plugin Options and System Variables”
Section 20.5.6.3, “X Plugin Status Variables”

mysqlx_connect_timeout

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_deflate_default_compression_level

Section 20.5.5, “Connection Compression with X Plugin”
Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_deflate_max_client_compression_level

Section 20.5.5, “Connection Compression with X Plugin”
Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_document_id_unique_prefix

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_enable_hello_notice

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_idle_worker_thread_timeout

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_interactive_timeout

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_lz

Section 20.5.5, “Connection Compression with X Plugin”
Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_max_allowed_packet

Section 20.5.5, “Connection Compression with X Plugin”
Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_max_connections

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_min_worker_threads

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_port

Section 5.6.7.13, “Clone Plugin Limitations”
Section 13.7.5, “CLONE Statement”
Section 5.6.7.3, “Cloning Remote Data”
Section 20.3.1, “MySQL Shell”
Section 20.4.1, “MySQL Shell”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 6.7.5.2, “Setting the TCP Port Context for MySQL Features”
Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_port_open_timeout

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_read_timeout

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_socket

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_ssl_ca

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_ssl_capath

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_ssl_cert

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_ssl_cipher

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_ssl_crl

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_ssl_crlpath

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_ssl_key

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_wait_timeout

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_write_timeout

Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_zstd_default_compression_level

Section 20.5.5, “Connection Compression with X Plugin”
Section 20.5.6.2, “X Plugin Options and System Variables”

mysqlx_zstd_max_client_compression_level

Section 20.5.5, “Connection Compression with X Plugin”
Section 20.5.6.2, “X Plugin Options and System Variables”

N

[index top]

named_pipe

Section B.3.2.2, “Can't connect to [local] MySQL server”
Section 4.2.3, “Command Options for Connecting to the Server”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 4.5.1.1, “mysql Client Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — A Load Emulation Client”
Section 2.3.4.3, “Selecting a MySQL Server Type”
Section 5.1.8, “Server System Variables”
Section 1.2.2, “The Main Features of MySQL”
Section 2.3.3.3.1.1, “Type and Networking”

named_pipe_full_access_group

Section 4.2.3, “Command Options for Connecting to the Server”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 4.2.7, “Connection Transport Protocols”
Section 4.5.1.1, “mysql Client Options”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — A Load Emulation Client”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

ndb_autoincrement_prefetch_sz

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 23.1.4, “What is New in NDB Cluster”

ndb_cache_check_time

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_clear_apply_status

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 13.4.2.5, “RESET REPLICA | SLAVE Statement”

ndb_conflict_role

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_data_node_neighbour

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 13.1.20.11, “Setting NDB_TABLE Options”

ndb_dbg_check_shares

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_default_column_format

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_deferred_constraints

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_distribution

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_eventbuffer_free_percent

Section 23.5.2.3, “Event Buffer Reporting in the Cluster Log”
Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_eventbuffer_max_alloc

Section 23.5.2.3, “Event Buffer Reporting in the Cluster Log”
Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_extra_logging

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_force_send

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_fully_replicated

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_index_stat_enable

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_index_stat_option

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_join_pushdown

Section 8.8.2, “EXPLAIN Output Format”
Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_log_apply_status

Section 23.6.10, “NDB Cluster Replication: Bidrectional and Circular Replication”
Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_log_bin

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_log_binlog_index

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_log_empty_epochs

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_log_empty_update

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_log_exclusive_reads

Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.6.11, “NDB Cluster Replication Conflict Resolution”
Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_log_orig

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_log_transaction_id

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_metadata_check

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 27.12.12, “Performance Schema NDB Cluster Tables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_metadata_check_interval

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 27.12.12, “Performance Schema NDB Cluster Tables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_metadata_sync

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 27.12.12, “Performance Schema NDB Cluster Tables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_optimized_node_selection

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.3.3.10, “NDB Cluster TCP/IP Connections”
Section 23.5.3.3, “Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client”

ndb_read_backup

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 13.1.20.11, “Setting NDB_TABLE Options”
Section 23.1.4, “What is New in NDB Cluster”

ndb_recv_thread_activation_threshold

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_recv_thread_cpu_mask

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_report_thresh_binlog_epoch_slip

Section 23.5.2.3, “Event Buffer Reporting in the Cluster Log”
Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_report_thresh_binlog_mem_usage

Section 23.5.2.3, “Event Buffer Reporting in the Cluster Log”
Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_row_checksum

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_schema_dist_lock_wait_timeout

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_schema_dist_timeout

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_schema_dist_upgrade_allowed

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_show_foreign_key_mock_tables

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_slave_conflict_role

Section 23.6.11, “NDB Cluster Replication Conflict Resolution”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_table_no_logging

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 13.1.20.11, “Setting NDB_TABLE Options”

ndb_table_temporary

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_use_copying_alter_table

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_use_exact_count

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_use_transactions

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_version

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndb_version_string

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndbinfo_database

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndbinfo_max_bytes

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndbinfo_max_rows

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndbinfo_offline

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndbinfo_show_hidden

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.5.14.6, “The ndbinfo cluster_operations Table”
Section 23.5.14.7, “The ndbinfo cluster_transactions Table”
Section 23.5.14.45, “The ndbinfo server_operations Table”
Section 23.5.14.46, “The ndbinfo server_transactions Table”

ndbinfo_table_prefix

Section 23.3.3.9.2, “NDB Cluster System Variables”

ndbinfo_version

Section 23.3.3.9.2, “NDB Cluster System Variables”

net_buffer_length

Section 8.12.3.1, “How MySQL Uses Memory”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 5.1.8, “Server System Variables”

net_read_timeout

Section B.3.2.3, “Lost connection to MySQL server”
Section 5.1.8, “Server System Variables”

net_retry_count

Section 5.1.8, “Server System Variables”

net_write_timeout

Section 5.1.8, “Server System Variables”

new

Section 24.6.2, “Partitioning Limitations Relating to Storage Engines”
Section 5.1.8, “Server System Variables”

ngram_token_size

Section 12.10.2, “Boolean Full-Text Searches”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.10.4, “Full-Text Stopwords”
Section 12.10.1, “Natural Language Full-Text Searches”
Section 12.10.8, “ngram Full-Text Parser”
Section 5.1.8, “Server System Variables”

O

[index top]

offline_mode

Section 18.6.6.4, “Exit Action”
Section 18.3.1, “Group Replication Server States”
Section 18.8, “Group Replication System Variables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.8, “Server System Variables”

old

Section 8.9.4, “Index Hints”
Section 5.1.8, “Server System Variables”

old_alter_table

Section 13.1.9, “ALTER TABLE Statement”
Section 15.12, “InnoDB and Online DDL”
Section 24.3.1, “Management of RANGE and LIST Partitions”
Section 15.12.1, “Online DDL Operations”
Section 15.12.2, “Online DDL Performance and Concurrency”
Section 13.7.3.4, “OPTIMIZE TABLE Statement”
Section 5.1.8, “Server System Variables”
Section 15.12.4, “Simplifying DDL Statements with Online DDL”
Section 1.3, “What Is New in MySQL 8.0”

open_files_limit

Section 5.1.12.1, “Connection Interfaces”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 8.2.1.4, “Hash Join Optimization”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 2.5.9, “Managing MySQL Server with systemd”
Section 27.15, “Performance Schema System Variables”
Section 24.6, “Restrictions and Limitations on Partitioning”
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

optimizer_prune_level

Section 8.9.1, “Controlling Query Plan Evaluation”
Section 8.9.3, “Optimizer Hints”
Section 8.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations”
Section 5.1.8, “Server System Variables”

optimizer_search_depth

Section 8.9.1, “Controlling Query Plan Evaluation”
Section 5.1.8, “Server System Variables”

optimizer_switch

Section 8.2.1.12, “Block Nested-Loop and Batched Key Access Joins”
Section 8.2.1.13, “Condition Filtering”
Section 8.2.2.5, “Derived Condition Pushdown Optimization”
Section 8.2.1.5, “Engine Condition Pushdown Optimization”
Section 8.2.1.4, “Hash Join Optimization”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 8.2.1.3, “Index Merge Optimization”
Section 8.3.12, “Invisible Indexes”
Section 8.2.1.19, “LIMIT Query Optimization”
Section 8.2.1.11, “Multi-Range Read Optimization”
Section 8.9.3, “Optimizer Hints”
Section 8.9.6, “Optimizer Statistics”
Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section 8.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations”
Section 8.2.2.2, “Optimizing Subqueries with Materialization”
Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section 8.2.1.2, “Range Optimization”
Section 5.1.8, “Server System Variables”
Section 8.9.2, “Switchable Optimizations”
Section 28.4.5.7, “The list_add() Function”
Section 13.2.13, “UPDATE Statement”
Section 8.3.10, “Use of Index Extensions”
Section 25.5.2, “View Processing Algorithms”
Section 1.3, “What Is New in MySQL 8.0”

optimizer_trace

Section 5.1.8, “Server System Variables”
Section 26.19, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

optimizer_trace_features

Section 5.1.8, “Server System Variables”

optimizer_trace_limit

Section 5.1.8, “Server System Variables”

optimizer_trace_max_mem_size

Section 2.11.4, “Changes in MySQL 8.0”
Section 5.1.8, “Server System Variables”
Section 26.19, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

optimizer_trace_offset

Section 5.1.8, “Server System Variables”

original_commit_timestamp

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”

original_server_version

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 17.5.2, “Replication Compatibility Between MySQL Versions”
Section 17.1.6.2, “Replication Source Options and Variables”
Section 5.1.8, “Server System Variables”

P

[index top]

parser_max_mem_size

Section 5.1.8, “Server System Variables”

partial_revokes

Section 6.2.11, “Account Categories”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.12, “Privilege Restriction Using Partial Revokes”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

password_history

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 6.2.15, “Password Management”
Section 5.1.8, “Server System Variables”

password_require_current

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 6.2.15, “Password Management”
Section 5.1.8, “Server System Variables”

password_reuse_interval

Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 6.2.15, “Password Management”
Section 5.1.8, “Server System Variables”

performance_schema

Section 27.1, “Performance Schema Quick Start”
Section 27.3, “Performance Schema Startup Configuration”
Section 27.15, “Performance Schema System Variables”
Section 27.12.19.9, “The processlist Table”

performance_schema_accounts_size

Section 27.12.15, “Performance Schema Status Variable Tables”
Section 27.15, “Performance Schema System Variables”
Section 27.12.18.12, “Status Variable Summary Tables”
Section 27.12.8.1, “The accounts Table”

performance_schema_digests_size

Section 27.10, “Performance Schema Statement Digests and Sampling”
Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”
Section 27.12.18.3, “Statement Summary Tables”

performance_schema_error_size

Section 27.15, “Performance Schema System Variables”

performance_schema_events_stages_history_long_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.5.3, “The events_stages_history_long Table”

performance_schema_events_stages_history_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.5.2, “The events_stages_history Table”

performance_schema_events_statements_history_long_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.6.3, “The events_statements_history_long Table”

performance_schema_events_statements_history_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.6.2, “The events_statements_history Table”

performance_schema_events_transactions_history_long_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.7.3, “The events_transactions_history_long Table”

performance_schema_events_transactions_history_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.7.2, “The events_transactions_history Table”

performance_schema_events_waits_history_long_size

Section 27.15, “Performance Schema System Variables”
Section 27.12, “Performance Schema Table Descriptions”
Section 13.7.7.15, “SHOW ENGINE Statement”
Section 27.12.4.3, “The events_waits_history_long Table”

performance_schema_events_waits_history_size

Section 27.15, “Performance Schema System Variables”
Section 27.12, “Performance Schema Table Descriptions”
Section 13.7.7.15, “SHOW ENGINE Statement”
Section 27.12.4.2, “The events_waits_history Table”

performance_schema_hosts_size

Section 27.12.15, “Performance Schema Status Variable Tables”
Section 27.15, “Performance Schema System Variables”
Section 27.12.18.12, “Status Variable Summary Tables”
Section 27.12.8.2, “The hosts Table”

performance_schema_max_cond_classes

Section 27.15, “Performance Schema System Variables”

performance_schema_max_cond_instances

Section 27.15, “Performance Schema System Variables”

performance_schema_max_digest_length

Section 27.10, “Performance Schema Statement Digests and Sampling”
Section 27.15, “Performance Schema System Variables”
Section 5.1.8, “Server System Variables”
Section 27.12.6.1, “The events_statements_current Table”

performance_schema_max_digest_sample_age

Section 27.10, “Performance Schema Statement Digests and Sampling”
Section 27.15, “Performance Schema System Variables”

performance_schema_max_file_classes

Section 27.15, “Performance Schema System Variables”

performance_schema_max_file_handles

Section 27.15, “Performance Schema System Variables”

performance_schema_max_file_instances

Section 27.15, “Performance Schema System Variables”

performance_schema_max_index_stat

Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”

performance_schema_max_memory_classes

Section 27.15, “Performance Schema System Variables”

performance_schema_max_metadata_locks

Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”
Section 27.12.13.3, “The metadata_locks Table”

performance_schema_max_mutex_classes

Section 27.7, “Performance Schema Status Monitoring”
Section 27.15, “Performance Schema System Variables”

performance_schema_max_mutex_instances

Section 27.15, “Performance Schema System Variables”

performance_schema_max_prepared_statements_instances

Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”
Section 27.12.6.4, “The prepared_statements_instances Table”

performance_schema_max_program_instances

Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”

performance_schema_max_rwlock_classes

Section 27.15, “Performance Schema System Variables”

performance_schema_max_rwlock_instances

Section 27.15, “Performance Schema System Variables”

performance_schema_max_socket_classes

Section 27.15, “Performance Schema System Variables”

performance_schema_max_socket_instances

Section 27.15, “Performance Schema System Variables”

performance_schema_max_sql_text_length

Section 27.10, “Performance Schema Statement Digests and Sampling”
Section 27.15, “Performance Schema System Variables”
Section 27.12.18.3, “Statement Summary Tables”
Section 27.12.6.1, “The events_statements_current Table”

performance_schema_max_stage_classes

Section 27.15, “Performance Schema System Variables”
Section 27.12.19.9, “The processlist Table”

performance_schema_max_statement_classes

Section 27.15, “Performance Schema System Variables”

performance_schema_max_statement_stack

Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”

performance_schema_max_table_handles

Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”
Section 27.12.13.4, “The table_handles Table”

performance_schema_max_table_instances

Section 27.15, “Performance Schema System Variables”

performance_schema_max_table_lock_stat

Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”

performance_schema_max_thread_classes

Section 27.15, “Performance Schema System Variables”
Section 27.12.19.9, “The processlist Table”

performance_schema_max_thread_instances

Section 12.22, “Performance Schema Functions”
Section 27.12.15, “Performance Schema Status Variable Tables”
Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”
Section 13.7.7.15, “SHOW ENGINE Statement”
Section 27.12.19.9, “The processlist Table”

performance_schema_session_connect_attrs_size

Section 27.12.9, “Performance Schema Connection Attribute Tables”
Section 27.16, “Performance Schema Status Variables”
Section 27.15, “Performance Schema System Variables”

performance_schema_setup_actors_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.2.1, “The setup_actors Table”

performance_schema_setup_objects_size

Section 27.15, “Performance Schema System Variables”
Section 27.12.2.4, “The setup_objects Table”

performance_schema_show_processlist

Section 27.15, “Performance Schema System Variables”
Section 27.12.19.9, “The processlist Table”

performance_schema_users_size

Section 27.12.15, “Performance Schema Status Variable Tables”
Section 27.15, “Performance Schema System Variables”
Section 27.12.18.12, “Status Variable Summary Tables”
Section 27.12.8.3, “The users Table”

persist_only_admin_x

Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
Section 5.1.8, “Server System Variables”
Section 5.1.9.1, “System Variable Privileges”

persisted_globals_load

Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
Section 27.12.14.2, “Performance Schema variables_info Table”
Section 5.1.9.3, “Persisted System Variables”
Section 13.7.8.7, “RESET PERSIST Statement”
Section 5.1.8, “Server System Variables”
Section 4.2.2.2, “Using Option Files”

pid

Section 15.8.2, “Configuring InnoDB for Read-Only Operation”

pid_file

Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

plugin_dir

Section 6.1.2.2, “Administrator Guidelines for Password Security”
Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 13.7.4.1, “CREATE FUNCTION Statement for User-Defined Functions”
Section 6.4.4.10, “General-Purpose Keyring Key-Management Functions”
Section 13.7.4.3, “INSTALL COMPONENT Statement”
Section 13.7.4.4, “INSTALL PLUGIN Statement”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section 2.4.3, “Installing and Using the MySQL Launch Daemon”
Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 5.6.5.1, “Installing or Uninstalling ddl_rewriter”
Section 6.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”
Section 6.5.2, “Installing or Uninstalling MySQL Enterprise Data Masking and De-Identification”
Section 5.6.6.2, “Installing or Uninstalling Version Tokens”
Section 5.6.7.1, “Installing the Clone Plugin”
Section 6.4.4.12, “Keyring Command Options”
Section 6.4.4.1, “Keyring Plugin Installation”
Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.6.1, “MySQL Enterprise Encryption Installation”
Section 6.4.1.8, “No-Login Pluggable Authentication”
Section 6.4.1.5, “PAM Pluggable Authentication”
Section 6.4.3.1, “Password Validation Component Installation and Uninstallation”
Section 6.2.17, “Pluggable Authentication”
Section 16.11.1, “Pluggable Storage Engine Architecture”
Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 13.7.7.25, “SHOW PLUGINS Statement”
Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”
Section 6.4.1.10, “Test Pluggable Authentication”
Section 6.4.6, “The Audit Message Component”
Section 26.22, “The INFORMATION_SCHEMA PLUGINS Table”
Section 5.6.8.1.2, “The Locking Service UDF Interface”
Section 27.12.19.12, “The user_defined_functions Table”
Section 5.6.3.2, “Thread Pool Installation”
Section 6.4.1.6, “Windows Pluggable Authentication”

port

Section B.3.2.2, “Can't connect to [local] MySQL server”
Section 13.7.5, “CLONE Statement”
Section 5.6.7.3, “Cloning Remote Data”
Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.4.3.1, “Connections for Distributed Recovery”
Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 20.3.1, “MySQL Shell”
Section 20.4.1, “MySQL Shell”
Section 18.5.3, “Securing Distributed Recovery Connections”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”
Section 5.1.8, “Server System Variables”
Section 6.7.5.1, “Setting the TCP Port Context for mysqld”
Section 27.12.11.10, “The replication_group_members Table”
Section 20.5.6.2, “X Plugin Options and System Variables”

preload_buffer_size

Section 5.1.8, “Server System Variables”

print_identified_with_as_hex

Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 13.7.1.1, “ALTER USER Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 5.1.8, “Server System Variables”
Section 13.7.7.12, “SHOW CREATE USER Statement”

profiling

Section 5.1.8, “Server System Variables”
Section 13.7.7.30, “SHOW PROFILE Statement”
Section 26.24, “The INFORMATION_SCHEMA PROFILING Table”

profiling_history_size

Section 5.1.8, “Server System Variables”
Section 13.7.7.30, “SHOW PROFILE Statement”

protocol_compression_algorithms

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 4.2.3, “Command Options for Connecting to the Server”
Section 4.2.8, “Connection Compression Control”
Section 20.5.5, “Connection Compression with X Plugin”
Section 18.8, “Group Replication System Variables”
Section 4.5.1.1, “mysql Client Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — A Load Emulation Client”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

protocol_version

Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
Section 5.1.8, “Server System Variables”

proxy_user

Section 6.2.18, “Proxy Users”
Section 5.1.8, “Server System Variables”

pseudo_slave_mode

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 5.1.8, “Server System Variables”

pseudo_thread_id

Section 12.16, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 17.3.3, “Replication Privilege Checks”
Section 5.1.8, “Server System Variables”

Q

[index top]

query_alloc_block_size

Section 5.1.8, “Server System Variables”

query_prealloc_size

Section 5.1.8, “Server System Variables”

R

[index top]

rand_seed

Section 5.1.8, “Server System Variables”

range_alloc_block_size

Section 5.1.8, “Server System Variables”

range_optimizer_max_mem_size

Section 4.5.1.6, “mysql Client Tips”
Section 8.2.1.2, “Range Optimization”
Section 5.1.8, “Server System Variables”

rbr_exec_mode

Section 5.1.8, “Server System Variables”

read_buffer_size

Section 8.12.3.1, “How MySQL Uses Memory”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 5.1.8, “Server System Variables”

read_only

Section 13.7.1, “Account Management Statements”
Section 13.7.1.1, “ALTER USER Statement”
Section 6.2.14, “Assigning Account Passwords”
Section 17.4.1.3, “Backing Up a Source or Replica by Making It Read Only”
Section 13.7.1.2, “CREATE ROLE Statement”
Section 13.7.1.3, “CREATE USER Statement”
Section 13.7.1.4, “DROP ROLE Statement”
Section 13.7.1.5, “DROP USER Statement”
Section 13.7.1.6, “GRANT Statement”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.7, “RENAME USER Statement”
Section 17.5.1.39, “Replication and Variables”
Section 13.7.1.8, “REVOKE Statement”
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 13.7.1.10, “SET PASSWORD Statement”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”

read_rnd_buffer_size

Section 8.12.3.1, “How MySQL Uses Memory”
Section 8.2.1.11, “Multi-Range Read Optimization”
Section 8.2.1.16, “ORDER BY Optimization”
Section 5.1.8, “Server System Variables”

regexp_stack_limit

Section 12.8.2, “Regular Expressions”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

regexp_time_limit

Section 12.8.2, “Regular Expressions”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

relay

Section 2.11.4, “Changes in MySQL 8.0”
Section 17.2.2.3, “Startup Options and Replication Channels”

relay_log

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 18.10, “Frequently Asked Questions”
Section 17.4.7, “Improving Replication Performance”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.2.4, “Replication Channel Naming Conventions”
Section 17.2.4.1, “The Relay Log”
Section 1.3, “What Is New in MySQL 8.0”

relay_log_basename

Section 17.1.6.3, “Replica Server Options and Variables”

relay_log_index

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.4.1, “The Relay Log”

relay_log_info_file

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.4.2, “Replication Metadata Repositories”

relay_log_info_repository

Section 2.11.4, “Changes in MySQL 8.0”
Section 5.6.7.6, “Cloning for Replication”
Section 18.9.1, “Group Replication Requirements”
Section 17.4.2, “Handling an Unexpected Halt of a Replica”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.4.2, “Replication Metadata Repositories”
Section 13.4.2.5, “RESET REPLICA | SLAVE Statement”
Section 17.2.2.3, “Startup Options and Replication Channels”
Section 1.3, “What Is New in MySQL 8.0”

relay_log_purge

Section 17.1.6.3, “Replica Server Options and Variables”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”

relay_log_recovery

Section 17.4.2, “Handling an Unexpected Halt of a Replica”
Section 17.1.6.3, “Replica Server Options and Variables”

relay_log_space_limit

Section 17.1.6.3, “Replica Server Options and Variables”
Section 8.14.5, “Replication I/O Thread States”
Section 17.2.2.3, “Startup Options and Replication Channels”

replication_optimize_for_static_plugin_config

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.4.10.1, “Semisynchronous Replication Administrative Interface”

replication_sender_observe_commit_only

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.4.10.1, “Semisynchronous Replication Administrative Interface”

report_host

Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.4.3.1, “Connections for Distributed Recovery”
Section 18.2.2, “Deploying Group Replication Locally”
Section 17.1.6.3, “Replica Server Options and Variables”

report_password

Section 17.1.6.3, “Replica Server Options and Variables”

report_port

Section 18.4.3.1, “Connections for Distributed Recovery”
Section 18.10, “Frequently Asked Questions”
Section 18.8, “Group Replication System Variables”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 18.4.3.1.1, “Selecting addresses for distributed recovery endpoints”

report_user

Section 17.1.6.3, “Replica Server Options and Variables”

require_row_format

Section 5.1.8, “Server System Variables”

require_secure_transport

Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 4.2.7, “Connection Transport Protocols”
Section 6.8, “FIPS Support”
Section 5.1.8, “Server System Variables”
Section 6.3, “Using Encrypted Connections”
Section 20.5.3, “Using Encrypted Connections with X Plugin”

resultset_metadata

Section 5.1.8, “Server System Variables”

rewriter_enabled

Section 5.6.4.3.3, “Rewriter Query Rewrite Plugin System Variables”
Section 5.6.4.2, “Using the Rewriter Query Rewrite Plugin”

rewriter_verbose

Section 5.6.4.3.3, “Rewriter Query Rewrite Plugin System Variables”

rpl_read_size

Section 8.12.3.1, “How MySQL Uses Memory”
Section 17.4.7, “Improving Replication Performance”
Section 17.1.6.3, “Replica Server Options and Variables”

rpl_semi_sync_master_enabled

Section 17.1.6.2, “Replication Source Options and Variables”
Section 17.4.10.1, “Semisynchronous Replication Administrative Interface”
Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”
Section 17.4.10.3, “Semisynchronous Replication Monitoring”

rpl_semi_sync_master_timeout

Section 17.1.6.2, “Replication Source Options and Variables”
Section 17.4.10.1, “Semisynchronous Replication Administrative Interface”
Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”

rpl_semi_sync_master_trace_level

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.1.6.2, “Replication Source Options and Variables”

rpl_semi_sync_master_wait_for_slave_count

Section 17.1.6.2, “Replication Source Options and Variables”
Section 17.4.10, “Semisynchronous Replication”

rpl_semi_sync_master_wait_no_slave

Section 17.1.6.2, “Replication Source Options and Variables”

rpl_semi_sync_master_wait_point

Section 17.1.6.2, “Replication Source Options and Variables”
Section 17.4.10, “Semisynchronous Replication”

rpl_semi_sync_slave_enabled

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.4.10.1, “Semisynchronous Replication Administrative Interface”
Section 17.4.10.2, “Semisynchronous Replication Installation and Configuration”

rpl_semi_sync_slave_trace_level

Section 17.1.6.3, “Replica Server Options and Variables”

rpl_stop_slave_timeout

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”
Section 13.4.2.9, “STOP REPLICA | SLAVE Statement”

S

[index top]

schema_definition_cache

Section 14.4, “Dictionary Object Cache”
Section 5.1.8, “Server System Variables”

secondary_engine_cost_threshold

Section 5.1.8, “Server System Variables”

secure_file_priv

Section 13.2.5, “IMPORT TABLE Statement”
Section 2.10.1, “Initializing the Data Directory”
Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 13.2.7, “LOAD DATA Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification User-Defined Function Descriptions”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 6.2.2, “Privileges Provided by MySQL”
Section 15.6.5, “Redo Log”
Section 13.2.10.1, “SELECT ... INTO Statement”
Section 6.7.4, “SELinux File Context”
Section 5.1.8, “Server System Variables”
Section 12.8, “String Functions and Operators”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

select_into_buffer_size

Section 13.2.10.1, “SELECT ... INTO Statement”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

select_into_disk_sync

Section 13.2.10.1, “SELECT ... INTO Statement”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

select_into_disk_sync_delay

Section 13.2.10.1, “SELECT ... INTO Statement”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

server

Section 2.11.4, “Changes in MySQL 8.0”

server_id

Section 18.2.1.6.1, “Adding a Second Instance”
Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 2.3.3.3.1.6, “Advanced Options”
Section 6.4.5.4, “Audit Log File Formats”
Section 17.1.1, “Binary Log File Position Based Replication Configuration Overview”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 2.11.4, “Changes in MySQL 8.0”
Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 18.9.1, “Group Replication Requirements”
Section 12.24, “Miscellaneous Functions”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 23.6.11, “NDB Cluster Replication Conflict Resolution”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 27.12.11, “Performance Schema Replication Tables”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.1.6, “Replication and Binary Logging Options and Variables”
Section 17.1.6.2, “Replication Source Options and Variables”
Section 17.1.2.2, “Setting the Replica Configuration”
Section 17.1.2.1, “Setting the Replication Source Configuration”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”
Section 5.4.4, “The Binary Log”
Section 17.5.4, “Troubleshooting Replication”
Section 17.2.1.2, “Usage of Row-Based Logging and Replication”

server_id_bits

Section 23.3.3.9.2, “NDB Cluster System Variables”

server_uuid

Section 17.3.2.2, “Binary Log Encryption Keys”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 18.4.1.2, “Changing a Group's Mode”
Section 18.4.1.1, “Changing a Group's Primary Member”
Section 13.4.3.3, “Function which Configures Group Replication Primary”
Section 17.1.3.1, “GTID Format and Storage”
Section 27.12.11, “Performance Schema Replication Tables”
Section 18.1.3.1.1, “Primary Election Algorithm”
Section 17.1.6, “Replication and Binary Logging Options and Variables”
Section 17.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”
Section 13.4.2.7, “START REPLICA | SLAVE Statement”
Section 17.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 27.12.19.7, “The log_status Table”
Section 27.12.11.4, “The replication_applier_configuration Table”
Section 27.12.11.2, “The replication_connection_status Table”
Section 18.3.2, “The replication_group_members Table”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”

session_track_gtids

Section 17.1.6.5, “Global Transaction ID System Variables”
Section 17.1.4.1, “Replication Mode Concepts”
Section 5.1.8, “Server System Variables”
Section 5.1.18, “Server Tracking of Client Session State Changes”

session_track_schema

Section 5.1.8, “Server System Variables”
Section 5.1.18, “Server Tracking of Client Session State Changes”

session_track_state_change

Section 5.1.8, “Server System Variables”
Section 5.1.18, “Server Tracking of Client Session State Changes”

session_track_system_variables

Section 5.1.8, “Server System Variables”
Section 5.1.18, “Server Tracking of Client Session State Changes”

session_track_transaction_info

Section 5.1.8, “Server System Variables”
Section 5.1.18, “Server Tracking of Client Session State Changes”

sha

Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 6.2.18, “Proxy Users”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”

shared_memory

Section 4.2.3, “Command Options for Connecting to the Server”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 4.5.1.1, “mysql Client Options”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — A Load Emulation Client”
Section 5.1.8, “Server System Variables”
Section 5.8.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.4.5, “Starting the Server for the First Time”
Section 1.2.2, “The Main Features of MySQL”
Section 2.3.3.3.1.1, “Type and Networking”

shared_memory_base_name

Section 5.1.8, “Server System Variables”
Section 5.8.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”

show_create_table_skip_secondary_engine

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.8, “Server System Variables”

show_create_table_verbosity

Section 5.1.8, “Server System Variables”

show_old_temporals

Section 5.1.8, “Server System Variables”

skip_external_locking

Section 8.11.5, “External Locking”
Section 5.1.8, “Server System Variables”

skip_name_resolve

Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 18.10, “Frequently Asked Questions”
Section 2.10.1, “Initializing the Data Directory”
Section 5.1.14, “Network Namespace Support”
Section 5.1.8, “Server System Variables”
Section 2.3.4.9, “Testing The MySQL Installation”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”

skip_networking

Section B.3.2.2, “Can't connect to [local] MySQL server”
Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section A.14, “MySQL 8.0 FAQ: Replication”
Section B.3.2.7, “MySQL server has gone away”
Section 6.2.17, “Pluggable Authentication”
Section B.3.3.2.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 17.1.2.1, “Setting the Replication Source Configuration”
Section 23.5.14.41, “The ndbinfo processes Table”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 17.5.4, “Troubleshooting Replication”
Section 17.5.3, “Upgrading a Replication Setup”
Section 20.5.6.3, “X Plugin Status Variables”

skip_show_database

Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

skip_slave_start

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 23.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 23.6.5, “Preparing the NDB Cluster for Replication”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 17.1.2.6.2, “Setting Up Replication with Existing Data”
Section 13.4.2.7, “START REPLICA | SLAVE Statement”
Section 23.6.6, “Starting NDB Cluster Replication (Single Replication Channel)”
Section 17.2.2.3, “Startup Options and Replication Channels”
Section 17.5.4, “Troubleshooting Replication”
Section 17.5.3, “Upgrading a Replication Setup”

slave

Section 17.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”
Section 17.2.2.3, “Startup Options and Replication Channels”

slave_allow_batching

Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.6.5, “Preparing the NDB Cluster for Replication”
Section 23.6.6, “Starting NDB Cluster Replication (Single Replication Channel)”
Section 23.1.4, “What is New in NDB Cluster”

slave_checkpoint_group

Section 23.6.3, “Known Issues in NDB Cluster Replication”
Section 12.24, “Miscellaneous Functions”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.2.2.3, “Startup Options and Replication Channels”

slave_checkpoint_period

Section 12.24, “Miscellaneous Functions”
Section 17.1.6.3, “Replica Server Options and Variables”

slave_compressed_protocol

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 4.2.8, “Connection Compression Control”
Section 5.4.4.5.3, “Monitoring Binary Log Transaction Compression”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 1.3, “What Is New in MySQL 8.0”

slave_exec_mode

Section 23.6.3, “Known Issues in NDB Cluster Replication”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.21, “Replication and MEMORY Tables”
Section 17.2.1.2, “Usage of Row-Based Logging and Replication”

slave_load_tmpdir

Section 17.4.1.2, “Backing Up Raw Data from a Replica”
Section 7.2, “Database Backup Methods”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section B.3.3.5, “Where MySQL Stores Temporary Files”

slave_max_allowed_packet

Section 5.4.4.5.1, “Behaviors When Binary Log Transaction Compression is Enabled”
Section 18.9.2, “Group Replication Limitations”
Section 18.8, “Group Replication System Variables”
Section 18.6.4, “Message Fragmentation”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.20, “Replication and max_allowed_packet”

slave_net_timeout

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 17.1.7.1, “Checking Replication Status”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.28, “Replication and Source or Replica Shutdowns”
Section 8.14.5, “Replication I/O Thread States”
Section 5.1.8, “Server System Variables”

slave_parallel_type

Section 5.4.4.5.1, “Behaviors When Binary Log Transaction Compression is Enabled”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 18.9.1, “Group Replication Requirements”
Section 17.2.3.2, “Monitoring Replication Applier Worker Threads”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”

slave_parallel_workers

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 5.6.7.6, “Cloning for Replication”
Section 18.9.1, “Group Replication Requirements”
Section 17.1.3.2, “GTID Life Cycle”
Section 23.6.3, “Known Issues in NDB Cluster Replication”
Section 17.1.5, “MySQL Multi-Source Replication”
Section 27.12.11, “Performance Schema Replication Tables”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.20, “Replication and max_allowed_packet”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”
Section 17.2.2, “Replication Channels”
Section 8.14.6, “Replication SQL Thread States”
Section 17.2.3, “Replication Threads”
Section 13.4.2.9, “STOP REPLICA | SLAVE Statement”
Section 27.12.11.7, “The replication_applier_status_by_worker Table”

slave_pending_jobs_size_max

Section 2.11.4, “Changes in MySQL 8.0”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 17.2.3.2, “Monitoring Replication Applier Worker Threads”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.20, “Replication and max_allowed_packet”
Section 8.14.6, “Replication SQL Thread States”

slave_preserve_commit_order

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 18.9.1, “Group Replication Requirements”
Section 17.1.3.2, “GTID Life Cycle”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”
Section 8.14.5, “Replication I/O Thread States”

slave_rows_search_algorithms

Section 2.11.4, “Changes in MySQL 8.0”
Section 13.1.20.10, “Invisible Columns”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.27, “Replication and Row Searches”
Section 5.1.10, “Server Status Variables”

slave_skip_errors

Section 17.1.6.3, “Replica Server Options and Variables”

slave_sql_verify_checksum

MySQL Glossary
Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.4.4, “The Binary Log”

slave_transaction_retries

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.32, “Replication Retries and Timeouts”
Section 17.2.2.3, “Startup Options and Replication Channels”
Section 27.12.11.5, “The replication_applier_status Table”

slave_type_conversions

Section 23.6.3, “Known Issues in NDB Cluster Replication”
Section 17.1.6.3, “Replica Server Options and Variables”

slow_launch_time

Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

slow_query_log

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

slow_query_log_file

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 5.4.5, “The Slow Query Log”
Section 1.3, “What Is New in MySQL 8.0”

socket

Section 5.1.8, “Server System Variables”
Section 20.5.6.2, “X Plugin Options and System Variables”

sort_buffer_size

Section 7.6.3, “How to Repair MyISAM Tables”
Section 8.2.1.16, “ORDER BY Optimization”
Section 5.1.7, “Server Command Options”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 13.7.6.1, “SET Syntax for Variable Assignment”

sql_auto_is_null

Section 12.4.2, “Comparison Functions and Operators”
Section 13.1.20, “CREATE TABLE Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 5.4.4, “The Binary Log”

sql_big_selects

Section 5.1.8, “Server System Variables”

sql_buffer_result

Section 5.1.8, “Server System Variables”

sql_log_bin

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 23.1.7.8, “Issues Exclusive to NDB Cluster”
Section 23.6.3, “Known Issues in NDB Cluster Replication”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.4.1.3, “SET sql_log_bin Statement”
Section 5.1.9.1, “System Variable Privileges”
Section 28.4.4.2, “The diagnostics() Procedure”
Section 28.4.4.12, “The ps_setup_reload_saved() Procedure”
Section 28.4.4.14, “The ps_setup_save() Procedure”
Section 28.4.4.22, “The ps_trace_statement_digest() Procedure”
Section 28.4.4.23, “The ps_trace_thread() Procedure”
Section 28.4.4.25, “The statement_performance_analyzer() Procedure”
Section 17.5.3, “Upgrading a Replication Setup”
Section 1.3, “What Is New in MySQL 8.0”

sql_log_off

MySQL Glossary
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.8, “Server System Variables”
Section 5.4.3, “The General Query Log”

SQL_MODE

Section 15.12.1, “Online DDL Operations”

sql_mode

Section 15.1.2, “Best Practices for InnoDB Tables”
Section 2.11.4, “Changes in MySQL 8.0”
Section 13.1.13, “CREATE EVENT Statement”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.22, “CREATE TRIGGER Statement”
Section 12.25.3, “Expression Handling”
Section 1.6, “How to Report Bugs or Problems”
Section 13.2.7, “LOAD DATA Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 1.7, “MySQL Standards Compliance”
Section 2.11.5, “Preparing Your Installation for Upgrade”
Section B.3.4.2, “Problems Using DATE Columns”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.11, “Server SQL Modes”
Section 5.1.8, “Server System Variables”
Section 13.7.7.13, “SHOW CREATE VIEW Statement”
Section 13.6.7.5, “SIGNAL Statement”
Section 5.4.4, “The Binary Log”
Section 26.48, “The INFORMATION_SCHEMA VIEWS Table”
Section 28.4.5.7, “The list_add() Function”
Section 4.2.2.2, “Using Option Files”
Section 5.1.9, “Using System Variables”

sql_notes

Section B.2, “Error Information Interfaces”
Section 5.1.8, “Server System Variables”
Section 13.7.7.42, “SHOW WARNINGS Statement”
Section 13.6.7.7, “The MySQL Diagnostics Area”

sql_quote_show_create

Section 12.16, “Information Functions”
Section 5.1.8, “Server System Variables”
Section 13.7.7.6, “SHOW CREATE DATABASE Statement”
Section 13.7.7.10, “SHOW CREATE TABLE Statement”

sql_require_primary_key

Section 13.1.9, “ALTER TABLE Statement”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.4.2.3, “CHANGE REPLICATION SOURCE TO Statement”
Section 18.9.1, “Group Replication Requirements”
Section 17.3.3.2, “Privilege Checks For Group Replication Channels”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 17.3.3, “Replication Privilege Checks”
Section 5.1.8, “Server System Variables”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”

sql_safe_updates

Section 4.5.1.6, “mysql Client Tips”
Section 8.2.1.2, “Range Optimization”
Section 5.1.8, “Server System Variables”

sql_select_limit

Section 4.5.1.6, “mysql Client Tips”
Section 5.1.8, “Server System Variables”

sql_slave_skip_counter

Section 5.4.4.5.1, “Behaviors When Binary Log Transaction Compression is Enabled”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.1.3.7, “Restrictions on Replication with GTIDs”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”
Section 17.1.7.3.2.1, “Skipping Transactions With SET GLOBAL sql_slave_skip_counter

sql_warnings

Section 5.1.8, “Server System Variables”

ssl_ca

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 6.3.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 17.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 20.5.6.2, “X Plugin Options and System Variables”

ssl_capath

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 17.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 20.5.6.2, “X Plugin Options and System Variables”

ssl_cert

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 6.3.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.7, “Server Command Options”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 17.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 20.5.6.2, “X Plugin Options and System Variables”

ssl_cipher

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 20.5.6.2, “X Plugin Options and System Variables”

ssl_crl

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 20.5.6.2, “X Plugin Options and System Variables”

ssl_crlpath

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 20.5.6.2, “X Plugin Options and System Variables”

ssl_fips_mode

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.8, “FIPS Support”
Section 5.1.8, “Server System Variables”

ssl_key

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 6.3.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.7, “Server Command Options”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 17.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 20.5.6.2, “X Plugin Options and System Variables”

storage_engine

Section 13.1.16, “CREATE LOGFILE GROUP Statement”

stored_program_cache

Section 8.10.3, “Caching of Prepared Statements and Stored Programs”
Section 14.4, “Dictionary Object Cache”
Section 5.1.8, “Server System Variables”

stored_program_definition_cache

Section 14.4, “Dictionary Object Cache”
Section 5.1.8, “Server System Variables”

super_read_only

Section 18.2.1.6.1, “Adding a Second Instance”
Section 18.6.6.4, “Exit Action”
Section 18.7.3.3, “Group Replication Online Upgrade Methods”
Section 18.3.1, “Group Replication Server States”
Section 18.8, “Group Replication System Variables”
Section 18.7.1.1, “Member Versions During Upgrades”
Section 18.7.3.1, “Online Upgrade Considerations”
Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 5.1.8, “Server System Variables”
Section 18.1.3.1, “Single-Primary Mode”
Section 13.4.3.1, “START GROUP_REPLICATION Statement”
Section 13.4.3.2, “STOP GROUP_REPLICATION Statement”
Section 18.7.3.2, “Upgrading a Group Replication Member”

sync_binlog

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.1.3.3, “GTID Auto-Positioning”
Section 15.2, “InnoDB and the ACID Model”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 17.5.1.28, “Replication and Source or Replica Shutdowns”
Section 5.4.4, “The Binary Log”

sync_master_info

Section 17.1.6.3, “Replica Server Options and Variables”

sync_relay_log

Section 17.4.2, “Handling an Unexpected Halt of a Replica”
Section 17.1.6.3, “Replica Server Options and Variables”

sync_relay_log_info

Section 17.1.6.3, “Replica Server Options and Variables”
Section 17.5.1.28, “Replication and Source or Replica Shutdowns”

syseventlog

Section 5.4.2.8, “Error Logging to the System Log”
Section 5.1.8, “Server System Variables”

system_time_zone

Section 5.1.15, “MySQL Server Time Zone Support”
Section 17.5.1.33, “Replication and Time Zones”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

T

[index top]

table_definition_cache

Section 14.4, “Dictionary Object Cache”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 5.1.8, “Server System Variables”

table_encryption_privilege_check

Section 13.1.2, “ALTER DATABASE Statement”
Section 13.1.9, “ALTER TABLE Statement”
Section 13.1.10, “ALTER TABLESPACE Statement”
Section 13.1.12, “CREATE DATABASE Statement”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 15.13, “InnoDB Data-at-Rest Encryption”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.1.36, “RENAME TABLE Statement”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

table_open_cache

Section 2.11.4, “Changes in MySQL 8.0”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 8.14.3, “General Thread States”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

table_open_cache_instances

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

tablespace_definition_cache

Section 14.4, “Dictionary Object Cache”
Section 5.1.8, “Server System Variables”

temptable_max_mmap

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

temptable_max_ram

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

temptable_use_mmap

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 1.3, “What Is New in MySQL 8.0”

thread_cache_size

Section 5.1.12.1, “Connection Interfaces”
Section 5.9.1.4, “Debugging mysqld under gdb”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

thread_handling

Section 5.1.8, “Server System Variables”
Section 5.6.3.1, “Thread Pool Elements”

thread_pool_algorithm

Section 5.1.8, “Server System Variables”
Section 27.12.16.1, “The tp_thread_group_state Table”
Section 5.6.3.3, “Thread Pool Operation”

thread_pool_high_priority_connection

Section 5.1.8, “Server System Variables”
Section 5.6.3.3, “Thread Pool Operation”

thread_pool_max_active_query_threads

Section 5.1.8, “Server System Variables”
Section 5.6.3.3, “Thread Pool Operation”

thread_pool_max_unused_threads

Section 5.1.8, “Server System Variables”
Section 5.6.3.3, “Thread Pool Operation”

thread_pool_prio_kickup_timer

Section 5.1.8, “Server System Variables”
Section 27.12.16.1, “The tp_thread_group_state Table”
Section 27.12.16.2, “The tp_thread_group_stats Table”
Section 5.6.3.3, “Thread Pool Operation”
Section 5.6.3.4, “Thread Pool Tuning”

thread_pool_size

Section 5.1.8, “Server System Variables”
Section 5.6.3.3, “Thread Pool Operation”
Section 5.6.3.4, “Thread Pool Tuning”

thread_pool_stall_limit

Section 5.1.8, “Server System Variables”
Section 27.12.16.1, “The tp_thread_group_state Table”
Section 27.12.16.2, “The tp_thread_group_stats Table”
Section 5.6.3.3, “Thread Pool Operation”
Section 5.6.3.4, “Thread Pool Tuning”

thread_stack

Section 5.1.12.1, “Connection Interfaces”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 5.1.8, “Server System Variables”
Section 25.2.1, “Stored Routine Syntax”

time_zone

Section 13.1.13, “CREATE EVENT Statement”
Section 12.7, “Date and Time Functions”
Section 25.4.4, “Event Metadata”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 5.1.15, “MySQL Server Time Zone Support”
Section 17.5.1.33, “Replication and Time Zones”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types”
Section 5.4.3, “The General Query Log”
Section 5.4.5, “The Slow Query Log”
Section 1.3, “What Is New in MySQL 8.0”

timestamp

Section 16.8.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”

tls_ciphersuites

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”

tls_version

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 18.5.2, “Securing Group Communication Connections with Secure Socket Layer (SSL)”
Section 5.1.7, “Server Command Options”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 17.3.1, “Setting Up Replication to Use Encrypted Connections”
Section 20.5.3, “Using Encrypted Connections with X Plugin”

tmp_table_size

Section 8.12.3.1, “How MySQL Uses Memory”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 13.6.6.5, “Restrictions on Server-Side Cursors”
Section 5.1.8, “Server System Variables”

tmpdir

Section 17.4.1.2, “Backing Up Raw Data from a Replica”
Section B.3.2.11, “Can't create/write to file”
Section 7.2, “Database Backup Methods”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 15.12.5, “Online DDL Failure Conditions”
Section 15.12.3, “Online DDL Space Requirements”
Section 8.2.1.16, “ORDER BY Optimization”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.1.8, “Server System Variables”

transaction

Section 2.11.4, “Changes in MySQL 8.0”
Section 18.9.1, “Group Replication Requirements”

transaction_alloc_block_size

Section 5.1.8, “Server System Variables”

transaction_allow_batching

Section 23.3.3.9.2, “NDB Cluster System Variables”

transaction_isolation

Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 5.1.18, “Server Tracking of Client Session State Changes”
Section 13.3.7, “SET TRANSACTION Statement”

transaction_prealloc_size

Section 5.1.8, “Server System Variables”

transaction_read_only

Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 5.1.18, “Server Tracking of Client Session State Changes”
Section 13.3.7, “SET TRANSACTION Statement”

transaction_write_set_extraction

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 18.8, “Group Replication System Variables”

U

[index top]

unique_checks

Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.5.1.39, “Replication and Variables”
Section 5.1.8, “Server System Variables”
Section 5.4.4, “The Binary Log”

updatable_views_with_limit

Section 5.1.8, “Server System Variables”
Section 25.5.3, “Updatable and Insertable Views”

use_secondary_engine

Section 5.1.8, “Server System Variables”

V

[index top]

validate_password

Section 12.14, “Encryption and Compression Functions”
Section 6.4.3.2, “Password Validation Options and Variables”
Section 6.4.3, “The Password Validation Component”

validate_password_check_user_name

Section 2.11.4, “Changes in MySQL 8.0”
Section 6.4.3.2, “Password Validation Options and Variables”

validate_password_dictionary_file

Section 6.4.3.2, “Password Validation Options and Variables”

validate_password_length

Section 6.4.3.2, “Password Validation Options and Variables”

validate_password_mixed_case_count

Section 6.4.3.2, “Password Validation Options and Variables”

validate_password_number_count

Section 6.4.3.2, “Password Validation Options and Variables”

validate_password_policy

Section 6.4.3.2, “Password Validation Options and Variables”

validate_password_special_char_count

Section 6.4.3.2, “Password Validation Options and Variables”

validate_user_plugins

Section 5.1.8, “Server System Variables”

version

Section 6.4.5.4, “Audit Log File Formats”
Section 12.16, “Information Functions”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 5.1.8, “Server System Variables”

version_comment

Section 2.9.7, “MySQL Source-Configuration Options”
Section 5.1.8, “Server System Variables”
Section 13.7.7.41, “SHOW VARIABLES Statement”

version_compile_machine

Section 5.1.8, “Server System Variables”

version_compile_os

Section 5.1.8, “Server System Variables”

version_compile_zlib

Section 5.1.8, “Server System Variables”

version_tokens_session

Section 5.6.6.3, “Using Version Tokens”
Section 5.6.6.4, “Version Tokens Reference”

version_tokens_session_number

Section 5.6.6.4, “Version Tokens Reference”

W

[index top]

wait_timeout

Section B.3.2.9, “Communication Errors and Aborted Connections”
Section 18.4.2.2, “Configuring Transaction Consistency Guarantees”
Section B.3.2.7, “MySQL server has gone away”
Section 5.6.7.8, “Remote Cloning Operation Failure Handling”
Section 5.1.8, “Server System Variables”

warning_count

Section B.2, “Error Information Interfaces”
Section 13.5, “Prepared Statements”
Section 5.1.8, “Server System Variables”
Section 13.7.7.17, “SHOW ERRORS Statement”
Section 13.7.7.42, “SHOW WARNINGS Statement”
Section 13.6.7.5, “SIGNAL Statement”
Section 13.6.7.7, “The MySQL Diagnostics Area”

windowing_use_high_precision

Section 5.1.8, “Server System Variables”
Section 8.2.1.21, “Window Function Optimization”