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.5.2.4, “Audit Log Logging Control”
Section 6.5.2.7, “Audit Log Options and System Variables”

audit_log_file

Section 6.5.2.4, “Audit Log Logging Control”
Section 6.5.2.7, “Audit Log Options and System Variables”
Section 6.5.2, “MySQL Enterprise Audit”
Section 6.5.2.2, “MySQL Enterprise Audit Security Considerations”

audit_log_flush

Section 6.5.2.4, “Audit Log Logging Control”
Section 6.5.2.7, “Audit Log Options and System Variables”

audit_log_format

Section 6.5.2.7, “Audit Log Options and System Variables”
Section 6.5.2, “MySQL Enterprise Audit”
Section 6.5.2.3, “The Audit Log File”

audit_log_policy

Section 6.5.2.5, “Audit Log Filtering”
Section 6.5.2.7, “Audit Log Options and System Variables”
Section 6.5.2, “MySQL Enterprise Audit”

audit_log_rotate_on_size

Section 6.5.2.4, “Audit Log Logging Control”
Section 6.5.2.7, “Audit Log Options and System Variables”

audit_log_strategy

Section 6.5.2.4, “Audit Log Logging Control”
Section 6.5.2.7, “Audit Log Options and System Variables”

authentication_windows_log_level

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

authentication_windows_use_principal_name

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

auto_increment_increment

Section 14.11.6, “AUTO_INCREMENT Handling in InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.1, “MySQL 5.5 FAQ: General”
Section 18.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 17.4.1.38, “Replication and Variables”
Section 17.1.3.2, “Replication Master Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

auto_increment_offset

Section 14.11.6, “AUTO_INCREMENT Handling in InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.1, “MySQL 5.5 FAQ: General”
Section 18.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 17.4.1.38, “Replication and Variables”
Section 17.1.3.2, “Replication Master Options and Variables”
Section 3.6.9, “Using AUTO_INCREMENT”

AUTOCOMMIT

Section 17.4.1.35, “Replication and Transactions”

autocommit

Section 14.8.2.2, “autocommit, Commit, and Rollback”
Section 14.11.5, “Converting Tables from MyISAM to InnoDB”
Section 14.8.5.2, “Deadlock Detection and Rollback”
Section 13.2.2, “DELETE Syntax”
Section 14.8, “InnoDB Locking and Transaction Model”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 13.3.5.1, “Interaction of Table Locking and Transactions”
Section 14.11.8, “Limits on InnoDB Tables”
Section 14.8.2.4, “Locking Reads”
Section 14.8.3, “Locks Set by Different SQL Statements in InnoDB”
Section 18.3.3.8.2, “MySQL Cluster System Variables”
Section 17.4.1.35, “Replication and Transactions”
Section 5.1.4, “Server System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 5.5.4.3, “Thread Pool Operation”
Section 14.8.2.1, “Transaction Isolation Levels”

automatic_sp_privileges

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

B

[index top]

back_log

Section 5.1.4, “Server System Variables”

basedir

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

big_tables

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 5.1.4, “Server System Variables”

binlog_cache_size

Section 17.1.3.4, “Binary Log Options and Variables”
Section 5.1.6, “Server Status Variables”
Section 5.4.4, “The Binary Log”

binlog_checksum

MySQL Glossary

binlog_direct_non_transactional_updates

Section 17.1.3.4, “Binary Log Options and Variables”
Section 17.4.1.35, “Replication and Transactions”

binlog_format

Section 17.1.3.4, “Binary Log Options and Variables”
Section 12.7, “Date and Time Functions”
Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 18.6.2, “General Requirements for MySQL Cluster Replication”
Section 12.14, “Information Functions”
Section 13.2.5.2, “INSERT DELAYED Syntax”
Section 5.4.4.4, “Logging Format for Changes to mysql Database Tables”
Section 12.6.2, “Mathematical Functions”
Section 12.16, “Miscellaneous Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.13, “MySQL 5.5 FAQ: Replication”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 17.4.1.2, “Replication and BLACKHOLE Tables”
Section 17.4.1.23, “Replication and MEMORY Tables”
Section 17.4.1.24, “Replication and Temporary Tables”
Section 17.4.1.35, “Replication and Transactions”
Section 17.1.2, “Replication Formats”
Section 17.4.1.25, “Replication of the mysql System Database”
Section 5.1.3, “Server Command Options”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 15.7, “The BLACKHOLE Storage Engine”
Section 5.4.3, “The General Query Log”

binlog_stmt_cache_size

Section 17.1.3.4, “Binary Log Options and Variables”
Section 5.1.6, “Server Status Variables”

bulk_insert_buffer_size

Section 15.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 23.8.9.1, “C API Prepared Statement Type Codes”
Section 10.5, “Character Set Configuration”
Section 10.1.5, “Connection Character Sets and Collations”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.11, “MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Syntax”
Section 13.7.4.3, “SET NAMES 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 5.4.4, “The Binary Log”
Section 21.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 21.17, “The INFORMATION_SCHEMA ROUTINES Table”
Section 21.25, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 21.27, “The INFORMATION_SCHEMA VIEWS Table”

character_set_connection

Section 10.1.4.5, “Character String Literal Character Set and Collation”
Section 10.1.8.4, “Collation of Expressions”
Section 10.1.5, “Connection Character Sets and Collations”
Section 10.1.10.2, “CONVERT() and CAST()”
Section 12.7, “Date and Time Functions”
Section 12.13, “Encryption and Compression Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.11, “MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 10.7, “MySQL Server Locale Support”
Section 17.4.1.38, “Replication and Variables”
Section 10.1.10.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Syntax”
Section 13.7.4.3, “SET NAMES Syntax”
Section 9.1.1, “String Literals”
Section 10.1.9, “String Repertoire”
Section 12.2, “Type Conversion in Expression Evaluation”

character_set_database

Section 10.1.5, “Connection Character Sets and Collations”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 10.1.4.2, “Database Character Set and Collation”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Syntax”

character_set_filesystem

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

character_set_results

Section 23.8.5, “C API Data Structures”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.5”
Section 10.1.7, “Character Set for Error Messages”
Section 10.1.5, “Connection Character Sets and Collations”
Section A.11, “MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.1.4, “Server System Variables”
Section 13.7.4.2, “SET CHARACTER SET Syntax”
Section 13.7.4.3, “SET NAMES Syntax”
Section 10.1.12, “UTF-8 for Metadata”

character_set_server

Section 10.5, “Character Set Configuration”
Section 10.1.5, “Connection Character Sets and Collations”
Section 10.1.4.2, “Database Character Set and Collation”
Section 12.9.4, “Full-Text Stopwords”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.3, “Replication and Character Sets”
Section 17.4.1.38, “Replication and Variables”
Section 10.1.4.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.4.5, “Character String Literal Character Set and Collation”
Section 10.1.8.4, “Collation of Expressions”
Section 10.1.5, “Connection Character Sets and Collations”
Section 10.1.10.2, “CONVERT() and CAST()”
Section 12.7, “Date and Time Functions”
Section 12.13, “Encryption and Compression Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 10.1.10.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 13.7.4.3, “SET NAMES 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 5.4.4, “The Binary Log”
Section 21.7, “The INFORMATION_SCHEMA EVENTS Table”
Section 21.17, “The INFORMATION_SCHEMA ROUTINES Table”
Section 21.25, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 21.27, “The INFORMATION_SCHEMA VIEWS Table”
Section 12.2, “Type Conversion in Expression Evaluation”

collation_database

Section 10.1.5, “Connection Character Sets and Collations”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 10.1.4.2, “Database Character Set and Collation”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.4.4, “The Binary Log”

collation_server

Section 10.1.5, “Connection Character Sets and Collations”
Section 10.1.4.2, “Database Character Set and Collation”
Section 12.9.4, “Full-Text Stopwords”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 10.1.4.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”
Section 5.4.4, “The Binary Log”

completion_type

Section 23.8.7.6, “mysql_commit()”
Section 23.8.7.57, “mysql_rollback()”
Section 5.1.4, “Server System Variables”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

concurrent_insert

Section 8.11.3, “Concurrent Inserts”
Section 8.11.1, “Internal Locking Methods”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 5.1.4, “Server System Variables”

connect_timeout

Section B.5.2.11, “Communication Errors and Aborted Connections”
Section B.5.2.3, “Lost connection to MySQL server”
Section 23.8.7.52, “mysql_real_connect()”
Section 5.1.4, “Server System Variables”

D

[index top]

datadir

Section 14.9.1, “InnoDB Startup Configuration”
Section 2.3, “Installing MySQL on Microsoft Windows”
MySQL Glossary
Section 5.1.4, “Server System Variables”

date_format

Section 5.1.4, “Server System Variables”

datetime_format

Section 5.1.4, “Server System Variables”

debug

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

debug_sync

Section 5.1.4, “Server System Variables”

default_storage_engine

Section 13.1.14, “CREATE LOGFILE GROUP Syntax”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 15.1, “Setting the Storage Engine”
Section 17.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 1.4, “What Is New in MySQL 5.5”

default_week_format

Section 12.7, “Date and Time Functions”
Section 19.5.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”

div_precision_increment

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

E

[index top]

engine_condition_pushdown

Section 8.2.1.5, “Engine Condition Pushdown Optimization”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

error_count

Section 5.1.4, “Server System Variables”
Section 13.7.5.18, “SHOW ERRORS Syntax”
Section B.1, “Sources of Error Information”

event_scheduler

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

expire_logs_days

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

external_user

Section 24.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 6.3.7, “Proxy Users”
Section 5.1.4, “Server System Variables”
Section 24.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.4, “Server System Variables”

foreign_key_checks

Section 13.1.7, “ALTER TABLE Syntax”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 5.4.4, “The Binary Log”
Section 13.1.17.3, “Using FOREIGN KEY Constraints”

ft_boolean_syntax

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

ft_max_word_len

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

ft_min_word_len

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

ft_query_expansion_limit

Section 5.1.4, “Server System Variables”

ft_stopword_file

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

G

[index top]

general_log

MySQL Glossary
Section 5.4.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.4.3, “The General Query Log”

general_log_file

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

group_concat_max_len

Section 12.17.1, “Aggregate (GROUP BY) Function Descriptions”
Section 5.1.4, “Server System Variables”

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 17.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 B.5.4.5, “Rollback Failure for Nontransactional Tables”
Section 5.1.4, “Server System Variables”

have_ndbcluster

Section 18.3.3.8.2, “MySQL Cluster System Variables”

have_openssl

Section 5.1.4, “Server System Variables”

have_partitioning

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

have_profiling

Section 5.1.4, “Server System Variables”

have_query_cache

Section 8.10.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.4.2, “Building MySQL with Support for Secure Connections”
Section 5.1.4, “Server System Variables”

have_symlink

Section 5.1.4, “Server System Variables”
Section 8.12.4.3, “Using Symbolic Links for Databases on Windows”
Section 8.12.4.2, “Using Symbolic Links for MyISAM Tables on Unix”

hostname

Section 5.1.4, “Server System Variables”

I

[index top]

identity

Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”

init_connect

Section 10.1.6, “Configuring the Character Set and Collation for Applications”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

init_file

Section 5.1.4, “Server System Variables”

init_slave

Section 17.1.3.3, “Replication Slave Options and Variables”

innodb

Section 14.10.4.1, “Enabling and Disabling File-Per-Table Tablespaces”
Section A.15, “MySQL 5.5 FAQ: InnoDB Change Buffer”

innodb_adaptive_flushing

Section 14.9.2.5, “Configuring InnoDB Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.9.2.1, “The InnoDB Buffer Pool”

innodb_adaptive_hash_index

Section 14.7.3, “Adaptive Hash Index”
Section 14.9.5, “Configuring Thread Concurrency for InnoDB”
MySQL Glossary
Section 8.5.8, “Optimizing InnoDB Configuration Variables”
Section 13.1.33, “TRUNCATE TABLE Syntax”
Section 1.4, “What Is New in MySQL 5.5”

innodb_additional_mem_pool_size

Section 14.9.3, “Configuring the Memory Allocator for InnoDB”
Section 14.9.1, “InnoDB Startup Configuration”

innodb_autoextend_increment

Section 14.10.4, “InnoDB File-Per-Table Tablespaces”
Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.10.1, “Resizing the InnoDB System Tablespace”

innodb_autoinc_lock_mode

Section 14.11.6, “AUTO_INCREMENT Handling in InnoDB”
Section 8.5.4, “Bulk Data Loading for InnoDB Tables”
Section 12.14, “Information Functions”
Section 14.8.1, “InnoDB Locking”
Section 14.11.8, “Limits on InnoDB Tables”
MySQL Glossary

innodb_buffer_pool_dump_at_shutdown

MySQL Glossary

innodb_buffer_pool_instances

Section 14.9.2.2, “Configuring Multiple Buffer Pool Instances”
Section 14.11.5, “Converting Tables from MyISAM to InnoDB”
Section 8.12.5.1, “How MySQL Uses Memory”
Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.9.2.1, “The InnoDB Buffer Pool”

innodb_buffer_pool_load_at_startup

MySQL Glossary

innodb_buffer_pool_size

Section 14.9.2.2, “Configuring Multiple Buffer Pool Instances”
Section 14.11.5, “Converting Tables from MyISAM to InnoDB”
Section 8.12.5.1, “How MySQL Uses Memory”
Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section B.3, “Server Error Codes and Messages”
Section 14.9.2.1, “The InnoDB Buffer Pool”

innodb_change_buffer_max_size

MySQL Glossary

innodb_change_buffering

Section 14.7.2, “Change Buffer”
Section 14.9.4, “Configuring InnoDB Change Buffering”
MySQL Glossary
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 8.5.2, “Optimizing InnoDB Transaction Management”

innodb_checksums

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

innodb_commit_concurrency

Section 14.17, “InnoDB Startup Options and System Variables”

innodb_compression_failure_threshold_pct

MySQL Glossary

innodb_compression_level

MySQL Glossary

innodb_compression_pad_pct_max

MySQL Glossary

innodb_concurrency_tickets

Section 14.9.5, “Configuring Thread Concurrency for InnoDB”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 8.5.8, “Optimizing InnoDB Configuration Variables”

innodb_data_file_path

Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 14.10.1, “Resizing the InnoDB System Tablespace”
Section 14.7.5, “System Tablespace”
Section 14.23.1, “Troubleshooting InnoDB I/O Problems”
Section 14.10.3, “Using Raw Disk Partitions for the System Tablespace”

innodb_data_home_dir

Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 14.23.1, “Troubleshooting InnoDB I/O Problems”

innodb_default_row_format

MySQL Glossary

innodb_doublewrite

Section 14.7.7, “Doublewrite Buffer”
Section 14.5, “InnoDB and the ACID Model”
Section 14.15.1, “InnoDB Disk I/O”
Section 14.9.1, “InnoDB Startup Configuration”
MySQL Glossary

innodb_fast_shutdown

Section 14.10.2, “Changing the Number or Size of InnoDB Redo Log Files”
Section 14.13.2.1, “Compatibility Check When InnoDB Is Started”
Section 2.11.2, “Downgrading MySQL”
MySQL Glossary
Section 14.21.1, “The InnoDB Recovery Process”
Section 5.1.11, “The Server Shutdown Process”
Section 2.11.1, “Upgrading MySQL”

innodb_file_format

Section 14.13.2.2, “Compatibility Check When a Table Is Opened”
Section 14.13.2.1, “Compatibility Check When InnoDB Is Started”
Section 14.11.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.17, “CREATE TABLE Syntax”
Section 14.11.1, “Creating InnoDB Tables”
Section 14.14.3, “DYNAMIC and COMPRESSED Row Formats”
Section 14.12.2, “Enabling Compression for a Table”
Section 14.13.1, “Enabling File Formats”
Section 14.13.3, “Identifying the File Format in Use”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 14.12.6, “SQL Compression Syntax Warnings and Errors”
Section 14.1.4, “Upward and Downward Compatibility”

innodb_file_format_check

Section 14.13.2.2, “Compatibility Check When a Table Is Opened”
Section 14.13.2.1, “Compatibility Check When InnoDB Is Started”
Section 14.17, “InnoDB Startup Options and System Variables”

innodb_file_format_max

Section 14.17, “InnoDB Startup Options and System Variables”

innodb_file_per_table

Section 14.11.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.17, “CREATE TABLE Syntax”
Section 14.11.1, “Creating InnoDB Tables”
Section 14.14.3, “DYNAMIC and COMPRESSED Row Formats”
Section 14.10.4.1, “Enabling and Disabling File-Per-Table Tablespaces”
Section 14.12.2, “Enabling Compression for a Table”
Section 14.13.1, “Enabling File Formats”
Section 14.15.2, “File Space Management”
Section 14.7.9, “File-Per-Table Tablespaces”
Section 14.22, “InnoDB and MySQL Replication”
Section 14.5, “InnoDB and the ACID Model”
Section 14.10.4, “InnoDB File-Per-Table Tablespaces”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 14.20.4, “InnoDB Tablespace Monitor Output”
MySQL Glossary
Section 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section 14.15.5, “Reclaiming Disk Space with TRUNCATE TABLE”
Section 17.3.4, “Replicating Different Databases to Different Slaves”
Section 19.5, “Restrictions and Limitations on Partitioning”
Section 14.12.6, “SQL Compression Syntax Warnings and Errors”
Section 14.23.3, “Troubleshooting InnoDB Data Dictionary Operations”
Section 1.4, “What Is New in MySQL 5.5”

innodb_flush_log_at_timeout

Section 14.7.4, “Redo Log Buffer”

innodb_flush_log_at_trx_commit

Section 14.5, “InnoDB and the ACID Model”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 14.7.4, “Redo Log Buffer”

innodb_flush_method

Section 14.10.4, “InnoDB File-Per-Table Tablespaces”
Section 8.5.7, “Optimizing InnoDB Disk I/O”

innodb_flush_neighbors

MySQL Glossary

innodb_force_load_corrupted

Section 14.17, “InnoDB Startup Options and System Variables”

innodb_force_recovery

Section 14.23.2, “Forcing InnoDB Recovery”
Section 1.6, “How to Report Bugs or Problems”
Section 8.5.2, “Optimizing InnoDB Transaction Management”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 14.21.1, “The InnoDB Recovery Process”

innodb_ft_cache_size

MySQL Glossary

innodb_io_capacity

Section 14.9.7, “Configuring the InnoDB Master Thread I/O Rate”
Section 14.17, “InnoDB Startup Options and System Variables”
Section A.15, “MySQL 5.5 FAQ: InnoDB Change Buffer”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 1.4, “What Is New in MySQL 5.5”

innodb_large_prefix

Section 2.11.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 8.3.4, “Column Indexes”
Section 13.1.13, “CREATE INDEX Syntax”
Section 13.1.17, “CREATE TABLE Syntax”
Section 14.11.8, “Limits on InnoDB Tables”
MySQL Glossary

innodb_lock_wait_timeout

Section 14.8.5.2, “Deadlock Detection and Rollback”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 17.4.1.32, “Replication Retries and Timeouts”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section B.3, “Server Error Codes and Messages”
Section 1.4, “What Is New in MySQL 5.5”

innodb_locks_unsafe_for_binlog

Section 14.8.2.3, “Consistent Nonlocking Reads”
Section 14.8.1, “InnoDB Locking”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 14.8.3, “Locks Set by Different SQL Statements in InnoDB”
MySQL Glossary
Section 14.8.2.1, “Transaction Isolation Levels”

innodb_log_buffer_size

Section 14.9.1, “InnoDB Startup Configuration”
MySQL Glossary
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 8.5.3, “Optimizing InnoDB Redo Logging”
Section 14.7.4, “Redo Log Buffer”

innodb_log_file_size

Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 8.5.3, “Optimizing InnoDB Redo Logging”

innodb_log_files_in_group

Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.3, “Optimizing InnoDB Redo Logging”

innodb_log_group_home_dir

Section 14.9.1, “InnoDB Startup Configuration”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary

innodb_lru_scan_depth

MySQL Glossary

innodb_max_dirty_pages_pct

Section 14.9.2.5, “Configuring InnoDB Buffer Pool Flushing”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.9.2.1, “The InnoDB Buffer Pool”

innodb_max_purge_lag

Section 14.6, “InnoDB Multi-Versioning”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 8.5.7, “Optimizing InnoDB Disk I/O”

innodb_old_blocks_pct

Section 14.17, “InnoDB Startup Options and System Variables”
Section 14.9.2.3, “Making the Buffer Pool Scan Resistant”
MySQL Glossary
Section 14.9.2.1, “The InnoDB Buffer Pool”

innodb_old_blocks_time

Section 14.9.2.3, “Making the Buffer Pool Scan Resistant”
Section 14.9.2.6, “Monitoring the Buffer Pool Using the InnoDB Standard Monitor”
MySQL Glossary
Section 14.9.2.1, “The InnoDB Buffer Pool”

innodb_online_alter_log_max_size

MySQL Glossary

innodb_open_files

Section 8.5.7, “Optimizing InnoDB Disk I/O”

innodb_page_size

MySQL Glossary

innodb_print_all_deadlocks

Section 14.8.5, “Deadlocks in InnoDB”
Section 14.8.5.3, “How to Minimize and Handle Deadlocks”
Section 14.23, “InnoDB Troubleshooting”

innodb_purge_batch_size

Section 14.9.9, “Configuring InnoDB Purge Scheduling”

innodb_purge_threads

Section 14.9.9, “Configuring InnoDB Purge Scheduling”
Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary

innodb_random_read_ahead

Section 14.9.2.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.9.2.1, “The InnoDB Buffer Pool”
Section 1.4, “What Is New in MySQL 5.5”

innodb_read_ahead_threshold

Section 14.9.2.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.9.2.1, “The InnoDB Buffer Pool”

innodb_read_io_threads

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.5”
Section 14.9.6, “Configuring the Number of Background InnoDB I/O Threads”
Section 14.20.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 24.1.1, “MySQL Threads”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 1.4, “What Is New in MySQL 5.5”

innodb_rollback_segments

Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 14.7.8, “Undo Log”

innodb_sort_buffer_size

MySQL Glossary

innodb_spin_wait_delay

Section 14.9.8, “Configuring Spin Lock Polling”

innodb_stats_method

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

innodb_stats_on_metadata

Section 1.4, “What Is New in MySQL 5.5”

innodb_stats_sample_pages

Section 14.9.10, “Configuring Optimizer Statistics for InnoDB”
Section 14.9.10.1, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 14.11.8, “Limits on InnoDB Tables”

innodb_strict_mode

Section 13.1.17, “CREATE TABLE Syntax”
Section 14.12.5, “How Compression Works for InnoDB Tables”
Section 14.2, “Installing the InnoDB Storage Engine”
Section C.10.4, “Limits on Table Column Count and Row Size”
MySQL Glossary
Section 5.1.7, “Server SQL Modes”
Section 14.12.6, “SQL Compression Syntax Warnings and Errors”
Section 1.4, “What Is New in MySQL 5.5”

innodb_support_xa

MySQL Glossary
Section 8.5.2, “Optimizing InnoDB Transaction Management”

innodb_table_locks

Section 14.17, “InnoDB Startup Options and System Variables”
Section 14.11.8, “Limits on InnoDB Tables”

innodb_temp_data_file_path

MySQL Glossary

innodb_thread_concurrency

Section 14.9.5, “Configuring Thread Concurrency for InnoDB”
Section 14.20.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.17, “InnoDB Startup Options and System Variables”
Section A.14, “MySQL 5.5 FAQ: MySQL Enterprise Thread Pool”
Section 8.5.8, “Optimizing InnoDB Configuration Variables”

innodb_thread_sleep_delay

Section 14.9.5, “Configuring Thread Concurrency for InnoDB”

innodb_undo_directory

MySQL Glossary

innodb_undo_tablespaces

MySQL Glossary

innodb_use_native_aio

Section 14.17, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 1.4, “What Is New in MySQL 5.5”

innodb_use_sys_malloc

Section 14.9.3, “Configuring the Memory Allocator for InnoDB”
Section 14.9.5, “Configuring Thread Concurrency for InnoDB”
Section 14.17, “InnoDB Startup Options and System Variables”

innodb_write_io_threads

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.5”
Section 14.9.6, “Configuring the Number of Background InnoDB I/O Threads”
Section 14.20.3, “InnoDB Standard Monitor and Lock Monitor Output”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 24.1.1, “MySQL Threads”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 1.4, “What Is New in MySQL 5.5”

insert_id

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

interactive_timeout

Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 23.8.7.52, “mysql_real_connect()”
Section 5.1.4, “Server System Variables”

J

[index top]

join_buffer_size

Section 8.2.1.8, “Nested-Loop Join Algorithms”
Section 5.1.4, “Server System Variables”

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 14.11.5, “Converting Tables from MyISAM to InnoDB”
Section 8.8.4, “Estimating Query Performance”
Section 8.12.5.1, “How MySQL Uses Memory”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 14.9.1, “InnoDB Startup Configuration”
Section B.5.7, “Known Issues in MySQL”
Section 8.10.2.2, “Multiple Key Caches”
Section 8.10.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.10.2, “The MyISAM Key Cache”
Section 8.12.2, “Tuning Server Parameters”

key_cache_age_threshold

Section 8.10.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.10.2.5, “Key Cache Block Size”
Section 8.10.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.10.2.3, “Midpoint Insertion Strategy”
Section 5.1.4, “Server System Variables”
Section 5.1.5.1, “Structured System Variables”

L

[index top]

language

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.5”
Section 5.1.4, “Server System Variables”

large_files_support

Section 19.5, “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.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”

lc_messages

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.5”
Section 5.1.4, “Server System Variables”
Section 10.2, “Setting the Error Message Language”
Section 1.4, “What Is New in MySQL 5.5”

lc_messages_dir

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.5”
Section 5.1.4, “Server System Variables”
Section 10.2, “Setting the Error Message Language”
Section 1.4, “What Is New in MySQL 5.5”

lc_time_names

Section 12.7, “Date and Time Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 10.7, “MySQL Server Locale Support”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”

license

Section 5.1.4, “Server System Variables”

local

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

local_infile

Section 5.1.4, “Server System Variables”

lock_wait_timeout

Section 5.1.4, “Server System Variables”

locked_in_memory

Section 5.1.4, “Server System Variables”

log

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

log_bin

Section 17.1.3.4, “Binary Log Options and Variables”
Section 18.3.3.8.2, “MySQL Cluster System Variables”

log_bin_trust_function_creators

Section 17.1.3.4, “Binary Log Options and Variables”
Section 20.7, “Binary Logging of Stored Programs”
Section A.4, “MySQL 5.5 FAQ: Stored Procedures and Functions”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

log_bin_use_v

Section 17.1.3.4, “Binary Log Options and Variables”

log_error

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

log_output

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

log_queries_not_using_indexes

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

log_slave_updates

Section 17.1.3.4, “Binary Log Options and Variables”

log_slow_queries

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

log_warnings

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

long_query_time

Section 5.4, “MySQL Server Logs”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server Command Options”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

low_priority_updates

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

lower_case_file_system

Section 5.1.4, “Server System Variables”

lower_case_table_names

Section 10.1.8.8, “Collation and INFORMATION_SCHEMA Searches”
Section 13.7.1.3, “GRANT Syntax”
Section 17.2.3, “How Servers Evaluate Replication Filtering Rules”
Section 1.6, “How to Report Bugs or Problems”
Section 9.2.2, “Identifier Case Sensitivity”
Section 22.1, “Performance Schema Quick Start”
Section 17.4.1.38, “Replication and Variables”
Section 13.7.1.5, “REVOKE Syntax”
Section 5.1.4, “Server System Variables”
Section 13.7.5.38, “SHOW TABLES Syntax”
Section 13.1.17.3, “Using FOREIGN KEY Constraints”

M

[index top]

master_verify_checksum

MySQL Glossary

max_allowed_packet

Section 12.17.1, “Aggregate (GROUP BY) Function Descriptions”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 12.3.2, “Comparison Functions and Operators”
Section B.5.4.6, “Deleting Rows from Related Tables”
Section 8.12.5.1, “How MySQL Uses Memory”
Section B.5.2.3, “Lost connection to MySQL server”
Section 23.8, “MySQL C API”
Section 18.6.11, “MySQL Cluster Replication Conflict Resolution”
Section B.5.2.9, “MySQL server has gone away”
Section 23.8.11.26, “mysql_stmt_send_long_data()”
Section 23.8.7.71, “mysql_use_result()”
Section B.5.2.10, “Packet Too Large”
Section 17.4.1.22, “Replication and max_allowed_packet”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 12.5, “String Functions”
Section 11.4.3, “The BLOB and TEXT Types”

max_binlog_cache_size

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

max_binlog_size

Section 17.1.3.4, “Binary Log Options and Variables”
Section 5.4, “MySQL Server Logs”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section 5.4.7, “Server Log Maintenance”
Section 5.1.4, “Server System Variables”
Section 5.4.4, “The Binary Log”
Section 17.2.2.1, “The Slave Relay Log”

max_binlog_stmt_cache_size

Section 17.1.3.4, “Binary Log Options and Variables”

max_connect_errors

Section 8.12.6.2, “DNS Lookup Optimization and the Host Cache”
Section 13.7.6.3, “FLUSH Syntax”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 5.1.4, “Server System Variables”

max_connections

Section 24.5.1.4, “Debugging mysqld under gdb”
Section B.5.2.18, “File Not Found and Similar Errors”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.12.6.1, “How MySQL Uses Threads for Client Connections”
Section 22.9, “Performance Schema System Variables”
Section 6.2.1, “Privileges Provided by MySQL”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 5.5.4.3, “Thread Pool Operation”
Section B.5.2.7, “Too many connections”

max_delayed_threads

Section 22.9, “Performance Schema System Variables”
Section 5.1.4, “Server System Variables”

max_error_count

Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.6.7.3, “RESIGNAL Syntax”
Section 5.1.4, “Server System Variables”
Section 13.7.5.18, “SHOW ERRORS Syntax”
Section 13.7.5.41, “SHOW WARNINGS Syntax”

max_heap_table_size

Section 8.12.5.1, “How MySQL Uses Memory”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section C.10.3, “Limits on Table Size”
Section 17.4.1.23, “Replication and MEMORY Tables”
Section 17.4.1.38, “Replication and Variables”
Section C.3, “Restrictions on Server-Side Cursors”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 15.4, “The MEMORY Storage Engine”

max_insert_delayed_threads

Section 5.1.4, “Server System Variables”

max_join_size

Section 8.8.2, “EXPLAIN Output Format”
Section 5.1.4, “Server System Variables”
Section 13.7.4.1, “SET Syntax for Variable Assignment”
Section 5.1.5, “Using System Variables”

max_length_for_sort_data

Section 8.2.1.11, “ORDER BY Optimization”
Section 5.1.4, “Server System Variables”

max_long_data_size

Section 23.8.11.26, “mysql_stmt_send_long_data()”
Section 5.1.4, “Server System Variables”

max_prepared_stmt_count

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 17.1.3.4, “Binary Log Options and Variables”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”
Section 17.2.2.1, “The Slave Relay Log”

max_seeks_for_key

Section 14.11.8, “Limits on InnoDB Tables”
Section 5.1.4, “Server System Variables”

max_sort_length

Section 13.1.17, “CREATE TABLE Syntax”
Section B.5.7, “Known Issues in MySQL”
Section 8.2.1.11, “ORDER BY Optimization”
Section 5.1.4, “Server System Variables”
Section 11.4.3, “The BLOB and TEXT Types”

max_sp_recursion_depth

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

max_tmp_tables

Section 5.1.4, “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.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.11.2, “Table Locking Issues”

metadata_locks_cache_size

Section 5.1.4, “Server System Variables”

min_examined_row_limit

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

multi_range_count

Section 5.1.4, “Server System Variables”

myisam_data_pointer_size

Section 13.1.17, “CREATE TABLE Syntax”
Section C.10.3, “Limits on Table Size”
Section 5.1.4, “Server System Variables”

myisam_max_sort_file_size

Section 15.3.1, “MyISAM Startup Options”
Section 19.5, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”
Section 8.6.3, “Speed of REPAIR TABLE Statements”

myisam_mmap_size

Section 5.1.4, “Server System Variables”

myisam_recover_options

Section 5.1.4, “Server System Variables”

myisam_repair_threads

Section 5.1.4, “Server System Variables”

myisam_sort_buffer_size

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

myisam_stats_method

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

myisam_use_mmap

Section 8.12.5.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 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_cache_check_time

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_deferred_constraints

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_distribution

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_eventbuffer_max_alloc

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_extra_logging

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_force_send

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_index_stat_cache_entries

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_index_stat_enable

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_index_stat_option

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_index_stat_update_freq

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_join_pushdown

Section 8.8.2, “EXPLAIN Output Format”
Section 18.3.3.8.2, “MySQL Cluster System Variables”
Section 18.1.4, “What is New in MySQL Cluster”

ndb_log_apply_status

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

ndb_log_bin

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_log_binlog_index

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_log_empty_epochs

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_log_orig

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_log_transaction_id

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_optimized_node_selection

Section 18.3.3.8.2, “MySQL Cluster System Variables”
Section 18.5.6.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”

ndb_report_thresh_binlog_epoch_slip

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_report_thresh_binlog_mem_usage

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_table_no_logging

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_table_temporary

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_use_copying_alter_table

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_use_exact_count

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_use_transactions

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_version

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndb_version_string

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndbinfo_database

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndbinfo_max_bytes

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndbinfo_max_rows

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndbinfo_offline

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndbinfo_show_hidden

Section 18.3.3.8.2, “MySQL Cluster System Variables”
Section 18.5.10.4, “The ndbinfo cluster_operations Table”
Section 18.5.10.5, “The ndbinfo cluster_transactions Table”
Section 18.5.10.15, “The ndbinfo server_operations Table”
Section 18.5.10.16, “The ndbinfo server_transactions Table”

ndbinfo_table_prefix

Section 18.3.3.8.2, “MySQL Cluster System Variables”

ndbinfo_version

Section 18.3.3.8.2, “MySQL Cluster System Variables”

net_buffer_length

Section 8.12.5.1, “How MySQL Uses Memory”
Section 23.8, “MySQL C API”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.1.4, “Server System Variables”

net_read_timeout

Section B.5.2.3, “Lost connection to MySQL server”
Section 5.1.4, “Server System Variables”

net_retry_count

Section 5.1.4, “Server System Variables”

net_write_timeout

Section 5.1.4, “Server System Variables”

new

Section 19.5.2, “Partitioning Limitations Relating to Storage Engines”
Section 5.1.4, “Server System Variables”

O

[index top]

old

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

old_alter_table

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

old_passwords

Section 6.3.5, “Assigning Account Passwords”
Section B.5.2.4, “Client does not support authentication protocol”
Section 13.7.1.1, “CREATE USER Syntax”
Section 12.13, “Encryption and Compression Functions”
Section 6.1.2.5, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.4, “Server System Variables”
Section 13.7.1.6, “SET PASSWORD Syntax”

one_shot

Section 5.1.4, “Server System Variables”

open_files_limit

Section B.5.2.18, “File Not Found and Similar Errors”
Section 22.9, “Performance Schema System Variables”
Section 19.5, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”

optimizer_prune_level

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

optimizer_search_depth

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

optimizer_switch

Section 8.9.2, “Controlling Switchable Optimizations”
Section 8.2.1.5, “Engine Condition Pushdown Optimization”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

P

[index top]

performance_schema

Section 22.1, “Performance Schema Quick Start”
Section 22.2.2, “Performance Schema Startup Configuration”
Section 22.9, “Performance Schema System Variables”

performance_schema_events_waits_history_long_size

Section 22.9, “Performance Schema System Variables”
Section 22.7, “Performance Schema Table Descriptions”
Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 22.7.4.3, “The events_waits_history_long Table”

performance_schema_events_waits_history_size

Section 22.9, “Performance Schema System Variables”
Section 22.7, “Performance Schema Table Descriptions”
Section 13.7.5.16, “SHOW ENGINE Syntax”
Section 22.7.4.2, “The events_waits_history Table”

performance_schema_max_cond_classes

Section 22.9, “Performance Schema System Variables”

performance_schema_max_cond_instances

Section 22.9, “Performance Schema System Variables”

performance_schema_max_file_classes

Section 22.9, “Performance Schema System Variables”

performance_schema_max_file_handles

Section 22.9, “Performance Schema System Variables”

performance_schema_max_file_instances

Section 22.9, “Performance Schema System Variables”

performance_schema_max_mutex_classes

Section 22.5, “Performance Schema Status Monitoring”
Section 22.9, “Performance Schema System Variables”

performance_schema_max_mutex_instances

Section 22.9, “Performance Schema System Variables”

performance_schema_max_rwlock_classes

Section 22.9, “Performance Schema System Variables”

performance_schema_max_rwlock_instances

Section 22.9, “Performance Schema System Variables”

performance_schema_max_table_handles

Section 22.9, “Performance Schema System Variables”

performance_schema_max_table_instances

Section 22.9, “Performance Schema System Variables”

performance_schema_max_thread_classes

Section 22.9, “Performance Schema System Variables”

performance_schema_max_thread_instances

Section 22.10, “Performance Schema Status Variables”
Section 22.9, “Performance Schema System Variables”
Section 13.7.5.16, “SHOW ENGINE Syntax”

pid_file

Section 5.1.4, “Server System Variables”

plugin_dir

Section 6.1.2.2, “Administrator Guidelines for Password Security”
Section 24.2.4.3, “Compiling and Installing Plugin Libraries”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 2.10.1, “Initializing the Data Directory”
Section 13.7.3.3, “INSTALL PLUGIN Syntax”
Section 5.5.2, “Installing and Uninstalling Plugins”
Section 6.5.2.1, “Installing MySQL Enterprise Audit”
Section 6.5.1.3.1, “Installing the PAM Authentication Plugin”
Section 6.5.1.4.1, “Installing the Windows Authentication Plugin”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.3.6, “Pluggable Authentication”
Section 15.2.1, “Pluggable Storage Engine Architecture”
Section 24.2.3, “Plugin API Components”
Section C.9, “Restrictions on Pluggable Authentication”
Section 17.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 13.7.5.26, “SHOW PLUGINS Syntax”
Section 21.13, “The INFORMATION_SCHEMA PLUGINS Table”
Section 6.5.1.3, “The PAM Authentication Plugin”
Section 6.5.1.6, “The Socket Peer-Credential Authentication Plugin”
Section 6.5.1.7, “The Test Authentication Plugin”
Section 6.5.1.4, “The Windows Native Authentication Plugin”
Section 5.5.4.2, “Thread Pool Installation”
Section 24.4.2.5, “UDF Compiling and Installing”
Section 24.4.2.6, “UDF Security Precautions”
Section 24.2.4.9.3, “Using the Authentication Plugins”
Section 24.2.4.8, “Writing Audit Plugins”
Section 24.2.4.5, “Writing Daemon Plugins”
Section 24.2.4.4, “Writing Full-Text Parser Plugins”
Section 24.2.4.6, “Writing INFORMATION_SCHEMA Plugins”
Section 24.2.4.7, “Writing Semisynchronous Replication Plugins”

port

Section B.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 5.1.4, “Server System Variables”
Section 13.7.5.31, “SHOW PROFILE Syntax”
Section 21.15, “The INFORMATION_SCHEMA PROFILING Table”

profiling_history_size

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

protocol_version

Section 5.1.4, “Server System Variables”

proxy_user

Section 6.3.7, “Proxy Users”
Section 5.1.4, “Server System Variables”

pseudo_slave_mode

Section 5.1.4, “Server System Variables”

pseudo_thread_id

Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “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.10.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”

query_cache_min_res_unit

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

query_cache_size

Section 8.10.3.3, “Query Cache Configuration”
Section 5.1.4, “Server System Variables”
Section 8.10.3, “The MySQL Query Cache”
Section 5.1.5, “Using System Variables”

query_cache_type

Section 8.10.3.3, “Query Cache Configuration”
Section 8.10.3.2, “Query Cache SELECT Options”
Section 13.2.9, “SELECT Syntax”
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.12.5.1, “How MySQL Uses Memory”
Section 5.1.4, “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, “Account Management Statements”
Section 6.3.5, “Assigning Account Passwords”
Section 17.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
Section 13.7.1.1, “CREATE USER Syntax”
Section 13.7.1.2, “DROP USER Syntax”
Section 8.14.2, “General Thread States”
Section 13.7.1.3, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.1.4, “RENAME USER Syntax”
Section 17.4.1.38, “Replication and Variables”
Section 13.7.1.5, “REVOKE Syntax”
Section 5.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 13.7.1.6, “SET PASSWORD Syntax”

read_rnd_buffer_size

Section 8.12.5.1, “How MySQL Uses Memory”
Section 8.2.1.11, “ORDER BY Optimization”
Section 5.1.4, “Server System Variables”
Section 8.12.2, “Tuning Server Parameters”

relay_log

Section 17.1.3.3, “Replication Slave Options and Variables”

relay_log_index

Section 17.1.3.3, “Replication Slave Options and Variables”

relay_log_info_file

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

relay_log_space_limit

Section 8.14.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_recovery_rank

Section 13.7.5.34, “SHOW SLAVE HOSTS Syntax”

rpl_recovery_rank

Section 17.1.3.3, “Replication Slave Options and Variables”

rpl_semi_sync_master_enabled

Section 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.3.8.2, “Semisynchronous Replication Installation and Configuration”
Section 17.3.8.3, “Semisynchronous Replication Monitoring”
Section 5.1.4, “Server System Variables”

rpl_semi_sync_master_timeout

Section 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.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 17.3.8.1, “Semisynchronous Replication Administrative Interface”
Section 17.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 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 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 5.1.4, “Server System Variables”
Section 12.5, “String Functions”

server_id

Section 12.16, “Miscellaneous Functions”
Section 18.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 18.3.3.8.2, “MySQL Cluster System Variables”
Section 18.3.3.8.1, “MySQL Server Options for MySQL Cluster”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.1.4, “Server System Variables”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”
Section 6.5.2.3, “The Audit Log File”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

server_id_bits

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

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.11.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 18.3.3.8.2, “MySQL Cluster System Variables”
Section 18.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”

slave_compressed_protocol

Section 17.1.3.3, “Replication Slave Options and Variables”

slave_exec_mode

Section 18.6.3, “Known Issues in MySQL Cluster Replication”
Section 17.4.1.23, “Replication and MEMORY Tables”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”

slave_load_tmpdir

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

slave_max_allowed_packet

Section 17.1.3.3, “Replication Slave Options and Variables”

slave_net_timeout

Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.1.4.1, “Checking Replication Status”
Section 17.4.1.21, “Replication and Master or Slave Shutdowns”
Section 8.14.6, “Replication Slave I/O Thread States”
Section 17.1.3.3, “Replication Slave Options and Variables”
Section 5.1.4, “Server System Variables”

slave_skip_errors

Section 17.1.3.3, “Replication Slave Options and Variables”

slave_sql_verify_checksum

MySQL Glossary

slave_transaction_retries

Section 17.4.1.32, “Replication Retries and Timeouts”
Section 17.1.3.3, “Replication Slave Options and Variables”

slave_type_conversions

Section 18.6.3, “Known Issues in MySQL Cluster Replication”
Section 17.1.3.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.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 5.4.5, “The Slow Query Log”

slow_query_log_file

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

socket

Section 5.1.4, “Server System Variables”

sort_buffer_size

Section 7.6.3, “How to Repair MyISAM Tables”
Section 8.2.1.11, “ORDER BY Optimization”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

sql_auto_is_null

Section 12.3.2, “Comparison Functions and Operators”
Section 13.1.17, “CREATE TABLE Syntax”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.4.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 17.1.3.4, “Binary Log Options and Variables”
Section 18.1.6.8, “Issues Exclusive to MySQL Cluster”
Section 18.6.3, “Known Issues in MySQL Cluster Replication”
Section 18.1.6.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 17.1.3.1, “Replication and Binary Logging Option and Variable Reference”
Section 5.1.4, “Server System Variables”
Section 13.4.1.3, “SET sql_log_bin Syntax”
Section 13.7.4.1, “SET Syntax for Variable Assignment”
Section 17.4.3, “Upgrading a Replication Setup”
Section 5.1.5, “Using System Variables”

sql_log_off

Section 17.1.3.4, “Binary Log Options and Variables”
MySQL Glossary
Section 17.1.3.1, “Replication and Binary Logging Option and Variable Reference”
Section 5.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.1.4, “Server System Variables”
Section 5.4.3, “The General Query Log”

sql_log_update

Section 5.1.4, “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.6.7.4.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 12.18.3, “Expression Handling”
Section 1.6, “How to Report Bugs or Problems”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section A.11, “MySQL 5.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 1.7, “MySQL Standards Compliance”
Section B.5.4.2, “Problems Using DATE Columns”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 5.4.4, “The Binary Log”
Section 21.27, “The INFORMATION_SCHEMA VIEWS Table”
Section 4.2.6, “Using Option Files”
Section 5.1.5, “Using System Variables”

sql_notes

Section 5.1.4, “Server System Variables”
Section 13.7.5.41, “SHOW WARNINGS Syntax”

sql_quote_show_create

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

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 17.1.3.3, “Replication Slave Options and Variables”
Section 13.7.5.35, “SHOW SLAVE STATUS Syntax”

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_key

Section 5.1.4, “Server System Variables”

storage_engine

Section 13.1.14, “CREATE LOGFILE GROUP Syntax”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 17.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.4, “Server System Variables”

sync_binlog

Section 17.1.3.4, “Binary Log Options and Variables”
Section 14.5, “InnoDB and the ACID Model”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 8.5.7, “Optimizing InnoDB Disk I/O”
Section 17.4.1.21, “Replication and Master or Slave Shutdowns”
Section 5.4.4, “The Binary Log”

sync_frm

Section 5.1.4, “Server System Variables”

sync_master_info

Section 17.1.3.3, “Replication Slave Options and Variables”

sync_relay_log

Section 17.1.3.3, “Replication Slave Options and Variables”

sync_relay_log_info

Section 17.4.1.21, “Replication and Master or Slave Shutdowns”
Section 17.1.3.3, “Replication Slave Options and Variables”

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 8.12.5.1, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”

table_lock_wait_timeout

Section 5.1.4, “Server System Variables”

table_open_cache

Section B.5.2.18, “File Not Found and Similar Errors”
Section 8.14.2, “General Thread States”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.12.5.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.12.2, “Tuning Server Parameters”

table_type

Section 5.1.4, “Server System Variables”

thread_cache_size

Section 24.5.1.4, “Debugging mysqld under gdb”
Section 8.12.6.1, “How MySQL Uses Threads for Client Connections”
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 5.5.4.1, “Thread Pool Components”

thread_pool_algorithm

Section 5.1.4, “Server System Variables”
Section 21.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 5.5.4.1, “Thread Pool Components”

thread_pool_high_priority_connection

Section 5.1.4, “Server System Variables”
Section 5.5.4.1, “Thread Pool Components”
Section 5.5.4.3, “Thread Pool Operation”

thread_pool_max_unused_threads

Section 5.1.4, “Server System Variables”
Section 5.5.4.1, “Thread Pool Components”

thread_pool_prio_kickup_timer

Section 5.1.4, “Server System Variables”
Section 21.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 21.30.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 5.5.4.1, “Thread Pool Components”
Section 5.5.4.3, “Thread Pool Operation”
Section 5.5.4.4, “Thread Pool Tuning”

thread_pool_size

Section 5.1.4, “Server System Variables”
Section 5.5.4.1, “Thread Pool Components”
Section 5.5.4.3, “Thread Pool Operation”
Section 5.5.4.4, “Thread Pool Tuning”

thread_pool_stall_limit

Section 5.1.4, “Server System Variables”
Section 21.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 21.30.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
Section 5.5.4.1, “Thread Pool Components”
Section 5.5.4.3, “Thread Pool Operation”
Section 5.5.4.4, “Thread Pool Tuning”

thread_stack

Section 8.12.5.1, “How MySQL Uses Memory”
Section 5.1.4, “Server System Variables”
Section 20.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 20.4.4, “Event Metadata”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 11.3.1, “The DATE, DATETIME, and TIMESTAMP Types”

timed_mutexes

Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.5”

timestamp

Section 15.9.3, “FEDERATED Storage Engine Notes and Tips”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”

tmp_table_size

Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section C.3, “Restrictions on Server-Side Cursors”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”

tmpdir

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section B.5.2.13, “Can't create/write to file”
Section 7.2, “Database Backup Methods”
Section 14.16.6, “Limitations of Fast Index Creation”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 8.2.1.11, “ORDER BY Optimization”
Section 17.1.3.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 18.3.3.8.2, “MySQL Cluster System Variables”

transaction_prealloc_size

Section 5.1.4, “Server System Variables”

tx_isolation

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

U

[index top]

unique_checks

Section 14.11.5, “Converting Tables from MyISAM to InnoDB”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.38, “Replication and Variables”
Section 5.1.4, “Server System Variables”
Section 5.4.4, “The Binary Log”

updatable_views_with_limit

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

V

[index top]

version

Section 12.14, “Information Functions”
Section 14.17, “InnoDB Startup Options and System Variables”
Section 5.1.4, “Server System Variables”
Section 6.5.2.3, “The Audit Log File”

version_comment

Section 5.1.4, “Server System Variables”
Section 13.7.5.40, “SHOW VARIABLES Syntax”

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 B.5.2.11, “Communication Errors and Aborted Connections”
Section B.5.2.9, “MySQL server has gone away”
Section 23.8.7.52, “mysql_real_connect()”
Section 5.1.4, “Server System Variables”

warning_count

Section 13.6.7.4.2, “Effect of Signals on Handlers, Cursors, and Statements”
Section 5.1.4, “Server System Variables”
Section 13.7.5.18, “SHOW ERRORS Syntax”
Section 13.7.5.41, “SHOW WARNINGS Syntax”
Section B.1, “Sources of Error Information”