System Variable Index
Prev		Next

System Variable Index

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W

A

`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.2.4.1, “Traditional InnoDB Auto-Increment Locking”
Section 3.6.9, “Using AUTO_INCREMENT”

`auto_increment_offset`

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

`AUTOCOMMIT`

Section 16.4.1.30, “Replication and Transactions”

`autocommit`

Section 13.2.2, “DELETE Syntax”
Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 14.2.4.9, “Deadlock Detection and Rollback”
Section 13.3.5.1, “Interaction of Table Locking and Transactions”
Section 14.2.8, “Limits on InnoDB Tables”
Section 14.2.4.4, “Locking Reads (SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE)”
Section 14.2.4.7, “Locks Set by Different SQL Statements in InnoDB”
Section 16.4.1.30, “Replication and Transactions”
Section 5.1.4, “Server System Variables”
Section 1.8.5.3, “Transaction and Atomic Operation Differences”

`automatic_sp_privileges`

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

B

`back_log`

Section 5.1.2.1, “Changes to Server Defaults”
Section 5.1.4, “Server System Variables”
Section 2.11.1.1, “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.11.1.1, “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.30, “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.15, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.21, “Replication and MEMORY Tables”
Section 16.4.1.30, “Replication and Transactions”
Section 16.1.2, “Replication Formats”
Section 16.4.1.23, “Replication of the mysql System Database”
Section 16.1.3.3, “Restrictions on Replication with GTIDs”
Section 5.1.3, “Server Command Options”
Section 5.2.4.2, “Setting The Binary Log Format”
Section 14.7, “The BLACKHOLE Storage Engine”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”
Section 14.2.10.4, “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.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 21.9.5.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 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”

`character_set_connection`

Section 10.1.9.2, “CONVERT() and CAST()”
Section 13.7.4, “SET Syntax”
Section 10.1.3.5, “Character String Literal Character Set and Collation”
Section 10.1.7.5, “Collation of Expressions”
Section 10.1.4, “Connection Character Sets and Collations”
Section 12.7, “Date and Time Functions”
Section 12.13, “Encryption and Compression Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 10.7, “MySQL Server Locale Support”
Section 16.4.1.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.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.4, “SET Syntax”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.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 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.2, “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.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 19.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 12.2, “Type Conversion in Expression Evaluation”

`collation_database`

Section 13.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 10.1.4, “Connection Character Sets and Collations”
Section 10.1.3.2, “Database Character Set and Collation”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.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.2, “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 21.9.3.6, “mysql_commit()”
Section 21.9.3.58, “mysql_rollback()”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.1.4, “Server System Variables”

`concurrent_insert`

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

`connect_timeout`

Section C.5.2.3, “Lost connection to MySQL server”
Section 21.9.3.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.10.3, “Getting Started with InnoDB Memcached Daemon Plugin”

`daemon_memcached_engine_lib_path`

Section 14.2.10.3, “Getting Started with InnoDB Memcached Daemon Plugin”

`daemon_memcached_option`

Section 14.2.10.3, “Getting Started with InnoDB Memcached Daemon Plugin”
Section 14.2.10.2, “Introduction to InnoDB and memcached Integration”
Section 14.2.10.5.1, “SASL Support”
Section 14.2.10.14, “Troubleshooting the InnoDB memcached Plugin”

`daemon_memcached_r_batch_size`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.10.3, “Getting Started with InnoDB Memcached Daemon Plugin”
Section 14.2.10.2, “Introduction to InnoDB and memcached Integration”
Section 14.2.10.11, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.2.10.8, “Tuning Performance of the InnoDB memcached Plugin”
Section 14.2.10.4, “Using the InnoDB memcached Plugin with Replication”

`daemon_memcached_w_batch_size`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.10.9, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.2.10.3, “Getting Started with InnoDB Memcached Daemon Plugin”
Section 14.2.10.2, “Introduction to InnoDB and memcached Integration”
Section 14.2.10.11, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.2.10.8, “Tuning Performance of the InnoDB memcached Plugin”
Section 14.2.10.4, “Using the InnoDB memcached Plugin with Replication”

`DATADIR`

Section 14.2.2.1.2, “Specifying the Location of a Tablespace”

`datadir`

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

`date_format`

Section 5.1.4, “Server System Variables”

`datetime_format`

Section 5.1.4, “Server System Variables”

`debug`

Section 5.1.4, “Server System Variables”

`debug_sync`

Section 5.1.4, “Server System Variables”

`default_storage_engine`

Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 16.4.1.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 17.6.3, “Partitioning Limitations Relating to Functions”
Section 5.1.4, “Server System Variables”

`delay_key_write`

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

`delayed_insert_limit`

Section 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”

`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.13.1.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 18.4.2, “Event Scheduler Configuration”
Section 21.8.2, “Restrictions When Using the Embedded MySQL Server”
Section 5.1.4, “Server System Variables”
Section 18.4.6, “The Event Scheduler and MySQL Privileges”

`expire_logs_days`

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

`explicit_defaults_for_timestamp`

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 11.5, “Data Type Default Values”
Section 11.1.2, “Date and Time Type Overview”
Section 5.1.4, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”
Section 1.4, “What Is New in MySQL 5.6”

`external_user`

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

F

`flush`

Section 5.1.4, “Server System Variables”

`flush_time`

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

`foreign_key_checks`

Section 14.2.2.5, “FOREIGN KEY Constraints”
Section 5.2.4.3, “Mixed Binary Logging Format”
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”

`ft_boolean_syntax`

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

`ft_max_word_len`

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

`ft_min_word_len`

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

`ft_query_expansion_limit`

Section 5.1.4, “Server System Variables”

`ft_stopword_file`

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

G

`general_log`

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

`general_log_file`

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

`group_concat_max_len`

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

`gtid_executed`

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

`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, “Miscellaneous Functions”

`gtid_next`

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”

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

Section 5.1.4, “Server System Variables”

`have_partitioning`

Chapter 17, 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.8.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 20.9.9.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.6.1, “Support for Read-Only Media”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_adaptive_flushing`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_adaptive_hash_index`

Section 14.2.4.12.6, “Adaptive Hash Indexes”
Section 14.2.6.5.4, “Dynamically Changing innodb_adaptive_hash_index”

`innodb_adaptive_max_sleep_delay`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_api_bk_commit_interval`

Section 14.2.10.2, “Introduction to InnoDB and memcached Integration”

`innodb_api_enable_binlog`

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

`innodb_api_enable_mdl`

Section 14.2.10.9, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.2.10.2, “Introduction to InnoDB and memcached Integration”

`innodb_api_trx_level`

Section 14.2.10.9, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.2.10.2, “Introduction to InnoDB and memcached Integration”

`innodb_autoextend_increment`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.3.2, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.1.2, “Configuring InnoDB”
Section 2.11.1.1, “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.2.4.2, “Configurable InnoDB Auto-Increment Locking”

`innodb_buffer_pool_dump_at_shutdown`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_buffer_pool_dump_now`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_buffer_pool_instances`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 8.9.1, “The InnoDB Buffer Pool”
Section 14.2.10.8, “Tuning Performance of the InnoDB memcached Plugin”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

`innodb_buffer_pool_load_abort`

Section 5.1.6, “Server Status Variables”

`innodb_buffer_pool_load_at_startup`

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

`innodb_buffer_pool_load_now`

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

`innodb_buffer_pool_size`

Section 14.2.4.14.1, “InnoDB Error Codes”
Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.10.2, “Introduction to InnoDB and memcached Integration”
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.10.8, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_change_buffer_max_size`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_change_buffering`

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

`innodb_checksum_algorithm`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

`innodb_checksums`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_concurrency_tickets`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 8.5.8, “Optimizing InnoDB Configuration Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

`innodb_data_file_path`

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

`innodb_data_home_dir`

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

`innodb_doublewrite`

Section 14.2.9, “MySQL and the ACID Model”
Section 14.2.10.8, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_fast_shutdown`

Section 14.2.3.2, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 5.1.12, “The Shutdown Process”

`innodb_file_format`

Section 13.1.14, “CREATE TABLE Syntax”
Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.2.3, “Converting Tables from Other Storage Engines to InnoDB”
Section 14.2.6.5.1, “Dynamically Changing innodb_file_per_table”
Section 14.2.6.4, “The Barracuda File Format”

`innodb_file_format_check`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_file_format_max`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_file_per_table`

Section 13.1.14, “CREATE TABLE Syntax”
Section 13.7.6.3, “FLUSH Syntax”
Section 14.2.3.6, “InnoDB and MySQL Replication”
Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.5.4.2, “InnoDB Tablespace Monitor Output”
Section 14.2.6.6, “TRUNCATE TABLE Reclaims Space”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.2.3, “Converting Tables from Other Storage Engines to InnoDB”
Section 14.2.3.1, “Creating the InnoDB Tablespace”
Section 14.2.6.5.1, “Dynamically Changing innodb_file_per_table”
Section 14.2.2.1.1, “Enabling and Disabling File-Per-Table Mode”
Section 14.2.2.1, “Managing InnoDB Tablespaces”
Section 14.2.9, “MySQL and the ACID Model”
Section 14.2.4.12.7, “Physical Row Structure”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 17.6, “Restrictions and Limitations on Partitioning”
Section 14.2, “The InnoDB Storage Engine”
Section 14.2.5.7, “Troubleshooting InnoDB Data Dictionary Operations”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

`innodb_flush_log_at_timeout`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_flush_log_at_trx_commit`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 14.2.9, “MySQL and the ACID Model”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 14.2.10.8, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_flush_method`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 5.1.6, “Server Status Variables”
Section 14.2.10.8, “Tuning Performance of the InnoDB memcached Plugin”

`innodb_flush_neighbors`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_force_load_corrupted`

Section 14.2.7, “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.5.6, “Starting InnoDB on a Corrupted Database”

`innodb_ft_aux_table`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 19.30.24, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 19.30.18, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 19.30.23, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 19.30.21, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 19.30.20, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”
Section 19.30.22, “The INFORMATION_SCHEMA INNODB_FT_INSERTED Table”

`innodb_ft_cache_size`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_ft_enable_stopword`

Section 14.2.7, “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.7, “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.7, “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.4.12.3, “FULLTEXT Indexes”
Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”

`innodb_ft_server_stopword_table`

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

`innodb_ft_sort_pll_degree`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_ft_user_stopword_table`

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

`innodb_io_capacity`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_large_prefix`

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

`innodb_lock_wait_timeout`

Section 14.2.4.9, “Deadlock Detection and Rollback”
Section 14.2.6.5.3, “Dynamically Changing innodb_lock_wait_timeout”
Section 16.4.1.28, “Replication Retries and Timeouts”
Section 16.1.4.3, “Replication Slave Options and Variables”

`innodb_locks_unsafe_for_binlog`

Section 14.2.4.5, “InnoDB Record, Gap, and Next-Key Locks”
Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 14.2.4.3, “Consistent Nonlocking Reads”
Section 14.2.4.7, “Locks Set by Different SQL Statements in InnoDB”

`innodb_log_buffer_size`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_log_file_size`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.2.6.1, “Support for Read-Only Media”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_log_files_in_group`

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

`innodb_log_group_home_dir`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_lru_scan_depth`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_max_dirty_pages_pct`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_max_purge_lag`

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

`innodb_max_purge_lag_delay`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_monitor_disable`

Section 19.30.17, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_enable`

Section 19.30.17, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_reset`

Section 19.30.17, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_monitor_reset_all`

Section 19.30.17, “The INFORMATION_SCHEMA INNODB_METRICS Table”

`innodb_old_blocks_pct`

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

`innodb_old_blocks_time`

Section 14.2.7, “InnoDB Startup Options and System Variables”
Section 5.1.2.1, “Changes to Server Defaults”
Section 8.9.1, “The InnoDB Buffer Pool”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

`innodb_open_files`

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

`innodb_optimize_fulltext_only`

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

`innodb_page_size`

Section 14.2.2.3, “Converting Tables from Other Storage Engines to InnoDB”
Section 2.11.2.1, “Downgrading to MySQL 5.5”
Section 5.3.2, “File Space Management”
Section 14.2.8, “Limits on InnoDB Tables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.2.4.12.4, “Physical Structure of an InnoDB Index”
Section 14.2.10.14, “Troubleshooting the InnoDB memcached Plugin”
Section 1.4, “What Is New in MySQL 5.6”

`innodb_print_all_deadlocks`

Section 14.2.5.5, “InnoDB General Troubleshooting”
Section 14.2.4.10, “How to Cope with Deadlocks”

`innodb_random_read_ahead`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_read_ahead_threshold`

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

`innodb_read_io_threads`

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

`innodb_rollback_segments`

Section 8.5.7, “Optimizing InnoDB Disk I/O”

`innodb_sort_buffer_size`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_stats_auto_recalc`

Section 13.1.14, “CREATE TABLE Syntax”

`innodb_stats_method`

Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”

`innodb_stats_on_metadata`

Section 5.1.2.1, “Changes to Server Defaults”
Section 14.2.6.5.2, “Dynamically Changing innodb_stats_on_metadata”
Section 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

`innodb_stats_persistent`

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

`innodb_stats_persistent_sample_pages`

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

`innodb_stats_sample_pages`

Section 14.2.6.8, “Controlling Optimizer Statistics Estimation”

`innodb_stats_transient_sample_pages`

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

`innodb_strict_mode`

Section 13.1.11, “CREATE INDEX Syntax”
Section 13.1.14, “CREATE TABLE Syntax”
Section 14.2.6.7, “InnoDB Strict Mode”
Section 5.1.7, “Server SQL Modes”

`innodb_support_xa`

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

`innodb_table_locks`

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

`innodb_thread_concurrency`

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

`innodb_undo_directory`

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

`innodb_undo_logs`

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

`innodb_undo_tablespaces`

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

`innodb_use_native_aio`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_use_sys_malloc`

Section 14.2.7, “InnoDB Startup Options and System Variables”

`innodb_write_io_threads`

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

`insert_id`

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

`interactive_timeout`

Section 21.9.3.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 5.1.2.1, “Changes to Server Defaults”
Section 8.13.7, “Nested-Loop Join Algorithms”
Section 5.1.4, “Server System Variables”
Section 2.11.1.1, “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 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 17.6, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”

`large_page_size`

Section 5.1.4, “Server System Variables”

`large_pages`

Section 5.1.4, “Server System Variables”

`last_insert_id`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.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.9.4, “MySQL Source-Configuration Options”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”

`local_infile`

Section 5.1.4, “Server System Variables”

`lock_wait_timeout`

Section 5.1.4, “Server System Variables”

`locked_in_memory`

Section 5.1.4, “Server System Variables”

`log`

Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 14.2.10.4, “Using the InnoDB memcached Plugin with Replication”

`log_bin`

Section 16.1.4.4, “Binary Log Options and Variables”
Section 5.1.4, “Server 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_trust_function_creators`

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

`log_error`

Section 5.1.4, “Server System Variables”

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

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

`log_throttle_queries_not_using_indexes`

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

`log_warnings`

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

`long_query_time`

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

`low_priority_updates`

Section 5.1.4, “Server System Variables”
Section 8.10.2, “Table Locking Issues”
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 14.2.2.5, “FOREIGN KEY Constraints”
Section 13.7.1.4, “GRANT Syntax”
Section 13.7.1.6, “REVOKE 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 19.30.9, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
Section 19.30.7, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”

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.16.1, “GROUP BY (Aggregate) Functions”
Section C.5.2.3, “Lost connection to MySQL server”
Section C.5.2.9, “MySQL server has gone away”
Section 21.9.7.26, “mysql_stmt_send_long_data()”
Section 21.9.3.72, “mysql_use_result()”
Section C.5.2.10, “Packet too large”
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 21.9, “MySQL C API”
Section 16.4.1.20, “Replication and max_allowed_packet”
Section 16.1.4.2, “Replication Master Options and Variables”
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.11.1.1, “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 20.9.9.1, “The host_cache Table”
Section 2.11.1.1, “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 22.4.1.4, “Debugging mysqld under gdb”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 20.11, “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 2.11.1.1, “Upgrading from MySQL 5.5 to 5.6”

`max_delayed_threads`

Section 20.11, “Performance Schema System Variables”
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.3.3, “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 4.5.1.1, “mysql Options”
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.13.12, “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.8, “Limits on InnoDB Tables”
Section 5.1.4, “Server System Variables”

`max_sort_length`

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

`max_sp_recursion_depth`

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

`max_tmp_tables`

Section 5.1.4, “Server System Variables”

`max_user_connections`

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

`max_write_lock_count`

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

`metadata_locks_cache_size`

Section 5.1.4, “Server System Variables”

`metadata_locks_hash_instances`

Section 5.1.4, “Server System Variables”

`min_examined_row_limit`

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

`myisam_data_pointer_size`

Section 13.1.14, “CREATE TABLE Syntax”
Section 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 17.6, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”

`myisam_mmap_size`

Section 5.1.4, “Server System Variables”

`myisam_recover_options`

Section 5.1.4, “Server System Variables”

`myisam_repair_threads`

Section 5.1.4, “Server System Variables”

`myisam_sort_buffer_size`

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

`myisam_stats_method`

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

`myisam_use_mmap`

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

N

`named_pipe`

Section 5.1.4, “Server System Variables”

`net_buffer_length`

Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 21.9, “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 21.9.3.49, “mysql_options()”
Section 5.1.4, “Server System Variables”

`net_write_timeout`

Section 5.1.4, “Server System Variables”

`new`

Section 5.1.4, “Server System Variables”

O

`old`

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

`old_alter_table`

Section 13.1.6, “ALTER TABLE Syntax”
Section 5.1.4, “Server System Variables”

`old_passwords`

Section C.5.2.4, “Client does not support authentication protocol”
Section 13.7.1.7, “SET PASSWORD Syntax”
Section 6.3.5, “Assigning Account Passwords”
Section 12.13, “Encryption and Compression Functions”
Section 6.1.2.5, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 21.10, “MySQL PHP API”
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.6.2, “The SHA-256 Authentication Plugin”

`open_files_limit`

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

`optimizer_join_cache_level`

Section 8.13.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.13.11.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.13.11.3, “Batched Key Access Joins”
Section 8.13.11.2, “Block Nested-Loop Algorithm for Outer Joins and Semi-Joins”
Section 8.8.5.2, “Controlling Switchable Optimizations”
Section 8.13.3, “Engine Condition Pushdown Optimization”
Section 8.13.4, “Index Condition Pushdown Optimization”
Section 8.13.11.1, “Join Buffer Management for Block Nested-Loop and Batched Key Access Algorithms”
Section 8.13.10, “Multi-Range Read Optimization”
Section 8.13.15.1, “Optimizing Subqueries with Semi-Join Transformations”
Section 8.13.15.2, “Optimizing Subqueries with Subquery Materialization”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

`optimizer_trace`

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

`optimizer_trace_features`

Section 5.1.4, “Server System Variables”

`optimizer_trace_limit`

Section 5.1.4, “Server System Variables”

`optimizer_trace_max_mem_size`

Section 5.1.4, “Server System Variables”

`optimizer_trace_offset`

Section 5.1.4, “Server System Variables”

P

`performance_schema`

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

`performance_schema_accounts_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.6.1, “The accounts Table”

`performance_schema_digests_size`

Section 20.7, “Performance Schema Statement Digests”
Section 20.11, “Performance Schema System Variables”
Section 20.9.8.3, “Statement Summary Tables”

`performance_schema_events_stages_history_long_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.4.3, “The events_stages_history_long Table”

`performance_schema_events_stages_history_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.4.2, “The events_stages_history Table”

`performance_schema_events_statements_history_long_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.5.3, “The events_statements_history_long Table”

`performance_schema_events_statements_history_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.5.2, “The events_statements_history Table”

`performance_schema_events_waits_history_long_size`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 20.11, “Performance Schema System Variables”
Section 20.9, “Performance Schema Table Descriptions”
Section 20.9.3.3, “The events_waits_history_long Table”

`performance_schema_events_waits_history_size`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 20.11, “Performance Schema System Variables”
Section 20.9, “Performance Schema Table Descriptions”
Section 20.9.3.2, “The events_waits_history Table”

`performance_schema_hosts_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.6.2, “The hosts Table”

`performance_schema_max_cond_classes`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_cond_instances`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_file_classes`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_file_handles`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_file_instances`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_mutex_classes`

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

`performance_schema_max_mutex_instances`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_rwlock_classes`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_rwlock_instances`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_socket_classes`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_socket_instances`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_stage_classes`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_statement_classes`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_table_handles`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_table_instances`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_thread_classes`

Section 20.11, “Performance Schema System Variables”

`performance_schema_max_thread_instances`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 20.11, “Performance Schema System Variables”

`performance_schema_session_connect_attrs_size`

Section 20.11, “Performance Schema System Variables”

`performance_schema_setup_actors_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.1.1, “The setup_actors Table”

`performance_schema_setup_objects_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.1.4, “The setup_objects Table”

`performance_schema_users_size`

Section 20.11, “Performance Schema System Variables”
Section 20.9.6.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 22.2.4.3, “Compiling and Installing Plugin Libraries”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 5.1.8.1, “Installing and Uninstalling Plugins”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.1.2.6.1, “Password Validation Plugin Installation”
Section 6.3.6, “Pluggable Authentication”
Section 14.12.1, “Pluggable Storage Engine Architecture”
Section 22.2.2, “Plugin API Components”
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 19.15, “The INFORMATION_SCHEMA PLUGINS Table”
Section 6.3.6.4, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.6.5, “The Test Authentication Plugin”
Section 2.10.1, “Unix Postinstallation Procedures”
Section 22.3.2.6, “User-Defined Function Security Precautions”
Section 22.2.4.9.3, “Using the Authentication Plugins”
Section 22.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 22.2.4.8, “Writing Audit Plugins”
Section 22.2.4.5, “Writing Daemon Plugins”
Section 22.2.4.4, “Writing Full-Text Parser Plugins”
Section 22.2.4.10, “Writing Password-Validation Plugins”
Section 22.2.4.7, “Writing Semisynchronous Replication Plugins”

`port`

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

`preload_buffer_size`

Section 5.1.4, “Server System Variables”

`profiling`

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

`profiling_history_size`

Section 13.7.5.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.7, “Proxy Users”
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.13.12, “ORDER BY Optimization”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 8.13.10, “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 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”

S

`secure_auth`

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

`secure_file_priv`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 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.15, “Miscellaneous Functions”
Section 5.1.4, “Server System Variables”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

`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.6.2, “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.4, “Server System Variables”

`slave_allow_batching`

Section 16.1.4.2, “Replication Master Options and Variables”

`slave_checkpoint_group`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_checkpoint_period`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_compressed_protocol`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_exec_mode`

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

`slave_load_tmpdir`

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

`slave_max_allowed_packet`

Section 16.1.4.2, “Replication Master 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.2, “Replication Master Options and Variables”

`slave_skip_errors`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slave_sql_verify_checksum`

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

`slave_transaction_retries`

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

`slave_type_conversions`

Section 16.1.4.3, “Replication Slave Options and Variables”

`slow_launch_time`

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

`slow_query_log`

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

`slow_query_log_file`

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

`socket`

Section 5.1.4, “Server System Variables”

`sort_buffer_size`

Section 8.13.12, “ORDER BY Optimization”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 8.2.1.3, “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 5.1.4, “Server System Variables”
Section 16.4.3, “Upgrading a Replication Setup”

`sql_log_off`

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

`sql_mode`

Section 13.1.9, “CREATE EVENT Syntax”
Section 13.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.15, “CREATE TRIGGER Syntax”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 13.7.5.39, “SHOW TRIGGERS 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.18.3, “Expression Handling”
Section 1.7, “How to Report Bugs or Problems”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section C.5.5.2, “Problems Using DATE Columns”
Section 16.4.1.34, “Replication and Variables”
Section 1.8.3, “Running MySQL in ANSI Mode”
Section 1.8.2, “Selecting SQL Modes”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 19.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 19.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 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.3, “Replication Slave Options and Variables”

`sql_warnings`

Section 5.1.4, “Server System Variables”

`ssl_ca`

Section 5.1.4, “Server System Variables”

`ssl_capath`

Section 5.1.4, “Server System Variables”

`ssl_cert`

Section 5.1.4, “Server System Variables”

`ssl_cipher`

Section 5.1.4, “Server System Variables”

`ssl_crl`

Section 5.1.4, “Server System Variables”

`ssl_crlpath`

Section 5.1.4, “Server System Variables”

`ssl_key`

Section 5.1.4, “Server System Variables”

`storage_engine`

Section 16.4.1.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.7, “InnoDB Startup Options and System Variables”
Section 16.1.4.4, “Binary Log Options and Variables”
Section 14.2.9, “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.11.1.1, “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.11.1.1, “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.11.1.1, “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”

`table_open_cache`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 14.2.7, “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.11.1.1, “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 22.4.1.4, “Debugging mysqld under gdb”
Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 8.2.5, “Other Optimization Tips”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

`thread_concurrency`

Section 5.1.4, “Server System Variables”

`thread_handling`

Section 5.1.4, “Server System Variables”

`thread_stack`

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

`time_format`

Section 5.1.4, “Server System Variables”

`time_zone`

Section 13.1.9, “CREATE EVENT Syntax”
Section 12.7, “Date and Time Functions”
Section 18.4.4, “Event Metadata”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 10.6, “MySQL Server Time Zone Support”
Section 16.4.1.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 13.7.5.16, “SHOW ENGINE Syntax”
Section 5.1.4, “Server System Variables”

`timestamp`

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

`tmp_table_size`

Section 8.4.3.3, “How MySQL Uses Internal Temporary Tables”
Section 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.13.12, “ORDER BY Optimization”
Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

`transaction_alloc_block_size`

Section 5.1.4, “Server System Variables”

`transaction_prealloc_size`

Section 5.1.4, “Server System Variables”

`tx_isolation`

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

`tx_read_only`

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

U

`unique_checks`

Section 14.2.2.3, “Converting Tables from Other Storage Engines 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 18.5.3, “Updatable and Insertable Views”

V

`validate_password_dictionary_file`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_length`

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

`validate_password_mixed_case_count`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_number_count`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_policy_number`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`validate_password_special_char_count`

Section 6.1.2.6.2, “Password Validation Plugin Options and Variables”

`version`

Section 12.14, “Information Functions”
Section 5.1.4, “Server System Variables”

`version_comment`

Section 5.1.4, “Server System Variables”

`version_compile_machine`

Section 5.1.4, “Server System Variables”

`version_compile_os`

Section 5.1.4, “Server System Variables”

W

`wait_timeout`

Section C.5.2.9, “MySQL server has gone away”
Section 21.9.3.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”

Prev	Up	Next
Statement/Syntax Index	Home	Status Variable Index