Spec-Zone .ru
спецификации, руководства, описания, API

System Variable Index

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

A

[index top]

audit_log_buffer_size

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

audit_log_file

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

audit_log_flush

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

audit_log_policy

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

audit_log_rotate_on_size

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

audit_log_strategy

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

authentication_windows_log_level

Section 5.1.4, "Server System Variables"
Section 6.3.7.4.2, "Using the Windows Authentication Plugin"

authentication_windows_use_principal_name

Section 5.1.4, "Server System Variables"
Section 6.3.7.4.2, "Using the Windows Authentication Plugin"

auto_increment_increment

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

auto_increment_offset

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

AUTOCOMMIT

Section 16.4.1.30, "Replication and Transactions"

autocommit

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

automatic_sp_privileges

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

B

[index top]

back_log

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

basedir

Section 13.7.3.3, "INSTALL PLUGIN Syntax"
Section 5.1.4, "Server System Variables"

big_tables

Section 5.1.4, "Server System Variables"
Section 1.4, "What Is New in MySQL 5.6"

bind_address

Section 5.1.4, "Server System Variables"

binlog_cache_size

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

binlog_checksum

Section 16.1.4.4, "Binary Log Options and Variables"
Section 5.1.2.1, "Changes to Server Defaults"
Section 5.2.4, "The Binary Log"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"
Section 1.4, "What Is New in MySQL 5.6"

binlog_direct_non_transactional_updates

Section 16.1.4.4, "Binary Log Options and Variables"
Section 16.4.1.30, "Replication and Transactions"

binlog_format

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

binlog_max_flush_queue_time

Section 16.1.4.4, "Binary Log Options and Variables"

binlog_order_commits

Section 16.1.4.4, "Binary Log Options and Variables"

binlog_row_image

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

binlog_rows_query_log_events

Section 16.1.4.4, "Binary Log Options and Variables"

binlog_stmt_cache_size

Section 16.1.4.4, "Binary Log Options and Variables"
Section 5.1.6, "Server Status Variables"

bulk_insert_buffer_size

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

C

[index top]

character_set_client

Section 13.2.6, "LOAD DATA INFILESyntax"
Section 13.7.4, "SET Syntax"
Section 13.7.5.9, "SHOW CREATE EVENT Syntax"
Section 13.7.5.11, "SHOW CREATE PROCEDURE Syntax"
Section 13.7.5.13, "SHOW CREATE TRIGGER Syntax"
Section 13.7.5.14, "SHOW CREATE VIEW Syntax"
Section 13.7.5.19, "SHOW EVENTS Syntax"
Section 13.7.5.29, "SHOW PROCEDURE STATUS Syntax"
Section 13.7.5.39, "SHOW TRIGGERS Syntax"
Section 22.8.9.1, "C API Prepared Statement Type Codes"
Section 10.5, "Character Set Configuration"
Section 10.1.4, "Connection Character Sets and Collations"
Section 5.2.4.3, "Mixed Binary Logging Format"
Section 16.4.1.33, "Replication and Variables"
Section 5.1.4, "Server System Variables"
Section 20.7, "The INFORMATION_SCHEMA EVENTS Table"
Section 20.19, "The INFORMATION_SCHEMA ROUTINES Table"
Section 20.27, "The INFORMATION_SCHEMA TRIGGERS Table"
Section 20.29, "The INFORMATION_SCHEMA VIEWS Table"
Section 5.2.4, "The Binary Log"

character_set_connection

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

character_set_database

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

character_set_filesystem

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

character_set_results

Section 13.7.4, "SET Syntax"
Section 10.1.6, "Character Set for Error Messages"
Section 10.1.4, "Connection Character Sets and Collations"
Section 5.1.4, "Server System Variables"
Section 10.1.12, "UTF-8 for Metadata"

character_set_server

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

character_set_system

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

character_sets_dir

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

collation_connection

Section 10.1.9.2, "CONVERT() andCAST()"
Section 13.7.4, "SET Syntax"
Section 13.7.5.9, "SHOW CREATE EVENT Syntax"
Section 13.7.5.11, "SHOW CREATE PROCEDURE Syntax"
Section 13.7.5.13, "SHOW CREATE TRIGGER Syntax"
Section 13.7.5.14, "SHOW CREATE VIEW Syntax"
Section 13.7.5.19, "SHOW EVENTS Syntax"
Section 13.7.5.29, "SHOW PROCEDURE STATUS Syntax"
Section 13.7.5.39, "SHOW TRIGGERS Syntax"
Section 10.1.3.5, "Character String Literal Character Set and Collation"
Section 10.1.7.5, "Collation of Expressions"
Section 10.1.4, "Connection Character Sets and Collations"
Section 12.7, "Date and Time Functions"
Section 12.13, "Encryption and Compression Functions"
Section 5.2.4.3, "Mixed Binary Logging Format"
Section 16.4.1.33, "Replication and Variables"
Section 10.1.9.1, "Result Strings"
Section 5.1.4, "Server System Variables"
Section 20.7, "The INFORMATION_SCHEMA EVENTS Table"
Section 20.19, "The INFORMATION_SCHEMA ROUTINES Table"
Section 20.27, "The INFORMATION_SCHEMA TRIGGERS Table"
Section 20.29, "The INFORMATION_SCHEMA VIEWS Table"
Section 5.2.4, "The Binary Log"
Section 12.2, "Type Conversion in Expression Evaluation"

collation_database

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

collation_server

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

completion_type

Section 22.8.7.6, "mysql_commit()"
Section 22.8.7.58, "mysql_rollback()"
Section 13.3.1, "START TRANSACTION, COMMIT, andROLLBACK Syntax"
Section 5.1.4, "Server System Variables"

concurrent_insert

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

connect_timeout

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

core_file

Section 5.1.4, "Server System Variables"

D

[index top]

daemon_memcached_engine_lib_name

Section 14.2.9.3.2, "Installing and Configuring the InnoDB memcached Plugin"

daemon_memcached_engine_lib_path

Section 14.2.9.3.2, "Installing and Configuring the InnoDB memcached Plugin"

daemon_memcached_option

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"
Section 14.2.9.3.2, "Installing and Configuring the InnoDB memcached Plugin"
Section 14.2.9.4.1, "Password-Protecting the memcached Interface throughSASL"
Section 14.2.9.8, "Troubleshooting the InnoDB memcached Plugin"

daemon_memcached_r_batch_size

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

daemon_memcached_w_batch_size

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

DATADIR

Section 5.4.1.2, "Specifying the Location of a Tablespace"

datadir

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

date_format

Section 5.1.4, "Server System Variables"

datetime_format

Section 5.1.4, "Server System Variables"

debug

Section 5.1.4, "Server System Variables"

debug_sync

Section 5.1.4, "Server System Variables"

default_storage_engine

Section 13.1.14, "CREATE LOGFILE GROUP Syntax"
Section 5.1.8.1, "Installing and Uninstalling Plugins"
Section 16.4.1.33, "Replication and Variables"
Section 5.1.4, "Server System Variables"
Section 14.1, "Setting the Storage Engine"
Section 16.3.2, "Using Replication with Different Master and Slave Storage Engines"

default_tmp_storage_engine

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

default_week_format

Section 12.7, "Date and Time Functions"
Section 18.6.3, "Partitioning Limitations Relating to Functions"
Section 5.1.4, "Server System Variables"

delay_key_write

Section 13.1.17, "CREATE TABLE Syntax"
Section 5.1.4, "Server System Variables"

delayed_insert_limit

Section 13.2.5.2, "INSERT DELAYED Syntax"
Section 5.1.4, "Server System Variables"

delayed_insert_timeout

Section 13.2.5.2, "INSERT DELAYED Syntax"
Section 5.1.4, "Server System Variables"

delayed_queue_size

Section 13.2.5.2, "INSERT DELAYED Syntax"
Section 5.1.4, "Server System Variables"

disable_gtid_unsafe_statements

Section 16.1.4.5, "Global Transaction ID Options and Variables"

disconnect_on_expired_passwords

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

div_precision_increment

Section 12.6.1, "Arithmetic Operators"
Section 5.1.4, "Server System Variables"

E

[index top]

end_markers_in_json

Section 5.1.4, "Server System Variables"

enforce_gtid_consistency

Section 16.1.4.5, "Global Transaction ID Options and Variables"

engine_condition_pushdown

Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"

eq_range_index_dive_limit

Section 8.13.1.3, "Equality Range Optimization of Many-Valued Comparisons"
Section 5.1.4, "Server System Variables"

error_count

Section 13.7.5.18, "SHOW ERRORS Syntax"
Section 13.6.7.7.4, "Diagnostics Area-Related System Variables"
Section 5.1.4, "Server System Variables"
Section C.1, "Sources of Error Information"

event_scheduler

Section 19.4.2, "Event Scheduler Configuration"
Section 22.7.2, "Restrictions When Using the Embedded MySQL Server"
Section 5.1.4, "Server System Variables"
Section 19.4.6, "The Event Scheduler and MySQL Privileges"

expire_logs_days

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

explicit_defaults_for_timestamp

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

external_user

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

F

[index top]

flush

Section 5.1.4, "Server System Variables"

flush_time

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

foreign_key_checks

Section 5.5.6, "Implementation Details of Online DDL"
Section 5.2.4.3, "Mixed Binary Logging Format"
Section 5.5.1, "Overview of Online DDL"
Section 16.4.1.33, "Replication and Variables"
Section 5.1.7, "Server SQL Modes"
Section 5.1.4, "Server System Variables"
Section 5.2.4, "The Binary Log"
Section 13.1.17.2, "Using FOREIGN KEY Constraints"

ft_boolean_syntax

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

ft_max_word_len

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

ft_min_word_len

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

ft_query_expansion_limit

Section 5.1.4, "Server System Variables"

ft_stopword_file

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

G

[index top]

general_log

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

general_log_file

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

group_concat_max_len

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

gtid_done

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

gtid_executed

Section 13.4.1.2, "RESET MASTER Syntax"
Section 13.7.5.24, "SHOW MASTER STATUS Syntax"
Section 16.1.4.5, "Global Transaction ID Options and Variables"
Section 16.1.3.1, "GTID Concepts"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 16.1.3.4, "Restrictions on Replication with GTIDs"
Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

gtid_lost

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

gtid_mode

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

gtid_next

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

gtid_owned

Section 16.1.4.5, "Global Transaction ID Options and Variables"

gtid_purged

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

H

[index top]

have_compress

Section 5.1.4, "Server System Variables"

have_crypt

Section 5.1.4, "Server System Variables"

have_csv

Section 5.1.4, "Server System Variables"

have_dynamic_loading

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

have_geometry

Section 5.1.4, "Server System Variables"

have_innodb

Section 5.1.4, "Server System Variables"

have_ndbcluster

Section 17.3.4.3, "MySQL Cluster System Variables"

have_openssl

Section 5.1.4, "Server System Variables"

have_partitioning

Chapter 18, Partitioning
Section 5.1.4, "Server System Variables"

have_profiling

Section 5.1.4, "Server System Variables"

have_query_cache

Section 8.9.3.3, "Query Cache Configuration"
Section 5.1.4, "Server System Variables"

have_rtree_keys

Section 5.1.4, "Server System Variables"

have_ssl

Section 6.3.9.2, "Configuring MySQL for SSL"
Section 5.1.4, "Server System Variables"

have_symlink

Section 5.1.4, "Server System Variables"
Section 8.11.3.1.2, "Using Symbolic Links for MyISAM Tables on Unix"
Section 8.11.3.1.3, "Using Symbolic Links for Databases on Windows"

host_cache_size

Section 5.1.2.1, "Changes to Server Defaults"
Section 8.11.5.2, "DNS Lookup Optimization and the Host Cache"
Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"
Section 1.4, "What Is New in MySQL 5.6"

hostname

Section 5.1.4, "Server System Variables"

I

[index top]

identity

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

ignore_db_dirs

Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"

init_connect

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

init_file

Section 5.1.4, "Server System Variables"

init_slave

Section 16.1.4.3, "Replication Slave Options and Variables"

innodb

Section 14.2.5.1, "Support for Read-Only Media"
Section 1.4, "What Is New in MySQL 5.6"

innodb_adaptive_flushing

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_adaptive_hash_index

Section 14.2.3.12.6, "Adaptive Hash Indexes"
Section 14.2.5.5.4, "Dynamically Changing innodb_adaptive_hash_index"

innodb_adaptive_max_sleep_delay

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_api_bk_commit_interval

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

innodb_api_enable_binlog

Section 14.2.9.6, "Using the InnoDB memcached Plugin with Replication"

innodb_api_enable_mdl

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

innodb_api_trx_level

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

innodb_autoextend_increment

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 14.2.2.2, "Adding, Removing, or Resizing InnoDB Data and LogFiles"
Section 5.1.2.1, "Changes to Server Defaults"
Section 14.2.1.2, "Configuring InnoDB"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

innodb_autoinc_lock_mode

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

innodb_buffer_pool_dump_at_shutdown

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_buffer_pool_dump_now

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_buffer_pool_instances

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 5.1.2.1, "Changes to Server Defaults"
Section 5.4.3, "Converting Tables from MyISAM toInnoDB"
Section 8.9.1, "The InnoDB Buffer Pool"
Section 14.2.9.5.3, "Tuning Performance of the InnoDB memcached Plugin"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

innodb_buffer_pool_load_abort

Section 5.1.6, "Server Status Variables"

innodb_buffer_pool_load_at_startup

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

innodb_buffer_pool_load_now

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

innodb_buffer_pool_size

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

innodb_change_buffer_max_size

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_change_buffering

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

innodb_checksum_algorithm

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 5.1.2.1, "Changes to Server Defaults"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

innodb_checksums

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_cmp_per_index_enabled

Section 5.4.6.4, "Monitoring Compression at Runtime"
Section 20.30.2, "The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX andINNODB_CMP_PER_INDEX_RESET Tables"
Section 5.4.6.3, "Tuning Compression for InnoDB Tables"

innodb_compression_failure_threshold_pct

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

innodb_compression_level

Section 5.4.6.5, "How Compression Works for InnoDB Tables"
Section 5.4.6.3, "Tuning Compression for InnoDB Tables"

innodb_compression_pad_pct_max

Section 5.4.6.5, "How Compression Works for InnoDB Tables"
Section 5.4.6.3, "Tuning Compression for InnoDB Tables"

innodb_concurrency_tickets

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

innodb_data_file_path

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 14.2.2.2, "Adding, Removing, or Resizing InnoDB Data and LogFiles"
Section 5.1.2.1, "Changes to Server Defaults"
Section 14.2.1.2, "Configuring InnoDB"
Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"
Section 14.2.4.5.1, "Troubleshooting InnoDB I/O Problems"
Section 14.2.2.3, "Using Raw Disk Partitions for the Shared Tablespace"

innodb_data_home_dir

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

innodb_doublewrite

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

innodb_fast_shutdown

Section 14.2.2.2, "Adding, Removing, or Resizing InnoDB Data and LogFiles"
Section 5.4.7.2.1, "Compatibility Check When InnoDB Is Started"
Section 5.1.12, "The Shutdown Process"

innodb_file_format

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

innodb_file_format_check

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

innodb_file_format_max

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_file_per_table

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

innodb_flush_log_at_timeout

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_flush_log_at_trx_commit

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

innodb_flush_method

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

innodb_flush_neighbors

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_force_load_corrupted

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_force_recovery

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

innodb_ft_aux_table

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 20.30.25, "The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table"
Section 20.30.24, "The INFORMATION_SCHEMA INNODB_FT_DELETED Table"
Section 20.30.23, "The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table"
Section 20.30.22, "The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table"

innodb_ft_cache_size

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_ft_enable_diag_print

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_ft_enable_stopword

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

innodb_ft_max_token_size

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 12.9.2, "Boolean Full-Text Searches"
Section 12.9.6, "Fine-Tuning MySQL Full-Text Search"

innodb_ft_min_token_size

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

innodb_ft_num_word_optimize

Section 14.2.3.12.3, "FULLTEXT Indexes"
Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 13.7.2.4, "OPTIMIZE TABLE Syntax"

innodb_ft_server_stopword_table

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 12.9.2, "Boolean Full-Text Searches"
Section 12.9.6, "Fine-Tuning MySQL Full-Text Search"
Section 12.9, "Full-Text Search Functions"
Section 12.9.4, "Full-Text Stopwords"
Section 12.9.1, "Natural Language Full-Text Searches"
Section 20.30.21, "The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORDTable"

innodb_ft_sort_pll_degree

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_ft_user_stopword_table

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 12.9.2, "Boolean Full-Text Searches"
Section 12.9.6, "Fine-Tuning MySQL Full-Text Search"
Section 12.9, "Full-Text Search Functions"
Section 12.9.4, "Full-Text Stopwords"
Section 12.9.1, "Natural Language Full-Text Searches"
Section 20.30.21, "The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORDTable"

innodb_io_capacity

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_io_capacity_max

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_large_prefix

Section 2.11.3, "Checking Whether Tables or Indexes Must Be Rebuilt"
Section 14.2.7, "Limits on InnoDB Tables"

innodb_lock_wait_timeout

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

innodb_locks_unsafe_for_binlog

Section 14.2.3.5, "InnoDB Record, Gap, and Next-Key Locks"
Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 13.3.6, "SET TRANSACTION Syntax"
Section 14.2.3.3, "Consistent Nonlocking Reads"
Section 14.2.3.7, "Locks Set by Different SQL Statements in InnoDB"

innodb_log_buffer_size

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_log_file_size

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 14.2.2.2, "Adding, Removing, or Resizing InnoDB Data and LogFiles"
Section 5.1.2.1, "Changes to Server Defaults"
Section 14.2.1.2, "Configuring InnoDB"
Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"
Section 8.5.7, "Optimizing InnoDB Disk I/O"
Section 14.2.5.1, "Support for Read-Only Media"
Section 1.4, "What Is New in MySQL 5.6"

innodb_log_files_in_group

Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 14.2.2.2, "Adding, Removing, or Resizing InnoDB Data and LogFiles"
Section 1.4, "What Is New in MySQL 5.6"

innodb_log_group_home_dir

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_lru_scan_depth

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_max_dirty_pages_pct

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_max_purge_lag

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

innodb_max_purge_lag_delay

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_monitor_disable

Section 20.30.19, "The INFORMATION_SCHEMA INNODB_METRICS Table"

innodb_monitor_enable

Section 20.30.19, "The INFORMATION_SCHEMA INNODB_METRICS Table"

innodb_monitor_reset

Section 20.30.19, "The INFORMATION_SCHEMA INNODB_METRICS Table"

innodb_monitor_reset_all

Section 20.30.19, "The INFORMATION_SCHEMA INNODB_METRICS Table"

innodb_old_blocks_pct

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

innodb_old_blocks_time

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

innodb_online_alter_log_max_size

Section 5.5.6, "Implementation Details of Online DDL"

innodb_open_files

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

innodb_optimize_fulltext_only

Section 14.2.3.12.3, "FULLTEXT Indexes"
Section 13.7.2.4, "OPTIMIZE TABLE Syntax"

innodb_page_size

Section 5.4.3, "Converting Tables from MyISAM toInnoDB"
Section 2.11.2.1, "Downgrading to MySQL 5.5"
Section 5.3.2, "File Space Management"
Section 5.4.6.5, "How Compression Works for InnoDB Tables"
Section 14.2.7, "Limits on InnoDB Tables"
Section 8.5.7, "Optimizing InnoDB Disk I/O"
Section 14.2.3.12.4, "Physical Structure of an InnoDB Index"
Section 14.2.9.8, "Troubleshooting the InnoDB memcached Plugin"
Section 1.4, "What Is New in MySQL 5.6"

innodb_print_all_deadlocks

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

innodb_random_read_ahead

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_read_ahead_threshold

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

innodb_read_io_threads

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

innodb_rollback_segments

Section 8.5.7, "Optimizing InnoDB Disk I/O"

innodb_sort_buffer_size

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_stats_auto_recalc

Section 13.1.17, "CREATE TABLE Syntax"

innodb_stats_method

Section 8.3.7, "InnoDB and MyISAM Index StatisticsCollection"

innodb_stats_on_metadata

Section 5.1.2.1, "Changes to Server Defaults"
Section 14.2.5.5.2, "Dynamically Changing innodb_stats_on_metadata"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

innodb_stats_persistent

Section 13.7.2.1, "ANALYZE TABLE Syntax"
Section 13.1.13, "CREATE INDEX Syntax"
Section 13.1.17, "CREATE TABLE Syntax"
Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 14.2.7, "Limits on InnoDB Tables"

innodb_stats_persistent_sample_pages

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

innodb_stats_sample_pages

Section 14.2.5.8, "Controlling Optimizer Statistics Estimation"

innodb_stats_transient_sample_pages

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

innodb_strict_mode

Section 13.1.13, "CREATE INDEX Syntax"
Section 13.1.17, "CREATE TABLE Syntax"
Section 14.2.5.7, "InnoDB Strict Mode"
Section 5.4.6.5, "How Compression Works for InnoDB Tables"
Section 5.1.7, "Server SQL Modes"
Section 5.4.6.6, "SQL Compression Syntax Warnings and Errors"

innodb_support_xa

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

innodb_table_locks

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

innodb_thread_concurrency

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

innodb_thread_sleep_delay

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_undo_directory

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

innodb_undo_logs

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

innodb_undo_tablespaces

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

innodb_use_native_aio

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_use_sys_malloc

Section 14.2.6, "InnoDB Startup Options and System Variables"

innodb_write_io_threads

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

insert_id

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

interactive_timeout

Section 22.8.7.53, "mysql_real_connect()"
Section C.5.2.11, "Communication Errors and Aborted Connections"
Section 5.1.4, "Server System Variables"

J

[index top]

join_buffer_size

Section 5.1.2.1, "Changes to Server Defaults"
Section 8.13.8, "Nested-Loop Join Algorithms"
Section 5.1.4, "Server System Variables"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

K

[index top]

keep_files_on_create

Section 5.1.4, "Server System Variables"

key_buffer_size

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

key_cache_age_threshold

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

key_cache_block_size

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

key_cache_division_limit

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

L

[index top]

large_files_support

Section 18.6, "Restrictions and Limitations on Partitioning"
Section 5.1.4, "Server System Variables"

large_page_size

Section 5.1.4, "Server System Variables"

large_pages

Section 5.1.4, "Server System Variables"

last_insert_id

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

lc_messages

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

lc_messages_dir

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

lc_time_names

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

license

Section 5.1.4, "Server System Variables"

local

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

local_infile

Section 5.1.4, "Server System Variables"

lock_wait_timeout

Section 5.1.4, "Server System Variables"

locked_in_memory

Section 5.1.4, "Server System Variables"

log

Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"
Section 14.2.9.6, "Using the InnoDB memcached Plugin with Replication"

log_bin

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

log_bin_basename

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

log_bin_trust_function_creators

Section 16.1.4.4, "Binary Log Options and Variables"
Section 19.7, "Binary Logging of Stored Programs"
Section 5.1.4, "Server System Variables"

log_bin_use_v

Section 16.1.4.4, "Binary Log Options and Variables"

log_error

Section 5.1.4, "Server System Variables"
Section 5.2.2, "The Error Log"

log_output

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

log_queries_not_using_indexes

Section 5.1.4, "Server System Variables"
Section 5.2.5, "The Slow Query Log"

log_slave_updates

Section 16.1.4.4, "Binary Log Options and Variables"

log_slow_admin_statements

Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"

log_slow_queries

Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"

log_slow_slave_statements

Section 16.1.4.3, "Replication Slave Options and Variables"

log_throttle_queries_not_using_indexes

Section 5.1.4, "Server System Variables"
Section 5.2.5, "The Slow Query Log"

log_warnings

Section 5.1.4, "Server System Variables"
Section 5.2.2, "The Error Log"

long_query_time

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

low_priority_updates

Section 5.1.4, "Server System Variables"
Section 8.10.2, "Table Locking Issues"
Section 1.4, "What Is New in MySQL 5.6"

lower_case_file_system

Section 5.1.4, "Server System Variables"

lower_case_table_names

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

M

[index top]

master_info_repository

Section 16.1.4.3, "Replication Slave Options and Variables"

master_verify_checksum

Section 16.1.4.4, "Binary Log Options and Variables"
Section 5.2.4, "The Binary Log"

max_allowed_packet

Section 12.17.1, "GROUP BY (Aggregate) Functions"
Section C.5.2.3, "Lost connection to MySQL server"
Section C.5.2.9, "MySQL server has gone away"
Section 22.8.11.26, "mysql_stmt_send_long_data()"
Section 22.8.7.72, "mysql_use_result()"
Section 5.1.2.1, "Changes to Server Defaults"
Section C.5.2.11, "Communication Errors and Aborted Connections"
Section 12.3.2, "Comparison Functions and Operators"
Section C.5.5.6, "Deleting Rows from Related Tables"
Section 8.11.4.1, "How MySQL Uses Memory"
Section 22.8, "MySQL C API"
Section 17.6.11, "MySQL Cluster Replication Conflict Resolution"
Section C.5.2.10, "Packet Too Large"
Section 16.4.1.20, "Replication and max_allowed_packet"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 5.1.4, "Server System Variables"
Section 12.5, "String Functions"
Section 11.4.3, "The BLOB andTEXT Types"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"
Section 4.2.3.3, "Using Option Files"
Section 1.4, "What Is New in MySQL 5.6"

max_binlog_cache_size

Section 16.1.4.4, "Binary Log Options and Variables"
Section 5.2.4, "The Binary Log"

max_binlog_size

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

max_binlog_stmt_cache_size

Section 16.1.4.4, "Binary Log Options and Variables"

max_connect_errors

Section 13.7.6.3, "FLUSH Syntax"
Section C.5.2.6, "Host 'host_name' isblocked"
Section 5.1.2.1, "Changes to Server Defaults"
Section 8.11.5.2, "DNS Lookup Optimization and the Host Cache"
Section 5.1.4, "Server System Variables"
Section 21.9.9.1, "The host_cache Table"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"
Section 1.4, "What Is New in MySQL 5.6"

max_connections

Section C.5.2.18, "'File' Not Found andSimilar Errors"
Section C.5.2.7, "Too many connections"
Section 5.1.2.1, "Changes to Server Defaults"
Section 23.4.1.4, "Debugging mysqld under gdb"
Section 8.4.3.1, "How MySQL Opens and Closes Tables"
Section 8.11.5.1, "How MySQL Uses Threads for Client Connections"
Section 21.12, "Performance Schema System Variables"
Section 6.2.1, "Privileges Provided by MySQL"
Section 5.1.3, "Server Command Options"
Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"
Section 8.11.6.2, "Thread Pool Operation"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

max_delayed_threads

Section 5.1.4, "Server System Variables"

max_error_count

Section 13.2.6, "LOAD DATA INFILESyntax"
Section 13.6.7.4, "RESIGNAL Syntax"
Section 13.7.5.18, "SHOW ERRORS Syntax"
Section 13.7.5.41, "SHOW WARNINGS Syntax"
Section 13.6.7.7.4, "Diagnostics Area-Related System Variables"
Section 5.1.4, "Server System Variables"

max_heap_table_size

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

max_insert_delayed_threads

Section 5.1.4, "Server System Variables"

max_join_size

Section 4.5.1.1, "mysql Options"
Section 8.8.2, "EXPLAIN Output Format"
Section 13.7.4, "SET Syntax"
Section 5.1.4, "Server System Variables"
Section 5.1.5, "Using System Variables"
Section 1.4, "What Is New in MySQL 5.6"

max_length_for_sort_data

Section 8.13.13, "ORDER BY Optimization"
Section 5.1.4, "Server System Variables"

max_prepared_stmt_count

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

max_relay_log_size

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

max_seeks_for_key

Section 14.2.7, "Limits on InnoDB Tables"
Section 5.1.4, "Server System Variables"

max_sort_length

Section 13.1.17, "CREATE TABLE Syntax"
Section C.5.8, "Known Issues in MySQL"
Section 5.1.4, "Server System Variables"
Section 11.4.3, "The BLOB andTEXT Types"

max_sp_recursion_depth

Section 5.1.4, "Server System Variables"
Section 19.2.1, "Stored Routine Syntax"

max_tmp_tables

Section 5.1.4, "Server System Variables"

max_user_connections

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

max_write_lock_count

Section 5.1.4, "Server System Variables"
Section 8.10.2, "Table Locking Issues"

metadata_locks_cache_size

Section 5.1.4, "Server System Variables"

metadata_locks_hash_instances

Section 5.1.4, "Server System Variables"

min_examined_row_limit

Section 5.1.4, "Server System Variables"
Section 5.2.5, "The Slow Query Log"

myisam_data_pointer_size

Section 13.1.17, "CREATE TABLE Syntax"
Section E.10.3, "Limits on Table Size"
Section 5.1.4, "Server System Variables"

myisam_max_sort_file_size

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

myisam_mmap_size

Section 5.1.4, "Server System Variables"

myisam_recover_options

Section 5.1.4, "Server System Variables"

myisam_repair_threads

Section 5.1.4, "Server System Variables"

myisam_sort_buffer_size

Section 4.6.3.1, "myisamchk General Options"
Section 13.1.7, "ALTER TABLE Syntax"
Section 14.3.1, "MyISAM Startup Options"
Section 5.1.4, "Server System Variables"
Section 8.6.3, "Speed of REPAIR TABLE Statements"

myisam_stats_method

Section 8.3.7, "InnoDB and MyISAM Index StatisticsCollection"
Section 5.1.4, "Server System Variables"

myisam_use_mmap

Section 8.11.4.1, "How MySQL Uses Memory"
Section 5.1.4, "Server System Variables"

N

[index top]

named_pipe

Section 5.1.4, "Server System Variables"

ndb_autoincrement_prefetch_sz

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_cache_check_time

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_deferred_constraints

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_distribution

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_extra_logging

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_force_send

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_join_pushdown

Section 8.8.2, "EXPLAIN Output Format"
Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_log_apply_status

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_log_bin

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_log_binlog_index

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_log_empty_epochs

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_log_transaction_id

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_optimized_node_selection

Section 17.3.4.3, "MySQL Cluster System Variables"
Section 17.5.6.3, "Using CLUSTERLOG STATISTICS in the MySQL ClusterManagement Client"

ndb_recv_thread_activation_threshold

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_recv_thread_cpu_mask

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_report_thresh_binlog_epoch_slip

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_report_thresh_binlog_mem_usage

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_table_no_logging

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_table_temporary

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_use_copying_alter_table

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_use_exact_count

Section 17.3.4.3, "MySQL Cluster System Variables"

ndb_use_transactions

Section 17.3.4.3, "MySQL Cluster System Variables"

ndbinfo_database

Section 17.3.4.3, "MySQL Cluster System Variables"

ndbinfo_max_bytes

Section 17.3.4.3, "MySQL Cluster System Variables"

ndbinfo_max_rows

Section 17.3.4.3, "MySQL Cluster System Variables"

ndbinfo_show_hidden

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

ndbinfo_table_prefix

Section 17.3.4.3, "MySQL Cluster System Variables"

ndbinfo_version

Section 17.3.4.3, "MySQL Cluster System Variables"

net_buffer_length

Section 4.5.1.1, "mysql Options"
Section 4.5.4, "mysqldump — A Database Backup Program"
Section 8.11.4.1, "How MySQL Uses Memory"
Section 22.8, "MySQL C API"
Section 5.1.4, "Server System Variables"

net_read_timeout

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

net_retry_count

Section 22.8.7.49, "mysql_options()"
Section 5.1.4, "Server System Variables"

net_write_timeout

Section 5.1.4, "Server System Variables"

new

Section 5.1.4, "Server System Variables"

O

[index top]

old

Section 13.2.9.3, "Index Hint Syntax"
Section 5.1.4, "Server System Variables"

old_alter_table

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

old_passwords

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

open_files_limit

Section C.5.2.18, "'File' Not Found andSimilar Errors"
Section 5.1.2.1, "Changes to Server Defaults"
Section 21.12, "Performance Schema System Variables"
Section 18.6, "Restrictions and Limitations on Partitioning"
Section 5.1.4, "Server System Variables"

optimizer_join_cache_level

Section 8.13.12.2, "Block Nested-Loop Algorithm for Outer Joins and Semi-Joins"
Section 8.13.12.1, "Join Buffer Management for Block Nested-Loop and Batched Key AccessAlgorithms"
Section 5.1.4, "Server System Variables"

optimizer_prune_level

Section 8.8.5.1, "Controlling Query Plan Evaluation"
Section 5.1.4, "Server System Variables"

optimizer_search_depth

Section 8.8.5.1, "Controlling Query Plan Evaluation"
Section 5.1.4, "Server System Variables"

optimizer_switch

Section 8.13.12.3, "Batched Key Access Joins"
Section 8.13.12.2, "Block Nested-Loop Algorithm for Outer Joins and Semi-Joins"
Section 8.8.5.2, "Controlling Switchable Optimizations"
Section 8.13.3, "Engine Condition Pushdown Optimization"
Section 8.13.4, "Index Condition Pushdown Optimization"
Section 8.13.12.1, "Join Buffer Management for Block Nested-Loop and Batched Key AccessAlgorithms"
Section 8.13.11, "Multi-Range Read Optimization"
Section 8.13.16.1, "Optimizing Subqueries with Semi-Join Transformations"
Section 8.13.16.2, "Optimizing Subqueries with Subquery Materialization"
Section 5.1.4, "Server System Variables"
Section 8.13.5, "Use of Index Extensions"
Section 1.4, "What Is New in MySQL 5.6"

optimizer_trace

Section 5.1.4, "Server System Variables"
Section 20.12, "The INFORMATION_SCHEMA OPTIMIZER_TRACE Table"

optimizer_trace_features

Section 5.1.4, "Server System Variables"

optimizer_trace_limit

Section 5.1.4, "Server System Variables"

optimizer_trace_max_mem_size

Section 5.1.4, "Server System Variables"

optimizer_trace_offset

Section 5.1.4, "Server System Variables"

P

[index top]

performance_schema

Section 5.1.2.1, "Changes to Server Defaults"
Section 21.1, "Performance Schema Quick Start"
Section 21.2.2, "Performance Schema Startup Configuration"
Section 21.12, "Performance Schema System Variables"

performance_schema_accounts_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.6.1, "The accounts Table"

performance_schema_digests_size

Section 21.7, "Performance Schema Statement Digests"
Section 21.12, "Performance Schema System Variables"
Section 21.9.8.3, "Statement Summary Tables"

performance_schema_events_stages_history_long_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.4.3, "The events_stages_history_long Table"

performance_schema_events_stages_history_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.4.2, "The events_stages_history Table"

performance_schema_events_statements_history_long_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.5.3, "The events_statements_history_long Table"

performance_schema_events_statements_history_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.5.2, "The events_statements_history Table"

performance_schema_events_waits_history_long_size

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

performance_schema_events_waits_history_size

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

performance_schema_hosts_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.6.2, "The hosts Table"

performance_schema_max_cond_classes

Section 21.12, "Performance Schema System Variables"

performance_schema_max_cond_instances

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

performance_schema_max_file_classes

Section 21.12, "Performance Schema System Variables"

performance_schema_max_file_handles

Section 21.12, "Performance Schema System Variables"

performance_schema_max_file_instances

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

performance_schema_max_mutex_classes

Section 21.5, "Performance Schema Status Monitoring"
Section 21.12, "Performance Schema System Variables"

performance_schema_max_mutex_instances

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

performance_schema_max_rwlock_classes

Section 21.12, "Performance Schema System Variables"

performance_schema_max_rwlock_instances

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

performance_schema_max_socket_classes

Section 21.12, "Performance Schema System Variables"

performance_schema_max_socket_instances

Section 21.12, "Performance Schema System Variables"

performance_schema_max_stage_classes

Section 21.12, "Performance Schema System Variables"

performance_schema_max_statement_classes

Section 21.12, "Performance Schema System Variables"

performance_schema_max_table_handles

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

performance_schema_max_table_instances

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

performance_schema_max_thread_classes

Section 21.12, "Performance Schema System Variables"

performance_schema_max_thread_instances

Section 13.7.5.16, "SHOW ENGINE Syntax"
Section 5.1.2.1, "Changes to Server Defaults"
Section 21.12, "Performance Schema System Variables"

performance_schema_session_connect_attrs_size

Section 21.12, "Performance Schema System Variables"

performance_schema_setup_actors_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.1.1, "The setup_actors Table"

performance_schema_setup_objects_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.1.4, "The setup_objects Table"

performance_schema_users_size

Section 21.12, "Performance Schema System Variables"
Section 21.9.6.3, "The users Table"

pid_file

Section 5.1.4, "Server System Variables"

plugin_dir

Section 13.7.3.1, "CREATE FUNCTION Syntax for User-DefinedFunctions"
Section 13.7.3.3, "INSTALL PLUGIN Syntax"
Section 13.7.5.26, "SHOW PLUGINS Syntax"
Section 6.1.2.2, "Administrator Guidelines for Password Security"
Section 23.2.4.3, "Compiling and Installing Plugin Libraries"
Section 23.3.2.5, "Compiling and Installing User-Defined Functions"
Section 5.1.8.1, "Installing and Uninstalling Plugins"
Section 6.3.11.1, "Installing the Audit Log Plugin"
Section 6.3.7.3.1, "Installing the PAM Authentication Plugin"
Section 6.3.7.4.1, "Installing the Windows Authentication Plugin"
Section 6.1.3, "Making MySQL Secure Against Attackers"
Section 6.1.2.6.1, "Password Validation Plugin Installation"
Section 6.3.7, "Pluggable Authentication"
Section 14.12.1, "Pluggable Storage Engine Architecture"
Section 23.2.2, "Plugin API Components"
Section E.9, "Restrictions on Pluggable Authentication"
Section 16.3.8.2, "Semisynchronous Replication Installation and Configuration"
Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"
Section 20.15, "The INFORMATION_SCHEMA PLUGINS Table"
Section 6.3.7.3, "The PAM Authentication Plugin"
Section 6.3.7.6, "The Socket Peer-Credential Authentication Plugin"
Section 6.3.7.7, "The Test Authentication Plugin"
Section 6.3.7.4, "The Windows Native Authentication Plugin"
Section 8.11.6.1, "Thread Pool Components and Installation"
Section 2.10.1, "Unix Postinstallation Procedures"
Section 23.3.2.6, "User-Defined Function Security Precautions"
Section 23.2.4.9.3, "Using the Authentication Plugins"
Section 23.2.4.6, "Writing INFORMATION_SCHEMA Plugins"
Section 23.2.4.8, "Writing Audit Plugins"
Section 23.2.4.5, "Writing Daemon Plugins"
Section 23.2.4.4, "Writing Full-Text Parser Plugins"
Section 23.2.4.10, "Writing Password-Validation Plugins"
Section 23.2.4.7, "Writing Semisynchronous Replication Plugins"

port

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

preload_buffer_size

Section 5.1.4, "Server System Variables"

profiling

Section 13.7.5.31, "SHOW PROFILE Syntax"
Section 5.1.4, "Server System Variables"
Section 20.17, "The INFORMATION_SCHEMA PROFILING Table"

profiling_history_size

Section 13.7.5.31, "SHOW PROFILE Syntax"
Section 5.1.4, "Server System Variables"

protocol_version

Section 5.1.4, "Server System Variables"

proxy_user

Section 6.3.8, "Proxy Users"
Section 5.1.4, "Server System Variables"

pseudo_slave_mode

Section 5.1.4, "Server System Variables"

pseudo_thread_id

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

Q

[index top]

query_alloc_block_size

Section 5.1.4, "Server System Variables"

query_cache_limit

Section 8.9.3.3, "Query Cache Configuration"
Section 5.1.4, "Server System Variables"

query_cache_min_res_unit

Section 8.9.3.3, "Query Cache Configuration"
Section 5.1.4, "Server System Variables"

query_cache_size

Section 5.1.2.1, "Changes to Server Defaults"
Section 8.9.3.3, "Query Cache Configuration"
Section 5.1.4, "Server System Variables"
Section 8.9.3, "The MySQL Query Cache"
Section 5.1.5, "Using System Variables"

query_cache_type

Section 13.2.9, "SELECT Syntax"
Section 5.1.2.1, "Changes to Server Defaults"
Section 8.9.3.2, "Query Cache SELECT Options"
Section 8.9.3.3, "Query Cache Configuration"
Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"

query_cache_wlock_invalidate

Section 5.1.4, "Server System Variables"

query_prealloc_size

Section 5.1.4, "Server System Variables"

R

[index top]

rand_seed

Section 5.1.4, "Server System Variables"

range_alloc_block_size

Section 5.1.4, "Server System Variables"

read_buffer_size

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

read_only

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

read_rnd_buffer_size

Section 8.13.13, "ORDER BY Optimization"
Section 8.11.4.1, "How MySQL Uses Memory"
Section 8.13.11, "Multi-Range Read Optimization"
Section 5.1.4, "Server System Variables"
Section 8.11.2, "Tuning Server Parameters"

relay_log

Section 16.1.4.3, "Replication Slave Options and Variables"

relay_log_basename

Section 16.1.4.3, "Replication Slave Options and Variables"
Section 1.4, "What Is New in MySQL 5.6"

relay_log_index

Section 16.1.4.3, "Replication Slave Options and Variables"

relay_log_info_file

Section 16.1.4.3, "Replication Slave Options and Variables"

relay_log_info_repository

Section 16.1.4.3, "Replication Slave Options and Variables"

relay_log_purge

Section 13.4.2.1, "CHANGE MASTER TO Syntax"
Section 5.1.4, "Server System Variables"

relay_log_recovery

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

relay_log_space_limit

Section 8.12.5.6, "Replication Slave I/O Thread States"
Section 5.1.4, "Server System Variables"

report_host

Section 5.1.4, "Server System Variables"

report_password

Section 5.1.4, "Server System Variables"

report_port

Section 5.1.4, "Server System Variables"

report_user

Section 5.1.4, "Server System Variables"

rpl_semi_sync_master_enabled

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

rpl_semi_sync_master_timeout

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

rpl_semi_sync_master_trace_level

Section 5.1.4, "Server System Variables"

rpl_semi_sync_master_wait_no_slave

Section 5.1.4, "Server System Variables"

rpl_semi_sync_slave_enabled

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

rpl_semi_sync_slave_trace_level

Section 5.1.4, "Server System Variables"

S

[index top]

secure_auth

Section 5.1.2.1, "Changes to Server Defaults"
Section 6.1.2.4, "Password Hashing in MySQL"
Section 5.1.4, "Server System Variables"

secure_file_priv

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

server_id

Section 13.7.5.35, "SHOW SLAVE STATUS Syntax"
Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"
Section 12.16, "Miscellaneous Functions"
Section 17.6.11, "MySQL Cluster Replication Conflict Resolution"
Section 17.3.4.3, "MySQL Cluster System Variables"
Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"
Section 5.1.4, "Server System Variables"
Section 6.3.11.3, "The Audit Log File"
Section 16.1.2.2, "Usage of Row-Based Logging and Replication"

server_id_bits

Section 17.3.4.3, "MySQL Cluster System Variables"
Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

server_uuid

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

sha

Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"
Section 6.3.7.2, "The SHA-256 Authentication Plugin"

shared_memory

Section 5.1.4, "Server System Variables"

shared_memory_base_name

Section 5.1.4, "Server System Variables"

skip_external_locking

Section 8.10.5, "External Locking"
Section 5.1.4, "Server System Variables"

skip_name_resolve

Section 5.1.4, "Server System Variables"

skip_networking

Section 5.1.4, "Server System Variables"

skip_show_database

Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"

slave_allow_batching

Section 16.1.4.3, "Replication Slave Options and Variables"
Section 17.6.6, "Starting MySQL Cluster Replication (Single Replication Channel)"

slave_checkpoint_group

Section 16.1.4.3, "Replication Slave Options and Variables"

slave_checkpoint_period

Section 16.1.4.3, "Replication Slave Options and Variables"

slave_compressed_protocol

Section 16.1.4.3, "Replication Slave Options and Variables"

slave_exec_mode

Section 17.6.3, "Known Issues in MySQL Cluster Replication"
Section 17.6.10, "MySQL Cluster Replication: Multi-Master and Circular Replication"
Section 16.4.1.21, "Replication and MEMORY Tables"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 16.1.2.2, "Usage of Row-Based Logging and Replication"

slave_load_tmpdir

Section 13.2.6, "LOAD DATA INFILESyntax"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 5.1.4, "Server System Variables"

slave_max_allowed_packet

Section 16.1.4.3, "Replication Slave Options and Variables"

slave_net_timeout

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

slave_parallel_workers

Section 13.7.5.35, "SHOW SLAVE STATUS Syntax"
Section 13.4.2.5, "START SLAVE Syntax"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 1.4, "What Is New in MySQL 5.6"

slave_pending_jobs_size_max

Section 16.1.4.3, "Replication Slave Options and Variables"

slave_rows_search_algorithms

Section 16.1.4.3, "Replication Slave Options and Variables"

slave_skip_errors

Section 16.1.4.3, "Replication Slave Options and Variables"

slave_sql_verify_checksum

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

slave_transaction_retries

Section 16.4.1.28, "Replication Retries and Timeouts"
Section 16.1.4.3, "Replication Slave Options and Variables"

slave_type_conversions

Section 17.6.3, "Known Issues in MySQL Cluster Replication"
Section 16.1.4.3, "Replication Slave Options and Variables"

slow_launch_time

Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"

slow_query_log

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

slow_query_log_file

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

socket

Section 5.1.4, "Server System Variables"

sort_buffer_size

Section 8.13.13, "ORDER BY Optimization"
Section 7.6.3, "How to Repair MyISAM Tables"
Section 8.2.1.3, "Optimizing LIMIT Queries"
Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"
Section 1.4, "What Is New in MySQL 5.6"

sql_auto_is_null

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

sql_big_selects

Section 5.1.4, "Server System Variables"

sql_buffer_result

Section 5.1.4, "Server System Variables"

sql_log_bin

Section 13.4.1.3, "SET sql_log_bin Syntax"
Section 17.1.6.8, "Issues Exclusive to MySQL Cluster"
Section 17.6.3, "Known Issues in MySQL Cluster Replication"
Section 17.1.6.1, "Noncompliance with SQL Syntax in MySQL Cluster"
Section 5.1.4, "Server System Variables"
Section 16.4.3, "Upgrading a Replication Setup"

sql_log_off

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

SQL_MODE

Section 5.5.5, "Examples of Online DDL"
Section 5.5.1, "Overview of Online DDL"

sql_mode

Section 13.1.11, "CREATE EVENT Syntax"
Section 13.1.15, "CREATE PROCEDURE and CREATE FUNCTION Syntax"
Section 13.1.19, "CREATE TRIGGER Syntax"
Section 13.2.6, "LOAD DATA INFILESyntax"
Section 13.7.5.14, "SHOW CREATE VIEW Syntax"
Section 5.1.2.1, "Changes to Server Defaults"
Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"
Section 13.6.7.5.2, "Effect of Signals on Handlers, Cursors, and Statements"
Section 12.19.3, "Expression Handling"
Section 1.7, "How to Report Bugs or Problems"
Section 5.2.4.3, "Mixed Binary Logging Format"
Section C.5.5.2, "Problems Using DATE Columns"
Section 16.4.1.33, "Replication and Variables"
Section 1.8.3, "Running MySQL in ANSI Mode"
Section 1.8.2, "Selecting SQL Modes"
Section 5.1.7, "Server SQL Modes"
Section 5.1.4, "Server System Variables"
Section 20.29, "The INFORMATION_SCHEMA VIEWS Table"
Section 5.2.4, "The Binary Log"
Section 5.1.2.2, "Using a Sample Default Server Configuration File"
Section 5.1.5, "Using System Variables"

sql_notes

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

sql_quote_show_create

Section 13.7.5.8, "SHOW CREATE DATABASE Syntax"
Section 13.7.5.12, "SHOW CREATE TABLE Syntax"
Section 5.1.4, "Server System Variables"

sql_safe_updates

Section 5.1.4, "Server System Variables"

sql_select_limit

Section 5.1.4, "Server System Variables"

sql_slave_skip_counter

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

sql_warnings

Section 5.1.4, "Server System Variables"

ssl_ca

Section 5.1.4, "Server System Variables"

ssl_capath

Section 5.1.4, "Server System Variables"

ssl_cert

Section 5.1.4, "Server System Variables"

ssl_cipher

Section 5.1.4, "Server System Variables"

ssl_crl

Section 5.1.4, "Server System Variables"

ssl_crlpath

Section 5.1.4, "Server System Variables"

ssl_key

Section 5.1.4, "Server System Variables"

storage_engine

Section 13.1.14, "CREATE LOGFILE GROUP Syntax"
Section 16.4.1.33, "Replication and Variables"
Section 5.1.4, "Server System Variables"
Section 16.3.2, "Using Replication with Different Master and Slave Storage Engines"

stored_program_cache

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

sync_binlog

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

sync_frm

Section 5.1.4, "Server System Variables"

sync_master_info

Section 5.1.2.1, "Changes to Server Defaults"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

sync_relay_log

Section 5.1.2.1, "Changes to Server Defaults"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

sync_relay_log_info

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

system_time_zone

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

T

[index top]

table_definition_cache

Section 5.1.2.1, "Changes to Server Defaults"
Section 5.1.4, "Server System Variables"

table_open_cache

Section C.5.2.18, "'File' Not Found andSimilar Errors"
Section 14.2.6, "InnoDB Startup Options and System Variables"
Section 5.1.2.1, "Changes to Server Defaults"
Section 8.12.5.2, "General Thread States"
Section 8.4.3.1, "How MySQL Opens and Closes Tables"
Section 8.11.4.1, "How MySQL Uses Memory"
Section 5.1.3, "Server Command Options"
Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"
Section 8.11.2, "Tuning Server Parameters"
Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"
Section 1.4, "What Is New in MySQL 5.6"

table_open_cache_instances

Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"

thread_cache_size

Section 5.1.2.1, "Changes to Server Defaults"
Section 23.4.1.4, "Debugging mysqld under gdb"
Section 8.11.5.1, "How MySQL Uses Threads for Client Connections"
Section 8.2.5, "Other Optimization Tips"
Section 5.1.6, "Server Status Variables"
Section 5.1.4, "Server System Variables"

thread_concurrency

Section 5.1.4, "Server System Variables"

thread_handling

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

thread_pool_algorithm

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

thread_pool_high_priority_connection

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

thread_pool_max_unused_threads

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

thread_pool_prio_kickup_timer

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

thread_pool_size

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

thread_pool_stall_limit

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

thread_stack

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

time_format

Section 5.1.4, "Server System Variables"

time_zone

Section 13.1.11, "CREATE EVENT Syntax"
Section 12.7, "Date and Time Functions"
Section 19.4.4, "Event Metadata"
Section 5.2.4.3, "Mixed Binary Logging Format"
Section 10.6, "MySQL Server Time Zone Support"
Section 16.4.1.33, "Replication and Variables"
Section 5.1.3, "Server Command Options"
Section 5.1.4, "Server System Variables"
Section 11.3.1, "The DATE, DATETIME, andTIMESTAMP Types"

timed_mutexes

Section 13.7.5.16, "SHOW ENGINE Syntax"
Section 5.1.4, "Server System Variables"

timestamp

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

tmp_table_size

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

tmpdir

Section C.5.2.13, "Can't create/write to file"
Section 13.2.6, "LOAD DATA INFILESyntax"
Section 8.13.13, "ORDER BY Optimization"
Section 16.3.1.2, "Backing Up Raw Data from a Slave"
Section 7.2, "Database Backup Methods"
Section 5.5.6, "Implementation Details of Online DDL"
Section 5.5.9, "Limitations of Online DDL"
Section 16.1.4.3, "Replication Slave Options and Variables"
Section 5.1.4, "Server System Variables"

transaction_alloc_block_size

Section 5.1.4, "Server System Variables"

transaction_allow_batching

Section 17.3.4.3, "MySQL Cluster System Variables"

transaction_prealloc_size

Section 5.1.4, "Server System Variables"

tx_isolation

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

tx_read_only

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

U

[index top]

unique_checks

Section 5.4.3, "Converting Tables from MyISAM toInnoDB"
Section 5.2.4.3, "Mixed Binary Logging Format"
Section 16.4.1.33, "Replication and Variables"
Section 5.1.4, "Server System Variables"
Section 5.2.4, "The Binary Log"

updatable_views_with_limit

Section 5.1.4, "Server System Variables"
Section 19.5.3, "Updatable and Insertable Views"

V

[index top]

validate_password_dictionary_file

Section 6.1.2.6.2, "Password Validation Plugin Options and Variables"

validate_password_length

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

validate_password_mixed_case_count

Section 6.1.2.6.2, "Password Validation Plugin Options and Variables"

validate_password_number_count

Section 6.1.2.6.2, "Password Validation Plugin Options and Variables"

validate_password_policy

Section 6.1.2.6.2, "Password Validation Plugin Options and Variables"
Section 6.1.2.6, "The Password Validation Plugin"

validate_password_special_char_count

Section 6.1.2.6.2, "Password Validation Plugin Options and Variables"

validate_user_plugins

Section 5.1.4, "Server System Variables"

version

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

version_comment

Section 5.1.4, "Server System Variables"

version_compile_machine

Section 5.1.4, "Server System Variables"

version_compile_os

Section 5.1.4, "Server System Variables"

W

[index top]

wait_timeout

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

warning_count

Section 13.7.5.18, "SHOW ERRORS Syntax"
Section 13.7.5.41, "SHOW WARNINGS Syntax"
Section 13.6.7.7.4, "Diagnostics Area-Related System Variables"
Section 13.6.7.5.2, "Effect of Signals on Handlers, Cursors, and Statements"
Section 5.1.4, "Server System Variables"
Section C.1, "Sources of Error Information"