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

  • 首页
  • 博客
  • 下载
  • 文档
  • 工具
  • 知识库
  • 培训及服务
  • MySQL 5.1 Reference Manual :: Standard 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

    Standard Index

    SYMBOLS

    = (assignment), Section 8.4, “User-Defined Variables”, Section 8.5, “Comment Syntax”
    ! (logical NOT), Section 11.2.4, “Logical Operators”
    != (not equal), Section 11.2.3, “Comparison Functions and Operators”
    ", Section 8.2, “Schema Object Names”
    #mysql50 identifier prefix, Section 8.2, “Schema Object Names”, Section 8.2.3, “Mapping of Identifiers to File Names”
    %, Section 11.5.1, “Arithmetic Operators”
    % (modulo), Section 11.5.2, “Mathematical Functions”
    % (wildcard character), Section 8.1.1, “Strings”
    & (bitwise AND), Section 11.11.1, “Bit Functions”
    && (logical AND), Section 11.2.4, “Logical Operators”
    () (parentheses), Section 11.2.1, “Operator Precedence”
    (Control-Z) \Z, Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    * (multiplication), Section 11.5.1, “Arithmetic Operators”
    + (addition), Section 11.5.1, “Arithmetic Operators”
    - (subtraction), Section 11.5.1, “Arithmetic Operators”
    - (unary minus), Section 11.5.1, “Arithmetic Operators”
    --disable option prefix, Section 4.2.3.2, “Program Option Modifiers”
    --enable option prefix, Section 4.2.3.2, “Program Option Modifiers”
    --initial option (ndbd), Description
    --initial option (ndbmtd), Description
    --initial-start option (ndbd), Description
    --initial-start option (ndbmtd), Description
    --loose option prefix, Section 4.2.3.2, “Program Option Modifiers”
    --maximum option prefix, Section 4.2.3.2, “Program Option Modifiers”
    --ndb-log-update-as-write (mysqld option), Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    --nodaemon option (ndbd), Description
    --nodaemon option (ndbmtd), Description
    --nostart option (ndbd), Description
    --nostart option (ndbmtd), Description
    --nowait-nodes option (ndbd), Description
    --nowait-nodes option (ndbmtd), Description
    --password option, Section 5.3.2.2, “End-User Guidelines for Password Security”
    --skip option prefix, Section 4.2.3.2, “Program Option Modifiers”
    --with-raid link errors, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    -n option (ndbd), Description
    -n option (ndbmtd), Description
    -p option, Section 5.3.2.2, “End-User Guidelines for Password Security”
    .my.cnf file, Section 5.3.2.2, “End-User Guidelines for Password Security”, Section 4.2.2, “Connecting to the MySQL Server”, Section 5.4.7, “Causes of Access-Denied Errors”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 4.2.3.3, “Using Option Files”
    .mysql_history file, Section 5.3.2.2, “End-User Guidelines for Password Security”, Section 4.5.1.1, “mysql Options”
    .pid (process ID) file, Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
    / (division), Section 11.5.1, “Arithmetic Operators”
    /etc/passwd, Section 5.3.3, “Making MySQL Secure Against Attackers”, Section 12.2.8, “SELECT Syntax”
    < (less than), Section 11.2.3, “Comparison Functions and Operators”
    <<, Section 3.6.8, “Calculating Visits Per Day”
    << (left shift), Section 11.11.1, “Bit Functions”
    <= (less than or equal), Section 11.2.3, “Comparison Functions and Operators”
    <=> (equal to), Section 11.2.3, “Comparison Functions and Operators”
    <> (not equal), Section 11.2.3, “Comparison Functions and Operators”
    = (assignment), Section 8.4, “User-Defined Variables”, Section 8.5, “Comment Syntax”
    = (equal), Section 11.2.3, “Comparison Functions and Operators”
    > (greater than), Section 11.2.3, “Comparison Functions and Operators”
    >= (greater than or equal), Section 11.2.3, “Comparison Functions and Operators”
    >> (right shift), Section 11.11.1, “Bit Functions”
    [SQL] (MySQL Cluster), Section 17.3.3.3, “MySQL Cluster SQL Node and API Node Configuration Parameters”
    [api] (MySQL Cluster), Section 17.3.3.3, “MySQL Cluster SQL Node and API Node Configuration Parameters”
    [computer] (MySQL Cluster), Section 17.3.3.4, “Other MySQL Cluster Configuration Parameters”
    [mgm] (MySQL Cluster), Section 17.3.3.2, “MySQL Cluster Management Node Configuration Parameters”
    [ndb_mgmd] (MySQL Cluster), Section 17.3.3.2, “MySQL Cluster Management Node Configuration Parameters”
    [ndbd default] (MySQL Cluster), Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
    [ndbd] (MySQL Cluster), Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
    [sci] (MySQL Cluster), Section 17.3.3.4, “Other MySQL Cluster Configuration Parameters”
    [shm] (MySQL Cluster), Section 17.3.3.4, “Other MySQL Cluster Configuration Parameters”
    [tcp] (MySQL Cluster), Section 17.3.3.4, “Other MySQL Cluster Configuration Parameters”
    \" (double quote), Section 8.1.1, “Strings”
    \' (single quote), Section 8.1.1, “Strings”
    \. (mysql client command), Section 3.5, “Using mysql in Batch Mode”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
    \0 (ASCII NUL), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    \N (NULL), Section 12.2.6, “LOAD DATA INFILE Syntax”
    \Z (Control-Z) ASCII 26, Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    \\ (escape), Section 8.1.1, “Strings”
    \b (backspace), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    \n (linefeed), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    \n (newline), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    \r (carriage return), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    \t (tab), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    ^ (bitwise XOR), Section 11.11.1, “Bit Functions”
    _ (wildcard character), Section 8.1.1, “Strings”
    _rowid, Section 12.1.17, “CREATE TABLE Syntax”
    `, Section 8.2, “Schema Object Names”
    | (bitwise OR), Section 11.11.1, “Bit Functions”
    || (logical OR), Section 11.2.4, “Logical Operators”
    ~, Section 11.11.1, “Bit Functions”

    A

    ABS(), Section 11.5.2, “Mathematical Functions”
    ACID, Section 1.8.5.3, “Transactions and Atomic Operations”, Section 13.6, “The InnoDB Storage Engine”
    ACLs, Section 5.4, “The MySQL Access Privilege System”
    ACOS(), Section 11.5.2, “Mathematical Functions”
    ADDDATE(), Section 11.6, “Date and Time Functions”
    ADDTIME(), Section 11.6, “Date and Time Functions”
    AES_DECRYPT(), Section 11.11.2, “Encryption and Compression Functions”
    AES_ENCRYPT(), Section 11.11.2, “Encryption and Compression Functions”
    ALL, Section 12.2.9.4, “Subqueries with ALL”, Section 12.2.8, “SELECT Syntax”
    ALL join type
    optimizer, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    ALLOW_INVALID_DATES SQL mode, Section 5.1.7, “Server SQL Modes”
    ALTER COLUMN, Section 12.1.7, “ALTER TABLE Syntax”
    ALTER DATABASE, Section 12.1.1, “ALTER DATABASE Syntax”
    ALTER EVENT, Section 12.1.2, “ALTER EVENT Syntax”
    ALTER FUNCTION, Section 12.1.4, “ALTER FUNCTION Syntax”
    ALTER LOGFILE GROUP, Section 12.1.3, “ALTER LOGFILE GROUP Syntax”
    ALTER PROCEDURE, Section 12.1.5, “ALTER PROCEDURE Syntax”
    ALTER SCHEMA, Section 12.1.1, “ALTER DATABASE Syntax”
    ALTER SERVER, Section 12.1.6, “ALTER SERVER Syntax”
    ALTER TABLE, Section B.5.7.1, “Problems with ALTER TABLE”, Section 12.1.7, “ALTER TABLE Syntax”
    ALTER TABLESPACE, Section 12.1.8, “ALTER TABLESPACE Syntax”
    ALTER VIEW, Section 12.1.9, “ALTER VIEW Syntax”
    ANALYZE TABLE, Section 12.4.2.1, “ANALYZE TABLE Syntax”
    and partitioning, Section 18.3.3, “Maintenance of Partitions”
    AND
    bitwise, Section 11.11.1, “Bit Functions”
    logical, Section 11.2.4, “Logical Operators”
    ANSI SQL mode, Section 5.1.7, “Server SQL Modes”
    ANSI mode
    running, Section 1.8.3, “Running MySQL in ANSI Mode”
    ANSI_QUOTES SQL mode, Section 5.1.7, “Server SQL Modes”
    ANY, Section 12.2.9.3, “Subqueries with ANY, IN, or SOME”
    API node (MySQL Cluster)
    defined, Section 17.1.1, “MySQL Cluster Core Concepts”
    API nodes, Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    APIs, Chapter 21, Connectors and APIs
    Perl, Section 21.11, “MySQL Perl API”
    ARCHIVE storage engine, Chapter 13, Storage Engines, Section 13.12, “The ARCHIVE Storage Engine”
    AS, Section 12.2.8.1, “JOIN Syntax”, Section 12.2.8, “SELECT Syntax”
    AS/400, Section 2.9, “Installing MySQL on i5/OS”
    ASCII(), Section 11.4, “String Functions”
    ASIN(), Section 11.5.2, “Mathematical Functions”
    ATAN(), Section 11.5.2, “Mathematical Functions”
    ATAN2(), Section 11.5.2, “Mathematical Functions”
    AUTO_INCREMENT, Section 10.2, “Numeric Types”, Section 3.6.9, “Using AUTO_INCREMENT”
    and NULL values, Section B.5.5.3, “Problems with NULL Values”
    and replication, Section 16.4.1.1, “Replication and AUTO_INCREMENT”
    AVG(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    AVG(DISTINCT), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    ActiveState Perl, Section 2.15.2, “Installing ActiveState Perl on Windows”
    After create
    thread state, Section 7.5.6.2, “General Thread States”
    Analyzing
    thread state, Section 7.5.6.2, “General Thread States”
    Apache, Section 3.8, “Using MySQL with Apache”
    Arbitration, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    ArbitrationDelay, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    ArbitrationRank, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    ArbitrationTimeout, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    ArbitrationTimeout (DEPRECATED), Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Area(), Section 11.13.5.2.6, “MultiPolygon Functions”, Section 11.13.5.2.5, “Polygon Functions”
    AsBinary(), Section 11.13.5.1, “Geometry Format Conversion Functions”
    AsText(), Section 11.13.5.1, “Geometry Format Conversion Functions”
    AutoReconnect
    API and SQL nodes, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    abort-slave-event-count option
    mysqld, Section 16.1.3.3, “Replication Slave Options and Variables”
    aborted clients, Section B.5.2.11, “Communication Errors and Aborted Connections”
    aborted connection, Section B.5.2.11, “Communication Errors and Aborted Connections”
    access control, Section 5.4.4, “Access Control, Stage 1: Connection Verification”
    access denied errors, Section B.5.2.1, “Access denied”
    access privileges, Section 5.4, “The MySQL Access Privilege System”
    account names, Section 5.4.3, “Specifying Account Names”
    account privileges
    adding, Section 5.5.2, “Adding User Accounts”
    accounts
    anonymous user, Section 2.13.2, “Securing the Initial MySQL Accounts”
    root, Section 2.13.2, “Securing the Initial MySQL Accounts”
    add-drop-database option
    mysqldump, Description
    add-drop-table option
    mysqldump, Description
    add-locks option
    mysqldump, Description
    add-user option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    adding
    character sets, Section 9.3, “Adding a New Character Set”
    native functions, Section 22.3.3, “Adding a New Native Function”
    new account privileges, Section 5.5.2, “Adding User Accounts”
    new functions, Section 22.3, “Adding New Functions to MySQL”
    new user privileges, Section 5.5.2, “Adding User Accounts”
    new users, Section 2.3.1, “Source Installation Overview”, Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    procedures, Section 22.4, “Adding New Procedures to MySQL”
    user-defined functions, Section 22.3.2, “Adding a New User-Defined Function”
    addition (+), Section 11.5.1, “Arithmetic Operators”
    addtodest option
    mysqlhotcopy, Description
    administration
    server, Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
    administrative programs, Section 4.1, “Overview of MySQL Programs”
    age
    calculating, Section 3.3.4.5, “Date Calculations”
    alias names
    case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
    aliases
    for expressions, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
    for tables, Section 12.2.8, “SELECT Syntax”
    in GROUP BY clauses, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
    names, Section 8.2, “Schema Object Names”
    on expressions, Section 12.2.8, “SELECT Syntax”
    all-databases option
    mysqlcheck, Description
    mysqldump, Description
    all-in-1 option
    mysqlcheck, Description
    all-tablespaces option
    mysqldump, Description
    allocating local table
    thread state, Section 7.5.6.3, “Delayed-Insert Thread States”
    allow-keywords option
    mysqldump, Description
    allow-suspicious-udfs option
    mysqld, Section 5.1.2, “Server Command Options”, Section 5.3.4, “Security-Related mysqld Options”
    allowold option
    mysqlhotcopy, Description
    altering
    database, Section 12.1.1, “ALTER DATABASE Syntax”
    schema, Section 12.1.1, “ALTER DATABASE Syntax”
    analyze option
    myisamchk, Section 4.6.3.4, “Other myisamchk Options”
    mysqlcheck, Description
    angel-pid-file option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    anonymous user, Section 5.4.5, “Access Control, Stage 2: Request Verification”, Section 5.4.4, “Access Control, Stage 1: Connection Verification”, Section 2.13.2, “Securing the Initial MySQL Accounts”
    ansi option
    mysqld, Section 5.1.2, “Server Command Options”
    ansi_mode system variable, Section 5.1.4, “Server System Variables”
    apply-slave-statements option
    mysqldump, Description
    apply_status table (OBSOLETE), Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    arbitrator, Section A.10, “MySQL 5.1 FAQ: MySQL Cluster”, MySQL 4.1 FAQ: MySQL Cluster
    argument processing, Section 22.3.2.3, “UDF Argument Processing”
    arithmetic expressions, Section 11.5.1, “Arithmetic Operators”
    arithmetic functions, Section 11.11.1, “Bit Functions”
    asynchronous replication, Section 17.6, “MySQL Cluster Replication”
    attackers
    security against, Section 5.3.3, “Making MySQL Secure Against Attackers”
    attribute demotion
    replication, Section 16.4.1.6.2, “Replication of Columns Having Different Data Types”
    attribute promotion
    replication, Section 16.4.1.6.2, “Replication of Columns Having Different Data Types”
    auto-generate-sql option
    mysqlslap, Description
    auto-generate-sql-add-autoincrement option
    mysqlslap, Description
    auto-generate-sql-execute-number option
    mysqlslap, Description
    auto-generate-sql-guid-primary option
    mysqlslap, Description
    auto-generate-sql-load-type option
    mysqlslap, Description
    auto-generate-sql-secondary-indexes option
    mysqlslap, Description
    auto-generate-sql-select-columns option
    mysqlslap, Description
    auto-generate-sql-unique-query-number option
    mysqlslap, Description
    auto-generate-sql-unique-write-number option
    mysqlslap, Description
    auto-generate-sql-write-number option
    mysqlslap, Description
    auto-rehash option
    mysql, Section 4.5.1.1, “mysql Options”
    auto-repair option
    mysqlcheck, Description
    auto-vertical-output option
    mysql, Section 4.5.1.1, “mysql Options”
    auto_increment_increment system variable, Section 16.1.3.2, “Replication Master Options and Variables”
    auto_increment_offset system variable, Section 16.1.3.2, “Replication Master Options and Variables”
    autoclose option
    mysqld_safe, Description
    autocommit session variable, Section 5.1.4, “Server System Variables”
    automatic_sp_privileges system variable, Section 5.1.4, “Server System Variables”

    B

    BACKUP TABLE, Section 12.4.2.2, “BACKUP TABLE Syntax”
    BDB storage engine, Chapter 13, Storage Engines
    BDB tables, Section 1.8.5.3, “Transactions and Atomic Operations”
    BEGIN, Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
    XA transactions, Section 12.3.7.1, “XA Transaction SQL Syntax”
    BENCHMARK(), Section 11.11.3, “Information Functions”
    BETWEEN ... AND, Section 11.2.3, “Comparison Functions and Operators”
    BIGINT data type, Section 10.1.1, “Overview of Numeric Types”
    BIN(), Section 11.4, “String Functions”
    BINARY, Section 11.9, “Cast Functions and Operators”
    BINARY data type, Section 10.4.2, “The BINARY and VARBINARY Types”, Section 10.1.3, “Overview of String Types”
    BINLOG, Section 12.4.6.1, “BINLOG Syntax”
    BINLOG statement
    mysqlbinlog output, Section 4.6.7.2, “mysqlbinlog Row Event Display”
    BIT data type, Section 10.1.1, “Overview of Numeric Types”
    BIT_AND(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    BIT_COUNT, Section 3.6.8, “Calculating Visits Per Day”
    BIT_COUNT(), Section 11.11.1, “Bit Functions”
    BIT_LENGTH(), Section 11.4, “String Functions”
    BIT_OR, Section 3.6.8, “Calculating Visits Per Day”
    BIT_OR(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    BIT_XOR(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    BLACKHOLE storage engine, Chapter 13, Storage Engines, Section 13.14, “The BLACKHOLE Storage Engine”
    BLOB
    inserting binary data, Section 8.1.1, “Strings”
    size, Section 10.5, “Data Type Storage Requirements”
    BLOB columns
    default values, Section 10.4.3, “The BLOB and TEXT Types”
    indexing, Section 12.1.17, “CREATE TABLE Syntax”, Section 7.4.2, “Column Indexes”
    BLOB data type, Section 10.4.3, “The BLOB and TEXT Types”, Section 10.1.3, “Overview of String Types”
    BOOL data type, Section 10.1.1, “Overview of Numeric Types”
    BOOLEAN data type, Section 10.1.1, “Overview of Numeric Types”
    BackupDataBufferSize, Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    BackupDataBufferSize (MySQL Cluster configuration parameter), Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    BackupDataDir, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    BackupLogBufferSize, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    BackupMaxWriteSize, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    BackupMemory, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    BackupReportFrequency, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    BackupWriteSize, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    BatchByteSize, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    BatchSize, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    BatchSizePerLocalScan, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Bazaar tree, Section 2.3.3, “Installing from the Development Source Tree”
    BdMPolyFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
    BdMPolyFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
    BdPolyFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
    BdPolyFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
    BerkeleyDB storage engine, Chapter 13, Storage Engines
    Binlog Dump
    thread command, Section 7.5.6.1, “Thread Command Values”
    BitKeeper tree, Section 2.3.3, “Installing from the Development Source Tree”
    Block Nested-Loop join algorithm, Section 7.2.10, “Nested-Loop Join Algorithms”
    Boundary(), Section 11.13.5.2.1, “General Geometry Functions”
    Buffer pool
    InnoDB, Section 7.4.6, “The InnoDB Buffer Pool”
    Buffer(), Section 11.13.5.3.2, “Spatial Operators”
    back_log system variable, Section 5.1.4, “Server System Variables”
    backslash
    escape character, Section 8.1.1, “Strings”
    backspace (\b), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    backup identifiers
    native backup and restore, Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
    backup option
    myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
    myisampack, Description
    backup_elevation system variable, Section 5.1.4, “Server System Variables”
    backup_history_log system variable, Section 5.1.4, “Server System Variables”
    backup_history_log_file system variable, Section 5.1.4, “Server System Variables”
    backup_progress_log system variable, Section 5.1.4, “Server System Variables”
    backup_progress_log_file system variable, Section 5.1.4, “Server System Variables”
    backup_wait_timeout session variable, Section 5.1.4, “Server System Variables”
    backupdir system variable, Section 5.1.4, “Server System Variables”
    backups, Chapter 6, Backup and Recovery
    InnoDB, Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    database, Section 12.4.2.2, “BACKUP TABLE Syntax”
    databases and tables, Section 4.5.4, “mysqldump — A Database Backup Program”, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
    in MySQL Cluster, Section 17.5.3.1, “MySQL Cluster Backup Concepts”, Section 17.5.3, “Online Backup of MySQL Cluster”, Section 17.5.3.3, “Configuration for MySQL Cluster Backups”, Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”
    in MySQL Cluster replication, Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
    with mysqldump, Section 6.4, “Using mysqldump for Backups”
    backups, troubleshooting
    in MySQL Cluster, Section 17.5.3.4, “MySQL Cluster Backup Troubleshooting”
    base64-output option
    mysqlbinlog, Description
    basedir option
    mysql.server, Description
    mysql_install_db, Description
    mysql_upgrade, Description
    mysqld, Section 5.1.2, “Server Command Options”
    mysqld_safe, Description
    basedir system variable, Section 5.1.4, “Server System Variables”
    batch SQL files, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
    batch mode, Section 3.5, “Using mysql in Batch Mode”
    batch option
    mysql, Section 4.5.1.1, “mysql Options”
    batched updates (MySQL Cluster Replication), Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”
    bdb_cache_size system variable, Section 5.1.4, “Server System Variables”
    bdb_home system variable, Section 5.1.4, “Server System Variables”
    bdb_log_buffer_size system variable, Section 5.1.4, “Server System Variables”
    bdb_logdir system variable, Section 5.1.4, “Server System Variables”
    bdb_max_lock system variable, Section 5.1.4, “Server System Variables”
    bdb_shared_data system variable, Section 5.1.4, “Server System Variables”
    bdb_tmpdir system variable, Section 5.1.4, “Server System Variables”
    bdb_version system variable, Section 5.1.4, “Server System Variables”
    benchmark suite, Section 7.1.3, “The MySQL Benchmark Suite”
    benchmarks, Section 7.1.4, “Using Your Own Benchmarks”
    big-tables option
    mysqld, Section 5.1.2, “Server Command Options”
    big5, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    big_tables session variable, Section 5.1.4, “Server System Variables”
    binary distributions
    installing, Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    binary log, Section 5.2.4, “The Binary Log”
    event groups, Section 12.5.2.6, “SET GLOBAL sql_slave_skip_counter Syntax”
    binary logging
    and MySQL Cluster, Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
    bind-address option
    mysqld, Section 5.1.2, “Server Command Options”
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    binlog-do-db option
    mysqld, Section 16.1.3.4, “Binary Log Options and Variables”
    binlog-format option
    mysqld, Section 5.1.2, “Server Command Options”
    binlog-ignore-db option
    mysqld, Section 16.1.3.4, “Binary Log Options and Variables”
    binlog-row-event-max-size option
    mysqld, Section 16.1.3.4, “Binary Log Options and Variables”
    binlog_cache_size system variable, Section 16.1.3.4, “Binary Log Options and Variables”, Section 5.1.4, “Server System Variables”
    binlog_direct_non_transactional_updates system variable, Section 16.1.3.4, “Binary Log Options and Variables”
    binlog_format system variable, Section 16.1.3.4, “Binary Log Options and Variables”
    binlog_index table (OBSOLETE), Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    bit_functions
    example, Section 3.6.8, “Calculating Visits Per Day”
    block-search option
    myisamchk, Section 4.6.3.4, “Other myisamchk Options”
    blocks
    ndbinfo table, Section 17.5.8.1, “The ndbinfo blocks Table”
    boolean options, Section 4.2.3.2, “Program Option Modifiers”
    bootstrap option
    mysqld, Section 5.1.2, “Server Command Options”
    brackets
    square, Chapter 10, Data Types
    brief option
    mysqlaccess, Description
    buffer sizes
    client, Chapter 21, Connectors and APIs
    mysqld server, Section 7.5.3, “Tuning Server Parameters”
    bug reports
    criteria for, Section 1.7, “How to Report Bugs or Problems”
    bugs
    known, Section B.5.8, “Known Issues in MySQL”
    reporting, Section 1.7, “How to Report Bugs or Problems”
    bugs database, Section 1.7, “How to Report Bugs or Problems”
    bugs.mysql.com, Section 1.7, “How to Report Bugs or Problems”
    building
    client programs, Section 21.9.16, “Building Client Programs”
    bulk_insert_buffer_size system variable, Section 5.1.4, “Server System Variables”
    burnin option
    mysqlslap, Description

    C

    C
    \my.cnf file, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”
    C API
    data types, Section 21.9, “MySQL C API”
    functions, Section 21.9.2, “C API Function Overview”
    linking problems, Section 21.9.16.1, “Problems Linking with the C API”
    C prepared statement API
    functions, Section 21.9.5.2, “C API Prepared Statement Type Conversions”, Section 21.9.6, “C API Prepared Statement Function Overview”
    type codes, Section 21.9.5.1, “C API Prepared Statement Type Codes”
    C++ APIs, Section 21.12, “MySQL C++ API”
    C++ compiler
    gcc, Section 2.3.2, “Typical configure Options”
    C++ compiler cannot create executables, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    CACHE INDEX, Section 12.4.6.2, “CACHE INDEX Syntax”
    and partitioning, Section 18.5, “Restrictions and Limitations on Partitioning”
    CALL, Section 12.2.1, “CALL Syntax”
    CASE, Section 11.3, “Control Flow Functions”
    CAST, Section 11.9, “Cast Functions and Operators”
    CC environment variable, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    CEIL(), Section 11.5.2, “Mathematical Functions”
    CEILING(), Section 11.5.2, “Mathematical Functions”
    CFLAGS environment variable, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    CHANGE MASTER TO, Section 12.5.2.1, “CHANGE MASTER TO Syntax”
    in MySQL Cluster, Section 17.6.5, “Preparing the MySQL Cluster for Replication”
    CHAR VARYING data type, Section 10.1.3, “Overview of String Types”
    CHAR data type, Section 10.4, “String Types”, Section 10.1.3, “Overview of String Types”
    CHAR(), Section 11.4, “String Functions”
    CHARACTER VARYING data type, Section 10.1.3, “Overview of String Types”
    CHARACTER data type, Section 10.1.3, “Overview of String Types”
    CHARACTER_LENGTH(), Section 11.4, “String Functions”
    CHARACTER_SETS
    INFORMATION_SCHEMA table, Section 20.9, “The INFORMATION_SCHEMA CHARACTER_SETS Table”
    CHARSET(), Section 11.11.3, “Information Functions”
    CHAR_LENGTH(), Section 11.4, “String Functions”
    CHECK TABLE, Section 12.4.2.3, “CHECK TABLE Syntax”
    and partitioning, Section 18.3.3, “Maintenance of Partitions”
    CHECKPOINT Events (MySQL Cluster), Section 17.5.4.2, “MySQL Cluster Log Events”
    CHECKSUM TABLE, Section 12.4.2.4, “CHECKSUM TABLE Syntax”
    CJK
    FAQ, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    CJK (Chinese, Japanese, Korean)
    Access, PHP, etc., Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    CJKV, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Database and table names, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Japanese character sets, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Korean character set, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    LIKE and FULLTEXT, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    MySQL 4.0 behavior, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    ORDER BY treatment, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Unicode collations, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Vietnamese, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Yen sign, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    availability of specific characters, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    available character sets, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    big5, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    character sets available, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    characters displayed as question marks, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    collations, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    conversion problems with Japanese character sets, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    data truncation, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    documentation in Chinese, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    documentation in Japanese, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    documentation in Korean, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    gb2312, gbk, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    problems with Access, PHP, etc., Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    problems with Big5 character sets (Chinese), Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    problems with GB character sets (Chinese), Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    problems with LIKE and FULLTEXT, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    problems with Yen sign (Japanese), Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    problems with data truncation, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    problems with euckr character set (Korean), Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    rejected characters, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    sort order problems, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    sorting problems, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    testing availability of characters, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    CLUSTERLOG STATISTICS command (MySQL Cluster), Section 17.5.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
    CLUSTERLOG commands (MySQL Cluster), Section 17.5.4.1, “MySQL Cluster Logging Management Commands”
    CMake, Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    COALESCE(), Section 11.2.3, “Comparison Functions and Operators”
    COERCIBILITY(), Section 11.11.3, “Information Functions”
    COLLATION(), Section 11.11.3, “Information Functions”
    COLLATIONS
    INFORMATION_SCHEMA table, Section 20.10, “The INFORMATION_SCHEMA COLLATIONS Table”
    COLLATION_CHARACTER_SET_APPLICABILITY
    INFORMATION_SCHEMA table, Section 20.11, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”
    COLUMNS
    INFORMATION_SCHEMA table, Section 20.3, “The INFORMATION_SCHEMA COLUMNS Table”
    COLUMN_PRIVILEGES
    INFORMATION_SCHEMA table, Section 20.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
    COMMIT, Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”, Section 1.8.5.3, “Transactions and Atomic Operations”
    XA transactions, Section 12.3.7.1, “XA Transaction SQL Syntax”
    COMPRESS(), Section 11.11.2, “Encryption and Compression Functions”
    CONCAT(), Section 11.4, “String Functions”
    CONCAT_WS(), Section 11.4, “String Functions”
    CONNECTION Events (MySQL Cluster), Section 17.5.4.2, “MySQL Cluster Log Events”
    CONNECTION_ID(), Section 11.11.3, “Information Functions”
    CONSTRAINTS
    INFORMATION_SCHEMA table, Section 20.12, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”
    CONV(), Section 11.5.2, “Mathematical Functions”
    CONVERT, Section 11.9, “Cast Functions and Operators”
    CONVERT TO, Section 12.1.7, “ALTER TABLE Syntax”
    CONVERT_TZ(), Section 11.6, “Date and Time Functions”
    COS(), Section 11.5.2, “Mathematical Functions”
    COT(), Section 11.5.2, “Mathematical Functions”
    COUNT(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    COUNT(DISTINCT), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    CRC32(), Section 11.5.2, “Mathematical Functions”
    CREATE ... IF NOT EXISTS
    and replication, Section 16.4.1.3, “Replication of CREATE ... IF NOT EXISTS Statements”
    CREATE DATABASE, Section 12.1.10, “CREATE DATABASE Syntax”
    CREATE EVENT, Section 12.1.11, “CREATE EVENT Syntax”
    CREATE FUNCTION, Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”, Section 12.4.3.2, “CREATE FUNCTION Syntax”
    CREATE INDEX, Section 12.1.13, “CREATE INDEX Syntax”
    CREATE LOGFILE GROUP, Section 12.1.14, “CREATE LOGFILE GROUP Syntax”
    CREATE NODEGROUP command (MySQL Cluster), Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    CREATE PROCEDURE, Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    CREATE SCHEMA, Section 12.1.10, “CREATE DATABASE Syntax”
    CREATE SERVER, Section 12.1.16, “CREATE SERVER Syntax”
    CREATE TABLE, Section 12.1.17, “CREATE TABLE Syntax”
    DIRECTORY options
    and replication, Section 16.4.1.7, “Replication and DIRECTORY Table Options”
    CREATE TABLE ... SELECT
    and replication, Section 16.4.1.4, “Replication of CREATE TABLE ... SELECT Statements”
    CREATE TABLESPACE, Section 12.1.18, “CREATE TABLESPACE Syntax”
    CREATE TRIGGER, Section 12.1.19, “CREATE TRIGGER Syntax”
    CREATE USER, Section 12.4.1.1, “CREATE USER Syntax”
    CREATE VIEW, Section 12.1.20, “CREATE VIEW Syntax”
    CROSS JOIN, Section 12.2.8.1, “JOIN Syntax”
    CR_SERVER_GONE_ERROR, Section B.5.2.9, “MySQL server has gone away”
    CR_SERVER_LOST_ERROR, Section B.5.2.9, “MySQL server has gone away”
    CSV data, reading, Section 12.2.6, “LOAD DATA INFILE Syntax”, Section 12.2.8, “SELECT Syntax”
    CSV storage engine, Section 13.13, “The CSV Storage Engine”, Chapter 13, Storage Engines
    CURDATE(), Section 11.6, “Date and Time Functions”
    CURRENT_DATE, Section 11.6, “Date and Time Functions”
    CURRENT_TIME, Section 11.6, “Date and Time Functions”
    CURRENT_TIMESTAMP, Section 11.6, “Date and Time Functions”
    CURRENT_USER(), Section 11.11.3, “Information Functions”
    CURTIME(), Section 11.6, “Date and Time Functions”
    CXX environment variable, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    CXXFLAGS environment variable, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    Centroid(), Section 11.13.5.2.6, “MultiPolygon Functions”
    Change user
    thread command, Section 7.5.6.1, “Thread Command Values”
    ChangeLog, Appendix C, MySQL Change History
    Changing master
    thread state, Section 7.5.6.8, “Replication Slave Connection Thread States”
    Character sets, Section 9.1, “Character Set Support”
    Checking master version
    thread state, Section 7.5.6.6, “Replication Slave I/O Thread States”
    Checking table
    thread state, Section 7.5.6.2, “General Thread States”
    Checksum, Section 17.3.2.8, “MySQL Cluster TCP/IP Connections”
    Checksum (MySQL Cluster), Section 17.3.2.10, “MySQL Cluster Shared-Memory Connections”, Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”
    Chinese, Japanese, Korean character sets
    frequently asked questions, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Clearing
    thread state, Section 7.5.6.10, “Event Scheduler Thread States”
    Close stmt
    thread command, Section 7.5.6.1, “Thread Command Values”
    Clustering, Chapter 17, MySQL Cluster NDB 6.X/7.X
    Comment syntax, Section 8.5, “Comment Syntax”
    Committing events to binlog
    thread state, Section 7.5.6.9, “MySQL Cluster Thread States”
    CompressedBackup, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    CompressedLCP, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Configuring MySQL Cluster (concepts), Section 17.1.1, “MySQL Cluster Core Concepts”
    Connect
    thread command, Section 7.5.6.1, “Thread Command Values”
    Connect Out
    thread command, Section 7.5.6.1, “Thread Command Values”
    Connecting to master
    thread state, Section 7.5.6.6, “Replication Slave I/O Thread States”
    Connector/C, Chapter 21, Connectors and APIs
    Connector/C++, Chapter 21, Connectors and APIs
    Connector/JDBC, Chapter 21, Connectors and APIs
    Connector/MXJ, Chapter 21, Connectors and APIs
    Connector/NET, Chapter 21, Connectors and APIs, Section 21.2, “MySQL Connector/NET”
    reporting problems, Section 21.2.8, “Connector/NET Support”
    Connector/ODBC, Chapter 21, Connectors and APIs, Section 21.1, “MySQL Connector/ODBC”
    Connector/OpenOffice.org, Chapter 21, Connectors and APIs
    Connectors
    MySQL, Chapter 21, Connectors and APIs
    Contains(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
    ConvexHull(), Section 11.13.5.3.2, “Spatial Operators”
    Copying to group table
    thread state, Section 7.5.6.2, “General Thread States”
    Copying to tmp table
    thread state, Section 7.5.6.2, “General Thread States”
    Copying to tmp table on disk
    thread state, Section 7.5.6.2, “General Thread States”
    Create DB
    thread command, Section 7.5.6.1, “Thread Command Values”
    Creating delayed handler
    thread state, Section 7.5.6.3, “Delayed-Insert Thread States”
    Creating index
    thread state, Section 7.5.6.2, “General Thread States”
    Creating sort index
    thread state, Section 7.5.6.2, “General Thread States”
    Creating table from master dump
    thread state, Section 7.5.6.8, “Replication Slave Connection Thread States”
    Creating tmp table
    thread state, Section 7.5.6.2, “General Thread States”
    Crosses(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
    caches
    clearing, Section 12.4.6.3, “FLUSH Syntax”
    calculating
    dates, Section 3.3.4.5, “Date Calculations”
    calendar, Section 11.7, “What Calendar Is Used By MySQL?”
    calling sequences for aggregate functions
    UDF, Section 22.3.2.2, “UDF Calling Sequences for Aggregate Functions”
    calling sequences for simple functions
    UDF, Section 22.3.2.1, “UDF Calling Sequences for Simple Functions”
    can't create/write to file, Section B.5.2.13, “Can't create/write to file”
    carriage return (\r), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    case sensitivity
    in access checking, Section 5.4.2, “Privilege System Grant Tables”
    in identifiers, Section 8.2.2, “Identifier Case Sensitivity”
    in names, Section 8.2.2, “Identifier Case Sensitivity”
    in searches, Section B.5.5.1, “Case Sensitivity in String Searches”
    in string comparisons, Section 11.4.1, “String Comparison Functions”
    case-sensitivity
    of database names, Section 1.8.4, “MySQL Extensions to Standard SQL”
    of table names, Section 1.8.4, “MySQL Extensions to Standard SQL”
    cast functions, Section 11.9, “Cast Functions and Operators”
    cast operators, Section 11.9, “Cast Functions and Operators”
    casts, Section 11.9, “Cast Functions and Operators”, Section 11.2.3, “Comparison Functions and Operators”, Section 11.2.2, “Type Conversion in Expression Evaluation”
    cc1plus problems, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    cflags option
    mysql_config, Description
    changes
    Cluster, Changes in MySQL Cluster
    InnoDB, Changes in InnoDB
    MySQL 3.23, Changes in Release 3.23.x (Lifecycle Support Ended)
    MySQL 4.0, Changes in Release 4.0.x (Lifecycle Support Ended)
    MySQL 5.1, Section C.1, “Changes in Release 5.1.x (Production)”
    MySQL Cluster, Section 17.7, “Changes in MySQL Cluster NDB 6.X and 7.X”, Section 17.7.6, “Release Series Changelogs: MySQL Cluster NDB 6.X and 7.X”
    MySQL Community Server, Appendix C, MySQL Change History
    MySQL Enterprise, Appendix C, MySQL Change History
    log, Appendix C, MySQL Change History
    changes to privileges, Section 5.4.6, “When Privilege Changes Take Effect”
    changing
    column, Section 12.1.7, “ALTER TABLE Syntax”
    field, Section 12.1.7, “ALTER TABLE Syntax”
    table, Section B.5.7.1, “Problems with ALTER TABLE”, Section 12.1.7, “ALTER TABLE Syntax”
    changing socket location, Section 2.13.1.2, “Starting and Stopping MySQL Automatically”, Section 2.3.2, “Typical configure Options”, Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
    character set repertoire, Section 9.1.8, “String Repertoire”, Section 9.1.10.2, “The utf8 Character Set (Three-Byte UTF-8 Unicode Encoding)”
    character sets, Section 2.3.2, “Typical configure Options”
    adding, Section 9.3, “Adding a New Character Set”
    and MySQL Cluster (replication), Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    and replication, Section 16.4.1.2, “Replication and Character Sets”
    character-set-client-handshake option
    mysqld, Section 5.1.2, “Server Command Options”
    character-set-filesystem option
    mysqld, Section 5.1.2, “Server Command Options”
    character-set-server option
    mysqld, Section 5.1.2, “Server Command Options”
    character-sets-dir option
    myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
    myisampack, Description
    mysql, Section 4.5.1.1, “mysql Options”
    mysqladmin, Description
    mysqlbinlog, Description
    mysqlcheck, Description
    mysqld, Section 5.1.2, “Server Command Options”
    mysqldump, Description
    mysqlimport, Description
    mysqlshow, Description
    character_set system variable, Section 5.1.4, “Server System Variables”
    character_set_client system variable, Section 5.1.4, “Server System Variables”
    character_set_connection system variable, Section 5.1.4, “Server System Variables”
    character_set_database system variable, Section 5.1.4, “Server System Variables”
    character_set_filesystem system variable, Section 5.1.4, “Server System Variables”
    character_set_results system variable, Section 5.1.4, “Server System Variables”
    character_set_server system variable, Section 5.1.4, “Server System Variables”
    character_set_system system variable, Section 5.1.4, “Server System Variables”
    character_sets system variable, Section 5.1.4, “Server System Variables”
    character_sets_dir system variable, Section 5.1.4, “Server System Variables”
    characters
    multi-byte, Section 9.3.3, “Multi-Byte Character Support”
    charset command
    mysql, Section 4.5.1.2, “mysql Commands”
    charset option
    comp_err, Description
    charset_name command
    mysql, Section 4.5.1.2, “mysql Commands”
    check option
    myisamchk, Section 4.6.3.2, “myisamchk Check Options”
    mysqlcheck, Description
    check options
    myisamchk, Section 4.6.3.2, “myisamchk Check Options”
    check-only-changed option
    myisamchk, Section 4.6.3.2, “myisamchk Check Options”
    mysqlcheck, Description
    check-password-file option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    check-upgrade option
    mysqlcheck, Description
    checking
    tables for errors, Section 6.6.2, “How to Check MyISAM Tables for Errors”
    checking permissions
    thread state, Section 7.5.6.2, “General Thread States”
    checking privileges on cached query
    thread state, Section 7.5.6.4, “Query Cache Thread States”
    checking query cache for query
    thread state, Section 7.5.6.4, “Query Cache Thread States”
    checkpoint option
    mysqlhotcopy, Description
    checksum errors, Section 2.8, “Installing MySQL on Solaris”
    choosing
    a MySQL version, Section 2.1.2, “Choosing Which MySQL Distribution to Install”
    choosing types, Section 10.6, “Choosing the Right Type for a Column”
    chroot option
    mysqld, Section 5.1.2, “Server Command Options”
    mysqlhotcopy, Description
    circular replication
    in MySQL Cluster, Section 17.6.3, “Known Issues in MySQL Cluster Replication”, Section 17.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”, Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    clean-password-file option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    cleaning up
    thread state, Section 7.5.6.2, “General Thread States”
    clear command
    mysql, Section 4.5.1.2, “mysql Commands”
    clearing
    caches, Section 12.4.6.3, “FLUSH Syntax”
    client connection threads, Section 7.5.7, “How MySQL Uses Threads for Client Connections”
    client programs, Section 4.1, “Overview of MySQL Programs”
    building, Section 21.9.16, “Building Client Programs”
    client tools, Chapter 21, Connectors and APIs
    clients
    debugging, Section 22.5.2, “Debugging a MySQL Client”
    threaded, Section 21.9.16.2, “How to Make a Threaded Client”
    closing
    tables, Section 7.4.8, “How MySQL Opens and Closes Tables”
    closing tables
    thread state, Section 7.5.6.2, “General Thread States”
    cluster database (OBSOLETE), Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    cluster logs, Section 17.5.4.1, “MySQL Cluster Logging Management Commands”, Section 17.5.4, “Event Reports Generated in MySQL Cluster”
    cluster.binlog_index table (OBSOLETE), Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    cluster_replication database (OBSOLETE), Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    clustered index
    InnoDB, Section 13.6.10.1, “Clustered and Secondary Indexes”
    collating
    strings, Section 9.3.2, “String Collating Support”
    collation
    INFORMATION_SCHEMA, Section 9.1.7.8, “Collation and INFORMATION_SCHEMA Searches”
    adding, Section 9.4, “How to Add a New Collation to a Character Set”
    collation-server option
    mysqld, Section 5.1.2, “Server Command Options”
    collation_connection system variable, Section 5.1.4, “Server System Variables”
    collation_database system variable, Section 5.1.4, “Server System Variables”
    collation_server system variable, Section 5.1.4, “Server System Variables”
    column
    changing, Section 12.1.7, “ALTER TABLE Syntax”
    types, Chapter 10, Data Types
    column alias
    problems, Section B.5.5.4, “Problems with Column Aliases”
    quoting, Section 8.2, “Schema Object Names”, Section B.5.5.4, “Problems with Column Aliases”
    column comments, Section 12.1.17, “CREATE TABLE Syntax”
    column format, Section 12.1.17, “CREATE TABLE Syntax”
    column names
    case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
    column storage, Section 12.1.17, “CREATE TABLE Syntax”
    column-names option
    mysql, Section 4.5.1.1, “mysql Options”
    column-type-info option
    mysql, Section 4.5.1.1, “mysql Options”
    columns
    displaying, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
    indexes, Section 7.4.2, “Column Indexes”
    names, Section 8.2, “Schema Object Names”
    other types, Section 10.7, “Using Data Types from Other Database Engines”
    selecting, Section 3.3.4.3, “Selecting Particular Columns”
    storage requirements, Section 10.5, “Data Type Storage Requirements”
    columns option
    mysqlimport, Description
    comma-separated values data, reading, Section 12.2.6, “LOAD DATA INFILE Syntax”, Section 12.2.8, “SELECT Syntax”
    command options
    mysql, Section 4.5.1.1, “mysql Options”
    mysqladmin, Description
    mysqld, Section 5.1.2, “Server Command Options”
    command options (MySQL Cluster)
    mysqld, Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    ndbd, Description
    command syntax, Section 1.2, “Typographical and Syntax Conventions”
    command-line history
    mysql, Section 4.5.1.1, “mysql Options”
    command-line tool, Section 4.5.1, “mysql — The MySQL Command-Line Tool”
    commands
    for binary distribution, Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    commands out of sync, Section B.5.2.14, “Commands out of sync”
    comments
    adding, Section 8.5, “Comment Syntax”
    starting, Section 1.8.5.5, “'--' as the Start of a Comment”
    comments option
    mysql, Section 4.5.1.1, “mysql Options”
    mysqldump, Description
    commit option
    mysqlaccess, Description
    mysqlslap, Description
    comp_err, Section 4.4.1, “comp_err — Compile MySQL Error Message File”, Section 4.1, “Overview of MySQL Programs”
    charset option, Description
    debug option, Description
    debug-info option, Description
    header_file option, Description
    help option, Description
    in_file option, Description
    name_file option, Description
    out_dir option, Description
    out_file option, Description
    statefile option, Description
    version option, Description
    compact option
    mysqldump, Description
    comparison operators, Section 11.2.3, “Comparison Functions and Operators”
    compatibility
    between MySQL versions, Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    with ODBC, Section 12.1.17, “CREATE TABLE Syntax”, Section 8.2.1, “Identifier Qualifiers”, Section 5.1.4, “Server System Variables”, Section 10.1.1, “Overview of Numeric Types”, Section 11.2.3, “Comparison Functions and Operators”, Section 11.2.2, “Type Conversion in Expression Evaluation”, Section 12.2.8.1, “JOIN Syntax”
    with Oracle, Section 11.12.1, “GROUP BY (Aggregate) Functions”, Section 12.8.1, “DESCRIBE Syntax”, Section 1.8.4, “MySQL Extensions to Standard SQL”
    with PostgreSQL, Section 1.8.4, “MySQL Extensions to Standard SQL”
    with Sybase, Section 12.8.4, “USE Syntax”
    with mSQL, Section 11.4.2, “Regular Expressions”
    with standard SQL, Section 1.8, “MySQL Standards Compliance”
    compatible option
    mysqldump, Description
    compiler
    C++ gcc, Section 2.3.2, “Typical configure Options”
    compiling
    on Windows, Section 2.5.11, “Compiling MySQL Clients on Windows”
    optimizing, Section 7.5.2, “System Factors and Startup Parameter Tuning”
    problems, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    speed, Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    statically, Section 2.3.2, “Typical configure Options”
    user-defined functions, Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    complete-insert option
    mysqldump, Description
    completion_type system variable, Section 5.1.4, “Server System Variables”
    compliance
    Y2K, Section 10.3.4, “Year 2000 Issues and Date Types”
    composite partitioning, Section 18.2.5, “Subpartitioning”
    compress option
    mysql, Section 4.5.1.1, “mysql Options”
    mysqladmin, Description
    mysqlcheck, Description
    mysqldump, Description
    mysqlimport, Description
    mysqlshow, Description
    mysqlslap, Description
    compressed tables, Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”, Section 13.5.3.3, “Compressed Table Characteristics”
    concatenation
    string, Section 8.1.1, “Strings”, Section 11.4, “String Functions”
    concurrency option
    mysqlslap, Description
    concurrent inserts, Section 7.3.1, “Internal Locking Methods”, Section 7.3.3, “Concurrent Inserts”
    concurrent_insert system variable, Section 5.1.4, “Server System Variables”
    config-file option
    my_print_defaults, Description
    mysqld_multi, Description
    config.cache, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    config.cache file, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    config.ini (MySQL Cluster), Section 17.2.2, “MySQL Cluster Multi-Computer Configuration”, Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”, Section 17.3.2, “MySQL Cluster Configuration Files”
    config_params
    ndbinfo table, Section 17.5.8.2, “The ndbinfo config_params Table”
    configuration
    MySQL Cluster, Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
    configuration files, Section 5.4.7, “Causes of Access-Denied Errors”
    configuration options, Section 2.3.2, “Typical configure Options”
    configure
    disable-grant-options option, Section 2.3.2, “Typical configure Options”
    enable-community-features option, Section 2.3.2, “Typical configure Options”
    enable-debug-sync option, Section 2.3.2, “Typical configure Options”
    enable-dtrace option, Section 2.3.2, “Typical configure Options”
    enable-profiling option, Section 2.3.2, “Typical configure Options”
    enable-thread-safe-client option, Section 2.3.2, “Typical configure Options”
    localstatedir option, Section 2.3.2, “Typical configure Options”
    prefix option, Section 2.3.2, “Typical configure Options”
    running after prior invocation, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    with-big-tables option, Section 2.3.2, “Typical configure Options”
    with-charset option, Section 2.3.2, “Typical configure Options”
    with-client-ldflags option, Section 2.3.2, “Typical configure Options”
    with-collation option, Section 2.3.2, “Typical configure Options”
    with-debug option, Section 2.3.2, “Typical configure Options”
    with-embedded-server option, Section 2.3.2, “Typical configure Options”
    with-extra-charsets option, Section 2.3.2, “Typical configure Options”
    with-libevent option, Section 2.3.2, “Typical configure Options”
    with-tcp-port option, Section 2.3.2, “Typical configure Options”
    with-unix-socket-path option, Section 2.3.2, “Typical configure Options”
    with-zlib-dir option, Section 2.3.2, “Typical configure Options”
    without-server option, Section 2.3.2, “Typical configure Options”
    configure option
    --with-low-memory, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    configure script, Section 2.3.2, “Typical configure Options”
    configuring MySQL Cluster, Section 17.2, “MySQL Cluster Multi-Computer How-To”, Section 17.4.1, “MySQL Server Usage for MySQL Cluster”, Section 17.3, “MySQL Cluster Configuration”
    configuring backups
    in MySQL Cluster, Section 17.5.3.3, “Configuration for MySQL Cluster Backups”
    conflict resolution
    and ndb_replication system table, Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    enabling, Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    in MySQL Cluster Replication, Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    mysqld startup options, Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    connect command
    mysql, Section 4.5.1.2, “mysql Commands”
    connect_timeout system variable, Section 5.1.4, “Server System Variables”
    connect_timeout variable, Description, Section 4.5.1.1, “mysql Options”
    connecting
    remotely with SSH, Section 5.5.7, “Connecting to MySQL Remotely from Windows with SSH”
    to the server, Section 3.1, “Connecting to and Disconnecting from the Server”, Section 4.2.2, “Connecting to the MySQL Server”
    verification, Section 5.4.4, “Access Control, Stage 1: Connection Verification”
    connection
    aborted, Section B.5.2.11, “Communication Errors and Aborted Connections”
    connectstring, Section 17.3.2.3, “The MySQL Cluster Connectstring”
    console option
    mysqld, Section 5.1.2, “Server Command Options”
    const table
    optimizer, Section 7.2.1, “Optimizing Queries with EXPLAIN”, Section 12.2.8, “SELECT Syntax”
    constant table, Section 7.2.4, “WHERE Clause Optimization”
    constraints, Section 1.8.6, “How MySQL Deals with Constraints”
    control flow functions, Section 11.3, “Control Flow Functions”
    conventions
    syntax, Section 1.2, “Typographical and Syntax Conventions”
    typographical, Section 1.2, “Typographical and Syntax Conventions”
    convert_character_set system variable, Section 5.1.4, “Server System Variables”
    converting HEAP to MyISAM
    thread state, Section 7.5.6.2, “General Thread States”
    copy option
    mysqlaccess, Description
    copy to tmp table
    thread state, Section 7.5.6.2, “General Thread States”
    copying databases, Section 2.4.5, “Copying MySQL Databases to Another Machine”
    copying tables, Section 12.1.17, “CREATE TABLE Syntax”
    core-file option
    mysqld, Section 5.1.2, “Server Command Options”
    core-file-size option
    mysqld_safe, Description
    correct-checksum option
    myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
    correlated subqueries, Section 12.2.9.7, “Correlated Subqueries”
    count option
    myisam_ftdump, Description
    mysqladmin, Description
    mysqlshow, Description
    counters
    ndbinfo table, Section 17.5.8.3, “The ndbinfo counters Table”
    counting
    table rows, Section 3.3.4.8, “Counting Rows”
    crash, Section 22.5.1, “Debugging a MySQL Server”
    recovery, Section 6.6.1, “Using myisamchk for Crash Recovery”
    repeated, Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
    replication, Section 16.4.1.16, “Replication and Master or Slave Shutdowns”
    crash-me, Section 7.1.3, “The MySQL Benchmark Suite”
    crash-me program, Section 7.1.3, “The MySQL Benchmark Suite”, Section 7.1.2, “Designing Applications for Portability”
    create option
    mysqlslap, Description
    create-options option
    mysqldump, Description
    create-schema option
    mysqlslap, Description
    creating
    bug reports, Section 1.7, “How to Report Bugs or Problems”
    database, Section 12.1.10, “CREATE DATABASE Syntax”
    databases, Section 3.3, “Creating and Using a Database”
    default startup options, Section 4.2.3.3, “Using Option Files”
    function, Section 12.4.3.2, “CREATE FUNCTION Syntax”
    schema, Section 12.1.10, “CREATE DATABASE Syntax”
    tables, Section 3.3.2, “Creating a Table”
    creating table
    thread state, Section 7.5.6.2, “General Thread States”
    creating user accounts, Section 12.4.1.1, “CREATE USER Syntax”
    csv option
    mysqlslap, Description

    D

    DATA DIRECTORY
    and replication, Section 16.4.1.7, “Replication and DIRECTORY Table Options”
    DATABASE(), Section 11.11.3, “Information Functions”
    DATE, Section B.5.5.2, “Problems Using DATE Columns”
    DATE columns
    problems, Section B.5.5.2, “Problems Using DATE Columns”
    DATE data type, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
    DATE(), Section 11.6, “Date and Time Functions”
    DATEDIFF(), Section 11.6, “Date and Time Functions”
    DATETIME data type, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
    DATE_ADD(), Section 11.6, “Date and Time Functions”
    DATE_FORMAT(), Section 11.6, “Date and Time Functions”
    DATE_SUB(), Section 11.6, “Date and Time Functions”
    DAY(), Section 11.6, “Date and Time Functions”
    DAYNAME(), Section 11.6, “Date and Time Functions”
    DAYOFMONTH(), Section 11.6, “Date and Time Functions”
    DAYOFWEEK(), Section 11.6, “Date and Time Functions”
    DAYOFYEAR(), Section 11.6, “Date and Time Functions”
    DB2 SQL mode, Section 5.1.7, “Server SQL Modes”
    DBI interface, Section 21.11, “MySQL Perl API”
    DBI->quote, Section 8.1.1, “Strings”
    DBI->trace, Section 22.5.1.4, “Debugging mysqld under gdb”
    DBI/DBD interface, Section 21.11, “MySQL Perl API”
    DBI_TRACE environment variable, Section 22.5.1.4, “Debugging mysqld under gdb”, Section 2.14, “Environment Variables”
    DBI_USER environment variable, Section 2.14, “Environment Variables”
    DBUG package, Section 22.5.3, “The DBUG Package”
    DEALLOCATE PREPARE, Section 12.6, “SQL Syntax for Prepared Statements”, Section 12.6.3, “DEALLOCATE PREPARE Syntax”
    DEC data type, Section 10.1.1, “Overview of Numeric Types”
    DECIMAL data type, Section 10.1.1, “Overview of Numeric Types”
    DECODE(), Section 11.11.2, “Encryption and Compression Functions”
    DEFAULT
    constraint, Section 1.8.6.2, “Constraints on Invalid Data”
    DEFAULT value clause, Section 12.1.17, “CREATE TABLE Syntax”, Section 10.1.4, “Data Type Default Values”
    DEFAULT(), Section 11.11.4, “Miscellaneous Functions”
    DEGREES(), Section 11.5.2, “Mathematical Functions”
    DELAYED, Section 12.2.5.2, “INSERT DELAYED Syntax”
    when ignored, Section 12.2.5, “INSERT Syntax”
    DELETE, Section 12.2.2, “DELETE Syntax”
    and MySQL Cluster, Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
    DESC, Section 12.8.1, “DESCRIBE Syntax”
    DESCRIBE, Section 3.4, “Getting Information About Databases and Tables”, Section 12.8.1, “DESCRIBE Syntax”
    DES_DECRYPT(), Section 11.11.2, “Encryption and Compression Functions”
    DES_ENCRYPT(), Section 11.11.2, “Encryption and Compression Functions”
    DISCARD TABLESPACE, Section 12.1.7, “ALTER TABLE Syntax”, Section 13.6.2.1, “Using Per-Table Tablespaces”
    DISTINCT, Section 7.2.15, “DISTINCT Optimization”, Section 3.3.4.3, “Selecting Particular Columns”, Section 12.2.8, “SELECT Syntax”
    AVG(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    COUNT(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    MAX(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    MIN(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    SUM(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    DISTINCTROW, Section 12.2.8, “SELECT Syntax”
    DIV, Section 11.5.1, “Arithmetic Operators”
    DNS, Section 7.5.11, “How MySQL Uses DNS”
    DO, Section 12.2.3, “DO Syntax”
    DOUBLE PRECISION data type, Section 10.1.1, “Overview of Numeric Types”
    DOUBLE data type, Section 10.1.1, “Overview of Numeric Types”
    DRBD license, Section A.14.1, “Distributed Replicated Block Device (DRBD)”
    DROP ... IF EXISTS
    and replication, Section 16.4.1.5, “Replication of DROP ... IF EXISTS Statements”
    DROP DATABASE, Section 12.1.21, “DROP DATABASE Syntax”
    DROP EVENT, Section 12.1.22, “DROP EVENT Syntax”
    DROP FOREIGN KEY, Section 13.6.4.4, “FOREIGN KEY Constraints”, Section 12.1.7, “ALTER TABLE Syntax”
    DROP FUNCTION, Section 12.1.26, “DROP PROCEDURE and DROP FUNCTION Syntax”, Section 12.4.3.3, “DROP FUNCTION Syntax”
    DROP INDEX, Section 12.1.7, “ALTER TABLE Syntax”, Section 12.1.24, “DROP INDEX Syntax”
    DROP LOGFILE GROUP, Section 12.1.25, “DROP LOGFILE GROUP Syntax”
    DROP NODEGROUP command (MySQL Cluster), Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    DROP PREPARE, Section 12.6.3, “DEALLOCATE PREPARE Syntax”
    DROP PRIMARY KEY, Section 12.1.7, “ALTER TABLE Syntax”
    DROP PROCEDURE, Section 12.1.26, “DROP PROCEDURE and DROP FUNCTION Syntax”
    DROP SCHEMA, Section 12.1.21, “DROP DATABASE Syntax”
    DROP SERVER, Section 12.1.27, “DROP SERVER Syntax”
    DROP TABLE, Section 12.1.28, “DROP TABLE Syntax”
    and MySQL Cluster, Section 17.1.5.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
    DROP TABLESPACE, Section 12.1.29, “DROP TABLESPACE Syntax”
    DROP TRIGGER, Section 12.1.30, “DROP TRIGGER Syntax”
    DROP USER, Section 12.4.1.2, “DROP USER Syntax”
    DROP VIEW, Section 12.1.31, “DROP VIEW Syntax”
    DUAL, Section 12.2.8, “SELECT Syntax”
    DUMPFILE, Section 12.2.8, “SELECT Syntax”
    Daemon
    thread command, Section 7.5.6.1, “Thread Command Values”
    Data truncation with CJK characters, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    DataDir, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    DataMemory, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Database information
    obtaining, Section 12.4.5, “SHOW Syntax”
    Date and Time types, Section 10.3, “Date and Time Types”
    Debug
    thread command, Section 7.5.6.1, “Thread Command Values”
    Delayed insert
    thread command, Section 7.5.6.1, “Thread Command Values”
    Difference(), Section 11.13.5.3.2, “Spatial Operators”
    Dimension(), Section 11.13.5.2.1, “General Geometry Functions”
    Disjoint(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
    Disk Data tables (MySQL Cluster), Section 17.5.10, “MySQL Cluster Disk Data Tables”
    DiskCheckpointSpeed, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    DiskCheckpointSpeedInRestart, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    DiskIOThreadPool, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    DiskPageBufferMemory, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    DiskSyncSize, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Diskless, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Distance(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
    DocBook XML
    documentation source format, Section 1.1, “About This Manual”
    Documentation
    in Chinese, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    in Japanese, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    in Korean, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Drop DB
    thread command, Section 7.5.6.1, “Thread Command Values”
    data
    importing, Section 4.5.5, “mysqlimport — A Data Import Program”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
    loading into tables, Section 3.3.3, “Loading Data into a Table”
    retrieving, Section 3.3.4, “Retrieving Information from a Table”
    size, Section 7.4.1, “Make Your Data as Small as Possible”
    data node (MySQL Cluster)
    defined, Section 17.1.1, “MySQL Cluster Core Concepts”
    data nodes (MySQL Cluster), Section 17.4.2, “ndbd — The MySQL Cluster Data Node Daemon”
    data type
    BIGINT, Section 10.1.1, “Overview of Numeric Types”
    BINARY, Section 10.4.2, “The BINARY and VARBINARY Types”, Section 10.1.3, “Overview of String Types”
    BIT, Section 10.1.1, “Overview of Numeric Types”
    BLOB, Section 10.4.3, “The BLOB and TEXT Types”, Section 10.1.3, “Overview of String Types”
    BOOL, Section 10.1.1, “Overview of Numeric Types”, Section 10.7, “Using Data Types from Other Database Engines”
    BOOLEAN, Section 10.1.1, “Overview of Numeric Types”, Section 10.7, “Using Data Types from Other Database Engines”
    CHAR, Section 10.4, “String Types”, Section 10.1.3, “Overview of String Types”
    CHAR VARYING, Section 10.1.3, “Overview of String Types”
    CHARACTER, Section 10.1.3, “Overview of String Types”
    CHARACTER VARYING, Section 10.1.3, “Overview of String Types”
    DATE, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
    DATETIME, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
    DEC, Section 10.1.1, “Overview of Numeric Types”
    DECIMAL, Section 10.1.1, “Overview of Numeric Types”
    DOUBLE, Section 10.1.1, “Overview of Numeric Types”
    DOUBLE PRECISION, Section 10.1.1, “Overview of Numeric Types”
    ENUM, Section 10.4.4, “The ENUM Type”, Section 10.1.3, “Overview of String Types”
    FIXED, Section 10.1.1, “Overview of Numeric Types”
    FLOAT, Section 10.1.1, “Overview of Numeric Types”
    GEOMETRY, Section 11.13.4.1, “MySQL Spatial Data Types”
    GEOMETRYCOLLECTION, Section 11.13.4.1, “MySQL Spatial Data Types”
    INT, Section 10.1.1, “Overview of Numeric Types”
    INTEGER, Section 10.1.1, “Overview of Numeric Types”
    LINESTRING, Section 11.13.4.1, “MySQL Spatial Data Types”
    LONG, Section 10.4.3, “The BLOB and TEXT Types”
    LONGBLOB, Section 10.1.3, “Overview of String Types”
    LONGTEXT, Section 10.1.3, “Overview of String Types”
    MEDIUMBLOB, Section 10.1.3, “Overview of String Types”
    MEDIUMINT, Section 10.1.1, “Overview of Numeric Types”
    MEDIUMTEXT, Section 10.1.3, “Overview of String Types”
    MULTILINESTRING, Section 11.13.4.1, “MySQL Spatial Data Types”
    MULTIPOINT, Section 11.13.4.1, “MySQL Spatial Data Types”
    MULTIPOLYGON, Section 11.13.4.1, “MySQL Spatial Data Types”
    NATIONAL CHAR, Section 10.1.3, “Overview of String Types”
    NATIONAL VARCHAR, Section 10.1.3, “Overview of String Types”
    NCHAR, Section 10.1.3, “Overview of String Types”
    NUMERIC, Section 10.1.1, “Overview of Numeric Types”
    NVARCHAR, Section 10.1.3, “Overview of String Types”
    POINT, Section 11.13.4.1, “MySQL Spatial Data Types”
    POLYGON, Section 11.13.4.1, “MySQL Spatial Data Types”
    REAL, Section 10.1.1, “Overview of Numeric Types”
    SET, Section 10.1.3, “Overview of String Types”, Section 10.4.5, “The SET Type”
    SMALLINT, Section 10.1.1, “Overview of Numeric Types”
    TEXT, Section 10.4.3, “The BLOB and TEXT Types”, Section 10.1.3, “Overview of String Types”
    TIME, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.2, “The TIME Type”
    TIMESTAMP, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
    TINYBLOB, Section 10.1.3, “Overview of String Types”
    TINYINT, Section 10.1.1, “Overview of Numeric Types”
    TINYTEXT, Section 10.1.3, “Overview of String Types”
    VARBINARY, Section 10.4.2, “The BINARY and VARBINARY Types”, Section 10.1.3, “Overview of String Types”
    VARCHAR, Section 10.4, “String Types”, Section 10.1.3, “Overview of String Types”
    VARCHARACTER, Section 10.1.3, “Overview of String Types”
    YEAR, Section 10.1.2, “Overview of Date and Time Types”, Section 10.3.3, “The YEAR Type”
    data types, Chapter 10, Data Types
    C API, Section 21.9, “MySQL C API”
    overview, Section 10.1, “Data Type Overview”
    data-file-length option
    myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
    database
    altering, Section 12.1.1, “ALTER DATABASE Syntax”
    creating, Section 12.1.10, “CREATE DATABASE Syntax”
    deleting, Section 12.1.21, “DROP DATABASE Syntax”
    database metadata, Chapter 20, INFORMATION_SCHEMA Tables
    database names
    case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
    case-sensitivity, Section 1.8.4, “MySQL Extensions to Standard SQL”
    database option
    mysql, Section 4.5.1.1, “mysql Options”
    mysqlbinlog, Description
    databases
    backups, Chapter 6, Backup and Recovery
    copying, Section 2.4.5, “Copying MySQL Databases to Another Machine”
    creating, Section 3.3, “Creating and Using a Database”
    displaying, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
    dumping, Section 4.5.4, “mysqldump — A Database Backup Program”, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
    information about, Section 3.4, “Getting Information About Databases and Tables”
    names, Section 8.2, “Schema Object Names”
    replicating, Chapter 16, Replication
    selecting, Section 3.3.1, “Creating and Selecting a Database”
    symbolic links, Section 7.6.1.1, “Using Symbolic Links for Databases on Unix”
    using, Section 3.3, “Creating and Using a Database”
    databases option
    mysqlcheck, Description
    mysqldump, Description
    datadir option
    mysql.server, Description
    mysql_install_db, Description
    mysql_upgrade, Description
    mysqld, Section 5.1.2, “Server Command Options”
    mysqld_safe, Description
    datadir system variable, Section 5.1.4, “Server System Variables”
    date and time functions, Section 11.6, “Date and Time Functions”
    date calculations, Section 3.3.4.5, “Date Calculations”
    date functions
    Y2K compliance, Section 10.3.4, “Year 2000 Issues and Date Types”
    date types, Section 10.5, “Data Type Storage Requirements”
    Y2K issues, Section 10.3.4, “Year 2000 Issues and Date Types”
    date values, Section 8.1.3, “Date and Time Values”
    problems, Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
    date_format system variable, Section 5.1.4, “Server System Variables”
    dates
    used with partitioning, Section 18.2, “Partition Types”
    used with partitioning (examples), Section 18.2.1, “RANGE Partitioning”, Section 18.2.5, “Subpartitioning”, Section 18.4, “Partition Pruning”, Section 18.2.3, “HASH Partitioning”
    datetime_format system variable, Section 5.1.4, “Server System Variables”
    db option
    mysqlaccess, Description
    db table
    sorting, Section 5.4.5, “Access Control, Stage 2: Request Verification”
    debug option
    comp_err, Description
    make_win_bin_dist, Description
    my_print_defaults, Description
    myisamchk, Section 4.6.3.1, “myisamchk General Options”
    myisampack, Description
    mysql, Section 4.5.1.1, “mysql Options”
    mysqlaccess, Description
    mysqladmin, Description
    mysqlbinlog, Description
    mysqlcheck, Description
    mysqld, Section 5.1.2, “Server Command Options”
    mysqldump, Description
    mysqldumpslow, Description
    mysqlhotcopy, Description
    mysqlimport, Description
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    mysqlshow, Description
    mysqlslap, Description
    debug system variable, Section 5.1.4, “Server System Variables”
    debug-check option
    mysql, Section 4.5.1.1, “mysql Options”
    mysql_upgrade, Description
    mysqladmin, Description
    mysqlbinlog, Description
    mysqlcheck, Description
    mysqldump, Description
    mysqlimport, Description
    mysqlshow, Description
    mysqlslap, Description
    debug-info option
    comp_err, Description
    mysql, Section 4.5.1.1, “mysql Options”
    mysql_upgrade, Description
    mysqladmin, Description
    mysqlbinlog, Description
    mysqlcheck, Description
    mysqldump, Description
    mysqlimport, Description
    mysqlshow, Description
    mysqlslap, Description
    debug-sync-timeout option
    mysqld, Section 5.1.2, “Server Command Options”
    debug_sync system variable, Section 5.1.4, “Server System Variables”
    debugging
    client, Section 22.5.2, “Debugging a MySQL Client”
    server, Section 22.5.1, “Debugging a MySQL Server”
    debugging support, Section 2.3.2, “Typical configure Options”
    decimal point, Chapter 10, Data Types
    decode_bits myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
    default
    privileges, Section 2.13.2, “Securing the Initial MySQL Accounts”
    default host name, Section 4.2.2, “Connecting to the MySQL Server”
    default installation location, Section 2.1.5, “Installation Layouts”
    default options, Section 4.2.3.3, “Using Option Files”
    default values, Section 12.1.17, “CREATE TABLE Syntax”, Section 7.1.1, “MySQL Design Limitations and Tradeoffs”, Section 12.2.5, “INSERT Syntax”, Section 10.1.4, “Data Type Default Values”
    BLOB and TEXT columns, Section 10.4.3, “The BLOB and TEXT Types”
    explicit, Section 10.1.4, “Data Type Default Values”
    implicit, Section 10.1.4, “Data Type Default Values”
    suppression, Section 1.8.6.2, “Constraints on Invalid Data”
    default-character-set option
    mysql, Section 4.5.1.1, “mysql Options”
    mysqladmin, Description
    mysqlcheck, Description
    mysqld, Section 5.1.2, “Server Command Options”
    mysqldump, Description
    mysqlimport, Description
    mysqlshow, Description
    default-collation option
    mysqld, Section 5.1.2, “Server Command Options”
    default-mysqld-path option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    default-storage-engine option
    mysqld, Section 5.1.2, “Server Command Options”
    default-table-type option
    mysqld, Section 5.1.2, “Server Command Options”
    default-time-zone option
    mysqld, Section 5.1.2, “Server Command Options”
    default_storage_engine system variable, Section 5.1.4, “Server System Variables”
    default_week_format system variable, Section 5.1.4, “Server System Variables”
    defaults
    embedded, Section 21.8.3, “Options with the Embedded Server”
    defaults-extra-file option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    my_print_defaults, Description
    mysqld_multi, Description
    mysqld_safe, Description
    defaults-file option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    my_print_defaults, Description
    mysqld_multi, Description
    mysqld_safe, Description
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    defaults-group-suffix option, Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    my_print_defaults, Description
    delay-key-write option
    mysqld, Section 5.1.2, “Server Command Options”, Section 13.5.1, “MyISAM Startup Options”
    delay-key-write-for-all-tables option
    mysqld, Section 5.1.2, “Server Command Options”
    delay_key_write system variable, Section 5.1.4, “Server System Variables”
    delayed inserts
    thread states, Section 7.5.6.3, “Delayed-Insert Thread States”
    delayed-insert option
    mysqldump, Description
    delayed-start option
    mysqlslap, Description
    delayed_insert_limit, Section 12.2.5.2, “INSERT DELAYED Syntax”
    delayed_insert_limit system variable, Section 5.1.4, “Server System Variables”
    delayed_insert_timeout system variable, Section 5.1.4, “Server System Variables”
    delayed_queue_size system variable, Section 5.1.4, “Server System Variables”
    delete option
    mysqlimport, Description
    delete-master-logs option
    mysqldump, Description
    deleting
    database, Section 12.1.21, “DROP DATABASE Syntax”
    foreign key, Section 13.6.4.4, “FOREIGN KEY Constraints”, Section 12.1.7, “ALTER TABLE Syntax”
    function, Section 12.4.3.3, “DROP FUNCTION Syntax”
    index, Section 12.1.7, “ALTER TABLE Syntax”, Section 12.1.24, “DROP INDEX Syntax”
    primary key, Section 12.1.7, “ALTER TABLE Syntax”
    rows, Section B.5.5.6, “Deleting Rows from Related Tables”
    schema, Section 12.1.21, “DROP DATABASE Syntax”
    table, Section 12.1.28, “DROP TABLE Syntax”
    user, Section 5.5.3, “Removing User Accounts”, Section 12.4.1.2, “DROP USER Syntax”
    users, Section 5.5.3, “Removing User Accounts”, Section 12.4.1.2, “DROP USER Syntax”
    deleting from main table
    thread state, Section 7.5.6.2, “General Thread States”
    deleting from reference tables
    thread state, Section 7.5.6.2, “General Thread States”
    deletion
    mysql.sock, Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
    delimiter command
    mysql, Section 4.5.1.2, “mysql Commands”
    delimiter option
    mysql, Section 4.5.1.1, “mysql Options”
    mysqlslap, Description
    derived tables, Section 12.2.9.8, “Subqueries in the FROM Clause”
    des-key-file option
    mysqld, Section 5.1.2, “Server Command Options”
    description option
    myisamchk, Section 4.6.3.4, “Other myisamchk Options”
    design
    issues, Section B.5.8, “Known Issues in MySQL”
    limitations, Section 7.1.1, “MySQL Design Limitations and Tradeoffs”
    detach option
    mysqlslap, Description
    development of MySQL Cluster, Section 17.1.4, “MySQL Cluster Development History”
    development source tree, Section 2.3.3, “Installing from the Development Source Tree”
    digits, Chapter 10, Data Types
    directory structure
    default, Section 2.1.5, “Installation Layouts”
    disable named command
    mysql, Section 4.5.1.1, “mysql Options”
    disable-grant-options option
    configure, Section 2.3.2, “Typical configure Options”
    disable-keys option
    mysqldump, Description
    disable-log-bin option
    mysqlbinlog, Description
    discard_or_import_tablespace
    thread state, Section 7.5.6.2, “General Thread States”
    disconnect-slave-event-count option
    mysqld, Section 16.1.3.3, “Replication Slave Options and Variables”
    disconnecting
    from the server, Section 3.1, “Connecting to and Disconnecting from the Server”
    disk full, Section B.5.4.3, “How MySQL Handles a Full Disk”
    disk issues, Section 7.6, “Disk Issues”
    disks
    splitting data across, Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”
    display size, Chapter 10, Data Types
    display triggers, Section 12.4.5.40, “SHOW TRIGGERS Syntax”
    display width, Chapter 10, Data Types
    displaying
    database information, Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
    Cardinality, Section 12.4.5.23, “SHOW INDEX Syntax”
    Collation, Section 12.4.5.23, “SHOW INDEX Syntax”
    SHOW, Section 12.4.5.39, “SHOW TABLES Syntax”, Section 12.4.5.6, “SHOW COLUMNS Syntax”, Section 12.4.5, “SHOW Syntax”, Section 12.4.5.23, “SHOW INDEX Syntax”, Section 12.4.5.26, “SHOW OPEN TABLES Syntax”
    information
    Cardinality, Section 12.4.5.23, “SHOW INDEX Syntax”
    Collation, Section 12.4.5.23, “SHOW INDEX Syntax”
    SHOW, Section 12.4.5.39, “SHOW TABLES Syntax”, Section 12.4.5.6, “SHOW COLUMNS Syntax”, Section 12.4.5, “SHOW Syntax”, Section 12.4.5.23, “SHOW INDEX Syntax”, Section 12.4.5.26, “SHOW OPEN TABLES Syntax”
    table status, Section 12.4.5.38, “SHOW TABLE STATUS Syntax”
    div_precision_increment system variable, Section 5.1.4, “Server System Variables”
    division (/), Section 11.5.1, “Arithmetic Operators”
    double quote (\"), Section 8.1.1, “Strings”
    downgrades
    MySQL Cluster, Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”, Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”, Section 17.2.6, “Upgrading and Downgrading MySQL Cluster”
    downgrading, Section 2.4, “Upgrading or Downgrading MySQL”, Section 2.4.2, “Downgrading MySQL”
    downloading, Section 2.1.3, “How to Get MySQL”
    drbd
    FAQ, Section A.14.1, “Distributed Replicated Block Device (DRBD)”, Section A.14, “MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat”
    drop-user option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    dropping
    user, Section 5.5.3, “Removing User Accounts”, Section 12.4.1.2, “DROP USER Syntax”
    dryrun option
    mysqlhotcopy, Description
    dump option
    myisam_ftdump, Description
    dump-date option
    mysqldump, Description
    dump-slave option
    mysqldump, Description
    dumping
    databases and tables, Section 4.5.4, “mysqldump — A Database Backup Program”, Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
    dynamic table characteristics, Section 13.5.3.2, “Dynamic Table Characteristics”

    E

    ELT(), Section 11.4, “String Functions”
    ENCODE(), Section 11.11.2, “Encryption and Compression Functions”
    ENCRYPT(), Section 11.11.2, “Encryption and Compression Functions”
    ENGINES
    INFORMATION_SCHEMA table, Section 20.18, “The INFORMATION_SCHEMA ENGINES Table”
    ENTER SINGLE USER MODE command (MySQL Cluster), Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    ENUM
    size, Section 10.5, “Data Type Storage Requirements”
    ENUM data type, Section 10.4.4, “The ENUM Type”, Section 10.1.3, “Overview of String Types”
    ERROR Events (MySQL Cluster), Section 17.5.4.2, “MySQL Cluster Log Events”
    ERROR_FOR_DIVISION_BY_ZERO SQL mode, Section 5.1.7, “Server SQL Modes”
    EVENTS
    INFORMATION_SCHEMA table, Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
    EXAMPLE storage engine, Chapter 13, Storage Engines, Section 13.10, “The EXAMPLE Storage Engine”
    EXECUTE, Section 12.6.2, “EXECUTE Syntax”, Section 12.6, “SQL Syntax for Prepared Statements”
    EXISTS
    with subqueries, Section 12.2.9.6, “Subqueries with EXISTS or NOT EXISTS”
    EXIT SINGLE USER MODE command (MySQL Cluster), Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    EXIT command (MySQL Cluster), Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    EXP(), Section 11.5.2, “Mathematical Functions”
    EXPLAIN, Section 7.2.1, “Optimizing Queries with EXPLAIN”, Section 12.8.2, “EXPLAIN Syntax”
    EXPLAIN PARTITIONS, Section 18.3.4, “Obtaining Information About Partitions”
    EXPLAIN used with partitioned tables, Section 18.3.4, “Obtaining Information About Partitions”
    EXPORT_SET(), Section 11.4, “String Functions”
    EXTRACT(), Section 11.6, “Date and Time Functions”
    Eiffel Wrapper, Section 21.16, “MySQL Eiffel Wrapper”
    EndPoint(), Section 11.13.5.2.3, “LineString Functions”
    Envelope(), Section 11.13.5.2.1, “General Geometry Functions”
    Equals(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
    Errcode, Section 4.8.1, “perror — Explain Error Codes”
    Error
    thread command, Section 7.5.6.1, “Thread Command Values”
    Event Scheduler
    altering events, Section 12.1.2, “ALTER EVENT Syntax”
    and replication, Section 16.4.1.8, “Replication of Invoked Features”
    creating events, Section 12.1.11, “CREATE EVENT Syntax”
    dropping events, Section 12.1.22, “DROP EVENT Syntax”
    obtaining status information, Section 12.4.5.34, “SHOW SCHEDULER STATUS Syntax”
    Execute
    thread command, Section 7.5.6.1, “Thread Command Values”
    ExecuteOnComputer, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Execution of init_command
    thread state, Section 7.5.6.2, “General Thread States”
    ExteriorRing(), Section 11.13.5.2.5, “Polygon Functions”
    ExtractValue(), Section 11.10, “XML Functions”
    edit command
    mysql, Section 4.5.1.2, “mysql Commands”
    edit-user option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    ego command
    mysql, Section 4.5.1.2, “mysql Commands”
    embedded MySQL server library, Section 21.8, “libmysqld, the Embedded MySQL Server Library”
    embedded option
    make_win_bin_dist, Description
    mysql_config, Description
    enable-community-features option
    configure, Section 2.3.2, “Typical configure Options”
    enable-debug-sync option
    configure, Section 2.3.2, “Typical configure Options”
    enable-dtrace option
    configure, Section 2.3.2, “Typical configure Options”
    enable-named-pipe option
    mysqld, Section 5.1.2, “Server Command Options”
    enable-profiling option
    configure, Section 2.3.2, “Typical configure Options”
    enable-pstack option
    mysqld, Section 5.1.2, “Server Command Options”
    enable-thread-safe-client option
    configure, Section 2.3.2, “Typical configure Options”
    encryption, Section 5.5.6.1, “Basic SSL Concepts”
    encryption functions, Section 11.11.2, “Encryption and Compression Functions”
    end
    thread state, Section 7.5.6.2, “General Thread States”
    engine option
    mysqlslap, Description
    engine_condition_pushdown system variable, Section 5.1.4, “Server System Variables”
    enhancements
    MySQL Community Server, Appendix C, MySQL Change History
    MySQL Enterprise, Appendix C, MySQL Change History
    entering
    queries, Section 3.2, “Entering Queries”
    environment variable
    CC, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    CFLAGS, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    CXX, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    CXXFLAGS, Section 2.3.4, “Dealing with Problems Compiling MySQL”, Section 2.3.2, “Typical configure Options”, Section 2.14, “Environment Variables”
    DBI_TRACE, Section 22.5.1.4, “Debugging mysqld under gdb”, Section 2.14, “Environment Variables”
    DBI_USER, Section 2.14, “Environment Variables”
    HOME, Section 4.5.1.1, “mysql Options”, Section 2.14, “Environment Variables”
    LD_LIBRARY_PATH, Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
    LD_RUN_PATH, Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”, Section 2.14, “Environment Variables”
    MYSQL_DEBUG, Section 22.5.2, “Debugging a MySQL Client”, Section 4.1, “Overview of MySQL Programs”, Section 2.14, “Environment Variables”
    MYSQL_GROUP_SUFFIX, Section 2.14, “Environment Variables”
    MYSQL_HISTFILE, Section 4.5.1.1, “mysql Options”, Section 2.14, “Environment Variables”
    MYSQL_HOME, Section 2.14, “Environment Variables”
    MYSQL_HOST, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
    MYSQL_PS1, Section 2.14, “Environment Variables”
    MYSQL_PWD, Section 4.2.2, “Connecting to the MySQL Server”, Section 4.1, “Overview of MySQL Programs”, Section 2.14, “Environment Variables”
    MYSQL_TCP_PORT, Section 5.6.2, “Running Multiple Servers on Unix”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 4.1, “Overview of MySQL Programs”, Section 2.14, “Environment Variables”
    MYSQL_UNIX_PORT, Section 5.6.2, “Running Multiple Servers on Unix”, Section 5.6.3, “Using Client Programs in a Multiple-Server Environment”, Section 4.1, “Overview of MySQL Programs”, Section 2.14, “Environment Variables”, Section 2.13.1.1, “Problems Running mysql_install_db”
    PATH, Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”, Section 4.2.1, “Invoking MySQL Programs”, Section 2.14, “Environment Variables”
    TMPDIR, Section B.5.4.4, “Where MySQL Stores Temporary Files”, Section 4.1, “Overview of MySQL Programs”, Section 2.14, “Environment Variables”, Section 2.13.1.1, “Problems Running mysql_install_db”
    TZ, Section B.5.4.6, “Time Zone Problems”, Section 2.14, “Environment Variables”
    UMASK, Section B.5.3.2, “Problems with File Permissions”, Section 2.14, “Environment Variables”
    UMASK_DIR, Section B.5.3.2, “Problems with File Permissions”, Section 2.14, “Environment Variables”
    USER, Section 4.2.2, “Connecting to the MySQL Server”, Section 2.14, “Environment Variables”
    environment variables, Section 5.4.7, “Causes of Access-Denied Errors”, Section 4.2.4, “Setting Environment Variables”, Section 4.1, “Overview of MySQL Programs”
    CXX, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    list of, Section 2.14, “Environment Variables”
    eq_ref join type
    optimizer, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    equal (=), Section 11.2.3, “Comparison Functions and Operators”
    errno, Section 4.8.1, “perror — Explain Error Codes”
    error logs (MySQL Cluster), Description
    error messages
    can't find file, Section B.5.3.2, “Problems with File Permissions”
    displaying, Section 4.8.1, “perror — Explain Error Codes”
    languages, Section 9.2, “Setting the Error Message Language”
    error_count session variable, Section 5.1.4, “Server System Variables”
    errors
    access denied, Section B.5.2.1, “Access denied”
    and replication, Section 16.4.1.23, “Slave Errors During Replication”
    checking tables for, Section 6.6.2, “How to Check MyISAM Tables for Errors”
    common, Section B.5, “Problems and Common Errors”
    directory checksum, Section 2.8, “Installing MySQL on Solaris”
    handling for UDFs, Section 22.3.2.4, “UDF Return Values and Error Handling”
    in subqueries, Section 12.2.9.9, “Subquery Errors”
    known, Section B.5.8, “Known Issues in MySQL”
    linking, Section B.5.3.1, “Problems Linking to the MySQL Client Library”
    list of, Section B.5.2, “Common Errors When Using MySQL Programs”
    lost connection, Section B.5.2.3, “Lost connection to MySQL server”
    reporting, Section 1.7, “How to Report Bugs or Problems”, Chapter 1, General Information
    sources of information, Section B.1, “Sources of Error Information”
    escape (\\), Section 8.1.1, “Strings”
    escape sequences
    option files, Section 4.2.3.3, “Using Option Files”
    strings, Section 8.1.1, “Strings”
    estimating
    query performance, Section 7.2.2, “Estimating Query Performance”
    event
    restrictions, Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
    event groups, Section 12.5.2.6, “SET GLOBAL sql_slave_skip_counter Syntax”
    event log format (MySQL Cluster), Section 17.5.4.2, “MySQL Cluster Log Events”
    event logs (MySQL Cluster), Section 17.5.4.1, “MySQL Cluster Logging Management Commands”, Section 17.5.4, “Event Reports Generated in MySQL Cluster”
    event scheduler, Chapter 19, Stored Programs and Views
    thread states, Section 7.5.6.10, “Event Scheduler Thread States”
    event severity levels (MySQL Cluster), Section 17.5.4.1, “MySQL Cluster Logging Management Commands”
    event types (MySQL Cluster), Section 17.5.4, “Event Reports Generated in MySQL Cluster”, Section 17.5.4.2, “MySQL Cluster Log Events”
    event-scheduler option
    mysqld, Section 5.1.2, “Server Command Options”
    event_scheduler system variable, Section 5.1.4, “Server System Variables”
    events, Chapter 19, Stored Programs and Views
    altering, Section 12.1.2, “ALTER EVENT Syntax”
    creating, Section 12.1.11, “CREATE EVENT Syntax”
    dropping, Section 12.1.22, “DROP EVENT Syntax”
    events option
    mysqldump, Description
    example option
    mysqld_multi, Description
    examples
    compressed tables, Description
    myisamchk output, Section 4.6.3.5, “myisamchk Table Information”
    queries, Section 3.6, “Examples of Common Queries”
    exe-suffix option
    make_win_bin_dist, Description
    execute option
    mysql, Section 4.5.1.1, “mysql Options”
    executing
    thread state, Section 7.5.6.2, “General Thread States”
    executing SQL statements from text files, Section 3.5, “Using mysql in Batch Mode”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
    exit command
    mysql, Section 4.5.1.2, “mysql Commands”
    exit-info option
    mysqld, Section 5.1.2, “Server Command Options”
    expire_logs_days system variable, Section 5.1.4, “Server System Variables”
    explicit default values, Section 10.1.4, “Data Type Default Values”
    expression aliases, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”, Section 12.2.8, “SELECT Syntax”
    expressions
    extended, Section 3.3.4.7, “Pattern Matching”
    extend-check option
    myisamchk, Section 4.6.3.3, “myisamchk Repair Options”, Section 4.6.3.2, “myisamchk Check Options”
    extended option
    mysqlcheck, Description
    extended-insert option
    mysqldump, Description
    extensions
    to standard SQL, Section 1.8, “MySQL Standards Compliance”
    external locking, Section 5.1.4, “Server System Variables”, Section 7.5.6.2, “General Thread States”, Section 5.1.2, “Server Command Options”, Section 7.3.4, “External Locking”, Section 6.6.1, “Using myisamchk for Crash Recovery”
    external-locking option
    mysqld, Section 5.1.2, “Server Command Options”
    extra-file option
    my_print_defaults, Description
    extracting
    dates, Section 3.3.4.5, “Date Calculations”

    F

    FALSE, Section 8.1.5, “Boolean Values”, Section 8.1.2, “Numbers”
    testing for, Section 11.2.3, “Comparison Functions and Operators”
    FEDERATED storage engine, Chapter 13, Storage Engines, Section 13.11, “The FEDERATED Storage Engine”
    FIELD(), Section 11.4, “String Functions”
    FILE, Section 11.4, “String Functions”
    FILES
    INFORMATION_SCHEMA table, Section 20.21, “The INFORMATION_SCHEMA FILES Table”
    FIND_IN_SET(), Section 11.4, “String Functions”
    FIXED data type, Section 10.1.1, “Overview of Numeric Types”
    FLOAT data type, Section 10.1.1, “Overview of Numeric Types”
    FLOOR(), Section 11.5.2, “Mathematical Functions”
    FLUSH, Section 12.4.6.3, “FLUSH Syntax”
    and replication, Section 16.4.1.10, “Replication and FLUSH”
    FOR UPDATE, Section 12.2.8, “SELECT Syntax”
    FORCE INDEX, Section 12.2.8.2, “Index Hint Syntax”, Section B.5.6, “Optimizer-Related Issues”
    FORCE KEY, Section 12.2.8.2, “Index Hint Syntax”
    FORMAT(), Section 11.4, “String Functions”
    FOUND_ROWS(), Section 11.11.3, “Information Functions”
    FROM, Section 12.2.8, “SELECT Syntax”
    FROM_DAYS(), Section 11.6, “Date and Time Functions”
    FROM_UNIXTIME(), Section 11.6, “Date and Time Functions”
    FULLTEXT, Section 11.8, “Full-Text Search Functions”
    FULLTEXT initialization
    thread state, Section 7.5.6.2, “General Thread States”
    Falcon storage engine, Chapter 13, Storage Engines
    Fetch
    thread command, Section 7.5.6.1, “Thread Command Values”
    Field List
    thread command, Section 7.5.6.1, “Thread Command Values”
    FileSystemPath, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    FileSystemPathDD, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    FileSystemPathDataFiles, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    FileSystemPathUndoFiles, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Finished reading one binlog; switching to next binlog
    thread state, Section 7.5.6.5, “Replication Master Thread States”
    Flushing tables
    thread state, Section 7.5.6.2, “General Thread States”
    FragmentLogFileSize, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    FreeBSD troubleshooting, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Functions
    user-defined, Section 12.4.3.2, “CREATE FUNCTION Syntax”, Section 12.4.3.3, “DROP FUNCTION Syntax”
    failover
    Java clients, Section 17.1.1, “MySQL Cluster Core Concepts”
    in MySQL Cluster replication, Section 17.6.8, “Implementing Failover with MySQL Cluster Replication”
    fast option
    myisamchk, Section 4.6.3.2, “myisamchk Check Options”
    mysqlcheck, Description
    fatal signal 11, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    field
    changing, Section 12.1.7, “ALTER TABLE Syntax”
    fields-enclosed-by option
    mysqldump, Description, Description
    fields-escaped-by option
    mysqldump, Description, Description
    fields-optionally-enclosed-by option
    mysqldump, Description, Description
    fields-terminated-by option
    mysqldump, Description, Description
    files
    binary log, Section 5.2.4, “The Binary Log”
    config.cache, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    error messages, Section 9.2, “Setting the Error Message Language”
    general query log, Section 5.2.3, “The General Query Log”
    log, Section 2.3.2, “Typical configure Options”, Section 5.2.6, “Server Log Maintenance”
    my.cnf, Section 16.4.1, “Replication Features and Issues”
    not found message, Section B.5.3.2, “Problems with File Permissions”
    permissions, Section B.5.3.2, “Problems with File Permissions”
    repairing, Section 4.6.3.3, “myisamchk Repair Options”
    script, Section 3.5, “Using mysql in Batch Mode”
    size limits, Section B.5.2.12, “The table is full”
    slow query log, Section 5.2.5, “The Slow Query Log”
    text, Section 4.5.5, “mysqlimport — A Data Import Program”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
    tmp, Section 2.13.1.1, “Problems Running mysql_install_db”
    update log (obsolete), Section 5.2.4, “The Binary Log”
    filesort optimization, Section 7.2.13, “ORDER BY Optimization”
    firewalls (software)
    and MySQL Cluster, Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”
    first-slave option
    mysqldump, Description
    fix-db-names option
    mysqlcheck, Description
    fix-table-names option
    mysqlcheck, Description
    floating-point number, Section 10.1.1, “Overview of Numeric Types”
    floating-point values
    and replication, Section 16.4.1.9, “Replication and Floating-Point Values”
    floats, Section 8.1.2, “Numbers”
    flush option
    mysqld, Section 5.1.2, “Server Command Options”
    flush system variable, Section 5.1.4, “Server System Variables”
    flush tables, Description
    flush-logs option
    mysqldump, Description
    flush-privileges option
    mysqldump, Description
    flush_time system variable, Section 5.1.4, “Server System Variables”
    flushlog option
    mysqlhotcopy, Description
    force option
    myisamchk, Section 4.6.3.3, “myisamchk Repair Options”, Section 4.6.3.2, “myisamchk Check Options”
    myisampack, Description
    mysql, Section 4.5.1.1, “mysql Options”
    mysql_convert_table_format, Description
    mysql_install_db, Description
    mysql_upgrade, Description
    mysqladmin, Description
    mysqlcheck, Description
    mysqldump, Description
    mysqlimport, Description
    force-read option
    mysqlbinlog, Description
    foreign key
    constraint, Section 1.8.6.1, “PRIMARY KEY and UNIQUE Index Constraints”
    deleting, Section 13.6.4.4, “FOREIGN KEY Constraints”, Section 12.1.7, “ALTER TABLE Syntax”
    foreign keys, Section 3.6.6, “Using Foreign Keys”, Section 1.8.5.4, “Foreign Keys”, Section 12.1.7, “ALTER TABLE Syntax”
    foreign_key_checks session variable, Section 5.1.4, “Server System Variables”
    freeing items
    thread state, Section 7.5.6.2, “General Thread States”
    frequently asked questions about MySQL Cluster, MySQL 4.1 FAQ: MySQL Cluster
    frequently-asked questions about DRBD, Section A.14.1, “Distributed Replicated Block Device (DRBD)”, Section A.14, “MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat”
    frequently-asked questions about MySQL Cluster, Section A.10, “MySQL 5.1 FAQ: MySQL Cluster”
    ft_boolean_syntax system variable, Section 5.1.4, “Server System Variables”
    ft_max_word_len myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
    ft_max_word_len system variable, Section 5.1.4, “Server System Variables”
    ft_min_word_len myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
    ft_min_word_len system variable, Section 5.1.4, “Server System Variables”
    ft_query_expansion_limit system variable, Section 5.1.4, “Server System Variables”
    ft_stopword_file myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
    ft_stopword_file system variable, Section 5.1.4, “Server System Variables”
    full disk, Section B.5.4.3, “How MySQL Handles a Full Disk”
    full-text search, Section 11.8, “Full-Text Search Functions”
    fulltext
    stopword list, Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
    fulltext join type
    optimizer, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    function
    creating, Section 12.4.3.2, “CREATE FUNCTION Syntax”
    deleting, Section 12.4.3.3, “DROP FUNCTION Syntax”
    function names
    parsing, Section 8.2.4, “Function Name Parsing and Resolution”
    resolving ambiguity, Section 8.2.4, “Function Name Parsing and Resolution”
    functions, Chapter 11, Functions and Operators
    C API, Section 21.9.2, “C API Function Overview”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    C prepared statement API, Section 21.9.5.2, “C API Prepared Statement Type Conversions”, Section 21.9.6, “C API Prepared Statement Function Overview”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    GROUP BY, Section 11.12.1, “GROUP BY (Aggregate) Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    and replication, Section 16.4.1.11, “Replication and System Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    arithmetic, Section 11.11.1, “Bit Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    bit, Section 11.11.1, “Bit Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    cast, Section 11.9, “Cast Functions and Operators”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    control flow, Section 11.3, “Control Flow Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    date and time, Section 11.6, “Date and Time Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    encryption, Section 11.11.2, “Encryption and Compression Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    grouping, Section 11.2.1, “Operator Precedence”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    information, Section 11.11.3, “Information Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    mathematical, Section 11.5.2, “Mathematical Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    miscellaneous, Section 11.11.4, “Miscellaneous Functions”
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    native
    adding, Section 22.3.3, “Adding a New Native Function”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    new, Section 22.3, “Adding New Functions to MySQL”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    stored, Section 19.2, “Using Stored Routines (Procedures and Functions)”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    string, Section 11.4, “String Functions”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    string comparison, Section 11.4.1, “String Comparison Functions”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    user-defined, Section 22.3, “Adding New Functions to MySQL”
    adding, Section 22.3.2, “Adding a New User-Defined Function”
    functions for SELECT and WHERE clauses, Chapter 11, Functions and Operators

    G

    GCP Stop errors (MySQL Cluster), Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    GEOMETRY data type, Section 11.13.4.1, “MySQL Spatial Data Types”
    GEOMETRYCOLLECTION data type, Section 11.13.4.1, “MySQL Spatial Data Types”
    GET_FORMAT(), Section 11.6, “Date and Time Functions”
    GET_LOCK(), Section 11.11.4, “Miscellaneous Functions”
    GIS, Section 11.13, “Spatial Extensions”, Section 11.13.1, “Introduction to MySQL Spatial Support”
    GLOBAL_STATUS
    INFORMATION_SCHEMA table, Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
    GLOBAL_VARIABLES
    INFORMATION_SCHEMA table, Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”
    GLength(), Section 11.13.5.2.4, “MultiLineString Functions”, Section 11.13.5.2.3, “LineString Functions”
    GRANT, Section 12.4.1.3, “GRANT Syntax”
    GRANT statement, Section 5.5.2, “Adding User Accounts”
    GRANTS, Section 12.4.5.22, “SHOW GRANTS Syntax”
    GREATEST(), Section 11.2.3, “Comparison Functions and Operators”
    GROUP BY, Section 7.2.14, “GROUP BY Optimization”
    aliases in, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
    extensions to standard SQL, Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”, Section 12.2.8, “SELECT Syntax”
    GROUP BY functions, Section 11.12.1, “GROUP BY (Aggregate) Functions”
    GROUP_CONCAT(), Section 11.12.1, “GROUP BY (Aggregate) Functions”
    GeomCollFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
    GeomCollFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
    GeomFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”, Section 11.13.5.1, “Geometry Format Conversion Functions”
    GeomFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”, Section 11.13.5.1, “Geometry Format Conversion Functions”
    GeometryCollection(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
    GeometryCollectionFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
    GeometryCollectionFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
    GeometryFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
    GeometryFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
    GeometryN(), Section 11.13.5.2.7, “GeometryCollection Functions”
    GeometryType(), Section 11.13.5.2.1, “General Geometry Functions”
    gap event, Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    gap lock
    InnoDB, Section 13.6.8.4, “InnoDB Record, Gap, and Next-Key Locks”, Section 13.6.8, “The InnoDB Transaction Model and Locking”, Section 13.6.8.5, “Avoiding the Phantom Problem Using Next-Key Locking”, Section 13.6.3, “InnoDB Startup Options and System Variables”
    gb2312, gbk, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    gcc, Section 2.3.2, “Typical configure Options”
    gdb
    using, Section 22.5.1.4, “Debugging mysqld under gdb”
    gdb option
    mysqld, Section 5.1.2, “Server Command Options”
    general information, Chapter 1, General Information
    general query log, Section 5.2.3, “The General Query Log”
    general-log option
    mysqld, Section 5.1.2, “Server Command Options”
    general_log system variable, Section 5.1.4, “Server System Variables”
    general_log_file system variable, Section 5.1.4, “Server System Variables”
    geographic feature, Section 11.13.1, “Introduction to MySQL Spatial Support”
    geometry, Section 11.13.1, “Introduction to MySQL Spatial Support”
    geospatial feature, Section 11.13.1, “Introduction to MySQL Spatial Support”
    getting MySQL, Section 2.1.3, “How to Get MySQL”
    global privileges, Section 12.4.1.5, “REVOKE Syntax”, Section 12.4.1.3, “GRANT Syntax”
    go command
    mysql, Section 4.5.1.2, “mysql Commands”
    got handler lock
    thread state, Section 7.5.6.3, “Delayed-Insert Thread States”
    got old table
    thread state, Section 7.5.6.3, “Delayed-Insert Thread States”
    grant tables
    re-creating, Section 2.13.1.1, “Problems Running mysql_install_db”
    sorting, Section 5.4.5, “Access Control, Stage 2: Request Verification”, Section 5.4.4, “Access Control, Stage 1: Connection Verification”
    structure, Section 5.4.2, “Privilege System Grant Tables”
    upgrading, Section 4.4.4, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”
    granting
    privileges, Section 12.4.1.3, “GRANT Syntax”
    greater than (>), Section 11.2.3, “Comparison Functions and Operators”
    greater than or equal (>=), Section 11.2.3, “Comparison Functions and Operators”
    greatest timestamp wins (conflict resolution), Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    greatest timestamp, delete wins (conflict resolution), Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    group_concat_max_len system variable, Section 5.1.4, “Server System Variables”
    grouping
    expressions, Section 11.2.1, “Operator Precedence”

    H

    HANDLER, Section 12.2.4, “HANDLER Syntax”
    HAVING, Section 12.2.8, “SELECT Syntax”
    HEAP storage engine, Chapter 13, Storage Engines, Section 13.9, “The MEMORY (HEAP) Storage Engine”
    HELP command (MySQL Cluster), Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    HELP option
    myisamchk, Section 4.6.3.1, “myisamchk General Options”
    HELP statement, Section 12.8.3, “HELP Syntax”
    HEX(), Section 11.5.2, “Mathematical Functions”, Section 11.4, “String Functions”
    HIGH_NOT_PRECEDENCE SQL mode, Section 5.1.7, “Server SQL Modes”
    HIGH_PRIORITY, Section 12.2.8, “SELECT Syntax”
    HOME environment variable, Section 4.5.1.1, “mysql Options”, Section 2.14, “Environment Variables”
    HOUR(), Section 11.6, “Date and Time Functions”
    Has read all relay log; waiting for the slave I/O thread to update it
    thread state, Section 7.5.6.7, “Replication Slave SQL Thread States”
    Has sent all binlog to slave; waiting for binlog to be updated
    thread state, Section 7.5.6.5, “Replication Master Thread States”
    HeartbeatIntervalDbApi, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    HeartbeatIntervalDbDb, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    HeartbeatThreadPriority, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Host*SciId* parameters, Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”
    HostName, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    HostName (MySQL Cluster), Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”
    handling
    errors, Section 22.3.2.4, “UDF Return Values and Error Handling”
    hash partitioning, Section 18.2.3, “HASH Partitioning”
    hash partitions
    managing, Section 18.3.2, “Management of HASH and KEY Partitions”
    splitting and merging, Section 18.3.2, “Management of HASH and KEY Partitions”
    have_archive system variable, Section 5.1.4, “Server System Variables”
    have_bdb system variable, Section 5.1.4, “Server System Variables”
    have_blackhole_engine system variable, Section 5.1.4, “Server System Variables”
    have_community_features system variable, Section 5.1.4, “Server System Variables”
    have_compress system variable, Section 5.1.4, “Server System Variables”
    have_crypt system variable, Section 5.1.4, “Server System Variables”
    have_csv system variable, Section 5.1.4, “Server System Variables”
    have_dynamic_loading system variable, Section 5.1.4, “Server System Variables”
    have_example_engine system variable, Section 5.1.4, “Server System Variables”
    have_federated_engine system variable, Section 5.1.4, “Server System Variables”
    have_geometry system variable, Section 5.1.4, “Server System Variables”
    have_innodb system variable, Section 5.1.4, “Server System Variables”
    have_isam system variable, Section 5.1.4, “Server System Variables”
    have_merge_engine system variable, Section 5.1.4, “Server System Variables”
    have_openssl system variable, Section 5.1.4, “Server System Variables”
    have_partitioning system variable, Section 5.1.4, “Server System Variables”
    have_profiling system variable, Section 5.1.4, “Server System Variables”
    have_query_cache system variable, Section 5.1.4, “Server System Variables”
    have_raid system variable, Section 5.1.4, “Server System Variables”
    have_row_based_replication system variable, Section 5.1.4, “Server System Variables”
    have_rtree_keys system variable, Section 5.1.4, “Server System Variables”
    have_ssl system variable, Section 5.1.4, “Server System Variables”
    have_symlink system variable, Section 5.1.4, “Server System Variables”
    header_file option
    comp_err, Description
    help command
    mysql, Section 4.5.1.2, “mysql Commands”
    help option
    comp_err, Description
    my_print_defaults, Description
    myisam_ftdump, Description
    myisamchk, Section 4.6.3.1, “myisamchk General Options”
    myisampack, Description
    mysql, Section 4.5.1.1, “mysql Options”
    mysql_convert_table_format, Description
    mysql_find_rows, Description
    mysql_setpermission, Description
    mysql_upgrade, Description
    mysql_waitpid, Description
    mysqlaccess, Description
    mysqladmin, Description
    mysqlbinlog, Description
    mysqlcheck, Description
    mysqld, Section 5.1.2, “Server Command Options”
    mysqld_multi, Description
    mysqld_safe, Description
    mysqldump, Description
    mysqldumpslow, Description
    mysqlhotcopy, Description
    mysqlimport, Description
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    mysqlshow, Description
    mysqlslap, Description
    perror, Description
    resolve_stack_dump, Description
    resolveip, Description
    hex-blob option
    mysqldump, Description
    hexadecimal values, Section 8.1.4, “Hexadecimal Values”
    hexdump option
    mysqlbinlog, Description
    hints, Section 1.8.4, “MySQL Extensions to Standard SQL”, Section 12.2.8.1, “JOIN Syntax”, Section 12.2.8, “SELECT Syntax”
    index, Section 12.2.8.2, “Index Hint Syntax”, Section 12.2.8, “SELECT Syntax”
    host name
    default, Section 4.2.2, “Connecting to the MySQL Server”
    host name caching, Section 7.5.11, “How MySQL Uses DNS”
    host name resolution, Section 7.5.11, “How MySQL Uses DNS”
    host option, Section 4.2.2, “Connecting to the MySQL Server”
    mysql, Section 4.5.1.1, “mysql Options”
    mysql_convert_table_format, Description
    mysql_setpermission, Description
    mysqlaccess, Description
    mysqladmin, Description
    mysqlbinlog, Description
    mysqlcheck, Description
    mysqldump, Description
    mysqlhotcopy, Description
    mysqlimport, Description
    mysqlshow, Description
    mysqlslap, Description
    host table, Section 5.4.5, “Access Control, Stage 2: Request Verification”
    sorting, Section 5.4.5, “Access Control, Stage 2: Request Verification”
    host.frm
    problems finding, Section 2.13.1, “Unix Post-Installation Procedures”
    hostname system variable, Section 5.1.4, “Server System Variables”
    howto option
    mysqlaccess, Description
    html option
    mysql, Section 4.5.1.1, “mysql Options”

    I

    IBM i5/OS, Section 2.9, “Installing MySQL on i5/OS”
    IBMDB2I storage engine, Chapter 13, Storage Engines
    ID
    unique, Section 21.9.10.3, “How to Get the Unique ID for the Last Inserted Row”
    IF(), Section 11.3, “Control Flow Functions”
    IFNULL(), Section 11.3, “Control Flow Functions”
    IGNORE
    with partitioned tables, Section 12.2.5, “INSERT Syntax”
    IGNORE INDEX, Section 12.2.8.2, “Index Hint Syntax”
    IGNORE KEY, Section 12.2.8.2, “Index Hint Syntax”
    IGNORE_SPACE SQL mode, Section 5.1.7, “Server SQL Modes”
    IMPORT TABLESPACE, Section 12.1.7, “ALTER TABLE Syntax”, Section 13.6.2.1, “Using Per-Table Tablespaces”
    IN, Section 11.2.3, “Comparison Functions and Operators”, Section 12.2.9.3, “Subqueries with ANY, IN, or SOME”
    INDEX DIRECTORY
    and replication, Section 16.4.1.7, “Replication and DIRECTORY Table Options”
    INET_ATON(), Section 11.11.4, “Miscellaneous Functions”
    INET_NTOA(), Section 11.11.4, “Miscellaneous Functions”
    INFO Events (MySQL Cluster), Section 17.5.4.2, “MySQL Cluster Log Events”
    INFORMATION_SCHEMA, Chapter 20, INFORMATION_SCHEMA Tables
    and security issues, Section 17.5.9.2, “MySQL Cluster and MySQL Privileges”
    collation and searching, Section 9.1.7.8, “Collation and INFORMATION_SCHEMA Searches”
    INFORMATION_SCHEMA.ENGINES table
    used with MySQL Cluster, Section 17.5.7, “Quick Reference: MySQL Cluster SQL Statements”
    INFORMATION_SCHEMA.GLOBAL_STATUS table
    used with MySQL Cluster, Section 17.5.7, “Quick Reference: MySQL Cluster SQL Statements”
    INFORMATION_SCHEMA.GLOBAL_VARIABLES table
    used with MySQL Cluster, Section 17.5.7, “Quick Reference: MySQL Cluster SQL Statements”
    INNER JOIN, Section 12.2.8.1, “JOIN Syntax”
    INSERT, Section 12.2.5, “INSERT Syntax”, Section 7.2.21, “Speed of INSERT Statements”
    INSERT ... SELECT, Section 12.2.5.1, “INSERT ... SELECT Syntax”
    INSERT DELAYED, Section 12.2.5.2, “INSERT DELAYED Syntax”
    INSERT statement
    grant privileges, Section 5.5.2, “Adding User Accounts”
    INSERT(), Section 11.4, “String Functions”
    INSTALL PLUGIN, Section 12.4.3.4, “INSTALL PLUGIN Syntax”
    INSTR(), Section 11.4, “String Functions”
    INT data type, Section 10.1.1, “Overview of Numeric Types”
    INTEGER data type, Section 10.1.1, “Overview of Numeric Types”
    INTERVAL(), Section 11.2.3, “Comparison Functions and Operators”
    IPv6 connections, Section 2.13.2, “Securing the Initial MySQL Accounts”
    IS NOT NULL, Section 11.2.3, “Comparison Functions and Operators”
    IS NOT boolean_value, Section 11.2.3, “Comparison Functions and Operators”
    IS NULL, Section 7.2.8, “IS NULL Optimization”, Section 11.2.3, “Comparison Functions and Operators”
    and indexes, Section 7.4.4, “How MySQL Uses Indexes”
    IS boolean_value, Section 11.2.3, “Comparison Functions and Operators”
    ISAM storage engine, Chapter 13, Storage Engines
    ISNULL(), Section 11.2.3, “Comparison Functions and Operators”
    ISOLATION LEVEL, Section 12.3.6, “SET TRANSACTION Syntax”
    IS_FREE_LOCK(), Section 11.11.4, “Miscellaneous Functions”
    IS_USED_LOCK(), Section 11.11.4, “Miscellaneous Functions”
    Id, Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    IndexMemory, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”, Section 17.3.2.12, “Configuring MySQL Cluster Parameters for Local Checkpoints”
    Init DB
    thread command, Section 7.5.6.1, “Thread Command Values”
    InitFragmentLogFiles, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    InitialLogFileGroup, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    InitialNoOfOpenFiles, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    InitialTablespace, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Initialized
    thread state, Section 7.5.6.10, “Event Scheduler Thread States”
    InnoDB, Section 13.6, “The InnoDB Storage Engine”
    Monitors, Section 13.6.11.2, “File Space Management”, Section 13.6.13.4, “Troubleshooting InnoDB Data Dictionary Operations”, Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”, Section 13.6.6, “Backing Up and Recovering an InnoDB Database”, Section 13.6.13.3, “InnoDB General Troubleshooting”
    NFS, Section 13.6.14, “Restrictions on InnoDB Tables”, Section 13.6.3, “InnoDB Startup Options and System Variables”, Section 13.6.2, “InnoDB Configuration”
    Solaris 10 x86_64 issues, Section 2.8, “Installing MySQL on Solaris”
    backups, Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    clustered index, Section 13.6.10.1, “Clustered and Secondary Indexes”
    gap lock, Section 13.6.8.4, “InnoDB Record, Gap, and Next-Key Locks”, Section 13.6.8, “The InnoDB Transaction Model and Locking”, Section 13.6.8.5, “Avoiding the Phantom Problem Using Next-Key Locking”, Section 13.6.3, “InnoDB Startup Options and System Variables”
    index-record lock, Section 13.6.8.4, “InnoDB Record, Gap, and Next-Key Locks”, Section 13.6.8, “The InnoDB Transaction Model and Locking”, Section 13.6.8.5, “Avoiding the Phantom Problem Using Next-Key Locking”, Section 13.6.3, “InnoDB Startup Options and System Variables”
    next-key lock, Section 13.6.8.4, “InnoDB Record, Gap, and Next-Key Locks”, Section 13.6.8, “The InnoDB Transaction Model and Locking”, Section 13.6.8.5, “Avoiding the Phantom Problem Using Next-Key Locking”, Section 13.6.3, “InnoDB Startup Options and System Variables”
    page size, Section 13.6.14, “Restrictions on InnoDB Tables”, Section 13.6.10.2, “Physical Structure of an Index”
    record-level locks, Section 13.6.8.4, “InnoDB Record, Gap, and Next-Key Locks”, Section 13.6.8, “The InnoDB Transaction Model and Locking”, Section 13.6.8.5, “Avoiding the Phantom Problem Using Next-Key Locking”, Section 13.6.3, “InnoDB Startup Options and System Variables”
    secondary index, Section 13.6.10.1, “Clustered and Secondary Indexes”
    semi-consistent read, Section 13.6.3, “InnoDB Startup Options and System Variables”
    transaction isolation levels, Section 13.6.8, “The InnoDB Transaction Model and Locking”
    InnoDB buffer pool, Section 7.4.6, “The InnoDB Buffer Pool”
    InnoDB storage engine, Chapter 13, Storage Engines, Section 13.6, “The InnoDB Storage Engine”
    InnoDB tables, Section 1.8.5.3, “Transactions and Atomic Operations”
    InteriorRingN(), Section 11.13.5.2.5, “Polygon Functions”
    Intersection(), Section 11.13.5.3.2, “Spatial Operators”
    Intersects(), Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”
    IsClosed(), Section 11.13.5.2.4, “MultiLineString Functions”
    IsEmpty(), Section 11.13.5.2.1, “General Geometry Functions”
    IsRing(), Section 11.13.5.2.3, “LineString Functions”
    IsSimple(), Section 11.13.5.2.1, “General Geometry Functions”
    i-am-a-dummy option
    mysql, Section 4.5.1.1, “mysql Options”
    i5/OS, Section 2.9, “Installing MySQL on i5/OS”
    icc
    MySQL builds, Section 2.1.6, “Compiler-Specific Build Characteristics”
    and MySQL Cluster support>, Section 22.5, “Debugging and Porting MySQL”
    identifiers, Section 8.2, “Schema Object Names”
    case sensitivity, Section 8.2.2, “Identifier Case Sensitivity”
    quoting, Section 8.2, “Schema Object Names”
    identity session variable, Section 5.1.4, “Server System Variables”
    ignore option
    mysqlimport, Description
    ignore-builtin-innodb option
    mysqld, Section 13.6.3, “InnoDB Startup Options and System Variables”
    ignore-lines option
    mysqlimport, Description
    ignore-spaces option
    mysql, Section 4.5.1.1, “mysql Options”
    ignore-sql-errors option
    mysqlslap, Description
    ignore-table option
    mysqldump, Description
    implicit default values, Section 10.1.4, “Data Type Default Values”
    importing
    data, Section 4.5.5, “mysqlimport — A Data Import Program”, Section 4.5.1.4, “Executing SQL Statements from a Text File”
    in_file option
    comp_err, Description
    include option
    mysql_config, Description
    include-master-host-port option
    mysqldump, Description
    increasing
    performance, Section 16.4.4, “Replication FAQ”
    increasing with replication
    speed, Chapter 16, Replication
    incremental recovery, Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
    using MySQL Cluster replication, Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
    index
    deleting, Section 12.1.7, “ALTER TABLE Syntax”, Section 12.1.24, “DROP INDEX Syntax”
    rebuilding, Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    index hints, Section 12.2.8.2, “Index Hint Syntax”, Section 12.2.8, “SELECT Syntax”
    index join type
    optimizer, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    index-record lock
    InnoDB, Section 13.6.8.4, “InnoDB Record, Gap, and Next-Key Locks”, Section 13.6.8, “The InnoDB Transaction Model and Locking”, Section 13.6.8.5, “Avoiding the Phantom Problem Using Next-Key Locking”, Section 13.6.3, “InnoDB Startup Options and System Variables”
    index_merge join type
    optimizer, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    index_subquery join type
    optimizer, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    indexes, Section 12.1.13, “CREATE INDEX Syntax”
    and BLOB columns, Section 12.1.17, “CREATE TABLE Syntax”, Section 7.4.2, “Column Indexes”
    and IS NULL, Section 7.4.4, “How MySQL Uses Indexes”
    and LIKE, Section 7.4.4, “How MySQL Uses Indexes”
    and NULL values, Section 12.1.17, “CREATE TABLE Syntax”
    and TEXT columns, Section 12.1.17, “CREATE TABLE Syntax”, Section 7.4.2, “Column Indexes”
    assigning to key cache, Section 12.4.6.2, “CACHE INDEX Syntax”
    block size, Section 5.1.4, “Server System Variables”
    columns, Section 7.4.2, “Column Indexes”
    leftmost prefix of, Section 7.4.4, “How MySQL Uses Indexes”
    multi-column, Section 7.4.3, “Multiple-Column Indexes”
    multiple-part, Section 12.1.13, “CREATE INDEX Syntax”
    names, Section 8.2, “Schema Object Names”
    use of, Section 7.4.4, “How MySQL Uses Indexes”
    information functions, Section 11.11.3, “Information Functions”
    information option
    myisamchk, Section 4.6.3.2, “myisamchk Check Options”
    init
    thread state, Section 7.5.6.2, “General Thread States”
    init-file option
    mysqld, Section 5.1.2, “Server Command Options”
    init_connect system variable, Section 5.1.4, “Server System Variables”
    init_file system variable, Section 5.1.4, “Server System Variables”
    init_slave system variable, Section 16.1.3.3, “Replication Slave Options and Variables”
    innochecksum, Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”, Section 4.1, “Overview of MySQL Programs”
    innodb option
    mysqld, Section 13.6.3, “InnoDB Startup Options and System Variables”
    innodb-safe-binlog option
    mysqld, Section 5.1.2, “Server Command Options”
    innodb-status-file option
    mysqld, Section 13.6.3, “InnoDB Startup Options and System Variables”
    insert
    thread state, Section 7.5.6.3, “Delayed-Insert Thread States”
    insert-ignore option
    mysqldump, Description
    insert_id session variable, Section 5.1.4, “Server System Variables”
    insertable views
    insertable, Section 19.5.3, “Updatable and Insertable Views”
    inserting
    speed of, Section 7.2.21, “Speed of INSERT Statements”
    inserts
    concurrent, Section 7.3.1, “Internal Locking Methods”, Section 7.3.3, “Concurrent Inserts”
    install option
    mysqlmanager, Section 4.6.10.1, “MySQL Instance Manager Command Options”
    installation layouts, Section 2.1.5, “Installation Layouts”
    installation overview, Section 2.3, “MySQL Installation Using a Source Distribution”
    installing
    Linux RPM packages, Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
    Mac OS X PKG packages, Section 2.7, “Installing MySQL on Mac OS X”
    Perl, Section 2.15, “Perl Installation Notes”
    Perl on Windows, Section 2.15.2, “Installing ActiveState Perl on Windows”
    Solaris PKG packages, Section 2.8, “Installing MySQL on Solaris”
    binary distribution, Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    overview, Chapter 2, Installing and Upgrading MySQL
    source distribution, Section 2.3, “MySQL Installation Using a Source Distribution”
    user-defined functions, Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    installing MySQL Cluster, Section 17.2.1, “MySQL Cluster Multi-Computer Installation”, Section 17.2, “MySQL Cluster Multi-Computer How-To”
    installing plugins, Section 12.4.3.4, “INSTALL PLUGIN Syntax”, Section 12.4.3.1, “Installing and Uninstalling Plugins”
    integers, Section 8.1.2, “Numbers”
    interactive_timeout system variable, Section 5.1.4, “Server System Variables”
    internal compiler errors, Section 2.3.4, “Dealing with Problems Compiling MySQL”
    internal locking, Section 7.3.1, “Internal Locking Methods”
    internals, Section 22.1, “MySQL Internals”
    internationalization, Chapter 9, Internationalization and Localization
    introducer
    string literal, Section 8.1.1, “Strings”, Section 9.1.3.5, “Character String Literal Character Set and Collation”
    invalid data
    constraint, Section 1.8.6.2, “Constraints on Invalid Data”
    invalidating query cache entries
    thread state, Section 7.5.6.4, “Query Cache Thread States”
    isamchk, Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”, Section 4.1, “Overview of MySQL Programs”
    isamlog, Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”, Section 4.1, “Overview of MySQL Programs”
    iterations option
    mysqlslap, Description

    J

    JOIN, Section 12.2.8.1, “JOIN Syntax”
    Japanese character sets
    conversion, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Japanese, Korean, Chinese character sets
    frequently asked questions, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    jdbc
    mysql
    loadbalance, Section 17.1.1, “MySQL Cluster Core Concepts”
    join
    nested-loop algorithm, Section 7.2.11, “Nested Join Optimization”
    join algorithm
    Block Nested-Loop, Section 7.2.10, “Nested-Loop Join Algorithms”
    Nested-Loop, Section 7.2.10, “Nested-Loop Join Algorithms”
    join option
    myisampack, Description
    join type
    ALL, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    const, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    eq_ref, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    fulltext, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    index, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    index_merge, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    index_subquery, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    range, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    ref, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    ref_or_null, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    system, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    unique_subquery, Section 7.2.1, “Optimizing Queries with EXPLAIN”
    join_buffer_size system variable, Section 5.1.4, “Server System Variables”
    join_cache_level system variable, Section 5.1.4, “Server System Variables”

    K

    KEY_COLUMN_USAGE
    INFORMATION_SCHEMA table, Section 20.13, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”
    KILL, Section 12.4.6.4, “KILL Syntax”
    Key cache
    MyISAM, Section 7.4.5, “The MyISAM Key Cache”
    Kill
    thread command, Section 7.5.6.1, “Thread Command Values”
    Killed
    thread state, Section 7.5.6.2, “General Thread States”
    Killing slave
    thread state, Section 7.5.6.8, “Replication Slave Connection Thread States”
    Korean, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    Korean, Chinese, Japanese character sets
    frequently asked questions, Section A.11, “MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
    keep_files_on_create system variable, Section 5.1.4, “Server System Variables”
    keepold option
    mysqlhotcopy, Description
    key cache
    assigning indexes to, Section 12.4.6.2, “CACHE INDEX Syntax”
    key partitioning, Section 18.2.4, “KEY Partitioning”
    key partitions
    managing, Section 18.3.2, “Management of HASH and KEY Partitions”
    splitting and merging, Section 18.3.2, “Management of HASH and KEY Partitions”
    key space
    MyISAM, Section 13.5.2, “Space Needed for Keys”
    key_buffer_size myisamchk variable, Section 4.6.3.1, “myisamchk General Options”
    key_buffer_size system variable, Section 5.1.4, “Server System Variables”
    key_cache_age_threshold system variable, Section 5.1.4, “Server System Variables”
    key_cache_block_size system variable, Section 5.1.4, “Server System Variables”
    key_cache_division_limit system variable, Section 5.1.4, “Server System Variables”
    keys, Section 7.4.2, “Column Indexes”
    foreign, Section 3.6.6, “Using Foreign Keys”, Section 1.8.5.4, “Foreign Keys”
    multi-column, Section 7.4.3, “Multiple-Column Indexes”
    searching on two, Section 3.6.7, “Searching on Two Keys”
    keys option
    mysqlshow, Description
    keys-used option
    myisamchk, Section 4.6.3.3, “myisamchk Repair Options”
    keywords, Section 8.3, “Reserved Words”
    known errors, Section B.5.8, “Known Issues in MySQL”

    L

    LAST_DAY(), Section 11.6, “Date and Time Functions”
    LAST_INSERT_ID(), Section 1.8.5.3, “Transactions and Atomic Operations”, Section 12.2.5, “INSERT Syntax”
    and replication, Section 16.4.1.1, “Replication and AUTO_INCREMENT”
    LAST_INSERT_ID() and stored routines, Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
    LAST_INSERT_ID() and triggers, Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
    LAST_INSERT_ID([<replaceable>expr</replaceable>]), Section 11.11.3, “Information Functions”
    LCASE(), Section 11.4, “String Functions”
    LD_LIBRARY_PATH environment variable, Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
    LD_RUN_PATH environment variable, Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”, Section 2.14, “Environment Variables”
    LEAST(), Section 11.2.3, “Comparison Functions and Operators”
    LEFT JOIN, Section 7.2.9, “LEFT JOIN and RIGHT JOIN Optimization”, Section 12.2.8.1, “JOIN Syntax”
    LEFT OUTER JOIN, Section 12.2.8.1, “JOIN Syntax”
    LEFT(), Section 11.4, “String Functions”
    LENGTH(), Section 11.4, “String Functions”
    LIKE, Section 11.4.1, “String Comparison Functions”
    and indexes, Section 7.4.4, “How MySQL Uses Indexes”
    and wildcards, Section 7.4.4, “How MySQL Uses Indexes”
    LIMIT, Section 7.2.17, “LIMIT Optimization”, Section 12.2.8, “SELECT Syntax”, Section 11.11.3, “Information Functions”
    and replication, Section 16.4.1.12, “Replication and LIMIT”
    LINESTRING data type, Section 11.13.4.1, “MySQL Spatial Data Types”
    LN(), Section 11.5.2, “Mathematical Functions”
    LOAD DATA
    and replication, Section 16.4.1.13, “Replication and LOAD DATA INFILE”
    LOAD DATA FROM MASTER, Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    LOAD DATA INFILE, Section B.5.5.3, “Problems with NULL Values”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    LOAD INDEX INTO CACHE
    and partitioning, Section 18.5, “Restrictions and Limitations on Partitioning”
    LOAD TABLE FROM MASTER, Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
    LOAD_FILE(), Section 11.4, “String Functions”
    LOCALTIME, Section 11.6, “Date and Time Functions”
    LOCALTIMESTAMP, Section 11.6, “Date and Time Functions”
    LOCATE(), Section 11.4, “String Functions”
    LOCK IN SHARE MODE, Section 12.2.8, “SELECT Syntax”
    LOCK TABLES, Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
    LOG(), Section 11.5.2, “Mathematical Functions”
    LOG10(), Section 11.5.2, “Mathematical Functions”
    LOG2(), Section 11.5.2, “Mathematical Functions”
    LONG data type, Section 10.4.3, “The BLOB and TEXT Types”
    LONGBLOB data type, Section 10.1.3, “Overview of String Types”
    LONGTEXT data type, Section 10.1.3, “Overview of String Types”
    LOWER(), Section 11.4, “String Functions”
    LPAD(), Section 11.4, “String Functions”
    LTRIM(), Section 11.4, “String Functions”
    LineFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
    LineFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
    LineString(), Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
    LineStringFromText(), Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
    LineStringFromWKB(), Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
    Lock Monitor
    InnoDB, Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
    LockExecuteThreadToCPU, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LockMaintThreadsToCPU, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LockPagesInMainMemory, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Locked
    thread state, Section 7.5.6.2, “General Thread States”
    LogDestination, Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    LogLevelCheckpoint, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelCheckpoint (MySQL Cluster configuration parameter), Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelCongestion, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelConnection, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelConnection (MySQL Cluster configuration parameter), Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelError, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelInfo, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelNodeRestart, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelNodeRestart (MySQL Cluster configuration parameter), Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelShutdown, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelStartup, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelStatistic, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    LogLevelStatistic (MySQL Cluster configuration parameter), Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Long Data
    thread command, Section 7.5.6.1, “Thread Command Values”
    LongMessageBuffer, Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    label option
    mysqlslap, Description
    language option
    mysqld, Section 5.1.2, “Server Command Options”
    language support
    error messages, Section 9.2, “Setting the Error Message Language”
    language system variable, Section 5.1.4, “Server System Variables”
    large page support, Section 7.5.9, “Enabling Large Page Support”
    large-pages option
    mysqld, Section 5.1.2, “Server Command Options”
    large_files_support system variable, Section 5.1.4, “Server System Variables”
    large_page_size system variable, Section 5.1.4, “Server System Variables”
    large_pages system variable, Section 5.1.4, “Server System Variables”
    last row
    unique ID, Section 21.9.10.3, “How to Get the Unique ID for the Last Inserted Row”
    last_insert_id session variable, Section 5.1.4, “Server System Variables”
    layout of installation, Section 2.1.5, “Installation Layouts”
    lc-messages option
    mysqld, Section 5.1.2, “Server Command Options”
    lc-messages-dir option
    mysqld, Section 5.1.2, “Server Command Options”
    lc_messages system variable, Section 5.1.4, “Server System Variables”
    lc_messages_dir system variable, Section 5.1.4, “Server System Variables”
    lc_time_names system variable, Section 5.1.4, “Server System Variables”
    ldata option
    mysql_install_db, Description
    ledir option
    mysqld_safe, Description
    leftmost prefix of indexes, Section 7.4.4, “How MySQL Uses Indexes”
    legal names, Section 8.2, “Schema Object Names”
    length option
    myisam_ftdump, Description
    less than (<), Section 11.2.3, “Comparison Functions and Operators”
    less than or equal (<=), Section 11.2.3, “Comparison Functions and Operators”
    libmysqld, Section 21.8, “libmysqld, the Embedded MySQL Server Library”
    options, Section 21.8.3, “Options with the Embedded Server”
    libmysqld-libs option
    mysql_config, Description
    library
    mysqlclient, Chapter 21, Connectors and APIs
    mysqld, Chapter 21, Connectors and APIs
    libs option
    mysql_config, Description
    libs_r option
    mysql_config, Description
    license system variable, Section 5.1.4, “Server System Variables”
    limitations
    MySQL Limitations, Section D.7, “Limits in MySQL”
    design, Section 7.1.1, “MySQL Design Limitations and Tradeoffs”
    replication, Section 16.4.1, “Replication Features and Issues”
    limitations of MySQL Cluster, Section 17.1.5, “Known Limitations of MySQL Cluster”
    limits
    MySQL Limits, limits in MySQL, Section D.7, “Limits in MySQL”
    file-size, Section B.5.2.12, “The table is full”
    line-numbers option
    mysql, Section 4.5.1.1, “mysql Options”
    linear hash partitioning, Section 18.2.3.1, “LINEAR HASH Partitioning”
    linear key partitioning, Section 18.2.4, “KEY Partitioning”
    linefeed (\n), Section 8.1.1, “Strings”, Section 12.2.6, “LOAD DATA INFILE Syntax”
    lines-terminated-by option
    mysqldump, Description, Description
    linking, Section 21.9.16, “Building Client Programs”
    errors, Section B.5.3.1, “Problems Linking to the MySQL Client Library”
    problems, Section 21.9.16.1, “Problems Linking with the C API”
    speed, Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    links
    symbolic, Section 7.6.1, “Using Symbolic Links”
    list partitioning, Section 18.2.2, “LIST Partitioning”
    list partitions
    adding and dropping, Section 18.3.1, “Management of RANGE and LIST