System Variable Index

System Variable Index
Prev		Next

System Variable Index

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

A

audit_log_buffer_size

Section 6.4.4.4, “Audit Log Logging Control”
Section 6.4.4.6, “Audit Log Reference”

audit_log_connection_policy

Section 6.4.4.5, “Audit Log Filtering”
Section 6.4.4.6, “Audit Log Reference”

audit_log_current_session

Section 6.4.4.6, “Audit Log Reference”

audit_log_exclude_accounts

Section 6.4.4.5, “Audit Log Filtering”
Section 6.4.4.6, “Audit Log Reference”

audit_log_file

Section 6.4.4.4, “Audit Log Logging Control”
Section 6.4.4.6, “Audit Log Reference”
Section 6.4.4, “MySQL Enterprise Audit”
Section 6.4.4.2, “MySQL Enterprise Audit Security Considerations”

audit_log_flush

Section 6.4.4.4, “Audit Log Logging Control”
Section 6.4.4.6, “Audit Log Reference”

audit_log_format

Section 6.4.4.3, “Audit Log File Formats”
Section 6.4.4.4, “Audit Log Logging Control”
Section 6.4.4.6, “Audit Log Reference”
Section 6.4.4, “MySQL Enterprise Audit”

audit_log_include_accounts

Section 6.4.4.5, “Audit Log Filtering”
Section 6.4.4.6, “Audit Log Reference”

audit_log_policy

Section 6.4.4.5, “Audit Log Filtering”
Section 6.4.4.6, “Audit Log Reference”
Section 5.1.8, “Using System Variables”

audit_log_rotate_on_size

Section 6.4.4.4, “Audit Log Logging Control”
Section 6.4.4.6, “Audit Log Reference”

audit_log_statement_policy

Section 6.4.4.5, “Audit Log Filtering”
Section 6.4.4.6, “Audit Log Reference”

audit_log_strategy

Section 6.4.4.4, “Audit Log Logging Control”
Section 6.4.4.6, “Audit Log Reference”

authentication_windows_log_level

Section 5.1.7, “Server System Variables”
Section 6.4.1.7, “Windows Pluggable Authentication”

authentication_windows_use_principal_name

Section 5.1.7, “Server System Variables”
Section 6.4.1.7, “Windows Pluggable Authentication”

auto_increment_increment

Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.1, “MySQL 5.6 FAQ: General”
Section 17.4.1.35, “Replication and Variables”
Section 17.1.4.2, “Replication Master Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

auto_increment_offset

Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.1, “MySQL 5.6 FAQ: General”
Section 17.4.1.35, “Replication and Variables”
Section 17.1.4.2, “Replication Master Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

AUTOCOMMIT

Section 17.4.1.32, “Replication and Transactions”

autocommit

Section 14.7.2.2, “autocommit, Commit, and Rollback”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 14.7.5.2, “Deadlock Detection and Rollback”
Section 13.2.2, “DELETE Statement”
Section 14.7, “InnoDB Locking and Transaction Model”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 14.7.2.4, “Locking Reads”
Section 14.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section 14.6.1.4, “Moving or Copying InnoDB Tables”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 8.5.3, “Optimizing InnoDB Read-Only Transactions”
Section 14.8.10, “Purge Configuration”
Section 17.4.1.32, “Replication and Transactions”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 5.1.7, “Server System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 21.30.25, “The INFORMATION_SCHEMA INNODB_TRX Table”
Section 5.5.3.3, “Thread Pool Operation”
Section 14.7.2.1, “Transaction Isolation Levels”

automatic_sp_privileges

Section 13.1.5, “ALTER PROCEDURE Statement”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 20.2.2, “Stored Routines and MySQL Privileges”

avoid_temporal_upgrade

Section 2.11.3, “Changes in MySQL 5.6”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 5.1.7, “Server System Variables”

B

back_log

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 5.1.7, “Server System Variables”

basedir

Section 13.7.3.3, “INSTALL PLUGIN Statement”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”

big_tables

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

bind_address

Section B.4.2.2, “Can't connect to [local] MySQL server”
Section 5.1.11.2, “Configuring the MySQL Server to Permit IPv6 Connections”
Section 5.1.11.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.11.3, “Connecting Using the IPv6 Local Host Address”
Section 5.1.11, “IPv6 Support”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1.11.5, “Obtaining an IPv6 Address from a Broker”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.1.7, “Server System Variables”
Section 6.2.14, “Troubleshooting Problems Connecting to MySQL”

binlog_cache_size

Section 17.1.4.4, “Binary Log Options and Variables”
Section 5.1.9, “Server Status Variables”
Section 5.4.4, “The Binary Log”

binlog_checksum

Section 17.1.4.4, “Binary Log Options and Variables”
Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
MySQL Glossary
Section 17.4.2, “Replication Compatibility Between MySQL Versions”
Section 5.4.4, “The Binary Log”
Section 1.4, “What Is New in MySQL 5.6”

binlog_direct_non_transactional_updates

Section 17.1.4.4, “Binary Log Options and Variables”
Section 17.4.1.32, “Replication and Transactions”

binlog_error_action

Section 17.1.4.4, “Binary Log Options and Variables”
Section 5.4.4, “The Binary Log”

binlog_format

Section 17.1.4.4, “Binary Log Options and Variables”
Section 2.11.3, “Changes in MySQL 5.6”
Section 12.6, “Date and Time Functions”
Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 17.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 17.2.3.2, “Evaluation of Table-Level Replication Options”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 12.15, “Information Functions”
Section 13.2.5.3, “INSERT DELAYED Statement”
Section 12.14, “Locking Functions”
Section 5.4.4.4, “Logging Format for Changes to mysql Database Tables”
Section 12.5.2, “Mathematical Functions”
Section 12.20, “Miscellaneous Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.14, “MySQL 5.6 FAQ: Replication”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.4.1.2, “Replication and BLACKHOLE Tables”
Section 17.4.1.18, “Replication and LOAD DATA”
Section 17.4.1.20, “Replication and MEMORY Tables”
Section 17.4.1.29, “Replication and Temporary Tables”
Section 17.4.1.32, “Replication and Transactions”
Section 17.1.2, “Replication Formats”
Section 17.4.1.21, “Replication of the mysql System Database”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 20.7, “Stored Program Binary Logging”
Section 5.1.8.1, “System Variable Privileges”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 5.4.3, “The General Query Log”
Section 14.20.6, “The InnoDB memcached Plugin and Replication”
Section 5.4.5, “The Slow Query Log”
Section 14.7.2.1, “Transaction Isolation Levels”
Section 17.4.3, “Upgrading a Replication Setup”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

binlog_gtid_simple_recovery

Section 17.1.4.5, “Global Transaction ID Options and Variables”

binlog_max_flush_queue_time

Section 17.1.4.4, “Binary Log Options and Variables”

binlog_order_commits

Section 17.1.4.4, “Binary Log Options and Variables”

binlog_row_image

Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.1.4.4, “Binary Log Options and Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 17.4.2, “Replication Compatibility Between MySQL Versions”
Section 1.4, “What Is New in MySQL 5.6”

binlog_rows_query_log_events

Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.4.2, “Replication Compatibility Between MySQL Versions”

binlog_stmt_cache_size

Section 17.1.4.4, “Binary Log Options and Variables”
Section 5.1.9, “Server Status Variables”

binlogging_impossible_mode

Section 17.1.4.4, “Binary Log Options and Variables”

block_encryption_mode

Section 12.13, “Encryption and Compression Functions”
Section 5.1.7, “Server System Variables”

bulk_insert_buffer_size

Section 15.2.1, “MyISAM Startup Options”
Section 8.2.4.1, “Optimizing INSERT Statements”
Section 5.1.7, “Server System Variables”

C

character_set_client

Section 23.7.8.1, “C API Prepared Statement Type Codes”
Section 10.15, “Character Set Configuration”
Section 10.4, “Connection Character Sets and Collations”
Section 13.2.6, “LOAD DATA Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.11, “MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Statement”
Section 13.7.4.3, “SET NAMES Statement”
Section 13.7.5.9, “SHOW CREATE EVENT Statement”
Section 13.7.5.11, “SHOW CREATE PROCEDURE Statement”
Section 13.7.5.13, “SHOW CREATE TRIGGER Statement”
Section 13.7.5.14, “SHOW CREATE VIEW Statement”
Section 13.7.5.19, “SHOW EVENTS Statement”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Statement”
Section 13.7.5.39, “SHOW TRIGGERS Statement”
Section 5.4.4, “The Binary Log”
Section 21.8, “The INFORMATION_SCHEMA EVENTS Table”
Section 21.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 21.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 21.29, “The INFORMATION_SCHEMA VIEWS Table”

character_set_connection

Section 12.10, “Cast Functions and Operators”
Section 12.7.3, “Character Set and Collation of Function Results”
Section 10.3.8, “Character Set Introducers”
Section 10.2.1, “Character Set Repertoire”
Section 10.3.6, “Character String Literal Character Set and Collation”
Section 10.8.4, “Collation Coercibility in Expressions”
Section 10.4, “Connection Character Sets and Collations”
Section 12.6, “Date and Time Functions”
Section 12.13, “Encryption and Compression Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.11, “MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 10.16, “MySQL Server Locale Support”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Statement”
Section 13.7.4.3, “SET NAMES Statement”
Section 9.1.1, “String Literals”
Section 12.2, “Type Conversion in Expression Evaluation”

character_set_database

Section 13.1.7, “ALTER TABLE Statement”
Section 10.4, “Connection Character Sets and Collations”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 10.3.3, “Database Character Set and Collation”
Section 13.2.6, “LOAD DATA Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Statement”

character_set_filesystem

Section 13.2.6, “LOAD DATA Statement”
Section 13.2.9.1, “SELECT ... INTO Statement”
Section 5.1.7, “Server System Variables”
Section 12.7, “String Functions and Operators”

character_set_results

Section 23.7.4, “C API Data Structures”
Section 10.4, “Connection Character Sets and Collations”
Section 10.6, “Error Message Character Set”
Section A.11, “MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.7, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Statement”
Section 13.7.4.3, “SET NAMES Statement”
Section 10.2.2, “UTF-8 for Metadata”

character_set_server

Section 10.15, “Character Set Configuration”
Section 10.4, “Connection Character Sets and Collations”
Section 10.3.3, “Database Character Set and Collation”
Section 12.9.4, “Full-Text Stopwords”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.3, “Replication and Character Sets”
Section 17.4.1.35, “Replication and Variables”
Section 10.3.2, “Server Character Set and Collation”
Section 5.1.7, “Server System Variables”

character_set_system

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

character_sets_dir

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

collation_connection

Section 12.10, “Cast Functions and Operators”
Section 12.7.3, “Character Set and Collation of Function Results”
Section 10.3.8, “Character Set Introducers”
Section 10.3.6, “Character String Literal Character Set and Collation”
Section 10.8.4, “Collation Coercibility in Expressions”
Section 10.4, “Connection Character Sets and Collations”
Section 12.6, “Date and Time Functions”
Section 12.13, “Encryption and Compression Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 13.7.4.3, “SET NAMES Statement”
Section 13.7.5.9, “SHOW CREATE EVENT Statement”
Section 13.7.5.11, “SHOW CREATE PROCEDURE Statement”
Section 13.7.5.13, “SHOW CREATE TRIGGER Statement”
Section 13.7.5.14, “SHOW CREATE VIEW Statement”
Section 13.7.5.19, “SHOW EVENTS Statement”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Statement”
Section 13.7.5.39, “SHOW TRIGGERS Statement”
Section 5.4.4, “The Binary Log”
Section 21.8, “The INFORMATION_SCHEMA EVENTS Table”
Section 21.19, “The INFORMATION_SCHEMA ROUTINES Table”
Section 21.27, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 21.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 12.2, “Type Conversion in Expression Evaluation”

collation_database

Section 10.4, “Connection Character Sets and Collations”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 10.3.3, “Database Character Set and Collation”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 5.4.4, “The Binary Log”

collation_server

Section 10.4, “Connection Character Sets and Collations”
Section 10.3.3, “Database Character Set and Collation”
Section 12.9.4, “Full-Text Stopwords”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 10.3.2, “Server Character Set and Collation”
Section 5.1.7, “Server System Variables”
Section 5.4.4, “The Binary Log”

completion_type

Section 23.7.6.6, “mysql_commit()”
Section 23.7.6.58, “mysql_rollback()”
Section 5.1.7, “Server System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”

concurrent_insert

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

connect_timeout

Section B.4.2.11, “Communication Errors and Aborted Connections”
Section B.4.2.3, “Lost connection to MySQL server”
Section 23.7.6.53, “mysql_real_connect()”
Section 5.1.7, “Server System Variables”

connection_control_failed_connections_threshold

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

connection_control_max_connection_delay

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

connection_control_min_connection_delay

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

core_file

Section 5.1.7, “Server System Variables”

create_old_temporals

Section 18.3.3.8.2, “NDB Cluster System Variables”

D

daemon_memcached_engine_lib_name

Section 14.20.3, “Setting Up the InnoDB memcached Plugin”

daemon_memcached_engine_lib_path

Section 14.20.3, “Setting Up the InnoDB memcached Plugin”

daemon_memcached_option

Section 14.20.2, “InnoDB memcached Architecture”
Section 14.20.4, “Security Considerations for the InnoDB memcached Plugin”
Section 14.20.3, “Setting Up the InnoDB memcached Plugin”
Section 14.20.8, “Troubleshooting the InnoDB memcached Plugin”

daemon_memcached_r_batch_size

Section 14.20.2, “InnoDB memcached Architecture”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.20.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.20.3, “Setting Up the InnoDB memcached Plugin”
Section 14.20.6, “The InnoDB memcached Plugin and Replication”
Section 14.20.5.3, “Tuning InnoDB memcached Plugin Performance”

daemon_memcached_w_batch_size

Section 14.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.20.2, “InnoDB memcached Architecture”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.20.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.20.3, “Setting Up the InnoDB memcached Plugin”
Section 14.20.6, “The InnoDB memcached Plugin and Replication”
Section 14.20.5.3, “Tuning InnoDB memcached Plugin Performance”

datadir

Section 14.8.1, “InnoDB Startup Configuration”
Section 2.3, “Installing MySQL on Microsoft Windows”
MySQL Glossary
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”

date_format

Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

datetime_format

Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

debug

Section 5.1.7, “Server System Variables”
Section 24.5.3, “The DBUG Package”

debug_sync

Section 5.1.7, “Server System Variables”

default

Section 15.1, “Setting the Storage Engine”
Section 14.1.4, “Testing and Benchmarking with InnoDB”

default_storage_engine

Section 13.1.14, “CREATE LOGFILE GROUP Statement”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 15.1, “Setting the Storage Engine”
Section 17.3.3, “Using Replication with Different Master and Slave Storage Engines”

default_tmp_storage_engine

Section 5.5.1, “Installing and Uninstalling Plugins”
Section 5.1.7, “Server System Variables”
Section 15.1, “Setting the Storage Engine”

default_week_format

Section 12.6, “Date and Time Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Section 5.1.7, “Server System Variables”

delay_key_write

Section 13.1.17, “CREATE TABLE Statement”
Section 8.11.5, “External Locking”
Section A.14, “MySQL 5.6 FAQ: Replication”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section B.4.3.3, “What to Do If MySQL Keeps Crashing”

delayed_insert_limit

Section 13.2.5.3, “INSERT DELAYED Statement”
Section 5.1.7, “Server System Variables”

delayed_insert_timeout

Section 13.2.5.3, “INSERT DELAYED Statement”
Section 5.1.7, “Server System Variables”

delayed_queue_size

Section 13.2.5.3, “INSERT DELAYED Statement”
Section 5.1.7, “Server System Variables”

disconnect_on_expired_password

Section 6.2.10, “Server Handling of Expired Passwords”
Section 5.1.7, “Server System Variables”

div_precision_increment

Section 12.5.1, “Arithmetic Operators”
Section 5.1.7, “Server System Variables”

E

end_markers_in_json

Section 5.1.7, “Server System Variables”

enforce_gtid_consistency

Section 17.1.3.5, “Disabling GTID Transactions”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 1.4, “What Is New in MySQL 5.6”

eq_range_index_dive_limit

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

error_count

Section B.2, “Error Information Interfaces”
Section 5.1.7, “Server System Variables”
Section 13.7.5.18, “SHOW ERRORS Statement”
Section 13.6.7.7, “The MySQL Diagnostics Area”

event

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

event_scheduler

Section 20.4.2, “Event Scheduler Configuration”
Section 23.6.2, “Restrictions When Using the Embedded MySQL Server”
Section 5.1.7, “Server System Variables”
Section 20.4.6, “The Event Scheduler and MySQL Privileges”

expire_logs_days

Section 17.1.4.4, “Binary Log Options and Variables”
Section 13.4.1.1, “PURGE BINARY LOGS Statement”
Section 5.4.7, “Server Log Maintenance”

explicit_defaults_for_timestamp

Section 11.2.6, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 2.11.3, “Changes in MySQL 5.6”
Section 11.5, “Data Type Default Values”
Section 11.2.1, “Date and Time Data Type Syntax”
Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

external_user

Section 6.4.4.3, “Audit Log File Formats”
Section 24.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 6.2.12, “Proxy Users”
Section 5.1.7, “Server System Variables”
Section 24.2.4.9.1, “Writing the Server-Side Authentication Plugin”

F

flush

Section 5.1.7, “Server System Variables”

flush_time

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”

foreign_key_checks

Section 13.1.7, “ALTER TABLE Statement”
Section 13.1.17.6, “FOREIGN KEY Constraints”
Section 14.6.1.3, “Importing InnoDB Tables”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 14.13.1, “Online DDL Operations”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 5.4.4, “The Binary Log”

ft_boolean_syntax

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

ft_max_word_len

Section 12.9.2, “Boolean Full-Text Searches”
Section 17.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.7, “Server System Variables”
Section 24.2.1, “Types of Plugins”

ft_min_word_len

Section 12.9.2, “Boolean Full-Text Searches”
Section 17.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.9.1, “Natural Language Full-Text Searches”
Section 5.1.7, “Server System Variables”
Section 24.2.1, “Types of Plugins”

ft_query_expansion_limit

Section 5.1.7, “Server System Variables”

ft_stopword_file

Section 12.9.2, “Boolean Full-Text Searches”
Section 17.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.9.4, “Full-Text Stopwords”
Section 12.9.1, “Natural Language Full-Text Searches”
Section 5.1.7, “Server System Variables”

G

general_log

MySQL Glossary
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.7, “Server System Variables”
Section 5.4.3, “The General Query Log”
Section 1.4, “What Is New in MySQL 5.6”

general_log_file

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.7, “Server System Variables”
Section 5.4.3, “The General Query Log”
Section 1.4, “What Is New in MySQL 5.6”

group_concat_max_len

Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”
Section 5.1.7, “Server System Variables”

gtid_executed

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.3.1, “GTID Concepts”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.4.1.2, “RESET MASTER Statement”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 13.7.5.24, “SHOW MASTER STATUS Statement”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

gtid_mode

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 17.1.3.5, “Disabling GTID Transactions”
Section 12.17, “Functions Used with Global Transaction IDs”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.4.2, “Replication Compatibility Between MySQL Versions”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 17.4.3, “Upgrading a Replication Setup”
Section 2.11.4, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 1.4, “What Is New in MySQL 5.6”

gtid_next

Section 13.1.6, “ALTER SERVER Statement”
Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 13.7.6.2, “CACHE INDEX Statement”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.7.2.2, “CHECK TABLE Statement”
Section 13.1.16, “CREATE SERVER Statement”
Section 13.1.27, “DROP SERVER Statement”
Section 13.7.6.3, “FLUSH Statement”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.3.1, “GTID Concepts”
Section 13.7.6.5, “LOAD INDEX INTO CACHE Statement”
Section 13.7.2.4, “OPTIMIZE TABLE Statement”
Section 13.7.2.5, “REPAIR TABLE Statement”
Section 13.7.6.6, “RESET Statement”
Section 13.4.2.5, “START SLAVE Statement”
Section 13.4.2.6, “STOP SLAVE Statement”

gtid_owned

Section 17.1.4.5, “Global Transaction ID Options and Variables”

gtid_purged

Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 17.1.3.1, “GTID Concepts”
Section 13.4.1.2, “RESET MASTER Statement”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”

H

have_compress

Section 5.1.7, “Server System Variables”

have_crypt

Section 5.1.7, “Server System Variables”

have_dynamic_loading

Section 17.3.9.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.7, “Server System Variables”

have_geometry

Section 5.1.7, “Server System Variables”

have_openssl

Section 5.1.7, “Server System Variables”

have_profiling

Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

have_query_cache

Section 8.10.3.3, “Query Cache Configuration”
Section 5.1.7, “Server System Variables”

have_rtree_keys

Section 5.1.7, “Server System Variables”

have_ssl

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

have_symlink

Section 5.1.7, “Server System Variables”
Section 8.12.3.3, “Using Symbolic Links for Databases on Windows”
Section 8.12.3.2, “Using Symbolic Links for MyISAM Tables on Unix”

host_cache_size

Section 5.1.2.1, “Changes to Server Defaults”
Section 8.12.5.2, “DNS Lookup Optimization and the Host Cache”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 22.12.10.1, “The host_cache Table”
Section 1.4, “What Is New in MySQL 5.6”

hostname

Section 5.1.7, “Server System Variables”

I

identity

Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”

ignore_db_dirs

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

init_connect

Section 10.5, “Configuring Application Character Set and Collation”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.7, “Server System Variables”
Section 22.12.10.1, “The host_cache Table”

init_file

Section 8.10.2.2, “Multiple Key Caches”
Section 22.4, “Performance Schema Runtime Configuration”
Section B.4.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.4.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.1.7, “Server System Variables”
Section 15.3, “The MEMORY Storage Engine”

init_slave

Section 17.1.4.3, “Replication Slave Options and Variables”

innodb

Section 14.8.2, “Configuring InnoDB for Read-Only Operation”
Section A.16, “MySQL 5.6 FAQ: InnoDB Change Buffer”
Section 1.4, “What Is New in MySQL 5.6”

innodb_adaptive_flushing

Section 14.8.3.4, “Configuring Buffer Pool Flushing”

innodb_adaptive_flushing_lwm

Section 14.8.3.4, “Configuring Buffer Pool Flushing”

innodb_adaptive_hash_index

Section 14.5.3, “Adaptive Hash Index”
Section 14.8.5, “Configuring Thread Concurrency for InnoDB”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.9, “Optimizing InnoDB Configuration Variables”
Section 13.1.33, “TRUNCATE TABLE Statement”

innodb_adaptive_max_sleep_delay

Section 14.8.5, “Configuring Thread Concurrency for InnoDB”
Section 14.14, “InnoDB Startup Options and System Variables”

innodb_additional_mem_pool_size

Section 14.8.4, “Configuring the Memory Allocator for InnoDB”
Section 14.8.1, “InnoDB Startup Configuration”
Section 1.4, “What Is New in MySQL 5.6”

innodb_api_bk_commit_interval

Section 14.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.20.2, “InnoDB memcached Architecture”

innodb_api_disable_rowlock

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

innodb_api_enable_binlog

Section 14.20.6, “The InnoDB memcached Plugin and Replication”

innodb_api_enable_mdl

Section 14.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.20.2, “InnoDB memcached Architecture”

innodb_api_trx_level

Section 14.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 14.20.2, “InnoDB memcached Architecture”

innodb_autoextend_increment

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.6.3.2, “File-Per-Table Tablespaces”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.6.3.1, “The System Tablespace”

innodb_autoinc_lock_mode

Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
Section 8.5.5, “Bulk Data Loading for InnoDB Tables”
Section 12.15, “Information Functions”
Section 14.7.1, “InnoDB Locking”
Section 14.7.3, “Locks Set by Different SQL Statements in InnoDB”
MySQL Glossary

innodb_buffer_pool_dump_at_shutdown

Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary

innodb_buffer_pool_dump_now

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_buffer_pool_filename

Section 14.8.3.5, “Saving and Restoring the Buffer Pool State”

innodb_buffer_pool_instances

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.8.3.4, “Configuring Buffer Pool Flushing”
Section 14.8.3.1, “Configuring Multiple Buffer Pool Instances”
Section 8.12.4.1, “How MySQL Uses Memory”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.20.5.3, “Tuning InnoDB memcached Plugin Performance”

innodb_buffer_pool_load_abort

Section 5.1.9, “Server Status Variables”

innodb_buffer_pool_load_at_startup

Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 5.1.9, “Server Status Variables”

innodb_buffer_pool_load_now

Section 14.14, “InnoDB Startup Options and System Variables”
Section 5.1.9, “Server Status Variables”

innodb_buffer_pool_size

Section 14.5.1, “Buffer Pool”
Section 14.9.6, “Compression for OLTP Workloads”
Section 14.8.3.1, “Configuring Multiple Buffer Pool Instances”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 8.12.4.1, “How MySQL Uses Memory”
Section 14.20.2, “InnoDB memcached Architecture”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section B.3.1, “Server Error Message Reference”
Section 5.1.9, “Server Status Variables”
Section 14.20.5.3, “Tuning InnoDB memcached Plugin Performance”

innodb_change_buffer_max_size

Section 14.5.2, “Change Buffer”
Section A.16, “MySQL 5.6 FAQ: InnoDB Change Buffer”
MySQL Glossary

innodb_change_buffering

Section 14.5.2, “Change Buffer”
Section 14.8.2, “Configuring InnoDB for Read-Only Operation”
MySQL Glossary
Section 8.5.2, “Optimizing InnoDB Transaction Management”

innodb_checksum_algorithm

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 1.4, “What Is New in MySQL 5.6”

innodb_checksums

Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary

innodb_cmp_per_index_enabled

Section 14.9.4, “Monitoring InnoDB Table Compression at Runtime”
Section 21.30.6, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables”
Section 14.9.3, “Tuning Compression for InnoDB Tables”

innodb_compression_failure_threshold_pct

Section 14.9.6, “Compression for OLTP Workloads”
Section 14.9.5, “How Compression Works for InnoDB Tables”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.9.3, “Tuning Compression for InnoDB Tables”
Section 1.4, “What Is New in MySQL 5.6”

innodb_compression_level

Section 14.9.6, “Compression for OLTP Workloads”
Section 14.9.5, “How Compression Works for InnoDB Tables”
MySQL Glossary
Section 14.9.3, “Tuning Compression for InnoDB Tables”
Section 1.4, “What Is New in MySQL 5.6”

innodb_compression_pad_pct_max

Section 14.9.6, “Compression for OLTP Workloads”
Section 14.9.5, “How Compression Works for InnoDB Tables”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.9.3, “Tuning Compression for InnoDB Tables”
Section 1.4, “What Is New in MySQL 5.6”

innodb_concurrency_tickets

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.8.5, “Configuring Thread Concurrency for InnoDB”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 8.5.9, “Optimizing InnoDB Configuration Variables”
Section 21.30.25, “The INFORMATION_SCHEMA INNODB_TRX Table”

innodb_data_file_path

Section 5.1.2.1, “Changes to Server Defaults”
Section 14.12.2, “File Space Management”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 14.6.3.1, “The System Tablespace”
Section 14.21.1, “Troubleshooting InnoDB I/O Problems”

innodb_data_home_dir

Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 14.21.1, “Troubleshooting InnoDB I/O Problems”

innodb_deadlock_detect

MySQL Glossary

innodb_default_row_format

MySQL Glossary

innodb_doublewrite

Section 14.6.5, “Doublewrite Buffer”
Section 14.2, “InnoDB and the ACID Model”
Section 14.12.1, “InnoDB Disk I/O”
Section 14.8.1, “InnoDB Startup Configuration”
MySQL Glossary
Section 14.20.5.3, “Tuning InnoDB memcached Plugin Performance”

innodb_fast_shutdown

Section 14.10.2.1, “Compatibility Check When InnoDB Is Started”
Section 2.12.4, “Downgrading Binary and Package-based Installations on Unix/Linux”
Section 14.18.2, “InnoDB Recovery”
MySQL Glossary
Section 14.6.6, “Redo Log”
Section 5.1.14, “The Server Shutdown Process”
Section 2.11.4, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”

innodb_fil_make_page_dirty_debug

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_file_format

Section 14.10.2.2, “Compatibility Check When a Table Is Opened”
Section 14.10.2.1, “Compatibility Check When InnoDB Is Started”
Section 10.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.17, “CREATE TABLE Statement”
Section 14.6.1.1, “Creating InnoDB Tables”
Section 14.9.2, “Enabling Compression for a Table”
Section 14.10.1, “Enabling File Formats”
Section 14.10.3, “Identifying the File Format in Use”
Section 14.11, “InnoDB Row Formats”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.9.7, “SQL Compression Syntax Warnings and Errors”

innodb_file_format_check

Section 14.10.2.2, “Compatibility Check When a Table Is Opened”
Section 14.10.2.1, “Compatibility Check When InnoDB Is Started”

innodb_file_format_max

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_file_per_table

Section 14.1.2, “Best Practices for InnoDB Tables”
Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 10.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.17, “CREATE TABLE Statement”
Section 14.6.1.1, “Creating InnoDB Tables”
Section 14.6.1.2, “Creating Tables Externally”
Section 14.9.2, “Enabling Compression for a Table”
Section 14.10.1, “Enabling File Formats”
Section 14.12.2, “File Space Management”
Section 14.6.3.2, “File-Per-Table Tablespaces”
Section 13.1.17.2, “Files Created by CREATE TABLE”
Section 13.7.6.3, “FLUSH Statement”
Section 14.6.1.3, “Importing InnoDB Tables”
Section 14.2, “InnoDB and the ACID Model”
Section 14.6.2.3, “InnoDB FULLTEXT Indexes”
Section 14.11, “InnoDB Row Formats”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.17.4, “InnoDB Tablespace Monitor Output”
MySQL Glossary
Section 13.7.2.4, “OPTIMIZE TABLE Statement”
Section 14.12.5, “Reclaiming Disk Space with TRUNCATE TABLE”
Section 17.3.5, “Replicating Different Databases to Different Slaves”
Section 19.6, “Restrictions and Limitations on Partitioning”
Section 14.9.7, “SQL Compression Syntax Warnings and Errors”
Section 14.21.3, “Troubleshooting InnoDB Data Dictionary Operations”

innodb_flush_log_at_timeout

Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.5.4, “Log Buffer”

innodb_flush_log_at_trx_commit

Section 17.1.4.4, “Binary Log Options and Variables”
Section 14.2, “InnoDB and the ACID Model”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.5.4, “Log Buffer”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 17.4.1.26, “Replication and Master or Slave Shutdowns”
Section 14.20.5.3, “Tuning InnoDB memcached Plugin Performance”

innodb_flush_method

Section 14.6.3.2, “File-Per-Table Tablespaces”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 2.3, “Installing MySQL on Microsoft Windows”
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 5.1.9, “Server Status Variables”
Section 14.20.5.3, “Tuning InnoDB memcached Plugin Performance”

innodb_flush_neighbors

Section 14.8.3.4, “Configuring Buffer Pool Flushing”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_flushing_avg_loops

Section 14.8.3.4, “Configuring Buffer Pool Flushing”

innodb_force_load_corrupted

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_force_recovery

Section 13.1.28, “DROP TABLE Statement”
Section 14.21.2, “Forcing InnoDB Recovery”
Section 1.7, “How to Report Bugs or Problems”
Section 14.18.2, “InnoDB Recovery”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 2.11.10, “Rebuilding or Repairing Tables or Indexes”

innodb_ft_aux_table

Section 14.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 21.30.7, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”
Section 21.30.8, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”
Section 21.30.10, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”
Section 21.30.11, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”
Section 21.30.12, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

innodb_ft_cache_size

Section 14.6.2.3, “InnoDB FULLTEXT Indexes”
Section 14.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 21.30.11, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”

innodb_ft_enable_diag_print

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_ft_enable_stopword

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

innodb_ft_max_token_size

Section 12.9.2, “Boolean Full-Text Searches”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 12.9.4, “Full-Text Stopwords”
Section 14.14, “InnoDB Startup Options and System Variables”

innodb_ft_min_token_size

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

innodb_ft_num_word_optimize

Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 13.7.2.4, “OPTIMIZE TABLE Statement”

innodb_ft_result_cache_limit

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_ft_server_stopword_table

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

innodb_ft_sort_pll_degree

Section 14.6.2.3, “InnoDB FULLTEXT Indexes”
Section 14.14, “InnoDB Startup Options and System Variables”

innodb_ft_total_cache_size

Section 14.6.2.3, “InnoDB FULLTEXT Indexes”
Section 14.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 21.30.11, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”

innodb_ft_user_stopword_table

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

innodb_io_capacity

Section 14.8.3.4, “Configuring Buffer Pool Flushing”
Section 14.8.8, “Configuring InnoDB I/O Capacity”
Section 14.14, “InnoDB Startup Options and System Variables”
Section A.16, “MySQL 5.6 FAQ: InnoDB Change Buffer”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_io_capacity_max

Section 14.8.3.4, “Configuring Buffer Pool Flushing”
Section 14.8.8, “Configuring InnoDB I/O Capacity”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_large_prefix

Section 8.3.4, “Column Indexes”
Section 10.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”
Section 13.1.13, “CREATE INDEX Statement”
Section 13.1.17, “CREATE TABLE Statement”
Section 2.12.3, “Downgrade Notes”
Section 14.10, “InnoDB File-Format Management”
Section 14.22, “InnoDB Limits”
Section 14.11, “InnoDB Row Formats”
MySQL Glossary

innodb_lock_wait_timeout

Section 14.7.5.2, “Deadlock Detection and Rollback”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 17.4.1.30, “Replication Retries and Timeouts”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section B.3.1, “Server Error Message Reference”

innodb_locks_unsafe_for_binlog

Section 14.7.2.3, “Consistent Nonlocking Reads”
Section 14.7.1, “InnoDB Locking”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.7.3, “Locks Set by Different SQL Statements in InnoDB”
MySQL Glossary
Section 14.7.2.1, “Transaction Isolation Levels”

innodb_log_buffer_size

Section 14.8.1, “InnoDB Startup Configuration”
Section 14.5.4, “Log Buffer”
MySQL Glossary
Section 8.5.4, “Optimizing InnoDB Redo Logging”

innodb_log_compressed_pages

Section 14.9.6, “Compression for OLTP Workloads”
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 1.4, “What Is New in MySQL 5.6”

innodb_log_file_size

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.8.3.4, “Configuring Buffer Pool Flushing”
Section 14.8.2, “Configuring InnoDB for Read-Only Operation”
Section 2.12.3, “Downgrade Notes”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 14.6.6, “Redo Log”
Section 5.1.8, “Using System Variables”
Section 1.4, “What Is New in MySQL 5.6”

innodb_log_files_in_group

Section 2.11.3, “Changes in MySQL 5.6”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 14.6.6, “Redo Log”
Section 1.4, “What Is New in MySQL 5.6”

innodb_log_group_home_dir

Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”

innodb_lru_scan_depth

Section 14.8.3.4, “Configuring Buffer Pool Flushing”

innodb_max_dirty_pages_pct

Section 14.8.3.4, “Configuring Buffer Pool Flushing”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Disk I/O”

innodb_max_dirty_pages_pct_lwm

Section 14.8.3.4, “Configuring Buffer Pool Flushing”

innodb_max_purge_lag

Section 14.3, “InnoDB Multi-Versioning”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.8.10, “Purge Configuration”

innodb_max_purge_lag_delay

Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.8.10, “Purge Configuration”

innodb_monitor_disable

Section 14.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 21.30.15, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_monitor_enable

Section 14.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 21.30.15, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_monitor_reset

Section 14.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 21.30.15, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_monitor_reset_all

Section 14.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”
Section 21.30.15, “The INFORMATION_SCHEMA INNODB_METRICS Table”

innodb_old_blocks_pct

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

innodb_old_blocks_time

Section 14.5.1, “Buffer Pool”
Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.8.3.2, “Making the Buffer Pool Scan Resistant”

innodb_online_alter_log_max_size

MySQL Glossary
Section 14.13.5, “Online DDL Failure Conditions”
Section 14.13.3, “Online DDL Space Requirements”

innodb_open_files

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 5.1.7, “Server System Variables”

innodb_optimize_fulltext_only

Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 14.6.2.3, “InnoDB FULLTEXT Indexes”
Section 14.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
Section 13.7.2.4, “OPTIMIZE TABLE Statement”
Section 21.30.12, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”

innodb_page_cleaners

MySQL Glossary

innodb_page_size

Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.17, “CREATE TABLE Statement”
Section 2.12.3, “Downgrade Notes”
Section 14.9.2, “Enabling Compression for a Table”
Section 14.8.11.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 14.12.2, “File Space Management”
Section 14.9.5, “How Compression Works for InnoDB Tables”
Section 14.6.1.3, “Importing InnoDB Tables”
Section 14.22, “InnoDB Limits”
Section 14.23, “InnoDB Restrictions and Limitations”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 8.4.7, “Limits on Table Column Count and Row Size”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 14.6.2.2, “The Physical Structure of an InnoDB Index”
Section 14.6.3.1, “The System Tablespace”
Section 14.20.8, “Troubleshooting the InnoDB memcached Plugin”
Section 14.6.7, “Undo Logs”
Section 1.4, “What Is New in MySQL 5.6”

innodb_print_all_deadlocks

Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 14.7.5, “Deadlocks in InnoDB”
Section 14.7.5.3, “How to Minimize and Handle Deadlocks”
Section 14.21, “InnoDB Troubleshooting”

innodb_purge_batch_size

Section 14.8.10, “Purge Configuration”

innodb_purge_threads

Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.8.10, “Purge Configuration”

innodb_random_read_ahead

Section 14.8.3.3, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
MySQL Glossary

innodb_read_ahead_threshold

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

innodb_read_io_threads

Section 14.8.6, “Configuring the Number of Background InnoDB I/O Threads”
Section 14.17.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 24.1.1, “MySQL Threads”
Section 14.8.7, “Using Asynchronous I/O on Linux”

innodb_rollback_segments

Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 5.1.9, “Server Status Variables”
Section 14.6.7, “Undo Logs”
Section 14.6.3.3, “Undo Tablespaces”

innodb_saved_page_number_debug

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_sort_buffer_size

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

innodb_spin_wait_delay

Section 14.8.9, “Configuring Spin Lock Polling”

innodb_stats_auto_recalc

Section 14.8.11.1.1, “Configuring Automatic Statistics Calculation for Persistent Optimizer Statistics”
Section 14.8.11, “Configuring Optimizer Statistics for InnoDB”
Section 14.8.11.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 13.1.17, “CREATE TABLE Statement”
Section 14.8.11.1.6, “InnoDB Persistent Statistics Tables Example”

innodb_stats_include_delete_marked

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

innodb_stats_method

Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
MySQL Glossary

innodb_stats_on_metadata

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 14.8.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”

innodb_stats_persistent

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 14.8.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 14.8.11, “Configuring Optimizer Statistics for InnoDB”
Section 14.8.11.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 14.8.11.1, “Configuring Persistent Optimizer Statistics Parameters”
Section 13.1.13, “CREATE INDEX Statement”
Section 13.1.17, “CREATE TABLE Statement”
Section 14.8.11.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 8.5.10, “Optimizing InnoDB for Systems with Many Tables”

innodb_stats_persistent_sample_pages

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 14.8.11.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 14.8.11.1.3, “Configuring the Number of Sampled Pages for InnoDB Optimizer Statistics”
Section 14.8.11.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 14.14, “InnoDB Startup Options and System Variables”

innodb_stats_transient_sample_pages

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 14.8.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 14.8.11.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 14.14, “InnoDB Startup Options and System Variables”

innodb_status_output

Section 14.17.2, “Enabling InnoDB Monitors”
Section 1.4, “What Is New in MySQL 5.6”

innodb_status_output_locks

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

innodb_strict_mode

Section 13.1.17, “CREATE TABLE Statement”
Section 14.9.2, “Enabling Compression for a Table”
Section 14.9.5, “How Compression Works for InnoDB Tables”
Section 14.11, “InnoDB Row Formats”
Section 8.4.7, “Limits on Table Column Count and Row Size”
MySQL Glossary
Section 5.1.10, “Server SQL Modes”
Section 14.9.7, “SQL Compression Syntax Warnings and Errors”

innodb_support_xa

MySQL Glossary
Section 8.5.2, “Optimizing InnoDB Transaction Management”

innodb_table_locks

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

innodb_temp_data_file_path

MySQL Glossary

innodb_thread_concurrency

Section 14.8.5, “Configuring Thread Concurrency for InnoDB”
Section 14.17.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.14, “InnoDB Startup Options and System Variables”
Section A.15, “MySQL 5.6 FAQ: MySQL Enterprise Thread Pool”
Section 8.5.9, “Optimizing InnoDB Configuration Variables”

innodb_thread_sleep_delay

Section 14.8.5, “Configuring Thread Concurrency for InnoDB”
Section 14.14, “InnoDB Startup Options and System Variables”

innodb_tmpdir

Section 14.13.5, “Online DDL Failure Conditions”
Section 14.13.3, “Online DDL Space Requirements”

innodb_undo_directory

Section 14.8.2, “Configuring InnoDB for Read-Only Operation”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.6.3.3, “Undo Tablespaces”

innodb_undo_logs

Section 14.14, “InnoDB Startup Options and System Variables”

innodb_undo_tablespaces

Section 14.8.2, “Configuring InnoDB for Read-Only Operation”
Section 14.8.1, “InnoDB Startup Configuration”
Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.6.3.3, “Undo Tablespaces”

innodb_use_native_aio

Section 14.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Disk I/O”
Section 14.8.7, “Using Asynchronous I/O on Linux”

innodb_use_sys_malloc

Section 14.8.4, “Configuring the Memory Allocator for InnoDB”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 1.4, “What Is New in MySQL 5.6”

innodb_write_io_threads

Section 14.8.6, “Configuring the Number of Background InnoDB I/O Threads”
Section 14.17.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 24.1.1, “MySQL Threads”
Section 14.8.7, “Using Asynchronous I/O on Linux”

insert_id

Section 15.8.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.1.7, “Server System Variables”

interactive_timeout

Section B.4.2.11, “Communication Errors and Aborted Connections”
Section 23.7.6.53, “mysql_real_connect()”
Section 5.1.7, “Server System Variables”

J

join_buffer_size

Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”
Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 8.2.1.6, “Nested-Loop Join Algorithms”
Section 5.1.7, “Server System Variables”

K

keep_files_on_create

Section 5.1.7, “Server System Variables”

key_buffer_size

Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 5.1.1, “Configuring the Server”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 8.8.4, “Estimating Query Performance”
Section 8.12.4.1, “How MySQL Uses Memory”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 14.8.1, “InnoDB Startup Configuration”
Section B.4.7, “Known Issues in MySQL”
Section 8.10.2.2, “Multiple Key Caches”
Section 8.2.4.3, “Optimizing DELETE Statements”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 8.10.2.6, “Restructuring a Key Cache”
Section 5.1.6, “Server Command Options”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 5.1.8.3, “Structured System Variables”
Section 8.10.2, “The MyISAM Key Cache”

key_cache_age_threshold

Section 8.10.2.3, “Midpoint Insertion Strategy”
Section 5.1.7, “Server System Variables”
Section 5.1.8.3, “Structured System Variables”

key_cache_block_size

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

key_cache_division_limit

Section 8.10.2.3, “Midpoint Insertion Strategy”
Section 5.1.7, “Server System Variables”
Section 5.1.8.3, “Structured System Variables”

L

large_files_support

Section 19.6, “Restrictions and Limitations on Partitioning”
Section 5.1.7, “Server System Variables”

large_page_size

Section 5.1.7, “Server System Variables”

large_pages

Section 5.1.7, “Server System Variables”

last_insert_id

Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”

lc_messages

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

lc_messages_dir

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

lc_time_names

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

license

Section 5.1.7, “Server System Variables”

local

Section 13.2.7, “LOAD XML Statement”

local_infile

Section 13.2.6, “LOAD DATA Statement”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 5.1.7, “Server System Variables”

lock_wait_timeout

Section 5.1.7, “Server System Variables”

locked_in_memory

Section 5.1.7, “Server System Variables”

log

Section 14.14, “InnoDB Startup Options and System Variables”
Section 14.20.6, “The InnoDB memcached Plugin and Replication”

log_bin

Section 17.1.4.4, “Binary Log Options and Variables”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 5.4.4, “The Binary Log”
Section 1.4, “What Is New in MySQL 5.6”

log_bin_basename

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

log_bin_index

Section 17.1.4.4, “Binary Log Options and Variables”

log_bin_trust_function_creators

Section 17.1.4.4, “Binary Log Options and Variables”
Section A.4, “MySQL 5.6 FAQ: Stored Procedures and Functions”
Section 20.7, “Stored Program Binary Logging”

log_bin_use_v

Section 17.1.4.4, “Binary Log Options and Variables”
Section 18.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 18.6.11, “NDB Cluster Replication Conflict Resolution”
Section 17.4.2, “Replication Compatibility Between MySQL Versions”

log_error

Section 5.4.2.2, “Error Logging on Unix and Unix-Like Systems”
Section 5.4.2.1, “Error Logging on Windows”
Section 2.5.8.2, “More Topics on Deploying MySQL Server with Docker”
Section 5.1.7, “Server System Variables”

log_output

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

log_queries_not_using_indexes

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

log_slave_updates

Section 17.1.4.4, “Binary Log Options and Variables”
Section 17.3.6, “Improving Replication Performance”
Section 18.6.3, “Known Issues in NDB Cluster Replication”
Section 18.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 18.6.10, “NDB Cluster Replication: Multi-Master and Circular Replication”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.3.7, “Switching Masters During Failover”

log_slow_admin_statements

Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

log_slow_slave_statements

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.4.5, “The Slow Query Log”

log_throttle_queries_not_using_indexes

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

log_warnings

Section 5.4.2.4, “Error Log Filtering”
Section 22.12.8, “Performance Schema Connection Attribute Tables”
Section 22.15, “Performance Schema System Variables”
Section 5.1.7, “Server System Variables”

long_query_time

Section 5.4, “MySQL Server Logs”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

low_priority_updates

Section A.14, “MySQL 5.6 FAQ: Replication”
Section 5.1.7, “Server System Variables”
Section 8.11.2, “Table Locking Issues”
Section 1.4, “What Is New in MySQL 5.6”

lower_case_file_system

Section 5.1.7, “Server System Variables”

lower_case_table_names

Section 2.3.3.3.1.7, “Advanced Options”
Section 13.1.17.6, “FOREIGN KEY Constraints”
Section 13.7.1.4, “GRANT Statement”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 1.7, “How to Report Bugs or Problems”
Section 9.2.3, “Identifier Case Sensitivity”
Section 14.6.1.3, “Importing InnoDB Tables”
Section 17.4.1.35, “Replication and Variables”
Section 13.7.1.6, “REVOKE Statement”
Section 5.1.7, “Server System Variables”
Section 13.7.5.38, “SHOW TABLES Statement”
Section 21.30.16, “The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table”
Section 21.30.22, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”

M

master_info_repository

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 13.7.6.3, “FLUSH Statement”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.1.8, “Setting Up Replication with Existing Data”
Section 17.2.2.2, “Slave Status Logs”
Section 1.4, “What Is New in MySQL 5.6”

master_verify_checksum

Section 17.1.4.4, “Binary Log Options and Variables”
MySQL Glossary
Section 5.4.4, “The Binary Log”
Section 1.4, “What Is New in MySQL 5.6”

max_allowed_packet

Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”
Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section B.4.2.11, “Communication Errors and Aborted Connections”
Section 12.3.2, “Comparison Functions and Operators”
Section B.4.4.6, “Deleting Rows from Related Tables”
Section 8.12.4.1, “How MySQL Uses Memory”
Section B.4.2.3, “Lost connection to MySQL server”
Section 23.7, “MySQL C API”
Section B.4.2.9, “MySQL server has gone away”
Section 23.7.10.26, “mysql_stmt_send_long_data()”
Section 23.7.6.72, “mysql_use_result()”
Section 18.6.11, “NDB Cluster Replication Conflict Resolution”
Section B.4.2.10, “Packet Too Large”
Section 17.4.1.19, “Replication and max_allowed_packet”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.7, “Server System Variables”
Section 12.7, “String Functions and Operators”
Section 11.3.4, “The BLOB and TEXT Types”
Section 1.4, “What Is New in MySQL 5.6”

max_binlog_cache_size

Section 17.1.4.4, “Binary Log Options and Variables”
Section 5.4.4, “The Binary Log”

max_binlog_size

Section 17.1.4.4, “Binary Log Options and Variables”
Section 5.4, “MySQL Server Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.4.7, “Server Log Maintenance”
Section 5.4.4, “The Binary Log”
Section 17.2.2.1, “The Slave Relay Log”

max_binlog_stmt_cache_size

Section 17.1.4.4, “Binary Log Options and Variables”

max_connect_errors

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 8.12.5.2, “DNS Lookup Optimization and the Host Cache”
Section 13.7.6.3, “FLUSH Statement”
Section B.4.2.6, “Host 'host_name' is blocked”
Section 5.1.7, “Server System Variables”
Section 22.12.10.1, “The host_cache Table”
Section 1.4, “What Is New in MySQL 5.6”

max_connections

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 24.5.1.4, “Debugging mysqld under gdb”
Section B.4.2.18, “File Not Found and Similar Errors”
Section 8.12.5.1, “How MySQL Handles Client Connections”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 22.15, “Performance Schema System Variables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 5.5.3.3, “Thread Pool Operation”
Section B.4.2.7, “Too many connections”

max_delayed_threads

Section 5.1.7, “Server System Variables”

max_digest_length

Section 8.12.4.1, “How MySQL Uses Memory”
Section 6.4.5.4, “MySQL Enterprise Firewall Reference”
Section 22.10, “Performance Schema Statement Digests”
Section 22.15, “Performance Schema System Variables”
Section 5.1.7, “Server System Variables”
Section 22.12.6.1, “The events_statements_current Table”
Section 6.4.5.3, “Using MySQL Enterprise Firewall”

max_error_count

Section 13.2.6, “LOAD DATA Statement”
Section 13.6.7.4, “RESIGNAL Statement”
Section 5.1.7, “Server System Variables”
Section 13.7.5.18, “SHOW ERRORS Statement”
Section 13.7.5.41, “SHOW WARNINGS Statement”
Section 13.6.7.7, “The MySQL Diagnostics Area”

max_heap_table_size

Section 8.12.4.1, “How MySQL Uses Memory”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 8.4.6, “Limits on Table Size”
Section 17.4.1.20, “Replication and MEMORY Tables”
Section 17.4.1.35, “Replication and Variables”
Section 13.6.6.5, “Restrictions on Server-Side Cursors”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 15.3, “The MEMORY Storage Engine”

max_insert_delayed_threads

Section 5.1.7, “Server System Variables”

max_join_size

Section 8.8.2, “EXPLAIN Output Format”
Section 4.5.1.6, “mysql Client Tips”
Section 5.1.7, “Server System Variables”
Section 13.7.4.1, “SET Syntax for Variable Assignment”
Section 1.4, “What Is New in MySQL 5.6”

max_length_for_sort_data

Section 8.2.1.13, “ORDER BY Optimization”
Section 5.1.7, “Server System Variables”

max_prepared_stmt_count

Section 8.10.4, “Caching of Prepared Statements and Stored Programs”
Section 13.5.3, “DEALLOCATE PREPARE Statement”
Section 13.5, “Prepared Statements”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”

max_relay_log_size

Section 17.1.4.4, “Binary Log Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.1, “The Slave Relay Log”

max_seeks_for_key

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 5.1.7, “Server System Variables”

max_sort_length

Section B.4.7, “Known Issues in MySQL”
Section 8.2.1.13, “ORDER BY Optimization”
Section 13.2.9, “SELECT Statement”
Section 5.1.7, “Server System Variables”
Section 11.3.4, “The BLOB and TEXT Types”

max_sp_recursion_depth

Section 5.1.7, “Server System Variables”
Section 20.2.1, “Stored Routine Syntax”

max_tmp_tables

Section 5.1.7, “Server System Variables”

max_user_connections

Section 13.7.6.3, “FLUSH Statement”
Section 13.7.1.4, “GRANT Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 5.1.7, “Server System Variables”
Section 6.2.13, “Setting Account Resource Limits”

max_write_lock_count

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

metadata_locks_cache_size

Section 5.1.7, “Server System Variables”

metadata_locks_hash_instances

Section 5.1.7, “Server System Variables”

min_examined_row_limit

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

multi_range_count

Section 5.1.7, “Server System Variables”

myisam_data_pointer_size

Section 13.1.17, “CREATE TABLE Statement”
Section 8.4.6, “Limits on Table Size”
Section 5.1.7, “Server System Variables”

myisam_max_sort_file_size

Section 15.2.1, “MyISAM Startup Options”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 19.6, “Restrictions and Limitations on Partitioning”
Section 5.1.7, “Server System Variables”

myisam_mmap_size

Section 5.1.7, “Server System Variables”

myisam_recover_options

Section 15.2.1, “MyISAM Startup Options”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 5.1.7, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section B.4.2.19, “Table-Corruption Issues”
Section 15.2, “The MyISAM Storage Engine”
Section 24.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”

myisam_repair_threads

Section 5.1.7, “Server System Variables”

myisam_sort_buffer_size

Section 13.1.7, “ALTER TABLE Statement”
Section 15.2.1, “MyISAM Startup Options”
Section 4.6.3.1, “myisamchk General Options”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 5.1.7, “Server System Variables”

myisam_stats_method

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

myisam_use_mmap

Section 8.12.4.1, “How MySQL Uses Memory”
Section 5.1.7, “Server System Variables”

mysql_firewall_max_query_size

Section 6.4.5.4, “MySQL Enterprise Firewall Reference”

mysql_firewall_mode

Section 6.4.5.4, “MySQL Enterprise Firewall Reference”
Section 6.4.5.3, “Using MySQL Enterprise Firewall”

mysql_firewall_trace

Section 6.4.5.4, “MySQL Enterprise Firewall Reference”
Section 6.4.5.3, “Using MySQL Enterprise Firewall”

N

named_pipe

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

named_pipe_full_access_group

Section 4.2.3, “Command Options for Connecting to the Server”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 4.5.1.1, “mysql Client Options”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

ndb_autoincrement_prefetch_sz

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_cache_check_time

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_clear_apply_status

Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 13.4.2.3, “RESET SLAVE Statement”

ndb_deferred_constraints

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_distribution

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_eventbuffer_free_percent

Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 18.1.4.2, “What is New in NDB Cluster 7.4”

ndb_eventbuffer_max_alloc

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_extra_logging

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_force_send

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_index_stat_cache_entries

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_index_stat_enable

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_index_stat_option

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_index_stat_update_freq

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_join_pushdown

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

ndb_log_apply_status

Section 18.6.10, “NDB Cluster Replication: Multi-Master and Circular Replication”
Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_log_bin

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_log_binlog_index

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_log_empty_epochs

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_log_empty_update

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_log_exclusive_reads

Section 18.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 18.6.11, “NDB Cluster Replication Conflict Resolution”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 18.1.4.2, “What is New in NDB Cluster 7.4”

ndb_log_orig

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_log_transaction_id

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_optimized_node_selection

Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 18.3.3.9, “NDB Cluster TCP/IP Connections”
Section 18.5.6.3, “Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client”

ndb_recv_thread_activation_threshold

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_recv_thread_cpu_mask

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_report_thresh_binlog_epoch_slip

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_report_thresh_binlog_mem_usage

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_show_foreign_key_mock_tables

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_slave_conflict_role

Section 18.6.11, “NDB Cluster Replication Conflict Resolution”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 18.1.4, “What is New in MySQL NDB Cluster”
Section 18.1.4.2, “What is New in NDB Cluster 7.4”

ndb_table_no_logging

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_table_temporary

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_use_copying_alter_table

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_use_exact_count

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_use_transactions

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_version

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndb_version_string

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndbinfo_database

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndbinfo_max_bytes

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndbinfo_max_rows

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndbinfo_offline

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndbinfo_show_hidden

Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 18.5.10.4, “The ndbinfo cluster_operations Table”
Section 18.5.10.5, “The ndbinfo cluster_transactions Table”
Section 18.5.10.22, “The ndbinfo server_operations Table”
Section 18.5.10.23, “The ndbinfo server_transactions Table”

ndbinfo_table_prefix

Section 18.3.3.8.2, “NDB Cluster System Variables”

ndbinfo_version

Section 18.3.3.8.2, “NDB Cluster System Variables”

net_buffer_length

Section 8.12.4.1, “How MySQL Uses Memory”
Section 23.7, “MySQL C API”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.7, “Server System Variables”

net_read_timeout

Section B.4.2.3, “Lost connection to MySQL server”
Section 5.1.7, “Server System Variables”

net_retry_count

Section 5.1.7, “Server System Variables”

net_write_timeout

Section 5.1.7, “Server System Variables”

new

Section 19.6.2, “Partitioning Limitations Relating to Storage Engines”
Section 5.1.7, “Server System Variables”

O

old

Section 8.9.3, “Index Hints”
Section 5.1.7, “Server System Variables”

old_alter_table

Section 13.1.7, “ALTER TABLE Statement”
Section 14.13, “InnoDB and Online DDL”
Section 14.13.2, “Online DDL Performance and Concurrency”
Section 13.7.2.4, “OPTIMIZE TABLE Statement”
Section 5.1.7, “Server System Variables”
Section 14.13.4, “Simplifying DDL Statements with Online DDL”

old_passwords

Section 13.7.1.1, “ALTER USER Statement”
Section 6.2.9, “Assigning Account Passwords”
Section 2.11.3, “Changes in MySQL 5.6”
Section B.4.2.4, “Client does not support authentication protocol”
Section 13.7.1.2, “CREATE USER Statement”
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.1.2.4, “Password Hashing in MySQL”
Section 5.1.6, “Server Command Options”
Section 6.2.10, “Server Handling of Expired Passwords”
Section 5.1.7, “Server System Variables”
Section 13.7.1.7, “SET PASSWORD Statement”
Section 6.4.1.4, “SHA-256 Pluggable Authentication”
Section 1.4, “What Is New in MySQL 5.6”

open_files_limit

Section 5.1.2.1, “Changes to Server Defaults”
Section B.4.2.18, “File Not Found and Similar Errors”
Section 8.12.5.1, “How MySQL Handles Client Connections”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 22.15, “Performance Schema System Variables”
Section 19.6, “Restrictions and Limitations on Partitioning”
Section 5.1.7, “Server System Variables”

optimizer_prune_level

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

optimizer_search_depth

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

optimizer_switch

Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”
Section 8.2.1.4, “Engine Condition Pushdown Optimization”
Section 8.2.1.5, “Index Condition Pushdown Optimization”
Section 8.2.1.3, “Index Merge Optimization”
Section 8.2.1.10, “Multi-Range Read Optimization”
Section 8.2.2.2, “Optimizing Subqueries with Materialization”
Section 8.2.2.1, “Optimizing Subqueries with Semijoin Transformations”
Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section 5.1.7, “Server System Variables”
Section 8.9.2, “Switchable Optimizations”
Section 13.2.11, “UPDATE Statement”
Section 8.3.9, “Use of Index Extensions”
Section 1.4, “What Is New in MySQL 5.6”

optimizer_trace

Section 5.1.7, “Server System Variables”
Section 21.12, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

optimizer_trace_features

Section 5.1.7, “Server System Variables”

optimizer_trace_limit

Section 5.1.7, “Server System Variables”

optimizer_trace_max_mem_size

Section 5.1.7, “Server System Variables”
Section 21.12, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”

optimizer_trace_offset

Section 5.1.7, “Server System Variables”

P

performance_schema

Section 5.1.2.1, “Changes to Server Defaults”
Section 22.1, “Performance Schema Quick Start”
Section 22.3, “Performance Schema Startup Configuration”
Section 22.15, “Performance Schema System Variables”

performance_schema_accounts_size

Section 22.15, “Performance Schema System Variables”
Section 22.12.7.1, “The accounts Table”

performance_schema_digests_size

Section 22.10, “Performance Schema Statement Digests”
Section 22.16, “Performance Schema Status Variables”
Section 22.15, “Performance Schema System Variables”
Section 22.12.9.3, “Statement Summary Tables”

performance_schema_events_stages_history_long_size

Section 22.15, “Performance Schema System Variables”
Section 22.12.5.3, “The events_stages_history_long Table”

performance_schema_events_stages_history_size

Section 22.15, “Performance Schema System Variables”
Section 22.18.1, “Query Profiling Using Performance Schema”
Section 22.12.5.2, “The events_stages_history Table”

performance_schema_events_statements_history_long_size

Section 22.15, “Performance Schema System Variables”
Section 22.12.6.3, “The events_statements_history_long Table”

performance_schema_events_statements_history_size

Section 22.15, “Performance Schema System Variables”
Section 22.18.1, “Query Profiling Using Performance Schema”
Section 22.12.6.2, “The events_statements_history Table”

performance_schema_events_waits_history_long_size

Section 5.1.2.1, “Changes to Server Defaults”
Section 22.15, “Performance Schema System Variables”
Section 22.12, “Performance Schema Table Descriptions”
Section 13.7.5.16, “SHOW ENGINE Statement”
Section 22.12.4.3, “The events_waits_history_long Table”

performance_schema_events_waits_history_size

Section 5.1.2.1, “Changes to Server Defaults”
Section 22.15, “Performance Schema System Variables”
Section 22.12, “Performance Schema Table Descriptions”
Section 13.7.5.16, “SHOW ENGINE Statement”
Section 22.12.4.2, “The events_waits_history Table”

performance_schema_hosts_size

Section 22.15, “Performance Schema System Variables”
Section 22.12.7.2, “The hosts Table”

performance_schema_max_cond_classes

Section 22.15, “Performance Schema System Variables”

performance_schema_max_cond_instances

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

performance_schema_max_digest_length

Section 22.10, “Performance Schema Statement Digests”
Section 22.15, “Performance Schema System Variables”
Section 5.1.7, “Server System Variables”
Section 22.12.6.1, “The events_statements_current Table”

performance_schema_max_file_classes

Section 22.15, “Performance Schema System Variables”

performance_schema_max_file_handles

Section 22.15, “Performance Schema System Variables”

performance_schema_max_file_instances

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

performance_schema_max_mutex_classes

Section 22.7, “Performance Schema Status Monitoring”
Section 22.15, “Performance Schema System Variables”

performance_schema_max_mutex_instances

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

performance_schema_max_rwlock_classes

Section 22.15, “Performance Schema System Variables”

performance_schema_max_rwlock_instances

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

performance_schema_max_socket_classes

Section 22.15, “Performance Schema System Variables”

performance_schema_max_socket_instances

Section 22.15, “Performance Schema System Variables”

performance_schema_max_stage_classes

Section 22.15, “Performance Schema System Variables”

performance_schema_max_statement_classes

Section 22.15, “Performance Schema System Variables”

performance_schema_max_table_handles

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

performance_schema_max_table_instances

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

performance_schema_max_thread_classes

Section 22.15, “Performance Schema System Variables”

performance_schema_max_thread_instances

Section 5.1.2.1, “Changes to Server Defaults”
Section 22.16, “Performance Schema Status Variables”
Section 22.15, “Performance Schema System Variables”
Section 13.7.5.16, “SHOW ENGINE Statement”

performance_schema_session_connect_attrs_size

Section 22.12.8, “Performance Schema Connection Attribute Tables”
Section 22.16, “Performance Schema Status Variables”
Section 22.15, “Performance Schema System Variables”

performance_schema_setup_actors_size

Section 22.15, “Performance Schema System Variables”
Section 22.12.2.1, “The setup_actors Table”

performance_schema_setup_objects_size

Section 22.15, “Performance Schema System Variables”
Section 22.12.2.4, “The setup_objects Table”

performance_schema_users_size

Section 22.15, “Performance Schema System Variables”
Section 22.12.7.3, “The users Table”

pid

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

pid_file

Section 5.1.7, “Server System Variables”

plugin_dir

Section 24.4.2, “Adding a User-Defined Function”
Section 6.1.2.2, “Administrator Guidelines for Password Security”
Section 24.2.4.3, “Compiling and Installing Plugin Libraries”
Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.7.3.3, “INSTALL PLUGIN Statement”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section 6.4.4.1, “Installing MySQL Enterprise Audit”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 12.18.1, “MySQL Enterprise Encryption Installation”
Section 5.6.2, “Obtaining User-Defined Function Information”
Section 6.4.1.6, “PAM Pluggable Authentication”
Section 6.4.3.1, “Password Validation Plugin Installation”
Section 6.2.11, “Pluggable Authentication”
Section 15.11.1, “Pluggable Storage Engine Architecture”
Section 24.2.3, “Plugin API Components”
Section 17.3.9.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 14.20.3, “Setting Up the InnoDB memcached Plugin”
Section 13.7.5.26, “SHOW PLUGINS Statement”
Section 6.4.1.8, “Socket Peer-Credential Pluggable Authentication”
Section 6.4.1.9, “Test Pluggable Authentication”
Section 21.15, “The INFORMATION_SCHEMA PLUGINS Table”
Section 5.5.3.2, “Thread Pool Installation”
Section 24.2.4.9.3, “Using the Authentication Plugins”
Section 6.4.1.7, “Windows Pluggable Authentication”
Section 24.2.4.8, “Writing Audit Plugins”
Section 24.2.4.5, “Writing Daemon Plugins”
Section 24.2.4.4, “Writing Full-Text Parser Plugins”
Section 24.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 24.2.4.10, “Writing Password-Validation Plugins”
Section 24.2.4.7, “Writing Semisynchronous Replication Plugins”

port

Section B.4.2.2, “Can't connect to [local] MySQL server”
Section 5.1.7, “Server System Variables”

preload_buffer_size

Section 5.1.7, “Server System Variables”

profiling

Section 5.1.7, “Server System Variables”
Section 13.7.5.31, “SHOW PROFILE Statement”
Section 21.17, “The INFORMATION_SCHEMA PROFILING Table”
Section 1.4, “What Is New in MySQL 5.6”

profiling_history_size

Section 5.1.7, “Server System Variables”
Section 13.7.5.31, “SHOW PROFILE Statement”
Section 1.4, “What Is New in MySQL 5.6”

protocol_version

Section 5.1.7, “Server System Variables”

proxy_user

Section 6.2.12, “Proxy Users”
Section 5.1.7, “Server System Variables”

pseudo_slave_mode

Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.1.7, “Server System Variables”

pseudo_thread_id

Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”

Q

query_alloc_block_size

Section 5.1.7, “Server System Variables”

query_cache_limit

Section 8.10.3.3, “Query Cache Configuration”
Section 5.1.7, “Server System Variables”

query_cache_min_res_unit

Section 8.10.3.3, “Query Cache Configuration”
Section 5.1.7, “Server System Variables”

query_cache_size

Section 5.1.2.1, “Changes to Server Defaults”
Section 8.10.3.3, “Query Cache Configuration”
Section 5.1.7, “Server System Variables”
Section 8.10.3, “The MySQL Query Cache”

query_cache_type

Section 5.1.2.1, “Changes to Server Defaults”
Section 8.10.3.3, “Query Cache Configuration”
Section 8.10.3.2, “Query Cache SELECT Options”
Section 13.2.9, “SELECT Statement”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”

query_cache_wlock_invalidate

Section 5.1.7, “Server System Variables”

query_prealloc_size

Section 5.1.7, “Server System Variables”

R

rand_seed

Section 5.1.7, “Server System Variables”

range_alloc_block_size

Section 5.1.7, “Server System Variables”

read_buffer_size

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

read_only

Section 13.7.1, “Account Management Statements”
Section 13.7.1.1, “ALTER USER Statement”
Section 6.2.9, “Assigning Account Passwords”
Section 17.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
Section 13.7.1.2, “CREATE USER Statement”
Section 17.1.3.5, “Disabling GTID Transactions”
Section 13.7.1.3, “DROP USER Statement”
Section 8.14.2, “General Thread States”
Section 13.7.1.4, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.7.1.5, “RENAME USER Statement”
Section 17.4.1.35, “Replication and Variables”
Section 13.7.1.6, “REVOKE Statement”
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.7, “Server System Variables”
Section 13.7.1.7, “SET PASSWORD Statement”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”

read_rnd_buffer_size

Section 5.1.1, “Configuring the Server”
Section 8.12.4.1, “How MySQL Uses Memory”
Section 8.2.1.10, “Multi-Range Read Optimization”
Section 8.2.1.13, “ORDER BY Optimization”
Section 5.1.7, “Server System Variables”

relay_log

Section 17.3.6, “Improving Replication Performance”
Section 17.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.1, “The Slave Relay Log”

relay_log_basename

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 1.4, “What Is New in MySQL 5.6”

relay_log_index

Section 17.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.1, “The Slave Relay Log”

relay_log_info_file

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”

relay_log_info_repository

Section 13.7.6.3, “FLUSH Statement”
Section 17.3.2, “Handling an Unexpected Halt of a Replication Slave”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.2.2.2, “Slave Status Logs”
Section 1.4, “What Is New in MySQL 5.6”

relay_log_purge

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”

relay_log_recovery

Section 17.3.2, “Handling an Unexpected Halt of a Replication Slave”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.4.2.5, “START SLAVE Statement”

relay_log_space_limit

Section 8.14.6, “Replication Slave I/O Thread States”
Section 17.1.4.3, “Replication Slave Options and Variables”

report_host

Section 17.1.4.3, “Replication Slave Options and Variables”

report_password

Section 17.1.4.3, “Replication Slave Options and Variables”

report_port

Section 17.1.4.3, “Replication Slave Options and Variables”

report_user

Section 17.1.4.3, “Replication Slave Options and Variables”

rpl_semi_sync_master_enabled

Section 17.1.4.2, “Replication Master Options and Variables”
Section 17.3.9.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.9.2, “Semisynchronous Replication Installation and Configuration”
Section 17.3.9.3, “Semisynchronous Replication Monitoring”

rpl_semi_sync_master_timeout

Section 17.1.4.2, “Replication Master Options and Variables”
Section 17.3.9.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.9.2, “Semisynchronous Replication Installation and Configuration”

rpl_semi_sync_master_trace_level

Section 17.1.4.2, “Replication Master Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”

rpl_semi_sync_master_wait_no_slave

Section 17.1.4.2, “Replication Master Options and Variables”

rpl_semi_sync_slave_enabled

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.3.9.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.9.2, “Semisynchronous Replication Installation and Configuration”

rpl_semi_sync_slave_trace_level

Section 17.1.4.3, “Replication Slave Options and Variables”

rpl_stop_slave_timeout

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.4.2.6, “STOP SLAVE Statement”

S

secure_auth

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

secure_file_priv

Section 2.10.1, “Initializing the Data Directory”
Section 13.2.6, “LOAD DATA Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.2.9.1, “SELECT ... INTO Statement”
Section 5.1.7, “Server System Variables”
Section B.4.2.2.1, “Set SELinux context for MySQL Server”
Section 12.7, “String Functions and Operators”

server_id

Section 2.3.3.3.1.7, “Advanced Options”
Section 6.4.4.3, “Audit Log File Formats”
Section 17.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 12.20, “Miscellaneous Functions”
Section 18.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 18.6.11, “NDB Cluster Replication Conflict Resolution”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 17.1.4, “Replication and Binary Logging Options and Variables”
Section 17.1, “Replication Configuration”
Section 17.1.4.2, “Replication Master Options and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.1.1, “Setting the Replication Master Configuration”
Section 17.1.1.2, “Setting the Replication Slave Configuration”
Section 17.1.1.8, “Setting Up Replication with Existing Data”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”
Section 17.4.4, “Troubleshooting Replication”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

server_id_bits

Section 18.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 18.3.3.8.2, “NDB Cluster System Variables”

server_uuid

Section 17.1.3.1, “GTID Concepts”
Section 17.1.4, “Replication and Binary Logging Options and Variables”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”
Section 13.4.2.5, “START SLAVE Statement”

sha

Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 6.4.1.4, “SHA-256 Pluggable Authentication”
Section 6.3.4, “SSL Library-Dependent Capabilities”

shared_memory

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

shared_memory_base_name

Section 23.7.6.49, “mysql_options()”
Section 5.1.7, “Server System Variables”
Section 5.7.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”

show_old_temporals

Section 2.11.3, “Changes in MySQL 5.6”
Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 5.1.7, “Server System Variables”

simplified_binlog_gtid_recovery

Section 17.1.4.5, “Global Transaction ID Options and Variables”

skip_external_locking

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

skip_name_resolve

Section 8.12.5.2, “DNS Lookup Optimization and the Host Cache”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 5.1.7, “Server System Variables”
Section 2.3.4.8, “Testing The MySQL Installation”
Section 6.2.14, “Troubleshooting Problems Connecting to MySQL”

skip_networking

Section B.4.2.2, “Can't connect to [local] MySQL server”
Section 8.12.5.2, “DNS Lookup Optimization and the Host Cache”
Section A.14, “MySQL 5.6 FAQ: Replication”
Section B.4.2.9, “MySQL server has gone away”
Section 6.2.11, “Pluggable Authentication”
Section B.4.3.2.3, “Resetting the Root Password: Generic Instructions”
Section 5.1.7, “Server System Variables”
Section 17.1.1.1, “Setting the Replication Master Configuration”
Section 6.2.14, “Troubleshooting Problems Connecting to MySQL”
Section 17.4.4, “Troubleshooting Replication”
Section 17.4.3, “Upgrading a Replication Setup”

skip_show_database

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

slave_allow_batching

Section 18.3.3.8.2, “NDB Cluster System Variables”
Section 18.6.6, “Starting NDB Cluster Replication (Single Replication Channel)”

slave_checkpoint_group

Section 18.6.3, “Known Issues in NDB Cluster Replication”
Section 12.20, “Miscellaneous Functions”
Section 17.1.4.3, “Replication Slave Options and Variables”

slave_checkpoint_period

Section 12.20, “Miscellaneous Functions”
Section 17.1.4.3, “Replication Slave Options and Variables”

slave_compressed_protocol

Section 4.2.5, “Connection Compression Control”
Section 17.1.4.3, “Replication Slave Options and Variables”

slave_exec_mode

Section 18.6.3, “Known Issues in NDB Cluster Replication”
Section 17.4.1.20, “Replication and MEMORY Tables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

slave_load_tmpdir

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section B.4.3.5, “Where MySQL Stores Temporary Files”

slave_max_allowed_packet

Section 17.1.4.3, “Replication Slave Options and Variables”

slave_net_timeout

Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 17.1.5.1, “Checking Replication Status”
Section 17.4.1.26, “Replication and Master or Slave Shutdowns”
Section 8.14.6, “Replication Slave I/O Thread States”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.7, “Server System Variables”

slave_parallel_workers

Section 18.6.3, “Known Issues in NDB Cluster Replication”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 8.14.7, “Replication Slave SQL Thread States”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”
Section 13.4.2.5, “START SLAVE Statement”
Section 1.4, “What Is New in MySQL 5.6”

slave_pending_jobs_size_max

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 8.14.7, “Replication Slave SQL Thread States”

slave_rows_search_algorithms

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.9, “Server Status Variables”

slave_skip_errors

Section 17.1.4.3, “Replication Slave Options and Variables”

slave_sql_verify_checksum

MySQL Glossary
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.4.4, “The Binary Log”

slave_transaction_retries

Section 17.4.1.30, “Replication Retries and Timeouts”
Section 17.1.4.3, “Replication Slave Options and Variables”

slave_type_conversions

Section 18.6.3, “Known Issues in NDB Cluster Replication”
Section 17.1.4.3, “Replication Slave Options and Variables”

slow_launch_time

Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”

slow_query_log

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.7, “Server System Variables”
Section 5.4.5, “The Slow Query Log”
Section 1.4, “What Is New in MySQL 5.6”

slow_query_log_file

Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.7, “Server System Variables”
Section 5.4.5, “The Slow Query Log”
Section 1.4, “What Is New in MySQL 5.6”

socket

Section 5.1.7, “Server System Variables”

sort_buffer_size

Section 7.6.3, “How to Repair MyISAM Tables”
Section 8.2.1.13, “ORDER BY Optimization”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 13.7.4.1, “SET Syntax for Variable Assignment”
Section 1.4, “What Is New in MySQL 5.6”

sql_auto_is_null

Section 12.3.2, “Comparison Functions and Operators”
Section 13.1.17, “CREATE TABLE Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 5.4.4, “The Binary Log”

sql_big_selects

Section 5.1.7, “Server System Variables”

sql_buffer_result

Section 5.1.7, “Server System Variables”

sql_log_bin

Section 17.1.4.4, “Binary Log Options and Variables”
Section 18.1.7.8, “Issues Exclusive to NDB Cluster”
Section 18.6.3, “Known Issues in NDB Cluster Replication”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 18.1.7.1, “Noncompliance with SQL Syntax in NDB Cluster”
Section 6.2.2, “Privileges Provided by MySQL”
Section 13.4.1.3, “SET sql_log_bin Statement”
Section 5.1.8.1, “System Variable Privileges”
Section 17.4.3, “Upgrading a Replication Setup”

sql_log_off

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

SQL_MODE

Section 14.13.1, “Online DDL Operations”

sql_mode

Section 14.1.2, “Best Practices for InnoDB Tables”
Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 13.1.11, “CREATE EVENT Statement”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.19, “CREATE TRIGGER Statement”
Section 12.21.3, “Expression Handling”
Section 11.2.7, “Fractional Seconds in Time Values”
Section 1.7, “How to Report Bugs or Problems”
Section 13.2.6, “LOAD DATA Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 1.8, “MySQL Standards Compliance”
Section 4.4.3, “mysql_install_db — Initialize MySQL Data Directory”
Section B.4.4.2, “Problems Using DATE Columns”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 13.7.5.14, “SHOW CREATE VIEW Statement”
Section 13.6.7.5, “SIGNAL Statement”
Section 5.4.4, “The Binary Log”
Section 21.29, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.1.2.2, “Using a Sample Default Server Configuration File”
Section 4.2.2.2, “Using Option Files”
Section 5.1.8, “Using System Variables”

sql_notes

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

sql_quote_show_create

Section 5.1.7, “Server System Variables”
Section 13.7.5.8, “SHOW CREATE DATABASE Statement”
Section 13.7.5.12, “SHOW CREATE TABLE Statement”

sql_safe_updates

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

sql_select_limit

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

sql_slave_skip_counter

Section 17.1.4.3, “Replication Slave Options and Variables”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 13.7.5.35, “SHOW SLAVE STATUS Statement”

sql_warnings

Section 5.1.7, “Server System Variables”

ssl_ca

Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 5.1.7, “Server System Variables”

ssl_capath

Section 5.1.7, “Server System Variables”

ssl_cert

Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 5.1.7, “Server System Variables”

ssl_cipher

Section 5.1.7, “Server System Variables”

ssl_crl

Section 5.1.7, “Server System Variables”

ssl_crlpath

Section 5.1.7, “Server System Variables”

ssl_key

Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 5.1.7, “Server System Variables”

storage_engine

Section 13.1.14, “CREATE LOGFILE GROUP Statement”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 17.3.3, “Using Replication with Different Master and Slave Storage Engines”

stored_program_cache

Section 8.10.4, “Caching of Prepared Statements and Stored Programs”
Section 5.1.7, “Server System Variables”

sync_binlog

Section 17.1.4.4, “Binary Log Options and Variables”
Section 17.3.2, “Handling an Unexpected Halt of a Replication Slave”
Section 14.2, “InnoDB and the ACID Model”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 17.4.1.26, “Replication and Master or Slave Shutdowns”
Section 5.4.4, “The Binary Log”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

sync_frm

Section 5.1.7, “Server System Variables”

sync_master_info

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 17.1.4.3, “Replication Slave Options and Variables”

sync_relay_log

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 17.3.2, “Handling an Unexpected Halt of a Replication Slave”
Section 17.1.4.3, “Replication Slave Options and Variables”

sync_relay_log_info

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 17.4.1.26, “Replication and Master or Slave Shutdowns”
Section 17.1.4.3, “Replication Slave Options and Variables”

system_time_zone

Section 5.1.12, “MySQL Server Time Zone Support”
Section 17.4.1.31, “Replication and Time Zones”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”

T

table_definition_cache

Section 5.1.2.1, “Changes to Server Defaults”
Section 8.12.4.1, “How MySQL Uses Memory”
Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

table_open_cache

Section 2.11.3, “Changes in MySQL 5.6”
Section 5.1.2.1, “Changes to Server Defaults”
Section 5.1.1, “Configuring the Server”
Section B.4.2.18, “File Not Found and Similar Errors”
Section 8.14.2, “General Thread States”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.12.4.1, “How MySQL Uses Memory”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

table_open_cache_instances

Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”

thread_cache_size

Section 5.1.2.1, “Changes to Server Defaults”
Section 24.5.1.4, “Debugging mysqld under gdb”
Section 8.12.5.1, “How MySQL Handles Client Connections”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”

thread_concurrency

Section 5.1.7, “Server System Variables”

thread_handling

Section 5.1.7, “Server System Variables”
Section 5.5.3.1, “Thread Pool Components”

thread_pool_algorithm

Section 5.1.7, “Server System Variables”
Section 21.32.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 5.5.3.1, “Thread Pool Components”

thread_pool_high_priority_connection

Section 5.1.7, “Server System Variables”
Section 5.5.3.1, “Thread Pool Components”
Section 5.5.3.3, “Thread Pool Operation”

thread_pool_max_unused_threads

Section 5.1.7, “Server System Variables”
Section 5.5.3.1, “Thread Pool Components”

thread_pool_prio_kickup_timer

Section 5.1.7, “Server System Variables”
Section 21.32.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 21.32.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 5.5.3.1, “Thread Pool Components”
Section 5.5.3.3, “Thread Pool Operation”
Section 5.5.3.4, “Thread Pool Tuning”

thread_pool_size

Section 5.1.7, “Server System Variables”
Section 5.5.3.1, “Thread Pool Components”
Section 5.5.3.3, “Thread Pool Operation”
Section 5.5.3.4, “Thread Pool Tuning”

thread_pool_stall_limit

Section 5.1.7, “Server System Variables”
Section 21.32.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 21.32.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 5.5.3.1, “Thread Pool Components”
Section 5.5.3.3, “Thread Pool Operation”
Section 5.5.3.4, “Thread Pool Tuning”

thread_stack

Section 8.12.5.1, “How MySQL Handles Client Connections”
Section 8.12.4.1, “How MySQL Uses Memory”
Section 5.1.7, “Server System Variables”
Section 20.2.1, “Stored Routine Syntax”

time_format

Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

time_zone

Section 13.1.11, “CREATE EVENT Statement”
Section 12.6, “Date and Time Functions”
Section 20.4.4, “Event Metadata”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 5.1.12, “MySQL Server Time Zone Support”
Section 17.4.1.31, “Replication and Time Zones”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types”

timed_mutexes

Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

timestamp

Section 15.8.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”

tls_version

Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”

tmp_table_size

Section 8.12.4.1, “How MySQL Uses Memory”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 13.6.6.5, “Restrictions on Server-Side Cursors”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”

tmpdir

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section B.4.2.13, “Can't create/write to file”
Section 7.2, “Database Backup Methods”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 14.13.5, “Online DDL Failure Conditions”
Section 14.13.3, “Online DDL Space Requirements”
Section 8.2.1.13, “ORDER BY Optimization”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 5.1.7, “Server System Variables”

transaction_alloc_block_size

Section 5.1.7, “Server System Variables”

transaction_allow_batching

Section 18.3.3.8.2, “NDB Cluster System Variables”

transaction_prealloc_size

Section 5.1.7, “Server System Variables”

tx_isolation

Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Statement”

tx_read_only

Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Statement”

U

unique_checks

Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.35, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 5.4.4, “The Binary Log”

updatable_views_with_limit

Section 5.1.7, “Server System Variables”
Section 20.5.3, “Updatable and Insertable Views”

V

validate_password_dictionary_file

Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.4.3, “The Password Validation Plugin”

validate_password_length

Section 12.13, “Encryption and Compression Functions”
Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.4.3, “The Password Validation Plugin”

validate_password_mixed_case_count

Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.4.3, “The Password Validation Plugin”

validate_password_number_count

Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.4.3, “The Password Validation Plugin”

validate_password_policy

Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.4.3, “The Password Validation Plugin”

validate_password_special_char_count

Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.4.3, “The Password Validation Plugin”

validate_user_plugins

Section 5.1.7, “Server System Variables”

version

Section 6.4.4.3, “Audit Log File Formats”
Section 12.15, “Information Functions”
Section 14.14, “InnoDB Startup Options and System Variables”
Section 5.1.7, “Server System Variables”

version_comment

Section 5.1.7, “Server System Variables”
Section 13.7.5.40, “SHOW VARIABLES Statement”

version_compile_machine

Section 5.1.7, “Server System Variables”

version_compile_os

Section 5.1.7, “Server System Variables”

W

wait_timeout

Section B.4.2.11, “Communication Errors and Aborted Connections”
Section B.4.2.9, “MySQL server has gone away”
Section 23.7.6.53, “mysql_real_connect()”
Section 5.1.7, “Server System Variables”

warning_count

Section B.2, “Error Information Interfaces”
Section 5.1.7, “Server System Variables”
Section 13.7.5.18, “SHOW ERRORS Statement”
Section 13.7.5.41, “SHOW WARNINGS Statement”
Section 13.6.7.5, “SIGNAL Statement”
Section 13.6.7.7, “The MySQL Diagnostics Area”

Prev	Up	Next
Status Variable Index	Home	Transaction Isolation Level Index