System Variable Index

System Variable Index
Prev

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

`authentication_windows_log_level`

Section 5.1.3, “Server System Variables”
Section 6.3.6.3.2, “Using the Windows Authentication Plugin”

`authentication_windows_use_principal_name`

Section 5.1.3, “Server System Variables”
Section 6.3.6.3.2, “Using the Windows Authentication Plugin”

`auto_increment_increment`

Section 5.2.4.3, “Mixed Binary Logging Format”
Section 17.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 16.4.1.33, “Replication and Variables”
Section 16.1.3.2, “Replication Master Options and Variables”
Section 14.3.5.3.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 17.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 16.4.1.33, “Replication and Variables”
Section 16.1.3.2, “Replication Master Options and Variables”
Section 14.3.5.3.1, “Traditional InnoDB Auto-Increment Locking”
Section 3.6.9, “Using AUTO_INCREMENT”

`AUTOCOMMIT`

Section 16.4.1.29, “Replication and Transactions”

`autocommit`

Section 13.2.2, “DELETE Syntax”
Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 14.3.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 14.3.9.8, “Deadlock Detection and Rollback”
Section 13.3.5.1, “Interaction of Table Locking and Transactions”
Section 14.3.15, “Limits on InnoDB Tables”
Section 14.3.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 17.3.4.3, “MySQL Cluster System Variables”
Section 16.4.1.29, “Replication and Transactions”
Section 5.1.3, “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 and CREATE FUNCTION Syntax”
Section 5.1.3, “Server System Variables”
Section 19.2.2, “Stored Routines and MySQL Privileges”

B

`back_log`

Section 5.1.3, “Server System Variables”

`basedir`

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

`big_tables`

Section 5.1.3, “Server System Variables”

`binlog_cache_size`

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.1.5, “Server Status Variables”
Section 5.2.4, “The Binary Log”

`binlog_direct_non_transactional_updates`

Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.4.1.29, “Replication and Transactions”

`binlog_format`

Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 16.1.3.4, “Binary Log Options and Variables”
Section 12.7, “Date and Time Functions”
Section 4.6.7, “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.15, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.18, “Replication and MEMORY Tables”
Section 16.4.1.29, “Replication and Transactions”
Section 16.1.2, “Replication Formats”
Section 16.4.1.20, “Replication of the mysql System Database”
Section 5.1.2, “Server Command Options”
Section 5.2.4.2, “Setting The Binary Log Format”
Section 14.9, “The BLACKHOLE Storage Engine”

`binlog_stmt_cache_size`

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.1.5, “Server Status Variables”

`bulk_insert_buffer_size`

Section 14.5.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 8.2.2.1, “Speed of INSERT Statements”

C

`character_set_client`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.7.4, “SET Syntax”
Section 13.7.5.9, “SHOW CREATE EVENT Syntax”
Section 13.7.5.11, “SHOW CREATE PROCEDURE Syntax”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 13.7.5.19, “SHOW EVENTS Syntax”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Syntax”
Section 13.7.5.39, “SHOW TRIGGERS Syntax”
Section 22.8.5.1, “C API Prepared Statement Type Codes”
Section 10.5, “Character Set Configuration”
Section 10.1.4, “Connection Character Sets and Collations”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 20.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 20.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 20.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”

`character_set_connection`

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

`character_set_database`

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

`character_set_filesystem`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
Section 10.1.12, “UTF-8 for Metadata”

`character_set_server`

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

`character_set_system`

Section 10.5, “Character Set Configuration”
Section 5.1.3, “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.3, “Server System Variables”

`collation_connection`

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

`collation_database`

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

`collation_server`

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

`completion_type`

Section 22.8.3.6, “mysql_commit()”
Section 22.8.3.57, “mysql_rollback()”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.1.3, “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 5.1.3, “Server System Variables”

`connect_timeout`

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

D

`datadir`

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

`date_format`

Section 5.1.3, “Server System Variables”

`datetime_format`

Section 5.1.3, “Server System Variables”

`debug`

Section 5.1.3, “Server System Variables”

`debug_sync`

Section 5.1.3, “Server System Variables”

`default_storage_engine`

Section 13.1.14, “CREATE LOGFILE GROUP Syntax”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 14.1, “Setting the Storage Engine”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”

`default_week_format`

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

`delay_key_write`

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

`delayed_insert_limit`

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

`delayed_insert_timeout`

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

`delayed_queue_size`

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

`div_precision_increment`

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

E

`engine_condition_pushdown`

Section 8.13.3, “Engine Condition Pushdown Optimization”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

`error_count`

Section 13.7.5.18, “SHOW ERRORS Syntax”
Section 5.1.3, “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.3, “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.3, “Server System Variables”

`external_user`

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

F

`flush`

Section 5.1.3, “Server System Variables”

`flush_time`

Section 5.1.3, “Server System Variables”

`foreign_key_checks`

Section 14.3.5.4, “FOREIGN KEY Constraints”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

`ft_boolean_syntax`

Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

`ft_max_word_len`

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.3, “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 5.1.3, “Server System Variables”

`ft_query_expansion_limit`

Section 5.1.3, “Server System Variables”

`ft_stopword_file`

Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 5.1.3, “Server System Variables”

G

`general_log`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “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.3, “Server System Variables”
Section 5.2.3, “The General Query Log”

`group_concat_max_len`

Section 12.16.1, “GROUP BY (Aggregate) Functions”
Section 5.1.3, “Server System Variables”

H

`have_compress`

Section 5.1.3, “Server System Variables”

`have_crypt`

Section 5.1.3, “Server System Variables”

`have_csv`

Section 5.1.3, “Server System Variables”

`have_dynamic_loading`

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

`have_geometry`

Section 5.1.3, “Server System Variables”

`have_innodb`

Section C.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 5.1.3, “Server System Variables”

`have_ndbcluster`

Section 17.3.4.3, “MySQL Cluster System Variables”

`have_openssl`

Section 5.1.3, “Server System Variables”
Section 6.3.8.2, “Using SSL Connections”

`have_partitioning`

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

`have_profiling`

Section 5.1.3, “Server System Variables”

`have_query_cache`

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

`have_rtree_keys`

Section 5.1.3, “Server System Variables”

`have_ssl`

Section 5.1.3, “Server System Variables”
Section 6.3.8.2, “Using SSL Connections”

`have_symlink`

Section 5.1.3, “Server System Variables”

`hostname`

Section 5.1.3, “Server System Variables”

I

`identity`

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

`init_connect`

Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

`init_file`

Section 5.1.3, “Server System Variables”

`init_slave`

Section 16.1.3.3, “Replication Slave Options and Variables”

`innodb_autoextend_increment`

Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 14.3.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 14.3.2, “Configuring InnoDB”

`innodb_autoinc_lock_mode`

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

`innodb_buffer_pool_instances`

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

`innodb_buffer_pool_size`

Section 14.3.13.1, “InnoDB Error Codes”
Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 8.9.1, “The InnoDB Buffer Pool”

`innodb_checksums`

Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_commit_concurrency`

Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_concurrency_tickets`

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

`innodb_data_file_path`

Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 14.3.6, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 14.3.2, “Configuring InnoDB”
Section 14.3.3.3, “Troubleshooting InnoDB I/O Problems”
Section 14.3.3.1, “Using Raw Devices for the Shared Tablespace”

`innodb_data_home_dir`

Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 14.3.2, “Configuring InnoDB”
Section 14.3.3.3, “Troubleshooting InnoDB I/O Problems”

`innodb_fast_shutdown`

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

`innodb_file_format`

Section 13.1.17, “CREATE TABLE Syntax”
Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_file_format_check`

Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_file_format_max`

Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_file_per_table`

Section 13.1.17, “CREATE TABLE Syntax”
Section 14.3.5.5, “InnoDB and MySQL Replication”
Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 14.3.14.2.2, “InnoDB Tablespace Monitor Output”
Section 14.3.3.2, “Creating the InnoDB Tablespace”
Section 16.3.4, “Replicating Different Databases to Different Slaves”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 14.3.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section 14.3.3, “Using Per-Table Tablespaces”

`innodb_flush_log_at_trx_commit`

Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 8.5.2, “Optimizing InnoDB Transaction Management”

`innodb_flush_method`

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

`innodb_force_load_corrupted`

Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_force_recovery`

Section 14.3.7.2, “Forcing InnoDB Recovery”
Section 1.7, “How to Report Bugs or Problems”

`innodb_io_capacity`

Section 1.4.2, “InnoDB I/O Subsystem Changes”

`innodb_large_prefix`

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

`innodb_lock_wait_timeout`

Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 14.3.9.8, “Deadlock Detection and Rollback”
Section 16.4.1.26, “Replication Retries and Timeouts”
Section 16.1.3.3, “Replication Slave Options and Variables”

`innodb_locks_unsafe_for_binlog`

Section 14.3.9.4, “InnoDB Record, Gap, and Next-Key Locks”
Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 14.3.9.2, “Consistent Nonlocking Reads”
Section 14.3.9.6, “Locks Set by Different SQL Statements in InnoDB”

`innodb_max_purge_lag`

Section 14.3.10, “InnoDB Multi-Versioning”
Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_old_blocks_pct`

Section 8.9.1, “The InnoDB Buffer Pool”

`innodb_old_blocks_time`

Section 8.9.1, “The InnoDB Buffer Pool”

`innodb_read_ahead_threshold`

Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_read_io_threads`

Section 1.4.2, “InnoDB I/O Subsystem Changes”
Section 14.3.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 23.1.1, “MySQL Threads”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

`innodb_stats_method`

Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”

`innodb_stats_sample_pages`

Section 14.3.15, “Limits on InnoDB Tables”

`innodb_strict_mode`

Section 13.1.13, “CREATE INDEX Syntax”
Section 13.1.17, “CREATE TABLE Syntax”
Section 5.1.6, “Server SQL Modes”

`innodb_support_xa`

Section 8.5.2, “Optimizing InnoDB Transaction Management”

`innodb_table_locks`

Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 14.3.15, “Limits on InnoDB Tables”

`innodb_thread_concurrency`

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

`innodb_use_native_aio`

Section 14.3.4, “InnoDB Startup Options and System Variables”

`innodb_write_io_threads`

Section 1.4.2, “InnoDB I/O Subsystem Changes”
Section 14.3.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 23.1.1, “MySQL Threads”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

`insert_id`

Section 14.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.1.3, “Server System Variables”

`interactive_timeout`

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

J

`join_buffer_size`

Section 8.13.6, “Nested-Loop Join Algorithms”
Section 5.1.3, “Server System Variables”

K

`keep_files_on_create`

Section 5.1.3, “Server System Variables”

`key_buffer_size`

Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 8.8.4, “Estimating Query Performance”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 7.6.3, “How to Repair MyISAM Tables”
Section C.5.8, “Known Issues in MySQL”
Section 8.9.2.2, “Multiple Key Caches”
Section 8.9.2.6, “Restructuring a Key Cache”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 8.2.2.3, “Speed of DELETE Statements”
Section 8.6.3, “Speed of REPAIR TABLE Statements”
Section 5.1.4.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.3, “Server System Variables”
Section 5.1.4.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.3, “Server System Variables”
Section 5.1.4.1, “Structured System Variables”

`key_cache_division_limit`

Section 8.9.2.3, “Midpoint Insertion Strategy”
Section 5.1.3, “Server System Variables”
Section 5.1.4.1, “Structured System Variables”

L

`language`

Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”

`large_files_support`

Section 18.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”

`large_page_size`

Section 5.1.3, “Server System Variables”

`large_pages`

Section 5.1.3, “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.3, “Server System Variables”

`lc_messages`

Section 5.1.3, “Server System Variables”
Section 10.2, “Setting the Error Message Language”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
Section 1.4, “What Is New in MySQL 5.5”

`lc_messages_dir`

Section 5.1.3, “Server System Variables”
Section 10.2, “Setting the Error Message Language”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 2.11.1.2, “Upgrading from MySQL 5.4 to 5.5”
Section 1.4, “What Is New in MySQL 5.5”

`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.3, “Server System Variables”
Section 12.5, “String Functions”

`license`

Section 5.1.3, “Server System Variables”

`local_infile`

Section 5.1.3, “Server System Variables”

`lock_wait_timeout`

Section 5.1.3, “Server System Variables”

`locked_in_memory`

Section 5.1.3, “Server System Variables”

`log`

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

`log_bin`

Section 16.1.3.4, “Binary Log Options and Variables”
Section 17.3.4.3, “MySQL Cluster System Variables”
Section 5.1.3, “Server System Variables”

`log_bin_trust_function_creators`

Section 16.1.3.4, “Binary Log Options and Variables”
Section 19.7, “Binary Logging of Stored Programs”
Section 5.1.3, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

`log_bin_use_v`

Section 16.1.3.4, “Binary Log Options and Variables”

`log_error`

Section 5.1.3, “Server System Variables”

`log_output`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “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.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`log_slave_updates`

Section 5.1.3, “Server System Variables”

`log_slow_queries`

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

`log_warnings`

Section 5.1.3, “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.3.3, “Replication Slave Options and Variables”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`low_priority_updates`

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

`lower_case_file_system`

Section 5.1.3, “Server System Variables”

`lower_case_table_names`

Section 14.3.5.4, “FOREIGN KEY Constraints”
Section 13.7.1.3, “GRANT Syntax”
Section 13.7.1.5, “REVOKE Syntax”
Section 10.1.7.9, “Collation and INFORMATION_SCHEMA Searches”
Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 1.7, “How to Report Bugs or Problems”
Section 9.2.2, “Identifier Case Sensitivity”
Section 21.1, “Performance Schema Quick Start”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”

M

`max_allowed_packet`

Section 12.16.1, “GROUP BY (Aggregate) Functions”
Section C.5.2.3, “Lost connection to MySQL server”
Section C.5.2.9, “MySQL server has gone away”
Section 22.8.7.26, “mysql_stmt_send_long_data()”
Section 22.8.3.71, “mysql_use_result()”
Section C.5.2.10, “Packet too large”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
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 16.4.1.17, “Replication and max_allowed_packet”
Section 16.1.3.2, “Replication Master Options and Variables”
Section 5.1.3, “Server System Variables”
Section 12.5, “String Functions”
Section 11.4.3, “The BLOB and TEXT Types”
Section 4.2.3.3, “Using Option Files”

`max_binlog_cache_size`

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

`max_binlog_size`

Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.2, “MySQL Server Logs”
Section 5.2.6, “Server Log Maintenance”
Section 5.1.3, “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.3.4, “Binary Log Options and Variables”

`max_connect_errors`

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

`max_connections`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section C.5.2.7, “Too many connections”
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.8, “Performance Schema System Variables”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 8.11.6.2, “Thread Pool Operation”

`max_delayed_threads`

Section 21.8, “Performance Schema System Variables”
Section 5.1.3, “Server System Variables”

`max_error_count`

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.6.7.3, “RESIGNAL Syntax”
Section 13.7.5.18, “SHOW ERRORS Syntax”
Section 13.7.5.41, “SHOW WARNINGS Syntax”
Section 5.1.3, “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.18, “Replication and MEMORY Tables”
Section 16.4.1.33, “Replication and Variables”
Section E.3, “Restrictions on Server-Side Cursors”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 14.6, “The MEMORY Storage Engine”

`max_insert_delayed_threads`

Section 5.1.3, “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.3, “Server System Variables”
Section 5.1.4, “Using System Variables”

`max_length_for_sort_data`

Section 8.13.9, “ORDER BY Optimization”
Section 5.1.3, “Server System Variables”

`max_long_data_size`

Section 22.8.7.26, “mysql_stmt_send_long_data()”
Section 5.1.3, “Server System Variables”

`max_prepared_stmt_count`

Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 13.5, “SQL Syntax for Prepared Statements”

`max_relay_log_size`

Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”
Section 16.2.2.1, “The Slave Relay Log”

`max_seeks_for_key`

Section 14.3.15, “Limits on InnoDB Tables”
Section 5.1.3, “Server System Variables”

`max_sort_length`

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

`max_sp_recursion_depth`

Section 5.1.3, “Server System Variables”
Section 19.2.1, “Stored Routine Syntax”

`max_tmp_tables`

Section 5.1.3, “Server System Variables”

`max_user_connections`

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

`max_write_lock_count`

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

`metadata_locks_cache_size`

Section 5.1.3, “Server System Variables”

`min_examined_row_limit`

Section 5.1.3, “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.3, “Server System Variables”

`myisam_max_sort_file_size`

Section 14.5.1, “MyISAM Startup Options”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”

`myisam_mmap_size`

Section 5.1.3, “Server System Variables”

`myisam_recover_options`

Section 5.1.3, “Server System Variables”

`myisam_repair_threads`

Section 5.1.3, “Server System Variables”

`myisam_sort_buffer_size`

Section 13.1.7, “ALTER TABLE Syntax”
Section 14.5.1, “MyISAM Startup Options”
Section 5.1.3, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”

`myisam_stats_method`

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

`myisam_use_mmap`

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

N

`named_pipe`

Section 5.1.3, “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_index_stat_cache_entries`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_index_stat_enable`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_index_stat_update_freq`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_join_pushdown`

Section 8.8.2, “EXPLAIN Output Format”
Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”
Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_apply_status`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_bin`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_binlog_index`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_empty_epochs`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_log_transaction_id`

Section 17.3.4.3, “MySQL Cluster System Variables”

`ndb_optimized_node_selection`

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

`ndb_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”

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

`net_read_timeout`

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

`net_retry_count`

Section 22.8.3.49, “mysql_options()”
Section 5.1.3, “Server System Variables”

`net_write_timeout`

Section 5.1.3, “Server System Variables”

`new`

Section 5.1.3, “Server System Variables”

O

`old`

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

`old_alter_table`

Section 13.1.7, “ALTER TABLE Syntax”
Section 5.1.3, “Server System Variables”

`old_passwords`

Section 5.1.3, “Server System Variables”

`one_shot`

Section 5.1.3, “Server System Variables”

`open_files_limit`

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 21.8, “Performance Schema System Variables”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”

`optimizer_prune_level`

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

`optimizer_search_depth`

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

`optimizer_switch`

Section 8.8.5.2, “Controlling Switchable Optimizations”
Section 8.13.3, “Engine Condition Pushdown Optimization”
Section 5.1.3, “Server System Variables”

P

`performance_schema`

Section 21.1, “Performance Schema Quick Start”
Section 21.2.2, “Performance Schema Startup Configuration”
Section 21.8, “Performance Schema System Variables”

`performance_schema_events_waits_history_long_size`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 21.8, “Performance Schema System Variables”
Section 21.7, “Performance Schema Table Descriptions”
Section 21.7.3.3, “The events_waits_history_long Table”

`performance_schema_events_waits_history_size`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 21.8, “Performance Schema System Variables”
Section 21.7, “Performance Schema Table Descriptions”
Section 21.7.3.2, “The events_waits_history Table”

`performance_schema_max_cond_classes`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_cond_instances`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_file_classes`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_file_handles`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_file_instances`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_mutex_classes`

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

`performance_schema_max_mutex_instances`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_rwlock_classes`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_rwlock_instances`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_table_handles`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_table_instances`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_thread_classes`

Section 21.8, “Performance Schema System Variables”

`performance_schema_max_thread_instances`

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

`pid_file`

Section 5.1.3, “Server System Variables”

`plugin_dir`

Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 13.7.5.26, “SHOW PLUGINS Syntax”
Section 6.1.2.1, “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.7.1, “Installing and Uninstalling Plugins”
Section 6.3.6.2.1, “Installing the PAM Authentication Plugin”
Section 6.3.6.3.1, “Installing the Windows Authentication Plugin”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.3.6, “Pluggable Authentication”
Section 14.2.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.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 20.14, “The INFORMATION_SCHEMA PLUGINS Table”
Section 6.3.6.2, “The PAM Authentication Plugin”
Section 6.3.6.5, “The Socket Peer-Credential Authentication Plugin”
Section 6.3.6.6, “The Test Authentication Plugin”
Section 6.3.6.3, “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.7, “Writing Semisynchronous Replication Plugins”

`port`

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

`preload_buffer_size`

Section 5.1.3, “Server System Variables”

`profiling`

Section 13.7.5.32, “SHOW PROFILES Syntax”
Section 5.1.3, “Server System Variables”
Section 20.16, “The INFORMATION_SCHEMA PROFILING Table”

`profiling_history_size`

Section 13.7.5.32, “SHOW PROFILES Syntax”
Section 5.1.3, “Server System Variables”

`protocol_version`

Section 5.1.3, “Server System Variables”

`proxy_user`

Section 6.3.7, “Proxy Users”
Section 5.1.3, “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.3, “Server System Variables”

Q

`query_alloc_block_size`

Section 5.1.3, “Server System Variables”

`query_cache_limit`

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

`query_cache_min_res_unit`

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

`query_cache_size`

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

`query_cache_type`

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

`query_cache_wlock_invalidate`

Section 5.1.3, “Server System Variables”

`query_prealloc_size`

Section 5.1.3, “Server System Variables”

R

`rand_seed`

Section 5.1.3, “Server System Variables”

`range_alloc_block_size`

Section 5.1.3, “Server System Variables”

`read_buffer_size`

Section 8.11.4.1, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”
Section 1.4, “What Is New in MySQL 5.5”

`read_only`

Section 13.7.1.6, “SET PASSWORD 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.3, “Server System Variables”

`read_rnd_buffer_size`

Section 8.13.9, “ORDER BY Optimization”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 5.1.3, “Server System Variables”
Section 8.11.2, “Tuning Server Parameters”

`relay_log_index`

Section 16.1.3.3, “Replication Slave Options and Variables”

`relay_log_info_file`

Section 16.1.3.3, “Replication Slave Options and Variables”

`relay_log_purge`

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

`relay_log_recovery`

Section 16.1.3.3, “Replication Slave Options and Variables”

`relay_log_space_limit`

Section 8.12.5.6, “Replication Slave I/O Thread States”
Section 5.1.3, “Server System Variables”

`report_host`

Section 5.1.3, “Server System Variables”

`report_password`

Section 5.1.3, “Server System Variables”

`report_port`

Section 5.1.3, “Server System Variables”

`report_user`

Section 5.1.3, “Server System Variables”

`Rpl_recovery_rank`

Section 13.7.5.34, “SHOW SLAVE HOSTS Syntax”

`rpl_recovery_rank`

Section 16.1.3.3, “Replication Slave Options and 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.3, “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.3, “Server System Variables”

`rpl_semi_sync_master_trace_level`

Section 5.1.3, “Server System Variables”

`rpl_semi_sync_master_wait_no_slave`

Section 5.1.3, “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.3, “Server System Variables”

`rpl_semi_sync_slave_trace_level`

Section 5.1.3, “Server System Variables”

S

`secure_auth`

Section 5.1.3, “Server System Variables”

`secure_file_priv`

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

`server_id`

Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 12.15, “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.3, “Server System Variables”
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”

`shared_memory`

Section 5.1.3, “Server System Variables”

`shared_memory_base_name`

Section 5.1.3, “Server System Variables”

`skip_external_locking`

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

`skip_name_resolve`

Section 5.1.3, “Server System Variables”

`skip_networking`

Section 5.1.3, “Server System Variables”

`skip_show_database`

Section 5.1.3, “Server System Variables”

`slave_allow_batching`

Section 17.3.4.3, “MySQL Cluster System Variables”
Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”

`slave_compressed_protocol`

Section 16.1.3.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.18, “Replication and MEMORY Tables”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.1.2.2, “Usage of Row-Based Logging and Replication”

`slave_load_tmpdir`

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

`slave_max_allowed_packet`

Section 16.1.3.2, “Replication Master Options and Variables”

`slave_net_timeout`

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 16.1.4.1, “Checking Replication Status”
Section 16.4.1.16, “Replication and Master or Slave Shutdowns”
Section 8.12.5.6, “Replication Slave I/O Thread States”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

`slave_skip_errors`

Section 16.1.3.3, “Replication Slave Options and Variables”

`slave_transaction_retries`

Section 16.4.1.26, “Replication Retries and Timeouts”
Section 16.1.3.3, “Replication Slave Options and Variables”

`slave_type_conversions`

Section 17.6.3, “Known Issues in MySQL Cluster Replication”
Section 16.1.3.3, “Replication Slave Options and Variables”

`slow_launch_time`

Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

`slow_query_log`

Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.3, “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.3, “Server System Variables”
Section 5.2.5, “The Slow Query Log”

`socket`

Section 5.1.3, “Server System Variables”

`sort_buffer_size`

Section 8.13.9, “ORDER BY Optimization”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

`sql_auto_is_null`

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

`sql_big_selects`

Section 5.1.3, “Server System Variables”

`sql_buffer_result`

Section 5.1.3, “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.3, “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.3, “Server System Variables”
Section 5.2.3, “The General Query Log”

`sql_log_update`

Section 5.1.3, “Server System Variables”

`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.7.5.14, “SHOW CREATE VIEW Syntax”
Section 13.7.5.39, “SHOW TRIGGERS Syntax”
Section 13.6.7.4.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 12.18.3, “Expression Handling”
Section 1.7, “How to Report Bugs or Problems”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section C.5.5.2, “Problems Using DATE Columns”
Section 16.4.1.33, “Replication and Variables”
Section 1.8.3, “Running MySQL in ANSI Mode”
Section 1.8.2, “Selecting SQL Modes”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 20.18, “The INFORMATION_SCHEMA ROUTINES Table”
Section 20.26, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 5.2.4, “The Binary Log”
Section 5.1.4, “Using System Variables”

`sql_notes`

Section 13.7.5.41, “SHOW WARNINGS Syntax”
Section 5.1.3, “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.3, “Server System Variables”

`sql_safe_updates`

Section 5.1.3, “Server System Variables”

`sql_select_limit`

Section 5.1.3, “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.3.3, “Replication Slave Options and Variables”

`sql_warnings`

Section 5.1.3, “Server System Variables”

`ssl_ca`

Section 5.1.3, “Server System Variables”

`ssl_capath`

Section 5.1.3, “Server System Variables”

`ssl_cert`

Section 5.1.3, “Server System Variables”

`ssl_cipher`

Section 5.1.3, “Server System Variables”

`ssl_key`

Section 5.1.3, “Server System Variables”

`storage_engine`

Section 13.1.14, “CREATE LOGFILE GROUP Syntax”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 16.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 1.4, “What Is New in MySQL 5.5”

`stored_program_cache`

Section 5.1.3, “Server System Variables”

`sync_binlog`

Section 14.3.4, “InnoDB Startup Options and System Variables”
Section 16.1.3.4, “Binary Log Options and Variables”
Section 16.4.1.16, “Replication and Master or Slave Shutdowns”
Section 5.2.4, “The Binary Log”

`sync_frm`

Section 5.1.3, “Server System Variables”

`sync_master_info`

Section 16.1.3.3, “Replication Slave Options and Variables”

`sync_relay_log`

Section 16.1.3.3, “Replication Slave Options and Variables”

`sync_relay_log_info`

Section 16.4.1.16, “Replication and Master or Slave Shutdowns”
Section 16.1.3.3, “Replication Slave Options and Variables”

`system_time_zone`

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

T

`table_definition_cache`

Section 5.1.3, “Server System Variables”

`table_lock_wait_timeout`

Section 5.1.3, “Server System Variables”

`table_open_cache`

Section C.5.2.18, “'File' Not Found and Similar Errors”
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.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 8.11.2, “Tuning Server Parameters”

`table_type`

Section 5.1.3, “Server System Variables”

`thread_cache_size`

Section 23.4.1.4, “Debugging mysqld under gdb”
Section 8.11.5.1, “How MySQL Uses Threads for Client Connections”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

`thread_concurrency`

Section 5.1.3, “Server System Variables”

`thread_handling`

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

`thread_pool_algorithm`

Section 5.1.3, “Server System Variables”
Section 20.30.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.3, “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.3, “Server System Variables”
Section 8.11.6.1, “Thread Pool Components and Installation”

`thread_pool_prio_kickup_timer`

Section 5.1.3, “Server System Variables”
Section 20.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 20.30.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.3, “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.3, “Server System Variables”
Section 20.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 20.30.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.3, “Server System Variables”
Section 19.2.1, “Stored Routine Syntax”

`time_format`

Section 5.1.3, “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.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 11.3.1, “The DATE, DATETIME, and TIMESTAMP Types”

`timed_mutexes`

Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 5.1.3, “Server System Variables”

`timestamp`

Section 14.11.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.3, “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.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”

`tmpdir`

Section C.5.2.13, “Can't create/write to file”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 8.13.9, “ORDER BY Optimization”
Section 16.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.2, “Database Backup Methods”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”

`transaction_alloc_block_size`

Section 5.1.3, “Server System Variables”

`transaction_allow_batching`

Section 17.3.4.3, “MySQL Cluster System Variables”

`transaction_prealloc_size`

Section 5.1.3, “Server System Variables”

`tx_isolation`

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

U

`unique_checks`

Section 14.3.5.2, “Converting Tables from Other Storage Engines to InnoDB”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.4.1.33, “Replication and Variables”
Section 5.1.3, “Server System Variables”
Section 5.2.4, “The Binary Log”

`updatable_views_with_limit`

Section 5.1.3, “Server System Variables”
Section 19.5.3, “Updatable and Insertable Views”

V

`version`

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

`version_comment`

Section 5.1.3, “Server System Variables”

`version_compile_machine`

Section 5.1.3, “Server System Variables”

`version_compile_os`

Section 5.1.3, “Server System Variables”

W

`wait_timeout`

Section C.5.2.9, “MySQL server has gone away”
Section 22.8.3.52, “mysql_real_connect()”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 5.1.3, “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.4.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 5.1.3, “Server System Variables”
Section C.1, “Sources of Error Information”

Prev
Statement/Syntax Index	Home