System Variable Index
Prev		Next

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

`audit_log_buffer_size`

Section 6.3.11.4, “Audit Log Plugin Logging Control”
Section 6.3.11.5, “Audit Log Plugin Options and Variables”

`audit_log_file`

Section 6.3.11.4, “Audit Log Plugin Logging Control”
Section 6.3.11.5, “Audit Log Plugin Options and Variables”
Section 6.3.11.2, “Audit Log Plugin Security Considerations”
Section 6.3.11, “MySQL Enterprise Audit Log Plugin”

`audit_log_flush`

Section 6.3.11.4, “Audit Log Plugin Logging Control”
Section 6.3.11.5, “Audit Log Plugin Options and Variables”

`audit_log_policy`

Section 6.3.11.4, “Audit Log Plugin Logging Control”
Section 6.3.11.5, “Audit Log Plugin Options and Variables”
Section 6.3.11, “MySQL Enterprise Audit Log Plugin”

`audit_log_rotate_on_size`

Section 6.3.11.4, “Audit Log Plugin Logging Control”
Section 6.3.11.5, “Audit Log Plugin Options and Variables”

`audit_log_strategy`

Section 6.3.11.4, “Audit Log Plugin Logging Control”
Section 6.3.11.5, “Audit Log Plugin Options and Variables”

`auto_increment_increment`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 16.1.4.2, “Replication Master Options and Variables”
Section 5.4.4.1, “Traditional InnoDB Auto-Increment Locking”
Section 3.6.9, “Using AUTO_INCREMENT”

`auto_increment_offset`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 16.1.4.2, “Replication Master Options and Variables”
Section 5.4.4.1, “Traditional InnoDB Auto-Increment Locking”
Section 3.6.9, “Using AUTO_INCREMENT”

`AUTOCOMMIT`

Section 16.4.1.30, “Replication and Transactions”

`autocommit`

Section 13.2.2, “DELETE Syntax”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 14.2.3.9, “Deadlock Detection and Rollback”
Section 5.5.5, “Examples of Online DDL”
Section 13.3.5.1, “Interaction of Table Locking and Transactions”
Section 14.2.7, “Limits on InnoDB Tables”
Section 14.2.3.4, “Locking Reads (SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE)”
Section 14.2.3.7, “Locks Set by Different SQL Statements in InnoDB”
Section 16.4.1.30, “Replication and Transactions”
Section 16.1.3.4, “Restrictions on Replication with GTIDs”
Section 5.1.4, “Server System Variables”
Section 1.8.5.3, “Transaction and Atomic Operation Differences”

`automatic_sp_privileges`

Section 13.1.4, “ALTER PROCEDURE Syntax”
Section 13.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 5.1.4, “Server System Variables”
Section 18.2.2, “Stored Routines and MySQL Privileges”

B

`back_log`

Section 5.1.4, “Server System Variables”

`basedir`

Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.1.4, “Server System Variables”

`big_tables`

Section 5.1.4, “Server System Variables”

`bind_address`

Section 5.1.4, “Server System Variables”

`binlog_cache_size`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.1.6, “Server Status Variables”
Section 5.2.4, “The Binary Log”

`binlog_checksum`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

`binlog_direct_non_transactional_updates`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.4.1.30, “Replication and Transactions”

`binlog_format`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 12.7, “Date and Time Functions”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 16.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.14, “Information Functions”
Section 5.2.4.4, “Logging Format for Changes to mysql Database Tables”
Section 12.6.2, “Mathematical Functions”
Section 12.16, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.2, “Replication and BLACKHOLE Tables”
Section 16.4.1.21, “Replication and MEMORY Tables”
Section 16.4.1.22, “Replication and Temporary Tables”
Section 16.4.1.30, “Replication and Transactions”
Section 16.1.2, “Replication Formats”
Section 16.4.1.23, “Replication of the mysql System Database”
Section 16.1.3.4, “Restrictions on Replication with GTIDs”
Section 5.1.3, “Server Command Options”
Section 5.2.4.2, “Setting The Binary Log Format”
Section 14.7, “The BLACKHOLE Storage Engine”
Section 5.2.3, “The General Query Log”
Section 16.4.3, “Upgrading a Replication Setup”
Section 2.11.1.1, “Upgrading from MySQL 5.6 to 5.7”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”
Section 14.2.9.6, “Using the InnoDB memcached Plugin with Replication”

`binlog_max_flush_queue_time`

Section 16.1.4.4, “Binary Log Options and Variables”

`binlog_order_commits`

Section 16.1.4.4, “Binary Log Options and Variables”

`binlog_row_image`

Section 16.1.4.4, “Binary Log Options and Variables”

`binlog_rows_query_log_events`

Section 16.1.4.4, “Binary Log Options and Variables”

`binlog_stmt_cache_size`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.1.6, “Server Status Variables”

`bulk_insert_buffer_size`

Section 14.3.1, “MyISAM Startup Options”
Section 5.1.4, “Server System Variables”
Section 8.2.2.1, “Speed of INSERT Statements”

C

`character_set_client`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.4, “SET Syntax”
Section 13.7.5.7, “SHOW CREATE EVENT Syntax”
Section 13.7.5.9, “SHOW CREATE PROCEDURE Syntax”
Section 13.7.5.11, “SHOW CREATE TRIGGER Syntax”
Section 13.7.5.12, “SHOW CREATE VIEW Syntax”
Section 13.7.5.17, “SHOW EVENTS Syntax”
Section 13.7.5.27, “SHOW PROCEDURE STATUS Syntax”
Section 13.7.5.37, “SHOW TRIGGERS Syntax”
Section 21.8.9.1, “C API Prepared Statement Type Codes”
Section 10.5, “Character Set Configuration”
Section 10.1.4, “Connection Character Sets and Collations”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”

`character_set_connection`

Section 10.1.9.2, “CONVERT() and CAST()”
Section 13.7.4, “SET Syntax”
Section 10.1.3.5, “Character String Literal Character Set and Collation”
Section 10.1.7.5, “Collation of Expressions”
Section 10.1.4, “Connection Character Sets and Collations”
Section 12.7, “Date and Time Functions”
Section 12.13, “Encryption and Compression Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 10.7, “MySQL Server Locale Support”
Section 16.4.1.33, “Replication and Variables”
Section 10.1.9.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 9.1.1, “String Literals”
Section 10.1.8, “String Repertoire”
Section 12.2, “Type Conversion in Expression Evaluation”

`character_set_database`

Section 13.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.4, “SET Syntax”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”

`character_set_filesystem`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”

`character_set_results`

Section 13.7.4, “SET Syntax”
Section 21.8.5, “C API Data Structures”
Section 10.1.6, “Character Set for Error Messages”
Section 10.1.4, “Connection Character Sets and Collations”
Section 5.1.4, “Server System Variables”
Section 10.1.12, “UTF-8 for Metadata”

`character_set_server`

Section 10.5, “Character Set Configuration”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.3, “Replication and Character Sets”
Section 16.4.1.33, “Replication and Variables”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”

`character_set_system`

Section 10.5, “Character Set Configuration”
Section 5.1.4, “Server System Variables”
Section 10.1.12, “UTF-8 for Metadata”

`character_sets_dir`

Section 10.4.3, “Adding a Simple Collation to an 8-Bit Character Set”
Section 10.4.4.1, “Defining a UCA Collation Using LDML Syntax”
Section 5.1.4, “Server System Variables”

`collation_connection`

Section 10.1.9.2, “CONVERT() and CAST()”
Section 13.7.4, “SET Syntax”
Section 13.7.5.7, “SHOW CREATE EVENT Syntax”
Section 13.7.5.9, “SHOW CREATE PROCEDURE Syntax”
Section 13.7.5.11, “SHOW CREATE TRIGGER Syntax”
Section 13.7.5.12, “SHOW CREATE VIEW Syntax”
Section 13.7.5.17, “SHOW EVENTS Syntax”
Section 13.7.5.27, “SHOW PROCEDURE STATUS Syntax”
Section 13.7.5.37, “SHOW TRIGGERS Syntax”
Section 10.1.3.5, “Character String Literal Character Set and Collation”
Section 10.1.7.5, “Collation of Expressions”
Section 10.1.4, “Connection Character Sets and Collations”
Section 12.7, “Date and Time Functions”
Section 12.13, “Encryption and Compression Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 10.1.9.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 12.2, “Type Conversion in Expression Evaluation”

`collation_database`

Section 13.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”

`collation_server`

Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.3, “Replication and Character Sets”
Section 16.4.1.33, “Replication and Variables”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”

`completion_type`

Section 21.8.7.6, “mysql_commit()”
Section 21.8.7.58, “mysql_rollback()”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.1.4, “Server System Variables”

`concurrent_insert`

Section 8.10.3, “Concurrent Inserts”
Section 8.10.1, “Internal Locking Methods”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 8.2.5, “Other Optimization Tips”
Section 5.1.4, “Server System Variables”

`connect_timeout`

Section C.5.2.3, “Lost connection to MySQL server”
Section 21.8.7.53, “mysql_real_connect()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.4, “Server System Variables”

`core_file`

Section 5.1.4, “Server System Variables”

D

`daemon_memcached_engine_lib_name`

Section 14.2.9.3.2, “Installing and Configuring the InnoDB memcached Plugin”

`daemon_memcached_engine_lib_path`

Section 14.2.9.3.2, “Installing and Configuring the InnoDB memcached Plugin”

`daemon_memcached_option`

Section 14.2.9.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.9.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 14.2.9.4.1, “Password-Protecting the memcached Interface through SASL”
Section 14.2.9.8, “Troubleshooting the InnoDB memcached Plugin”

`daemon_memcached_r_batch_size`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.9.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.9.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 14.2.9.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”
Section 14.2.9.6, “Using the InnoDB memcached Plugin with Replication”

`daemon_memcached_w_batch_size`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.9.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.9.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.2.9.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 14.2.9.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”
Section 14.2.9.6, “Using the InnoDB memcached Plugin with Replication”

`DATADIR`

Section 5.4.1.2, “Specifying the Location of a Tablespace”

`datadir`

Section 2.3, “Installing MySQL on Microsoft Windows”
Section 5.1.4, “Server System Variables”

`date_format`

Section 5.1.4, “Server System Variables”

`datetime_format`

Section 5.1.4, “Server System Variables”

`debug`

Section 5.1.4, “Server System Variables”
Section 22.4.3, “The DBUG Package”

`debug_sync`

Section 5.1.4, “Server System Variables”

`default_storage_engine`

Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 14.1, “Setting the Storage Engine”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”

`default_tmp_storage_engine`

Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.1, “Setting the Storage Engine”

`default_week_format`

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

`delay_key_write`

Section 13.1.14, “CREATE TABLE Syntax”
Section 5.1.4, “Server System Variables”

`delayed_insert_limit`

Section 5.1.4, “Server System Variables”

`delayed_insert_timeout`

Section 5.1.4, “Server System Variables”

`delayed_queue_size`

Section 5.1.4, “Server System Variables”

`disconnect_on_expired_password`

Section 6.3.6, “Password Expiration and Sandbox Mode”
Section 5.1.4, “Server System Variables”

`div_precision_increment`

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

E

`end_markers_in_json`

Section 5.1.4, “Server System Variables”

`eq_range_index_dive_limit`

Section 8.2.1.3.3, “Equality Range Optimization of Many-Valued Comparisons”
Section 5.1.4, “Server System Variables”

`error_count`

Section 13.7.5.16, “SHOW ERRORS Syntax”
Section 13.6.7.7.5, “Diagnostics Area-Related System Variables”
Section 5.1.4, “Server System Variables”
Section C.1, “Sources of Error Information”
Section 13.5, “SQL Syntax for Prepared Statements”

`event_scheduler`

Section 18.4.2, “Event Scheduler Configuration”
Section 21.7.2, “Restrictions When Using the Embedded MySQL Server”
Section 5.1.4, “Server System Variables”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”

`expire_logs_days`

Section 13.4.1.1, “PURGE BINARY LOGS Syntax”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.4, “Server System Variables”

`explicit_defaults_for_timestamp`

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 11.5, “Data Type Default Values”
Section 11.1.2, “Date and Time Type Overview”
Section 5.1.4, “Server System Variables”

`external_user`

Section 22.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 6.3.8, “Proxy Users”
Section 5.1.4, “Server System Variables”
Section 22.2.4.9.1, “Writing the Server-Side Authentication Plugin”

F

`flush`

Section 5.1.4, “Server System Variables”

`flush_time`

Section 5.1.4, “Server System Variables”

`foreign_key_checks`

Section 5.4.1.3, “Copying Tablespaces to Another Server (Transportable Tablespaces)”
Section 5.5.6, “Implementation Details of Online DDL”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.5.1, “Overview of Online DDL”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”
Section 13.1.14.2, “Using FOREIGN KEY Constraints”

`ft_boolean_syntax`

Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.4, “Server System Variables”

`ft_max_word_len`

Section 12.9.2, “Boolean Full-Text Searches”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.3.2, “Full-Text Parser Plugins”
Section 5.1.4, “Server System Variables”

`ft_min_word_len`

Section 12.9.2, “Boolean Full-Text Searches”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.3.2, “Full-Text Parser Plugins”
Section 12.9.1, “Natural Language Full-Text Searches”
Section 5.1.4, “Server System Variables”

`ft_query_expansion_limit`

Section 5.1.4, “Server System Variables”

`ft_stopword_file`

Section 12.9.2, “Boolean Full-Text Searches”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.9, “Full-Text Search Functions”
Section 12.9.1, “Natural Language Full-Text Searches”
Section 5.1.4, “Server System Variables”

G

`general_log`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

`general_log_file`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

`group_concat_max_len`

Section 12.17.1, “GROUP BY (Aggregate) Functions”
Section 5.1.4, “Server System Variables”

`gtid_executed`

Section 13.4.1.2, “RESET MASTER Syntax”
Section 13.7.5.22, “SHOW MASTER STATUS Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.1, “GTID Concepts”
Section 20.9.9, “Performance Schema Replication Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.1.3.4, “Restrictions on Replication with GTIDs”
Section 16.1.3.3, “Using GTIDs for Failover and Scaleout”

`gtid_mode`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 12.15, “Functions Used with Global Transaction IDs”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 20.9.9.6, “The replication_execute_status_by_worker Table”
Section 16.1.3.3, “Using GTIDs for Failover and Scaleout”

`gtid_next`

Section 13.1.5, “ALTER SERVER Syntax”
Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 13.7.6.2, “CACHE INDEX Syntax”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.7.2.2, “CHECK TABLE Syntax”
Section 13.1.13, “CREATE SERVER Syntax”
Section 13.1.22, “DROP SERVER Syntax”
Section 13.7.6.3, “FLUSH Syntax”
Section 13.7.6.5, “LOAD INDEX INTO CACHE Syntax”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 13.7.2.5, “REPAIR TABLE Syntax”
Section 13.7.6.6, “RESET Syntax”
Section 13.4.2.5, “START SLAVE Syntax”
Section 13.4.2.6, “STOP SLAVE Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.1, “GTID Concepts”
Section 20.9.9.6, “The replication_execute_status_by_worker Table”

`gtid_owned`

Section 16.1.4.5, “Global Transaction ID Options and Variables”

`gtid_purged`

Section 13.4.1.2, “RESET MASTER Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.1, “GTID Concepts”
Section 16.1.3.3, “Using GTIDs for Failover and Scaleout”

H

`have_compress`

Section 5.1.4, “Server System Variables”

`have_crypt`

Section 5.1.4, “Server System Variables”

`have_dynamic_loading`

Section 16.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.4, “Server System Variables”

`have_geometry`

Section 5.1.4, “Server System Variables”

`have_openssl`

Section 5.1.4, “Server System Variables”

`have_partitioning`

Chapter 17, Partitioning

`have_profiling`

Section 5.1.4, “Server System Variables”

`have_query_cache`

Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”

`have_rtree_keys`

Section 5.1.4, “Server System Variables”

`have_ssl`

Section 6.3.9.2, “Configuring MySQL for SSL”
Section 5.1.4, “Server System Variables”

`have_symlink`

Section 5.1.4, “Server System Variables”
Section 8.11.3.1.2, “Using Symbolic Links for MyISAM Tables on Unix”

`host_cache_size`

Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

`hostname`

Section 5.1.4, “Server System Variables”

I

`identity`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”

`ignore_db_dirs`

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

`init_connect`

Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 20.9.11.1, “The host_cache Table”

`init_file`

Section 5.1.4, “Server System Variables”

`init_slave`

Section 16.1.4.3, “Replication Slave Options and Variables”

`innodb`

Section 14.2.5.1, “Support for Read-Only Media”

`innodb_adaptive_flushing`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_adaptive_hash_index`

Section 14.2.3.13.6, “Adaptive Hash Indexes”
Section 14.2.5.5.4, “Dynamically Changing innodb_adaptive_hash_index”

`innodb_adaptive_max_sleep_delay`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_api_bk_commit_interval`

Section 14.2.9.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.9.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

`innodb_api_enable_binlog`

Section 14.2.9.6, “Using the InnoDB memcached Plugin with Replication”

`innodb_api_enable_mdl`

Section 14.2.9.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.9.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

`innodb_api_trx_level`

Section 14.2.9.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.9.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

`innodb_autoextend_increment`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.2.2, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 14.2.1.2, “Configuring InnoDB”
Section 5.4.1, “Managing InnoDB Tablespaces”

`innodb_autoinc_lock_mode`

Section 8.5.4, “Bulk Data Loading for InnoDB Tables”
Section 5.4.4.2, “Configurable InnoDB Auto-Increment Locking”

`innodb_buffer_pool_dump_at_shutdown`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_buffer_pool_dump_now`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_buffer_pool_dump_pct`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 1.4, “What Is New in MySQL 5.7”

`innodb_buffer_pool_instances`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 8.9.1, “The InnoDB Buffer Pool”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_buffer_pool_load_abort`

Section 5.1.6, “Server Status Variables”

`innodb_buffer_pool_load_at_startup`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.1.6, “Server Status Variables”

`innodb_buffer_pool_load_now`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.1.6, “Server Status Variables”

`innodb_buffer_pool_size`

Section 14.2.3.15.1, “InnoDB Error Codes”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.9.2, “Architecture of InnoDB and memcached Integration”
Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 5.1.6, “Server Status Variables”
Section 8.9.1, “The InnoDB Buffer Pool”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_change_buffer_max_size`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_change_buffering`

Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 14.2.5.1, “Support for Read-Only Media”

`innodb_checksum_algorithm`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_checksums`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_cmp_per_index_enabled`

Section 5.4.6.4, “Monitoring Compression at Runtime”
Section 19.30.2, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 5.4.6.3, “Tuning Compression for InnoDB Tables”

`innodb_compression_failure_threshold_pct`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.4.6.5, “How Compression Works for InnoDB Tables”
Section 5.4.6.3, “Tuning Compression for InnoDB Tables”

`innodb_compression_level`

Section 5.4.6.5, “How Compression Works for InnoDB Tables”
Section 5.4.6.3, “Tuning Compression for InnoDB Tables”

`innodb_compression_pad_pct_max`

Section 5.4.6.5, “How Compression Works for InnoDB Tables”
Section 5.4.6.3, “Tuning Compression for InnoDB Tables”

`innodb_concurrency_tickets`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Configuration Variables”

`innodb_data_file_path`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.2.2, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 14.2.1.2, “Configuring InnoDB”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 14.2.4.5.1, “Troubleshooting InnoDB I/O Problems”
Section 14.2.2.3, “Using Raw Disk Partitions for the Shared Tablespace”

`innodb_data_home_dir`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.1.2, “Configuring InnoDB”
Section 14.2.4.5.1, “Troubleshooting InnoDB I/O Problems”

`innodb_doublewrite`

Section 14.2.8, “MySQL and the ACID Model”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_fast_shutdown`

Section 5.4.7.2.1, “Compatibility Check When InnoDB Is Started”
Section 5.1.12, “The Shutdown Process”
Section 2.11.1.1, “Upgrading from MySQL 5.6 to 5.7”

`innodb_file_format`

Section 13.1.14, “CREATE TABLE Syntax”
Section 5.4.8.3, “DYNAMIC and COMPRESSED Row Formats”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.4.7.2.1, “Compatibility Check When InnoDB Is Started”
Section 5.4.7.2.2, “Compatibility Check When a Table Is Opened”
Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 14.2.5.5.1, “Dynamically Changing innodb_file_per_table”
Section 5.4.6.2, “Enabling Compression for a Table”
Section 5.4.7.1, “Enabling File Formats”
Section 5.4.7.3, “Identifying the File Format in Use”
Section 5.4.8.1, “Overview of InnoDB Row Storage”
Section 5.4.6.6, “SQL Compression Syntax Warnings and Errors”
Section 14.2.5.4, “The Barracuda File Format”

`innodb_file_format_check`

Section 5.4.7.2.1, “Compatibility Check When InnoDB Is Started”
Section 5.4.7.2.2, “Compatibility Check When a Table Is Opened”

`innodb_file_format_max`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_file_per_table`

Section 13.1.14, “CREATE TABLE Syntax”
Section 13.7.6.3, “FLUSH Syntax”
Section 14.2.2.6, “InnoDB and MySQL Replication”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.4.4.2, “InnoDB Tablespace Monitor Output”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 14.2.5.6, “TRUNCATE TABLE Reclaims Space”
Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 5.4.1.3, “Copying Tablespaces to Another Server (Transportable Tablespaces)”
Section 14.2.2.1, “Creating the InnoDB Tablespace”
Section 14.2.5.5.1, “Dynamically Changing innodb_file_per_table”
Section 5.4.1.1, “Enabling and Disabling File-Per-Table Mode”
Section 5.4.6.2, “Enabling Compression for a Table”
Section 5.5.6, “Implementation Details of Online DDL”
Section 5.4.1, “Managing InnoDB Tablespaces”
Section 14.2.8, “MySQL and the ACID Model”
Section 5.4.8.1, “Overview of InnoDB Row Storage”
Section 14.2.3.13.7, “Physical Row Structure”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 17.6, “Restrictions and Limitations on Partitioning”
Section 5.4.6.6, “SQL Compression Syntax Warnings and Errors”
Section 14.2, “The InnoDB Storage Engine”
Section 14.2.4.7, “Troubleshooting InnoDB Data Dictionary Operations”

`innodb_flush_log_at_timeout`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_flush_log_at_trx_commit`

Section 14.2.8, “MySQL and the ACID Model”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_flush_method`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.4.1, “Managing InnoDB Tablespaces”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 5.1.6, “Server Status Variables”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_flush_neighbors`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_force_load_corrupted`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_force_recovery`

Section 1.7, “How to Report Bugs or Problems”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 14.2.4.6, “Starting InnoDB on a Corrupted Database”

`innodb_ft_aux_table`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 19.30.25, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 19.30.20, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 19.30.24, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 19.30.23, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 19.30.22, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

`innodb_ft_cache_size`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_ft_enable_diag_print`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_ft_enable_stopword`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.9, “Full-Text Search Functions”
Section 12.9.1, “Natural Language Full-Text Searches”

`innodb_ft_max_token_size`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.3.2, “Full-Text Parser Plugins”

`innodb_ft_min_token_size`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 22.2.3.2, “Full-Text Parser Plugins”
Section 12.9.1, “Natural Language Full-Text Searches”

`innodb_ft_num_word_optimize`

Section 14.2.3.13.3, “FULLTEXT Indexes”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”

`innodb_ft_server_stopword_table`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.9, “Full-Text Search Functions”
Section 12.9.4, “Full-Text Stopwords”
Section 12.9.1, “Natural Language Full-Text Searches”
Section 19.30.21, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

`innodb_ft_sort_pll_degree`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_ft_user_stopword_table`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.9, “Full-Text Search Functions”
Section 12.9.4, “Full-Text Stopwords”
Section 12.9.1, “Natural Language Full-Text Searches”
Section 19.30.21, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

`innodb_io_capacity`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 1.4, “What Is New in MySQL 5.7”

`innodb_io_capacity_max`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_large_prefix`

Section 2.11.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 8.3.4, “Column Indexes”
Section 14.2.7, “Limits on InnoDB Tables”

`innodb_lock_wait_timeout`

Section 14.2.3.15.1, “InnoDB Error Codes”
Section 14.2.3.9, “Deadlock Detection and Rollback”
Section 14.2.5.5.3, “Dynamically Changing innodb_lock_wait_timeout”
Section 16.4.1.28, “Replication Retries and Timeouts”
Section 16.1.4.3, “Replication Slave Options and Variables”

`innodb_locks_unsafe_for_binlog`

Section 14.2.3.5, “InnoDB Record, Gap, and Next-Key Locks”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 14.2.3.3, “Consistent Nonlocking Reads”

`innodb_log_buffer_size`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_log_file_size`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.2.2, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 14.2.1.2, “Configuring InnoDB”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.2.5.1, “Support for Read-Only Media”

`innodb_log_files_in_group`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.2.2, “Adding, Removing, or Resizing InnoDB Data and Log Files”

`innodb_log_group_home_dir`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_lru_scan_depth`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_max_dirty_pages_pct`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_max_purge_lag`

Section 14.2.3.11, “InnoDB Multi-Versioning”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_max_purge_lag_delay`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_monitor_disable`

Section 19.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_enable`

Section 19.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_reset`

Section 19.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_reset_all`

Section 19.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_old_blocks_pct`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.9.1, “The InnoDB Buffer Pool”

`innodb_old_blocks_time`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.9.1, “The InnoDB Buffer Pool”

`innodb_online_alter_log_max_size`

Section 5.5.6, “Implementation Details of Online DDL”

`innodb_open_files`

Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 5.1.4, “Server System Variables”

`innodb_optimize_fulltext_only`

Section 14.2.3.13.3, “FULLTEXT Indexes”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”

`innodb_page_size`

Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 5.3.2, “File Space Management”
Section 5.4.6.5, “How Compression Works for InnoDB Tables”
Section 14.2.7, “Limits on InnoDB Tables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.2.3.13.4, “Physical Structure of an InnoDB Index”
Section 14.2.9.8, “Troubleshooting the InnoDB memcached Plugin”

`innodb_print_all_deadlocks`

Section 14.2.4.5, “InnoDB General Troubleshooting”
Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 14.2.3.10, “How to Cope with Deadlocks”

`innodb_random_read_ahead`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_read_ahead_threshold`

Section 14.2.5.11, “More Read-Ahead Statistics”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_read_io_threads`

Section 14.2.4.4.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 22.1.1, “MySQL Threads”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_rollback_segments`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_sort_buffer_size`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_stats_auto_recalc`

Section 13.1.14, “CREATE TABLE Syntax”

`innodb_stats_method`

Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”

`innodb_stats_on_metadata`

Section 14.2.5.5.2, “Dynamically Changing innodb_stats_on_metadata”

`innodb_stats_persistent`

Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 13.1.11, “CREATE INDEX Syntax”
Section 13.1.14, “CREATE TABLE Syntax”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.7, “Limits on InnoDB Tables”

`innodb_stats_persistent_sample_pages`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.7, “Limits on InnoDB Tables”

`innodb_stats_transient_sample_pages`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.5.8, “Controlling Optimizer Statistics Estimation”
Section 14.2.7, “Limits on InnoDB Tables”

`innodb_strict_mode`

Section 13.1.11, “CREATE INDEX Syntax”
Section 13.1.14, “CREATE TABLE Syntax”
Section 14.2.5.7, “InnoDB Strict Mode”
Section 5.4.6.5, “How Compression Works for InnoDB Tables”
Section 5.1.7, “Server SQL Modes”
Section 5.4.6.6, “SQL Compression Syntax Warnings and Errors”

`innodb_support_xa`

Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 14.2.9.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_table_locks`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.7, “Limits on InnoDB Tables”

`innodb_temp_data_file_path`

Section 14.2.3.12, “InnoDB Temporary Table Undo Logs”
Section 1.4, “What Is New in MySQL 5.7”

`innodb_thread_concurrency`

Section 14.2.4.4.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Configuration Variables”

`innodb_thread_sleep_delay`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_undo_directory`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.5.1, “Support for Read-Only Media”

`innodb_undo_logs`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 5.1.6, “Server Status Variables”

`innodb_undo_tablespaces`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 14.2.5.1, “Support for Read-Only Media”

`innodb_use_native_aio`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_use_sys_malloc`

Section 14.2.6, “InnoDB Startup Options and System Variables”

`innodb_write_io_threads`

Section 14.2.4.4.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 22.1.1, “MySQL Threads”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`insert_id`

Section 14.9.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.1.4, “Server System Variables”

`interactive_timeout`

Section 21.8.7.53, “mysql_real_connect()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.4, “Server System Variables”

J

`join_buffer_size`

Section 8.2.1.10, “Nested-Loop Join Algorithms”
Section 5.1.4, “Server System Variables”

K

`keep_files_on_create`

Section 5.1.4, “Server System Variables”

`key_buffer_size`

Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 8.8.5, “Estimating Query Performance”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 7.6.3, “How to Repair MyISAM Tables”
Section C.5.8, “Known Issues in MySQL”
Section 8.9.2.2, “Multiple Key Caches”
Section 8.9.2.6, “Restructuring a Key Cache”
Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 8.2.2.3, “Speed of DELETE Statements”
Section 8.6.3, “Speed of REPAIR TABLE Statements”
Section 5.1.5.1, “Structured System Variables”
Section 8.9.2, “The MyISAM Key Cache”
Section 8.11.2, “Tuning Server Parameters”
Section 4.2.3.3, “Using Option Files”

`key_cache_age_threshold`

Section 8.9.2.3, “Midpoint Insertion Strategy”
Section 5.1.4, “Server System Variables”
Section 5.1.5.1, “Structured System Variables”

`key_cache_block_size`

Section 8.9.2.5, “Key Cache Block Size”
Section 8.9.2.6, “Restructuring a Key Cache”
Section 5.1.4, “Server System Variables”
Section 5.1.5.1, “Structured System Variables”

`key_cache_division_limit`

Section 8.9.2.3, “Midpoint Insertion Strategy”
Section 5.1.4, “Server System Variables”
Section 5.1.5.1, “Structured System Variables”

L

`large_files_support`

Section 17.6, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”

`large_page_size`

Section 5.1.4, “Server System Variables”

`large_pages`

Section 5.1.4, “Server System Variables”

`last_insert_id`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”

`lc_messages`

Section 5.1.4, “Server System Variables”
Section 10.2, “Setting the Error Message Language”

`lc_messages_dir`

Section 5.1.4, “Server System Variables”
Section 10.2, “Setting the Error Message Language”

`lc_time_names`

Section 12.7, “Date and Time Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 10.7, “MySQL Server Locale Support”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”

`license`

Section 5.1.4, “Server System Variables”

`local`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.7, “LOAD XML Syntax”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

`local_infile`

Section 5.1.4, “Server System Variables”

`lock_wait_timeout`

Section 5.1.4, “Server System Variables”

`locked_in_memory`

Section 5.1.4, “Server System Variables”

`log`

Section 14.2.9.6, “Using the InnoDB memcached Plugin with Replication”

`log_bin`

Section 16.1.4.4, “Binary Log Options and Variables”

`log_bin_basename`

Section 16.1.4.4, “Binary Log Options and Variables”

`log_bin_index`

Section 16.1.4.4, “Binary Log Options and Variables”

`log_bin_trust_function_creators`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 5.1.4, “Server System Variables”

`log_bin_use_v`

Section 16.1.4.4, “Binary Log Options and Variables”

`log_error`

Section 5.1.4, “Server System Variables”
Section 5.2.2, “The Error Log”

`log_output`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”
Section 5.2.5, “The Slow Query Log”

`log_queries_not_using_indexes`

Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`log_slave_updates`

Section 16.1.4.4, “Binary Log Options and Variables”

`log_slow_admin_statements`

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

`log_slow_slave_statements`

Section 16.1.4.3, “Replication Slave Options and Variables”

`log_throttle_queries_not_using_indexes`

Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`log_warnings`

Section 5.1.4, “Server System Variables”
Section 5.2.2, “The Error Log”

`long_query_time`

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.2, “MySQL Server Logs”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`low_priority_updates`

Section 5.1.4, “Server System Variables”
Section 8.10.2, “Table Locking Issues”

`lower_case_file_system`

Section 5.1.4, “Server System Variables”

`lower_case_table_names`

Section 13.7.1.4, “GRANT Syntax”
Section 13.7.1.6, “REVOKE Syntax”
Section 13.7.5.36, “SHOW TABLES Syntax”
Section 10.1.7.9, “Collation and INFORMATION_SCHEMA Searches”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 1.7, “How to Report Bugs or Problems”
Section 9.2.2, “Identifier Case Sensitivity”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 19.30.9, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
Section 19.30.7, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
Section 13.1.14.2, “Using FOREIGN KEY Constraints”

M

`master_info_repository`

Section 16.1.4.3, “Replication Slave Options and Variables”

`master_verify_checksum`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

`max_allowed_packet`

Section 12.17.1, “GROUP BY (Aggregate) Functions”
Section C.5.2.3, “Lost connection to MySQL server”
Section C.5.2.9, “MySQL server has gone away”
Section 21.8.11.26, “mysql_stmt_send_long_data()”
Section 21.8.7.72, “mysql_use_result()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 12.3.2, “Comparison Functions and Operators”
Section C.5.5.6, “Deleting Rows from Related Tables”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 21.8, “MySQL C API”
Section C.5.2.10, “Packet Too Large”
Section 16.4.1.20, “Replication and max_allowed_packet”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”
Section 11.4.3, “The BLOB and TEXT Types”
Section 4.2.3.3, “Using Option Files”

`max_binlog_cache_size`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.2.4, “The Binary Log”

`max_binlog_size`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.2, “MySQL Server Logs”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”
Section 16.2.2.1, “The Slave Relay Log”

`max_binlog_stmt_cache_size`

Section 16.1.4.4, “Binary Log Options and Variables”

`max_connect_errors`

Section 13.7.6.3, “FLUSH Syntax”
Section C.5.2.6, “Host 'host_name' is blocked”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 5.1.4, “Server System Variables”
Section 20.9.11.1, “The host_cache Table”

`max_connections`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section C.5.2.7, “Too many connections”
Section 22.4.1.4, “Debugging mysqld under gdb”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 20.12, “Performance Schema System Variables”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`max_delayed_threads`

Section 5.1.4, “Server System Variables”

`max_error_count`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.6.7.4, “RESIGNAL Syntax”
Section 13.7.5.16, “SHOW ERRORS Syntax”
Section 13.7.5.39, “SHOW WARNINGS Syntax”
Section 13.6.7.7.5, “Diagnostics Area-Related System Variables”
Section 5.1.4, “Server System Variables”

`max_heap_table_size`

Section 8.4.3.3, “How MySQL Uses Internal Temporary Tables”
Section D.10.3, “Limits on Table Size”
Section 16.4.1.21, “Replication and MEMORY Tables”
Section 16.4.1.33, “Replication and Variables”
Section D.3, “Restrictions on Server-Side Cursors”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 14.4, “The MEMORY Storage Engine”

`max_insert_delayed_threads`

Section 5.1.4, “Server System Variables”

`max_join_size`

Section 8.8.2, “EXPLAIN Output Format”
Section 13.7.4, “SET Syntax”
Section 5.1.4, “Server System Variables”
Section 5.1.5, “Using System Variables”

`max_length_for_sort_data`

Section 8.2.1.15, “ORDER BY Optimization”
Section 5.1.4, “Server System Variables”

`max_prepared_stmt_count`

Section 13.5.3, “DEALLOCATE PREPARE Syntax”
Section 8.9.4, “Caching of Prepared Statements and Stored Programs”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 13.5, “SQL Syntax for Prepared Statements”

`max_relay_log_size`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 16.2.2.1, “The Slave Relay Log”

`max_seeks_for_key`

Section 14.2.7, “Limits on InnoDB Tables”
Section 5.1.4, “Server System Variables”

`max_sort_length`

Section 13.1.14, “CREATE TABLE Syntax”
Section C.5.8, “Known Issues in MySQL”
Section 5.1.4, “Server System Variables”
Section 11.4.3, “The BLOB and TEXT Types”

`max_sp_recursion_depth`

Section 5.1.4, “Server System Variables”
Section 18.2.1, “Stored Routine Syntax”

`max_tmp_tables`

Section 5.1.4, “Server System Variables”

`max_user_connections`

Section 13.7.1.4, “GRANT Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.4, “Server System Variables”
Section 6.3.4, “Setting Account Resource Limits”

`max_write_lock_count`

Section 5.1.4, “Server System Variables”
Section 8.10.2, “Table Locking Issues”

`metadata_locks_cache_size`

Section 5.1.4, “Server System Variables”

`metadata_locks_hash_instances`

Section 5.1.4, “Server System Variables”

`min_examined_row_limit`

Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`myisam_data_pointer_size`

Section 13.1.14, “CREATE TABLE Syntax”
Section D.10.3, “Limits on Table Size”
Section 5.1.4, “Server System Variables”

`myisam_max_sort_file_size`

Section 14.3.1, “MyISAM Startup Options”
Section 17.6, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”

`myisam_mmap_size`

Section 5.1.4, “Server System Variables”

`myisam_recover_options`

Section 5.1.4, “Server System Variables”

`myisam_repair_threads`

Section 5.1.4, “Server System Variables”

`myisam_sort_buffer_size`

Section 13.1.6, “ALTER TABLE Syntax”
Section 14.3.1, “MyISAM Startup Options”
Section 5.1.4, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”

`myisam_stats_method`

Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 5.1.4, “Server System Variables”

`myisam_use_mmap`

Section 8.11.4.1, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”

N

`named_pipe`

Section 5.1.4, “Server System Variables”

`net_buffer_length`

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 21.8, “MySQL C API”
Section 5.1.4, “Server System Variables”

`net_read_timeout`

Section C.5.2.3, “Lost connection to MySQL server”
Section 5.1.4, “Server System Variables”

`net_retry_count`

Section 5.1.4, “Server System Variables”

`net_write_timeout`

Section 5.1.4, “Server System Variables”

`new`

Section 5.1.4, “Server System Variables”

O

`old`

Section 13.2.9.3, “Index Hint Syntax”
Section 5.1.4, “Server System Variables”

`old_alter_table`

Section 13.1.6, “ALTER TABLE Syntax”
Section 5.5.1, “Overview of Online DDL”
Section 5.5.2, “Performance and Concurrency Considerations for Online DDL”
Section 5.1.4, “Server System Variables”
Section 5.5.3, “SQL Syntax for Online DDL”

`old_passwords`

Section 13.7.1.1, “ALTER USER Syntax”
Section C.5.2.4, “Client does not support authentication protocol”
Section 13.7.1.7, “SET PASSWORD Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 12.13, “Encryption and Compression Functions”
Section 6.1.2.5, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 21.9, “MySQL PHP API”
Section 6.3.6, “Password Expiration and Sandbox Mode”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 6.3.7.4, “The SHA-256 Authentication Plugin”

`open_files_limit`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 20.12, “Performance Schema System Variables”
Section 17.6, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”

`optimizer_join_cache_level`

Section 8.2.1.14.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.2.1.14.1, “Join Buffer Management for Block Nested-Loop and Batched Key Access Algorithms”

`optimizer_prune_level`

Section 8.8.6.1, “Controlling Query Plan Evaluation”
Section 5.1.4, “Server System Variables”

`optimizer_search_depth`

Section 8.8.6.1, “Controlling Query Plan Evaluation”
Section 5.1.4, “Server System Variables”

`optimizer_switch`

Section 8.2.1.14.3, “Batched Key Access Joins”
Section 8.2.1.14.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.8.6.2, “Controlling Switchable Optimizations”
Section 8.2.1.5, “Engine Condition Pushdown Optimization”
Section 8.2.1.6, “Index Condition Pushdown Optimization”
Section 8.2.1.14.1, “Join Buffer Management for Block Nested-Loop and Batched Key Access Algorithms”
Section 8.2.1.13, “Multi-Range Read Optimization”
Section 8.2.1.18.1, “Optimizing Subqueries with Semi-Join Transformations”
Section 8.2.1.18.2, “Optimizing Subqueries with Subquery Materialization”
Section 5.1.4, “Server System Variables”
Section 8.2.1.7, “Use of Index Extensions”

`optimizer_trace`

Section 5.1.4, “Server System Variables”
Section 19.12, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

`optimizer_trace_features`

Section 5.1.4, “Server System Variables”

`optimizer_trace_limit`

Section 5.1.4, “Server System Variables”

`optimizer_trace_max_mem_size`

Section 5.1.4, “Server System Variables”

`optimizer_trace_offset`

Section 5.1.4, “Server System Variables”

P

`performance_schema`

Section 20.1, “Performance Schema Quick Start”
Section 20.2.2, “Performance Schema Startup Configuration”
Section 20.12, “Performance Schema System Variables”

`performance_schema_accounts_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.7.1, “The accounts Table”

`performance_schema_digests_size`

Section 20.7, “Performance Schema Statement Digests”
Section 20.12, “Performance Schema System Variables”
Section 20.9.10.3, “Statement Summary Tables”

`performance_schema_events_stages_history_long_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.5.3, “The events_stages_history_long Table”

`performance_schema_events_stages_history_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.5.2, “The events_stages_history Table”

`performance_schema_events_statements_history_long_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.6.3, “The events_statements_history_long Table”

`performance_schema_events_statements_history_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.6.2, “The events_statements_history Table”

`performance_schema_events_waits_history_long_size`

Section 13.7.5.14, “SHOW ENGINE Syntax”
Section 20.12, “Performance Schema System Variables”
Section 20.9, “Performance Schema Table Descriptions”
Section 20.9.4.3, “The events_waits_history_long Table”

`performance_schema_events_waits_history_size`

Section 13.7.5.14, “SHOW ENGINE Syntax”
Section 20.12, “Performance Schema System Variables”
Section 20.9, “Performance Schema Table Descriptions”
Section 20.9.4.2, “The events_waits_history Table”

`performance_schema_hosts_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.7.2, “The hosts Table”

`performance_schema_max_cond_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_cond_instances`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_file_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_file_handles`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_file_instances`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_memory_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_mutex_classes`

Section 20.5, “Performance Schema Status Monitoring”
Section 20.12, “Performance Schema System Variables”

`performance_schema_max_mutex_instances`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_program_instances`

Section 20.13, “Performance Schema Status Variables”
Section 20.12, “Performance Schema System Variables”

`performance_schema_max_rwlock_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_rwlock_instances`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_socket_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_socket_instances`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_stage_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_statement_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_statement_stack`

Section 20.13, “Performance Schema Status Variables”
Section 20.12, “Performance Schema System Variables”

`performance_schema_max_table_handles`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_table_instances`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_thread_classes`

Section 20.12, “Performance Schema System Variables”

`performance_schema_max_thread_instances`

Section 13.7.5.14, “SHOW ENGINE Syntax”
Section 20.12, “Performance Schema System Variables”

`performance_schema_session_connect_attrs_size`

Section 20.12, “Performance Schema System Variables”

`performance_schema_setup_actors_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.2.1, “The setup_actors Table”

`performance_schema_setup_objects_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.2.4, “The setup_objects Table”

`performance_schema_users_size`

Section 20.12, “Performance Schema System Variables”
Section 20.9.7.3, “The users Table”

`pid_file`

Section 5.1.4, “Server System Variables”

`plugin_dir`

Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 13.7.5.24, “SHOW PLUGINS Syntax”
Section 6.1.2.2, “Administrator Guidelines for Password Security”
Section 6.3.7.1, “Authentication Plugin Usage Instructions”
Section 22.2.4.3, “Compiling and Installing Plugin Libraries”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 6.3.11.1, “Installing the Audit Log Plugin”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 14.12.1, “Pluggable Storage Engine Architecture”
Section 22.2.2, “Plugin API Components”
Section D.9, “Restrictions on Pluggable Authentication”
Section 16.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 19.15, “The INFORMATION_SCHEMA PLUGINS Table”
Section 6.3.7.6, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.7.7, “The Test Authentication Plugin”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 22.3.2.6, “User-Defined Function Security Precautions”
Section 22.2.4.9.3, “Using the Authentication Plugins”
Section 22.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 22.2.4.8, “Writing Audit Plugins”
Section 22.2.4.5, “Writing Daemon Plugins”
Section 22.2.4.4, “Writing Full-Text Parser Plugins”
Section 22.2.4.10, “Writing Password-Validation Plugins”
Section 22.2.4.7, “Writing Semisynchronous Replication Plugins”

`port`

Section C.5.2.2, “Can't connect to [local] MySQL server”
Section 5.1.4, “Server System Variables”

`preload_buffer_size`

Section 5.1.4, “Server System Variables”

`profiling`

Section 13.7.5.29, “SHOW PROFILE Syntax”
Section 5.1.4, “Server System Variables”
Section 19.17, “The INFORMATION_SCHEMA PROFILING Table”

`profiling_history_size`

Section 13.7.5.29, “SHOW PROFILE Syntax”
Section 5.1.4, “Server System Variables”

`protocol_version`

Section 5.1.4, “Server System Variables”

`proxy_user`

Section 6.3.8, “Proxy Users”
Section 5.1.4, “Server System Variables”

`pseudo_slave_mode`

Section 5.1.4, “Server System Variables”

`pseudo_thread_id`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”

Q

`query_alloc_block_size`

Section 5.1.4, “Server System Variables”

`query_cache_limit`

Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”

`query_cache_min_res_unit`

Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”

`query_cache_size`

Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”
Section 8.9.3, “The MySQL Query Cache”
Section 5.1.5, “Using System Variables”

`query_cache_type`

Section 13.2.9, “SELECT Syntax”
Section 8.9.3.2, “Query Cache SELECT Options”
Section 8.9.3.3, “Query Cache Configuration”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`query_cache_wlock_invalidate`

Section 5.1.4, “Server System Variables”

`query_prealloc_size`

Section 5.1.4, “Server System Variables”

R

`rand_seed`

Section 5.1.4, “Server System Variables”

`range_alloc_block_size`

Section 5.1.4, “Server System Variables”

`read_buffer_size`

Section 8.11.4.1, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”

`read_only`

Section 13.7.1.7, “SET PASSWORD Syntax”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 16.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
Section 6.2.1, “Privileges Provided by MySQL”
Section 16.4.1.33, “Replication and Variables”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 16.1.3.2, “Setting Up Replication Using GTIDs”

`read_rnd_buffer_size`

Section 8.2.1.15, “ORDER BY Optimization”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 8.2.1.13, “Multi-Range Read Optimization”
Section 5.1.4, “Server System Variables”
Section 8.11.2, “Tuning Server Parameters”

`relay_log`

Section 16.1.4.3, “Replication Slave Options and Variables”

`relay_log_basename`

Section 16.1.4.3, “Replication Slave Options and Variables”

`relay_log_index`

Section 16.1.4.3, “Replication Slave Options and Variables”

`relay_log_info_file`

Section 16.1.4.3, “Replication Slave Options and Variables”

`relay_log_info_repository`

Section 16.1.4.3, “Replication Slave Options and Variables”

`relay_log_purge`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 5.1.4, “Server System Variables”

`relay_log_recovery`

Section 13.4.2.5, “START SLAVE Syntax”
Section 16.1.4.3, “Replication Slave Options and Variables”

`relay_log_space_limit`

Section 8.12.5.5, “Replication Slave I/O Thread States”
Section 5.1.4, “Server System Variables”

`report_host`

Section 5.1.4, “Server System Variables”

`report_password`

Section 5.1.4, “Server System Variables”

`report_port`

Section 5.1.4, “Server System Variables”

`report_user`

Section 5.1.4, “Server System Variables”

`rpl_semi_sync_master_enabled`

Section 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 16.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.4, “Server System Variables”

`rpl_semi_sync_master_timeout`

Section 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.4, “Server System Variables”

`rpl_semi_sync_master_trace_level`

Section 5.1.4, “Server System Variables”

`rpl_semi_sync_master_wait_no_slave`

Section 5.1.4, “Server System Variables”

`rpl_semi_sync_master_wait_point`

Section 16.3.8, “Semisynchronous Replication”
Section 5.1.4, “Server System Variables”

`rpl_semi_sync_slave_enabled`

Section 16.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 16.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.4, “Server System Variables”

`rpl_semi_sync_slave_trace_level`

Section 5.1.4, “Server System Variables”

`rpl_stop_slave_timeout`

Section 13.4.2.6, “STOP SLAVE Syntax”
Section 16.1.4.3, “Replication Slave Options and Variables”

S

`secure_auth`

Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.4, “Server System Variables”

`secure_file_priv`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”

`server_id`

Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 12.16, “Miscellaneous Functions”
Section 20.9.9, “Performance Schema Replication Tables”
Section 5.1.4, “Server System Variables”
Section 6.3.11.3, “The Audit Log File”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

`server_uuid`

Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 13.4.2.5, “START SLAVE Syntax”
Section 16.1.3.1, “GTID Concepts”
Section 20.9.9, “Performance Schema Replication Tables”
Section 16.1.4, “Replication and Binary Logging Options and Variables”
Section 20.9.9.2, “The replication_connection_status Table”

`sha`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 6.3.7.4, “The SHA-256 Authentication Plugin”

`shared_memory`

Section 5.1.4, “Server System Variables”

`shared_memory_base_name`

Section 5.1.4, “Server System Variables”

`skip_external_locking`

Section 8.10.5, “External Locking”
Section 5.1.4, “Server System Variables”

`skip_name_resolve`

Section 5.1.4, “Server System Variables”

`skip_networking`

Section 5.1.4, “Server System Variables”

`skip_show_database`

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

`slave_allow_batching`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_checkpoint_group`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_checkpoint_period`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_compressed_protocol`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_exec_mode`

Section 16.4.1.21, “Replication and MEMORY Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

`slave_load_tmpdir`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

`slave_max_allowed_packet`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_net_timeout`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 16.1.5.1, “Checking Replication Status”
Section 16.4.1.19, “Replication and Master or Slave Shutdowns”
Section 8.12.5.5, “Replication Slave I/O Thread States”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

`slave_parallel_workers`

Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 13.4.2.5, “START SLAVE Syntax”
Section 20.9.9, “Performance Schema Replication Tables”
Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_pending_jobs_size_max`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_rows_search_algorithms`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_skip_errors`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_sql_verify_checksum`

Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.2.4, “The Binary Log”

`slave_transaction_retries`

Section 16.4.1.28, “Replication Retries and Timeouts”
Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_type_conversions`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slow_launch_time`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`slow_query_log`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`slow_query_log_file`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`socket`

Section 5.1.4, “Server System Variables”

`sort_buffer_size`

Section 8.2.1.15, “ORDER BY Optimization”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 8.2.1.19, “Optimizing LIMIT Queries”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`sql_auto_is_null`

Section 12.3.2, “Comparison Functions and Operators”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”

`sql_big_selects`

Section 5.1.4, “Server System Variables”

`sql_buffer_result`

Section 5.1.4, “Server System Variables”

`sql_log_bin`

Section 13.4.1.3, “SET sql_log_bin Syntax”
Section 5.1.4, “Server System Variables”
Section 16.4.3, “Upgrading a Replication Setup”

`sql_log_off`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 5.2.3, “The General Query Log”

`SQL_MODE`

Section 5.5.5, “Examples of Online DDL”
Section 5.5.1, “Overview of Online DDL”

`sql_mode`

Section 13.1.9, “CREATE EVENT Syntax”
Section 13.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.15, “CREATE TRIGGER Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.5.12, “SHOW CREATE VIEW Syntax”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 13.6.7.5.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 12.19.3, “Expression Handling”
Section 1.7, “How to Report Bugs or Problems”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section C.5.5.2, “Problems Using DATE Columns”
Section 16.4.1.33, “Replication and Variables”
Section 1.8.3, “Running MySQL in ANSI Mode”
Section 1.8.2, “Selecting SQL Modes”
Section 5.1.2, “Server Configuration Defaults”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 19.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 2.11.1.1, “Upgrading from MySQL 5.6 to 5.7”
Section 5.1.5, “Using System Variables”

`sql_notes`

Section 13.7.5.39, “SHOW WARNINGS Syntax”
Section 13.6.7.7.5, “Diagnostics Area-Related System Variables”
Section 5.1.4, “Server System Variables”

`sql_quote_show_create`

Section 13.7.5.6, “SHOW CREATE DATABASE Syntax”
Section 13.7.5.10, “SHOW CREATE TABLE Syntax”
Section 5.1.4, “Server System Variables”

`sql_safe_updates`

Section 5.1.4, “Server System Variables”

`sql_select_limit`

Section 5.1.4, “Server System Variables”

`sql_slave_skip_counter`

Section 13.4.2.4, “SET GLOBAL sql_slave_skip_counter Syntax”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 16.1.3.4, “Restrictions on Replication with GTIDs”

`sql_warnings`

Section 5.1.4, “Server System Variables”

`ssl_ca`

Section 5.1.4, “Server System Variables”

`ssl_capath`

Section 5.1.4, “Server System Variables”

`ssl_cert`

Section 5.1.4, “Server System Variables”

`ssl_cipher`

Section 5.1.4, “Server System Variables”

`ssl_crl`

Section 5.1.4, “Server System Variables”

`ssl_crlpath`

Section 5.1.4, “Server System Variables”

`ssl_key`

Section 5.1.4, “Server System Variables”

`storage_engine`

Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”

`stored_program_cache`

Section 8.9.4, “Caching of Prepared Statements and Stored Programs”
Section 5.1.4, “Server System Variables”

`sync_binlog`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 16.1.4.4, “Binary Log Options and Variables”
Section 14.2.8, “MySQL and the ACID Model”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 16.4.1.19, “Replication and Master or Slave Shutdowns”
Section 5.2.4, “The Binary Log”

`sync_frm`

Section 5.1.4, “Server System Variables”

`sync_master_info`

Section 16.1.4.3, “Replication Slave Options and Variables”

`sync_relay_log`

Section 16.1.4.3, “Replication Slave Options and Variables”

`sync_relay_log_info`

Section 16.4.1.19, “Replication and Master or Slave Shutdowns”
Section 16.1.4.3, “Replication Slave Options and Variables”

`system_time_zone`

Section 10.6, “MySQL Server Time Zone Support”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

T

`table_definition_cache`

Section 5.1.4, “Server System Variables”

`table_open_cache`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 8.12.5.2, “General Thread States”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 8.11.2, “Tuning Server Parameters”

`table_open_cache_instances`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`thread_cache_size`

Section 22.4.1.4, “Debugging mysqld under gdb”
Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 8.2.5, “Other Optimization Tips”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`thread_concurrency`

Section 5.1.4, “Server System Variables”

`thread_handling`

Section 5.1.4, “Server System Variables”

`thread_stack`

Section 8.11.4.1, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”
Section 18.2.1, “Stored Routine Syntax”

`time_format`

Section 5.1.4, “Server System Variables”

`time_zone`

Section 13.1.9, “CREATE EVENT Syntax”
Section 12.7, “Date and Time Functions”
Section 18.4.4, “Event Metadata”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 10.6, “MySQL Server Time Zone Support”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 11.3.1, “The DATE, DATETIME, and TIMESTAMP Types”

`timed_mutexes`

Section 13.7.5.14, “SHOW ENGINE Syntax”
Section 5.1.4, “Server System Variables”

`timestamp`

Section 14.9.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”

`tmp_table_size`

Section 8.4.3.3, “How MySQL Uses Internal Temporary Tables”
Section D.3, “Restrictions on Server-Side Cursors”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`tmpdir`

Section C.5.2.13, “Can't create/write to file”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 8.2.1.15, “ORDER BY Optimization”
Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 5.5.6, “Implementation Details of Online DDL”
Section 5.5.9, “Limitations of Online DDL”
Section 5.5.2, “Performance and Concurrency Considerations for Online DDL”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section C.5.4.4, “Where MySQL Stores Temporary Files”

`transaction_alloc_block_size`

Section 5.1.4, “Server System Variables”

`transaction_prealloc_size`

Section 5.1.4, “Server System Variables”

`tx_isolation`

Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

`tx_read_only`

Section 13.3.6, “SET TRANSACTION Syntax”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

U

`unique_checks`

Section 5.4.3, “Converting Tables from MyISAM to InnoDB”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.2.4, “The Binary Log”

`updatable_views_with_limit`

Section 5.1.4, “Server System Variables”
Section 18.5.3, “Updatable and Insertable Views”

V

`validate_password_dictionary_file`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_length`

Section 12.13, “Encryption and Compression Functions”
Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_mixed_case_count`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_number_count`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_policy`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”
Section 6.1.2.6, “The Password Validation Plugin”

`validate_password_special_char_count`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_user_plugins`

Section 5.1.4, “Server System Variables”

`version`

Section 14.2.6, “InnoDB Startup Options and System Variables”
Section 12.14, “Information Functions”
Section 5.1.4, “Server System Variables”
Section 6.3.11.3, “The Audit Log File”

`version_comment`

Section 5.1.4, “Server System Variables”

`version_compile_machine`

Section 5.1.4, “Server System Variables”

`version_compile_os`

Section 5.1.4, “Server System Variables”

W

`wait_timeout`

Section C.5.2.9, “MySQL server has gone away”
Section 21.8.7.53, “mysql_real_connect()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.4, “Server System Variables”

`warning_count`

Section 13.7.5.16, “SHOW ERRORS Syntax”
Section 13.7.5.39, “SHOW WARNINGS Syntax”
Section 13.6.7.7.5, “Diagnostics Area-Related System Variables”
Section 13.6.7.5.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 5.1.4, “Server System Variables”
Section C.1, “Sources of Error Information”
Section 13.5, “SQL Syntax for Prepared Statements”

Prev	Up	Next
Statement/Syntax Index	Home	Status Variable Index