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

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

    Index

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

    Symbols

    [index top]
    ! (logical NOT), Logical Operators
    != (not equal), Comparison Functions and Operators
    ", Schema Object Names
    #mysql50 identifier prefix, Schema Object Names, Mapping of Identifiers to File Names
    %, Arithmetic Operators
    % (modulo), Mathematical Functions
    % (wildcard character), Strings
    & (bitwise AND), Bit Functions
    && (logical AND), Logical Operators
    () (parentheses), Operator Precedence
    (Control-Z) \Z, Strings, LOAD DATA INFILE Syntax
    * (multiplication), Arithmetic Operators
    + (addition), Arithmetic Operators
    - (subtraction), Arithmetic Operators
    - (unary minus), Arithmetic Operators
    --append option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --bind-address option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --character-sets-dir option
    MySQL Cluster programs, Options Common to MySQL Cluster Programs
    --config-cache option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --config-file option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --configdir option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --connect-string option (MySQL Cluster), Options Common to MySQL Cluster Programs
    --core-file option (MySQL Cluster), Options Common to MySQL Cluster Programs
    --daemon option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --debug option (MySQL Cluster), Options Common to MySQL Cluster Programs
    --disable option prefix, Program Option Modifiers
    --disable-indexes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --enable option prefix, Program Option Modifiers
    --exclude-databases option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --exclude-missing-columns option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --exclude-tables option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --execute option (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client
    --fields-enclosed-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --fields-optionally-enclosed-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --fields-terminated-by option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --help option
    MySQL Cluster programs, Options Common to MySQL Cluster Programs
    --hex option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --include-databases option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --include-tables option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --initial option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
    --initial option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
    --initial option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --initial-start option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
    --initial-start option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
    --log-name option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --loose option prefix, Program Option Modifiers
    --maximum option prefix, Program Option Modifiers
    --ndb-log-update-as-write (mysqld option), MySQL Cluster Replication Conflict Resolution
    --ndb-mgmd-host option (MySQL Cluster), Options Common to MySQL Cluster Programs
    --ndb-nodeid option (MySQL Cluster), Options Common to MySQL Cluster Programs
    --ndb-optimized-node-selection option (MySQL Cluster), Options Common to MySQL Cluster Programs
    --nodaemon option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
    --nodaemon option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
    --nodaemon option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --nostart option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
    --nostart option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
    --nowait-nodes option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
    --nowait-nodes option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
    --nowait-nodes option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --password option, End-User Guidelines for Password Security
    --print-full-config option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --rebuild-indexes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --reload option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    --restore_backupid option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_backup_path option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_connect option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_epoch option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_nodeid option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_preserve-trailing-spaces option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_print_data option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_promote-attributes option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --restore_skip-table-check option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --skip option prefix, Program Option Modifiers
    --skip-unknown-objects option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --tab option (ndb_restore), ndb_restore — Restore a MySQL Cluster Backup
    --usage option
    MySQL Cluster programs, Options Common to MySQL Cluster Programs
    --version option (MySQL Cluster), Options Common to MySQL Cluster Programs
    -? option
    MySQL Cluster programs, Options Common to MySQL Cluster Programs
    -c option (MySQL Cluster), Options Common to MySQL Cluster Programs
    -c option (ndb_mgmd) (OBSOLETE), ndb_mgmd — The MySQL Cluster Management Server Daemon
    -d option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    -e option (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client
    -f option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    -n option (ndbd), ndbd — The MySQL Cluster Data Node Daemon
    -n option (ndbmtd), ndbd — The MySQL Cluster Data Node Daemon
    -p option, End-User Guidelines for Password Security
    -P option (ndb_mgmd), ndb_mgmd — The MySQL Cluster Management Server Daemon
    -V option (MySQL Cluster), Options Common to MySQL Cluster Programs
    .my.cnf file, Connecting to the MySQL Server, Using Option Files, End-User Guidelines for Password Security, Causes of Access-Denied Errors, Using Client Programs in a Multiple-Server Environment
    .mysql_history file, mysql Options, End-User Guidelines for Password Security
    .pid (process ID) file, Setting Up a MyISAM Table Maintenance Schedule
    / (division), Arithmetic Operators
    /etc/passwd, Making MySQL Secure Against Attackers, SELECT Syntax
    := (assignment), User-Defined Variables
    < (less than), Comparison Functions and Operators
    <<, Calculating Visits Per Day
    << (left shift), Bit Functions
    <= (less than or equal), Comparison Functions and Operators
    <=> (equal to), Comparison Functions and Operators
    <> (not equal), Comparison Functions and Operators
    = (assignment), User-Defined Variables
    = (equal), Comparison Functions and Operators
    > (greater than), Comparison Functions and Operators
    >= (greater than or equal), Comparison Functions and Operators
    >> (right shift), Bit Functions
    [api] (MySQL Cluster), MySQL Cluster SQL Node and API Node Configuration Parameters
    [computer] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
    [mgm] (MySQL Cluster), MySQL Cluster Management Node Configuration Parameters
    [ndbd default] (MySQL Cluster), MySQL Cluster Data Node Configuration Parameters
    [ndbd] (MySQL Cluster), MySQL Cluster Data Node Configuration Parameters
    [ndb_mgmd] (MySQL Cluster), MySQL Cluster Management Node Configuration Parameters
    [sci] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
    [shm] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
    [SQL] (MySQL Cluster), MySQL Cluster SQL Node and API Node Configuration Parameters
    [tcp] (MySQL Cluster), Other MySQL Cluster Configuration Parameters
    \" (double quote), Strings
    \' (single quote), Strings
    \. (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File
    \0 (ASCII NUL), Strings, LOAD DATA INFILE Syntax
    \b (backspace), Strings, LOAD DATA INFILE Syntax
    \n (linefeed), Strings, LOAD DATA INFILE Syntax
    \n (newline), Strings, LOAD DATA INFILE Syntax
    \N (NULL), LOAD DATA INFILE Syntax
    \r (carriage return), Strings, LOAD DATA INFILE Syntax
    \t (tab), Strings, LOAD DATA INFILE Syntax
    \Z (Control-Z) ASCII 26, Strings, LOAD DATA INFILE Syntax
    \\ (escape), Strings
    ^ (bitwise XOR), Bit Functions
    _ (wildcard character), Strings
    _rowid, CREATE TABLE Syntax
    `, Schema Object Names
    | (bitwise OR), Bit Functions
    || (logical OR), Logical Operators
    ~, Bit Functions

    A

    [index top]
    abort-slave-event-count option
    mysqld, Replication Slave Options and Variables
    aborted clients, Communication Errors and Aborted Connections
    aborted connection, Communication Errors and Aborted Connections
    ABS(), Mathematical Functions
    access control, Access Control, Stage 1: Connection Verification
    access denied errors, Access denied
    access privileges, The MySQL Access Privilege System
    account names, Specifying Account Names
    account privileges
    adding, Adding User Accounts
    accounts
    anonymous user, Securing the Initial MySQL Accounts
    root, Securing the Initial MySQL Accounts
    ACID, Transactions and Atomic Operations, The InnoDB Storage Engine
    ACLs, The MySQL Access Privilege System
    ACOS(), Mathematical Functions
    Active Server Pages (ASP), Using Connector/ODBC with Active Server Pages (ASP)
    ActiveState Perl, Installing ActiveState Perl on Windows
    add-drop-database option
    mysqldump, mysqldump — A Database Backup Program
    add-drop-table option
    mysqldump, mysqldump — A Database Backup Program
    add-locks option
    mysqldump, mysqldump — A Database Backup Program
    add-user option
    mysqlmanager, MySQL Instance Manager Command Options
    ADDDATE(), Date and Time Functions
    adding
    character sets, Adding a New Character Set
    native functions, Adding a New Native Function
    new account privileges, Adding User Accounts
    new functions, Adding New Functions to MySQL
    new user privileges, Adding User Accounts
    new users, Installing MySQL from Generic Binaries on Unix/Linux, Source Installation Overview
    procedures, Adding New Procedures to MySQL
    user-defined functions, Adding a New User-Defined Function
    addition (+), Arithmetic Operators
    ADDTIME(), Date and Time Functions
    addtodest option
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    administration
    server, mysqladmin — Client for Administering a MySQL Server
    administration of MySQL Cluster, ndb_mgm — The MySQL Cluster Management Client
    administrative programs, Overview of MySQL Programs
    AES_DECRYPT(), Encryption and Compression Functions
    AES_ENCRYPT(), Encryption and Compression Functions
    After create
    thread state, General Thread States
    age
    calculating, Date Calculations
    alias names
    case sensitivity, Identifier Case Sensitivity
    aliases
    for expressions, GROUP BY and HAVING with Hidden Columns
    for tables, SELECT Syntax
    in GROUP BY clauses, GROUP BY and HAVING with Hidden Columns
    names, Schema Object Names
    on expressions, SELECT Syntax
    ALL, SELECT Syntax, Subqueries with ALL
    ALL join type
    optimizer, Optimizing Queries with EXPLAIN
    all-databases option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqldump, mysqldump — A Database Backup Program
    all-in-1 option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    all-tablespaces option
    mysqldump, mysqldump — A Database Backup Program
    allocating local table
    thread state, Delayed-Insert Thread States
    allow-keywords option
    mysqldump, mysqldump — A Database Backup Program
    allow-suspicious-udfs option
    mysqld, Server Command Options, Security-Related mysqld Options
    allowold option
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    ALLOW_INVALID_DATES SQL mode, Server SQL Modes
    ALTER COLUMN, ALTER TABLE Syntax
    ALTER DATABASE, ALTER DATABASE Syntax
    ALTER EVENT, ALTER EVENT Syntax
    ALTER FUNCTION, ALTER FUNCTION Syntax
    ALTER LOGFILE GROUP, ALTER LOGFILE GROUP Syntax
    (see also MySQL Cluster Disk Data)
    ALTER PROCEDURE, ALTER PROCEDURE Syntax
    ALTER SCHEMA, ALTER DATABASE Syntax
    ALTER SERVER, ALTER SERVER Syntax
    ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE
    ALTER TABLESPACE, ALTER TABLESPACE Syntax
    (see also MySQL Cluster Disk Data)
    ALTER VIEW, ALTER VIEW Syntax
    altering
    database, ALTER DATABASE Syntax
    schema, ALTER DATABASE Syntax
    analyze option
    myisamchk, Other myisamchk Options
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    ANALYZE TABLE, ANALYZE TABLE Syntax
    and partitioning, Maintenance of Partitions
    Analyzing
    thread state, General Thread States
    AND
    bitwise, Bit Functions
    logical, Logical Operators
    angel-pid-file option
    mysqlmanager, MySQL Instance Manager Command Options
    anonymous user, Securing the Initial MySQL Accounts, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
    ANSI mode
    running, Running MySQL in ANSI Mode
    ansi option
    mysqld, Server Command Options
    ANSI SQL mode, Server SQL Modes
    ANSI_QUOTES SQL mode, Server SQL Modes
    answering questions
    etiquette, Guidelines for Using the Mailing Lists
    ANY, Subqueries with ANY, IN, or SOME
    Apache, Using MySQL with Apache
    API node (MySQL Cluster)
    defined, MySQL Cluster Core Concepts
    API nodes (see SQL nodes)
    API's
    list of, Packages that support MySQL
    APIs, Connectors and APIs
    Perl, MySQL Perl API
    apply_status table (OBSOLETE), MySQL Cluster Replication Schema and Tables
    (see also MySQL Cluster replication)
    approximate-value literals, Precision Math
    Arbitration, Defining MySQL Cluster Data Nodes
    ArbitrationDelay, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster
    ArbitrationRank, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster
    ArbitrationTimeout (DEPRECATED), Defining MySQL Cluster Data Nodes
    arbitrator, MySQL 5.1 FAQ: MySQL Cluster
    ARCHIVE storage engine, Storage Engines, The ARCHIVE Storage Engine
    Area(), Polygon Functions, MultiPolygon Functions
    argument processing, UDF Argument Processing
    arithmetic expressions, Arithmetic Operators
    arithmetic functions, Bit Functions
    AS, SELECT Syntax, JOIN Syntax
    AS/400, Installing MySQL on i5/OS
    AsBinary(), Geometry Format Conversion Functions
    ASCII(), String Functions
    ASIN(), Mathematical Functions
    AsText(), Geometry Format Conversion Functions
    asynchronous replication (see MySQL Cluster replication)
    ATAN(), Mathematical Functions
    ATAN2(), Mathematical Functions
    attackers
    security against, Making MySQL Secure Against Attackers
    attribute demotion
    replication, Replication of Columns Having Different Data Types
    attribute promotion
    ndb_restore, ndb_restore — Restore a MySQL Cluster Backup
    replication, Replication of Columns Having Different Data Types
    auto-generate-sql option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-add-autoincrement option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-execute-number option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-guid-primary option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-load-type option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-secondary-indexes option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-unique-query-number option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-unique-write-number option
    mysqlslap, mysqlslap — Load Emulation Client
    auto-generate-sql-write-number option
    mysqlslap, mysqlslap — Load Emulation Client
    AUTO-INCREMENT
    ODBC, Obtaining Auto-Increment Values
    auto-rehash option
    mysql, mysql Options
    auto-repair option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    autoclose option
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    autocommit session variable, Server System Variables
    automatic_sp_privileges system variable, Server System Variables
    AutoReconnect
    API and SQL nodes, Defining SQL and Other API Nodes in a MySQL Cluster
    AUTO_INCREMENT, Using AUTO_INCREMENT, Numeric Types
    and NULL values, Problems with NULL Values
    and replication, Replication and AUTO_INCREMENT
    auto_increment_increment system variable, Replication Master Options and Variables
    auto_increment_offset system variable, Replication Master Options and Variables
    AVG(), GROUP BY (Aggregate) Functions
    AVG(DISTINCT), GROUP BY (Aggregate) Functions

    B

    [index top]
    backslash
    escape character, Strings
    backspace (\b), Strings, LOAD DATA INFILE Syntax
    backup identifiers
    native backup and restore, Using The MySQL Cluster Management Client to Create a Backup
    backup option
    myisamchk, myisamchk Repair Options
    myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
    BACKUP TABLE, BACKUP TABLE Syntax
    BackupDataBufferSize, Configuration for MySQL Cluster Backups
    BackupDataBufferSize (MySQL Cluster configuration parameter), Defining MySQL Cluster Data Nodes
    BackupDataDir, Defining MySQL Cluster Data Nodes
    BackupLogBufferSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
    BackupMaxWriteSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
    BackupMemory, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
    BackupReportFrequency, Defining MySQL Cluster Data Nodes
    backups, Backup and Recovery
    database, BACKUP TABLE Syntax
    databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
    in MySQL Cluster, ndb_restore — Restore a MySQL Cluster Backup, Online Backup of MySQL Cluster, MySQL Cluster Backup Concepts, Using The MySQL Cluster Management Client to Create a Backup, Configuration for MySQL Cluster Backups
    in MySQL Cluster replication, MySQL Cluster Backups With MySQL Cluster Replication
    InnoDB, Backing Up and Recovering an InnoDB Database
    with mysqldump, Using mysqldump for Backups
    backups, troubleshooting
    in MySQL Cluster, MySQL Cluster Backup Troubleshooting
    BackupWriteSize, Defining MySQL Cluster Data Nodes, Configuration for MySQL Cluster Backups
    back_log system variable, Server System Variables
    base64-output option
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    basedir option
    mysql.server, mysql.server — MySQL Server Startup Script
    mysqld, Server Command Options
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
    mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
    basedir system variable, Server System Variables
    batch mode, Using mysql in Batch Mode
    batch option
    mysql, mysql Options
    batch SQL files, mysql — The MySQL Command-Line Tool
    BatchByteSize, Defining SQL and Other API Nodes in a MySQL Cluster
    batched updates (MySQL Cluster Replication), Starting MySQL Cluster Replication (Single Replication Channel)
    BatchSize, Defining SQL and Other API Nodes in a MySQL Cluster
    BatchSizePerLocalScan, Defining MySQL Cluster Data Nodes
    Bazaar tree, Installing from the Development Source Tree
    BdMPolyFromText(), Creating Geometry Values Using WKT Functions
    BdMPolyFromWKB(), Creating Geometry Values Using WKB Functions
    BdPolyFromText(), Creating Geometry Values Using WKT Functions
    BdPolyFromWKB(), Creating Geometry Values Using WKB Functions
    BEGIN, START TRANSACTION, COMMIT, and ROLLBACK Syntax, BEGIN ... END Compound Statement Syntax
    XA transactions, XA Transaction SQL Syntax
    benchmark suite, The MySQL Benchmark Suite
    BENCHMARK(), Information Functions
    benchmarks, Using Your Own Benchmarks
    BETWEEN ... AND, Comparison Functions and Operators
    big-tables option
    mysqld, Server Command Options
    big5, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    BIGINT data type, Overview of Numeric Types
    big_tables session variable, Server System Variables
    BIN(), String Functions
    BINARY, Cast Functions and Operators
    BINARY data type, Overview of String Types, The BINARY and VARBINARY Types
    binary distributions
    installing, Installing MySQL from Generic Binaries on Unix/Linux
    binary log, The Binary Log
    event groups, SET GLOBAL sql_slave_skip_counter Syntax
    binary logging
    and MySQL Cluster, Issues Exclusive to MySQL Cluster
    bind-address option
    mysqld, Server Command Options
    mysqlmanager, MySQL Instance Manager Command Options
    BINLOG, BINLOG Syntax
    Binlog Dump
    thread command, Thread Command Values
    BINLOG statement
    mysqlbinlog output, mysqlbinlog Row Event Display
    binlog-do-db option
    mysqld, Binary Log Options and Variables
    binlog-format option
    mysqld, Server Command Options
    binlog-ignore-db option
    mysqld, Binary Log Options and Variables
    binlog-row-event-max-size option
    mysqld, Binary Log Options and Variables
    binlog_cache_size system variable, Binary Log Options and Variables
    binlog_direct_non_transactional_updates system variable, Binary Log Options and Variables
    binlog_format system variable, Binary Log Options and Variables
    binlog_index table (OBSOLETE) (see MySQL Cluster replication)
    BIT data type, Overview of Numeric Types
    BitKeeper tree, Installing from the Development Source Tree
    BIT_AND(), GROUP BY (Aggregate) Functions
    BIT_COUNT, Calculating Visits Per Day
    BIT_COUNT(), Bit Functions
    bit_functions
    example, Calculating Visits Per Day
    BIT_LENGTH(), String Functions
    BIT_OR, Calculating Visits Per Day
    BIT_OR(), GROUP BY (Aggregate) Functions
    BIT_XOR(), GROUP BY (Aggregate) Functions
    BLACKHOLE storage engine, Storage Engines, The BLACKHOLE Storage Engine
    BLOB
    inserting binary data, Strings
    size, Data Type Storage Requirements
    BLOB columns
    default values, The BLOB and TEXT Types
    indexing, Column Indexes, CREATE TABLE Syntax
    BLOB data type, Overview of String Types, The BLOB and TEXT Types
    blob-info option
    ndb_desc, ndb_desc — Describe NDB Tables
    Block Nested-Loop join algorithm, Nested-Loop Join Algorithms
    block-search option
    myisamchk, Other myisamchk Options
    blocks
    ndbinfo table, The ndbinfo blocks Table
    BOOL data type, Overview of Numeric Types
    BOOLEAN data type, Overview of Numeric Types
    boolean options, Program Option Modifiers
    bootstrap option
    mysqld, Server Command Options
    Borland Builder 4, Using Connector/ODBC with Borland Builder 4
    Boundary(), General Geometry Functions
    brackets
    square, Data Types
    brief option
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    Buffer pool
    InnoDB, The InnoDB Buffer Pool
    buffer sizes
    client, Connectors and APIs
    mysqld server, Tuning Server Parameters
    Buffer(), Spatial Operators
    bug reports
    criteria for, How to Report Bugs or Problems
    bugs
    known, Known Issues in MySQL
    MySQL Cluster
    reporting, ndb_error_reporter — NDB Error-Reporting Utility
    reporting, How to Report Bugs or Problems
    bugs database, How to Report Bugs or Problems
    bugs.mysql.com, How to Report Bugs or Problems
    building
    client programs, Building Client Programs
    bulk_insert_buffer_size system variable, Server System Variables

    C

    [index top]
    C API
    data types, MySQL C API
    functions, C API Function Overview
    linking problems, Problems Linking with the C API
    C prepared statement API
    functions, C API Prepared Statement Type Conversions, C API Prepared Statement Function Overview
    type codes, C API Prepared Statement Type Codes
    C++ APIs, MySQL C++ API
    C++ Builder, Using Connector/ODBC with C++ Builder
    C++ compiler
    gcc, Typical configure Options
    C++ compiler cannot create executables, Dealing with Problems Compiling MySQL
    C:\my.cnf file, Using Client Programs in a Multiple-Server Environment
    CACHE INDEX, CACHE INDEX Syntax
    and partitioning, Restrictions and Limitations on Partitioning
    caches
    clearing, FLUSH Syntax
    calculating
    dates, Date Calculations
    calendar, What Calendar Is Used By MySQL?
    CALL, CALL Syntax
    calling sequences for aggregate functions
    UDF, UDF Calling Sequences for Aggregate Functions
    calling sequences for simple functions
    UDF, UDF Calling Sequences for Simple Functions
    can't create/write to file, Can't create/write to file
    carriage return (\r), Strings, LOAD DATA INFILE Syntax
    CASE, Control Flow Functions, CASE Statement
    case sensitivity
    in access checking, Privilege System Grant Tables
    in identifiers, Identifier Case Sensitivity
    in names, Identifier Case Sensitivity
    in searches, Case Sensitivity in String Searches
    in string comparisons, String Comparison Functions
    case-sensitivity
    of database names, MySQL Extensions to Standard SQL
    of table names, MySQL Extensions to Standard SQL
    CAST, Cast Functions and Operators
    cast functions, Cast Functions and Operators
    cast operators, Cast Functions and Operators
    casts, Type Conversion in Expression Evaluation, Comparison Functions and Operators, Cast Functions and Operators
    CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
    cc1plus problems, Dealing with Problems Compiling MySQL
    CEIL(), Mathematical Functions
    CEILING(), Mathematical Functions
    Centroid(), MultiPolygon Functions
    CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
    cflags option
    mysql_config, mysql_config — Get Compile Options for Compiling Clients
    CHANGE MASTER TO, CHANGE MASTER TO Syntax
    in MySQL Cluster, Preparing the MySQL Cluster for Replication
    Change user
    thread command, Thread Command Values
    ChangeLog, MySQL Change History
    changes
    log, MySQL Change History
    MySQL 5.1, Changes in Release 5.1.x (Production)
    MySQL Cluster, Changes in MySQL Cluster NDB 6.X and 7.X, Release Series Changelogs: MySQL Cluster NDB 6.X and 7.X
    changes to privileges, When Privilege Changes Take Effect
    changing
    column, ALTER TABLE Syntax
    field, ALTER TABLE Syntax
    table, ALTER TABLE Syntax, Problems with ALTER TABLE
    Changing master
    thread state, Replication Slave Connection Thread States
    changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Unix Socket File
    CHAR data type, Overview of String Types, String Types
    CHAR VARYING data type, Overview of String Types
    CHAR(), String Functions
    CHARACTER data type, Overview of String Types
    character set repertoire, String Repertoire
    character sets, Typical configure Options
    adding, Adding a New Character Set
    and MySQL Cluster (replication), Known Issues in MySQL Cluster Replication
    and replication, Replication and Character Sets
    Character sets, Character Set Support
    CHARACTER VARYING data type, Overview of String Types
    character-set-client-handshake option
    mysqld, Server Command Options
    character-set-filesystem option
    mysqld, Server Command Options
    character-set-server option
    mysqld, Server Command Options
    character-sets-dir option
    myisamchk, myisamchk Repair Options
    myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
    mysql, mysql Options
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqld, Server Command Options
    mysqldump, mysqldump — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    characters
    multi-byte, Multi-Byte Character Support
    CHARACTER_LENGTH(), String Functions
    CHARACTER_SETS
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table
    character_sets_dir system variable, Server System Variables
    character_set_client system variable, Server System Variables
    character_set_connection system variable, Server System Variables
    character_set_database system variable, Server System Variables
    character_set_filesystem system variable, Server System Variables
    character_set_results system variable, Server System Variables
    character_set_server system variable, Server System Variables
    character_set_system system variable, Server System Variables
    charset command
    mysql, mysql Commands
    charset option
    comp_err, comp_err — Compile MySQL Error Message File
    CHARSET(), Information Functions
    CHAR_LENGTH(), String Functions
    check option
    myisamchk, myisamchk Check Options
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    check options
    myisamchk, myisamchk Check Options
    CHECK TABLE, CHECK TABLE Syntax
    and partitioning, Maintenance of Partitions
    check-only-changed option
    myisamchk, myisamchk Check Options
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    check-password-file option
    mysqlmanager, MySQL Instance Manager Command Options
    check-upgrade option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    checking
    tables for errors, How to Check MyISAM Tables for Errors
    Checking master version
    thread state, Replication Slave I/O Thread States
    checking permissions
    thread state, General Thread States
    checking privileges on cached query
    thread state, Query Cache Thread States
    checking query cache for query
    thread state, Query Cache Thread States
    Checking table
    thread state, General Thread States
    CHECKPOINT Events (MySQL Cluster), MySQL Cluster Log Events
    checkpoint option
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    Checksum, MySQL Cluster TCP/IP Connections
    Checksum (MySQL Cluster), MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster
    checksum errors, Installing MySQL on Solaris
    CHECKSUM TABLE, CHECKSUM TABLE Syntax
    Chinese, Japanese, Korean character sets
    frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    choosing
    a MySQL version, Choosing Which MySQL Distribution to Install
    choosing types, Choosing the Right Type for a Column
    chroot option
    mysqld, Server Command Options
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    circular replication
    in MySQL Cluster, Known Issues in MySQL Cluster Replication, MySQL Cluster Replication: Multi-Master and Circular Replication, MySQL Cluster Replication Conflict Resolution
    CJK
    FAQ, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    CJK (Chinese, Japanese, Korean)
    Access, PHP, etc., MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    availability of specific characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    available character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    big5, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    character sets available, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    characters displayed as question marks, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    CJKV, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    collations, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    conversion problems with Japanese character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    data truncation, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Database and table names, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    documentation in Chinese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    documentation in Japanese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    documentation in Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    gb2312, gbk, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Japanese character sets, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Korean character set, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    LIKE and FULLTEXT, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    MySQL 4.0 behavior, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    ORDER BY treatment, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    problems with Access, PHP, etc., MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    problems with Big5 character sets (Chinese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    problems with data truncation, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    problems with euckr character set (Korean), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    problems with GB character sets (Chinese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    problems with LIKE and FULLTEXT, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    problems with Yen sign (Japanese), MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    rejected characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    sort order problems, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    sorting problems, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    testing availability of characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Unicode collations, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Vietnamese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Yen sign, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    clean-password-file option
    mysqlmanager, MySQL Instance Manager Command Options
    cleaning up
    thread state, General Thread States
    clear command
    mysql, mysql Commands
    Clearing
    thread state, Event Scheduler Thread States
    clearing
    caches, FLUSH Syntax
    client connection threads, How MySQL Uses Threads for Client Connections
    client programs, Overview of MySQL Programs
    building, Building Client Programs
    client tools, Connectors and APIs
    clients
    debugging, Debugging a MySQL Client
    threaded, How to Make a Threaded Client
    CLOSE, Cursor CLOSE Statement
    Close stmt
    thread command, Thread Command Values
    closing
    tables, How MySQL Opens and Closes Tables
    closing tables
    thread state, General Thread States
    cluster database (OBSOLETE) (see MySQL Cluster replication)
    cluster logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
    cluster.binlog_index table (OBSOLETE) (see MySQL Cluster replication)
    clustered index
    InnoDB, Clustered and Secondary Indexes
    Clustering (see MySQL Cluster)
    CLUSTERLOG commands (MySQL Cluster), MySQL Cluster Logging Management Commands
    CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
    cluster_replication database (OBSOLETE) (see MySQL Cluster replication)
    CMake, Building MySQL from Source Using CMake and Visual Studio
    COALESCE(), Comparison Functions and Operators
    COERCIBILITY(), Information Functions
    ColdFusion, Using Connector/ODBC with ColdFusion
    collating
    strings, String Collating Support
    collation
    adding, How to Add a New Collation to a Character Set
    INFORMATION_SCHEMA, Collation and INFORMATION_SCHEMA Searches
    COLLATION(), Information Functions
    collation-server option
    mysqld, Server Command Options
    COLLATIONS
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table
    COLLATION_CHARACTER_SET_APPLICABILITY
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
    collation_connection system variable, Server System Variables
    collation_database system variable, Server System Variables
    collation_server system variable, Server System Variables
    column
    changing, ALTER TABLE Syntax
    types, Data Types
    column alias
    problems, Problems with Column Aliases
    quoting, Schema Object Names, Problems with Column Aliases
    column comments, CREATE TABLE Syntax
    column format, CREATE TABLE Syntax
    column names
    case sensitivity, Identifier Case Sensitivity
    column storage, CREATE TABLE Syntax
    column-names option
    mysql, mysql Options
    column-type-info option
    mysql, mysql Options
    columns
    displaying, mysqlshow — Display Database, Table, and Column Information
    indexes, Column Indexes
    names, Schema Object Names
    other types, Using Data Types from Other Database Engines
    selecting, Selecting Particular Columns
    storage requirements, Data Type Storage Requirements
    COLUMNS
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table
    columns option
    mysqlimport, mysqlimport — A Data Import Program
    COLUMN_PRIVILEGES
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
    comma-separated values data, reading, LOAD DATA INFILE Syntax, SELECT Syntax
    command options
    mysql, mysql Options
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqld, Server Command Options
    command options (MySQL Cluster)
    mysqld, mysqld Command Options for MySQL Cluster
    ndbd, ndbd — The MySQL Cluster Data Node Daemon
    ndb_mgm, ndb_mgm — The MySQL Cluster Management Client
    ndb_mgmd, ndb_mgmd — The MySQL Cluster Management Server Daemon
    command syntax, Typographical and Syntax Conventions, Conventions Used in This Document
    command-line history
    mysql, mysql Options
    command-line options (MySQL Cluster), Options Common to MySQL Cluster Programs
    command-line tool, mysql — The MySQL Command-Line Tool
    commands
    for binary distribution, Installing MySQL from Generic Binaries on Unix/Linux
    commands out of sync, Commands out of sync
    Comment syntax, Comment Syntax
    comments
    adding, Comment Syntax
    starting, '--' as the Start of a Comment
    comments option
    mysql, mysql Options
    mysqldump, mysqldump — A Database Backup Program
    COMMIT, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax
    XA transactions, XA Transaction SQL Syntax
    commit option
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    mysqlslap, mysqlslap — Load Emulation Client
    Committing events to binlog
    thread state, MySQL Cluster Thread States
    compact option
    mysqldump, mysqldump — A Database Backup Program
    comparison operators, Comparison Functions and Operators
    compatibility
    between MySQL versions, Upgrading from MySQL 5.0 to 5.1
    with mSQL, Regular Expressions
    with ODBC, Server System Variables, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
    with Oracle, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax
    with PostgreSQL, MySQL Extensions to Standard SQL
    with standard SQL, MySQL Standards Compliance
    with Sybase, USE Syntax
    compatible option
    mysqldump, mysqldump — A Database Backup Program
    compiler
    C++ gcc, Typical configure Options
    compiling
    on Windows, Compiling MySQL Clients on Windows
    optimizing, System Factors and Startup Parameter Tuning
    problems, Dealing with Problems Compiling MySQL
    speed, How Compiling and Linking Affects the Speed of MySQL
    statically, Typical configure Options
    user-defined functions, Compiling and Installing User-Defined Functions
    complete-insert option
    mysqldump, mysqldump — A Database Backup Program
    completion_type system variable, Server System Variables
    compliance
    Y2K, Year 2000 Issues and Date Types
    composite partitioning, Subpartitioning
    compound statements, MySQL Compound-Statement Syntax
    compress option
    mysql, mysql Options
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqldump, mysqldump — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    mysqlslap, mysqlslap — Load Emulation Client
    COMPRESS(), Encryption and Compression Functions
    compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables, Compressed Table Characteristics
    CompressedBackup, Defining MySQL Cluster Data Nodes
    CompressedLCP, Defining MySQL Cluster Data Nodes
    comp_err, Overview of MySQL Programs, comp_err — Compile MySQL Error Message File
    charset option, comp_err — Compile MySQL Error Message File
    debug option, comp_err — Compile MySQL Error Message File
    debug-info option, comp_err — Compile MySQL Error Message File
    header_file option, comp_err — Compile MySQL Error Message File
    help option, comp_err — Compile MySQL Error Message File
    in_file option, comp_err — Compile MySQL Error Message File
    name_file option, comp_err — Compile MySQL Error Message File
    out_dir option, comp_err — Compile MySQL Error Message File
    out_file option, comp_err — Compile MySQL Error Message File
    statefile option, comp_err — Compile MySQL Error Message File
    version option, comp_err — Compile MySQL Error Message File
    CONCAT(), String Functions
    concatenation
    string, Strings, String Functions
    CONCAT_WS(), String Functions
    concurrency option
    mysqlslap, mysqlslap — Load Emulation Client
    concurrent inserts, Internal Locking Methods, Concurrent Inserts
    concurrent_insert system variable, Server System Variables
    Conditions, DECLARE for Conditions
    config-file option
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    my_print_defaults, my_print_defaults — Display Options from Option Files
    ndb_config, ndb_config — Extract MySQL Cluster Configuration Information
    config.cache, Dealing with Problems Compiling MySQL
    config.cache file, Dealing with Problems Compiling MySQL
    config.ini (MySQL Cluster), MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files, MySQL Cluster Configuration: Basic Example, ndb_mgmd — The MySQL Cluster Management Server Daemon
    configinfo option
    ndb_config, ndb_config — Extract MySQL Cluster Configuration Information
    configuration
    MySQL Cluster, Overview of MySQL Cluster Configuration Parameters
    configuration files, Causes of Access-Denied Errors
    configuration options, Typical configure Options
    configure
    disable-grant-options option, Typical configure Options
    enable-community-features option, Typical configure Options
    enable-debug-sync option, Typical configure Options
    enable-profiling option, Typical configure Options
    enable-thread-safe-client option, Typical configure Options
    localstatedir option, Typical configure Options
    prefix option, Typical configure Options
    running after prior invocation, Dealing with Problems Compiling MySQL
    with-big-tables option, Typical configure Options
    with-charset option, Typical configure Options
    with-client-ldflags option, Typical configure Options
    with-collation option, Typical configure Options
    with-debug option, Typical configure Options
    with-embedded-server option, Typical configure Options
    with-extra-charsets option, Typical configure Options
    with-tcp-port option, Typical configure Options
    with-unix-socket-path option, Typical configure Options
    with-zlib-dir option, Typical configure Options
    without-server option, Typical configure Options
    configure option
    --with-low-memory, Dealing with Problems Compiling MySQL
    configure script, Typical configure Options
    configuring backups
    in MySQL Cluster, Configuration for MySQL Cluster Backups
    configuring MySQL Cluster, MySQL Cluster Multi-Computer How-To, MySQL Cluster Configuration, MySQL Server Usage for MySQL Cluster, ndb_mgmd — The MySQL Cluster Management Server Daemon
    Configuring MySQL Cluster (concepts), MySQL Cluster Core Concepts
    config_params
    ndbinfo table, The ndbinfo config_params Table
    conflict resolution
    and ndb_replication system table, MySQL Cluster Replication Conflict Resolution
    enabling, MySQL Cluster Replication Conflict Resolution
    in MySQL Cluster Replication, MySQL Cluster Replication Conflict Resolution
    mysqld startup options, MySQL Cluster Replication Conflict Resolution
    Connect
    thread command, Thread Command Values
    connect command
    mysql, mysql Commands
    Connect Out
    thread command, Thread Command Values
    connecting
    remotely with SSH, Connecting to MySQL Remotely from Windows with SSH
    to the server, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
    verification, Access Control, Stage 1: Connection Verification
    Connecting to master
    thread state, Replication Slave I/O Thread States
    connection
    aborted, Communication Errors and Aborted Connections
    CONNECTION Events (MySQL Cluster), MySQL Cluster Log Events
    CONNECTION_ID(), Information Functions
    Connector/C, Connectors and APIs
    Connector/C++, Connectors and APIs
    Connector/JDBC, Connectors and APIs
    Connector/MXJ, Connectors and APIs
    Connector/NET, Connectors and APIs, MySQL Connector/NET
    reporting problems, Connector/NET Support
    Connector/ODBC, Connectors and APIs, MySQL Connector/ODBC
    Borland, Using Connector/ODBC with Borland Applications
    Borland Database Engine, Using Connector/ODBC with Borland Applications
    reporting problems, Connector/ODBC Support
    Connector/OpenOffice.org, Connectors and APIs
    Connectors
    MySQL, Connectors and APIs
    connectstring (see MySQL Cluster)
    connect_timeout system variable, Server System Variables
    connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
    console option
    mysqld, Server Command Options
    const table
    optimizer, Optimizing Queries with EXPLAIN, SELECT Syntax
    constant table, WHERE Clause Optimization
    constraints, How MySQL Deals with Constraints
    CONSTRAINTS
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
    Contains(), Functions That Test Spatial Relationships Between Geometries
    contributing companies
    list of, Supporters of MySQL
    contributors
    list of, Contributors to MySQL
    control flow functions, Control Flow Functions
    CONV(), Mathematical Functions
    conventions
    syntax, Typographical and Syntax Conventions
    typographical, Typographical and Syntax Conventions, Conventions Used in This Document
    CONVERT, Cast Functions and Operators
    CONVERT TO, ALTER TABLE Syntax
    converting HEAP to MyISAM
    thread state, General Thread States
    CONVERT_TZ(), Date and Time Functions
    ConvexHull(), Spatial Operators
    copy option
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    copy to tmp table
    thread state, General Thread States
    copying databases, Copying MySQL Databases to Another Machine
    copying tables, CREATE TABLE Syntax
    Copying to group table
    thread state, General Thread States
    Copying to tmp table
    thread state, General Thread States
    Copying to tmp table on disk
    thread state, General Thread States
    core-file option
    mysqld, Server Command Options
    core-file-size option
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    correct-checksum option
    myisamchk, myisamchk Repair Options
    correlated subqueries, Correlated Subqueries
    COS(), Mathematical Functions
    COT(), Mathematical Functions
    count option
    myisam_ftdump, myisam_ftdump — Display Full-Text Index information
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    COUNT(), GROUP BY (Aggregate) Functions
    COUNT(DISTINCT), GROUP BY (Aggregate) Functions
    counters
    ndbinfo table, The ndbinfo counters Table
    counting
    table rows, Counting Rows
    crash, Debugging a MySQL Server
    recovery, Using myisamchk for Crash Recovery
    repeated, What to Do If MySQL Keeps Crashing
    replication, Replication and Master or Slave Shutdowns
    crash-me, The MySQL Benchmark Suite
    crash-me program, Designing Applications for Portability, The MySQL Benchmark Suite
    CRC32(), Mathematical Functions
    CREATE ... IF NOT EXISTS
    and replication, Replication of CREATE ... IF NOT EXISTS Statements
    CREATE DATABASE, CREATE DATABASE Syntax
    Create DB
    thread command, Thread Command Values
    CREATE EVENT, CREATE EVENT Syntax
    CREATE FUNCTION, CREATE PROCEDURE and CREATE FUNCTION Syntax, CREATE FUNCTION Syntax
    CREATE INDEX, CREATE INDEX Syntax
    CREATE LOGFILE GROUP, CREATE LOGFILE GROUP Syntax
    (see also MySQL Cluster Disk Data)
    CREATE NODEGROUP command (MySQL Cluster), Commands in the MySQL Cluster Management Client
    create option
    mysqlslap, mysqlslap — Load Emulation Client
    CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION Syntax
    CREATE SCHEMA, CREATE DATABASE Syntax
    CREATE SERVER, CREATE SERVER Syntax
    CREATE TABLE, CREATE TABLE Syntax
    DIRECTORY options
    and replication, Replication and DIRECTORY Table Options
    CREATE TABLE ... SELECT
    and replication, Replication of CREATE TABLE ... SELECT Statements
    CREATE TABLESPACE, CREATE TABLESPACE Syntax
    (see also MySQL Cluster Disk Data)
    CREATE TRIGGER, CREATE TRIGGER Syntax
    CREATE USER, CREATE USER Syntax
    CREATE VIEW, CREATE VIEW Syntax
    create-options option
    mysqldump, mysqldump — A Database Backup Program
    create-schema option
    mysqlslap, mysqlslap — Load Emulation Client
    creating
    bug reports, How to Report Bugs or Problems
    database, CREATE DATABASE Syntax
    databases, Creating and Using a Database
    default startup options, Using Option Files
    function, CREATE FUNCTION Syntax
    schema, CREATE DATABASE Syntax
    tables, Creating a Table
    Creating delayed handler
    thread state, Delayed-Insert Thread States
    Creating index
    thread state, General Thread States
    Creating sort index
    thread state, General Thread States
    creating table
    thread state, General Thread States
    Creating table from master dump
    thread state, Replication Slave Connection Thread States
    Creating tmp table
    thread state, General Thread States
    creating user accounts, CREATE USER Syntax
    CROSS JOIN, JOIN Syntax
    Crosses(), Functions That Test Spatial Relationships Between Geometries
    CR_SERVER_GONE_ERROR, MySQL server has gone away
    CR_SERVER_LOST_ERROR, MySQL server has gone away
    CSV data, reading, LOAD DATA INFILE Syntax, SELECT Syntax
    csv option
    mysqlslap, mysqlslap — Load Emulation Client
    CSV storage engine, Storage Engines, The CSV Storage Engine
    CURDATE(), Date and Time Functions
    CURRENT_DATE, Date and Time Functions
    CURRENT_TIME, Date and Time Functions
    CURRENT_TIMESTAMP, Date and Time Functions
    CURRENT_USER(), Information Functions
    Cursors, Cursors
    CURTIME(), Date and Time Functions
    CXX environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
    CXXFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

    D

    [index top]
    Daemon
    thread command, Thread Command Values
    data
    importing, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program
    loading into tables, Loading Data into a Table
    retrieving, Retrieving Information from a Table
    size, Make Your Data as Small as Possible
    DATA DIRECTORY
    and replication, Replication and DIRECTORY Table Options
    data node (MySQL Cluster)
    defined, MySQL Cluster Core Concepts
    data nodes (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    Data truncation with CJK characters, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    data type
    BIGINT, Overview of Numeric Types
    BINARY, Overview of String Types, The BINARY and VARBINARY Types
    BIT, Overview of Numeric Types
    BLOB, Overview of String Types, The BLOB and TEXT Types
    BOOL, Overview of Numeric Types, Using Data Types from Other Database Engines
    BOOLEAN, Overview of Numeric Types, Using Data Types from Other Database Engines
    CHAR, Overview of String Types, String Types
    CHAR VARYING, Overview of String Types
    CHARACTER, Overview of String Types
    CHARACTER VARYING, Overview of String Types
    DATE, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
    DATETIME, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
    DEC, Overview of Numeric Types
    DECIMAL, Overview of Numeric Types, Precision Math
    DOUBLE, Overview of Numeric Types
    DOUBLE PRECISION, Overview of Numeric Types
    ENUM, Overview of String Types, The ENUM Type
    FIXED, Overview of Numeric Types
    FLOAT, Overview of Numeric Types
    GEOMETRY, MySQL Spatial Data Types
    GEOMETRYCOLLECTION, MySQL Spatial Data Types
    INT, Overview of Numeric Types
    INTEGER, Overview of Numeric Types
    LINESTRING, MySQL Spatial Data Types
    LONG, The BLOB and TEXT Types
    LONGBLOB, Overview of String Types
    LONGTEXT, Overview of String Types
    MEDIUMBLOB, Overview of String Types
    MEDIUMINT, Overview of Numeric Types
    MEDIUMTEXT, Overview of String Types
    MULTILINESTRING, MySQL Spatial Data Types
    MULTIPOINT, MySQL Spatial Data Types
    MULTIPOLYGON, MySQL Spatial Data Types
    NATIONAL CHAR, Overview of String Types
    NATIONAL VARCHAR, Overview of String Types
    NCHAR, Overview of String Types
    NUMERIC, Overview of Numeric Types
    NVARCHAR, Overview of String Types
    POINT, MySQL Spatial Data Types
    POLYGON, MySQL Spatial Data Types
    REAL, Overview of Numeric Types
    SET, Overview of String Types, The SET Type
    SMALLINT, Overview of Numeric Types
    TEXT, Overview of String Types, The BLOB and TEXT Types
    TIME, Overview of Date and Time Types, The TIME Type
    TIMESTAMP, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
    TINYBLOB, Overview of String Types
    TINYINT, Overview of Numeric Types
    TINYTEXT, Overview of String Types
    VARBINARY, Overview of String Types, The BINARY and VARBINARY Types
    VARCHAR, Overview of String Types, String Types
    VARCHARACTER, Overview of String Types
    YEAR, Overview of Date and Time Types, The YEAR Type
    data types, Data Types
    C API, MySQL C API
    overview, Data Type Overview
    data-file-length option
    myisamchk, myisamchk Repair Options
    database
    altering, ALTER DATABASE Syntax
    creating, CREATE DATABASE Syntax
    deleting, DROP DATABASE Syntax
    Database information
    obtaining, SHOW Syntax
    database metadata, INFORMATION_SCHEMA Tables
    database names
    case sensitivity, Identifier Case Sensitivity
    case-sensitivity, MySQL Extensions to Standard SQL
    database option
    mysql, mysql Options
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    ndb_show_tables, ndb_show_tables — Display List of NDB Tables
    DATABASE(), Information Functions
    databases
    backups, Backup and Recovery
    copying, Copying MySQL Databases to Another Machine
    creating, Creating and Using a Database
    defined, What is MySQL?
    displaying, mysqlshow — Display Database, Table, and Column Information
    dumping, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
    information about, Getting Information About Databases and Tables
    names, Schema Object Names
    replicating, Replication
    selecting, Creating and Selecting a Database
    symbolic links, Using Symbolic Links for Databases on Unix
    using, Creating and Using a Database
    databases option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqldump, mysqldump — A Database Backup Program
    DataDir, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes
    datadir option
    mysql.server, mysql.server — MySQL Server Startup Script
    mysqld, Server Command Options
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
    mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
    datadir system variable, Server System Variables
    DataJunction, Using Connector/ODBC with Pervasive Software DataJunction
    DataMemory, Defining MySQL Cluster Data Nodes, Configuring MySQL Cluster Parameters for Local Checkpoints
    DATE, Problems Using DATE Columns
    date and time functions, Date and Time Functions
    Date and Time types, Date and Time Types
    date calculations, Date Calculations
    DATE columns
    problems, Problems Using DATE Columns
    DATE data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
    date functions
    Y2K compliance, Year 2000 Issues and Date Types
    date types, Data Type Storage Requirements
    Y2K issues, Year 2000 Issues and Date Types
    date values, Date and Time Values
    problems, The DATETIME, DATE, and TIMESTAMP Types
    DATE(), Date and Time Functions
    DATEDIFF(), Date and Time Functions
    dates
    used with partitioning, Partition Types
    used with partitioning (examples), RANGE Partitioning, HASH Partitioning, Subpartitioning, Partition Pruning
    DATETIME data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
    datetime_format system variable, Server System Variables
    DATE_ADD(), Date and Time Functions
    date_format system variable, Server System Variables
    DATE_FORMAT(), Date and Time Functions
    DATE_SUB(), Date and Time Functions
    DAY(), Date and Time Functions
    DAYNAME(), Date and Time Functions
    DAYOFMONTH(), Date and Time Functions
    DAYOFWEEK(), Date and Time Functions
    DAYOFYEAR(), Date and Time Functions
    db option
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    db table
    sorting, Access Control, Stage 2: Request Verification
    DB2 SQL mode, Server SQL Modes
    DBI interface, MySQL Perl API
    DBI->quote, Strings
    DBI->trace, Debugging mysqld under gdb
    DBI/DBD interface, MySQL Perl API
    DBI_TRACE environment variable, Environment Variables, Debugging mysqld under gdb
    DBI_USER environment variable, Environment Variables
    DBUG package, The DBUG Package
    DEALLOCATE PREPARE, SQL Syntax for Prepared Statements, DEALLOCATE PREPARE Syntax
    Debug
    thread command, Thread Command Values
    debug option
    comp_err, comp_err — Compile MySQL Error Message File
    make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    myisamchk, myisamchk General Options
    myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
    mysql, mysql Options
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqld, Server Command Options
    mysqldump, mysqldump — A Database Backup Program
    mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlmanager, MySQL Instance Manager Command Options
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    mysqlslap, mysqlslap — Load Emulation Client
    my_print_defaults, my_print_defaults — Display Options from Option Files
    debug system variable, Server System Variables
    debug-check option
    mysql, mysql Options
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqldump, mysqldump — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    mysqlslap, mysqlslap — Load Emulation Client
    mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
    debug-info option
    comp_err, comp_err — Compile MySQL Error Message File
    mysql, mysql Options
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqldump, mysqldump — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    mysqlslap, mysqlslap — Load Emulation Client
    mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
    debug-sync-timeout option
    mysqld, Server Command Options
    debugging
    client, Debugging a MySQL Client
    server, Debugging a MySQL Server
    debugging support, Typical configure Options
    debug_sync system variable, Server System Variables
    DEC data type, Overview of Numeric Types
    decimal arithmetic, Precision Math
    DECIMAL data type, Overview of Numeric Types, Precision Math
    decimal point, Data Types
    DECLARE, DECLARE Syntax
    DECODE(), Encryption and Compression Functions
    decode_bits myisamchk variable, myisamchk General Options
    DEFAULT
    constraint, Constraints on Invalid Data
    default
    privileges, Securing the Initial MySQL Accounts
    default host name, Connecting to the MySQL Server
    default installation location, Installation Layouts
    default options, Using Option Files
    DEFAULT value clause, Data Type Default Values, CREATE TABLE Syntax
    default values, MySQL Design Limitations and Tradeoffs, Data Type Default Values, CREATE TABLE Syntax, INSERT Syntax
    BLOB and TEXT columns, The BLOB and TEXT Types
    explicit, Data Type Default Values
    implicit, Data Type Default Values
    suppression, Constraints on Invalid Data
    DEFAULT(), Miscellaneous Functions
    default-character-set option
    mysql, mysql Options
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqld, Server Command Options
    mysqldump, mysqldump — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    default-collation option
    mysqld, Server Command Options
    default-mysqld-path option
    mysqlmanager, MySQL Instance Manager Command Options
    default-storage-engine option
    mysqld, Server Command Options
    default-table-type option
    mysqld, Server Command Options
    default-time-zone option
    mysqld, Server Command Options
    defaults
    embedded, Options with the Embedded Server
    defaults-extra-file option, Command-Line Options that Affect Option-File Handling
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    my_print_defaults, my_print_defaults — Display Options from Option Files
    defaults-file option, Command-Line Options that Affect Option-File Handling
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    mysqlmanager, MySQL Instance Manager Command Options
    my_print_defaults, my_print_defaults — Display Options from Option Files
    defaults-group-suffix option, Command-Line Options that Affect Option-File Handling
    my_print_defaults, my_print_defaults — Display Options from Option Files
    default_week_format system variable, Server System Variables
    DEGREES(), Mathematical Functions
    delay-key-write option
    mysqld, Server Command Options, MyISAM Startup Options
    DELAYED, INSERT DELAYED Syntax
    when ignored, INSERT Syntax
    Delayed insert
    thread command, Thread Command Values
    delayed inserts
    thread states, Delayed-Insert Thread States
    delayed-insert option
    mysqldump, mysqldump — A Database Backup Program
    delayed_insert_limit, INSERT DELAYED Syntax
    delayed_insert_limit system variable, Server System Variables
    delayed_insert_timeout system variable, Server System Variables
    delayed_queue_size system variable, Server System Variables
    delay_key_write system variable, Server System Variables
    DELETE, DELETE Syntax
    and MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits
    delete option
    mysqlimport, mysqlimport — A Data Import Program
    delete-master-logs option
    mysqldump, mysqldump — A Database Backup Program
    deleting
    database, DROP DATABASE Syntax
    foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints
    function, DROP FUNCTION Syntax
    index, ALTER TABLE Syntax, DROP INDEX Syntax
    primary key, ALTER TABLE Syntax
    rows, Deleting Rows from Related Tables
    schema, DROP DATABASE Syntax
    table, DROP TABLE Syntax
    user, Removing User Accounts, DROP USER Syntax
    users, Removing User Accounts, DROP USER Syntax
    deleting from main table
    thread state, General Thread States
    deleting from reference tables
    thread state, General Thread States
    deletion
    mysql.sock, How to Protect or Change the MySQL Unix Socket File
    delimiter command
    mysql, mysql Commands
    delimiter option
    mysql, mysql Options
    mysqlslap, mysqlslap — Load Emulation Client
    ndb_select_all, ndb_select_all — Print Rows from an NDB Table
    Delphi, Using Connector/ODBC with Delphi
    derived tables, Subqueries in the FROM Clause
    des-key-file option
    mysqld, Server Command Options
    DESC, DESCRIBE Syntax
    descending option
    ndb_select_all, ndb_select_all — Print Rows from an NDB Table
    DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax
    description option
    myisamchk, Other myisamchk Options
    design
    issues, Known Issues in MySQL
    limitations, MySQL Design Limitations and Tradeoffs
    DES_DECRYPT(), Encryption and Compression Functions
    DES_ENCRYPT(), Encryption and Compression Functions
    detach option
    mysqlslap, mysqlslap — Load Emulation Client
    development of MySQL Cluster, MySQL Cluster Development History
    development source tree, Installing from the Development Source Tree
    Difference(), Spatial Operators
    digits, Data Types
    Dimension(), General Geometry Functions
    directory structure
    default, Installation Layouts
    disable named command
    mysql, mysql Options
    disable-grant-options option
    configure, Typical configure Options
    disable-keys option
    mysqldump, mysqldump — A Database Backup Program
    disable-log-bin option
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    DISCARD TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
    discard_or_import_tablespace
    thread state, General Thread States
    disconnect-slave-event-count option
    mysqld, Replication Slave Options and Variables
    disconnecting
    from the server, Connecting to and Disconnecting from the Server
    Disjoint(), Functions That Test Spatial Relationships Between Geometries
    Disk Data tables (MySQL Cluster) (see MySQL Cluster Disk Data)
    disk full, How MySQL Handles a Full Disk
    disk issues, Disk Issues
    disk option
    ndb_select_all, ndb_select_all — Print Rows from an NDB Table
    DiskCheckpointSpeed, Defining MySQL Cluster Data Nodes
    DiskCheckpointSpeedInRestart, Defining MySQL Cluster Data Nodes
    DiskIOThreadPool, Defining MySQL Cluster Data Nodes
    Diskless, Defining MySQL Cluster Data Nodes
    DiskPageBufferMemory, Defining MySQL Cluster Data Nodes
    disks
    splitting data across, Using Symbolic Links for Databases on Windows
    DiskSyncSize, Defining MySQL Cluster Data Nodes
    display size, Data Types
    display triggers, SHOW TRIGGERS Syntax
    display width, Data Types
    displaying
    database information, mysqlshow — Display Database, Table, and Column Information
    information
    Cardinality, SHOW INDEX Syntax
    Collation, SHOW INDEX Syntax
    SHOW, SHOW Syntax, SHOW COLUMNS Syntax, SHOW INDEX Syntax, SHOW OPEN TABLES Syntax, SHOW TABLES Syntax
    table status, SHOW TABLE STATUS Syntax
    Distance(), Functions That Test Spatial Relationships Between Geometries
    DISTINCT, Selecting Particular Columns, DISTINCT Optimization, SELECT Syntax
    AVG(), GROUP BY (Aggregate) Functions
    COUNT(), GROUP BY (Aggregate) Functions
    MAX(), GROUP BY (Aggregate) Functions
    MIN(), GROUP BY (Aggregate) Functions
    SUM(), GROUP BY (Aggregate) Functions
    DISTINCTROW, SELECT Syntax
    DIV, Arithmetic Operators
    division (/), Arithmetic Operators
    div_precision_increment system variable, Server System Variables
    DNS, How MySQL Uses DNS
    DO, DO Syntax
    DocBook XML
    documentation source format, About This Manual
    Documentation
    in Chinese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    in Japanese, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    in Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Documenters
    list of, Documenters and translators
    DOUBLE data type, Overview of Numeric Types
    DOUBLE PRECISION data type, Overview of Numeric Types
    double quote (\"), Strings
    downgrades
    MySQL Cluster, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of a MySQL Cluster, MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility
    downgrading, Upgrading or Downgrading MySQL, Downgrading MySQL
    downloading, How to Get MySQL
    drbd
    FAQ, MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat, Distributed Replicated Block Device (DRBD)
    DRBD license, Distributed Replicated Block Device (DRBD)
    DROP ... IF EXISTS
    and replication, Replication of DROP ... IF EXISTS Statements
    DROP DATABASE, DROP DATABASE Syntax
    Drop DB
    thread command, Thread Command Values
    DROP EVENT, DROP EVENT Syntax
    DROP FOREIGN KEY, ALTER TABLE Syntax, FOREIGN KEY Constraints
    DROP FUNCTION, DROP PROCEDURE and DROP FUNCTION Syntax, DROP FUNCTION Syntax
    DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax
    DROP LOGFILE GROUP, DROP LOGFILE GROUP Syntax
    (see also MySQL Cluster Disk Data)
    DROP NODEGROUP command (MySQL Cluster), Commands in the MySQL Cluster Management Client
    DROP PREPARE, DEALLOCATE PREPARE Syntax
    DROP PRIMARY KEY, ALTER TABLE Syntax
    DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax
    DROP SCHEMA, DROP DATABASE Syntax
    DROP SERVER, DROP SERVER Syntax
    DROP TABLE, DROP TABLE Syntax
    and MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits
    DROP TABLESPACE, DROP TABLESPACE Syntax
    (see also MySQL Cluster Disk Data)
    DROP TRIGGER, DROP TRIGGER Syntax
    DROP USER, DROP USER Syntax
    DROP VIEW, DROP VIEW Syntax
    drop-user option
    mysqlmanager, MySQL Instance Manager Command Options
    dropping
    user, Removing User Accounts, DROP USER Syntax
    dryrun option
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    DUAL, SELECT Syntax
    dump option
    myisam_ftdump, myisam_ftdump — Display Full-Text Index information
    dump-date option
    mysqldump, mysqldump — A Database Backup Program
    DUMPFILE, SELECT Syntax
    dumping
    databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
    dynamic table characteristics, Dynamic Table Characteristics

    E

    [index top]
    edit command
    mysql, mysql Commands
    edit-user option
    mysqlmanager, MySQL Instance Manager Command Options
    ego command
    mysql, mysql Commands
    Eiffel Wrapper, MySQL Eiffel Wrapper
    ELT(), String Functions
    email lists, MySQL Mailing Lists
    embedded MySQL server library, libmysqld, the Embedded MySQL Server Library
    embedded option
    make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    mysql_config, mysql_config — Get Compile Options for Compiling Clients
    enable-community-features option
    configure, Typical configure Options
    enable-debug-sync option
    configure, Typical configure Options
    enable-named-pipe option
    mysqld, Server Command Options
    enable-profiling option
    configure, Typical configure Options
    enable-pstack option
    mysqld, Server Command Options
    enable-thread-safe-client option
    configure, Typical configure Options
    ENCODE(), Encryption and Compression Functions
    ENCRYPT(), Encryption and Compression Functions
    encryption, Basic SSL Concepts
    encryption functions, Encryption and Compression Functions
    end
    thread state, General Thread States
    END, BEGIN ... END Compound Statement Syntax
    EndPoint(), LineString Functions
    engine option
    mysqlslap, mysqlslap — Load Emulation Client
    ENGINES
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ENGINES Table
    engine_condition_pushdown system variable, Server System Variables
    ENTER SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client
    entering
    queries, Entering Queries
    ENUM
    size, Data Type Storage Requirements
    ENUM data type, Overview of String Types, The ENUM Type
    Envelope(), General Geometry Functions
    environment variable
    CC, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
    CFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
    CXX, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
    CXXFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
    DBI_TRACE, Environment Variables, Debugging mysqld under gdb
    DBI_USER, Environment Variables
    HOME, Environment Variables, mysql Options
    LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface
    LD_RUN_PATH, Solaris Notes, Environment Variables, Problems Using the Perl DBI/DBD Interface
    MYSQL_DEBUG, Environment Variables, Overview of MySQL Programs, Debugging a MySQL Client
    MYSQL_GROUP_SUFFIX, Environment Variables
    MYSQL_HISTFILE, Environment Variables, mysql Options
    MYSQL_HOME, Environment Variables
    MYSQL_HOST, Environment Variables, Connecting to the MySQL Server
    MYSQL_PS1, Environment Variables
    MYSQL_PWD, Environment Variables, Overview of MySQL Programs, Connecting to the MySQL Server
    MYSQL_TCP_PORT, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
    MYSQL_UNIX_PORT, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
    PATH, Installing MySQL from Generic Binaries on Unix/Linux, Environment Variables, Invoking MySQL Programs
    TMPDIR, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Where MySQL Stores Temporary Files
    TZ, Environment Variables, Time Zone Problems
    UMASK, Environment Variables, Problems with File Permissions
    UMASK_DIR, Environment Variables, Problems with File Permissions
    USER, Environment Variables, Connecting to the MySQL Server
    environment variables, Overview of MySQL Programs, Setting Environment Variables, Causes of Access-Denied Errors
    CXX, Dealing with Problems Compiling MySQL
    list of, Environment Variables
    equal (=), Comparison Functions and Operators
    Equals(), Functions That Test Spatial Relationships Between Geometries
    eq_ref join type
    optimizer, Optimizing Queries with EXPLAIN
    Errcode, perror — Explain Error Codes
    errno, perror — Explain Error Codes
    Error
    thread command, Thread Command Values
    ERROR Events (MySQL Cluster), MySQL Cluster Log Events
    error logs (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon
    error messages
    can't find file, Problems with File Permissions
    displaying, perror — Explain Error Codes
    languages, Setting the Error Message Language
    errors
    access denied, Access denied
    and replication, Slave Errors During Replication
    checking tables for, How to Check MyISAM Tables for Errors
    common, Problems and Common Errors
    directory checksum, Installing MySQL on Solaris
    handling for UDFs, UDF Return Values and Error Handling
    in subqueries, Subquery Errors
    known, Known Issues in MySQL
    linking, Problems Linking to the MySQL Client Library
    list of, Common Errors When Using MySQL Programs
    lost connection, Lost connection to MySQL server
    reporting, General Information, How to Report Bugs or Problems
    sources of information, Sources of Error Information
    error_count session variable, Server System Variables
    ERROR_FOR_DIVISION_BY_ZERO SQL mode, Server SQL Modes
    escape (\\), Strings
    escape sequences
    option files, Using Option Files
    strings, Strings
    estimating
    query performance, Estimating Query Performance
    event
    restrictions, Restrictions on Stored Routines, Triggers, and Events
    event groups, SET GLOBAL sql_slave_skip_counter Syntax
    event log format (MySQL Cluster), MySQL Cluster Log Events
    event logs (MySQL Cluster), Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
    event scheduler, Stored Programs and Views
    thread states, Event Scheduler Thread States
    Event Scheduler, Using the Event Scheduler
    altering events, ALTER EVENT Syntax
    and MySQL privileges, The Event Scheduler and MySQL Privileges
    and mysqladmin debug, Event Scheduler Status
    and replication, Replication of Invoked Features
    and SHOW PROCESSLIST, Event Scheduler Configuration
    concepts, Event Scheduler Overview
    creating events, CREATE EVENT Syntax
    dropping events, DROP EVENT Syntax
    enabling and disabling, Event Scheduler Configuration
    event metadata, Event Metadata
    obtaining status information, SHOW SCHEDULER STATUS Syntax, Event Scheduler Status
    SQL statements, Event Syntax
    starting and stopping, Event Scheduler Configuration
    time representation, Event Metadata
    event severity levels (MySQL Cluster), MySQL Cluster Logging Management Commands
    event types (MySQL Cluster), Event Reports Generated in MySQL Cluster, MySQL Cluster Log Events
    event-scheduler option
    mysqld, Server Command Options
    events, Stored Programs and Views, Using the Event Scheduler
    altering, ALTER EVENT Syntax
    creating, CREATE EVENT Syntax
    dropping, DROP EVENT Syntax
    metadata, Event Metadata
    status variables, The Event Scheduler and MySQL Privileges
    EVENTS
    INFORMATION_SCHEMA table, The Event Scheduler and MySQL Privileges, The INFORMATION_SCHEMA EVENTS Table
    events option
    mysqldump, mysqldump — A Database Backup Program
    event_scheduler system variable, Server System Variables
    exact-value literals, Precision Math
    example option
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    EXAMPLE storage engine, Storage Engines, The EXAMPLE Storage Engine
    examples
    compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables
    myisamchk output, myisamchk Table Information
    queries, Examples of Common Queries
    exe-suffix option
    make_win_bin_dist, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    Execute
    thread command, Thread Command Values
    EXECUTE, SQL Syntax for Prepared Statements, EXECUTE Syntax
    execute option
    mysql, mysql Options
    ExecuteOnComputer, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster
    executing
    thread state, General Thread States
    executing SQL statements from text files, Using mysql in Batch Mode, Executing SQL Statements from a Text File
    Execution of init_command
    thread state, General Thread States
    execution threads (MySQL Cluster), ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    EXISTS
    with subqueries, Subqueries with EXISTS or NOT EXISTS
    exit command
    mysql, mysql Commands
    EXIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client
    EXIT SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client
    exit-info option
    mysqld, Server Command Options
    EXP(), Mathematical Functions
    expire_logs_days system variable, Server System Variables
    EXPLAIN, Optimizing Queries with EXPLAIN, EXPLAIN Syntax
    EXPLAIN PARTITIONS, Obtaining Information About Partitions
    EXPLAIN used with partitioned tables, Obtaining Information About Partitions
    explicit default values, Data Type Default Values
    EXPORT_SET(), String Functions
    expression aliases, GROUP BY and HAVING with Hidden Columns, SELECT Syntax
    expressions
    extended, Pattern Matching
    extend-check option
    myisamchk, myisamchk Check Options, myisamchk Repair Options
    extended option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    extended-insert option
    mysqldump, mysqldump — A Database Backup Program
    extensions
    to standard SQL, MySQL Standards Compliance
    ExteriorRing(), Polygon Functions
    external locking, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
    external-locking option
    mysqld, Server Command Options
    extra-file option
    my_print_defaults, my_print_defaults — Display Options from Option Files
    extra-node-info option
    ndb_desc, ndb_desc — Describe NDB Tables
    extra-partition-info option
    ndb_desc, ndb_desc — Describe NDB Tables
    EXTRACT(), Date and Time Functions
    extracting
    dates, Date Calculations
    ExtractValue(), XML Functions

    F

    [index top]
    failover
    in MySQL Cluster replication, Implementing Failover with MySQL Cluster Replication
    Java clients, MySQL Cluster Core Concepts
    FALSE, Numbers, Boolean Values
    testing for, Comparison Functions and Operators
    fast option
    myisamchk, myisamchk Check Options
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    fatal signal 11, Dealing with Problems Compiling MySQL
    features of MySQL, The Main Features of MySQL
    FEDERATED storage engine, Storage Engines, The FEDERATED Storage Engine
    Fetch
    thread command, Thread Command Values
    FETCH, Cursor FETCH Statement
    field
    changing, ALTER TABLE Syntax
    Field List
    thread command, Thread Command Values
    FIELD(), String Functions
    fields option
    ndb_config, ndb_config — Extract MySQL Cluster Configuration Information
    fields-enclosed-by option
    mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    fields-escaped-by option
    mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    fields-optionally-enclosed-by option
    mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    fields-terminated-by option
    mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    FILE, String Functions
    files
    binary log, The Binary Log
    config.cache, Dealing with Problems Compiling MySQL
    error messages, Setting the Error Message Language
    general query log, The General Query Log
    log, Typical configure Options, Server Log Maintenance
    my.cnf, Replication Features and Issues
    not found message, Problems with File Permissions
    permissions, Problems with File Permissions
    repairing, myisamchk Repair Options
    script, Using mysql in Batch Mode
    size limits, The table is full
    slow query log, The Slow Query Log
    text, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program
    tmp, Problems Running mysql_install_db
    FILES
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA FILES Table
    (see also MySQL Cluster Disk Data)
    filesort optimization, ORDER BY Optimization
    FileSystemPath, Defining MySQL Cluster Data Nodes
    FileSystemPathDataFiles, Defining MySQL Cluster Data Nodes
    FileSystemPathDD, Defining MySQL Cluster Data Nodes
    FileSystemPathUndoFiles, Defining MySQL Cluster Data Nodes
    FIND_IN_SET(), String Functions
    Finished reading one binlog; switching to next binlog
    thread state, Replication Master Thread States
    firewalls (software)
    and MySQL Cluster, MySQL Cluster Security and Networking Issues
    first-slave option
    mysqldump, mysqldump — A Database Backup Program
    fix-db-names option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    fix-table-names option
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    FIXED data type, Overview of Numeric Types
    fixed-point arithmetic, Precision Math
    FLOAT data type, Overview of Numeric Types
    floating-point number, Overview of Numeric Types
    floating-point values
    and replication, Replication and Floating-Point Values
    floats, Numbers
    FLOOR(), Mathematical Functions
    FLUSH, FLUSH Syntax
    and replication, Replication and FLUSH
    flush option
    mysqld, Server Command Options
    flush system variable, Server System Variables
    flush tables, mysqladmin — Client for Administering a MySQL Server
    flush-logs option
    mysqldump, mysqldump — A Database Backup Program
    flush-privileges option
    mysqldump, mysqldump — A Database Backup Program
    Flushing tables
    thread state, General Thread States
    flushlog option
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    flush_time system variable, Server System Variables
    FOR UPDATE, SELECT Syntax
    FORCE INDEX, Index Hint Syntax, Optimizer-Related Issues
    FORCE KEY, Index Hint Syntax
    force option
    myisamchk, myisamchk Check Options, myisamchk Repair Options
    myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
    mysql, mysql Options
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqldump, mysqldump — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
    mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
    mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
    force-read option
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    foreign key
    constraint, PRIMARY KEY and UNIQUE Index Constraints
    deleting, ALTER TABLE Syntax, FOREIGN KEY Constraints
    foreign keys, Foreign Keys, Using Foreign Keys, ALTER TABLE Syntax
    foreign_key_checks session variable, Server System Variables
    FORMAT(), String Functions
    Forums, MySQL Community Support at the MySQL Forums
    FOUND_ROWS(), Information Functions
    FragmentLogFileSize, Defining MySQL Cluster Data Nodes
    FreeBSD troubleshooting, Dealing with Problems Compiling MySQL
    freeing items
    thread state, General Thread States
    frequently-asked questions about DRBD, MySQL 5.1 FAQ: MySQL, DRBD, and Heartbeat, Distributed Replicated Block Device (DRBD)
    frequently-asked questions about MySQL Cluster, MySQL 5.1 FAQ: MySQL Cluster
    FROM, SELECT Syntax
    FROM_DAYS(), Date and Time Functions
    FROM_UNIXTIME(), Date and Time Functions
    ft_boolean_syntax system variable, Server System Variables
    ft_max_word_len myisamchk variable, myisamchk General Options
    ft_max_word_len system variable, Server System Variables
    ft_min_word_len myisamchk variable, myisamchk General Options
    ft_min_word_len system variable, Server System Variables
    ft_query_expansion_limit system variable, Server System Variables
    ft_stopword_file myisamchk variable, myisamchk General Options
    ft_stopword_file system variable, Server System Variables
    full disk, How MySQL Handles a Full Disk
    full-text search, Full-Text Search Functions
    FULLTEXT, Full-Text Search Functions
    fulltext
    stopword list, Fine-Tuning MySQL Full-Text Search
    FULLTEXT initialization
    thread state, General Thread States
    fulltext join type
    optimizer, Optimizing Queries with EXPLAIN
    function
    creating, CREATE FUNCTION Syntax
    deleting, DROP FUNCTION Syntax
    function names
    parsing, Function Name Parsing and Resolution
    resolving ambiguity, Function Name Parsing and Resolution
    functions, Functions and Operators
    and replication, Replication and System Functions
    arithmetic, Bit Functions
    bit, Bit Functions
    C API, C API Function Overview
    C prepared statement API, C API Prepared Statement Type Conversions, C API Prepared Statement Function Overview
    cast, Cast Functions and Operators
    control flow, Control Flow Functions
    date and time, Date and Time Functions
    encryption, Encryption and Compression Functions
    GROUP BY, GROUP BY (Aggregate) Functions
    grouping, Operator Precedence
    information, Information Functions
    mathematical, Mathematical Functions
    miscellaneous, Miscellaneous Functions
    native
    adding, Adding a New Native Function
    new, Adding New Functions to MySQL
    stored, Using Stored Routines (Procedures and Functions)
    string, String Functions
    string comparison, String Comparison Functions
    user-defined, Adding New Functions to MySQL
    adding, Adding a New User-Defined Function
    Functions
    user-defined, CREATE FUNCTION Syntax, DROP FUNCTION Syntax
    functions for SELECT and WHERE clauses, Functions and Operators

    G

    [index top]
    gap event, Known Issues in MySQL Cluster Replication
    gap lock
    InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
    gb2312, gbk, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    gcc, Typical configure Options
    gci option
    ndb_select_all, ndb_select_all — Print Rows from an NDB Table
    GCP Stop errors (MySQL Cluster), Defining MySQL Cluster Data Nodes
    gdb
    using, Debugging mysqld under gdb
    gdb option
    mysqld, Server Command Options
    general information, General Information
    General Public License, What is MySQL?
    general query log, The General Query Log
    general-log option
    mysqld, Server Command Options
    general_log system variable, Server System Variables
    general_log_file system variable, Server System Variables
    geographic feature, Introduction to MySQL Spatial Support
    GeomCollFromText(), Creating Geometry Values Using WKT Functions
    GeomCollFromWKB(), Creating Geometry Values Using WKB Functions
    geometry, Introduction to MySQL Spatial Support
    GEOMETRY data type, MySQL Spatial Data Types
    GEOMETRYCOLLECTION data type, MySQL Spatial Data Types
    GeometryCollection(), Creating Geometry Values Using MySQL-Specific Functions
    GeometryCollectionFromText(), Creating Geometry Values Using WKT Functions
    GeometryCollectionFromWKB(), Creating Geometry Values Using WKB Functions
    GeometryFromText(), Creating Geometry Values Using WKT Functions
    GeometryFromWKB(), Creating Geometry Values Using WKB Functions
    GeometryN(), GeometryCollection Functions
    GeometryType(), General Geometry Functions
    GeomFromText(), Creating Geometry Values Using WKT Functions, Geometry Format Conversion Functions
    GeomFromWKB(), Creating Geometry Values Using WKB Functions, Geometry Format Conversion Functions
    geospatial feature, Introduction to MySQL Spatial Support
    getting MySQL, How to Get MySQL
    GET_FORMAT(), Date and Time Functions
    GET_LOCK(), Miscellaneous Functions
    GIS, Spatial Extensions, Introduction to MySQL Spatial Support
    GLength(), LineString Functions, MultiLineString Functions
    global privileges, GRANT Syntax, REVOKE Syntax
    GLOBAL_STATUS
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
    GLOBAL_VARIABLES
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
    go command
    mysql, mysql Commands
    goals of MySQL, What is MySQL?
    got handler lock
    thread state, Delayed-Insert Thread States
    got old table
    thread state, Delayed-Insert Thread States
    GRANT, GRANT Syntax
    GRANT statement, Adding User Accounts
    grant tables
    re-creating, Problems Running mysql_install_db
    sorting, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
    structure, Privilege System Grant Tables
    upgrading, mysql_fix_privilege_tables — Upgrade MySQL System Tables
    granting
    privileges, GRANT Syntax
    GRANTS, SHOW GRANTS Syntax
    greater than (>), Comparison Functions and Operators
    greater than or equal (>=), Comparison Functions and Operators
    greatest timestamp wins (conflict resolution), MySQL Cluster Replication Conflict Resolution
    greatest timestamp, delete wins (conflict resolution), MySQL Cluster Replication Conflict Resolution
    GREATEST(), Comparison Functions and Operators
    GROUP BY, GROUP BY Optimization
    aliases in, GROUP BY and HAVING with Hidden Columns
    extensions to standard SQL, GROUP BY and HAVING with Hidden Columns, SELECT Syntax
    GROUP BY functions, GROUP BY (Aggregate) Functions
    grouping
    expressions, Operator Precedence
    GROUP_CONCAT(), GROUP BY (Aggregate) Functions
    group_concat_max_len system variable, Server System Variables

    H

    [index top]
    HANDLER, HANDLER Syntax
    Handlers, DECLARE for Handlers
    handling
    errors, UDF Return Values and Error Handling
    Has read all relay log; waiting for the slave I/O thread to update it
    thread state, Replication Slave SQL Thread States
    Has sent all binlog to slave; waiting for binlog to be updated
    thread state, Replication Master Thread States
    hash partitioning, HASH Partitioning
    hash partitions
    managing, Management of HASH and KEY Partitions
    splitting and merging, Management of HASH and KEY Partitions
    have_archive system variable, Server System Variables
    have_blackhole_engine system variable, Server System Variables
    have_community_features system variable, Server System Variables
    have_compress system variable, Server System Variables
    have_crypt system variable, Server System Variables
    have_csv system variable, Server System Variables
    have_dynamic_loading system variable, Server System Variables
    have_example_engine system variable, Server System Variables
    have_federated_engine system variable, Server System Variables
    have_geometry system variable, Server System Variables
    have_innodb system variable, Server System Variables
    have_isam system variable, Server System Variables
    have_merge_engine system variable, Server System Variables
    have_openssl system variable, Server System Variables
    have_partitioning system variable, Server System Variables
    have_query_cache system variable, Server System Variables
    have_raid system variable, Server System Variables
    have_row_based_replication system variable, Server System Variables
    have_rtree_keys system variable, Server System Variables
    have_ssl system variable, Server System Variables
    have_symlink system variable, Server System Variables
    HAVING, SELECT Syntax
    header option
    ndb_select_all, ndb_select_all — Print Rows from an NDB Table
    header_file option
    comp_err, comp_err — Compile MySQL Error Message File
    HEAP storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine
    HeartbeatIntervalDbApi, Defining MySQL Cluster Data Nodes
    HeartbeatIntervalDbDb, Defining MySQL Cluster Data Nodes
    HeartbeatThreadPriority, Defining a MySQL Cluster Management Server, Defining SQL and Other API Nodes in a MySQL Cluster
    help command
    mysql, mysql Commands
    HELP command (MySQL Cluster), Commands in the MySQL Cluster Management Client
    help option
    comp_err, comp_err — Compile MySQL Error Message File
    myisamchk, myisamchk General Options
    myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
    myisam_ftdump, myisam_ftdump — Display Full-Text Index information
    mysql, mysql Options
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqld, Server Command Options
    mysqldump, mysqldump — A Database Backup Program
    mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlmanager, MySQL Instance Manager Command Options
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    mysqlslap, mysqlslap — Load Emulation Client
    mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
    mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
    mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
    mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
    mysql_waitpid, mysql_waitpid — Kill Process and Wait for Its Termination
    my_print_defaults, my_print_defaults — Display Options from Option Files
    perror, perror — Explain Error Codes
    resolveip, resolveip — Resolve Host name to IP Address or Vice Versa
    resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
    HELP option
    myisamchk, myisamchk General Options
    HELP statement, HELP Syntax
    HEX(), String Functions, Mathematical Functions
    hex-blob option
    mysqldump, mysqldump — A Database Backup Program
    hexadecimal values, Hexadecimal Values
    hexdump option
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    HIGH_NOT_PRECEDENCE SQL mode, Server SQL Modes
    HIGH_PRIORITY, SELECT Syntax
    hints, MySQL Extensions to Standard SQL
    index, SELECT Syntax, Index Hint Syntax
    history of MySQL, History of MySQL
    HOME environment variable, Environment Variables, mysql Options
    host name
    default, Connecting to the MySQL Server
    host name caching, How MySQL Uses DNS
    host name resolution, How MySQL Uses DNS
    host option, Connecting to the MySQL Server
    mysql, mysql Options
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    mysqladmin, mysqladmin — Client for Administering a MySQL Server
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    mysqldump, mysqldump — A Database Backup Program
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    mysqlslap, mysqlslap — Load Emulation Client
    mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
    mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
    ndb_config, ndb_config — Extract MySQL Cluster Configuration Information
    host table, Access Control, Stage 2: Request Verification
    sorting, Access Control, Stage 2: Request Verification
    Host*SciId* parameters, SCI Transport Connections in MySQL Cluster
    host.frm
    problems finding, Unix Post-Installation Procedures
    HostName, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster
    HostName (MySQL Cluster), MySQL Cluster Security and Networking Issues
    hostname system variable, Server System Variables
    HOUR(), Date and Time Functions
    howto option
    mysqlaccess, mysqlaccess — Client for Checking Access Privileges
    html option
    mysql, mysql Options

    I

    [index top]
    i-am-a-dummy option
    mysql, mysql Options
    i5/OS, Installing MySQL on i5/OS
    IBM i5/OS, Installing MySQL on i5/OS
    IBMDB2I storage engine, Storage Engines
    icc
    and MySQL Cluster support>, Debugging and Porting MySQL
    MySQL builds, Compiler-Specific Build Characteristics
    Id, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster
    ID
    unique, How to Get the Unique ID for the Last Inserted Row
    id option
    ndb_config, ndb_config — Extract MySQL Cluster Configuration Information
    identifiers, Schema Object Names
    case sensitivity, Identifier Case Sensitivity
    quoting, Schema Object Names
    identity session variable, Server System Variables
    IF, IF Statement
    IF(), Control Flow Functions
    IFNULL(), Control Flow Functions
    IGNORE
    with partitioned tables, INSERT Syntax
    IGNORE INDEX, Index Hint Syntax
    IGNORE KEY, Index Hint Syntax
    ignore option
    mysqlimport, mysqlimport — A Data Import Program
    ignore-builtin-innodb option
    mysqld, InnoDB Startup Options and System Variables
    ignore-lines option
    mysqlimport, mysqlimport — A Data Import Program
    ignore-spaces option
    mysql, mysql Options
    ignore-table option
    mysqldump, mysqldump — A Database Backup Program
    IGNORE_SPACE SQL mode, Server SQL Modes
    implicit default values, Data Type Default Values
    IMPORT TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
    importing
    data, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program
    IN, Comparison Functions and Operators, Subqueries with ANY, IN, or SOME
    include option
    mysql_config, mysql_config — Get Compile Options for Compiling Clients
    increasing
    performance, Replication FAQ
    increasing with replication
    speed, Replication
    incremental recovery, Point-in-Time (Incremental) Recovery Using the Binary Log
    using MySQL Cluster replication, Point-In-Time Recovery Using MySQL Cluster Replication
    index
    deleting, ALTER TABLE Syntax, DROP INDEX Syntax
    rebuilding, Rebuilding or Repairing Tables or Indexes
    INDEX DIRECTORY
    and replication, Replication and DIRECTORY Table Options
    index hints, SELECT Syntax, Index Hint Syntax
    index join type
    optimizer, Optimizing Queries with EXPLAIN
    index-record lock
    InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
    indexes, CREATE INDEX Syntax
    and BLOB columns, Column Indexes, CREATE TABLE Syntax
    and IS NULL, How MySQL Uses Indexes
    and LIKE, How MySQL Uses Indexes
    and NULL values, CREATE TABLE Syntax
    and TEXT columns, Column Indexes, CREATE TABLE Syntax
    assigning to key cache, CACHE INDEX Syntax
    block size, Server System Variables
    columns, Column Indexes
    leftmost prefix of, How MySQL Uses Indexes
    multi-column, Multiple-Column Indexes
    multiple-part, CREATE INDEX Syntax
    names, Schema Object Names
    use of, How MySQL Uses Indexes
    IndexMemory, Defining MySQL Cluster Data Nodes, Configuring MySQL Cluster Parameters for Local Checkpoints
    index_merge join type
    optimizer, Optimizing Queries with EXPLAIN
    index_subquery join type
    optimizer, Optimizing Queries with EXPLAIN
    INET_ATON(), Miscellaneous Functions
    INET_NTOA(), Miscellaneous Functions
    INFO Events (MySQL Cluster), MySQL Cluster Log Events
    information functions, Information Functions
    information option
    myisamchk, myisamchk Check Options
    INFORMATION_SCHEMA, INFORMATION_SCHEMA Tables
    and security issues, MySQL Cluster and MySQL Privileges
    collation and searching, Collation and INFORMATION_SCHEMA Searches
    INFORMATION_SCHEMA.ENGINES table
    used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
    INFORMATION_SCHEMA.GLOBAL_STATUS table
    used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
    INFORMATION_SCHEMA.GLOBAL_VARIABLES table
    used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements
    init
    thread state, General Thread States
    Init DB
    thread command, Thread Command Values
    init-file option
    mysqld, Server Command Options
    InitFragmentLogFiles, Defining MySQL Cluster Data Nodes
    Initialized
    thread state, Event Scheduler Thread States
    InitialLogFileGroup, Defining MySQL Cluster Data Nodes
    InitialNoOfOpenFiles, Defining MySQL Cluster Data Nodes
    InitialTablespace, Defining MySQL Cluster Data Nodes
    init_connect system variable, Server System Variables
    init_file system variable, Server System Variables
    init_slave system variable, Replication Slave Options and Variables
    INNER JOIN, JOIN Syntax
    innochecksum, Overview of MySQL Programs, innochecksum — Offline InnoDB File Checksum Utility
    InnoDB, The InnoDB Storage Engine
    backups, Backing Up and Recovering an InnoDB Database
    clustered index, Clustered and Secondary Indexes
    gap lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
    index-record lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
    Monitors, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, InnoDB General Troubleshooting, Troubleshooting InnoDB Data Dictionary Operations
    next-key lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
    NFS, InnoDB Configuration, Restrictions on InnoDB Tables
    page size, Physical Structure of an Index, Restrictions on InnoDB Tables
    record-level locks, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
    secondary index, Clustered and Secondary Indexes
    semi-consistent read, InnoDB Startup Options and System Variables
    Solaris 10 x86_64 issues, Installing MySQL on Solaris
    transaction isolation levels, The InnoDB Transaction Model and Locking
    InnoDB buffer pool, The InnoDB Buffer Pool
    innodb option
    mysqld, InnoDB Startup Options and System Variables
    InnoDB storage engine, Storage Engines, The InnoDB Storage Engine
    InnoDB tables, Transactions and Atomic Operations
    innodb-status-file option
    mysqld, InnoDB Startup Options and System Variables
    INSERT, Speed of INSERT Statements, INSERT Syntax
    insert
    thread state, Delayed-Insert Thread States
    INSERT ... SELECT, INSERT ... SELECT Syntax
    INSERT DELAYED, INSERT DELAYED Syntax
    INSERT statement
    grant privileges, Adding User Accounts
    INSERT(), String Functions
    insert-ignore option
    mysqldump, mysqldump — A Database Backup Program
    insertable views
    insertable, Updatable and Insertable Views
    inserting
    speed of, Speed of INSERT Statements
    inserts
    concurrent, Internal Locking Methods, Concurrent Inserts
    insert_id session variable, Server System Variables
    install option
    mysqlmanager, MySQL Instance Manager Command Options
    INSTALL PLUGIN, INSTALL PLUGIN Syntax
    installation layouts, Installation Layouts
    installation overview, MySQL Installation Using a Source Distribution
    installing
    binary distribution, Installing MySQL from Generic Binaries on Unix/Linux
    Linux RPM packages, Installing MySQL from RPM Packages on Linux
    Mac OS X PKG packages, Installing MySQL on Mac OS X
    overview, Installing and Upgrading MySQL
    Perl, Perl Installation Notes
    Perl on Windows, Installing ActiveState Perl on Windows
    Solaris PKG packages, Installing MySQL on Solaris
    source distribution, MySQL Installation Using a Source Distribution
    user-defined functions, Compiling and Installing User-Defined Functions
    installing MySQL Cluster, MySQL Cluster Multi-Computer How-To, MySQL Cluster Multi-Computer Installation
    installing plugins, Installing and Uninstalling Plugins, INSTALL PLUGIN Syntax
    INSTR(), String Functions
    INT data type, Overview of Numeric Types
    integer arithmetic, Precision Math
    INTEGER data type, Overview of Numeric Types
    integers, Numbers
    interactive_timeout system variable, Server System Variables
    InteriorRingN(), Polygon Functions
    internal compiler errors, Dealing with Problems Compiling MySQL
    internal locking, Internal Locking Methods
    internals, MySQL Internals
    internationalization, Internationalization and Localization
    Internet Relay Chat, MySQL Community Support on Internet Relay Chat (IRC)
    Intersection(), Spatial Operators
    Intersects(), Functions That Test Spatial Relationships Between Geometries
    INTERVAL(), Comparison Functions and Operators
    introducer
    string literal, Strings, Character String Literal Character Set and Collation
    invalid data
    constraint, Constraints on Invalid Data
    invalidating query cache entries
    thread state, Query Cache Thread States
    in_file option
    comp_err, comp_err — Compile MySQL Error Message File
    IRC, MySQL Community Support on Internet Relay Chat (IRC)
    IS boolean_value, Comparison Functions and Operators
    IS NOT boolean_value, Comparison Functions and Operators
    IS NOT NULL, Comparison Functions and Operators
    IS NULL, IS NULL Optimization, Comparison Functions and Operators
    and indexes, How MySQL Uses Indexes
    isamlog, Overview of MySQL Programs, myisamlog — Display MyISAM Log File Contents
    IsClosed(), MultiLineString Functions
    IsEmpty(), General Geometry Functions
    ISNULL(), Comparison Functions and Operators
    ISOLATION LEVEL, SET TRANSACTION Syntax
    IsRing(), LineString Functions
    IsSimple(), General Geometry Functions
    IS_FREE_LOCK(), Miscellaneous Functions
    IS_USED_LOCK(), Miscellaneous Functions
    ITERATE, ITERATE Statement
    iterations option
    mysqlslap, mysqlslap — Load Emulation Client

    J

    [index top]
    Japanese character sets
    conversion, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Japanese, Korean, Chinese character sets
    frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    jdbc:mysql:loadbalance://, MySQL Cluster Core Concepts
    join
    nested-loop algorithm, Nested Join Optimization
    JOIN, JOIN Syntax
    join algorithm
    Block Nested-Loop, Nested-Loop Join Algorithms
    Nested-Loop, Nested-Loop Join Algorithms
    join option
    myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
    join type
    ALL, Optimizing Queries with EXPLAIN
    const, Optimizing Queries with EXPLAIN
    eq_ref, Optimizing Queries with EXPLAIN
    fulltext, Optimizing Queries with EXPLAIN
    index, Optimizing Queries with EXPLAIN
    index_merge, Optimizing Queries with EXPLAIN
    index_subquery, Optimizing Queries with EXPLAIN
    range, Optimizing Queries with EXPLAIN
    ref, Optimizing Queries with EXPLAIN
    ref_or_null, Optimizing Queries with EXPLAIN
    system, Optimizing Queries with EXPLAIN
    unique_subquery, Optimizing Queries with EXPLAIN
    join_buffer_size system variable, Server System Variables

    K

    [index top]
    keepold option
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    keep_files_on_create system variable, Server System Variables
    Key cache
    MyISAM, The MyISAM Key Cache
    key cache
    assigning indexes to, CACHE INDEX Syntax
    key partitioning, KEY Partitioning
    key partitions
    managing, Management of HASH and KEY Partitions
    splitting and merging, Management of HASH and KEY Partitions
    key space
    MyISAM, Space Needed for Keys
    keys, Column Indexes
    foreign, Foreign Keys, Using Foreign Keys
    multi-column, Multiple-Column Indexes
    searching on two, Searching on Two Keys
    keys option
    mysqlshow, mysqlshow — Display Database, Table, and Column Information
    keys-used option
    myisamchk, myisamchk Repair Options
    keywords, Reserved Words
    key_buffer_size myisamchk variable, myisamchk General Options
    key_buffer_size system variable, Server System Variables
    key_cache_age_threshold system variable, Server System Variables
    key_cache_block_size system variable, Server System Variables
    key_cache_division_limit system variable, Server System Variables
    KEY_COLUMN_USAGE
    INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
    Kill
    thread command, Thread Command Values
    KILL, KILL Syntax
    Killed
    thread state, General Thread States
    Killing slave
    thread state, Replication Slave Connection Thread States
    known errors, Known Issues in MySQL
    Korean, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
    Korean, Chinese, Japanese character sets
    frequently asked questions, MySQL 5.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets

    L

    [index top]
    language option
    mysqld, Server Command Options
    language support
    error messages, Setting the Error Message Language
    language system variable, Server System Variables
    large page support, Enabling Large Page Support
    large-pages option
    mysqld, Server Command Options
    large_files_support system variable, Server System Variables
    large_pages system variable, Server System Variables
    large_page_size system variable, Server System Variables
    last row
    unique ID, How to Get the Unique ID for the Last Inserted Row
    LAST_DAY(), Date and Time Functions
    last_insert_id session variable, Server System Variables
    LAST_INSERT_ID(), Transactions and Atomic Operations, INSERT Syntax
    and replication, Replication and AUTO_INCREMENT
    LAST_INSERT_ID() and stored routines, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
    LAST_INSERT_ID() and triggers, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
    LAST_INSERT_ID([<replaceable>expr</replaceable>]), Information Functions
    layout of installation, Installation Layouts
    LCASE(), String Functions
    lc_time_names system variable, Server System Variables
    ldata option
    mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
    LD_LIBRARY_PATH environment variable, Problems Using the Perl DBI/DBD Interface
    LD_RUN_PATH environment variable, Solaris Notes, Environment Variables, Problems Using the Perl DBI/DBD Interface
    LEAST(), Comparison Functions and Operators
    LEAVE, LEAVE Statement
    ledir option
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization, JOIN Syntax
    LEFT OUTER JOIN, JOIN Syntax
    LEFT(), String Functions
    leftmost prefix of indexes, How MySQL Uses Indexes
    legal names, Schema Object Names
    length option
    myisam_ftdump, myisam_ftdump — Display Full-Text Index information
    LENGTH(), String Functions
    less than (<), Comparison Functions and Operators
    less than or equal (<=), Comparison Functions and Operators
    libmysqld, libmysqld, the Embedded MySQL Server Library
    options, Options with the Embedded Server
    libmysqld-libs option
    mysql_config, mysql_config — Get Compile Options for Compiling Clients
    library
    mysqlclient, Connectors and APIs
    mysqld, Connectors and APIs
    libs option
    mysql_config, mysql_config — Get Compile Options for Compiling Clients
    libs_r option
    mysql_config, mysql_config — Get Compile Options for Compiling Clients
    license system variable, Server System Variables
    LIKE, String Comparison Functions
    and indexes, How MySQL Uses Indexes
    and wildcards, How MySQL Uses Indexes
    LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax
    and replication, Replication and LIMIT
    limitations
    design, MySQL Design Limitations and Tradeoffs
    MySQL Limitations, Limits in MySQL
    replication, Replication Features and Issues
    limitations of MySQL Cluster, Known Limitations of MySQL Cluster
    limits
    file-size, The table is full
    MySQL Limits, limits in MySQL, Limits in MySQL
    line-numbers option
    mysql, mysql Options
    linear hash partitioning, LINEAR HASH Partitioning
    linear key partitioning, KEY Partitioning
    linefeed (\n), Strings, LOAD DATA INFILE Syntax
    LineFromText(), Creating Geometry Values Using WKT Functions
    LineFromWKB(), Creating Geometry Values Using WKB Functions
    lines-terminated-by option
    mysqldump, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    LINESTRING data type, MySQL Spatial Data Types
    LineString(), Creating Geometry Values Using MySQL-Specific Functions
    LineStringFromText(), Creating Geometry Values Using WKT Functions
    LineStringFromWKB(), Creating Geometry Values Using WKB Functions
    linking, Building Client Programs
    errors, Problems Linking to the MySQL Client Library
    problems, Problems Linking with the C API
    speed, How Compiling and Linking Affects the Speed of MySQL
    links
    symbolic, Using Symbolic Links
    list partitioning, LIST Partitioning
    list partitions
    adding and dropping, Management of RANGE and LIST Partitions
    managing, Management of RANGE and LIST Partitions
    list-users option
    mysqlmanager, MySQL Instance Manager Command Options
    literals, Literal Values
    LN(), Mathematical Functions
    LOAD DATA
    and replication, Replication and LOAD DATA INFILE
    LOAD DATA FROM MASTER, LOAD DATA FROM MASTER Syntax
    LOAD DATA INFILE, LOAD DATA INFILE Syntax, Problems with NULL Values
    load emulation, mysqlslap — Load Emulation Client
    LOAD INDEX INTO CACHE
    and partitioning, Restrictions and Limitations on Partitioning
    LOAD TABLE FROM MASTER, LOAD TABLE tbl_name FROM MASTER Syntax
    loading
    tables, Loading Data into a Table
    LOAD_FILE(), String Functions
    local checkpoints (MySQL Cluster), Configuring MySQL Cluster Parameters for Local Checkpoints
    local option
    mysqlimport, mysqlimport — A Data Import Program
    local-infile option
    mysql, mysql Options
    mysqld, Security-Related mysqld Options
    local-load option
    mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
    localization, Internationalization and Localization
    localstatedir option
    configure, Typical configure Options
    LOCALTIME, Date and Time Functions
    LOCALTIMESTAMP, Date and Time Functions
    local_infile system variable, Server System Variables
    LOCATE(), String Functions
    LOCK IN SHARE MODE, SELECT Syntax
    Lock Monitor
    InnoDB, SHOW ENGINE INNODB STATUS and the InnoDB Monitors
    lock option
    ndb_select_all, ndb_select_all — Print Rows from an NDB Table
    LOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax
    lock-all-tables option
    mysqldump, mysqldump — A Database Backup Program
    lock-directory option
    mysqlslap, mysqlslap — Load Emulation Client
    lock-tables option
    mysqldump, mysqldump — A Database Backup Program
    mysqlimport, mysqlimport — A Data Import Program
    Locked
    thread state, General Thread States
    locked_in_memory system variable, Server System Variables
    LockExecuteThreadToCPU, Defining MySQL Cluster Data Nodes
    locking, System Factors and Startup Parameter Tuning
    external, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
    internal, Internal Locking Methods
    row-level, Transactions and Atomic Operations, Internal Locking Methods
    table-level, Internal Locking Methods
    locking methods, Internal Locking Methods
    LockMaintThreadsToCPU, Defining MySQL Cluster Data Nodes
    LockPagesInMainMemory, Defining MySQL Cluster Data Nodes
    log
    changes, MySQL Change History
    log files, Typical configure Options
    maintaining, Server Log Maintenance
    log files (MySQL Cluster), ndbd — The MySQL Cluster Data Node Daemon
    ndbmtd, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    log option
    mysqld, Server Command Options
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    mysqlmanager, MySQL Instance Manager Command Options
    log system variable, Server System Variables
    LOG(), Mathematical Functions
    log-bin option
    mysqld, Binary Log Options and Variables
    log-bin-index option
    mysqld, Binary Log Options and Variables
    log-bin-trust-function-creators option
    mysqld, Binary Log Options and Variables
    log-error option
    mysqld, Server Command Options
    mysqldump, mysqldump — A Database Backup Program
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    log-isam option
    mysqld, Server Command Options
    log-long-format option
    mysqld, Server Command Options
    log-output option
    mysqld, Server Command Options
    log-queries-not-using-indexes option
    mysqld, Server Command Options
    log-short-format option
    mysqld, Server Command Options
    log-slave-updates option
    mysqld, Replication Slave Options and Variables
    log-slow-admin-statements option
    mysqld, Server Command Options
    log-slow-queries option
    mysqld, Server Command Options
    log-slow-slave-statements option
    mysqld, Replication Slave Options and Variables
    log-tc option
    mysqld, Server Command Options
    log-tc-size option
    mysqld, Server Command Options
    log-warnings option
    mysqld, Server Command Options, Replication Slave Options and Variables
    LOG10(), Mathematical Functions
    LOG2(), Mathematical Functions
    logbuffers
    ndbinfo table, The ndbinfo logbuffers Table
    LogDestination, Defining a MySQL Cluster Management Server
    logging commands (MySQL Cluster), MySQL Cluster Logging Management Commands
    logging slow query
    thread state, General Thread States
    logical operators, Logical Operators
    login
    thread state, General Thread States
    LogLevelCheckpoint, Defining MySQL Cluster Data Nodes
    LogLevelCongestion, Defining MySQL Cluster Data Nodes
    LogLevelConnection, Defining MySQL Cluster Data Nodes
    LogLevelError, Defining MySQL Cluster Data Nodes
    LogLevelInfo, Defining MySQL Cluster Data Nodes
    LogLevelNodeRestart, Defining MySQL Cluster Data Nodes
    LogLevelShutdown, Defining MySQL Cluster Data Nodes
    LogLevelStartup, Defining MySQL Cluster Data Nodes
    LogLevelStatistic, Defining MySQL Cluster Data Nodes
    logs
    flushing, MySQL Server Logs
    server, MySQL Server Logs
    logspaces
    ndbinfo table, The ndbinfo logspaces Table
    log_bin system variable, Server System Variables
    log_bin_trust_function_creators system variable, Server System Variables
    log_error system variable, Server System Variables
    log_output system variable, Server System Variables
    log_queries_not_using_indexes system variable, Server System Variables
    log_slave_updates system variable, Server System Variables
    log_slow_queries system variable, Server System Variables
    log_warnings system variable, Server System Variables
    Long Data
    thread command, Thread Command Values
    LONG data type, The BLOB and TEXT Types
    LONGBLOB data type, Overview of String Types
    LongMessageBuffer, Defining MySQL Cluster Data Nodes
    LONGTEXT data type, Overview of String Types
    long_query_time system variable, Server System Variables
    LOOP, LOOP Statement
    loops option
    ndb_show_tables, ndb_show_tables — Display List of NDB Tables
    lost connection errors, Lost connection to MySQL server
    low-priority option
    mysqlimport, mysqlimport — A Data Import Program
    low-priority-updates option
    mysqld, Server Command Options
    LOWER(), String Functions
    lower_case_file_system system variable, Server System Variables
    lower_case_table_names system variable, Server System Variables
    low_priority_updates system variable, Server System Variables
    LPAD(), String Functions
    LTRIM(), String Functions

    M

    [index top]
    Mac OS X, MySQL Connector/ODBC
    installation, Installing MySQL on Mac OS X
    mailing list address, General Information
    mailing lists, MySQL Mailing Lists
    archive location, MySQL Mailing Lists
    guidelines, Guidelines for Using the Mailing Lists
    main features of MySQL, The Main Features of MySQL
    maintaining
    log files, Server Log Maintenance
    tables, Setting Up a MyISAM Table Maintenance Schedule
    maintenance
    tables, mysqlcheck — A Table Maintenance Program
    MAKEDATE(), Date and Time Functions
    MAKETIME(), Date and Time Functions
    make_binary_distribution, Overview of MySQL Programs
    MAKE_SET(), String Functions
    make_win_bin_dist, Overview of MySQL Programs, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    exe-suffix option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    no-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    no-embedded option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    only-debug option, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
    Making temp file
    thread state, Replication Slave SQL Thread States
    malicious SQL statements
    and MySQL Cluster, MySQL Cluster and MySQL Privileges
    manage keys
    thread state, General Thread States
    management client (MySQL Cluster), ndb_mgm — The MySQL Cluster Management Client
    (see also mgm)
    management node (MySQL Cluster)
    defined, MySQL Cluster Core Concepts
    management nodes (MySQL Cluster), ndb_mgmd — The MySQL Cluster Management Server Daemon
    (see also mgmd)
    managing MySQL Cluster, Management of MySQL Cluster
    managing MySQL Cluster processes, MySQL Cluster Programs
    manual
    available formats, About This Manual
    online location, About This Manual
    syntax conventions, Typographical and Syntax Conventions
    typographical conventions, Typographical and Syntax Conventions
    master-connect-retry option
    mysqld, Replication Slave Options and Variables
    master-data option
    mysqldump, mysqldump — A Database Backup Program
    master-host option
    mysqld, Replication Slave Options and Variables
    master-info-file option
    mysqld, Replication Slave Options and Variables
    master-password option
    mysqld, Replication Slave Options and Variables
    master-port option
    mysqld, Replication Slave Options and Variables
    master-retry-count option
    mysqld, Replication Slave Options and Variables
    master-ssl option
    mysqld, Replication Slave Options and Variables
    master-ssl-ca option
    mysqld, Replication Slave Options and Variables
    master-ssl-capath option
    mysqld, Replication Slave Options and Variables
    master-ssl-cert option
    mysqld, Replication Slave Options and Variables
    master-ssl-cipher option
    mysqld, Replication Slave Options and Variables
    master-ssl-key option
    mysqld, Replication Slave Options and Variables
    master-user option
    mysqld, Replication Slave Options and Variables
    MASTER_POS_WAIT(), Miscellaneous Functions, MASTER_POS_WAIT() Syntax
    MATCH ... AGAINST(), Full-Text Search Functions
    matching
    patterns, Pattern Matching
    math, Precision Math
    mathematical functions, Mathematical Functions
    MAX(), GROUP BY (Aggregate) Functions
    MAX(DISTINCT), GROUP BY (Aggregate) Functions
    max-binlog-dump-events option
    mysqld, Binary Log Options and Variables
    max-record-length option
    myisamchk, myisamchk Repair Options
    max-relay-log-size option
    mysqld, Replication Slave Options and Variables
    MaxBufferedEpochs, Defining MySQL Cluster Data Nodes
    MAXDB SQL mode, Server SQL Modes
    maximum memory used, mysqladmin — Client for Administering a MySQL Server
    maximums
    maximum columns per table, The Maximum Number of Columns Per Table
    maximum tables per join, Limits of Joins
    MaxLCPStartDelay, Defining MySQL Cluster Data Nodes
    MaxNoOfAttributes, Defining MySQL Cluster Data Nodes
    MaxNoOfConcurrentIndexOperations, Defining MySQL Cluster Data Nodes
    MaxNoOfConcurrentOperations, Defining MySQL Cluster Data Nodes
    MaxNoOfConcurrentScans, Defining MySQL Cluster Data Nodes
    MaxNoOfConcurrentSubOperations, Defining MySQL Cluster Data Nodes
    MaxNoOfConcurrentTransactions, Defining MySQL Cluster Data Nodes
    MaxNoOfExecutionThreads
    ndbmtd, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    MaxNoOfFiredTriggers, Defining MySQL Cluster Data Nodes
    MaxNoOfIndexes, Defining MySQL Cluster Data Nodes
    MaxNoOfLocalOperations, Defining MySQL Cluster Data Nodes
    MaxNoOfLocalScans, Defining MySQL Cluster Data Nodes
    MaxNoOfOpenFiles, Defining MySQL Cluster Data Nodes
    MaxNoOfOrderedIndexes, Defining MySQL Cluster Data Nodes
    MaxNoOfSavedMessages, Defining MySQL Cluster Data Nodes
    MaxNoOfSubscribers, Defining MySQL Cluster Data Nodes
    MaxNoOfSubscriptions, Defining MySQL Cluster Data Nodes
    MaxNoOfTables, Defining MySQL Cluster Data Nodes
    MaxNoOfTriggers, Defining MySQL Cluster Data Nodes
    MaxNoOfUniqueHashIndexes, Defining MySQL Cluster Data Nodes
    MaxScanBatchSize, Defining SQL and Other API Nodes in a MySQL Cluster
    max_allowed_packet
    and replication, Replication and max_allowed_packet
    max_allowed_packet system variable, Server System Variables
    max_allowed_packet variable, mysql Options
    max_binlog_cache_size system variable, Binary Log Options and Variables
    max_binlog_size system variable, Binary Log Options and Variables
    max_connections system variable, Server System Variables
    MAX_CONNECTIONS_PER_HOUR, Setting Account Resource Limits
    max_connect_errors system variable, Server System Variables
    max_delayed_threads system variable, Server System Variables
    max_error_count system variable, Server System Variables
    max_heap_table_size system variable, Server System Variables
    max_insert_delayed_threads system variable, Server System Variables
    max_join_size system variable, Server System Variables
    max_join_size variable, mysql Options
    max_length_for_sort_data system variable, Server System Variables
    max_prepared_stmt_count system variable, Server System Variables
    MAX_QUERIES_PER_HOUR, Setting Account Resource Limits
    max_relay_log_size system variable, Server System Variables
    max_seeks_for_key system variable, Server System Variables
    max_sort_length system variable, Server System Variables
    max_sp_recursion_depth system variable, Server System Variables
    max_tmp_tables system variable, Server System Variables
    MAX_UPDATES_PER_HOUR, Setting Account Resource Limits
    MAX_USER_CONNECTIONS, Setting Account Resource Limits
    max_user_connections system variable, Server System Variables
    max_write_lock_count system variable, Server System Variables
    MBR, Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MBRContains(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MBRDisjoint(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MBREqual(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MBRIntersects(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MBROverlaps(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MBRTouches(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MBRWithin(), Relations on Geometry Minimal Bounding Rectangles (MBRs)
    MD5(), Encryption and Compression Functions
    medium-check option
    myisamchk, myisamchk Check Options
    mysqlcheck, mysqlcheck — A Table Maintenance Program
    MEDIUMBLOB data type, Overview of String Types
    MEDIUMINT data type, Overview of Numeric Types
    MEDIUMTEXT data type, Overview of String Types
    memlock option
    mysqld, Server Command Options
    MEMORY storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine
    and replication, Replication and MEMORY Tables
    memory usage
    myisamchk, myisamchk Memory Usage
    memory use, mysqladmin — Client for Administering a MySQL Server, How MySQL Uses Memory
    in MySQL Cluster, Limits and Differences of MySQL Cluster from Standard MySQL Limits
    memoryusage
    ndbinfo table, The ndbinfo memoryusage Table
    MemReportFrequency, Defining MySQL Cluster Data Nodes
    MERGE storage engine, Storage Engines, The MERGE Storage Engine
    MERGE tables
    defined, The MERGE Storage Engine
    metadata
    database, INFORMATION_SCHEMA Tables
    stored routines, Stored Routine Metadata
    triggers, Trigger Metadata
    views, View Metadata
    method option
    mysqlhotcopy, mysqlhotcopy — A Database Backup Program
    methods
    locking, Internal Locking Methods
    mgmd (MySQL Cluster)
    defined, MySQL Cluster Core Concepts
    (see also management node (MySQL Cluster))
    MICROSECOND(), Date and Time Functions
    Microsoft Access, Microsoft Access
    Microsoft ADO, Microsoft ADO
    Microsoft Excel, Microsoft Excel and Column Types
    Microsoft Visual Basic, Microsoft Visual Basic
    Microsoft Visual InterDev, Microsoft Visual InterDev
    MID(), String Functions
    MIN(), GROUP BY (Aggregate) Functions
    MIN(DISTINCT), GROUP BY (Aggregate) Functions
    min-examined-row-limit option
    mysqld, Server Command Options
    Minimum Bounding Rectangle, Relations on Geometry Minimal Bounding Rectangles (MBRs)
    minus
    unary (-), Arithmetic Operators
    MINUTE(), Date and Time Functions
    min_examined_row_limit system variable, Server System Variables
    mirror sites, How to Get MySQL
    miscellaneous functions, Miscellaneous Functions
    MIT-pthreads, MIT-pthreads Notes
    MLineFromText(), Creating Geometry Values Using WKT Functions
    MLineFromWKB(), Creating Geometry Values Using WKB Functions
    MOD (modulo), Mathematical Functions
    MOD(), Mathematical Functions
    modes
    batch, Using mysql in Batch Mode
    modulo (%), Mathematical Functions
    modulo (MOD), Mathematical Functions
    monitor
    terminal, Tutorial
    monitoring-interval option
    mysqlmanager, MySQL Instance Manager Command Options
    Monitors
    InnoDB, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, InnoDB General Troubleshooting, Troubleshooting InnoDB Data Dictionary Operations
    Mono, MySQL Connector/NET
    MONTH(), Date and Time Functions
    MONTHNAME(), Date and Time Functions
    MPointFromText(), Creating Geometry Values Using WKT Functions
    MPointFromWKB(), Creating Geometry Values Using WKB Functions
    MPolyFromText(), Creating Geometry Values Using WKT Functions
    MPolyFromWKB(), Creating Geometry Values Using WKB Functions
    mSQL compatibility, Regular Expressions
    msql2mysql, msql2mysql — Convert mSQL Programs for Use with MySQL
    MSSQL SQL mode, Server SQL Modes
    multi mysqld, mysqld_multi — Manage Multiple MySQL Servers
    multi-byte character sets, Can't initialize character set
    and MySQL Cluster (replication), Known Issues in MySQL Cluster Replication
    multi-byte characters, Multi-Byte Character Support
    multi-column indexes, Multiple-Column Indexes
    multi-master replication
    in MySQL Cluster, MySQL Cluster Replication: Multi-Master and Circular Replication, MySQL Cluster Replication Conflict Resolution
    MULTILINESTRING data type, MySQL Spatial Data Types
    MultiLineString(), Creating Geometry Values Using MySQL-Specific Functions
    MultiLineStringFromText(), Creating Geometry Values Using WKT Functions
    MultiLineStringFromWKB(), Creating Geometry Values Using WKB Functions
    multiple servers, Running Multiple MySQL Servers on the Same Machine
    multiple-part index, CREATE INDEX Syntax
    multiplication (*), Arithmetic Operators
    MULTIPOINT data type, MySQL Spatial Data Types
    MultiPoint(), Creating Geometry Values Using MySQL-Specific Functions
    MultiPointFromText(), Creating Geometry Values Using WKT Functions
    MultiPointFromWKB(), Creating Geometry Values Using WKB Functions
    MULTIPOLYGON data type, MySQL Spatial Data Types
    MultiPolygon(), Creating Geometry Values Using MySQL-Specific Functions
    MultiPolygonFromText(), Creating Geometry Values Using WKT Functions
    MultiPolygonFromWKB(), Creating Geometry Values Using WKB Functions
    My
    derivation, History of MySQL
    my.cnf
    and MySQL Cluster, MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files, MySQL Cluster Configuration: Basic Example
    in MySQL Cluster, MySQL Server Usage for MySQL Cluster
    my.cnf file, Replication Features and Issues
    MyISAM
    compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables, Compressed Table Characteristics
    MyISAM key cache, The MyISAM Key Cache
    MyISAM storage engine, Storage Engines, The MyISAM Storage Engine
    myisam-block-size option
    mysqld, Server Command Options
    myisam-recover option
    mysqld, Server Command Options, MyISAM Startup Options
    myisamchk, Overview of MySQL Programs, myisamchk — MyISAM Table-Maintenance Utility
    analyze option, Other myisamchk Options
    backup option, myisamchk Repair Options
    block-search option, Other myisamchk Options
    character-sets-dir option, myisamchk Repair Options
    check option, myisamchk Check Options
    check-only-changed option, myisamchk Check Options
    correct-checksum option, myisamchk Repair Options
    data-file-length option, myisamchk Repair Options
    debug option, myisamchk General Options
    description option, Other myisamchk Options
    example output, myisamchk Table Information
    extend-check option, myisamchk Check Options, myisamchk Repair Options
    fast option, myisamchk Check Options
    force option, myisamchk Check Options, myisamchk Repair Options
    help option, myisamchk General Options
    HELP option, myisamchk General Options
    information option, myisamchk Check Options
    keys-used option, myisamchk Repair Options
    max-record-length option, myisamchk Repair Options
    medium-check option, myisamchk Check Options
    no-symlinks option, myisamchk Repair Options
    options, myisamchk General Options
    parallel-recover option, myisamchk Repair Options
    quick option, myisamchk Repair Options
    read-only option, myisamchk Check Options
    recover option, myisamchk Repair Options
    safe-recover option, myisamchk Repair Options
    set-auto-increment[ option, Other myisamchk Options
    set-character-set option, myisamchk Repair Options
    set-collation option, myisamchk Repair Options
    silent option, myisamchk General Options
    sort-index option, Other myisamchk Options
    sort-records option, Other myisamchk Options
    sort-recover option, myisamchk Repair Options
    tmpdir option, myisamchk Repair Options
    unpack option, myisamchk Repair Options
    update-state option, myisamchk Check Options
    verbose option, myisamchk General Options
    version option, myisamchk General Options
    wait option, myisamchk General Options
    myisamlog, Overview of MySQL Programs, myisamlog — Display MyISAM Log File Contents
    myisampack, Overview of MySQL Programs, myisampack — Generate Compressed, Read-Only MyISAM Tables, Silent Column Specification Changes, Compressed Table Characteristics
    backup option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    character-sets-dir option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    debug option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    force option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    help option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    join option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    silent option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    test option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    tmpdir option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    verbose option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    version option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    wait option, myisampack — Generate Compressed, Read-Only MyISAM Tables
    myisam_block_size myisamchk variable, myisamchk General Options
    myisam_data_pointer_size system variable, Server System Variables
    myisam_ftdump, Overview of MySQL Programs, myisam_ftdump — Display Full-Text Index information
    count option, myisam_ftdump — Display Full-Text Index information
    dump option, myisam_ftdump — Display Full-Text Index information
    help option, myisam_ftdump — Display Full-Text Index information
    length option, myisam_ftdump — Display Full-Text Index information
    stats option, myisam_ftdump — Display Full-Text Index information
    verbose option, myisam_ftdump — Display Full-Text Index information
    myisam_max_sort_file_size system variable, Server System Variables
    myisam_mmap_size system variable, Server System Variables
    myisam_recover_options system variable, Server System Variables
    myisam_repair_threads system variable, Server System Variables
    myisam_sort_buffer_size system variable, Server System Variables
    myisam_stats_method system variable, Server System Variables
    myisam_use_mmap system variable, Server System Variables
    MyODBC, MySQL Connector/ODBC
    MySQL
    defined, What is MySQL?
    introduction, What is MySQL?
    pronunciation, What is MySQL?
    upgrading, mysql_upgrade — Check Tables for MySQL Upgrade
    mysql, Overview of MySQL Programs, mysql — The MySQL Command-Line Tool
    auto-rehash option, mysql Options
    batch option, mysql Options
    character-sets-dir option, mysql Options
    charset command, mysql Commands
    clear command, mysql Commands
    column-names option, mysql Options
    column-type-info option, mysql Options
    comments option, mysql Options
    compress option, mysql Options
    connect command, mysql Commands
    database option, mysql Options
    debug option, mysql Options
    debug-check option, mysql Options
    debug-info option, mysql Options
    default-character-set option, mysql Options
    delimiter command, mysql Commands
    delimiter option, mysql Options
    disable named commands, mysql Options
    edit command, mysql Commands
    ego command, mysql Commands
    execute option, mysql Options
    exit command, mysql Commands
    force option, mysql Options
    go command, mysql Commands
    help command, mysql Commands
    help option, mysql Options
    host option, mysql Options
    html option, mysql Options
    i-am-a-dummy option, mysql Options
    ignore-spaces option, mysql Options
    line-numbers option, mysql Options
    local-infile option, mysql Options
    named-commands option, mysql Options
    no-auto-rehash option, mysql Options
    no-beep option, mysql Options
    no-named-commands option, mysql Options
    no-pager option, mysql Options
    no-tee option, mysql Options
    nopager command, mysql Commands
    notee command, mysql Commands
    nowarning command, mysql Commands
    one-database option, mysql Options
    pager command, mysql Commands
    pager option, mysql Options
    password option, mysql Options
    pipe option, mysql Options
    port option, mysql Options
    print command, mysql Commands
    prompt command, mysql Commands
    prompt option, mysql Options
    protocol option, mysql Options
    quick option, mysql Options
    quit command, mysql Commands
    raw option, mysql Options
    reconnect option, mysql Options
    rehash command, mysql Commands
    safe-updates option, mysql Options
    secure-auth option, mysql Options
    show-warnings option, mysql Options
    sigint-ignore option, mysql Options
    silent option, mysql Options
    skip-column-names option, mysql Options
    skip-line-numbers option, mysql Options
    socket option, mysql Options
    source command, mysql Commands
    SSL options, mysql Options
    status command, mysql Commands
    system command, mysql Commands
    table option, mysql Options
    tee command, mysql Commands
    tee option, mysql Options
    unbuffered option, mysql Options
    use command, mysql Commands
    user option, mysql Options
    verbose option, mysql Options
    version option, mysql Options
    vertical option, mysql Options
    wait option, mysql Options
    warnings command, mysql Commands
    xml option, mysql Options
    MySQL binary distribution, Choosing Which MySQL Distribution to Install
    MYSQL C type, C API Data Structures
    MySQL Cluster, MySQL Cluster NDB 6.X/7.X
    "quick" configuration, Quick Test Setup of MySQL Cluster
    administration, mysqld Command Options for MySQL Cluster, ndbd — The MySQL Cluster Data Node Daemon, ndb_mgmd — The MySQL Cluster Management Server Daemon, ndb_mgm — The MySQL Cluster Management Client, Options Common to MySQL Cluster Programs, Commands in the MySQL Cluster Management Client, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
    and character sets, Known Issues in MySQL Cluster Replication
    and DNS, MySQL Cluster Multi-Computer How-To
    and INFORMATION_SCHEMA, MySQL Cluster and MySQL Privileges
    and IP addressing, MySQL Cluster Multi-Computer How-To
    and MySQL privileges, MySQL Cluster and MySQL Privileges
    and MySQL root user, MySQL Cluster and MySQL Privileges, MySQL Cluster and MySQL Security Procedures
    and networking, MySQL Cluster Hardware, Software, and Networking Requirements
    and transactions, MySQL 5.1 FAQ: MySQL Cluster
    and virtual machines, MySQL 5.1 FAQ: MySQL Cluster
    API node, MySQL Cluster Core Concepts, Defining SQL and Other API Nodes in a MySQL Cluster
    arbitrator, MySQL 5.1 FAQ: MySQL Cluster
    available platforms, MySQL Cluster NDB 6.X/7.X
    backups, ndb_restore — Restore a MySQL Cluster Backup, Online Backup of MySQL Cluster, MySQL Cluster Backup Concepts, Using The MySQL Cluster Management Client to Create a Backup, Configuration for MySQL Cluster Backups, MySQL Cluster Backup Troubleshooting
    benchmarks, MySQL Cluster Interconnects and Performance
    CHECKPOINT Events, MySQL Cluster Log Events
    cluster logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
    CLUSTERLOG commands, MySQL Cluster Logging Management Commands
    CLUSTERLOG STATISTICS command, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
    commands, mysqld Command Options for MySQL Cluster, ndbd — The MySQL Cluster Data Node Daemon, ndb_mgmd — The MySQL Cluster Management Server Daemon, ndb_mgm — The MySQL Cluster Management Client, Commands in the MySQL Cluster Management Client
    compiling with icc, Debugging and Porting MySQL
    concepts, MySQL Cluster Core Concepts
    configuration, MySQL Cluster Multi-Computer How-To, MySQL Cluster Configuration, Quick Test Setup of MySQL Cluster, Defining Computers in a MySQL Cluster, Defining a MySQL Cluster Management Server, Defining MySQL Cluster Data Nodes, Defining SQL and Other API Nodes in a MySQL Cluster, Configuring MySQL Cluster Parameters for Local Checkpoints, MySQL Server Usage for MySQL Cluster, ndb_mgmd — The MySQL Cluster Management Server Daemon
    configuration (example), MySQL Cluster Configuration: Basic Example
    configuration changes, Performing a Rolling Restart of a MySQL Cluster
    configuration files, MySQL Cluster Multi-Computer Configuration, MySQL Cluster Configuration Files
    configuration parameters, Overview of MySQL Cluster Configuration Parameters, MySQL Cluster Data Node Configuration Parameters, MySQL Cluster Management Node Configuration Parameters, MySQL Cluster SQL Node and API Node Configuration Parameters, Other MySQL Cluster Configuration Parameters
    configuring, Configuration for MySQL Cluster Backups
    CONNECTION Events, MySQL Cluster Log Events
    connectstring, The MySQL Cluster Connectstring
    CREATE NODEGROUP command, Commands in the MySQL Cluster Management Client
    data node, MySQL Cluster Core Concepts, Defining MySQL Cluster Data Nodes
    data nodes, ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    data types supported, MySQL 5.1 FAQ: MySQL Cluster
    defining node hosts, Defining Computers in a MySQL Cluster
    direct connections between nodes, MySQL Cluster TCP/IP Connections Using Direct Connections
    Disk Data tables (see MySQL Cluster Disk Data)
    DROP NODEGROUP command, Commands in the MySQL Cluster Management Client
    ENTER SINGLE USER MODE command, Commands in the MySQL Cluster Management Client
    ERROR Events, MySQL Cluster Log Events
    error logs, ndbd — The MySQL Cluster Data Node Daemon
    error messages, MySQL 5.1 FAQ: MySQL Cluster
    event log format, MySQL Cluster Log Events
    event logging thresholds, MySQL Cluster Logging Management Commands
    event logs, Event Reports Generated in MySQL Cluster, MySQL Cluster Logging Management Commands
    event severity levels, MySQL Cluster Logging Management Commands
    event types, Event Reports Generated in MySQL Cluster, MySQL Cluster Log Events
    execution threads, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    EXIT command, Commands in the MySQL Cluster Management Client
    EXIT SINGLE USER MODE command, Commands in the MySQL Cluster Management Client
    FAQ, MySQL 5.1 FAQ: MySQL Cluster
    features added in MySQL 5.1, Development History of MySQL Cluster in MySQL 5.1
    GCP Stop errors, Defining MySQL Cluster Data Nodes
    general description, MySQL Cluster Overview
    hardware requirements, MySQL 5.1 FAQ: MySQL Cluster
    HELP command, Commands in the MySQL Cluster Management Client
    HostName parameter
    and security, MySQL Cluster Security and Networking Issues
    how to obtain, MySQL 5.1 FAQ: MySQL Cluster
    importing existing tables, MySQL 5.1 FAQ: MySQL Cluster
    INFO Events, MySQL Cluster Log Events
    information sources, MySQL Cluster NDB 6.X/7.X
    insecurity of communication protocols, MySQL Cluster Security and Networking Issues
    installation, MySQL Cluster Multi-Computer How-To, MySQL Cluster Multi-Computer Installation
    interconnects, Using High-Speed Interconnects with MySQL Cluster
    Java clients, MySQL Cluster Core Concepts
    log files, ndbd — The MySQL Cluster Data Node Daemon, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    logging commands, MySQL Cluster Logging Management Commands
    management client (ndb_mgm), ndb_mgm — The MySQL Cluster Management Client
    management commands, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
    management node, MySQL Cluster Core Concepts, Defining a MySQL Cluster Management Server
    management nodes, ndb_mgmd — The MySQL Cluster Management Server Daemon
    managing, Management of MySQL Cluster
    master node, MySQL 5.1 FAQ: MySQL Cluster
    memory requirements, MySQL 5.1 FAQ: MySQL Cluster
    memory usage and recovery, Limits and Differences of MySQL Cluster from Standard MySQL Limits, Performing a Rolling Restart of a MySQL Cluster
    mgm, Options Common to MySQL Cluster Programs
    mgm client, Commands in the MySQL Cluster Management Client
    mgm management client, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
    mgm process, ndb_mgm — The MySQL Cluster Management Client
    mgmd, Options Common to MySQL Cluster Programs
    mgmd process, ndb_mgmd — The MySQL Cluster Management Server Daemon
    mysqld process, mysqld Command Options for MySQL Cluster, MySQL Server Usage for MySQL Cluster
    ndbd, ndbd — The MySQL Cluster Data Node Daemon, Options Common to MySQL Cluster Programs
    ndbd process, ndbd — The MySQL Cluster Data Node Daemon, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
    ndbmtd, ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)
    ndb_mgm, Initial Startup of MySQL Cluster, ndb_mgm — The MySQL Cluster Management Client
    ndb_mgmd process, ndb_mgmd — The MySQL Cluster Management Server Daemon
    ndb_size.pl (utility), MySQL 5.1 FAQ: MySQL Cluster
    network configuration
    and security, MySQL Cluster Security and Networking Issues
    network transporters, Using High-Speed Interconnects with MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets
    networking, MySQL Cluster TCP/IP Connections Using Direct Connections, MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster
    networking requirements, MySQL 5.1 FAQ: MySQL Cluster
    node failure (single user mode), MySQL Cluster Single User Mode
    node identifiers, MySQL Cluster Shared-Memory Connections, SCI Transport Connections in MySQL Cluster
    node logs, Event Reports Generated in MySQL Cluster
    node types, MySQL 5.1 FAQ: MySQL Cluster
    NODERESTART Events, MySQL Cluster Log Events
    nodes and node groups, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
    nodes and types, MySQL Cluster Core Concepts
    number of computers required, MySQL 5.1 FAQ: MySQL Cluster
    obtaining, MySQL Cluster Multi-Computer Installation
    partitioning support, Noncompliance with SQL Syntax in MySQL Cluster
    partitions, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
    performance, MySQL Cluster Interconnects and Performance
    performing queries, Loading Sample Data into MySQL Cluster and Performing Queries
    platforms supported, MySQL 5.1 FAQ: MySQL Cluster
    preparing for replication, Preparing the MySQL Cluster for Replication
    process management, MySQL Cluster Programs
    QUIT command, Commands in the MySQL Cluster Management Client
    replicas, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions
    replication, MySQL Cluster Replication
    (see also MySQL Cluster replication)
    REPORT command, Commands in the MySQL Cluster Management Client
    requirements, MySQL Cluster Hardware, Software, and Networking Requirements
    resetting, Performing a Rolling Restart of a MySQL Cluster
    RESTART command, Commands in the MySQL Cluster Management Client
    restarting, Safe Shutdown and Restart of MySQL Cluster
    restoring backups, ndb_restore — Restore a MySQL Cluster Backup
    roles of computers, MySQL 5.1 FAQ: MySQL Cluster
    runtime statistics, Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client
    SCI (Scalable Coherent Interface), SCI Transport Connections in MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets
    security, MySQL Cluster Security Issues, MySQL 5.1 FAQ: MySQL Cluster
    and firewalls, MySQL Cluster Security and Networking Issues
    and HostName parameter, MySQL Cluster Security and Networking Issues
    and network configuration, MySQL Cluster Security and Networking Issues
    and network ports, MySQL Cluster Security and Networking Issues
    and remote administration, MySQL Cluster Security and Networking Issues
    networking, MySQL Cluster Security and Networking Issues
    security procedures, MySQL Cluster and MySQL Security Procedures
    shared memory transport, MySQL Cluster Shared-Memory Connections
    SHOW command, Commands in the MySQL Cluster Management Client
    SHUTDOWN command, Commands in the MySQL Cluster Management Client
    shutting down, Safe Shutdown and Restart of MySQL Cluster
    single user mode, Commands in the MySQL Cluster Management Client, MySQL Cluster Single User Mode
    SQL node, MySQL Cluster Core Concepts, Defining SQL and Other API Nodes in a MySQL Cluster
    SQL nodes, MySQL Server Usage for MySQL Cluster
    SQL statements, MySQL 5.1 FAQ: MySQL Cluster
    SQL statements for monitoring, Quick Reference: MySQL Cluster SQL Statements
    START BACKUP command, MySQL Cluster Backups With MySQL Cluster Replication
    START command, Commands in the MySQL Cluster Management Client
    start phases (summary), Summary of MySQL Cluster Start Phases
    starting, Quick Test Setup of MySQL Cluster
    starting and stopping, MySQL 5.1 FAQ: MySQL Cluster
    starting nodes, Initial Startup of MySQL Cluster
    starting or restarting, Summary of MySQL Cluster Start Phases
    STARTUP Events, MySQL Cluster Log Events
    STATISTICS Events, MySQL Cluster Log Events
    STATUS command, Commands in the MySQL Cluster Management Client
    STOP command, Commands in the MySQL Cluster Management Client
    storage requirements, Data Type Storage Requirements
    Table is full errors, MySQL 5.1 FAQ: MySQL Cluster
    thread states, MySQL Cluster Thread States
    trace files, ndbd — The MySQL Cluster Data Node Daemon
    transaction handling, Limits Relating to Transaction Handling in MySQL Cluster
    transactions, Defining MySQL Cluster Data Nodes
    transporters
    Scalable Coherent Interface (SCI), SCI Transport Connections in MySQL Cluster
    shared memory (SHM), MySQL Cluster Shared-Memory Connections
    TCP/IP, MySQL Cluster TCP/IP Connections Using Direct Connections
    troubleshooting backups, MySQL Cluster Backup Troubleshooting
    upgrades and downgrades, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of a MySQL Cluster, MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility
    using tables and data, Loading Sample Data into MySQL Cluster and Performing Queries
    vs replication, MySQL 5.1 FAQ: MySQL Cluster
    MySQL Cluster Disk Data, MySQL Cluster Disk Data Tables
    creating log file groups, MySQL Cluster Disk Data Objects
    creating tables, MySQL Cluster Disk Data Objects
    creating tablespaces, MySQL Cluster Disk Data Objects
    dropping Disk Data objects, MySQL Cluster Disk Data Objects
    storage requirements, MySQL Cluster Disk Data Storage Requirements
    MySQL Cluster How-To, MySQL Cluster Multi-Computer How-To
    MySQL Cluster in MySQL 5.1, MySQL Cluster Development History
    MySQL Cluster limitations, Known Limitations of MySQL Cluster
    and differences from standard MySQL limits, Limits and Differences of MySQL Cluster from Standard MySQL Limits
    autodiscovery, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    binary logging, Issues Exclusive to MySQL Cluster
    character sets, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    CREATE TABLE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    database objects, Limits Associated with Database Objects in MySQL Cluster
    Disk Data storage, Limitations Relating to MySQL Cluster Disk Data Storage
    error handling and reporting, MySQL Cluster Error Handling
    geometry data types, Noncompliance with SQL Syntax in MySQL Cluster
    implementation, Issues Exclusive to MySQL Cluster
    imposed by configuration, Limits and Differences of MySQL Cluster from Standard MySQL Limits
    INSERT IGNORE, UPDATE IGNORE, and REPLACE statements, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    memory usage and transaction handling, Limits Relating to Transaction Handling in MySQL Cluster
    multiple data nodes, MySQL Cluster Development in MySQL Cluster NDB 6.2, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    multiple management servers, Limitations Relating to Multiple MySQL Cluster Nodes, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    multiple MySQL servers, Limitations Relating to Multiple MySQL Cluster Nodes
    partitioning, Noncompliance with SQL Syntax in MySQL Cluster
    performance, Limitations Relating to Performance in MySQL Cluster
    replication, Noncompliance with SQL Syntax in MySQL Cluster, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    resolved in current version from previous versions, Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x
    syntax, Noncompliance with SQL Syntax in MySQL Cluster
    transactions, Limits Relating to Transaction Handling in MySQL Cluster
    unsupported features, Unsupported or Missing Features in MySQL Cluster
    MySQL Cluster NDB 6.x, MySQL Cluster Development History
    MySQL Cluster processes, MySQL Cluster Programs
    MySQL Cluster programs, MySQL Cluster Programs
    MySQL Cluster replication, MySQL Cluster Replication
    and --initial option, Known Issues in MySQL Cluster Replication
    and auto_increment* variables, Known Issues in MySQL Cluster Replication
    and circular replication, Known Issues in MySQL Cluster Replication
    and multi-byte character sets, Known Issues in MySQL Cluster Replication
    and primary key, Known Issues in MySQL Cluster Replication
    and single point of failure, Using Two Replication Channels for MySQL Cluster Replication
    backups, MySQL Cluster Backups With MySQL Cluster Replication
    circular replication, MySQL Cluster Replication: Multi-Master and Circular Replication
    concepts, MySQL Cluster Replication: Abbreviations and Symbols, MySQL Cluster Replication: Assumptions and General Requirements
    conflict resolution, MySQL Cluster Replication Conflict Resolution
    failover, Using Two Replication Channels for MySQL Cluster Replication, Implementing Failover with MySQL Cluster Replication
    gap event, Known Issues in MySQL Cluster Replication
    known issues, Known Issues in MySQL Cluster Replication
    loss of connection, Known Issues in MySQL Cluster Replication
    multi-master replication, MySQL Cluster Replication: Multi-Master and Circular Replication
    point-in-time recovery, Point-In-Time Recovery Using MySQL Cluster Replication
    preparing, Preparing the MySQL Cluster for Replication
    requirements, MySQL Cluster Replication: Assumptions and General Requirements
    reset-slave.pl backup automation script, MySQL Cluster Replication: Automating Synchronization of the Replication Slave to the Master Binary Log
    restoring from backup, MySQL Cluster Backups With MySQL Cluster Replication
    starting, Starting MySQL Cluster Replication (Single Replication Channel)
    storage engines other than NDB on slave, Known Issues in MySQL Cluster Replication
    synchronization of master and slave, MySQL Cluster Replication: Automating Synchronization of the Replication Slave to the Master Binary Log
    system tables used, MySQL Cluster Replication Schema and Tables
    mysql command options, mysql Options
    mysql commands
    list of, mysql Commands
    MySQL Dolphin name, History of MySQL
    MySQL history, History of MySQL
    mysql history file, mysql Options
    MySQL Instance Manager, mysqlmanager — The MySQL Instance Manager
    MySQL mailing lists, MySQL Mailing Lists
    MySQL name, History of MySQL
    MySQL privileges
    and MySQL Cluster, MySQL Cluster and MySQL Privileges
    mysql prompt command, mysql Commands
    MySQL server
    mysqld, mysqld — The MySQL Server, The MySQL Server
    mysql source (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File
    MySQL source distribution, Choosing Which MySQL Distribution to Install
    MySQL storage engines, Storage Engines
    MySQL system tables
    and MySQL Cluster, MySQL Cluster and MySQL Privileges
    and replication, Replication of the mysql System Database
    MySQL version, How to Get MySQL
    mysql \. (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File
    MySQL++, MySQL C++ API
    mysql.event table, The Event Scheduler and MySQL Privileges
    mysql.ndb_binlog_index table, MySQL Cluster Replication Schema and Tables
    (see also MySQL Cluster replication)
    mysql.server, Overview of MySQL Programs, mysql.server — MySQL Server Startup Script
    basedir option, mysql.server — MySQL Server Startup Script
    datadir option, mysql.server — MySQL Server Startup Script
    pid-file option, mysql.server — MySQL Server Startup Script
    service-startup-timeout option, mysql.server — MySQL Server Startup Script
    use-manager option, mysql.server — MySQL Server Startup Script
    use-mysqld_safe option, mysql.server — MySQL Server Startup Script
    user option, mysql.server — MySQL Server Startup Script
    mysql.sock
    changing location of, Typical configure Options
    protection, How to Protect or Change the MySQL Unix Socket File
    MYSQL323 SQL mode, Server SQL Modes
    MYSQL40 SQL mode, Server SQL Modes
    mysqlaccess, Overview of MySQL Programs, mysqlaccess — Client for Checking Access Privileges
    brief option, mysqlaccess — Client for Checking Access Privileges
    commit option, mysqlaccess — Client for Checking Access Privileges
    copy option, mysqlaccess — Client for Checking Access Privileges
    db option, mysqlaccess — Client for Checking Access Privileges
    debug option, mysqlaccess — Client for Checking Access Privileges
    help option, mysqlaccess — Client for Checking Access Privileges
    host option, mysqlaccess — Client for Checking Access Privileges
    howto option, mysqlaccess — Client for Checking Access Privileges
    old_server option, mysqlaccess — Client for Checking Access Privileges
    password option, mysqlaccess — Client for Checking Access Privileges
    plan option, mysqlaccess — Client for Checking Access Privileges
    preview option, mysqlaccess — Client for Checking Access Privileges
    relnotes option, mysqlaccess — Client for Checking Access Privileges
    rhost option, mysqlaccess — Client for Checking Access Privileges
    rollback option, mysqlaccess — Client for Checking Access Privileges
    spassword option, mysqlaccess — Client for Checking Access Privileges
    superuser option, mysqlaccess — Client for Checking Access Privileges
    table option, mysqlaccess — Client for Checking Access Privileges
    user option, mysqlaccess — Client for Checking Access Privileges
    version option, mysqlaccess — Client for Checking Access Privileges
    mysqladmin, Overview of MySQL Programs, mysqladmin — Client for Administering a MySQL Server, CREATE DATABASE Syntax, DROP DATABASE Syntax, SHOW STATUS Syntax, SHOW VARIABLES Syntax, FLUSH Syntax, KILL Syntax
    character-sets-dir option, mysqladmin — Client for Administering a MySQL Server
    compress option, mysqladmin — Client for Administering a MySQL Server
    count option, mysqladmin — Client for Administering a MySQL Server
    debug option, mysqladmin — Client for Administering a MySQL Server
    debug-check option, mysqladmin — Client for Administering a MySQL Server
    debug-info option, mysqladmin — Client for Administering a MySQL Server
    default-character-set option, mysqladmin — Client for Administering a MySQL Server
    force option, mysqladmin — Client for Administering a MySQL Server
    help option, mysqladmin — Client for Administering a MySQL Server
    host option, mysqladmin — Client for Administering a MySQL Server
    no-beep option, mysqladmin — Client for Administering a MySQL Server
    password option, mysqladmin — Client for Administering a MySQL Server
    pipe option, mysqladmin — Client for Administering a MySQL Server
    port option, mysqladmin — Client for Administering a MySQL Server
    protocol option, mysqladmin — Client for Administering a MySQL Server
    relative option, mysqladmin — Client for Administering a MySQL Server
    silent option, mysqladmin — Client for Administering a MySQL Server
    sleep option, mysqladmin — Client for Administering a MySQL Server
    socket option, mysqladmin — Client for Administering a MySQL Server
    SSL options, mysqladmin — Client for Administering a MySQL Server
    user option, mysqladmin — Client for Administering a MySQL Server
    verbose option, mysqladmin — Client for Administering a MySQL Server
    version option, mysqladmin — Client for Administering a MySQL Server
    vertical option, mysqladmin — Client for Administering a MySQL Server
    wait option, mysqladmin — Client for Administering a MySQL Server
    mysqladmin command options, mysqladmin — Client for Administering a MySQL Server
    mysqladmin option
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    mysqlbinlog, Overview of MySQL Programs, mysqlbinlog — Utility for Processing Binary Log Files
    base64-output option, mysqlbinlog — Utility for Processing Binary Log Files
    character-sets-dir option, mysqlbinlog — Utility for Processing Binary Log Files
    database option, mysqlbinlog — Utility for Processing Binary Log Files
    debug option, mysqlbinlog — Utility for Processing Binary Log Files
    debug-check option, mysqlbinlog — Utility for Processing Binary Log Files
    debug-info option, mysqlbinlog — Utility for Processing Binary Log Files
    disable-log-bin option, mysqlbinlog — Utility for Processing Binary Log Files
    force-read option, mysqlbinlog — Utility for Processing Binary Log Files
    help option, mysqlbinlog — Utility for Processing Binary Log Files
    hexdump option, mysqlbinlog — Utility for Processing Binary Log Files
    host option, mysqlbinlog — Utility for Processing Binary Log Files
    local-load option, mysqlbinlog — Utility for Processing Binary Log Files
    offset option, mysqlbinlog — Utility for Processing Binary Log Files
    password option, mysqlbinlog — Utility for Processing Binary Log Files
    port option, mysqlbinlog — Utility for Processing Binary Log Files
    position option, mysqlbinlog — Utility for Processing Binary Log Files
    protocol option, mysqlbinlog — Utility for Processing Binary Log Files
    read-from-remote-server option, mysqlbinlog — Utility for Processing Binary Log Files
    result-file option, mysqlbinlog — Utility for Processing Binary Log Files
    server-id option, mysqlbinlog — Utility for Processing Binary Log Files
    set-charset option, mysqlbinlog — Utility for Processing Binary Log Files
    short-form option, mysqlbinlog — Utility for Processing Binary Log Files
    socket option, mysqlbinlog — Utility for Processing Binary Log Files
    start-datetime option, mysqlbinlog — Utility for Processing Binary Log Files
    start-position option, mysqlbinlog — Utility for Processing Binary Log Files
    stop-datetime option, mysqlbinlog — Utility for Processing Binary Log Files
    stop-position option, mysqlbinlog — Utility for Processing Binary Log Files
    to-last-log option, mysqlbinlog — Utility for Processing Binary Log Files
    user option, mysqlbinlog — Utility for Processing Binary Log Files
    verbose option, mysqlbinlog — Utility for Processing Binary Log Files
    version option, mysqlbinlog — Utility for Processing Binary Log Files
    mysqlbug, mysqlbug — Generate Bug Report
    mysqlbug script, How to Report Bugs or Problems
    mysqlcheck, Overview of MySQL Programs, mysqlcheck — A Table Maintenance Program
    all-databases option, mysqlcheck — A Table Maintenance Program
    all-in-1 option, mysqlcheck — A Table Maintenance Program
    analyze option, mysqlcheck — A Table Maintenance Program
    auto-repair option, mysqlcheck — A Table Maintenance Program
    character-sets-dir option, mysqlcheck — A Table Maintenance Program
    check option, mysqlcheck — A Table Maintenance Program
    check-only-changed option, mysqlcheck — A Table Maintenance Program
    check-upgrade option, mysqlcheck — A Table Maintenance Program
    compress option, mysqlcheck — A Table Maintenance Program
    databases option, mysqlcheck — A Table Maintenance Program
    debug option, mysqlcheck — A Table Maintenance Program
    debug-check option, mysqlcheck — A Table Maintenance Program
    debug-info option, mysqlcheck — A Table Maintenance Program
    default-character-set option, mysqlcheck — A Table Maintenance Program
    extended option, mysqlcheck — A Table Maintenance Program
    fast option, mysqlcheck — A Table Maintenance Program
    fix-db-names option, mysqlcheck — A Table Maintenance Program
    fix-table-names option, mysqlcheck — A Table Maintenance Program
    force option, mysqlcheck — A Table Maintenance Program
    help option, mysqlcheck — A Table Maintenance Program
    host option, mysqlcheck — A Table Maintenance Program
    medium-check option, mysqlcheck — A Table Maintenance Program
    optimize option, mysqlcheck — A Table Maintenance Program
    password option, mysqlcheck — A Table Maintenance Program
    pipe option, mysqlcheck — A Table Maintenance Program
    port option, mysqlcheck — A Table Maintenance Program
    protocol option, mysqlcheck — A Table Maintenance Program
    quick option, mysqlcheck — A Table Maintenance Program
    repair option, mysqlcheck — A Table Maintenance Program
    silent option, mysqlcheck — A Table Maintenance Program
    socket option, mysqlcheck — A Table Maintenance Program
    SSL options, mysqlcheck — A Table Maintenance Program
    tables option, mysqlcheck — A Table Maintenance Program
    use-frm option, mysqlcheck — A Table Maintenance Program
    user option, mysqlcheck — A Table Maintenance Program
    verbose option, mysqlcheck — A Table Maintenance Program
    version option, mysqlcheck — A Table Maintenance Program
    write-binlog option, mysqlcheck — A Table Maintenance Program
    mysqlclient library, Connectors and APIs
    mysqld, Overview of MySQL Programs
    abort-slave-event-count option, Replication Slave Options and Variables
    allow-suspicious-udfs option, Server Command Options, Security-Related mysqld Options
    ansi option, Server Command Options
    as MySQL Cluster process, mysqld Command Options for MySQL Cluster, MySQL Server Usage for MySQL Cluster
    basedir option, Server Command Options
    big-tables option, Server Command Options
    bind-address option, Server Command Options
    binlog-do-db option, Binary Log Options and Variables
    binlog-format option, Server Command Options
    binlog-ignore-db option, Binary Log Options and Variables
    binlog-row-event-max-size option, Binary Log Options and Variables
    bootstrap option, Server Command Options
    character-set-client-handshake option, Server Command Options
    character-set-filesystem option, Server Command Options
    character-set-server option, Server Command Options
    character-sets-dir option, Server Command Options
    chroot option, Server Command Options
    collation-server option, Server Command Options
    command options, Server Command Options
    console option, Server Command Options
    core-file option, Server Command Options
    datadir option, Server Command Options
    debug option, Server Command Options
    debug-sync-timeout option, Server Command Options
    default-character-set option, Server Command Options
    default-collation option, Server Command Options
    default-storage-engine option, Server Command Options
    default-table-type option, Server Command Options
    default-time-zone option, Server Command Options
    delay-key-write option, Server Command Options, MyISAM Startup Options
    des-key-file option, Server Command Options
    disconnect-slave-event-count option, Replication Slave Options and Variables
    enable-named-pipe option, Server Command Options
    enable-pstack option, Server Command Options
    event-scheduler option, Server Command Options
    exit-info option, Server Command Options
    external-locking option, Server Command Options
    flush option, Server Command Options
    gdb option, Server Command Options
    general-log option, Server Command Options
    help option, Server Command Options
    ignore-builtin-innodb option, InnoDB Startup Options and System Variables
    init-file option, Server Command Options
    innodb option, InnoDB Startup Options and System Variables
    innodb-status-file option, InnoDB Startup Options and System Variables
    language option, Server Command Options
    large-pages option, Server Command Options
    local-infile option, Security-Related mysqld Options
    log option, Server Command Options
    log-bin option, Binary Log Options and Variables
    log-bin-index option, Binary Log Options and Variables
    log-bin-trust-function-creators option, Binary Log Options and Variables
    log-error option, Server Command Options
    log-isam option, Server Command Options
    log-long-format option, Server Command Options
    log-output option, Server Command Options
    log-queries-not-using-indexes option, Server Command Options
    log-short-format option, Server Command Options
    log-slave-updates option, Replication Slave Options and Variables
    log-slow-admin-statements option, Server Command Options
    log-slow-queries option, Server Command Options
    log-slow-slave-statements option, Replication Slave Options and Variables
    log-tc option, Server Command Options
    log-tc-size option, Server Command Options
    log-warnings option, Server Command Options, Replication Slave Options and Variables
    low-priority-updates option, Server Command Options
    master-connect-retry option, Replication Slave Options and Variables
    master-host option, Replication Slave Options and Variables
    master-info-file option, Replication Slave Options and Variables
    master-password option, Replication Slave Options and Variables
    master-port option, Replication Slave Options and Variables
    master-retry-count option, Replication Slave Options and Variables
    master-ssl option, Replication Slave Options and Variables
    master-ssl-ca option, Replication Slave Options and Variables
    master-ssl-capath option, Replication Slave Options and Variables
    master-ssl-cert option, Replication Slave Options and Variables
    master-ssl-cipher option, Replication Slave Options and Variables
    master-ssl-key option, Replication Slave Options and Variables
    master-user option, Replication Slave Options and Variables
    max-binlog-dump-events option, Binary Log Options and Variables
    max-relay-log-size option, Replication Slave Options and Variables
    memlock option, Server Command Options
    min-examined-row-limit option, Server Command Options
    myisam-block-size option, Server Command Options
    myisam-recover option, Server Command Options, MyISAM Startup Options
    MySQL server, mysqld — The MySQL Server, The MySQL Server
    ndb-batch-size option, mysqld Command Options for MySQL Cluster
    ndb-cluster-connection-pool option, mysqld Command Options for MySQL Cluster
    ndb-connectstring option, mysqld Command Options for MySQL Cluster
    ndb-nodeid, mysqld Command Options for MySQL Cluster
    ndbcluster option, mysqld Command Options for MySQL Cluster
    old-alter-table option, Server Command Options
    old-passwords option, Server Command Options, Security-Related mysqld Options
    old-style-user-limits option, Server Command Options
    one-thread option, Server Command Options
    open-files-limit option, Server Command Options
    partition option, Server Command Options
    pid-file option, Server Command Options
    plugin option prefix, Server Command Options
    plugin-load option, Server Command Options
    port option, Server Command Options
    port-open-timeout option, Server Command Options
    read-only option, Replication Slave Options and Variables
    relay-log option, Replication Slave Options and Variables
    relay-log-index option, Replication Slave Options and Variables
    relay-log-info-file option, Replication Slave Options and Variables
    relay-log-purge option, Replication Slave Options and Variables
    relay-log-space-limit option, Replication Slave Options and Variables
    replicate-do-db option, Replication Slave Options and Variables
    replicate-do-table option, Replication Slave Options and Variables
    replicate-ignore-db option, Replication Slave Options and Variables
    replicate-ignore-table option, Replication Slave Options and Variables
    replicate-rewrite-db option, Replication Slave Options and Variables
    replicate-same-server-id option, Replication Slave Options and Variables
    replicate-wild-do-table option, Replication Slave Options and Variables
    replicate-wild-ignore-table option, Replication Slave Options and Variables
    report-host option, Replication Slave Options and Variables
    report-password option, Replication Slave Options and Variables
    report-port option, Replication Slave Options and Variables
    report-user option, Replication Slave Options and Variables
    role in MySQL Cluster (see SQL Node (MySQL Cluster))
    safe-mode option, Server Command Options
    safe-show-database option, Server Command Options, Security-Related mysqld Options
    safe-user-create option, Server Command Options, Security-Related mysqld Options
    secure-auth option, Server Command Options, Security-Related mysqld Options
    secure-file-priv option, Server Command Options, Security-Related mysqld Options
    server-id option, Replication and Binary Logging Options and Variables
    shared-memory option, Server Command Options
    shared-memory-base-name option, Server Command Options
    show-slave-auth-info option, Replication Slave Options and Variables
    skip-concurrent-insert option, Server Command Options
    skip-event-scheduler option, Server Command Options
    skip-external-locking option, Server Command Options
    skip-grant-tables option, Server Command Options, Security-Related mysqld Options
    skip-host-cache option, Server Command Options
    skip-innodb option, Server Command Options
    skip-merge option, Security-Related mysqld Options
    skip-name-resolve option, Server Command Options, Security-Related mysqld Options
    skip-ndbcluster option, mysqld Command Options for MySQL Cluster
    skip-networking option, Server Command Options, Security-Related mysqld Options
    skip-partition option, Server Command Options
    skip-safemalloc option, Server Command Options
    skip-show-database option, Server Command Options, Security-Related mysqld Options
    skip-slave-start option, Replication Slave Options and Variables
    skip-stack-trace option, Server Command Options
    skip-symbolic-links option, Server Command Options
    skip-thread-priority option, Server Command Options
    slave-load-tmpdir option, Replication Slave Options and Variables
    slave-net-timeout option, Replication Slave Options and Variables
    slave-skip-errors option, Replication Slave Options and Variables
    slave_compressed_protocol option, Replication Slave Options and Variables
    slow-query-log option, Server Command Options
    socket option, Server Command Options
    sporadic-binlog-dump-fail option, Binary Log Options and Variables
    sql-mode option, Server Command Options
    SSL options, Server Command Options, Security-Related mysqld Options
    standalone option, Server Command Options
    starting, How to Run MySQL as a Normal User
    symbolic-links option, Server Command Options
    sysdate-is-now option, Server Command Options
    tc-heuristic-recover option, Server Command Options
    temp-pool option, Server Command Options
    tmpdir option, Server Command Options
    transaction-isolation option, Server Command Options
    user option, Server Command Options
    verbose option, Server Command Options
    version option, Server Command Options
    mysqld (MySQL Cluster), MySQL Cluster Programs
    mysqld library, Connectors and APIs
    mysqld option
    mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    mysqld options, Tuning Server Parameters
    mysqld server
    buffer sizes, Tuning Server Parameters
    mysqld-safe-compatible option
    mysqlmanager, MySQL Instance Manager Command Options
    mysqld-version option
    mysqld_safe, mysqld_safe — MySQL Server Startup Script
    mysqldump, Copying MySQL Databases to Another Machine, Overview of MySQL Programs, mysqldump — A Database Backup Program
    add-drop-database option, mysqldump — A Database Backup Program
    add-drop-table option, mysqldump — A Database Backup Program
    add-locks option, mysqldump — A Database Backup Program
    all-databases option, mysqldump — A Database Backup Program
    all-tablespaces option, mysqldump — A Database Backup Program
    allow-keywords option, mysqldump — A Database Backup Program
    character-sets-dir option, mysqldump — A Database Backup Program
    comments option, mysqldump — A Database Backup Program
    compact option, mysqldump — A Database Backup Program
    compatible option, mysqldump — A Database Backup Program
    complete-insert option, mysqldump — A Database Backup Program
    compress option, mysqldump — A Database Backup Program
    create-options option, mysqldump — A Database Backup Program
    databases option, mysqldump — A Database Backup Program
    debug option, mysqldump — A Database Backup Program
    debug-check option, mysqldump — A Database Backup Program
    debug-info option, mysqldump — A Database Backup Program
    default-character-set option, mysqldump — A Database Backup Program
    delayed-insert option, mysqldump — A Database Backup Program
    delete-master-logs option, mysqldump — A Database Backup Program
    disable-keys option, mysqldump — A Database Backup Program
    dump-date option, mysqldump — A Database Backup Program
    events option, mysqldump — A Database Backup Program
    extended-insert option, mysqldump — A Database Backup Program
    fields-enclosed-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    fields-escaped-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    fields-optionally-enclosed-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    fields-terminated-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    first-slave option, mysqldump — A Database Backup Program
    flush-logs option, mysqldump — A Database Backup Program
    flush-privileges option, mysqldump — A Database Backup Program
    force option, mysqldump — A Database Backup Program
    help option, mysqldump — A Database Backup Program
    hex-blob option, mysqldump — A Database Backup Program
    host option, mysqldump — A Database Backup Program
    ignore-table option, mysqldump — A Database Backup Program
    insert-ignore option, mysqldump — A Database Backup Program
    lines-terminated-by option, mysqldump — A Database Backup Program, mysqlimport — A Data Import Program
    lock-all-tables option, mysqldump — A Database Backup Program
    lock-tables option, mysqldump — A Database Backup Program
    log-error option, mysqldump — A Database Backup Program
    master-data option, mysqldump — A Database Backup Program
    no-autocommit option, mysqldump — A Database Backup Program
    no-create-db option, mysqldump — A Database Backup Program
    no-create-info option, mysqldump — A Database Backup Program
    no-data option, mysqldump — A Database Backup Program
    no-set-names option, mysqldump — A Database Backup Program
    no-tablespaces option, mysqldump — A Database Backup Program
    opt option, mysqldump — A Database Backup Program
    order-by-primary option, mysqldump — A Database Backup Program
    password option, mysqldump — A Database Backup Program
    pipe option, mysqldump — A Database Backup Program
    port option, mysqldump — A Database Backup Program
    problems, mysqldump — A Database Backup Program, Restrictions on Views
    protocol option, mysqldump — A Database Backup Program
    quick option, mysqldump — A Database Backup Program
    quote-names option, mysqldump — A Database Backup Program
    replace option, mysqldump — A Database Backup Program
    result-file option, mysqldump — A Database Backup Program
    routines option, mysqldump — A Database Backup Program
    set-charset option, mysqldump — A Database Backup Program
    single-transaction option, mysqldump — A Database Backup Program
    skip-comments option, mysqldump — A Database Backup Program
    skip-opt option, mysqldump — A Database Backup Program
    socket option, mysqldump — A Database Backup Program
    SSL options, mysqldump — A Database Backup Program
    tab option, mysqldump — A Database Backup Program
    tables option, mysqldump — A Database Backup Program
    triggers option, mysqldump — A Database Backup Program
    tz-utc option, mysqldump — A Database Backup Program
    user option, mysqldump — A Database Backup Program
    using for backups, Using mysqldump for Backups
    verbose option, mysqldump — A Database Backup Program
    version option, mysqldump — A Database Backup Program
    views, mysqldump — A Database Backup Program, Restrictions on Views
    where option, mysqldump — A Database Backup Program
    workarounds, mysqldump — A Database Backup Program, Restrictions on Views
    xml option, mysqldump — A Database Backup Program
    mysqldumpslow, Overview of MySQL Programs, mysqldumpslow — Summarize Slow Query Log Files
    debug option, mysqldumpslow — Summarize Slow Query Log Files
    help option, mysqldumpslow — Summarize Slow Query Log Files
    verbose option, mysqldumpslow — Summarize Slow Query Log Files
    mysqld_multi, Overview of MySQL Programs, mysqld_multi — Manage Multiple MySQL Servers
    config-file option, mysqld_multi — Manage Multiple MySQL Servers
    defaults-extra-file option, mysqld_multi — Manage Multiple MySQL Servers
    defaults-file option, mysqld_multi — Manage Multiple MySQL Servers
    example option, mysqld_multi — Manage Multiple MySQL Servers
    help option, mysqld_multi — Manage Multiple MySQL Servers
    log option, mysqld_multi — Manage Multiple MySQL Servers
    mysqladmin option, mysqld_multi — Manage Multiple MySQL Servers
    mysqld option, mysqld_multi — Manage Multiple MySQL Servers
    no-defaults option, mysqld_multi — Manage Multiple MySQL Servers
    no-log option, mysqld_multi — Manage Multiple MySQL Servers
    password option, mysqld_multi — Manage Multiple MySQL Servers
    silent option, mysqld_multi — Manage Multiple MySQL Servers
    tcp-ip option, mysqld_multi — Manage Multiple MySQL Servers
    user option, mysqld_multi — Manage Multiple MySQL Servers
    verbose option, mysqld_multi — Manage Multiple MySQL Servers
    version option, mysqld_multi — Manage Multiple MySQL Servers
    mysqld_safe, Overview of MySQL Programs, mysqld_safe — MySQL Server Startup Script
    autoclose option, mysqld_safe — MySQL Server Startup Script
    basedir option, mysqld_safe — MySQL Server Startup Script
    core-file-size option, mysqld_safe — MySQL Server Startup Script
    datadir option, mysqld_safe — MySQL Server Startup Script
    defaults-extra-file option, mysqld_safe — MySQL Server Startup Script
    defaults-file option, mysqld_safe — MySQL Server Startup Script
    help option, mysqld_safe — MySQL Server Startup Script
    ledir option, mysqld_safe — MySQL Server Startup Script
    log-error option, mysqld_safe — MySQL Server Startup Script
    mysqld option, mysqld_safe — MySQL Server Startup Script
    mysqld-version option, mysqld_safe — MySQL Server Startup Script
    nice option, mysqld_safe — MySQL Server Startup Script
    no-defaults option, mysqld_safe — MySQL Server Startup Script
    open-files-limit option, mysqld_safe — MySQL Server Startup Script
    pid-file option, mysqld_safe — MySQL Server Startup Script
    port option, mysqld_safe — MySQL Server Startup Script
    skip-kill-mysqld option, mysqld_safe — MySQL Server Startup Script
    skip-syslog option, mysqld_safe — MySQL Server Startup Script
    socket option, mysqld_safe — MySQL Server Startup Script
    syslog option, mysqld_safe — MySQL Server Startup Script
    syslog-tag option, mysqld_safe — MySQL Server Startup Script
    timezone option, mysqld_safe — MySQL Server Startup Script
    user option, mysqld_safe — MySQL Server Startup Script
    mysqlhotcopy, Overview of MySQL Programs, mysqlhotcopy — A Database Backup Program
    addtodest option, mysqlhotcopy — A Database Backup Program
    allowold option, mysqlhotcopy — A Database Backup Program
    checkpoint option, mysqlhotcopy — A Database Backup Program
    chroot option, mysqlhotcopy — A Database Backup Program
    debug option, mysqlhotcopy — A Database Backup Program
    dryrun option, mysqlhotcopy — A Database Backup Program
    flushlog option, mysqlhotcopy — A Database Backup Program
    help option, mysqlhotcopy — A Database Backup Program
    host option, mysqlhotcopy — A Database Backup Program
    keepold option, mysqlhotcopy — A Database Backup Program
    method option, mysqlhotcopy — A Database Backup Program
    noindices option, mysqlhotcopy — A Database Backup Program
    password option, mysqlhotcopy — A Database Backup Program
    port option, mysqlhotcopy — A Database Backup Program
    quiet option, mysqlhotcopy — A Database Backup Program
    record_log_pos option, mysqlhotcopy — A Database Backup Program
    regexp option, mysqlhotcopy — A Database Backup Program
    resetmaster option, mysqlhotcopy — A Database Backup Program
    resetslave option, mysqlhotcopy — A Database Backup Program
    socket option, mysqlhotcopy — A Database Backup Program
    suffix option, mysqlhotcopy — A Database Backup Program
    tmpdir option, mysqlhotcopy — A Database Backup Program
    user option, mysqlhotcopy — A Database Backup Program
    mysqlimport, Copying MySQL Databases to Another Machine, Overview of MySQL Programs, mysqlimport — A Data Import Program, LOAD DATA INFILE Syntax
    character-sets-dir option, mysqlimport — A Data Import Program
    columns option, mysqlimport — A Data Import Program
    compress option, mysqlimport — A Data Import Program
    debug option, mysqlimport — A Data Import Program
    debug-check option, mysqlimport — A Data Import Program
    debug-info option, mysqlimport — A Data Import Program
    default-character-set option, mysqlimport — A Data Import Program
    delete option, mysqlimport — A Data Import Program
    force option, mysqlimport — A Data Import Program
    help option, mysqlimport — A Data Import Program
    host option, mysqlimport — A Data Import Program
    ignore option, mysqlimport — A Data Import Program
    ignore-lines option, mysqlimport — A Data Import Program
    local option, mysqlimport — A Data Import Program
    lock-tables option, mysqlimport — A Data Import Program
    low-priority option, mysqlimport — A Data Import Program
    password option, mysqlimport — A Data Import Program
    pipe option, mysqlimport — A Data Import Program
    port option, mysqlimport — A Data Import Program
    protocol option, mysqlimport — A Data Import Program
    replace option, mysqlimport — A Data Import Program
    silent option, mysqlimport — A Data Import Program
    socket option, mysqlimport — A Data Import Program
    SSL options, mysqlimport — A Data Import Program
    use-threads option, mysqlimport — A Data Import Program
    user option, mysqlimport — A Data Import Program
    verbose option, mysqlimport — A Data Import Program
    version option, mysqlimport — A Data Import Program
    mysqlmanager, Overview of MySQL Programs, mysqlmanager — The MySQL Instance Manager
    add-user option, MySQL Instance Manager Command Options
    angel-pid-file option, MySQL Instance Manager Command Options
    bind-address option, MySQL Instance Manager Command Options
    check-password-file option, MySQL Instance Manager Command Options
    clean-password-file option, MySQL Instance Manager Command Options
    debug option, MySQL Instance Manager Command Options
    default-mysqld-path option, MySQL Instance Manager Command Options
    defaults-file option, MySQL Instance Manager Command Options
    drop-user option, MySQL Instance Manager Command Options
    edit-user option, MySQL Instance Manager Command Options
    help option, MySQL Instance Manager Command Options
    install option, MySQL Instance Manager Command Options
    list-users option, MySQL Instance Manager Command Options
    log option, MySQL Instance Manager Command Options
    monitoring-interval option, MySQL Instance Manager Command Options
    mysqld-safe-compatible option, MySQL Instance Manager Command Options
    password option, MySQL Instance Manager Command Options
    password-file option, MySQL Instance Manager Command Options
    pid-file option, MySQL Instance Manager Command Options
    port option, MySQL Instance Manager Command Options
    print-defaults option, MySQL Instance Manager Command Options
    print-password-line option, MySQL Instance Manager Command Options
    remove option, MySQL Instance Manager Command Options
    run-as-service option, MySQL Instance Manager Command Options
    socket option, MySQL Instance Manager Command Options
    standalone option, MySQL Instance Manager Command Options
    user option, MySQL Instance Manager Command Options
    username option, MySQL Instance Manager Command Options
    version option, MySQL Instance Manager Command Options
    wait-timeout option, MySQL Instance Manager Command Options
    mysqlshow, Overview of MySQL Programs, mysqlshow — Display Database, Table, and Column Information
    character-sets-dir option, mysqlshow — Display Database, Table, and Column Information
    compress option, mysqlshow — Display Database, Table, and Column Information
    count option, mysqlshow — Display Database, Table, and Column Information
    debug option, mysqlshow — Display Database, Table, and Column Information
    debug-check option, mysqlshow — Display Database, Table, and Column Information
    debug-info option, mysqlshow — Display Database, Table, and Column Information
    default-character-set option, mysqlshow — Display Database, Table, and Column Information
    help option, mysqlshow — Display Database, Table, and Column Information
    host option, mysqlshow — Display Database, Table, and Column Information
    keys option, mysqlshow — Display Database, Table, and Column Information
    password option, mysqlshow — Display Database, Table, and Column Information
    pipe option, mysqlshow — Display Database, Table, and Column Information
    port option, mysqlshow — Display Database, Table, and Column Information
    protocol option, mysqlshow — Display Database, Table, and Column Information
    show-table-type option, mysqlshow — Display Database, Table, and Column Information
    socket option, mysqlshow — Display Database, Table, and Column Information
    SSL options, mysqlshow — Display Database, Table, and Column Information
    status option, mysqlshow — Display Database, Table, and Column Information
    user option, mysqlshow — Display Database, Table, and Column Information
    verbose option, mysqlshow — Display Database, Table, and Column Information
    version option, mysqlshow — Display Database, Table, and Column Information
    mysqlslap, Overview of MySQL Programs, mysqlslap — Load Emulation Client
    auto-generate-sql option, mysqlslap — Load Emulation Client
    auto-generate-sql-add-autoincrement option, mysqlslap — Load Emulation Client
    auto-generate-sql-execute-number option,