MySQL 实验室 因为专注,所以专业。

  • 首页
  • 博客
  • 下载
  • 文档
  • 工具
  • 知识库
  • 培训及服务
  • MySQL 5.1 Reference Manual :: System Variable Index
    • MySQL 5.1 Reference Manual
    • Preface, Notes, Licenses
    • 1 General Information
    • 2 Installing and Upgrading MySQL
    • 3 Tutorial
    • 4 MySQL Programs
    • 5 MySQL Server Administration
    • 6 Backup and Recovery
    • 7 Optimization
    • 8 Language Structure
    • 9 Internationalization and Localization
    • 10 Data Types
    • 11 Functions and Operators
    • 12 SQL Statement Syntax
    • 13 Storage Engines
    • 14 High Availability and Scalability
    • 15 MySQL Enterprise Monitor
    • 16 Replication
    • 17 MySQL Cluster NDB 6.X/7.X
    • 18 Partitioning
    • 19 Stored Programs and Views
    • 20 INFORMATION_SCHEMA Tables
    • 21 Connectors and APIs
    • 22 Extending MySQL
    • A MySQL 5.1 Frequently Asked Questions
    • B Errors, Error Codes, and Common Problems
    • C MySQL Change History
    • D Restrictions and Limits
    • Index
    • Standard Index
    • C Function Index
    • Command Index
    • Function Index
    • INFORMATION_SCHEMA Index
    • Transaction Isolation Level Index
    • JOIN Types Index
    • Operator Index
    • Option Index
    • Privileges Index
    • SQL Modes Index
    • Status Variable Index
    • Statement/Syntax Index
    • System Variable Index

    System Variable Index

    AUTOCOMMIT=1

    Section 16.4.1.27, “Replication and Transactions”

    Rpl_recovery_rank

    Section 12.4.5.35, “SHOW SLAVE HOSTS Syntax”

    auto_increment_increment

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
    Section 16.1.3.2, “Replication Master Options and Variables”
    Section 16.4.1.31, “Replication and Variables”
    Section 3.6.9, “Using AUTO_INCREMENT”

    auto_increment_offset

    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
    Section 16.1.3.2, “Replication Master Options and Variables”
    Section 16.4.1.31, “Replication and Variables”
    Section 3.6.9, “Using AUTO_INCREMENT”

    autocommit

    Section 12.2.2, “DELETE Syntax”
    Section 13.6.8.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
    Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 5.1.4, “Server System Variables”

    autocommit = 0

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.8.8, “Deadlock Detection and Rollback”
    Section 13.6.8.6, “Locks Set by Different SQL Statements in InnoDB”

    autocommit = 1

    Section 13.6.8.9, “How to Cope with Deadlocks”
    Section 12.3.5.1, “Interaction of Table Locking and Transactions”
    Section 13.6.14, “Restrictions on InnoDB Tables”
    Section 1.8.5.3, “Transactions and Atomic Operations”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    autocommit=1

    Section 5.1.4, “Server System Variables”

    automatic_sp_privileges

    Section 12.1.5, “ALTER PROCEDURE Syntax”
    Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    Section 5.1.4, “Server System Variables”
    Section 19.2.2, “Stored Routines and MySQL Privileges”

    back_log

    Section 5.1.4, “Server System Variables”

    backup_elevation

    Section 5.1.4, “Server System Variables”

    backup_history_log

    Section 5.1.4, “Server System Variables”

    backup_history_log_file

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

    backup_progress_log

    Section 5.1.4, “Server System Variables”

    backup_progress_log_file

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

    backup_wait_timeout

    Section 5.1.4, “Server System Variables”

    backupdir

    Section 5.1.4, “Server System Variables”

    basedir

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

    bdb_cache_size

    Section 5.1.4, “Server System Variables”

    bdb_home

    Section 5.1.4, “Server System Variables”

    bdb_log_buffer_size

    Section 5.1.4, “Server System Variables”

    bdb_logdir

    Section 5.1.4, “Server System Variables”

    bdb_max_lock

    Section 5.1.4, “Server System Variables”

    bdb_shared_data

    Section 5.1.4, “Server System Variables”

    bdb_tmpdir

    Section 5.1.4, “Server System Variables”

    bdb_version

    Section 5.1.4, “Server System Variables”

    big_tables

    Section 5.1.4, “Server System Variables”

    binlog_cache_size

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System 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.27, “Replication and Transactions”

    binlog_format

    Section 12.2.5.2, “INSERT DELAYED Syntax”
    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 11.6, “Date and Time Functions”
    Description
    Section 11.11.3, “Information Functions”
    Section 5.2.4.4, “Logging Format for Changes to mysql Database Tables”
    Section 11.5.2, “Mathematical Functions”
    Section 11.11.4, “Miscellaneous Functions”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.4, “Replication FAQ”
    Section 16.4.1.27, “Replication and Transactions”
    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”

    binlog_format = STATEMENT

    Section 5.2.4.3, “Mixed Binary Logging Format”

    binlog_format=ROW

    Section 13.14, “The BLACKHOLE Storage Engine”

    bulk_insert_buffer_size

    Section 13.5.1, “MyISAM Startup Options”
    Section 5.1.4, “Server System Variables”
    Section 7.2.21, “Speed of INSERT Statements”

    character_set

    Section 5.1.4, “Server System Variables”

    character_set_client

    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 12.4.4, “SET Syntax”
    Section 12.4.5.9, “SHOW CREATE EVENT Syntax”
    Section 12.4.5.11, “SHOW CREATE PROCEDURE Syntax”
    Section 12.4.5.14, “SHOW CREATE VIEW Syntax”
    Section 12.4.5.19, “SHOW EVENTS Syntax”
    Section 12.4.5.30, “SHOW PROCEDURE STATUS Syntax”
    Section 12.4.5.40, “SHOW TRIGGERS Syntax”
    Section 21.9.5.1, “C API Prepared Statement Type Codes”
    Section 9.5, “Character Set Configuration”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”
    Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
    Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
    Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
    Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
    Section 5.2.4, “The Binary Log”

    character_set_connection

    Section 9.1.9.2, “CONVERT() and CAST()”
    Section 12.4.4, “SET Syntax”
    Section 9.1.3.5, “Character String Literal Character Set and Collation”
    Section 9.1.7.3, “Collations Must Be for the Right Character Set”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 11.6, “Date and Time Functions”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 9.7, “MySQL Server Locale Support”
    Section 16.4.1.31, “Replication and Variables”
    Section 9.1.9.1, “Result Strings”
    Section 5.1.4, “Server System Variables”
    Section 9.1.8, “String Repertoire”
    Section 8.1.1, “Strings”
    Section 11.2.2, “Type Conversion in Expression Evaluation”

    character_set_database

    Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 12.4.4, “SET Syntax”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 9.1.3.2, “Database Character Set and Collation”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”

    character_set_filesystem

    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 12.2.8, “SELECT Syntax”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 11.4, “String Functions”

    character_set_results

    Section 12.4.4, “SET Syntax”
    Section 9.1.6, “Character Set for Error Messages”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 5.1.4, “Server System Variables”
    Section 9.1.11, “UTF-8 for Metadata”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    character_set_server

    Section 9.5, “Character Set Configuration”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 9.1.3.2, “Database Character Set and Collation”
    Section 11.11.4, “Miscellaneous Functions”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.2, “Replication and Character Sets”
    Section 16.4.1.31, “Replication and Variables”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 5.1.4, “Server System Variables”

    character_set_system

    Section 9.5, “Character Set Configuration”
    Section 5.1.4, “Server System Variables”
    Section 9.1.11, “UTF-8 for Metadata”

    character_sets

    Section 5.1.4, “Server System Variables”

    character_sets_dir

    Section 9.4.3, “Adding a Simple Collation to an 8-Bit Character Set”
    Section 9.4.4, “Adding a UCA Collation to a Unicode Character Set”
    Section 5.1.4, “Server System Variables”

    collation_connection

    Section 9.1.9.2, “CONVERT() and CAST()”
    Section 12.4.4, “SET Syntax”
    Section 12.4.5.9, “SHOW CREATE EVENT Syntax”
    Section 12.4.5.11, “SHOW CREATE PROCEDURE Syntax”
    Section 12.4.5.14, “SHOW CREATE VIEW Syntax”
    Section 12.4.5.19, “SHOW EVENTS Syntax”
    Section 12.4.5.30, “SHOW PROCEDURE STATUS Syntax”
    Section 12.4.5.40, “SHOW TRIGGERS Syntax”
    Section 9.1.3.5, “Character String Literal Character Set and Collation”
    Section 9.1.7.3, “Collations Must Be for the Right Character Set”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 11.6, “Date and Time Functions”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 9.1.9.1, “Result Strings”
    Section 5.1.4, “Server System Variables”
    Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
    Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
    Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
    Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
    Section 5.2.4, “The Binary Log”
    Section 11.2.2, “Type Conversion in Expression Evaluation”

    collation_database

    Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 9.1.3.2, “Database Character Set and Collation”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”
    Section 5.2.4, “The Binary Log”

    collation_server

    Section 9.1.4, “Connection Character Sets and Collations”
    Section 9.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.31, “Replication and Variables”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 5.1.4, “Server System Variables”
    Section 5.2.4, “The Binary Log”

    completion_type

    Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
    Section 21.9.3.6, “mysql_commit()”
    Section 21.9.3.57, “mysql_rollback()”
    Section 5.1.4, “Server System Variables”

    concurrent_insert

    Section 7.3.3, “Concurrent Inserts”
    Section 7.3.1, “Internal Locking Methods”
    Section 7.2.24, “Other Optimization Tips”
    Section 5.1.4, “Server System Variables”

    connect_timeout

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

    connect_timeout = 2

    Section 4.2.3.3, “Using Option Files”

    convert_character_set

    Section 5.1.4, “Server System Variables”

    datadir

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

    date_format

    Section 5.1.4, “Server System Variables”

    datetime_format

    Section 5.1.4, “Server System Variables”

    debug

    Section 5.1.4, “Server System Variables”

    debug_sync

    Section 5.1.4, “Server System Variables”

    default_storage_engine

    Section 5.1.4, “Server System Variables”

    default_week_format

    Section 11.6, “Date and Time Functions”
    Section 5.1.4, “Server System Variables”

    delay_key_write

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

    delayed_insert_limit

    Section 12.2.5.2, “INSERT DELAYED Syntax”
    Section 5.1.4, “Server System Variables”

    delayed_insert_timeout

    Section 12.2.5.2, “INSERT DELAYED Syntax”
    Section 5.1.4, “Server System Variables”

    delayed_queue_size

    Section 12.2.5.2, “INSERT DELAYED Syntax”
    Section 5.1.4, “Server System Variables”

    div_precision_increment

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

    engine_condition_pushdown

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

    error_count

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

    event_scheduler

    Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
    Section 21.8.2, “Restrictions When Using the Embedded MySQL Server”
    Section 5.1.4, “Server System Variables”

    expire_logs_days

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

    falcon_consistent_read

    Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

    flush

    Section 5.1.4, “Server System Variables”

    flush_time

    Section 5.1.4, “Server System Variables”

    foreign_key_checks

    Section 13.6.4.4, “FOREIGN KEY Constraints”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.7, “Server SQL Modes”
    Section 5.1.4, “Server System Variables”
    Section 5.2.4, “The Binary Log”

    foreign_key_checks = 0

    Section 13.6.4.4, “FOREIGN KEY Constraints”
    Section 5.1.4, “Server System Variables”

    ft_boolean_syntax

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

    ft_max_word_len

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

    ft_min_word_len

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

    ft_min_word_len=4

    Section 11.8.2, “Boolean Full-Text Searches”

    ft_query_expansion_limit

    Section 5.1.4, “Server System Variables”

    ft_stopword_file

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

    general_log

    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 5.2.3, “The General Query Log”

    general_log_file

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

    group_concat_max_len

    Section 11.12.1, “GROUP BY (Aggregate) Functions”
    Section 5.1.4, “Server System Variables”

    have_archive

    Section 5.1.4, “Server System Variables”

    have_bdb

    Section 5.1.4, “Server System Variables”

    have_blackhole_engine

    Section 5.1.4, “Server System Variables”

    have_community_features

    Section 5.1.4, “Server System Variables”

    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 5.1.4, “Server System Variables”

    have_example_engine

    Section 5.1.4, “Server System Variables”

    have_federated_engine

    Section 5.1.4, “Server System Variables”

    have_geometry

    Section 5.1.4, “Server System Variables”

    have_innodb

    Section B.5.5.5, “Rollback Failure for Nontransactional Tables”
    Section 5.1.4, “Server System Variables”

    have_isam

    Section 5.1.4, “Server System Variables”

    have_merge_engine

    Section 5.1.4, “Server System Variables”

    have_ndbcluster

    Section 17.3.4.3, “MySQL Cluster System Variables”

    have_openssl

    Section 5.1.4, “Server System Variables”
    Section 5.5.6.2, “Using SSL Connections”

    have_partitioning

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

    have_profiling

    Section 5.1.4, “Server System Variables”

    have_query_cache

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

    have_raid

    Section 5.1.4, “Server System Variables”

    have_row_based_replication

    Section 5.1.4, “Server System Variables”

    have_rtree_keys

    Section 5.1.4, “Server System Variables”

    have_ssl

    Section 5.1.4, “Server System Variables”
    Section 5.5.6.2, “Using SSL Connections”

    have_symlink

    Section 5.1.4, “Server System Variables”

    hostname

    Section 5.1.4, “Server System Variables”

    identity

    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”

    ignore_builtin_innodb

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    init_connect

    Section 9.1.5, “Configuring the Character Set and Collation for Applications”
    Section 16.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 16.1.3.3, “Replication Slave Options and Variables”

    innodb_adaptive_flushing

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_adaptive_hash_index

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_additional_mem_pool_size

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_autoextend_increment

    Section 13.6.2, “InnoDB Configuration”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”

    innodb_autoinc_lock_mode

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.4.3.2, “Configurable InnoDB Auto-Increment Locking”

    innodb_buffer_pool_awe_mem_mb

    Section 13.6.2, “InnoDB Configuration”
    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_buffer_pool_size

    Section 13.6.12.1, “InnoDB Error Codes”
    Section 13.6.13.1, “InnoDB Performance Tuning Tips”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 7.4.6, “The InnoDB Buffer Pool”

    innodb_change_buffering

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_checksums

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_commit_concurrency

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_concurrency_tickets

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_data_file_path

    Section 13.6.2, “InnoDB Configuration”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”
    Section 13.6.2.4, “Dealing with InnoDB Initialization Problems”
    Chapter 13, Storage Engines
    The mysqld-max Extended MySQL Server
    Section 13.6.2.2, “Using Raw Devices for the Shared Tablespace”

    innodb_data_home_dir

    Section 13.6.2, “InnoDB Configuration”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.2.4, “Dealing with InnoDB Initialization Problems”

    innodb_doublewrite

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_extra_dirty_writes

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_fast_shutdown

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”
    Section 5.1.10, “The Shutdown Process”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    innodb_file_format

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_file_format_check

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_file_io_threads

    Section 13.6.13.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 22.1.1, “MySQL Threads”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    innodb_file_per_table

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.13.2.2, “InnoDB Tablespace Monitor Output”
    Section 13.6.4.5, “InnoDB and MySQL Replication”
    Section 13.6.2.3, “Creating the InnoDB Tablespace”
    Section 13.6.12.2, “Operating System Error Codes”
    Section 18.5, “Restrictions and Limitations on Partitioning”
    Section 13.6.13.4, “Troubleshooting InnoDB Data Dictionary Operations”
    Section 13.6.2.1, “Using Per-Table Tablespaces”

    innodb_file_per_table=1

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_flush_log_at_trx_commit

    Section 13.6.13.1, “InnoDB Performance Tuning Tips”
    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_flush_method

    Section 13.6.13.1, “InnoDB Performance Tuning Tips”
    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_flush_method = O_DIRECT

    Section 13.6.13.1, “InnoDB Performance Tuning Tips”

    innodb_force_recovery

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.6.2, “Forcing InnoDB Recovery”

    innodb_io_capacity

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_lock_wait_timeout

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.8.8, “Deadlock Detection and Rollback”
    Section 16.4.1.25, “Replication Retries and Timeouts”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    innodb_locks_unsafe_for_binlog

    Section 13.6.8.4, “InnoDB Record, Gap, and Next-Key Locks”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 12.3.6, “SET TRANSACTION Syntax”
    Section 13.6.8.2, “Consistent Nonlocking Reads”
    Section 13.6.8.6, “Locks Set by Different SQL Statements in InnoDB”

    innodb_log_arch_dir

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_log_archive

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_log_buffer_size

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_log_file_size

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    innodb_log_files_in_group

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    innodb_log_group_home_dir

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_max_dirty_pages_pct

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_max_merged_io

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_max_purge_lag

    Section 13.6.9, “InnoDB Multi-Versioning”
    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_mirrored_log_groups

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_old_blocks_pct

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 7.4.6, “The InnoDB Buffer Pool”

    innodb_old_blocks_time

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 7.4.6, “The InnoDB Buffer Pool”

    innodb_open_files

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_purge_batch_size

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_purge_threads

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_read_ahead_threshold

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_read_io_threads

    Section 13.6.13.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 22.1.1, “MySQL Threads”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    innodb_replication_delay

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_rollback_on_timeout

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_spin_wait_delay

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_stats_on_metadata

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_stats_sample_pages

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.14, “Restrictions on InnoDB Tables”

    innodb_strict_mode

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_support_xa

    Section 13.6.13.1, “InnoDB Performance Tuning Tips”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 13.6.8.9, “How to Cope with Deadlocks”

    innodb_sync_spin_loops

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_table_locks

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_thread_concurrency

    Section 13.6.13.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 7.5.7, “How MySQL Uses Threads for Client Connections”

    innodb_thread_concurrency_timer_based

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_thread_sleep_delay

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_use_legacy_cardinality_algorithm

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_use_native_aio

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_use_native_aio=0

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_use_sys_malloc

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_version

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    innodb_write_io_threads

    Section 13.6.13.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 22.1.1, “MySQL Threads”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    insert_id

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

    interactive_timeout

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

    join_buffer_size

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

    join_cache_level

    Section 5.1.4, “Server System Variables”

    keep_files_on_create

    Section 5.1.4, “Server System Variables”

    key_buffer_size

    Section B.5.8.2, “Additional Known Issues”
    Section 7.2.2, “Estimating Query Performance”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 7.4.5.2, “Multiple Key Caches”
    Section B.5.8.1, “Open Issues in MySQL”
    Section 7.4.5.6, “Restructuring a Key Cache”
    Section 5.1.2, “Server Command Options”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 7.2.23, “Speed of DELETE Statements”
    Section 7.2.21, “Speed of INSERT Statements”
    Section 5.1.5.1, “Structured System Variables”
    Section 7.4.5, “The MyISAM Key Cache”
    Section 7.5.3, “Tuning Server Parameters”
    Section 4.2.3.3, “Using Option Files”

    key_cache_age_threshold

    Section 7.4.5.3, “Midpoint Insertion Strategy”
    Section 5.1.4, “Server System Variables”
    Section 5.1.5.1, “Structured System Variables”

    key_cache_block_size

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

    language

    Section 5.1.4, “Server System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    large_files_support

    Section 18.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.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”

    lc_messages

    Section 5.1.4, “Server System Variables”
    Section 9.2, “Setting the Error Message Language”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    lc_messages_dir

    Section 5.1.4, “Server System Variables”
    Section 9.2, “Setting the Error Message Language”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    lc_time_names

    Section 11.6, “Date and Time Functions”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 9.7, “MySQL Server Locale Support”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”
    Section 11.4, “String Functions”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    license

    Section 22.2.4.1, “General Plugin Data Structures and Functions”
    Section 5.1.4, “Server System Variables”

    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.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    log_backup_output

    Section 5.1.4, “Server System Variables”

    log_bin

    Section 17.3.4.3, “MySQL Cluster System Variables”
    Section 5.1.4, “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 1.5, “What Is New in MySQL 5.1”
    Section 5.1.4, “Server System Variables”

    log_error

    Section 5.1.4, “Server System Variables”

    log_output

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

    log_queries_not_using_indexes

    Section 5.1.4, “Server System Variables”

    log_slave_updates

    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 5.1.4, “Server System Variables”

    log_slow_queries

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

    log_update

    Section 5.1.4, “Server System Variables”

    log_warnings

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

    long_query_time

    Description
    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.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 5.2.5, “The Slow Query Log”

    low_priority_updates

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

    lower_case_file_system

    Section 5.1.4, “Server System Variables”

    lower_case_table_names

    Section 13.6.4.4, “FOREIGN KEY Constraints”
    Section 12.4.1.3, “GRANT Syntax”
    Section 12.4.1.5, “REVOKE Syntax”
    Section 9.1.7.8, “Collation and INFORMATION_SCHEMA Searches”
    Section 1.7, “How to Report Bugs or Problems”
    Section 8.2.2, “Identifier Case Sensitivity”
    Section 5.1.4, “Server System Variables”

    max_allowed_packet

    Section 11.12.1, “GROUP BY (Aggregate) Functions”
    Section B.5.2.3, “Lost connection to MySQL server”
    Section B.5.2.9, “MySQL server has gone away”
    Section B.5.2.10, “Packet too large”
    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 21.9.3.71, “mysql_use_result()”
    Section B.5.2.11, “Communication Errors and Aborted Connections”
    Section 11.2.3, “Comparison Functions and Operators”
    Section B.5.5.6, “Deleting Rows from Related Tables”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 21.9, “MySQL C API”
    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    Section 16.4.1.17, “Replication and max_allowed_packet”
    Section 5.1.4, “Server System Variables”
    Section 11.4, “String Functions”
    Section 10.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.4, “Server System Variables”
    Section 5.2.4, “The Binary Log”
    Section 16.2.2.1, “The Slave Relay Log”

    max_connect_errors

    Section 12.4.6.3, “FLUSH Syntax”
    Section B.5.2.6, “Host 'host_name' is blocked”
    Section 5.1.4, “Server System Variables”

    max_connections

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 12.4.1.3, “GRANT Syntax”
    Section B.5.2.7, “Too many connections”
    Section 22.5.1.4, “Debugging mysqld under gdb”
    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section 7.5.7, “How MySQL Uses Threads for Client Connections”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    max_connections+1

    Section B.5.2.7, “Too many connections”

    max_delayed_threads

    Section 5.1.4, “Server System Variables”

    max_error_count

    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 12.4.5.42, “SHOW WARNINGS Syntax”
    Section 5.1.4, “Server System Variables”

    max_heap_table_size

    Section B.5.2.12, “The table is full”
    Section 7.5.10, “How MySQL Uses Internal Temporary Tables”
    Section D.2, “Restrictions on Server-Side Cursors”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 13.9, “The MEMORY (HEAP) Storage Engine”

    max_insert_delayed_threads

    Section 5.1.4, “Server System Variables”

    max_join_size

    Section 4.5.1.1, “mysql Options”
    Section 12.4.4, “SET Syntax”
    Section 7.2.1, “Optimizing Queries with EXPLAIN”
    Section 5.1.4, “Server System Variables”
    Section 5.1.5, “Using System Variables”

    max_length_for_sort_data

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

    max_prepared_stmt_count

    Section 12.6, “SQL Syntax for Prepared Statements”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”

    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.4, “Server System Variables”
    Section 16.2.2.1, “The Slave Relay Log”

    max_seeks_for_key

    Section 13.6.14, “Restrictions on InnoDB Tables”
    Section 5.1.4, “Server System Variables”

    max_sort_length

    Section 12.1.17, “CREATE TABLE Syntax”
    Section B.5.8.2, “Additional Known Issues”
    Section B.5.8.1, “Open Issues in MySQL”
    Section 5.1.4, “Server System Variables”
    Section 10.4.3, “The BLOB and TEXT Types”

    max_sp_recursion_depth

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

    max_tmp_tables

    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section 5.1.4, “Server System Variables”

    max_user_connections

    Section 12.4.1.3, “GRANT Syntax”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.1.4, “Server System Variables”
    Section 5.5.4, “Setting Account Resource Limits”

    max_write_lock_count

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

    min_examined_row_limit

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

    myisam_data_pointer_size

    Section 12.1.17, “CREATE TABLE Syntax”
    Section B.5.2.12, “The table is full”
    Section 5.1.4, “Server System Variables”

    myisam_max_extra_sort_file_size

    Section 13.5.1, “MyISAM Startup Options”
    Section 5.1.4, “Server System Variables”

    myisam_max_sort_file_size

    Section 13.5.1, “MyISAM Startup Options”
    Section 18.5, “Restrictions and Limitations on Partitioning”
    Section 5.1.4, “Server System Variables”

    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 12.1.7, “ALTER TABLE Syntax”
    Section 13.5.1, “MyISAM Startup Options”
    Section 5.1.4, “Server System Variables”

    myisam_stats_method

    Section 7.4.7, “MyISAM Index Statistics Collection”
    Section 5.1.4, “Server System Variables”

    myisam_use_mmap

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

    named_pipe

    Section 5.1.4, “Server System Variables”

    ndb_autoincrement_prefetch_sz

    Section 17.3.4.3, “MySQL Cluster System Variables”

    ndb_cache_check_time

    Section 17.3.4.3, “MySQL Cluster System Variables”

    ndb_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_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_optimized_node_selection

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.3.4.3, “MySQL Cluster System Variables”
    Section 17.5.4.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”

    ndb_wait_connected

    Section 17.3.4.3, “MySQL Cluster System Variables”

    ndb_wait_setup

    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”
    Description
    Section 7.5.8, “How MySQL Uses Memory”
    Section 21.9, “MySQL C API”
    Section 5.1.4, “Server System Variables”

    net_read_timeout

    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    Section B.5.2.3, “Lost connection to MySQL server”
    Section 5.1.4, “Server System Variables”

    net_retry_count

    Section 21.9.3.49, “mysql_options()”
    Section 5.1.4, “Server System Variables”

    net_write_timeout

    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    Section 5.1.4, “Server System Variables”

    new

    Section 5.1.4, “Server System Variables”

    old

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

    old_alter_table

    Section 5.1.4, “Server System Variables”

    old_passwords

    Section 5.1.4, “Server System Variables”

    one_shot

    Section 5.1.4, “Server System Variables”

    open_files_limit

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 18.5, “Restrictions and Limitations on Partitioning”
    Section 5.1.4, “Server System Variables”

    optimizer_prune_level

    Section 7.5.4, “Controlling Query Optimizer Performance”
    Section 5.1.4, “Server System Variables”

    optimizer_search_depth

    Section 7.5.4, “Controlling Query Optimizer Performance”
    Section 5.1.4, “Server System Variables”

    optimizer_switch

    Section 5.1.4, “Server System Variables”
    Section 7.2.18, “Using optimizer_switch to Control the Optimizer”

    optimizer_use_mrr

    Section 5.1.4, “Server System Variables”

    performance_schema_events_waits_history_long_size

    Section 12.4.5.16, “SHOW ENGINE Syntax”

    performance_schema_events_waits_history_size

    Section 12.4.5.16, “SHOW ENGINE Syntax”

    performance_schema_max_thread_instances

    Section 12.4.5.16, “SHOW ENGINE Syntax”

    pid_file

    Section 5.1.4, “Server System Variables”

    plugin_dir

    Section 12.4.3.2, “CREATE FUNCTION Syntax”
    Section 12.4.3.4, “INSTALL PLUGIN Syntax”
    Section 12.4.5.27, “SHOW PLUGINS Syntax”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 13.4.1, “Pluggable Storage Engine Architecture”
    Section 22.2.2, “Plugin API Components”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.3.1, “Source Installation Overview”
    Section 20.17, “The INFORMATION_SCHEMA PLUGINS Table”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 22.3.2.6, “User-Defined Function Security Precautions”
    Section 22.2.5, “Writing 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”

    prepared_stmt_count

    Section 5.1.4, “Server System Variables”

    profiling

    Section 12.4.5.33, “SHOW PROFILES Syntax”
    Section 5.1.4, “Server System Variables”
    Section 20.26, “The INFORMATION_SCHEMA PROFILING Table”

    profiling_history_size

    Section 12.4.5.33, “SHOW PROFILES Syntax”
    Section 5.1.4, “Server System Variables”

    protocol_version

    Section 5.1.4, “Server System Variables”

    pseudo_thread_id

    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”

    query_alloc_block_size

    Section 5.1.4, “Server System Variables”

    query_cache_limit

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

    query_cache_min_res_unit

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

    query_cache_size

    Section 7.5.5.3, “Query Cache Configuration”
    Section 5.1.4, “Server System Variables”
    Section 7.5.5, “The MySQL Query Cache”
    Section 5.1.5, “Using System Variables”

    query_cache_type

    Section 12.2.8, “SELECT Syntax”
    Section 7.5.5.2, “Query Cache SELECT Options”
    Section 7.5.5.3, “Query Cache Configuration”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”

    query_cache_type=0

    Section 7.5.5.3, “Query Cache Configuration”
    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”

    rand_seed1

    Section 5.1.4, “Server System Variables”

    rand_seed2

    Section 5.1.4, “Server System Variables”

    range_alloc_block_size

    Section 5.1.4, “Server System Variables”

    read_buffer_size

    Section 7.5.8, “How MySQL Uses Memory”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 5.1.4, “Server System Variables”
    Section 7.5.3, “Tuning Server Parameters”

    read_only

    Section 5.4.1, “Privileges Provided by MySQL”
    Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.4, “Server System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    read_rnd_buffer_size

    Section 7.2.13, “ORDER BY Optimization”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 5.1.4, “Server System Variables”
    Section 7.5.3, “Tuning Server Parameters”

    relay_log_purge

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    Section 5.1.4, “Server System Variables”

    relay_log_recovery

    Section 16.1.3.3, “Replication Slave Options and Variables”

    relay_log_space_limit

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

    restore_disables_events

    Section 5.1.4, “Server System Variables”

    restore_elevation

    Section 5.1.4, “Server System Variables”

    restore_precheck

    Section 5.1.4, “Server System Variables”

    rpl_recovery_rank

    Section 16.1.3.3, “Replication Slave Options and Variables”

    rpl_semi_sync_master_enabled

    Section 5.1.4, “Server System Variables”

    rpl_semi_sync_master_reply_log_file_pos

    Section 5.1.4, “Server System Variables”

    rpl_semi_sync_master_timeout

    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 5.1.4, “Server System Variables”

    rpl_semi_sync_slave_trace_level

    Section 5.1.4, “Server System Variables”

    safe_show_database

    Section 5.1.4, “Server System Variables”

    secure_auth

    Section 5.1.4, “Server System Variables”

    secure_backup_file_priv

    Section 5.1.4, “Server System Variables”

    secure_file_priv

    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 12.2.8, “SELECT Syntax”
    Section 5.1.4, “Server System Variables”
    Section 11.4, “String Functions”

    server_id

    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Description
    Section 11.11.4, “Miscellaneous Functions”
    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    Section 5.1.4, “Server System Variables”

    shared_memory

    Section 5.1.4, “Server System Variables”

    shared_memory_base_name

    Section 5.1.4, “Server System Variables”

    skip_external_locking

    Section 7.3.4, “External Locking”
    Section 5.1.4, “Server System Variables”

    skip_name_resolve

    Section 5.1.4, “Server System Variables”

    skip_networking

    Section 5.1.4, “Server System Variables”

    skip_show_database

    Section 5.1.4, “Server System Variables”

    slave_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.1.3.3, “Replication Slave Options and Variables”

    slave_load_tmpdir

    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.1.4, “Server System Variables”

    slave_net_timeout

    Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    Section 16.4.4, “Replication FAQ”
    Section 7.5.6.6, “Replication Slave I/O Thread States”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.4.1.16, “Replication and Master or Slave Shutdowns”
    Section 5.1.4, “Server System Variables”

    slave_skip_errors

    Section 16.1.3.3, “Replication Slave Options and Variables”

    slave_transaction_retries

    Section 16.4.1.25, “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 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
    Section 16.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.2.1, “Selecting General Query and Slow Query Log Output Destinations”
    Section 5.1.4, “Server System Variables”
    Section 5.2.5, “The Slow Query Log”

    slow_query_log_file

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

    socket

    Section 5.1.4, “Server System Variables”

    sort_buffer_size

    Section 7.2.13, “ORDER BY Optimization”
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 7.5.3, “Tuning Server Parameters”

    sql_auto_is_null

    Section 11.2.3, “Comparison Functions and Operators”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”
    Section 5.2.4, “The Binary Log”

    sql_auto_is_null = 0

    Section 11.2.3, “Comparison Functions and Operators”

    sql_big_selects

    Section 5.1.4, “Server System Variables”

    sql_buffer_result

    Section 5.1.4, “Server System Variables”

    sql_log_bin

    Section 12.5.1.3, “SET sql_log_bin Syntax”
    Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
    Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
    Section 5.1.4, “Server System Variables”
    Section 16.4.3, “Upgrading a Replication Setup”

    sql_log_off

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

    sql_log_update

    Section 5.1.4, “Server System Variables”

    sql_mode

    Section 12.1.11, “CREATE EVENT Syntax”
    Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    Section 12.1.19, “CREATE TRIGGER Syntax”
    Section 12.4.5.14, “SHOW CREATE VIEW Syntax”
    Section 12.4.5.40, “SHOW TRIGGERS Syntax”
    Section 10.3.1.1, “TIMESTAMP Properties”
    Section 1.7, “How to Report Bugs or Problems”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section B.5.5.2, “Problems Using DATE Columns”
    Section 16.4.1.7, “Replication and DIRECTORY Table Options”
    Section 16.4.1.31, “Replication and Variables”
    Section 1.8.3, “Running MySQL in ANSI Mode”
    Section 1.8.2, “Selecting SQL Modes”
    Section 5.1.7, “Server SQL Modes”
    Section 5.1.4, “Server System Variables”
    Section 20.14, “The INFORMATION_SCHEMA ROUTINES Table”
    Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
    Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
    Section 5.2.4, “The Binary Log”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 5.1.5, “Using System Variables”

    sql_notes

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

    sql_quote_show_create

    Section 12.4.5.8, “SHOW CREATE DATABASE Syntax”
    Section 12.4.5.12, “SHOW CREATE TABLE Syntax”
    Section 5.1.4, “Server System Variables”

    sql_safe_updates

    Section 5.1.4, “Server System Variables”

    sql_select_limit

    Section 5.1.4, “Server System Variables”

    sql_slave_skip_counter

    Section 12.5.2.6, “SET GLOBAL sql_slave_skip_counter Syntax”
    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 16.1.3.3, “Replication Slave Options and Variables”

    sql_warnings

    Section 5.1.4, “Server System Variables”

    ssl_ca

    Section 5.1.4, “Server System Variables”

    ssl_capath

    Section 5.1.4, “Server System Variables”

    ssl_cert

    Section 5.1.4, “Server System Variables”

    ssl_cipher

    Section 5.1.4, “Server System Variables”

    ssl_key

    Section 5.1.4, “Server System Variables”

    storage_engine

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”
    Section 13.3, “Setting the Storage Engine”
    Chapter 13, Storage Engines

    sync_binlog

    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 5.2.4, “The Binary Log”

    sync_binlog=1

    Section 16.4.1.16, “Replication and Master or Slave Shutdowns”

    sync_frm

    Section 5.1.4, “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.1.3.3, “Replication Slave Options and Variables”
    Section 16.4.1.16, “Replication and Master or Slave Shutdowns”

    sync_relay_log_info=1

    Section 16.4.1.16, “Replication and Master or Slave Shutdowns”

    system_time_zone

    Section 9.6, “MySQL Server Time Zone Support”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    sysvar_ndb_table_temporary

    Section 17.3.4.3, “MySQL Cluster System Variables”

    table_cache

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 7.5.6.2, “General Thread States”
    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section 5.1.2, “Server Command Options”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 7.5.3, “Tuning Server Parameters”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    table_definition_cache

    Section 5.1.4, “Server System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    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 7.5.6.2, “General Thread States”
    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section 5.1.2, “Server Command Options”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 7.5.3, “Tuning Server Parameters”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    table_type

    Section 1.5, “What Is New in MySQL 5.1”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.4, “Server System Variables”
    Chapter 13, Storage Engines

    thread_cache_size

    Section 22.5.1.4, “Debugging mysqld under gdb”
    Section 7.5.7, “How MySQL Uses Threads for Client Connections”
    Section 7.2.24, “Other Optimization Tips”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”

    thread_concurrency

    Section 5.1.4, “Server System Variables”

    thread_handling

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”
    Section 5.1.4, “Server System Variables”

    thread_pool_size

    Section 7.5.7, “How MySQL Uses Threads for Client Connections”
    Section 5.1.4, “Server System Variables”

    thread_stack

    Section 7.5.8, “How MySQL Uses Memory”
    Section 5.1.4, “Server System Variables”
    Section 19.2.1, “Stored Routine Syntax”

    time_format

    Section 5.1.4, “Server System Variables”

    time_zone

    Section 12.1.11, “CREATE EVENT Syntax”
    Section 12.4.5.19, “SHOW EVENTS Syntax”
    Section 10.3.1.1, “TIMESTAMP Properties”
    Section 11.6, “Date and Time Functions”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 9.6, “MySQL Server Time Zone Support”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”

    timed_mutexes

    Section 12.4.5.16, “SHOW ENGINE Syntax”
    Section 5.1.4, “Server System Variables”

    timestamp

    Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    Section 16.4.1.31, “Replication and Variables”

    timestamp = {timestamp_value | DEFAULT}

    Section 5.1.4, “Server System Variables”

    timezone

    Section 5.1.4, “Server System Variables”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    tmp_table_size

    Section B.5.2.12, “The table is full”
    Section 7.5.10, “How MySQL Uses Internal Temporary Tables”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”

    tmpdir

    Section B.5.2.13, “Can't create/write to file”
    Section 7.2.13, “ORDER BY Optimization”
    Section 6.2, “Database Backup Methods”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 5.1.4, “Server System Variables”
    Section 16.2.2.2, “The Slave Status Files”

    transaction_alloc_block_size

    Section 5.1.4, “Server System Variables”

    transaction_allow_batching

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 5.1.4, “Server System Variables”

    transaction_prealloc_size

    Section 5.1.4, “Server System Variables”

    tx_isolation

    Section 12.3.6, “SET TRANSACTION Syntax”
    Section 5.1.4, “Server System Variables”

    unique_checks

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

    updatable_views_with_limit

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

    version

    Section 5.1.4, “Server System Variables”

    version_bdb

    Section 5.1.4, “Server System Variables”

    version_comment

    Section 5.1.4, “Server System Variables”

    version_compile_machine

    Section 5.1.4, “Server System Variables”

    version_compile_os

    Section 5.1.4, “Server System Variables”

    wait_timeout

    Section B.5.2.9, “MySQL server has gone away”
    Section 21.9.3.52, “mysql_real_connect()”
    Section B.5.2.11, “Communication Errors and Aborted Connections”
    Section 5.1.4, “Server System Variables”

    warning_count

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