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

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

    Command Index

    --ndb-cluster

    MySQL 4.1 FAQ: MySQL Cluster

    --old-passwords

    Section 21.10, “MySQL PHP API”

    --passwd

    Section 4.6.10.4, “Instance Manager User and Password Management”

    --run-as-service

    Section 4.6.10.1, “MySQL Instance Manager Command Options”

    ./configure

    Section 2.3.3, “Installing from the Development Source Tree”
    Section 2.3.2, “Typical configure Options”

    ./configure --help

    Section 2.3.1, “Source Installation Overview”

    ./configure --help

    Section 2.3.1, “Source Installation Overview”
    Section 2.3.2, “Typical configure Options”

    ./configure --without-server

    Section 22.5, “Debugging and Porting MySQL”

    ./configure --help

    Section 2.3.2, “Typical configure Options”

    ./mysql-test-run.pl

    Section 22.1.2, “MySQL Test Suite”

    ./mysql-test-run.pl test_name

    Section 22.1.2, “MySQL Test Suite”

    /etc/init.d/mysql

    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

    /etc/init.d/mysql stop

    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

    /usr/local/mysql/bin/mysql

    Section 4.2.1, “Invoking MySQL Programs”

    ? [arg]

    Section 4.5.1.2, “mysql Commands”

    ALL STATUS

    Section 17.5.6, “MySQL Cluster Single User Mode”

    APF

    Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”

    Access

    Section 12.2.2, “DELETE Syntax”

    BUILD/autorun.sh

    Section 2.3.3, “Installing from the Development Source Tree”

    BUILD/compile-platform_name-max

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    CRTUSRPRF

    Section 2.9, “Installing MySQL on i5/OS”

    DSPLIB

    Section 2.9, “Installing MySQL on i5/OS”

    Directory Utility

    Section 2.7.5, “MySQL Installation on Mac OS X Notes”

    EXIT SINGLE USER MODE

    Section 17.5.6, “MySQL Cluster Single User Mode”

    GnuPG

    Section 2.1.4.2, “Signature Checking Using GnuPG”

    Help View

    Section 2.7, “Installing MySQL on Mac OS X”

    Hot Backup

    Section 16.1.1, “How to Set Up Replication”

    Hot Backup

    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

    InnoDB Hot Backup

    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Section 16.1.1, “How to Set Up Replication”
    Section 13.6, “The InnoDB Storage Engine”

    InnoDB Hot Backup

    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 16.1.1, “How to Set Up Replication”
    Section 13.6, “The InnoDB Storage Engine”
    Section 13.6.2.1, “Using Per-Table Tablespaces”

    MYSQLINST/UPGMYSQL

    Section 2.9, “Installing MySQL on i5/OS”

    MySQL Enterprise Backup

    Section 13.6, “The InnoDB Storage Engine”

    MySQL Enterprise Backup

    Section 13.6, “The InnoDB Storage Engine”

    MySQL Enterprise Backup

    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Section 13.6, “The InnoDB Storage Engine”

    MySQLInstanceConfig.exe

    Section 2.5.4.13, “Creating an Instance from the Command Line”

    NET

    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    NET START MySQL

    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    NET STOP MySQL

    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    NET START

    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

    NET START MySQL

    Section 2.5.7, “Upgrading MySQL on Windows”

    NET START MySQL

    Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”

    NET STOP

    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

    NET STOP MySQL

    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    Netinfo Manager

    Section 2.7.5, “MySQL Installation on Mac OS X Notes”

    Notepad

    Section 2.5.5.2, “Creating an Option File”
    Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”

    PGP

    Section 2.1.4.2, “Signature Checking Using GnuPG”

    PowerArchiver

    Section 16.1.1, “How to Set Up Replication”

    Registry Editor

    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    SELECT

    Section 17.2.4, “Loading Sample Data into MySQL Cluster and Performing Queries”

    SHOW

    Section 17.3.1, “Quick Test Setup of MySQL Cluster”

    SHOW WARNINGS

    MySQL 4.1 FAQ: MySQL Cluster

    SHOW ERRORS

    MySQL 4.1 FAQ: MySQL Cluster

    Service Control Manager

    Section 2.5, “Installing MySQL on Windows”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    Services

    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    Start>Run>cmd.exe

    Section 5.5.6.4, “Setting Up SSL Certificates for MySQL”

    System Preferences...

    Section 2.7.3, “Installing and Using the MySQL Preference Pane”

    Terminal

    Section 2.7, “Installing MySQL on Mac OS X”

    Text in this style

    Section 1.2, “Typographical and Syntax Conventions”

    WinDbg

    Section 22.5.1.3, “Using pdb to create a Windows crashdump”

    WinRAR

    Section 16.1.1, “How to Set Up Replication”

    WinZip

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 16.1.1, “How to Set Up Replication”

    WordPad

    Section 12.2.6, “LOAD DATA INFILE Syntax”

    \! command

    Section 4.5.1.2, “mysql Commands”

    \#

    Section 4.5.1.2, “mysql Commands”

    \. file_name

    Section 4.5.1.2, “mysql Commands”

    \? [arg]

    Section 4.5.1.2, “mysql Commands”

    \C charset_name

    Section 4.5.1.2, “mysql Commands”

    \G

    Section 4.5.1.2, “mysql Commands”

    \P [command]

    Section 4.5.1.2, “mysql Commands”

    \R [str]

    Section 4.5.1.2, “mysql Commands”

    \T [file_name]

    Section 4.5.1.2, “mysql Commands”

    \W

    Section 4.5.1.2, “mysql Commands”

    \c

    Section 4.5.1.2, “mysql Commands”

    \d str

    Section 4.5.1.2, “mysql Commands”

    \e

    Section 4.5.1.2, “mysql Commands”

    \g

    Section 4.5.1.2, “mysql Commands”

    \h [arg]

    Section 4.5.1.2, “mysql Commands”

    \n

    Section 4.5.1.2, “mysql Commands”

    \p

    Section 4.5.1.2, “mysql Commands”

    \q

    Section 4.5.1.2, “mysql Commands”

    \r [db_name host_name]]

    Section 4.5.1.2, “mysql Commands”

    \s

    Section 4.5.1.2, “mysql Commands”

    \t

    Section 4.5.1.2, “mysql Commands”

    \u db_name

    Section 4.5.1.2, “mysql Commands”

    \w

    Section 4.5.1.2, “mysql Commands”

    aCC

    Section 22.5, “Debugging and Porting MySQL”

    aclocal

    Section 2.3.3, “Installing from the Development Source Tree”

    addgroup

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.3.1, “Source Installation Overview”

    adduser

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.3.1, “Source Installation Overview”

    autoconf

    Section 2.3.3, “Installing from the Development Source Tree”

    automake

    Section 2.3.3, “Installing from the Development Source Tree”

    autoreconf

    Section 2.3.3, “Installing from the Development Source Tree”

    bash

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 5.3.2.2, “End-User Guidelines for Password Security”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 2.7.5, “MySQL Installation on Mac OS X Notes”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 4.2.4, “Setting Environment Variables”
    Section 1.2, “Typographical and Syntax Conventions”

    bin/mysql_setpermission

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.3.1, “Source Installation Overview”

    bin/mysqld_safe

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 2.3.1, “Source Installation Overview”
    Section 2.13.1, “Unix Post-Installation Procedures”

    bin/safe_mysqld

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.3.1, “Source Installation Overview”
    Section 2.13.1, “Unix Post-Installation Procedures”

    bison

    Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Section 2.5.10, “Installing MySQL from Source on Windows”
    Section 2.3.3, “Installing from the Development Source Tree”

    bzr

    Section 2.3.3, “Installing from the Development Source Tree”
    Section 21.5, “MySQL Connector/C++”

    c++

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    c++filt

    Section 22.5.1.5, “Using a Stack Trace”

    cat [> filename]

    Section 4.5.1.1, “mysql Options”

    cc

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    charset

    Section 4.5.1.2, “mysql Commands”

    charset charset_name

    Section 4.5.1.2, “mysql Commands”

    charset_name charset_name

    Section 4.5.1.2, “mysql Commands”

    chkconfig

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”

    chroot

    Description

    clear

    Section 4.5.1.2, “mysql Commands”

    cmake

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”

    cmake --help

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”

    cmd

    Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”

    cmd.exe

    Section 4.2.1, “Invoking MySQL Programs”
    Section 1.2, “Typographical and Syntax Conventions”

    command.com

    Section 4.2.1, “Invoking MySQL Programs”
    Section 1.2, “Typographical and Syntax Conventions”

    comp_err

    Section 4.4.1, “comp_err — Compile MySQL Error Message File”
    Description
    Section 4.1, “Overview of MySQL Programs”

    comp_err [options]

    Section 4.4.1, “comp_err — Compile MySQL Error Message File”

    comp_err [options] from_file ... to_file

    Section 4.4.1, “comp_err — Compile MySQL Error Message File”

    compile-amd64-max-sci

    Section 17.3.5.1, “Configuring MySQL Cluster to use SCI Sockets”

    compile-pentium64-max-sci

    Section 17.3.5.1, “Configuring MySQL Cluster to use SCI Sockets”

    configure

    Section 12.1.17, “CREATE TABLE Syntax”
    Section B.5.2.17, “Can't initialize character set”
    Section 9.3, “Adding a New Character Set”
    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Section 2.14, “Environment Variables”
    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
    Section 1.7, “How to Report Bugs or Problems”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.3.3, “Installing from the Development Source Tree”
    Section 2.3.5, “MIT-pthreads Notes”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.3, “MySQL Installation Using a Source Distribution”
    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 5.1.4, “Server System Variables”
    Section 2.3.1, “Source Installation Overview”
    The mysqld-max Extended MySQL Server
    Section 13.12, “The ARCHIVE Storage Engine”
    Section 13.14, “The BLACKHOLE Storage Engine”
    Section 13.13, “The CSV Storage Engine”
    Section 13.10, “The EXAMPLE Storage Engine”
    Section 13.11, “The FEDERATED Storage Engine”
    Section 13.5, “The MyISAM Storage Engine”
    Section 7.5.5, “The MySQL Query Cache”
    Section 2.3.2, “Typical configure Options”
    Section 1.2, “Typographical and Syntax Conventions”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 4.2.3.3, “Using Option Files”
    Section 5.5.6.2, “Using SSL Connections”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
    Section 22.2.5, “Writing Plugins”
    Section 21.8, “libmysqld, the Embedded MySQL Server Library”

    configure --help

    Section 2.3.2, “Typical configure Options”

    configure.js

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.3.2, “Typical configure Options”

    connect [db_name host_name]]

    Section 4.5.1.2, “mysql Commands”

    copy

    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

    coreadm

    Section 5.1.2, “Server Command Options”

    cp

    Section 6.1, “Backup and Recovery Types”
    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
    Section 22.2.5, “Writing Plugins”

    crash-me

    Section 7.1.2, “Designing Applications for Portability”
    Section 7.1.3, “The MySQL Benchmark Suite”

    cron

    Section 12.4.2.3, “CHECK TABLE Syntax”
    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section 13.5.1, “MyISAM Startup Options”
    Section 5.2.6, “Server Log Maintenance”
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
    Section 3.5, “Using mysql in Batch Mode”

    csh

    Section 4.2.1, “Invoking MySQL Programs”
    Section 4.2.4, “Setting Environment Variables”
    Section 1.2, “Typographical and Syntax Conventions”

    delimiter str

    Section 4.5.1.2, “mysql Commands”

    df

    Section B.5.1, “How to Determine What Is Causing a Problem”

    drwtsn32.exe

    Section 22.5.1.3, “Using pdb to create a Windows crashdump”

    dump

    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

    dyld

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”

    ecc/icc

    Section 22.5, “Debugging and Porting MySQL”

    edit

    Section 4.5.1.2, “mysql Commands”

    ego

    Section 4.5.1.2, “mysql Commands”

    exit

    Section 4.5.1.2, “mysql Commands”

    g++

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    gcc

    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 21.8.1, “Compiling Programs with libmysqld”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section 2.3, “MySQL Installation Using a Source Distribution”
    Section 22.5, “Debugging and Porting MySQL”
    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
    Section 13.6, “The InnoDB Storage Engine”
    Section 2.3.2, “Typical configure Options”

    gcc-c++

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    gdb

    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 22.5.1.4, “Debugging mysqld under gdb”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    gmake

    Section 2.3.3, “Installing from the Development Source Tree”

    gnutar

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.3, “MySQL Installation Using a Source Distribution”

    go

    Section 4.5.1.2, “mysql Commands”

    gpg

    Section 2.1.4.2, “Signature Checking Using GnuPG”

    gpg --import

    Section 2.1.4.2, “Signature Checking Using GnuPG”

    grep

    Description
    Section 3.3.4.7, “Pattern Matching”

    groupadd

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.3.1, “Source Installation Overview”

    gtar

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.8, “Installing MySQL on Solaris”
    Section 2.3, “MySQL Installation Using a Source Distribution”

    gunzip

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.3.1, “Source Installation Overview”

    gzip

    Section 1.7, “How to Report Bugs or Problems”
    Section 2.7, “Installing MySQL on Mac OS X”

    gzip --fast

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    hdparm

    Section 13.6.3, “InnoDB Startup Options and System Variables”

    help [arg]

    Section 4.5.1.2, “mysql Commands”

    help contents

    Section 4.5.1.3, “mysql Server-Side Help”

    hostname

    Section B.5.2.2, “Can't connect to [local] MySQL server”

    ibbackup

    Section 6.1, “Backup and Recovery Types”

    icc

    Section 2.1.6, “Compiler-Specific Build Characteristics”
    Section 22.5, “Debugging and Porting MySQL”
    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    innochecksum

    Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
    Description
    Section 4.1, “Overview of MySQL Programs”

    innochecksum [options] file_name

    Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”

    iptables

    Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”

    isamchk

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 6.6, “MyISAM Table Maintenance and Crash Recovery”
    Section 13.5.3.3, “Compressed Table Characteristics”
    Description
    Description
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 4.1, “Overview of MySQL Programs”

    isamchk -rq

    Description

    isamchk -r

    Section 4.6.3.3, “myisamchk Repair Options”

    isamchk [options] tbl_name

    Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”

    isamlog

    Description
    Section 4.1, “Overview of MySQL Programs”

    isamlog [options] [log_file [tbl_name] ...]

    Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”

    kill

    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Description
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”

    kill -9

    Section D.5, “Restrictions on XA Transactions”

    kswapd

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    ld-elf.so.1

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”

    ld.so

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”

    ldconfig

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”

    less

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”

    libtool

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 2.3.3, “Installing from the Development Source Tree”
    Section 2.3, “MySQL Installation Using a Source Distribution”
    Section 22.2.5, “Writing Plugins”

    ln

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”

    lockd

    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”

    logger

    Description
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    ls

    Section 6.2, “Database Backup Methods”

    m4

    Section 2.3.3, “Installing from the Development Source Tree”

    make

    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Section 2.3.3, “Installing from the Development Source Tree”
    Section 2.3, “MySQL Installation Using a Source Distribution”
    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
    Section 2.3.2, “Typical configure Options”
    Section 22.2.5, “Writing Plugins”

    make install

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    make perl

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    make realclean

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    make test

    Section 2.3.3, “Installing from the Development Source Tree”

    make -f Makefile.aperl inst_perl MAP_TARGET=perl

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    make -k

    Section 2.3.2, “Typical configure Options”

    make distclean

    Section 2.3.4, “Dealing with Problems Compiling MySQL”

    make install

    Section 2.3.3, “Installing from the Development Source Tree”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.3.1, “Source Installation Overview”
    Section 13.6, “The InnoDB Storage Engine”
    Section 22.2.5, “Writing Plugins”

    make perl

    Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

    make test

    Section 2.15.1, “Installing Perl on Unix”
    Section 2.3.3, “Installing from the Development Source Tree”
    Section 22.1.2, “MySQL Test Suite”

    make_binary_distribution

    Section 4.1, “Overview of MySQL Programs”

    make_win_bin_dist

    Section 4.4.2, “make_win_bin_dist — Package MySQL Distribution as ZIP Archive”
    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Description
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 4.1, “Overview of MySQL Programs”

    make_win_bin_dist [options] package_basename [copy_def ...]

    Section 4.4.2, “make_win_bin_dist — Package MySQL Distribution as ZIP Archive”

    make_win_src_distribution

    Section 4.1, “Overview of MySQL Programs”

    md5

    Section 2.1.4.1, “Verifying the MD5 Checksum”

    md5sum

    Section 2.1.4.1, “Verifying the MD5 Checksum”

    memcached

    Chapter 14, High Availability and Scalability
    Section 14.5, “Using MySQL with memcached”

    mkdir

    Section 12.1.10, “CREATE DATABASE Syntax”

    more

    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”

    msiexec.exe

    Section 2.5.3.2, “Installing MySQL Automatically using MSI”

    msql2mysql

    Section 4.7.1, “msql2mysql — Convert mSQL Programs for Use with MySQL”
    Description
    Description
    Section 4.1, “Overview of MySQL Programs”

    msql2mysqlC-source-file ...

    Section 4.7.1, “msql2mysql — Convert mSQL Programs for Use with MySQL”

    my_print_defaults

    Section 4.7.3, “my_print_defaults — Display Options from Option Files”
    Description
    Section 4.7, “MySQL Program Development Utilities”
    Section 4.1, “Overview of MySQL Programs”

    my_print_defaults [options] option_group ...

    Section 4.7.3, “my_print_defaults — Display Options from Option Files”

    myisam_ftdump

    Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
    Description
    Section 11.8, “Full-Text Search Functions”
    Section 4.1, “Overview of MySQL Programs”

    myisam_ftdump [options] tbl_name index_num

    Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”

    myisamchk

    Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.1, “myisamchk General Options”
    Section 4.6.3.6, “myisamchk Memory Usage”
    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.6.3.5, “myisamchk Table Information”
    Section 12.2.2, “DELETE Syntax”
    Section 13.5.1, “MyISAM Startup Options”
    Section 6.6, “MyISAM Table Maintenance and Crash Recovery”
    Section 6.6.4, “MyISAM Table Optimization”
    Section 12.4.2.6, “REPAIR TABLE Syntax”
    Section 2.5.3.1.2, “Choosing an Install Type”
    Section 13.5.3.3, “Compressed Table Characteristics”
    Section 13.5.4.1, “Corrupted MyISAM Tables”
    Section 6.2, “Database Backup Methods”
    Section 22.5.1, “Debugging a MySQL Server”
    Description
    Description
    Description
    Section 7.3.4, “External Locking”
    Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
    Section 6.6.2, “How to Check MyISAM Tables for Errors”
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 1.7, “How to Report Bugs or Problems”
    Section 4.6.3.4, “Other myisamchk Options”
    Section 7.2.24, “Other Optimization Tips”
    Section 4.1, “Overview of MySQL Programs”
    Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
    Section 18.5, “Restrictions and Limitations on Partitioning”
    Section 5.1.2, “Server Command Options”
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
    Section 7.2.21, “Speed of INSERT Statements”
    Section 13.5.3.1, “Static (Fixed-Length) Table Characteristics”
    Section 7.5.2, “System Factors and Startup Parameter Tuning”
    Section 13.5, “The MyISAM Storage Engine”
    Section 6.6.1, “Using myisamchk for Crash Recovery”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
    Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    myisamchk --analyze

    Section 12.4.2.1, “ANALYZE TABLE Syntax”
    Section 7.2.1, “Optimizing Queries with EXPLAIN”

    myisamchk --description --verbose

    Section 7.2.3, “Speed of SELECT Queries”

    myisamchk --help

    Section 4.6.3.1, “myisamchk General Options”

    myisamchk --medium-check tbl_name

    Section 12.4.2.3, “CHECK TABLE Syntax”

    myisamchk --recover

    Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”

    myisamchk --safe-recover

    Section 12.4.2.6, “REPAIR TABLE Syntax”

    myisamchk --safe-recover tbl_name

    Section 6.6.3, “How to Repair MyISAM Tables”

    myisamchk --stats_method=method_name --analyze

    Section 7.4.7, “MyISAM Index Statistics Collection”

    myisamchk --unpack

    Section 13.5.3, “MyISAM Table Storage Formats”

    myisamchk --update-state

    Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”

    myisamchk -a

    Section 4.6.3.5, “myisamchk Table Information”

    myisamchk -r

    Section 6.2, “Database Backup Methods”

    myisamchk *.MYI

    Section 6.6.3, “How to Repair MyISAM Tables”

    myisamchk --analyze

    Section 12.4.2.1, “ANALYZE TABLE Syntax”
    Section 7.2.3, “Speed of SELECT Queries”
    Section 13.5, “The MyISAM Storage Engine”

    myisamchk --description --verbose tbl_name

    Section 4.6.3.4, “Other myisamchk Options”

    myisamchk --fast

    Section 13.5, “The MyISAM Storage Engine”

    myisamchk --help

    Description

    myisamchk --keys-used=0 -rq /path/to/db/tbl_name.

    Section 7.2.21, “Speed of INSERT Statements”

    myisamchk --medium-check

    Section 4.6.3.2, “myisamchk Check Options”

    myisamchk --recover --quick

    Section 12.4.2.6, “REPAIR TABLE Syntax”

    myisamchk --recover tbl_name

    Section 12.4.2.6, “REPAIR TABLE Syntax”

    myisamchk --recover --quick

    Section 12.4.2.6, “REPAIR TABLE Syntax”

    myisamchk --safe-recover

    Section 12.4.2.6, “REPAIR TABLE Syntax”

    myisamchk --silent --force */*.MYI

    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    myisamchk --sort-index --sort-records=1

    Section 7.2.3, “Speed of SELECT Queries”

    myisamchk -a

    Section 12.4.5.23, “SHOW INDEX Syntax”

    myisamchk -d tbl_name

    Section 4.6.3.5, “myisamchk Table Information”

    myisamchk -dv

    Section 12.4.6.5, “LOAD INDEX INTO CACHE Syntax”

    myisamchk -dv /path/to/table-index-file

    Section B.5.2.12, “The table is full”

    myisamchk -dv tbl_name

    Section 4.6.3.6, “myisamchk Memory Usage”
    Section 4.6.3.5, “myisamchk Table Information”

    myisamchk -dvv

    Section 4.6.3.5, “myisamchk Table Information”
    Section 12.4.5.38, “SHOW TABLE STATUS Syntax”
    Description

    myisamchk -dvv tbl_name

    Section 9.5, “Character Set Configuration”

    myisamchk -e *.MYI

    Section 6.6.3, “How to Repair MyISAM Tables”

    myisamchk -ed

    Section 13.5.3.2, “Dynamic Table Characteristics”

    myisamchk -ei

    Section 13.5.3.2, “Dynamic Table Characteristics”

    myisamchk -eis tbl_name

    Section 4.6.3.5, “myisamchk Table Information”

    myisamchk -eiv

    Section 4.6.3.5, “myisamchk Table Information”

    myisamchk -eiv tbl_name

    Section 4.6.3.5, “myisamchk Table Information”

    myisamchk -r

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 13.5.3.2, “Dynamic Table Characteristics”
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 13.5.3.1, “Static (Fixed-Length) Table Characteristics”

    myisamchk -r database/table.MYI

    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”

    myisamchk -r tbl_name

    Section 6.6.3, “How to Repair MyISAM Tables”

    myisamchk -r -q

    Section 6.6.3, “How to Repair MyISAM Tables”

    myisamchk -r -q --set-character-set=charset_name

    Section 2.3.2, “Typical configure Options”
    Section 2.4.1, “Upgrading MySQL”

    myisamchk -r -q tbl_name

    Section 6.6.3, “How to Repair MyISAM Tables”

    myisamchk -rq

    Description
    Description

    myisamchk -rq /path/to/db/tbl_name

    Section 7.2.21, “Speed of INSERT Statements”

    myisamchk -s

    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”

    myisamchk -s database/*.MYI

    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”

    myisamchk [options] tbl_name ...

    Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”

    myisamlog

    Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”
    Description
    Section 4.1, “Overview of MySQL Programs”

    myisamlog [options] [log_file [tbl_name] ...]

    Section 4.6.4, “myisamlog — Display MyISAM Log File Contents”

    myisampack

    Section 4.6.3.3, “myisamchk Repair Options”
    Section 4.6.3.5, “myisamchk Table Information”
    Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
    Section 12.1.17, “CREATE TABLE Syntax”
    Section 13.8.1, “MERGE Table Advantages and Disadvantages”
    Section 13.5.3, “MyISAM Table Storage Formats”
    Section B.5.2.12, “The table is full”
    Section 13.5.3.3, “Compressed Table Characteristics”
    Description
    Section 7.3.4, “External Locking”
    Section 4.1, “Overview of MySQL Programs”
    Section 12.1.17.1, “Silent Column Specification Changes”
    Section 7.2.21, “Speed of INSERT Statements”
    Section 13.8, “The MERGE Storage Engine”
    Section 13.5, “The MyISAM Storage Engine”

    myisampack [options] file_name ...

    Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

    mysql

    Section 1.8.5.5, “'--' as the Start of a Comment”
    Section 4.5.1, “mysql — The MySQL Command-Line Tool”
    Section 4.5.1.2, “mysql Commands”
    Section 4.5.1.1, “mysql Options”
    Section 4.5.1.3, “mysql Server-Side Help”
    Section 4.5.1.5, “mysql Tips”
    Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    Section 13.6.4.4, “FOREIGN KEY Constraints”
    Section 12.8.3, “HELP Syntax”
    Section B.5.2.15, “Ignoring user”
    Section 7.2.17, “LIMIT Optimization”
    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
    Section B.5.2.8, “Out of memory”
    Section B.5.2.10, “Packet too large”
    Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
    Section 12.4.5.36, “SHOW SLAVE STATUS Syntax”
    Section 21.9.3.14, “mysql_errno()”
    Section 21.9.3.66, “mysql_sqlstate()”
    Section 17.5.11.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.5.11.1, “Adding MySQL Cluster Data Nodes Online: General Issues”
    Section 5.5.2, “Adding User Accounts”
    Section 11.13.5, “Analyzing Spatial Information”
    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Section 6.1, “Backup and Recovery Types”
    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 2.5.3.1.5, “Changes Made by MySQL Installation Wizard”
    Section 17.7, “Changes in MySQL Cluster NDB 6.X and 7.X”
    Section 2.5.3.1.2, “Choosing an Install Type”
    Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Section 8.5, “Comment Syntax”
    Section 9.1.5, “Configuring the Character Set and Collation for Applications”
    Section 4.6.10.6, “Connecting to MySQL Instance Manager”
    Section 3.1, “Connecting to and Disconnecting from the Server”
    Section 4.2.2, “Connecting to the MySQL Server”
    Section 9.1.4, “Connection Character Sets and Collations”
    Section 21.9.11, “Controlling Automatic Reconnection Behavior”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Section 3.3.1, “Creating and Selecting a Database”
    Section 13.6.2.3, “Creating the InnoDB Tablespace”
    Section 22.5.2, “Debugging a MySQL Client”
    Section 19.1, “Defining Stored Programs”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 4.5.1.5.3, “Disabling mysql Auto-Reconnect”
    Section 2.4.2, “Downgrading MySQL”
    Section 5.3.2.2, “End-User Guidelines for Password Security”
    Section 3.2, “Entering Queries”
    Section 2.14, “Environment Variables”
    Section 6.3, “Example Backup and Recovery Strategy”
    Section 3.6, “Examples of Common Queries”
    Section 4.5.1.4, “Executing SQL Statements from a Text File”
    Chapter 11, Functions and Operators
    Section B.5.1, “How to Determine What Is Causing a Problem”
    Section 1.7, “How to Report Bugs or Problems”
    Section 5.3.6, “How to Run MySQL as a Normal User”
    Section 11.11.3, “Information Functions”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
    Section 17.2.4, “Loading Sample Data into MySQL Cluster and Performing Queries”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 6.4.5.1, “Making a Copy of a Database”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 1.5, “What Is New in MySQL 5.1”
    Chapter 17, MySQL Cluster NDB 6.X/7.X
    Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
    Section 17.5.10.1, “MySQL Cluster Disk Data Objects”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    Section 2.7.5, “MySQL Installation on Mac OS X Notes”
    Section 9.6, “MySQL Server Time Zone Support”
    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    Section B.5.8.1, “Open Issues in MySQL”
    Section 7.2, “Optimizing SELECT and Other Statements”
    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.3.2.3, “Password Hashing in MySQL”
    Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
    Section 17.6.5, “Preparing the MySQL Cluster for Replication”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
    Section 2.13.1.1, “Problems Running mysql_install_db”
    Section 4.2.3.2, “Program Option Modifiers”
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section 6.4.4, “Reloading Delimited-Text Format Backups”
    Section 6.4.2, “Reloading SQL-Format Backups”
    Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
    Section 12.2.9.11, “Rewriting Subqueries as Joins”
    Section 12.6, “SQL Syntax for Prepared Statements”
    Section 2.13.2, “Securing the Initial MySQL Accounts”
    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”
    Section 5.3.4, “Security-Related mysqld Options”
    Section B.3, “Server Error Codes and Messages”
    Section 5.1.4, “Server System Variables”
    Section 5.1.8, “Server-Side Help”
    Section 4.2.3, “Specifying Program Options”
    Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 2.5.5.7, “Testing The MySQL Installation”
    Section 10.4.3, “The BLOB and TEXT Types”
    Section 17.5.8, “The ndbinfo MySQL Cluster Information Database”
    Section 5.2.4, “The Binary Log”
    Section 19.3.1, “Trigger Syntax”
    Section 13.6.13.4, “Troubleshooting InnoDB Data Dictionary Operations”
    Chapter 3, Tutorial
    Section 2.3.2, “Typical configure Options”
    Section 1.2, “Typographical and Syntax Conventions”
    Section 2.4.1, “Upgrading MySQL”
    Section 3.5, “Using mysql in Batch Mode”
    Section 6.4, “Using mysqldump for Backups”
    Section 6.3.2, “Using Backups for Recovery”
    Section 4.2.3.3, “Using Option Files”
    Section 4.2.3.1, “Using Options on the Command Line”
    Section 4.2.3.4, “Using Options to Set Program Variables”
    Section 5.5.6.2, “Using SSL Connections”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
    Section 17.5.10.2, “Using Symbolic Links with Disk Data Objects”
    Section 4.5.1.5.2, “Using the --safe-updates Option”
    Section 2.5.8, “Windows Post-Installation Procedures”
    Section 11.10, “XML Functions”

    mysql --help

    Section 4.1, “Overview of MySQL Programs”

    mysql -u root mysql

    Section 2.13.1.1, “Problems Running mysql_install_db”

    mysql ... --debug

    Section 22.5.1.1, “Compiling MySQL for Debugging”

    mysql < file_name

    Section 8.5, “Comment Syntax”

    mysql [options] db_name

    Section 4.5.1, “mysql — The MySQL Command-Line Tool”

    mysql mysql < /tmp/mysql.dump

    Section 2.4.2.1, “Downgrading to MySQL 5.0”

    mysql {start|stop}

    Section 4.3.3, “mysql.server — MySQL Server Startup Script”

    mysql-test-run

    Section 22.1.2, “MySQL Test Suite”

    mysql-test-run.pl

    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 22.1.2, “MySQL Test Suite”

    mysql.server

    Section 4.3.3, “mysql.server — MySQL Server Startup Script”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Description
    Description
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.1.2, “Server Command Options”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
    Section 5.2.3, “The General Query Log”
    Section B.5.4.6, “Time Zone Problems”

    mysql.server stop

    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”

    mysql_config

    Section 4.7.2, “mysql_config — Get Compile Options for Compiling Clients”
    Section 21.9.16, “Building Client Programs”
    Section 21.8.1, “Compiling Programs with libmysqld”
    Description
    Section 4.1, “Overview of MySQL Programs”
    Section B.5.3.1, “Problems Linking to the MySQL Client Library”

    mysql_config --libmysqld-libs

    Section 21.8.1, “Compiling Programs with libmysqld”

    mysql_config --plugindir

    Section 22.2.2, “Plugin API Components”

    mysql_config options

    Section 4.7.2, “mysql_config — Get Compile Options for Compiling Clients”

    mysql_convert_table_format

    Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”
    Description
    Section 4.1, “Overview of MySQL Programs”

    mysql_convert_table_format [options] db_name

    Section 4.6.11, “mysql_convert_table_format — Convert Tables to Use a Given Storage Engine”

    mysql_create_system_tables

    Section 4.1, “Overview of MySQL Programs”

    mysql_explain_log

    Section 4.1, “Overview of MySQL Programs”

    mysql_find_rows

    Section 4.6.12, “mysql_find_rows — Extract SQL Statements from Files”
    Description
    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
    Section 4.1, “Overview of MySQL Programs”

    mysql_find_rows [options] [file_name ...]

    Section 4.6.12, “mysql_find_rows — Extract SQL Statements from Files”

    mysql_fix_extensions

    Section 4.6.13, “mysql_fix_extensions — Normalize Table File Name Extensions”
    Description
    Section 4.1, “Overview of MySQL Programs”

    mysql_fix_extensions data_dir

    Section 4.6.13, “mysql_fix_extensions — Normalize Table File Name Extensions”

    mysql_fix_privilege_tables

    Section 4.4.4, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”
    Section 12.4.3.2, “CREATE FUNCTION Syntax”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Description
    Description
    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.3.2.3, “Password Hashing in MySQL”
    Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    mysql_fix_privilege_tables --password=root_password

    Section 4.4.4, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”

    mysql_fix_privilege_tables [options]

    Section 4.4.4, “mysql_fix_privilege_tables — Upgrade MySQL System Tables”

    mysql_install_db

    Section 4.4.5, “mysql_install_db — Initialize MySQL Data Directory”
    Section 5.5.2, “Adding User Accounts”
    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section C.1.33, “Changes in MySQL 5.1.21 (16 August 2007)”
    Description
    Section 2.1.5, “Installation Layouts”
    Section 2.7.1, “Installing MySQL Using the Installation Package”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    Section 4.1, “Overview of MySQL Programs”
    Section 2.13.1.1, “Problems Running mysql_install_db”
    Section 13.6.14, “Restrictions on InnoDB Tables”
    Section 2.13.2, “Securing the Initial MySQL Accounts”
    Section 5.1.2, “Server Command Options”
    Section 5.1.8, “Server-Side Help”
    Section 2.3.1, “Source Installation Overview”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 2.7.4, “Using MySQL on Mac OS X Server”
    Section 2.5.8, “Windows Post-Installation Procedures”

    mysql_install_db [options]

    Section 4.4.5, “mysql_install_db — Initialize MySQL Data Directory”

    mysql_secure_installation

    Section 4.4.6, “mysql_secure_installation — Improve MySQL Installation Security”
    Description
    Section 4.1, “Overview of MySQL Programs”

    mysql_setpermission

    Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”
    Description
    Section 4.1, “Overview of MySQL Programs”

    mysql_setpermission [options]

    Section 4.6.14, “mysql_setpermission — Interactively Set Permissions in Grant Tables”

    mysql_setpermissions

    Description

    mysql_stmt_execute()

    Section 5.1.6, “Server Status Variables”

    mysql_stmt_prepare()

    Section 5.1.6, “Server Status Variables”

    mysql_tableinfo

    Section 4.1, “Overview of MySQL Programs”

    mysql_tzinfo_to_sql

    Section 4.4.7, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
    Description
    Section 9.6, “MySQL Server Time Zone Support”
    Section 4.1, “Overview of MySQL Programs”

    mysql_tzinfo_to_sql arguments

    Section 4.4.7, “mysql_tzinfo_to_sql — Load the Time Zone Tables”

    mysql_upgrade

    Section 4.4.8, “mysql_upgrade — Check Tables for MySQL Upgrade”
    Section 12.1.1, “ALTER DATABASE Syntax”
    Section 12.1.11, “CREATE EVENT Syntax”
    Section 12.4.3.2, “CREATE FUNCTION Syntax”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 2.4.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
    Description
    Description
    Description
    Section 2.4.2, “Downgrading MySQL”
    Section 1.5, “What Is New in MySQL 5.1”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.3.2.3, “Password Hashing in MySQL”
    Section 22.2.2, “Plugin API Components”
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
    Section 22.2, “The MySQL Plugin API”
    Section 2.4.1, “Upgrading MySQL”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    mysql_upgrade

    Description

    mysql_upgrade [options]

    Section 4.4.8, “mysql_upgrade — Check Tables for MySQL Upgrade”

    mysql_waitpid

    Section 4.6.15, “mysql_waitpid — Kill Process and Wait for Its Termination”
    Description
    Section 4.1, “Overview of MySQL Programs”

    mysql_waitpid [options] pid wait_time

    Section 4.6.15, “mysql_waitpid — Kill Process and Wait for Its Termination”

    mysql_waitpid()

    Description

    mysql_zap

    Section 4.6.16, “mysql_zap — Kill Processes That Match a Pattern”
    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Description
    Section 4.1, “Overview of MySQL Programs”

    mysql_zap [-signal] [-?Ift] pattern

    Section 4.6.16, “mysql_zap — Kill Processes That Match a Pattern”

    mysqlaccess

    Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Description
    Section 1.7, “How to Report Bugs or Problems”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 4.1, “Overview of MySQL Programs”

    mysqlaccess [host_name [user_name [db_name]]] [options]

    Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”

    mysqladmin

    Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
    Section 12.1.10, “CREATE DATABASE Syntax”
    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section 12.1.21, “DROP DATABASE Syntax”
    Section 12.4.6.3, “FLUSH Syntax”
    Section 5.5.5, “Assigning Account Passwords”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Description
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 1.7, “How to Report Bugs or Problems”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 2.9, “Installing MySQL on i5/OS”
    Section 2.7.5, “MySQL Installation on Mac OS X Notes”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 2.13.2, “Securing the Initial MySQL Accounts”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”
    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”
    Section 5.1.10, “The Shutdown Process”
    Section 7.5.3, “Tuning Server Parameters”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 2.5.7, “Upgrading MySQL on Windows”
    Section 4.2.3.3, “Using Option Files”

    mysqladmin --sleep

    Section 2.3.5, “MIT-pthreads Notes”

    mysqladmin debug

    Section 12.4.1.3, “GRANT Syntax”

    mysqladmin flush-hosts

    Section 7.5.11, “How MySQL Uses DNS”

    mysqladmin flush-logs

    Section 5.2, “MySQL Server Logs”
    Section 5.2.4, “The Binary Log”

    mysqladmin flush-privileges

    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 2.13.1.1, “Problems Running mysql_install_db”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.4.6, “When Privilege Changes Take Effect”

    mysqladmin flush-tables

    Description
    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 7.2.21, “Speed of INSERT Statements”

    mysqladmin flush-xxx

    Section 5.5.2, “Adding User Accounts”

    mysqladmin kill

    Section B.5.4.3, “How MySQL Handles a Full Disk”

    mysqladmin password

    Section 5.5.5, “Assigning Account Passwords”

    mysqladmin processlist

    Section 5.3.3, “Making MySQL Secure Against Attackers”

    mysqladmin processlist status

    Section 22.5.1, “Debugging a MySQL Server”

    mysqladmin refresh

    Section 5.5.2, “Adding User Accounts”
    Section B.5.8.2, “Additional Known Issues”
    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section B.5.8.1, “Open Issues in MySQL”

    mysqladmin reload

    Section 2.13.1.1, “Problems Running mysql_install_db”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 5.1.2, “Server Command Options”
    Section 5.5.4, “Setting Account Resource Limits”

    mysqladmin shutdown

    Section 5.4.5, “Access Control, Stage 2: Request Verification”
    Section 5.3.6, “How to Run MySQL as a Normal User”
    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
    Section 16.4.1.19, “Replication and Temporary Tables”
    Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”

    mysqladmin variables

    Section B.5.2.9, “MySQL server has gone away”

    mysqladmin ver

    Section 22.5.1.1, “Compiling MySQL for Debugging”

    mysqladmin version

    Section B.5.2.2, “Can't connect to [local] MySQL server”

    mysqladmin --sleep

    Section 2.3.5, “MIT-pthreads Notes”

    mysqladmin -h localhost variables

    Section B.5.2.2, “Can't connect to [local] MySQL server”

    mysqladmin -i 5 -r status

    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    mysqladmin -i 5 status

    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    mysqladmin -i10 processlist status

    Section 22.5.1, “Debugging a MySQL Server”

    mysqladmin -u root ping

    Section B.5.1, “How to Determine What Is Causing a Problem”

    mysqladmin -u root processlist

    Section B.5.1, “How to Determine What Is Causing a Problem”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    mysqladmin -u root processlist

    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    mysqladmin [options] command [command-options] [command [command-options]] ...

    Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

    mysqladmin debug

    Section 12.4.5.34, “SHOW SCHEDULER STATUS Syntax”
    Section 22.5.1, “Debugging a MySQL Server”
    Section 5.4.1, “Privileges Provided by MySQL”

    mysqladmin extended-status

    Section 12.2.5.2, “INSERT DELAYED Syntax”
    Section 12.4.5.37, “SHOW STATUS Syntax”

    mysqladmin flush-hosts

    Section B.5.2.6, “Host 'host_name' is blocked”
    Section 5.4.7, “Causes of Access-Denied Errors”

    mysqladmin flush-logs

    Section 6.3.1, “Backup Policy”
    Section 6.3.3, “Backup Strategy Summary”
    Section 5.2.6, “Server Log Maintenance”
    Section 16.2.2.1, “The Slave Relay Log”

    mysqladmin flush-privileges

    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Description
    Section 2.4.2.1, “Downgrading to MySQL 5.0”

    mysqladmin flush-tables

    Section 7.3.4, “External Locking”
    Section 6.6.1, “Using myisamchk for Crash Recovery”

    mysqladmin kill

    Section 12.4.6.4, “KILL Syntax”
    Section B.5.2.9, “MySQL server has gone away”
    Section 11.11.4, “Miscellaneous Functions”
    Section 2.5.9, “MySQL on Windows Compared to MySQL on Unix”
    Section 5.4.1, “Privileges Provided by MySQL”

    mysqladmin password

    Section 5.5.5, “Assigning Account Passwords”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Description

    mysqladmin processlist

    Section 12.4.6.4, “KILL Syntax”
    Section 12.4.5.31, “SHOW PROCESSLIST Syntax”
    Section 21.9.3.43, “mysql_list_processes()”
    Section 5.5.2, “Adding User Accounts”
    Section 7.5.6, “Examining Thread Information”
    Section 22.1.1, “MySQL Threads”
    Section 5.4.1, “Privileges Provided by MySQL”

    mysqladmin refresh

    Section B.5.8.2, “Additional Known Issues”
    Section 5.2, “MySQL Server Logs”
    Section B.5.8.1, “Open Issues in MySQL”
    Section 5.2.6, “Server Log Maintenance”

    mysqladmin reload

    Section 5.5.2, “Adding User Accounts”
    Description
    Section 1.7, “How to Report Bugs or Problems”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 5.4.6, “When Privilege Changes Take Effect”

    mysqladmin reload version

    Section 1.7, “How to Report Bugs or Problems”

    mysqladmin shutdown

    Section 12.4.1.3, “GRANT Syntax”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 22.5.1.2, “Creating Trace Files”
    Section 13.6.2.3, “Creating the InnoDB Tablespace”
    Description
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 2.7.1, “Installing MySQL Using the Installation Package”
    Section 2.7, “Installing MySQL on Mac OS X”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 2.5.9, “MySQL on Windows Compared to MySQL on Unix”
    Section 5.4.1, “Privileges Provided by MySQL”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 5.1.10, “The Shutdown Process”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    mysqladmin status

    Section 21.9.3.68, “mysql_stat()”
    Description
    Section 7.4.8, “How MySQL Opens and Closes Tables”

    mysqladmin variables

    Section 12.4.5.41, “SHOW VARIABLES Syntax”

    mysqladmin variables extended-status processlist

    Section 1.7, “How to Report Bugs or Problems”

    mysqladmin version

    Section B.5.2.9, “MySQL server has gone away”
    Section 1.7, “How to Report Bugs or Problems”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

    mysqlanalyze

    Description

    mysqlbinlog

    Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
    Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
    Section 4.6.7.2, “mysqlbinlog Row Event Display”
    Section 12.4.6.1, “BINLOG Syntax”
    Section 12.4.4, “SET Syntax”
    Section 12.4.5.3, “SHOW BINLOG EVENTS Syntax”
    Section 12.5.2.7, “START SLAVE Syntax”
    Section B.5.8.2, “Additional Known Issues”
    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Description
    Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
    Section 16.4.6, “How to Report Replication Bugs or Problems”
    Section 11.11.4, “Miscellaneous Functions”
    Section 1.5, “What Is New in MySQL 5.1”
    Section B.5.8.1, “Open Issues in MySQL”
    Section 4.1, “Overview of MySQL Programs”
    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
    Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
    Section 6.5.2, “Point-in-Time Recovery Using Event Positions”
    Section 6.5.1, “Point-in-Time Recovery Using Event Times”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.2.4, “The Binary Log”
    Section 16.2.2.1, “The Slave Relay Log”
    Section 6.3.2, “Using Backups for Recovery”

    mysqlbinlog --database=test

    Description

    mysqlbinlog binary-log-file | mysql

    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”

    mysqlbinlog --database=db2

    Description

    mysqlbinlog --database=test

    Description

    mysqlbinlog [options] log_file ...

    Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”

    mysqlbinlog|mysql

    Section B.5.8.2, “Additional Known Issues”
    Section B.5.8.1, “Open Issues in MySQL”

    mysqlbug

    Section 4.4.3, “mysqlbug — Generate Bug Report”
    Description
    Section 1.7, “How to Report Bugs or Problems”

    mysqlc

    Section 2.5.5.7, “Testing The MySQL Installation”

    mysqlcheck

    Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
    Section 12.1.1, “ALTER DATABASE Syntax”
    Section 6.6, “MyISAM Table Maintenance and Crash Recovery”
    Description
    Description
    Description
    Section 8.2.3, “Mapping of Identifiers to File Names”
    Section 4.1, “Overview of MySQL Programs”
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section 18.5, “Restrictions and Limitations on Partitioning”
    Section 13.5, “The MyISAM Storage Engine”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    mysqlcheck --all-databases --analyze

    Section 5.1.4, “Server System Variables”

    mysqlcheck --check-upgrade

    Section 2.4.3, “Checking Whether Tables or Indexes Must Be Rebuilt”

    mysqlcheck --check-upgrade

    Section 2.4.3, “Checking Whether Tables or Indexes Must Be Rebuilt”

    mysqlcheck --repair

    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”

    mysqlcheck [options] [db_name [tbl_name ...]]

    Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

    mysqld

    Section 4.6.3.2, “myisamchk Check Options”
    Section 4.6.3.1, “myisamchk General Options”
    Section 4.3.1, “mysqld — The MySQL Server”
    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 12.4.2.4, “CHECKSUM TABLE Syntax”
    Section 12.4.3.2, “CREATE FUNCTION Syntax”
    Section 12.1.20, “CREATE VIEW Syntax”
    Section B.5.2.2, “Can't connect to [local] MySQL server”
    Section B.5.2.13, “Can't create/write to file”
    Section B.5.2.17, “Can't initialize character set”
    Section B.5.2.4, “Client does not support authentication protocol”
    Section 12.4.6.3, “FLUSH Syntax”
    Section B.5.2.6, “Host 'host_name' is blocked”
    Section 12.2.5.2, “INSERT DELAYED Syntax”
    Section B.5.2.15, “Ignoring user”
    Section 13.6.2, “InnoDB Configuration”
    Section 13.6.13.3, “InnoDB General Troubleshooting”
    Section 13.6.3, “InnoDB Startup Options and System Variables”
    Section 12.4.6.4, “KILL Syntax”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 13.5.1, “MyISAM Startup Options”
    Section B.5.2.9, “MySQL server has gone away”
    Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
    Section B.5.2.10, “Packet too large”
    Section 12.2.8, “SELECT Syntax”
    Section 12.3.6, “SET TRANSACTION Syntax”
    Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
    Section 12.4.5.16, “SHOW ENGINE Syntax”
    Section 12.4.5.41, “SHOW VARIABLES Syntax”
    Section B.5.2.12, “The table is full”
    Section B.5.2.7, “Too many connections”
    Section 21.9.3.1, “mysql_affected_rows()”
    Section 21.9.3.49, “mysql_options()”
    Section 22.3, “Adding New Functions to MySQL”
    Section 22.4, “Adding New Procedures to MySQL”
    Section 22.3.2, “Adding a New User-Defined Function”
    Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”
    Section B.5.8.2, “Additional Known Issues”
    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Section 16.1.3.4, “Binary Log Options and Variables”
    Section 5.2.4.1, “Binary Logging Formats”
    Section 2.5.10.1, “Building MySQL from Source Using CMake and Visual Studio”
    Section 11.9, “Cast Functions and Operators”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 2.1.2.2, “Choosing a Distribution Format”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Section 8.5, “Comment Syntax”
    Section B.5.2.11, “Communication Errors and Aborted Connections”
    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 7.2.7, “Condition Pushdown Optimization”
    Section 13.6.4.3.2, “Configurable InnoDB Auto-Increment Locking”
    Section 13.5.4.1, “Corrupted MyISAM Tables”
    Section 22.5.1.2, “Creating Trace Files”
    Section 13.6.2.3, “Creating the InnoDB Tablespace”
    Section 13.6.2.4, “Dealing with InnoDB Initialization Problems”
    Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Section 22.5.1.4, “Debugging mysqld under gdb”
    Section 22.5.1, “Debugging a MySQL Server”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Description
    Section 2.14, “Environment Variables”
    Section 7.3.4, “External Locking”
    Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
    Section 13.6.6.2, “Forcing InnoDB Recovery”
    Section 7.5.6.2, “General Thread States”
    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
    Section 7.4.8, “How MySQL Opens and Closes Tables”
    Section 7.5.11, “How MySQL Uses DNS”
    Section 7.5.8, “How MySQL Uses Memory”
    Section 7.2.19, “How to Avoid Table Scans”
    Section B.5.1, “How to Determine What Is Causing a Problem”
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 1.7, “How to Report Bugs or Problems”
    Section 5.3.6, “How to Run MySQL as a Normal User”
    Section 8.2.2, “Identifier Case Sensitivity”
    Section 17.6.8, “Implementing Failover with MySQL Cluster Replication”
    Section 17.2.3, “Initial Startup of MySQL Cluster”
    Section 2.1.5, “Installation Layouts”
    Section 2.7.1, “Installing MySQL Using the Installation Package”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 2.9, “Installing MySQL on i5/OS”
    Section 17.1.5.8, “Issues Exclusive to MySQL Cluster”
    Section 17.6.3, “Known Issues in MySQL Cluster Replication”
    Section 2.3.5, “MIT-pthreads Notes”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
    Section 11.11.4, “Miscellaneous Functions”
    Section 5.2.4.3, “Mixed Binary Logging Format”
    MySQL 4.1 FAQ: MySQL Cluster
    Chapter 17, MySQL Cluster NDB 6.X/7.X
    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.1”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.2.2, “MySQL Cluster Multi-Computer Configuration”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
    Section 17.1, “MySQL Cluster Overview”
    Section 17.4, “MySQL Cluster Programs”
    Section 17.6.11, “MySQL Cluster Replication Conflict Resolution”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    Section 17.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”
    Section 17.3.4.1, “MySQL Cluster Server Option and Variable Reference”
    Section 17.3.4.3, “MySQL Cluster System Variables”
    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
    Chapter 5, MySQL Server Administration
    Section 5.2, “MySQL Server Logs”
    Section 9.6, “MySQL Server Time Zone Support”
    Section 17.4.1, “MySQL Server Usage for MySQL Cluster”
    Section 4.3, “MySQL Server and Server-Startup Programs”
    Section 22.1.2, “MySQL Test Suite”
    Section 22.1.1, “MySQL Threads”
    Section 2.5.9, “MySQL on Windows Compared to MySQL on Unix”
    Section B.5.8.1, “Open Issues in MySQL”
    Section B.5.6, “Optimizer-Related Issues”
    Section 21.8.3, “Options with the Embedded Server”
    Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
    Section 4.1, “Overview of MySQL Programs”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 22.2.4.3, “Plugin Status and System Variables”
    Section 22.5, “Debugging and Porting MySQL”
    Section 17.6.5, “Preparing the MySQL Cluster for Replication”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
    Section 5.4.2, “Privilege System Grant Tables”
    Section 2.13.1.1, “Problems Running mysql_install_db”
    Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
    Section B.5.3.2, “Problems with File Permissions”
    Section 4.2.3.2, “Program Option Modifiers”
    Section 7.5.5.3, “Query Cache Configuration”
    Section 17.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”
    Section 16.1.3.2, “Replication Master Options and Variables”
    Section 16.1.3.3, “Replication Slave Options and Variables”
    Section 16.1.3.1, “Replication and Binary Logging Option and Variable Reference”
    Section 16.1.3, “Replication and Binary Logging Options and Variables”
    Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
    Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
    Section B.5.5.5, “Rollback Failure for Nontransactional Tables”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 1.8.3, “Running MySQL in ANSI Mode”
    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”
    Section 5.3.4, “Security-Related mysqld Options”
    Section 1.8.2, “Selecting SQL Modes”
    Section 2.5.5.3, “Selecting a MySQL Server Type”
    Section 9.1.3.1, “Server Character Set and Collation”
    Section 5.1.2, “Server Command Options”
    Section 5.1.9, “Server Response to Signals”
    Section 5.1.7, “Server SQL Modes”
    Section 5.1.6, “Server Status Variables”
    Section 5.1.4, “Server System Variables”
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
    Section 9.2, “Setting the Error Message Language”
    Section 2.3.1, “Source Installation Overview”
    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
    Section 17.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”
    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
    Section 9.6.1, “Staying Current with Time Zone Changes”
    Section 7.3.2, “Table Locking Issues”
    Section B.5.2.19, “Table-Corruption Issues”
    Section 2.5.5.7, “Testing The MySQL Installation”
    The mysqld-max Extended MySQL Server
    Section 13.14, “The BLACKHOLE Storage Engine”
    Section 10.4.3, “The BLOB and TEXT Types”
    Section 13.5, “The MyISAM Storage Engine”
    Section 17.5.8, “The ndbinfo MySQL Cluster Information Database”
    Section 5.2.4, “The Binary Log”
    Section 5.2.2, “The Error Log”
    Section 5.2.3, “The General Query Log”
    Section 7.5.5, “The MySQL Query Cache”
    Section 5.1, “The MySQL Server”
    Section 5.2.5, “The Slow Query Log”
    Section B.5.4.6, “Time Zone Problems”
    Section 2.5.6, “Troubleshooting a MySQL Installation Under Windows”
    Section 7.5.3, “Tuning Server Parameters”
    Section 2.3.2, “Typical configure Options”
    Section 1.2, “Typographical and Syntax Conventions”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 2.4.1, “Upgrading MySQL”
    Section 2.5.7, “Upgrading MySQL on Windows”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 22.3.2.6, “User-Defined Function Security Precautions”
    Section 8.4, “User-Defined Variables”
    Section 6.6.1, “Using myisamchk for Crash Recovery”
    Section 22.5.1.3, “Using pdb to create a Windows crashdump”
    Section 2.7.4, “Using MySQL on Mac OS X Server”
    Section 4.2.3.3, “Using Option Files”
    Section 13.6.2.1, “Using Per-Table Tablespaces”
    Section 5.5.6.2, “Using SSL Connections”
    Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
    Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”
    Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
    Section 17.6.7, “Using Two Replication Channels for MySQL Cluster Replication”
    Section 22.5.1.5, “Using a Stack Trace”
    Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
    Section 5.4.6, “When Privilege Changes Take Effect”
    Section B.5.4.4, “Where MySQL Stores Temporary Files”
    Section 2.5.1, “Windows Installation Layout”
    Section 22.2.5, “Writing Plugins”

    mysqld --help

    Section 7.5.3, “Tuning Server Parameters”

    mysqld --print-defaults

    Section 22.5.1, “Debugging a MySQL Server”

    mysqld --remove

    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

    mysqld --console

    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”

    mysqld --help

    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 5.1.2, “Server Command Options”

    mysqld --no-defaults ...

    Section 22.5.1, “Debugging a MySQL Server”

    mysqld --print-defaults

    Section 2.4.1, “Upgrading MySQL”

    mysqld --verbose --help

    Section 5.1.2, “Server Command Options”
    Section 2.5.5.5, “Starting MySQL from the Windows Command Line”

    mysqld [options]

    Section 4.3.1, “mysqld — The MySQL Server”

    mysqld-

    Section 2.4.1, “Upgrading MySQL”

    mysqld-.13

    Section 2.4.1, “Upgrading MySQL”

    mysqld-abc.exe

    Description

    mysqld-debug

    Section 2.1.2.2, “Choosing a Distribution Format”
    Section 22.5.1.2, “Creating Trace Files”
    Description
    Section 2.5.5.3, “Selecting a MySQL Server Type”
    Section 5.1.2, “Server Command Options”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”

    mysqld-max

    Section 2.1.2.2, “Choosing a Distribution Format”
    Description
    Section 17.2.3, “Initial Startup of MySQL Cluster”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 4.1, “Overview of MySQL Programs”
    Section 2.5.5.3, “Selecting a MySQL Server Type”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
    The mysqld-max Extended MySQL Server
    Section 2.4.1, “Upgrading MySQL”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”

    mysqld-max-nt

    Section 2.5.5.3, “Selecting a MySQL Server Type”
    Section 5.1.2, “Server Command Options”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”

    mysqld-max.exe

    The mysqld-max Extended MySQL Server

    mysqld-nt

    Section 2.5.5.3, “Selecting a MySQL Server Type”
    Section 5.1.2, “Server Command Options”
    Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
    Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”

    mysqld-opt

    Section 2.5.5.3, “Selecting a MySQL Server Type”

    mysqld_multi

    Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
    Description
    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 4.1, “Overview of MySQL Programs”
    Section 5.6.2, “Running Multiple Servers on Unix”

    mysqld_multi [options] {start|stop|report} [GNR[,GNR] ...]

    Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

    mysqld_safe

    Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 13.6.13.3, “InnoDB General Troubleshooting”
    Section B.5.2.10, “Packet too large”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section B.5.8.2, “Additional Known Issues”
    Section 22.5.1.1, “Compiling MySQL for Debugging”
    Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
    Section 13.6.2.3, “Creating the InnoDB Tablespace”
    Description
    Description
    Description
    Section 7.5.9, “Enabling Large Page Support”
    Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 2.9, “Installing MySQL on i5/OS”
    Section 5.3.3, “Making MySQL Secure Against Attackers”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 9.6, “MySQL Server Time Zone Support”
    Section B.5.8.1, “Open Issues in MySQL”
    Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
    Section 4.1, “Overview of MySQL Programs”
    Section B.5.3.2, “Problems with File Permissions”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 5.6.2, “Running Multiple Servers on Unix”
    Section 5.1.2, “Server Command Options”
    Section 5.1.4, “Server System Variables”
    Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
    Section 2.3.1, “Source Installation Overview”
    Section 2.13.1.2, “Starting and Stopping MySQL Automatically”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
    Section 5.2.2, “The Error Log”
    Section B.5.4.6, “Time Zone Problems”
    Section 7.5.3, “Tuning Server Parameters”
    Section 2.13.1, “Unix Post-Installation Procedures”
    Section 2.4.1, “Upgrading MySQL”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 4.2.3.3, “Using Option Files”

    mysqld_safe options

    Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

    mysqldump

    Section 4.5.4, “mysqldump — A Database Backup Program”
    Section 6.4.5, “mysqldump Tips”
    Section 12.4.2.2, “BACKUP TABLE Syntax”
    Section 12.1.13, “CREATE INDEX Syntax”
    Section 12.1.20, “CREATE VIEW Syntax”
    Section 13.6.4.4, “FOREIGN KEY Constraints”
    Section 13.6.13.1, “InnoDB Performance Tuning Tips”
    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
    Section 12.4.3.5, “UNINSTALL PLUGIN Syntax”
    Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”
    Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
    Section 6.3.1, “Backup Policy”
    Section 6.3.3, “Backup Strategy Summary”
    Chapter 6, Backup and Recovery
    Section 6.1, “Backup and Recovery Types”
    Section 5.4.7, “Causes of Access-Denied Errors”
    Section 2.4.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
    Section 2.5.3.1.2, “Choosing an Install Type”
    Section 4.2.2, “Connecting to the MySQL Server”
    Section 6.4.5.2, “Copy a Database from one Server to Another”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump”
    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 6.2, “Database Backup Methods”
    Section 13.6.11.3, “Defragmenting a Table”
    Description
    Description
    Description
    Section 2.4.2, “Downgrading MySQL”
    Section 2.4.2.1, “Downgrading to MySQL 5.0”
    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
    Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
    Section 6.4.5.3, “Dumping Stored Programs”
    Section 6.4.5.4, “Dumping Table Definitions and Content Separately”
    Section 6.3, “Example Backup and Recovery Strategy”
    Section 1.8.5.4, “Foreign Keys”
    Section 1.7, “How to Report Bugs or Problems”
    Section 16.1.1, “How to Set Up Replication”
    Section 17.2.4, “Loading Sample Data into MySQL Cluster and Performing Queries”
    Section 6.4.5.1, “Making a Copy of a Database”
    Section 8.2.3, “Mapping of Identifiers to File Names”
    Section 13.6.7, “Moving an InnoDB Database to Another Machine”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 1.5, “What Is New in MySQL 5.1”
    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.1, “MySQL Cluster Overview”
    Section 17.5.3, “Online Backup of MySQL Cluster”
    Section 4.1, “Overview of MySQL Programs”
    Section 10.1.1, “Overview of Numeric Types”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
    Section 17.6.5, “Preparing the MySQL Cluster for Replication”
    Section B.5.5.8, “Problems with Floating-Point Values”
    Section 2.4.4, “Rebuilding or Repairing Tables or Indexes”
    Section 6.4.4, “Reloading Delimited-Text Format Backups”
    Section 6.4.2, “Reloading SQL-Format Backups”
    Section D.4, “Restrictions on Views”
    Section 5.1.7, “Server SQL Modes”
    Section 5.1.4, “Server System Variables”
    Section 16.1.1.8, “Setting Up Replication with Existing Data”
    Section 4.2.3, “Specifying Program Options”
    Section 2.5.5.6, “Starting MySQL as a Windows Service”
    Section 10.4.3, “The BLOB and TEXT Types”
    Section 7.4.6, “The InnoDB Buffer Pool”
    Section 9.6.2, “Time Zone Leap Second Support”
    Section 2.4.1, “Upgrading MySQL”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
    Section 6.4, “Using mysqldump for Backups”
    Section 6.4.5.5, “Using mysqldump to Test for Upgrade Incompatibilities”
    Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
    Section 11.10, “XML Functions”

    mysqldump --delete-master-logs

    Section 6.3.1, “Backup Policy”

    mysqldump --flush-logs

    Section 5.2.6, “Server Log Maintenance”

    mysqldump --master-data

    Section 16.1.1, “How to Set Up Replication”
    Section 5.2, “MySQL Server Logs”
    Section 16.1.1.4, “Obtaining the Replication Master Binary Log Coordinates”
    Section 5.2.6, “Server Log Maintenance”

    mysqldump --routines

    Section 2.4.2.1, “Downgrading to MySQL 5.0”

    mysqldump --xml

    Section 4.5.1.1, “mysql Options”

    mysqldump --flush-logs

    Section 6.2, “Database Backup Methods”
    Section 5.2, “MySQL Server Logs”

    mysqldump --help

    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Description

    mysqldump --master-data

    Section 16.1.1, “How to Set Up Replication”
    Section 16.4.4, “Replication FAQ”

    mysqldump --opt --add-drop-table mysql > /tmp/mysql.dump

    Section 2.4.2.1, “Downgrading to MySQL 5.0”

    mysqldump --quick db_name tbl_name_1 ... tbl_name_n > query.sql

    Section B.5.5.7, “Solving Problems with No Matching Rows”

    mysqldump --tab

    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
    Section 6.4.4, “Reloading Delimited-Text Format Backups”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    mysqldump -T

    Section 12.2.6, “LOAD DATA INFILE Syntax”

    mysqldump [options] [db_name [tbl_name ...]]

    Section 4.5.4, “mysqldump — A Database Backup Program”

    mysqldump mysql

    Section 5.4.7, “Causes of Access-Denied Errors”

    mysqldumpslow

    Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
    Description
    Section 4.1, “Overview of MySQL Programs”
    Section 5.2.5, “The Slow Query Log”

    mysqldumpslow [options] [log_file ...]

    Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”

    mysqlhotcopy

    Section 4.6.9, “mysqlhotcopy — A Database Backup Program”
    Section 12.4.2.2, “BACKUP TABLE Syntax”
    Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
    Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
    Chapter 6, Backup and Recovery
    Section 6.1, “Backup and Recovery Types”
    Section 6.2, “Database Backup Methods”
    Description
    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 4.1, “Overview of MySQL Programs”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    mysqlhotcopy --flushlog

    Section 6.2, “Database Backup Methods”

    mysqlhotcopy arguments

    Section 4.6.9, “mysqlhotcopy — A Database Backup Program”

    mysqlimport

    Section 4.5.5, “mysqlimport — A Data Import Program”
    Section 12.2.6, “LOAD DATA INFILE Syntax”
    Section 6.1, “Backup and Recovery Types”
    Section 2.4.5, “Copying MySQL Databases to Another Machine”
    Section 6.2, “Database Backup Methods”
    Description
    Section 2.4.2, “Downgrading MySQL”
    Section 4.1, “Overview of MySQL Programs”
    Section 6.4.4, “Reloading Delimited-Text Format Backups”
    Section 5.3.5, “Security Issues with LOAD DATA LOCAL”
    Section 2.4.1, “Upgrading MySQL”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    mysqlimport [options] db_name textfile1 ...

    Section 4.5.5, “mysqlimport — A Data Import Program”

    mysqlmanager

    Section 4.6.10, “mysqlmanager — The MySQL Instance Manager”
    Description
    Section 4.6.10.4, “Instance Manager User and Password Management”
    Section 4.6.10.1, “MySQL Instance Manager Command Options”
    Section 4.1, “Overview of MySQL Programs”
    Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”

    mysqlmanager [options]

    Section 4.6.10, “mysqlmanager — The MySQL Instance Manager”

    mysqloptimize

    Description

    mysqlrepair

    Description

    mysqlshow

    Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
    Section 12.4.5.15, “SHOW DATABASES Syntax”
    Section 4.2.2, “Connecting to the MySQL Server”
    Description
    Section 4.1, “Overview of MySQL Programs”
    Section 2.5.5.7, “Testing The MySQL Installation”
    Section 2.5.8, “Windows Post-Installation Procedures”

    mysqlshow --status db_name

    Section 12.4.5.38, “SHOW TABLE STATUS Syntax”

    mysqlshow -k db_name tbl_name

    Section 12.4.5.23, “SHOW INDEX Syntax”

    mysqlshow db_name

    Section 12.4.5.39, “SHOW TABLES Syntax”

    mysqlshow db_name tbl_name

    Section 12.4.5.6, “SHOW COLUMNS Syntax”

    mysqlshow [options] [db_name [tbl_name [col_name]]]

    Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”

    mysqlshow db_name

    Section 12.4.5.39, “SHOW TABLES Syntax”

    mysqlshow mysql user

    Section B.5.2.15, “Ignoring user”

    mysqlslap

    Section 4.5.7, “mysqlslap — Load Emulation Client”
    Description
    Section 1.5, “What Is New in MySQL 5.1”
    Section 4.1, “Overview of MySQL Programs”
    Section 7.1.4, “Using Your Own Benchmarks”

    mysqlslap [options]

    Section 4.5.7, “mysqlslap — Load Emulation Client”

    mysqltest

    Section 22.1.2, “MySQL Test Suite”

    ndb_config

    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
    Section 17.4, “MySQL Cluster Programs”

    ndb_config --configinfo

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    ndb_config --configinfo --xml

    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

    ndb_desc

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
    Section 17.5.10.1, “MySQL Cluster Disk Data Objects”
    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”
    Section 20.21, “The INFORMATION_SCHEMA FILES Table”

    ndb_desc -d db_name table_name

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    ndb_error_reporter

    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”

    ndb_mgm

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.5.11.1, “Adding MySQL Cluster Data Nodes Online: General Issues”
    Section 17.7, “Changes in MySQL Cluster NDB 6.X and 7.X”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Section 17.5.4, “Event Reports Generated in MySQL Cluster”
    Section 17.2.3, “Initial Startup of MySQL Cluster”
    MySQL 4.1 FAQ: MySQL Cluster
    Chapter 17, MySQL Cluster NDB 6.X/7.X
    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
    Section 17.5.4.1, “MySQL Cluster Logging Management Commands”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
    Section 17.4, “MySQL Cluster Programs”
    Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”
    Section 17.5.6, “MySQL Cluster Single User Mode”
    Section 17.5.3, “Online Backup of MySQL Cluster”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
    Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
    Section 17.5.8.6, “The ndbinfo memoryusage Table”
    Section 17.5.8.7, “The ndbinfo nodes Table”
    Section 17.5.8.10, “The ndbinfo transporters Table”
    Section 4.2.3.1, “Using Options on the Command Line”
    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    ndb_mgm -e "START BACKUP"

    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    ndb_mgm -e "START BACKUP"

    Section 17.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

    ndb_mgmd

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Section 17.3.2.5, “Defining a MySQL Cluster Management Server”
    Description
    Section 17.2.3, “Initial Startup of MySQL Cluster”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.5.4.1, “MySQL Cluster Logging Management Commands”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
    Section 17.4, “MySQL Cluster Programs”
    Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 17.3.1, “Quick Test Setup of MySQL Cluster”
    Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
    Section 17.5.1, “Summary of MySQL Cluster Start Phases”
    Section 17.3.2.3, “The MySQL Cluster Connectstring”

    ndb_restore

    Section 6.1, “Backup and Recovery Types”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.1.4, “MySQL Cluster Development History”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.1, “MySQL Cluster Overview”
    Section 17.4, “MySQL Cluster Programs”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    Section 17.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”
    Section 17.5.6, “MySQL Cluster Single User Mode”
    Section 17.5.3, “Online Backup of MySQL Cluster”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”

    ndb_schema

    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”

    ndb_select_all

    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”

    ndb_show_tables

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 17.4, “MySQL Cluster Programs”
    Section 17.6.4, “MySQL Cluster Replication Schema and Tables”
    Section 17.5.9.3, “MySQL Cluster and MySQL Security Procedures”

    ndb_size.pl

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 2.15, “Perl Installation Notes”

    ndbd

    Section 17.3.4.2, “mysqld Command Options for MySQL Cluster”
    Section 17.4.2, “ndbd — The MySQL Cluster Data Node Daemon”
    Section 17.5.11.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.5.2, “Commands in the MySQL Cluster Management Client”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Description
    Section 17.2.3, “Initial Startup of MySQL Cluster”
    Section 17.1.5.10, “Limitations Relating to Multiple MySQL Cluster Nodes”
    Section 17.5, “Management of MySQL Cluster”
    MySQL 4.1 FAQ: MySQL Cluster
    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
    Section 17.3.2.1, “MySQL Cluster Configuration: Basic Example”
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
    Section 17.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.3.5.2, “MySQL Cluster Interconnects and Performance”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
    Section 17.4, “MySQL Cluster Programs”
    Section 17.1.5.1, “Noncompliance with SQL Syntax in MySQL Cluster”
    Section 17.3.3, “Overview of MySQL Cluster Configuration Parameters”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
    Section 17.3.1, “Quick Test Setup of MySQL Cluster”
    Section 17.3.2.11, “SCI Transport Connections in MySQL Cluster”
    Section 17.2.5, “Safe Shutdown and Restart of MySQL Cluster”
    Section 17.5.1, “Summary of MySQL Cluster Start Phases”
    Section 17.5.8.7, “The ndbinfo nodes Table”
    Section 17.5.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
    Section 17.3.5, “Using High-Speed Interconnects with MySQL Cluster”

    ndbd --nostart

    Section 17.5.2, “Commands in the MySQL Cluster Management Client”

    ndbd --initial

    Section 17.5.2, “Commands in the MySQL Cluster Management Client”

    ndbd -n

    Section 17.5.2, “Commands in the MySQL Cluster Management Client”

    ndbd options

    Section 17.4.2, “ndbd — The MySQL Cluster Data Node Daemon”

    ndbinfo

    Section 17.5.8, “The ndbinfo MySQL Cluster Information Database”

    ndbmtd

    Section 17.5.11.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
    Section 17.5.11.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”
    Description
    Section 17.2.6.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
    Section 17.1.1, “MySQL Cluster Core Concepts”
    Section 17.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
    Section 17.1.4, “MySQL Cluster Development History”
    Section 17.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 17.4, “MySQL Cluster Programs”
    Section 17.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
    Section 17.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
    Section 17.1.5.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
    Section 17.5.8.7, “The ndbinfo nodes Table”

    ndbmtd.exe

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    nm

    Section 22.5.1.5, “Using a Stack Trace”

    nm --numeric-sort mysqld

    Description

    nopager

    Section 4.5.1.2, “mysql Commands”

    notee

    Section 4.5.1.2, “mysql Commands”

    nowarning

    Section 4.5.1.2, “mysql Commands”

    openssl

    Section 5.5.6.4, “Setting Up SSL Certificates for MySQL”

    openssl md5 package_name

    Section 2.1.4.1, “Verifying the MD5 Checksum”

    pack_isam

    Section 13.5.3.3, “Compressed Table Characteristics”
    Description
    Section 4.1, “Overview of MySQL Programs”
    Section 13.5, “The MyISAM Storage Engine”

    pack_isam [options] file_name

    Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”

    pager

    Section 4.5.1.2, “mysql Commands”

    pager [command]

    Section 4.5.1.2, “mysql Commands”

    perror

    Section 4.8.1, “perror — Explain Error Codes”
    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section B.5.2.13, “Can't create/write to file”
    Description
    Section 6.6.3, “How to Repair MyISAM Tables”
    Section 13.6.12.2, “Operating System Error Codes”
    Section 4.1, “Overview of MySQL Programs”
    Section B.1, “Sources of Error Information”

    perror --ndb error_code

    MySQL 4.1 FAQ: MySQL Cluster

    perror [options] errorcode ...

    Section 4.8.1, “perror — Explain Error Codes”

    pfexec

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”

    pgcc

    Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”

    ping

    Section 14.2, “Using Linux HA Heartbeat”

    ppm

    Section 2.15, “Perl Installation Notes”

    print

    Section 4.5.1.2, “mysql Commands”

    prompt

    Section 4.5.1.2, “mysql Commands”

    prompt [str]

    Section 4.5.1.2, “mysql Commands”

    ps

    Description
    Section 22.5.5, “Differences Between Thread Packages”
    Section 5.3.2.2, “End-User Guidelines for Password Security”
    Section 7.5.8, “How MySQL Uses Memory”
    Section B.5.1, “How to Determine What Is Causing a Problem”
    Section 2.13.1.3, “Starting and Troubleshooting the MySQL Server”

    ps auxw

    Section 4.2.2, “Connecting to the MySQL Server”

    ps xa | grep mysqld

    Section B.5.2.2, “Can't connect to [local] MySQL server”

    pthread

    Description

    quit

    Section 4.5.1.2, “mysql Commands”

    rehash

    Section 4.5.1.2, “mysql Commands”

    replace

    Section 1.8.5.5, “'--' as the Start of a Comment”
    Section 4.8.2, “replace — A String-Replacement Utility”
    Description
    Description
    Section 4.1, “Overview of MySQL Programs”
    Section 16.4.4, “Replication FAQ”

    replace arguments

    Section 4.8.2, “replace — A String-Replacement Utility”

    resolve_stack_dump

    Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
    Description
    Section 4.1, “Overview of MySQL Programs”
    Section 22.5.1.5, “Using a Stack Trace”

    resolve_stack_dump [options] symbols_file [numeric_dump_file]

    Section 4.7.4, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”

    resolveip

    Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
    Description
    Section 4.1, “Overview of MySQL Programs”

    resolveip [options] {host_name|ip-addr} ...

    Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”

    rm

    Section 12.5.1.1, “PURGE BINARY LOGS Syntax”

    rpm

    Section 2.1.4.2, “Signature Checking Using GnuPG”
    Section 2.3.1, “Source Installation Overview”

    rpm --import

    Section 2.1.4.3, “Signature Checking Using RPM”

    rpmbuild

    Section 2.3.1, “Source Installation Overview”

    rsync

    Section 6.1, “Backup and Recovery Types”
    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”

    safe_mysqld

    Description
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
    Section 2.3.1, “Source Installation Overview”
    Section 5.2.3, “The General Query Log”
    Section 7.5.3, “Tuning Server Parameters”

    scp

    Section 6.1, “Backup and Recovery Types”
    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

    sed

    Section 3.3.4.7, “Pattern Matching”

    setenv

    Section 4.2.4, “Setting Environment Variables”

    sh

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 4.2.4, “Setting Environment Variables”
    Section 1.2, “Typographical and Syntax Conventions”

    source file_name

    Section 4.5.1.2, “mysql Commands”

    ssh

    Section 17.5.9.1, “MySQL Cluster Security and Networking Issues”

    status

    Section 4.5.1.2, “mysql Commands”

    strings

    Section 5.3.1, “General Security Guidelines”

    su root

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    sudo

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    system

    Section 4.5.1.2, “mysql Commands”

    system command

    Section 4.5.1.2, “mysql Commands”

    tar

    Section 6.1, “Backup and Recovery Types”
    Section 2.1.2.2, “Choosing a Distribution Format”
    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 3.3, “Creating and Using a Database”
    Section 1.7, “How to Report Bugs or Problems”
    Section 16.1.1, “How to Set Up Replication”
    Section 2.1.5, “Installation Layouts”
    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 2.8, “Installing MySQL on Solaris”
    Section 2.15.1, “Installing Perl on Unix”
    Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
    Section 2.3, “MySQL Installation Using a Source Distribution”
    Section 2.3.1, “Source Installation Overview”

    tcpdump

    Section 5.3.1, “General Security Guidelines”

    tcsh

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 2.7, “Installing MySQL on Mac OS X”
    Section 4.2.1, “Invoking MySQL Programs”
    Section 2.7.5, “MySQL Installation on Mac OS X Notes”
    Section 4.2.4, “Setting Environment Variables”
    Section 1.2, “Typographical and Syntax Conventions”

    tee

    Section 4.5.1.2, “mysql Commands”

    tee [file_name]

    Section 4.5.1.2, “mysql Commands”

    telnet

    Section 5.3.1, “General Security Guidelines”

    top

    Section B.5.1, “How to Determine What Is Causing a Problem”

    ulimit

    Section B.5.2.18, “'File' Not Found and Similar Errors”
    Section 7.5.9, “Enabling Large Page Support”

    ulimit -n

    Description

    ulimit -c

    Description

    ulimit -c unlimited

    Section 5.1.2, “Server Command Options”

    ulimit -d 256000

    Section B.5.2.10, “Packet too large”

    ulimit -l

    Section 17.3.2.6, “Defining MySQL Cluster Data Nodes”

    ulimit -n 256

    Section B.5.2.18, “'File' Not Found and Similar Errors”

    update-rc.d

    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”

    use db_name

    Section 4.5.1.2, “mysql Commands”

    useradd

    Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
    Section 2.6.1, “Installing MySQL from RPM Packages on Linux”
    Section 17.2.1, “MySQL Cluster Multi-Computer Installation”
    Section 2.3.1, “Source Installation Overview”

    usermod

    Section 2.6.1, “Installing MySQL from RPM Packages on Linux”

    vi

    Section 4.5.1.2, “mysql Commands”
    Section 17.2.2, “MySQL Cluster Multi-Computer Configuration”
    Section 3.3.4.7, “Pattern Matching”

    warnings

    Section 4.5.1.2, “mysql Commands”

    winMd5Sum

    Section 2.1.4.1, “Verifying the MD5 Checksum”

    xlC_r

    Section 22.5, “Debugging and Porting MySQL”

    yacc

    Section 22.3.3, “Adding a New Native Function”
    Section 2.3.4, “Dealing with Problems Compiling MySQL”
    Section 8.3, “Reserved Words”

    zip

    Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
    Section 1.7, “How to Report Bugs or Problems”

    zsh

    Section 4.2.4, “Setting Environment Variables”