Skip navigation links

MySQL 5.6 Reference Manual :: System Variable Index

« Statement/Syntax Index

Status Variable Index »

Section Navigation [Toggle]

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.12.4, “Audit Log Plugin Logging Control”
Section 6.3.12.5, “Audit Log Plugin Options and Variables”

`audit_log_file`

Section 6.3.12.4, “Audit Log Plugin Logging Control”
Section 6.3.12.5, “Audit Log Plugin Options and Variables”
Section 6.3.12.2, “Audit Log Plugin Security Considerations”
Section 6.3.12, “MySQL Enterprise Audit Log Plugin”

`audit_log_flush`

Section 6.3.12.4, “Audit Log Plugin Logging Control”
Section 6.3.12.5, “Audit Log Plugin Options and Variables”

`audit_log_format`

Section 6.3.12.5, “Audit Log Plugin Options and Variables”
Section 6.3.12, “MySQL Enterprise Audit Log Plugin”
Section 6.3.12.3, “The Audit Log File”

`audit_log_policy`

Section 6.3.12.4, “Audit Log Plugin Logging Control”
Section 6.3.12.5, “Audit Log Plugin Options and Variables”
Section 6.3.12, “MySQL Enterprise Audit Log Plugin”

`audit_log_rotate_on_size`

Section 6.3.12.4, “Audit Log Plugin Logging Control”
Section 6.3.12.5, “Audit Log Plugin Options and Variables”

`audit_log_strategy`

Section 6.3.12.4, “Audit Log Plugin Logging Control”
Section 6.3.12.5, “Audit Log Plugin Options and Variables”

`authentication_windows_log_level`

Section 5.1.4, “Server System Variables”
Section 6.3.8.6.2, “Using the Windows Authentication Plugin”

`authentication_windows_use_principal_name`

Section 5.1.4, “Server System Variables”
Section 6.3.8.6.2, “Using the Windows Authentication Plugin”

`auto_increment_increment`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.34, “Replication and Variables”
Section 16.1.4.2, “Replication Master Options and Variables”
Section 14.2.6.5.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.34, “Replication and Variables”
Section 16.1.4.2, “Replication Master Options and Variables”
Section 14.2.6.5.1, “Traditional InnoDB Auto-Increment Locking”
Section 3.6.9, “Using AUTO_INCREMENT”

`AUTOCOMMIT`

Section 16.4.1.31, “Replication and Transactions”

`autocommit`

Section 13.2.2, “DELETE Syntax”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 14.2.2.10, “Deadlock Detection and Rollback”
Section 14.2.11.5, “Examples of Online DDL”
Section 13.3.5.1, “Interaction of Table Locking and Transactions”
Section 14.2.6.7, “Limits on InnoDB Tables”
Section 14.2.2.5, “Locking Reads (SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE)”
Section 14.2.2.8, “Locks Set by Different SQL Statements in InnoDB”
Section 17.3.4.3, “MySQL Cluster System Variables”
Section 16.4.1.31, “Replication and Transactions”
Section 16.1.3.4, “Restrictions on Replication with GTIDs”
Section 5.1.4, “Server System Variables”
Section 8.11.6.2, “Thread Pool Operation”
Section 1.8.2.3, “Transaction and Atomic Operation Differences”

`automatic_sp_privileges`

Section 13.1.5, “ALTER PROCEDURE Syntax”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 5.1.4, “Server System Variables”
Section 19.2.2, “Stored Routines and MySQL Privileges”

B

`back_log`

Section 5.1.2.1, “Changes to Server Defaults”
Section 5.1.4, “Server System Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`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”
Section 1.4, “What Is New in MySQL 5.6”

`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.1.2.1, “Changes to Server Defaults”
Section 5.2.4, “The Binary Log”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 1.4, “What Is New in MySQL 5.6”

`binlog_direct_non_transactional_updates`

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

`binlog_format`

Section 13.2.5.2, “INSERT DELAYED Syntax”
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.31, “Replication and Transactions”
Section 16.1.2, “Replication Formats”
Section 16.4.1.23, “Replication of the mysql System Database”
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.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”
Section 14.2.16.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”
Section 1.4, “What Is New in MySQL 5.6”

`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.9, “SHOW CREATE EVENT Syntax”
Section 13.7.5.11, “SHOW CREATE PROCEDURE Syntax”
Section 13.7.5.13, “SHOW CREATE TRIGGER Syntax”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 13.7.5.19, “SHOW EVENTS Syntax”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Syntax”
Section 13.7.5.39, “SHOW TRIGGERS Syntax”
Section 22.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.34, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 20.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 20.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 20.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.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.34, “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.15, “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.34, “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 22.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.34, “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.9, “SHOW CREATE EVENT Syntax”
Section 13.7.5.11, “SHOW CREATE PROCEDURE Syntax”
Section 13.7.5.13, “SHOW CREATE TRIGGER Syntax”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 13.7.5.19, “SHOW EVENTS Syntax”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Syntax”
Section 13.7.5.39, “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.34, “Replication and Variables”
Section 10.1.9.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 20.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 20.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 20.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.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.15, “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.34, “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.34, “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 22.8.7.6, “mysql_commit()”
Section 22.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 22.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.16.3.2, “Installing and Configuring the InnoDB memcached Plugin”

`daemon_memcached_engine_lib_path`

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

`daemon_memcached_option`

Section 14.2.16.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.16.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 14.2.16.4.1, “Password-Protecting the memcached Interface through SASL”
Section 14.2.16.8, “Troubleshooting the InnoDB memcached Plugin”

`daemon_memcached_r_batch_size`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.16.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.16.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 14.2.16.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.2.16.5.3, “Tuning Performance of the InnoDB memcached Plugin”
Section 14.2.16.6, “Using the InnoDB memcached Plugin with Replication”

`daemon_memcached_w_batch_size`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.16.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.16.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.2.16.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 14.2.16.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.2.16.5.3, “Tuning Performance of the InnoDB memcached Plugin”
Section 14.2.16.6, “Using the InnoDB memcached Plugin with Replication”

`DATADIR`

Section 14.2.5.4, “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 23.4.3, “The DBUG Package”

`debug_sync`

Section 5.1.4, “Server System Variables”

`default_storage_engine`

Section 13.1.14, “CREATE LOGFILE GROUP Syntax”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 16.4.1.34, “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 18.6.3, “Partitioning Limitations Relating to Functions”
Section 5.1.4, “Server System Variables”

`delay_key_write`

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

`delayed_insert_limit`

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.4, “Server System Variables”

`delayed_insert_timeout`

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.4, “Server System Variables”

`delayed_queue_size`

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.1.4, “Server System Variables”

`disable_gtid_unsafe_statements`

Section 16.1.4.5, “Global Transaction ID Options and 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”

`enforce_gtid_consistency`

Section 16.1.4.5, “Global Transaction ID Options and Variables”

`engine_condition_pushdown`

Section 5.1.3, “Server Command Options”
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.18, “SHOW ERRORS Syntax”
Section 13.6.7.7.4, “Diagnostics Area-Related System Variables”
Section 5.1.4, “Server System Variables”
Section C.1, “Sources of Error Information”

`event_scheduler`

Section 19.4.2, “Event Scheduler Configuration”
Section 22.7.2, “Restrictions When Using the Embedded MySQL Server”
Section 5.1.4, “Server System Variables”
Section 19.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”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 1.4, “What Is New in MySQL 5.6”

`external_user`

Section 23.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 6.3.9, “Proxy Users”
Section 5.1.4, “Server System Variables”
Section 23.2.4.9.1, “Writing the Server-Side Authentication Plugin”

F

`flush`

Section 5.1.4, “Server System Variables”

`flush_time`

Section 5.1.2.1, “Changes to Server Defaults”
Section 5.1.4, “Server System Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`foreign_key_checks`

Section 14.2.5.5, “Copying Tablespaces to Another Server (Transportable Tablespaces)”
Section 14.2.11.6, “Implementation Details of Online DDL”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 14.2.12.2.33, “Online DDL”
Section 14.2.11.1, “Overview of Online DDL”
Section 16.4.1.34, “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.17.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 23.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 23.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_done`

Section 13.4.1.2, “RESET MASTER Syntax”
Section 13.7.5.24, “SHOW MASTER STATUS Syntax”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”

`gtid_executed`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 13.4.1.2, “RESET MASTER Syntax”
Section 13.7.5.24, “SHOW MASTER STATUS Syntax”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 16.1.3.1, “GTID Concepts”
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_lost`

Section 13.4.1.2, “RESET MASTER Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”

`gtid_mode`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 16.1.4.5, “Global Transaction ID Options and Variables”
Section 12.15, “GTID Functions”
Section 16.1.3.3, “Using GTIDs for Failover and Scaleout”

`gtid_next`

Section 13.1.6, “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.16, “CREATE SERVER Syntax”
Section 13.1.27, “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”

`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_csv`

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_innodb`

Section 5.1.4, “Server System Variables”

`have_ndbcluster`

Section 17.3.4.3, “MySQL Cluster System Variables”

`have_openssl`

Section 5.1.4, “Server System Variables”

`have_partitioning`

Chapter 18, Partitioning
Section 5.1.4, “Server System Variables”

`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.10.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”
Section 8.11.3.1.3, “Using Symbolic Links for Databases on Windows”

`host_cache_size`

Section 5.1.2.1, “Changes to Server Defaults”
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”
Section 1.4, “What Is New in MySQL 5.6”

`hostname`

Section 5.1.4, “Server System Variables”

I

`identity`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.34, “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 21.9.10.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.3.1, “Configuring InnoDB for Read-Only Operation”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_adaptive_flushing`

Section 14.2.12.2.21, “Controlling the Flushing Rate of Dirty Pages from the InnoDB Buffer Pool”
Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_adaptive_flushing_lwm`

Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”

`innodb_adaptive_hash_index`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.2.13.6, “Adaptive Hash Indexes”
Section 14.2.12.2.14, “Controlling Adaptive Hash Indexing”

`innodb_adaptive_max_sleep_delay`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.15, “Changes Regarding Thread Concurrency”

`innodb_additional_mem_pool_size`

Section 14.2.12.2.12, “Using Operating System Memory Allocators”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_api_bk_commit_interval`

Section 14.2.16.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.16.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

`innodb_api_disable_rowlock`

Section 14.2.16.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

`innodb_api_enable_binlog`

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

`innodb_api_enable_mdl`

Section 14.2.16.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.16.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

`innodb_api_trx_level`

Section 14.2.16.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.16.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”

`innodb_autoextend_increment`

Section 14.2.3, “InnoDB Configuration”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.5.7, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 14.2.5.2, “InnoDB File-Per-Table Mode”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`innodb_autoinc_lock_mode`

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

`innodb_buffer_pool_dump_at_shutdown`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.8, “Faster Restart by Preloading the InnoDB Buffer Pool”

`innodb_buffer_pool_dump_now`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.8, “Faster Restart by Preloading the InnoDB Buffer Pool”

`innodb_buffer_pool_filename`

Section 14.2.12.2.8, “Faster Restart by Preloading the InnoDB Buffer Pool”

`innodb_buffer_pool_instances`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 14.2.12.2.27, “Improvements to Performance from Multiple Buffer Pools”
Section 8.9.1, “The InnoDB Buffer Pool”
Section 14.2.16.5.3, “Tuning Performance of the InnoDB memcached Plugin”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`innodb_buffer_pool_load_abort`

Section 14.2.12.2.8, “Faster Restart by Preloading the InnoDB Buffer Pool”
Section 5.1.6, “Server Status Variables”

`innodb_buffer_pool_load_at_startup`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.8, “Faster Restart by Preloading the InnoDB Buffer Pool”
Section 5.1.6, “Server Status Variables”

`innodb_buffer_pool_load_now`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.8, “Faster Restart by Preloading the InnoDB Buffer Pool”
Section 5.1.6, “Server Status Variables”

`innodb_buffer_pool_size`

Section 14.2.17.5, “InnoDB Error Codes”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.16.2, “Architecture of InnoDB and memcached Integration”
Section 14.2.12.2.2, “Compression Enhancements for OLTP Workloads”
Section 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 14.2.12.2.27, “Improvements to Performance from Multiple Buffer Pools”
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.16.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 14.2.3.1, “Configuring InnoDB for Read-Only Operation”
Section 14.2.12.2.13, “Controlling InnoDB Change Buffering”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 8.5.2, “Optimizing InnoDB Transaction Management”

`innodb_checksum_algorithm`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.12.2.7, “Fast CRC32 Checksum Algorithm”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_checksums`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.7, “Fast CRC32 Checksum Algorithm”

`innodb_cmp_per_index_enabled`

Section 14.2.7.4, “Monitoring Compression at Runtime”
Section 20.30.2, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 14.2.7.3, “Tuning Compression for InnoDB Tables”

`innodb_compression_failure_threshold_pct`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.2, “Compression Enhancements for OLTP Workloads”
Section 14.2.7.5, “How Compression Works for InnoDB Tables”
Section 14.2.7.3, “Tuning Compression for InnoDB Tables”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_compression_level`

Section 14.2.12.2.2, “Compression Enhancements for OLTP Workloads”
Section 14.2.7.5, “How Compression Works for InnoDB Tables”
Section 14.2.7.3, “Tuning Compression for InnoDB Tables”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_compression_pad_pct_max`

Section 14.2.12.2.2, “Compression Enhancements for OLTP Workloads”
Section 14.2.7.5, “How Compression Works for InnoDB Tables”
Section 14.2.7.3, “Tuning Compression for InnoDB Tables”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_concurrency_tickets`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.15, “Changes Regarding Thread Concurrency”
Section 5.1.2.1, “Changes to Server Defaults”
Section 8.5.8, “Optimizing InnoDB Configuration Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`innodb_data_file_path`

Section 14.2.3, “InnoDB Configuration”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.5.7, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 14.2.17.1, “Troubleshooting InnoDB I/O Problems”
Section 14.2.5.8, “Using Raw Disk Partitions for the Shared Tablespace”

`innodb_data_home_dir`

Section 14.2.3, “InnoDB Configuration”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.17.1, “Troubleshooting InnoDB I/O Problems”

`innodb_doublewrite`

Section 14.2.2.1, “MySQL and the ACID Model”
Section 14.2.16.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_fast_shutdown`

Section 14.2.5.7, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 14.2.8.2.1, “Compatibility Check When InnoDB Is Started”
Section 14.2.14.1, “The InnoDB Recovery Process”
Section 5.1.12, “The Shutdown Process”
Section 2.10.1, “Upgrading MySQL”

`innodb_file_format`

Section 13.1.17, “CREATE TABLE Syntax”
Section 14.2.9.3, “DYNAMIC and COMPRESSED Row Formats”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.8.2.1, “Compatibility Check When InnoDB Is Started”
Section 14.2.8.2.2, “Compatibility Check When a Table Is Opened”
Section 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 14.2.7.2, “Enabling Compression for a Table”
Section 14.2.8.1, “Enabling File Formats”
Section 14.2.8.3, “Identifying the File Format in Use”
Section 14.2.9.1, “Overview of InnoDB Row Storage”
Section 14.2.7.6, “SQL Compression Syntax Warnings and Errors”

`innodb_file_format_check`

Section 14.2.8.2.1, “Compatibility Check When InnoDB Is Started”
Section 14.2.8.2.2, “Compatibility Check When a Table Is Opened”

`innodb_file_format_max`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_file_per_table`

Section 13.1.17, “CREATE TABLE Syntax”
Section 13.7.6.3, “FLUSH Syntax”
Section 14.2.15, “InnoDB and MySQL Replication”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.4.4, “InnoDB Tablespace Monitor Output”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 14.2.5.5, “Copying Tablespaces to Another Server (Transportable Tablespaces)”
Section 14.2.6.1, “Creating InnoDB Tables”
Section 14.2.5.1, “Creating the InnoDB Tablespace”
Section 14.2.5.3, “Enabling and Disabling File-Per-Table Mode”
Section 14.2.7.2, “Enabling Compression for a Table”
Section 14.2.8.1, “Enabling File Formats”
Section 14.2.11.6, “Implementation Details of Online DDL”
Section 14.2.5.2, “InnoDB File-Per-Table Mode”
Section 14.2.1, “Introduction to InnoDB”
Section 14.2.6.2, “Moving or Copying InnoDB Tables to Another Machine”
Section 14.2.2.1, “MySQL and the ACID Model”
Section 14.2.9.1, “Overview of InnoDB Row Storage”
Section 14.2.2.13.7, “Physical Row Structure”
Section 14.2.10.5, “Reclaiming Disk Space with TRUNCATE TABLE”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 18.6, “Restrictions and Limitations on Partitioning”
Section 14.2.7.6, “SQL Compression Syntax Warnings and Errors”
Section 14.2.17.3, “Troubleshooting InnoDB Data Dictionary Operations”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`innodb_flush_log_at_timeout`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_flush_log_at_trx_commit`

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

`innodb_flush_method`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.5.2, “InnoDB File-Per-Table Mode”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 5.1.6, “Server Status Variables”
Section 14.2.16.5.3, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_flush_neighbors`

Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_flushing_avg_loops`

Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”

`innodb_force_load_corrupted`

Section 14.2.13, “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.17.2, “Starting InnoDB on a Corrupted Database”
Section 14.2.14.1, “The InnoDB Recovery Process”

`innodb_ft_aux_table`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 20.30.25, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 20.30.24, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 20.30.23, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 20.30.22, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

`innodb_ft_cache_size`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_ft_enable_diag_print`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_ft_enable_stopword`

Section 14.2.13, “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.13, “InnoDB Startup Options and System Variables”
Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”

`innodb_ft_min_token_size`

Section 14.2.13, “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.1, “Natural Language Full-Text Searches”

`innodb_ft_num_word_optimize`

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

`innodb_ft_result_cache_limit`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_ft_server_stopword_table`

Section 14.2.13, “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 20.30.21, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

`innodb_ft_sort_pll_degree`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_ft_total_cache_size`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_ft_user_stopword_table`

Section 14.2.13, “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 20.30.21, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”

`innodb_io_capacity`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.20, “Controlling the InnoDB Master Thread I/O Rate”
Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_io_capacity_max`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”

`innodb_large_prefix`

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

`innodb_lock_wait_timeout`

Section 14.2.17.5, “InnoDB Error Codes”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.2.10, “Deadlock Detection and Rollback”
Section 16.4.1.29, “Replication Retries and Timeouts”
Section 16.1.4.3, “Replication Slave Options and Variables”

`innodb_locks_unsafe_for_binlog`

Section 14.2.2.6, “InnoDB Record, Gap, and Next-Key Locks”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 14.2.2.4, “Consistent Nonlocking Reads”
Section 14.2.2.8, “Locks Set by Different SQL Statements in InnoDB”

`innodb_log_buffer_size`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_log_compressed_pages`

Section 1.4, “What Is New in MySQL 5.6”

`innodb_log_file_size`

Section 14.2.3, “InnoDB Configuration”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.5.7, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 14.2.3.1, “Configuring InnoDB for Read-Only Operation”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_log_files_in_group`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.5.7, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_log_group_home_dir`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_lru_scan_depth`

Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_max_dirty_pages_pct`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.21, “Controlling the Flushing Rate of Dirty Pages from the InnoDB Buffer Pool”
Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_max_dirty_pages_pct_lwm`

Section 14.2.12.2.9, “Improvements to Buffer Pool Flushing”

`innodb_max_purge_lag`

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

`innodb_max_purge_lag_delay`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_monitor_disable`

Section 20.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_enable`

Section 20.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_reset`

Section 20.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_reset_all`

Section 20.30.19, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_old_blocks_pct`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.24, “Making the Buffer Pool Scan Resistant”
Section 8.9.1, “The InnoDB Buffer Pool”

`innodb_old_blocks_time`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.12.2.24, “Making the Buffer Pool Scan Resistant”
Section 8.9.1, “The InnoDB Buffer Pool”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`innodb_online_alter_log_max_size`

Section 14.2.11.6, “Implementation Details of Online DDL”

`innodb_open_files`

Section 5.1.2.1, “Changes to Server Defaults”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 5.1.4, “Server System Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`innodb_optimize_fulltext_only`

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

`innodb_page_size`

Section 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 2.10.2.1, “Downgrading to MySQL 5.5”
Section 14.2.10.2, “File Space Management”
Section 14.2.7.5, “How Compression Works for InnoDB Tables”
Section 14.2.6.7, “Limits on InnoDB Tables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.2.2.13.4, “Physical Structure of an InnoDB Index”
Section 14.2.16.8, “Troubleshooting the InnoDB memcached Plugin”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_print_all_deadlocks`

Section 14.2.17, “InnoDB Troubleshooting”
Section 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 14.2.2.11, “How to Cope with Deadlocks”

`innodb_purge_batch_size`

Section 14.2.12.2.29, “Better Scalability with Improved Purge Scheduling”

`innodb_purge_threads`

Section 14.2.12.2.29, “Better Scalability with Improved Purge Scheduling”
Section 14.2.12.2.20, “Controlling the InnoDB Master Thread I/O Rate”

`innodb_random_read_ahead`

Section 14.2.12.2.16, “Changes in the Read-Ahead Algorithm”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_read_ahead_threshold`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.16, “Changes in the Read-Ahead Algorithm”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_read_io_threads`

Section 14.2.12.4.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.17, “Multiple Background InnoDB I/O Threads”
Section 23.1.1, “MySQL Threads”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_rollback_segments`

Section 14.2.12.2.28, “Better Scalability with Multiple Rollback Segments”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_sort_buffer_size`

Section 14.2.13, “InnoDB Startup Options and System Variables”

`innodb_spin_wait_delay`

Section 14.2.12.2.23, “Control of Spin Lock Polling”

`innodb_stats_auto_recalc`

Section 13.1.17, “CREATE TABLE Syntax”
Section 14.2.12.2.10, “Persistent Optimizer Statistics for InnoDB Tables”

`innodb_stats_method`

Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”

`innodb_stats_on_metadata`

Section 5.1.2.1, “Changes to Server Defaults”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`innodb_stats_persistent`

Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 13.1.13, “CREATE INDEX Syntax”
Section 13.1.17, “CREATE TABLE Syntax”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.6.7, “Limits on InnoDB Tables”
Section 14.2.12.2.10, “Persistent Optimizer Statistics for InnoDB Tables”

`innodb_stats_persistent_sample_pages`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.6.7, “Limits on InnoDB Tables”
Section 14.2.12.2.10, “Persistent Optimizer Statistics for InnoDB Tables”

`innodb_stats_transient_sample_pages`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.5, “Controlling Optimizer Statistics Estimation”
Section 14.2.6.7, “Limits on InnoDB Tables”
Section 14.2.12.2.10, “Persistent Optimizer Statistics for InnoDB Tables”

`innodb_status_output`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.4.2, “Enabling InnoDB Monitors”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_status_output_locks`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.4.2, “Enabling InnoDB Monitors”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_strict_mode`

Section 13.1.13, “CREATE INDEX Syntax”
Section 13.1.17, “CREATE TABLE Syntax”
Section 14.2.7.5, “How Compression Works for InnoDB Tables”
Section 5.1.7, “Server SQL Modes”
Section 14.2.7.6, “SQL Compression Syntax Warnings and Errors”

`innodb_support_xa`

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

`innodb_table_locks`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.6.7, “Limits on InnoDB Tables”

`innodb_thread_concurrency`

Section 14.2.12.4.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.15, “Changes Regarding Thread Concurrency”
Section 8.5.8, “Optimizing InnoDB Configuration Variables”

`innodb_thread_sleep_delay`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.15, “Changes Regarding Thread Concurrency”

`innodb_undo_directory`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.3.1, “Configuring InnoDB for Read-Only Operation”
Section 14.2.12.2.4, “Separate Tablespaces for InnoDB Undo Logs”

`innodb_undo_logs`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.4, “Separate Tablespaces for InnoDB Undo Logs”
Section 5.1.6, “Server Status Variables”

`innodb_undo_tablespaces`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.3.1, “Configuring InnoDB for Read-Only Operation”
Section 14.2.12.2.4, “Separate Tablespaces for InnoDB Undo Logs”

`innodb_use_native_aio`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.18, “Asynchronous I/O on Linux”

`innodb_use_sys_malloc`

Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.12, “Using Operating System Memory Allocators”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_write_io_threads`

Section 14.2.12.4.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 14.2.12.2.17, “Multiple Background InnoDB I/O Threads”
Section 23.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 22.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.14.3, “Batched Key Access Joins”
Section 5.1.2.1, “Changes to Server Defaults”
Section 8.2.1.10, “Nested-Loop Join Algorithms”
Section 5.1.4, “Server System Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

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 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 8.8.4, “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 18.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.34, “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.34, “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.8.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 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.2.16.6, “Using the InnoDB memcached Plugin with Replication”

`log_bin`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 17.3.4.3, “MySQL Cluster System Variables”
Section 1.4, “What Is New in MySQL 5.6”

`log_bin_basename`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 1.4, “What Is New in MySQL 5.6”

`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 19.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”
Section 5.2.5, “The Slow Query Log”

`log_slow_queries`

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”
Section 5.2.5, “The Slow Query Log”

`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”
Section 1.4, “What Is New in MySQL 5.6”

`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.38, “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.34, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 20.30.9, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
Section 20.30.7, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
Section 13.1.17.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 22.8.11.26, “mysql_stmt_send_long_data()”
Section 22.8.7.72, “mysql_use_result()”
Section 5.1.2.1, “Changes to Server Defaults”
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 22.8, “MySQL C API”
Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
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 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 4.2.3.3, “Using Option Files”
Section 1.4, “What Is New in MySQL 5.6”

`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 5.1.2.1, “Changes to Server Defaults”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section 5.1.4, “Server System Variables”
Section 21.9.10.1, “The host_cache Table”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 1.4, “What Is New in MySQL 5.6”

`max_connections`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section C.5.2.7, “Too many connections”
Section 5.1.2.1, “Changes to Server Defaults”
Section 23.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 21.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”
Section 8.11.6.2, “Thread Pool Operation”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`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.18, “SHOW ERRORS Syntax”
Section 13.7.5.41, “SHOW WARNINGS Syntax”
Section 13.6.7.7.4, “Diagnostics Area-Related System Variables”
Section 5.1.4, “Server System Variables”

`max_heap_table_size`

Section 8.4.4, “How MySQL Uses Internal Temporary Tables”
Section E.10.3, “Limits on Table Size”
Section 16.4.1.21, “Replication and MEMORY Tables”
Section 16.4.1.34, “Replication and Variables”
Section E.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”
Section 1.4, “What Is New in MySQL 5.6”

`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.6.7, “Limits on InnoDB Tables”
Section 5.1.4, “Server System Variables”

`max_sort_length`

Section 13.1.17, “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 19.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.17, “CREATE TABLE Syntax”
Section E.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 18.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 4.6.3.1, “myisamchk General Options”
Section 13.1.7, “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”

`ndb_autoincrement_prefetch_sz`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_cache_check_time`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_deferred_constraints`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_distribution`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_extra_logging`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_force_send`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_join_pushdown`

Section 8.8.2, “EXPLAIN Output Format”
Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_apply_status`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_bin`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_binlog_index`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_empty_epochs`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_transaction_id`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_optimized_node_selection`

Section 17.3.4.3, “MySQL Cluster System Variables”
Section 17.5.6.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”

`ndb_recv_thread_activation_threshold`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_recv_thread_cpu_mask`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_report_thresh_binlog_epoch_slip`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_report_thresh_binlog_mem_usage`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_table_no_logging`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_table_temporary`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_use_copying_alter_table`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_use_exact_count`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_use_transactions`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndbinfo_database`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndbinfo_max_bytes`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndbinfo_max_rows`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndbinfo_offline`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndbinfo_show_hidden`

Section 17.3.4.3, “MySQL Cluster System Variables”
Section 17.5.10.4, “The ndbinfo cluster_operations Table”
Section 17.5.10.5, “The ndbinfo cluster_transactions Table”
Section 17.5.10.15, “The ndbinfo server_operations Table”
Section 17.5.10.16, “The ndbinfo server_transactions Table”

`ndbinfo_table_prefix`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndbinfo_version`

Section 17.3.4.3, “MySQL Cluster System Variables”

`net_buffer_length`

Section 4.5.4, “mysqldump — A Database Backup Program”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 22.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.7, “ALTER TABLE Syntax”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 14.2.11.2, “Performance and Concurrency Considerations for Online DDL”
Section 5.1.4, “Server System Variables”
Section 14.2.11.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.2, “CREATE USER Syntax”
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 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.8.4, “The SHA-256 Authentication Plugin”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`open_files_limit`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”
Section 18.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”
Section 5.1.4, “Server System Variables”

`optimizer_prune_level`

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

`optimizer_search_depth`

Section 8.8.5.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.5.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”
Section 1.4, “What Is New in MySQL 5.6”

`optimizer_trace`

Section 5.1.4, “Server System Variables”
Section 20.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 5.1.2.1, “Changes to Server Defaults”
Section 21.1, “Performance Schema Quick Start”
Section 21.2.2, “Performance Schema Startup Configuration”
Section 21.12, “Performance Schema System Variables”

`performance_schema_accounts_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.7.1, “The accounts Table”

`performance_schema_digests_size`

Section 21.7, “Performance Schema Statement Digests”
Section 21.13, “Performance Schema Status Variables”
Section 21.12, “Performance Schema System Variables”
Section 21.9.9.3, “Statement Summary Tables”

`performance_schema_events_stages_history_long_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.5.3, “The events_stages_history_long Table”

`performance_schema_events_stages_history_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.5.2, “The events_stages_history Table”

`performance_schema_events_statements_history_long_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.6.3, “The events_statements_history_long Table”

`performance_schema_events_statements_history_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.6.2, “The events_statements_history Table”

`performance_schema_events_waits_history_long_size`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”
Section 21.9, “Performance Schema Table Descriptions”
Section 21.9.4.3, “The events_waits_history_long Table”

`performance_schema_events_waits_history_size`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”
Section 21.9, “Performance Schema Table Descriptions”
Section 21.9.4.2, “The events_waits_history Table”

`performance_schema_hosts_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.7.2, “The hosts Table”

`performance_schema_max_cond_classes`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_cond_instances`

Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”

`performance_schema_max_file_classes`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_file_handles`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_file_instances`

Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”

`performance_schema_max_mutex_classes`

Section 21.5, “Performance Schema Status Monitoring”
Section 21.12, “Performance Schema System Variables”

`performance_schema_max_mutex_instances`

Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”

`performance_schema_max_rwlock_classes`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_rwlock_instances`

Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”

`performance_schema_max_socket_classes`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_socket_instances`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_stage_classes`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_statement_classes`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_table_handles`

Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”

`performance_schema_max_table_instances`

Section 5.1.2.1, “Changes to Server Defaults”
Section 21.12, “Performance Schema System Variables”

`performance_schema_max_thread_classes`

Section 21.12, “Performance Schema System Variables”

`performance_schema_max_thread_instances`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 5.1.2.1, “Changes to Server Defaults”
Section 21.13, “Performance Schema Status Variables”
Section 21.12, “Performance Schema System Variables”

`performance_schema_session_connect_attrs_size`

Section 21.12, “Performance Schema System Variables”

`performance_schema_setup_actors_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.2.1, “The setup_actors Table”

`performance_schema_setup_objects_size`

Section 21.12, “Performance Schema System Variables”
Section 21.9.2.4, “The setup_objects Table”

`performance_schema_users_size`

Section 21.12, “Performance Schema System Variables”
Section 21.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.26, “SHOW PLUGINS Syntax”
Section 6.1.2.2, “Administrator Guidelines for Password Security”
Section 23.2.4.3, “Compiling and Installing Plugin Libraries”
Section 23.3.2.5, “Compiling and Installing User-Defined Functions”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 6.3.12.1, “Installing the Audit Log Plugin”
Section 6.3.8.5.1, “Installing the PAM Authentication Plugin”
Section 6.3.8.6.1, “Installing the Windows Authentication Plugin”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 6.3.7, “Pluggable Authentication”
Section 14.12.1, “Pluggable Storage Engine Architecture”
Section 23.2.2, “Plugin API Components”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section E.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 20.15, “The INFORMATION_SCHEMA PLUGINS Table”
Section 6.3.8.5, “The PAM Authentication Plugin”
Section 6.3.8.8, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.8.9, “The Test Authentication Plugin”
Section 6.3.8.6, “The Windows Native Authentication Plugin”
Section 8.11.6.1, “Thread Pool Components and Installation”
Section 23.3.2.6, “User-Defined Function Security Precautions”
Section 23.2.4.9.3, “Using the Authentication Plugins”
Section 23.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 23.2.4.8, “Writing Audit Plugins”
Section 23.2.4.5, “Writing Daemon Plugins”
Section 23.2.4.4, “Writing Full-Text Parser Plugins”
Section 23.2.4.10, “Writing Password-Validation Plugins”
Section 23.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.31, “SHOW PROFILE Syntax”
Section 5.1.4, “Server System Variables”
Section 20.17, “The INFORMATION_SCHEMA PROFILING Table”

`profiling_history_size`

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

`protocol_version`

Section 5.1.4, “Server System Variables”

`proxy_user`

Section 6.3.9, “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.34, “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 5.1.2.1, “Changes to Server Defaults”
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 5.1.2.1, “Changes to Server Defaults”
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.34, “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”
Section 1.4, “What Is New in MySQL 5.6”

`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 13.7.5.35, “SHOW SLAVE STATUS 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.6, “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_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 5.1.2.1, “Changes to Server Defaults”
Section 6.3.8.3, “Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.4, “Server System Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 1.4, “What Is New in MySQL 5.6”

`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.35, “SHOW SLAVE STATUS Syntax”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 12.16, “Miscellaneous Functions”
Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 17.3.4.3, “MySQL Cluster System Variables”
Section 17.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 5.1.4, “Server System Variables”
Section 6.3.12.3, “The Audit Log File”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

`server_id_bits`

Section 17.3.4.3, “MySQL Cluster System Variables”
Section 17.3.4.2, “MySQL Server Options for MySQL Cluster”

`server_uuid`

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 13.4.2.5, “START SLAVE Syntax”
Section 16.1.3.1, “GTID Concepts”
Section 16.1.4, “Replication and Binary Logging Options and Variables”

`sha`

Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 6.3.8.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”
Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”

`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 17.6.3, “Known Issues in MySQL Cluster Replication”
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.6, “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.35, “SHOW SLAVE STATUS Syntax”
Section 13.4.2.5, “START SLAVE Syntax”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.6”

`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.29, “Replication Retries and Timeouts”
Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_type_conversions`

Section 17.6.3, “Known Issues in MySQL Cluster Replication”
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”
Section 1.4, “What Is New in MySQL 5.6”

`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.34, “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 16.1.4.4, “Binary Log Options and Variables”
Section 17.1.6.8, “Issues Exclusive to MySQL Cluster”
Section 17.6.3, “Known Issues in MySQL Cluster Replication”
Section 17.1.6.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 16.1.4.1, “Replication and Binary Logging Option and Variable Reference”
Section 5.1.4, “Server System Variables”
Section 16.4.3, “Upgrading a Replication Setup”

`sql_log_off`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 16.1.4.1, “Replication and Binary Logging Option and Variable Reference”
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 14.2.11.5, “Examples of Online DDL”
Section 14.2.11.1, “Overview of Online DDL”

`sql_mode`

Section 13.1.11, “CREATE EVENT Syntax”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.19, “CREATE TRIGGER Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 5.1.2.1, “Changes to Server Defaults”
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 1.8, “MySQL Standards Compliance”
Section C.5.5.2, “Problems Using DATE Columns”
Section 16.4.1.34, “Replication and Variables”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 20.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 5.1.2.2, “Using a Sample Default Server Configuration File”
Section 5.1.5, “Using System Variables”

`sql_notes`

Section 13.7.5.41, “SHOW WARNINGS Syntax”
Section 13.6.7.7.4, “Diagnostics Area-Related System Variables”
Section 5.1.4, “Server System Variables”

`sql_quote_show_create`

Section 13.7.5.8, “SHOW CREATE DATABASE Syntax”
Section 13.7.5.12, “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.35, “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 13.1.14, “CREATE LOGFILE GROUP Syntax”
Section 16.4.1.34, “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.13, “InnoDB Startup Options and System Variables”
Section 16.1.4.4, “Binary Log Options and Variables”
Section 14.2.2.1, “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 5.1.2.1, “Changes to Server Defaults”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`sync_relay_log`

Section 5.1.2.1, “Changes to Server Defaults”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`sync_relay_log_info`

Section 5.1.2.1, “Changes to Server Defaults”
Section 16.4.1.19, “Replication and Master or Slave Shutdowns”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”

`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.2.1, “Changes to Server Defaults”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

`table_open_cache`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 14.2.13, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
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”
Section 2.10.1.2, “Upgrading from MySQL 5.5 to 5.6”
Section 1.4, “What Is New in MySQL 5.6”

`table_open_cache_instances`

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

`thread_cache_size`

Section 5.1.2.1, “Changes to Server Defaults”
Section 23.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”
Section 8.11.6.1, “Thread Pool Components and Installation”

`thread_pool_algorithm`

Section 5.1.4, “Server System Variables”
Section 20.31.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 8.11.6.1, “Thread Pool Components and Installation”

`thread_pool_high_priority_connection`

Section 5.1.4, “Server System Variables”
Section 8.11.6.1, “Thread Pool Components and Installation”
Section 8.11.6.2, “Thread Pool Operation”

`thread_pool_max_unused_threads`

Section 5.1.4, “Server System Variables”
Section 8.11.6.1, “Thread Pool Components and Installation”

`thread_pool_prio_kickup_timer`

Section 5.1.4, “Server System Variables”
Section 20.31.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 20.31.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 8.11.6.1, “Thread Pool Components and Installation”
Section 8.11.6.2, “Thread Pool Operation”
Section 8.11.6.3, “Thread Pool Tuning”

`thread_pool_size`

Section 5.1.4, “Server System Variables”
Section 8.11.6.1, “Thread Pool Components and Installation”
Section 8.11.6.2, “Thread Pool Operation”
Section 8.11.6.3, “Thread Pool Tuning”

`thread_pool_stall_limit`

Section 5.1.4, “Server System Variables”
Section 20.31.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 20.31.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 8.11.6.1, “Thread Pool Components and Installation”
Section 8.11.6.2, “Thread Pool Operation”
Section 8.11.6.3, “Thread Pool Tuning”

`thread_stack`

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

`time_format`

Section 5.1.4, “Server System Variables”

`time_zone`

Section 13.1.11, “CREATE EVENT Syntax”
Section 12.7, “Date and Time Functions”
Section 19.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.34, “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 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

`timestamp`

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

`tmp_table_size`

Section 8.4.4, “How MySQL Uses Internal Temporary Tables”
Section E.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 14.2.11.6, “Implementation Details of Online DDL”
Section 14.2.11.9, “Limitations of Online DDL”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 14.2.11.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_allow_batching`

Section 17.3.4.3, “MySQL Cluster 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 14.2.6.4, “Converting Tables from MyISAM to InnoDB”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.34, “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 19.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.13, “InnoDB Startup Options and System Variables”
Section 12.14, “Information Functions”
Section 5.1.4, “Server System Variables”
Section 6.3.12.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 22.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.18, “SHOW ERRORS Syntax”
Section 13.7.5.41, “SHOW WARNINGS Syntax”
Section 13.6.7.7.4, “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”

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

© 2014, Oracle Corporation and/or its affiliates