Skip navigation links
Function Index »
Section Navigation      [Toggle]

Command Index

--old-passwords

Section 20.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.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.4, “MySQL Source-Configuration Options”

./configure --without-server

Section 21.5, “Debugging and Porting MySQL”

./configure --help

Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.11.4, “MySQL Source-Configuration Options”

./mysql-test-run.pl

Section 21.1.2, “The MySQL Test Suite”

./mysql-test-run.pl test_name

Section 21.1.2, “The 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”

ALL STATUS

Section 16.5.7, “MySQL Cluster Single User Mode”

APF

Section 16.5.10.1, “MySQL Cluster Security and Networking Issues”

Access

Section 12.2.2, “DELETE Syntax”

BUILD/autorun.sh

Section 2.11.3, “Installing MySQL from a Development Source Tree”

CMake

Section C.5.2.17, “Can't initialize character set”
Section 9.3, “Adding a Character Set”
Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 21.2.4.3, “Compiling and Installing Plugin Libraries”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 2.11.5, “Dealing with Problems Compiling MySQL”
Section 2.14, “Environment Variables”
Section C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.11, “Installing MySQL from Source”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Chapter 16, MySQL Cluster NDB 6.X/7.X
Section 2.11.4, “MySQL Source-Configuration Options”
Section 2.1.1, “Operating Systems Supported by MySQL Community Server”
Section 5.6.3, “Running Multiple MySQL Instances 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.3, “Server System Variables”
Section 13.12, “The ARCHIVE Storage Engine”
Section 13.14, “The BLACKHOLE Storage Engine”
Section 13.10, “The EXAMPLE Storage Engine”
Section 13.11, “The FEDERATED Storage Engine”
Section 2.13.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 1.4, “What Is New in MySQL 5.1”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”
Section 20.8, “libmysqld, the Embedded MySQL Server Library”

DSPLIB

Section 2.10, “Installing MySQL on i5/OS”

Directory Utility

Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”

EXIT SINGLE USER MODE

Section 16.5.7, “MySQL Cluster Single User Mode”

GnuPG

Section 2.1.4.2, “Signature Checking Using GnuPG”

Hot Backup

Section 15.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 13.6, “The InnoDB Storage Engine”

InnoDB Hot Backup

Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 13.6, “The InnoDB Storage Engine”
Section 13.6.2.2, “Using Per-Table Tablespaces”

MYSQLINST/UPGMYSQL

Section 2.10, “Installing MySQL on i5/OS”

MySQLInstanceConfig.exe

Section 2.3.4.13, “MySQL Server Instance Config Wizard: Creating an Instance from the Command Line”

NET

Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”

NET START

Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”

NET START MySQL

Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”

NET STOP MySQL

Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”

NET START

Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”

NET START MySQL

Section 2.3.7, “Upgrading MySQL Server on Microsoft Windows”

NET START MySQL

Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”

NET STOP

Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”

NET STOP MYSQL

Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”

NET STOP MySQL

Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”

Netinfo Manager

Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”

PGP

Section 2.1.4.2, “Signature Checking Using GnuPG”

SELECT

Section 16.2.5, “MySQL Cluster Example with Tables and Data”

SHOW

Section 16.3.1, “Quick Test Setup of MySQL Cluster”

Service Control Manager

Section 2.3, “Installing MySQL on Microsoft Windows”

Service Control Manager

Section 2.3, “Installing MySQL on Microsoft Windows”
Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”

Services

Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”

Start>Run>cmd.exe

Section 5.5.6.4, “Setting Up SSL Certificates for MySQL”

System Preferences...

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

Terminal

Section 2.4, “Installing MySQL on Mac OS X”

Text in this style

Section 1.2, “Typographical and Syntax Conventions”

WinDbg

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

WinZip

Section 15.3.1.2, “Backing Up Raw Data from a Slave”
Section 2.11, “Installing MySQL from Source”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”

WordPad

Section 12.2.6, “LOAD DATA INFILE Syntax”

aCC

Section 21.5, “Debugging and Porting MySQL”

addgroup

Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

addr2line

Section 21.5.1.5, “Using a Stack Trace”

adduser

Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

apt-get

Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”

ar

Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”

autoconf

Section 2.11.3, “Installing MySQL from a Development Source Tree”

automake

Section 2.11.3, “Installing MySQL from a Development Source Tree”

autoreconf

Section 2.11.3, “Installing MySQL from a Development Source Tree”

bash

Section 5.3.2.2, “End-User Guidelines for Password Security”
Section 2.14, “Environment Variables”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.4, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 15.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.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.12.1, “Unix Postinstallation Procedures”

bin/mysqld_safe

Section 5.6, “Running Multiple MySQL Instances on One Machine”

bison

Section 2.11.5, “Dealing with Problems Compiling MySQL”
Section 2.11, “Installing MySQL from Source”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.11.3, “Installing MySQL from a Development Source Tree”

bzr

Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 20.5, “MySQL Connector/C++”

c++

Section 2.11.5, “Dealing with Problems Compiling MySQL”

c++filt

Section 21.5.1.5, “Using a Stack Trace”

cat [> filename]

Section 4.5.1.1, “mysql Options”

cc

Section 2.11.10, “Notes on Installing MySQL on HP-UX from Source”
Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

chkconfig

Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 2.12.1.2, “Starting and Stopping MySQL Automatically”

chroot

Description

cmake

Section 2.11.2, “Installing MySQL from a Standard Source Distribution”

cmake --help

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

cmd

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

compile-amd64-max-sci

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

compile-pentium64-max-sci

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

configure

Section C.5.2.17, “Can't initialize character set”
Section 9.3, “Adding a Character Set”
Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 21.2.4.3, “Compiling and Installing Plugin Libraries”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 2.11.5, “Dealing with Problems Compiling MySQL”
Section 21.5, “Debugging and Porting MySQL”
Section 2.14, “Environment Variables”
Section C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 1.7, “How to Report Bugs or Problems”
Section 2.11, “Installing MySQL from Source”
Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 2.11.9, “Notes on Installing MySQL on AIX from Source”
Section 2.11.10, “Notes on Installing MySQL on HP-UX from Source”
Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”
Section 5.6.3, “Running Multiple MySQL Instances 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.3, “Server System Variables”
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.6.3, “The MySQL Query Cache”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.13.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 1.4, “What Is New in MySQL 5.1”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”
Section 20.8, “libmysqld, the Embedded MySQL Server Library”

configure --help

Section 2.11.4, “MySQL Source-Configuration Options”

configure.js

Section 16.2.2.2, “Compiling and Installing MySQL Cluster from Source on Windows”
Section 2.11.4, “MySQL Source-Configuration Options”

copy

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

coreadm

Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 5.1.2, “Server Command Options”

cp

Section 15.3.1.2, “Backing Up Raw Data from a Slave”
Section 6.1, “Backup and Recovery Types”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 15.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”

crash-me

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

cron

Section 12.7.2.3, “CHECK TABLE Syntax”
Section C.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 2.14, “Environment Variables”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.4, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

date

Description

df

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

drwtsn32.exe

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

dump

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

dyld

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

ecc/icc

Section 21.5, “Debugging and Porting MySQL”

emerge

Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”

g++

Section 2.11.5, “Dealing with Problems Compiling MySQL”

gcc

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 20.8.1, “Compiling Programs with libmysqld”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 2.11.5, “Dealing with Problems Compiling MySQL”
Section 21.5, “Debugging and Porting MySQL”
Section 2.11, “Installing MySQL from Source”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 2.11.9, “Notes on Installing MySQL on AIX from Source”
Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”
Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
Section 13.6.2.1, “Using InnoDB Plugin Instead of the Built-In InnoDB”

gcc-c++

Section 2.11.5, “Dealing with Problems Compiling MySQL”

gdb

Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 21.5.1.4, “Debugging mysqld under gdb”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

gmake

Section 2.11, “Installing MySQL from Source”
Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.9, “Installing MySQL on FreeBSD”

gnutar

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

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.5.1, “Installing MySQL from RPM Packages on Linux”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

gtar

Section 2.8.1, “General Notes on Installing MySQL on HP-UX”
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.11, “Installing MySQL from Source”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”

gunzip

Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”

gzip

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

gzip --fast

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

hdparm

Section 13.6.3, “InnoDB Startup Options and System Variables”

help contents

Section 4.5.1.4, “mysql Server-Side Help”

hostname

Section C.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 21.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 16.5.10.1, “MySQL Cluster Security and Networking Issues”

isamlog

Description
Section 4.1, “Overview of MySQL Programs”

kill

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

kill -9

Section E.5, “Restrictions on XA Transactions”

ksh

Section 2.14, “Environment Variables”

kswapd

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ld-elf.so.1

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

ld.so

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

ldconfig

Section 21.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 21.2.4.3, “Compiling and Installing Plugin Libraries”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.11, “Installing MySQL from Source”
Section 2.11.3, “Installing MySQL from a Development Source Tree”

logger

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

m4

Section 2.11, “Installing MySQL from Source”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.11.3, “Installing MySQL from a Development Source Tree”

make

Section 21.2.4.3, “Compiling and Installing Plugin Libraries”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.11.5, “Dealing with Problems Compiling MySQL”
Section 2.11, “Installing MySQL from Source”
Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.9, “Installing MySQL on FreeBSD”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

make package

Section 16.2.2.2, “Compiling and Installing MySQL Cluster from Source on Windows”
Section 2.11.4, “MySQL Source-Configuration Options”

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.11.3, “Installing MySQL from a Development Source Tree”

make && make install

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”

make -f Makefile.aperl inst_perl MAP_TARGET=perl

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

make -k

Section 2.11.4, “MySQL Source-Configuration Options”

make distclean

Section 2.11.5, “Dealing with Problems Compiling MySQL”

make install

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 21.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 13.6.2.1, “Using InnoDB Plugin Instead of the Built-In InnoDB”

make package

Section 2.11.2, “Installing MySQL from a Standard Source Distribution”

make perl

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

make test

Section 2.11.3, “Installing MySQL from a Development Source Tree”
Section 2.15.1, “Installing Perl on Unix”
Section 21.1.2, “The 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 16.2.2.2, “Compiling and Installing MySQL Cluster from Source on Windows”
Description
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 2.11.7, “Installing MySQL from Source on Windows”
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

Section 16.1.1, “MySQL Cluster Core Concepts”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 14.6, “Using MySQL with memcached”

mgmd

Section 16.2, “MySQL Cluster Installation”

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.3.3.2, “Automating MySQL Installation on Microsoft Windows using the MSI Package”

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”

mv

Section 5.2.6, “Server Log Maintenance”
Section 5.2.2, “The Error Log”
Section 5.2.3, “The General Query Log”

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.9, “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 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.7.2.6, “REPAIR TABLE Syntax”
Section 13.5.3.3, “Compressed Table Characteristics”
Section 13.5.4.1, “Corrupted MyISAM Tables”
Section 6.2, “Database Backup Methods”
Section 21.5.1, “Debugging a MySQL Server”
Description
Description
Description
Section 7.7.4, “External Locking”
Section 11.9.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 17.3.3, “Maintenance of Partitions”
Section 2.3.3.1.2, “MySQL Installation Wizard: Choosing an Install Type”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 4.6.3.4, “Other myisamchk Options”
Section 7.3.4, “Other Optimization Tips”
Section 4.1, “Overview of MySQL Programs”
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section 17.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.3.2.1, “Speed of INSERT Statements”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”
Section 13.5.3.1, “Static (Fixed-Length) Table Characteristics”
Section 7.9.1, “System Factors and Startup Parameter Tuning”
Section 13.5, “The MyISAM Storage Engine”
Section 6.6.1, “Using myisamchk for Crash Recovery”
Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 7.9.6.2, “Using Symbolic Links for Tables on Unix”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

myisamchk --analyze

Section 12.7.2.1, “ANALYZE TABLE Syntax”
Section 7.2.2, “EXPLAIN Output Format”

myisamchk --help

Section 4.6.3.1, “myisamchk General Options”

myisamchk --medium-check tbl_name

Section 12.7.2.3, “CHECK TABLE Syntax”

myisamchk --recover

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

myisamchk --safe-recover

Section 12.7.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.5.4, “InnoDB and 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, “Obtaining Table Information with myisamchk”

myisamchk -r

Section 6.2, “Database Backup Methods”

myisamchk tbl_name

Section 6.6.2, “How to Check MyISAM Tables for Errors”

myisamchk *.MYI

Section 6.6.3, “How to Repair MyISAM Tables”

myisamchk --analyze

Section 7.3.1.1, “Speed of SELECT Statements”
Section 13.5, “The MyISAM Storage Engine”

myisamchk --description --verbose tbl_name

Section 4.6.3.4, “Other myisamchk Options”

myisamchk --description --verbose

Section 7.3.1.1, “Speed of SELECT Statements”

myisamchk --fast

Section 13.5, “The MyISAM Storage Engine”

myisamchk --help

Description

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

Section 7.3.2.1, “Speed of INSERT Statements”

myisamchk --medium-check

Section 4.6.3.2, “myisamchk Check Options”

myisamchk --recover --quick

Section 12.7.2.6, “REPAIR TABLE Syntax”

myisamchk --recover tbl_name

Section 12.7.2.6, “REPAIR TABLE Syntax”

myisamchk --safe-recover

Section 12.7.2.6, “REPAIR TABLE Syntax”

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

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

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

Section 7.3.1.1, “Speed of SELECT Statements”

myisamchk -a

Section 12.7.5.23, “SHOW INDEX Syntax”

myisamchk -d tbl_name

Section 4.6.3.5, “Obtaining Table Information with myisamchk”

myisamchk -dv

Section 12.7.6.5, “LOAD INDEX INTO CACHE Syntax”

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

Section E.7.3, “Limits on Table Size”

myisamchk -dv tbl_name

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

myisamchk -dvv

Section 12.7.5.38, “SHOW TABLE STATUS Syntax”
Description
Section 4.6.3.5, “Obtaining Table Information with myisamchk”

myisamchk -dvv tbl_name

Section 9.5, “Character Set Configuration”

myisamchk -e *.MYI

Section 6.6.3, “How to Repair MyISAM Tables”

myisamchk -e tbl_name

Section 6.6.2, “How to Check MyISAM Tables for Errors”

myisamchk -e -i tbl_name

Section 6.6.2, “How to Check MyISAM Tables for Errors”

myisamchk -e -i tbl_name

Section 6.6.2, “How to Check MyISAM Tables for Errors”

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, “Obtaining Table Information with myisamchk”

myisamchk -eiv

Section 4.6.3.5, “Obtaining Table Information with myisamchk”

myisamchk -eiv tbl_name

Section 4.6.3.5, “Obtaining Table Information with myisamchk”

myisamchk -m tbl_name

Section 6.6.2, “How to Check MyISAM Tables for Errors”

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 21.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 tbl_name

Section 6.6.3, “How to Repair MyISAM Tables”

myisamchk -rq

Description
Description

myisamchk -rq /path/to/db/tbl_name

Section 7.3.2.1, “Speed of INSERT Statements”

myisamchk -s

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

myisamchk -s database/*.MYI

Section 21.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.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 13.5.3.3, “Compressed Table Characteristics”
Description
Section 7.7.4, “External Locking”
Section E.7.3, “Limits on Table Size”
Section 7.8.1, “Make Your Data as Small as Possible”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 4.1, “Overview of MySQL Programs”
Section 12.1.17.2, “Silent Column Specification Changes”
Section 7.3.2.1, “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.3, “mysql History File”
Section 4.5.1.1, “mysql Options”
Section 4.5.1.4, “mysql Server-Side Help”
Section 4.5.1.6, “mysql Tips”
Section 12.6.1, “BEGIN ... END Compound-Statement Syntax”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.8.3, “HELP Syntax”
Section C.5.2.15, “Ignoring user”
Section 7.3.1.15, “LIMIT Optimization”
Section 12.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 12.4.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section C.5.2.8, “Out of memory”
Section C.5.2.10, “Packet too large”
Section 12.2.8.1, “SELECT ... INTO Syntax”
Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.7.5.36, “SHOW SLAVE STATUS Syntax”
Section 20.9.3.14, “mysql_errno()”
Section 20.9.3.66, “mysql_sqlstate()”
Section 16.5.12.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.5.12.1, “Adding MySQL Cluster Data Nodes Online: General Issues”
Section 5.5.2, “Adding User Accounts”
Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Section 6.1, “Backup and Recovery Types”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 16.7, “Changes in MySQL Cluster NDB 6.X and 7.X”
Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Section 8.6, “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 20.9.11, “Controlling Automatic Reconnection Behavior”
Section 2.13.5, “Copying MySQL Databases to Another Machine”
Section 3.3.1, “Creating and Selecting a Database”
Section 13.6.2.4, “Creating the InnoDB Tablespace”
Section 2.3.5.6, “Customizing the PATH for MySQL Tools”
Section 21.5.2, “Debugging a MySQL Client”
Section 18.1, “Defining Stored Programs”
Description
Description
Description
Description
Description
Description
Description
Description
Section 4.5.1.6.3, “Disabling mysql Auto-Reconnect”
Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
Section 2.13.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 18.4.2, “Event Scheduler Configuration”
Section 6.3, “Example Backup and Recovery Strategy”
Section 3.6, “Examples of Common Queries”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Chapter 11, Functions and Operators
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section C.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.14, “Information Functions”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.4, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 16.1.6.8, “Issues Exclusive to MySQL Cluster”
Section C.5.8, “Known Issues in MySQL”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 6.4.5.1, “Making a Copy of a Database”
Section 16.5, “Management of MySQL Cluster”
Section 16.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
Section 16.1.4, “MySQL Cluster Development History”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.5.11.1, “MySQL Cluster Disk Data Objects”
Section 16.2.5, “MySQL Cluster Example with Tables and Data”
Chapter 16, MySQL Cluster NDB 6.X/7.X
Section 16.6, “MySQL Cluster Replication”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
Section 2.3.3.1.5, “MySQL Installation Wizard: Changes Made”
Section 2.3.3.1.2, “MySQL Installation Wizard: Choosing an Install Type”
Section 14.7, “MySQL Proxy”
Section 9.6, “MySQL Server Time Zone Support”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 2.3.8, “MySQL Server on Microsoft Windows Postinstallation Procedures”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 16.5.14, “NDB API Statistics Counters and Variables”
Section 7.3.1, “Optimizing SELECT 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 16.6.5, “Preparing the MySQL Cluster for Replication”
Section 16.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 2.12.1.1, “Problems Running mysql_install_db”
Section 4.2.3.2, “Program Option Modifiers”
Section 2.13.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 C.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section 12.5, “SQL Syntax for Prepared Statements”
Section 2.12.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 C.3, “Server Error Codes and Messages”
Section 5.1.3, “Server System Variables”
Section 5.1.8, “Server-Side Help”
Section 11.17.5, “Spatial Analysis Functions”
Section 4.2.3, “Specifying Program Options”
Section 16.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”
Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”
Section 2.12.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.4.1, “Starting the MySQL Server Instance Config Wizard”
Section 8.1.1, “String Literals”
Section 10.4.3, “The BLOB and TEXT Types”
Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”
Section 18.3.1, “Trigger Syntax”
Section 13.6.13.4, “Troubleshooting InnoDB Data Dictionary Operations”
Chapter 3, Tutorial
Section 20.2.4.8, “Tutorial: Using MySqlScript”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.12.1, “Unix Postinstallation Procedures”
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 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 16.5.11.2, “Using Symbolic Links with Disk Data Objects”
Section 4.5.1.6.2, “Using the --safe-updates Option”
Section 1.4, “What Is New in MySQL 5.1”
Section 11.11, “XML Functions”

mysql --force --one-database db1

Section 4.5.1.1, “mysql Options”

mysql --help

Section 4.1, “Overview of MySQL Programs”

mysql ... --debug

Section 21.5.1.1, “Compiling MySQL for Debugging”

mysql [options] db_name

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

mysql mysql < /tmp/mysql.dump

Section 2.13.2.1, “Downgrading to MySQL 5.0”

mysql {start|stop}

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

mysql-server

Section 2.9, “Installing MySQL on FreeBSD”

mysql-test-run.pl

Section 2.11.7, “Installing MySQL from Source on Windows”
Section 21.1.2, “The MySQL Test Suite”

mysql.exe

Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”

mysql.server

Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Description
Description
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.5, “Installing MySQL on Linux”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.2, “Server Command Options”
Section 2.12.1.2, “Starting and Stopping MySQL Automatically”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section C.5.4.6, “Time Zone Problems”

mysql.server stop

Section 2.12.1.2, “Starting and Stopping MySQL Automatically”

mysql_config

Section 4.7.2, “mysql_config — Get Compile Options for Compiling Clients”
Section 20.9.16, “Building Client Programs”
Section 20.8.1, “Compiling Programs with libmysqld”
Section 2.11.5, “Dealing with Problems Compiling MySQL”
Description
Section 4.1, “Overview of MySQL Programs”
Section 20.9.16.1, “Problems Linking to the MySQL Client Library”

mysql_config --libmysqld-libs

Section 20.8.1, “Compiling Programs with libmysqld”

mysql_config --plugindir

Section 21.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_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 21.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”
Description
Description
Section 2.13.2.1, “Downgrading to MySQL 5.0”
Section 4.1, “Overview of MySQL Programs”
Section E.1, “Restrictions on Stored Programs”

mysql_fix_privilege_tables --password=root_password

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 5.4.7, “Causes of Access-Denied Errors”
Section D.1.49, “Changes in MySQL 5.1.21 (16 August 2007)”
Description
Section 2.1.5, “Installation Layouts”
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”
Section 2.4, “Installing MySQL on Mac OS X”
Section 2.4.2, “Installing MySQL on Mac OS X Using Native Packages”
Section 2.6.2, “Installing MySQL on OpenSolaris using IPS”
Section 13.6.14, “Limits on InnoDB Tables”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
Section 2.11.1, “MySQL Layout for Source Installation”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 4.1, “Overview of MySQL Programs”
Section 2.12.1.1, “Problems Running mysql_install_db”
Section 2.12.2, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.1.8, “Server-Side Help”
Section 5.6.1, “Setting Up Multiple Data Directories”
Section 2.12.1, “Unix Postinstallation Procedures”

mysql_install_db [options]

Section 4.4.5, “mysql_install_db — Initialize MySQL Data Directory”

mysql_plugin

Section 4.1, “Overview of MySQL Programs”

mysql_secure_installation

Section 4.4.6, “mysql_secure_installation — Improve MySQL Installation Security”
Description
Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”
Section 2.6.2, “Installing MySQL on OpenSolaris using IPS”
Section 2.6.1, “Installing MySQL on Solaris using a Solaris PKG”
Section 4.1, “Overview of MySQL Programs”
Section 2.12.2, “Securing the Initial MySQL Accounts”

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.5, “Server Status Variables”

mysql_stmt_prepare()

Section 5.1.5, “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.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.13.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Description
Description
Description
Section 2.13.2, “Downgrading MySQL”
Section 4.1, “Overview of MySQL Programs”
Section 5.3.2.3, “Password Hashing in MySQL”
Section 21.2.2, “Plugin API Components”
Section 2.13.4, “Rebuilding or Repairing Tables or Indexes”
Section E.1, “Restrictions on Stored Programs”
Section 13.12, “The ARCHIVE Storage Engine”
Section 16.5.9.8, “The ndbinfo nodes Table”
Section 21.2, “The MySQL Plugin API”
Section 16.2.7.1, “Upgrade and downgrade compatibility: MySQL Cluster NDB 7.x”
Section 2.13.1, “Upgrading MySQL”
Section 2.3.7, “Upgrading MySQL Server on Microsoft Windows”
Section 2.13.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 1.4, “What Is New in MySQL 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 C.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 4.1, “Overview of MySQL Programs”
Section 2.12.1, “Unix Postinstallation Procedures”

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 C.5.2.2, “Can't connect to [local] MySQL server”
Section 12.1.21, “DROP DATABASE Syntax”
Section 12.7.6.3, “FLUSH Syntax”
Section 5.5.5, “Assigning Account Passwords”
Section 15.3.1.1, “Backing Up a Slave Using mysqldump”
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.3.5.6, “Customizing the PATH for MySQL Tools”
Description
Description
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 2.4, “Installing MySQL on Mac OS X”
Section 2.10, “Installing MySQL on i5/OS”
Section 5.2, “MySQL Server Logs”
Section 4.1, “Overview of MySQL Programs”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”
Section 2.12.2, “Securing the Initial MySQL Accounts”
Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”
Section 2.3.5.5, “Starting MySQL Server from the Windows Command Line”
Section 5.1.10, “The Shutdown Process”
Section 7.9.2, “Tuning Server Parameters”
Section 2.12.1, “Unix Postinstallation Procedures”
Section 2.3.7, “Upgrading MySQL Server on Microsoft Windows”
Section 4.2.3.3, “Using Option Files”
Section 4.2.3.1, “Using Options on the Command Line”

mysqladmin debug

Section 12.7.1.3, “GRANT Syntax”
Section 18.4.5, “Event Scheduler Status”

mysqladmin flush-hosts

Section 7.9.8, “How MySQL Uses DNS”

mysqladmin flush-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.12.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.8.2, “How MySQL Opens and Closes Tables”
Section 7.9.4, “How MySQL Uses Memory”
Section 7.3.2.1, “Speed of INSERT Statements”

mysqladmin flush-xxx

Section 5.5.2, “Adding User Accounts”

mysqladmin kill

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

mysqladmin processlist

Section 5.3.3, “Making MySQL Secure Against Attackers”

mysqladmin processlist status

Section 21.5.1, “Debugging a MySQL Server”

mysqladmin refresh

Section 5.5.2, “Adding User Accounts”
Section 7.8.2, “How MySQL Opens and Closes Tables”
Section C.5.8, “Known Issues in MySQL”

mysqladmin reload

Section 2.12.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 2.4, “Installing MySQL on Mac OS X”
Section 2.4.2, “Installing MySQL on Mac OS X Using Native Packages”
Section 21.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 2.11.9, “Notes on Installing MySQL on AIX from Source”
Section 15.4.1.20, “Replication and Temporary Tables”
Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”

mysqladmin variables

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

mysqladmin ver

Section 21.5.1.1, “Compiling MySQL for Debugging”

mysqladmin version

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

mysqladmin -h localhost variables

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

mysqladmin -i 5 -r status

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

mysqladmin -i 5 status

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

mysqladmin -i10 processlist status

Section 21.5.1, “Debugging a MySQL Server”

mysqladmin -u root ping

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

mysqladmin -u root processlist

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

mysqladmin -u root processlist

Section C.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.7.5.34, “SHOW SCHEDULER STATUS Syntax”
Section 21.5.1, “Debugging a MySQL Server”
Section 18.4.5, “Event Scheduler Status”
Section 5.4.1, “Privileges Provided by MySQL”

mysqladmin extended-status

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

mysqladmin flush-hosts

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

mysqladmin flush-logs

Section 6.3.3, “Backup Strategy Summary”
Section 6.3.1, “Establishing a Backup Policy”
Section 5.2.6, “Server Log Maintenance”
Section 5.2.2, “The Error Log”
Section 15.2.2.1, “The Slave Relay Log”
Section 2.13.1.1, “Upgrading from MySQL 5.0 to 5.1”

mysqladmin flush-privileges

Section 2.13.5, “Copying MySQL Databases to Another Machine”
Description
Section 2.13.2.1, “Downgrading to MySQL 5.0”

mysqladmin flush-tables

Section 7.7.4, “External Locking”
Section 7.8.2, “How MySQL Opens and Closes Tables”
Section 6.6.1, “Using myisamchk for Crash Recovery”

mysqladmin kill

Section 12.7.6.4, “KILL Syntax”
Section C.5.2.9, “MySQL server has gone away”
Section 11.15, “Miscellaneous Functions”
Section 2.11.9, “Notes on Installing MySQL on AIX from Source”
Section 5.4.1, “Privileges Provided by MySQL”
Section E.7.5, “Windows Platform Limitations”

mysqladmin password

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

mysqladmin processlist

Section 12.7.6.4, “KILL Syntax”
Section 12.7.5.31, “SHOW PROCESSLIST Syntax”
Section 20.9.3.43, “mysql_list_processes()”
Section 5.5.2, “Adding User Accounts”
Section 7.10, “Examining Thread Information”
Section 21.1.1, “MySQL Threads”
Section 5.4.1, “Privileges Provided by MySQL”

mysqladmin refresh

Section 7.8.2, “How MySQL Opens and Closes Tables”
Section C.5.8, “Known 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.7.1.3, “GRANT Syntax”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 21.5.1.2, “Creating Trace Files”
Section 13.6.2.4, “Creating the InnoDB Tablespace”
Description
Section 6.6.3, “How to Repair MyISAM Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 2.12.1.2, “Starting and Stopping MySQL Automatically”
Section 5.1.10, “The Shutdown Process”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”
Section E.7.5, “Windows Platform Limitations”

mysqladmin status

Section 20.9.3.68, “mysql_stat()”
Description
Section 7.8.2, “How MySQL Opens and Closes Tables”

mysqladmin variables

Section 12.7.5.41, “SHOW VARIABLES Syntax”

mysqladmin variables extended-status processlist

Section 1.7, “How to Report Bugs or Problems”

mysqladmin version

Section C.5.2.9, “MySQL server has gone away”
Section 1.7, “How to Report Bugs or Problems”
Section 2.12.1, “Unix Postinstallation Procedures”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”

mysqlanalyze

Description

mysqlbackup

Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Section 6.1, “Backup and Recovery Types”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

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.7.6.1, “BINLOG Syntax”
Section 12.7.4, “SET Syntax”
Section 12.7.5.3, “SHOW BINLOG EVENTS Syntax”
Section 12.4.2.7, “START SLAVE Syntax”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Description
Section 15.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 15.4.5, “How to Report Replication Bugs or Problems”
Section C.5.8, “Known Issues in MySQL”
Section 11.15, “Miscellaneous Functions”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 4.1, “Overview of MySQL Programs”
Section 16.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 15.4.1.34, “Replication and Variables”
Section 5.2.4, “The Binary Log”
Section 15.2.2.1, “The Slave Relay Log”
Section 15.1.2.2, “Usage of Row-Based Logging and Replication”
Section 6.3.2, “Using Backups for Recovery”
Section 1.4, “What Is New in MySQL 5.1”

mysqlbinlog --database=test

Description

mysqlbinlog binary-log-file | mysql

Section 21.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 C.5.8, “Known Issues in MySQL”

mysqlbug

Section 4.4.3, “mysqlbug — Generate Bug Report”
Description

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 17.3.3, “Maintenance of Partitions”
Section 8.2.3, “Mapping of Identifiers to File Names”
Section 4.1, “Overview of MySQL Programs”
Section 2.13.4, “Rebuilding or Repairing Tables or Indexes”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 13.5, “The MyISAM Storage Engine”
Section 2.13.1.1, “Upgrading from MySQL 5.0 to 5.1”

mysqlcheck --all-databases --analyze

Section 5.1.3, “Server System Variables”

mysqlcheck --check-upgrade

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

mysqlcheck --all-databases --analyze

Section 5.1.3, “Server System Variables”

mysqlcheck --check-upgrade

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

mysqlcheck --repair

Section 2.13.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 C.5.2.18, “'File' Not Found and Similar Errors”
Section 12.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.1.17, “CREATE TABLE Syntax”
Section 12.1.20, “CREATE VIEW Syntax”
Section C.5.2.2, “Can't connect to [local] MySQL server”
Section C.5.2.13, “Can't create/write to file”
Section C.5.2.17, “Can't initialize character set”
Section C.5.2.4, “Client does not support authentication protocol”
Section 12.7.6.3, “FLUSH Syntax”
Section C.5.2.6, “Host 'host_name' is blocked”
Section 12.2.5.2, “INSERT DELAYED Syntax”
Section C.5.2.15, “Ignoring user”
Section 13.6.13.3, “InnoDB General Troubleshooting”
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 12.7.6.4, “KILL Syntax”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 13.5.1, “MyISAM Startup Options”
Section C.5.2.9, “MySQL server has gone away”
Section 12.7.2.5, “OPTIMIZE TABLE Syntax”
Section C.5.2.10, “Packet too large”
Section 12.4.2.5, “RESET SLAVE Syntax”
Section 12.2.8.1, “SELECT ... INTO Syntax”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.7.5.16, “SHOW ENGINE Syntax”
Section 12.7.5.41, “SHOW VARIABLES Syntax”
Section C.5.2.7, “Too many connections”
Section 20.9.3.1, “mysql_affected_rows()”
Section 20.9.3.49, “mysql_options()”
Section 21.3, “Adding New Functions to MySQL”
Section 21.3.2, “Adding a New User-Defined Function”
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 15.1.3.4, “Binary Log Options and Variables”
Section 5.2.4.1, “Binary Logging Formats”
Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.1.2.2, “Choosing a Distribution Format”
Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Section 8.6, “Comment Syntax”
Section C.5.2.11, “Communication Errors and Aborted Connections”
Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.11.6, “Compiling and Linking an Optimized mysqld Server”
Section 13.6.4.3.2, “Configurable InnoDB Auto-Increment Locking”
Section 13.6.2, “Configuring InnoDB”
Section 13.5.4.1, “Corrupted MyISAM Tables”
Section 21.5.1.2, “Creating Trace Files”
Section 13.6.2.4, “Creating the InnoDB Tablespace”
Section 13.6.2.5, “Dealing with InnoDB Initialization Problems”
Section 2.11.5, “Dealing with Problems Compiling MySQL”
Section 21.5.1.4, “Debugging mysqld under gdb”
Section 21.5.1, “Debugging a MySQL Server”
Section 21.5, “Debugging and Porting MySQL”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.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.7.4, “External Locking”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 13.6.6.2, “Forcing InnoDB Recovery”
Section 16.6.2, “General Requirements for MySQL Cluster Replication”
Section 7.10.2, “General Thread States”
Section 7.8.2, “How MySQL Opens and Closes Tables”
Section 7.9.8, “How MySQL Uses DNS”
Section 7.9.4, “How MySQL Uses Memory”
Section 7.3.1.16, “How to Avoid Table Scans”
Section C.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 16.6.8, “Implementing Failover with MySQL Cluster Replication”
Section 11.14, “Information Functions”
Section 16.2.3, “Initial Configuration of MySQL Cluster”
Section 16.2.4, “Initial Startup of MySQL Cluster”
Section 2.1.5, “Installation Layouts”
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 16.2.1, “Installing MySQL Cluster on Linux”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.5.1, “Installing MySQL from RPM Packages on Linux”
Section 2.11.7, “Installing MySQL from Source on Windows”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.4, “Installing MySQL on Mac OS X”
Section 2.4.2, “Installing MySQL on Mac OS X Using Native Packages”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.10, “Installing MySQL on i5/OS”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 16.1.6.8, “Issues Exclusive to MySQL Cluster”
Section C.5.8, “Known Issues in MySQL”
Section 16.6.3, “Known Issues in MySQL Cluster Replication”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 21.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 16.5, “Management of MySQL Cluster”
Section 11.15, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.4.1, “MySQL Cluster mysqld Option and Variable Reference”
Section 16.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.1.4, “MySQL Cluster Development History”
Section 16.1.4.6, “MySQL Cluster Development in MySQL Cluster NDB 6.1”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.1.4.1, “MySQL Cluster Development in MySQL Cluster NDB 7.2”
Section 16.2, “MySQL Cluster Installation”
Chapter 16, MySQL Cluster NDB 6.X/7.X
Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 16.1, “MySQL Cluster Overview”
Section 16.4, “MySQL Cluster Programs”
Section 16.6, “MySQL Cluster Replication”
Section 16.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
Section 16.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”
Section 16.3.4.4, “MySQL Cluster Status Variables”
Section 16.3.4.3, “MySQL Cluster System Variables”
Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
Section 2.11.1, “MySQL Layout for Source Installation”
Chapter 5, MySQL Server Administration
Section 5.2, “MySQL Server Logs”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 9.6, “MySQL Server Time Zone Support”
Section 16.4.1, “MySQL Server Usage for MySQL Cluster”
Section 4.3, “MySQL Server and Server-Startup Programs”
Section 16.1.5, “MySQL Server using InnoDB Compared with MySQL Cluster”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 21.1.1, “MySQL Threads”
Section 16.5.14, “NDB API Statistics Counters and Variables”
Section 2.11.8, “Notes on Installing MySQL on Solaris from Source”
Section C.5.6, “Optimizer-Related Issues”
Section 20.8.3, “Options with the Embedded Server”
Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 4.1, “Overview of MySQL Programs”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 21.2.4.2.2, “Plugin Status and System Variables”
Section 16.6.5, “Preparing the MySQL Cluster for Replication”
Section 16.1.6.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.12.1.1, “Problems Running mysql_install_db”
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section C.5.3.1, “Problems with File Permissions”
Section 4.2.3.2, “Program Option Modifiers”
Section 7.6.3.3, “Query Cache Configuration”
Section 16.3.2.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”
Section 15.1.3.2, “Replication Master Options and Variables”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 15.1.3.1, “Replication and Binary Logging Option and Variable Reference”
Section 15.1.3, “Replication and Binary Logging Options and Variables”
Section C.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section C.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section C.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 5.6, “Running Multiple MySQL Instances on One Machine”
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.3.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.6, “Server SQL Modes”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 9.2, “Setting the Error Message Language”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 16.6.6, “Starting MySQL Cluster Replication (Single Replication Channel)”
Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”
Section 2.3.5.5, “Starting MySQL Server from the Windows Command Line”
Section 2.12.1.2, “Starting and Stopping MySQL Automatically”
Section 2.12.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.7.2, “Table Locking Issues”
Section C.5.2.19, “Table-Corruption Issues”
Section 2.3.5.8, “Testing The MySQL Server Installation on Microsoft Windows”
Section 13.14, “The BLACKHOLE Storage Engine”
Section 13.5, “The MyISAM Storage Engine”
Section 16.5.9, “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.6.3, “The MySQL Query Cache”
Section 5.1, “The MySQL Server”
Section 21.1.2, “The MySQL Test Suite”
Section 5.2.5, “The Slow Query Log”
Section C.5.4.6, “Time Zone Problems”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 7.9.2, “Tuning Server Parameters”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.12.1, “Unix Postinstallation Procedures”
Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”
Section 2.13.1, “Upgrading MySQL”
Section 2.3.7, “Upgrading MySQL Server on Microsoft Windows”
Section 2.13.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 21.3.2.6, “User-Defined Function Security Precautions”
Section 6.6.1, “Using myisamchk for Crash Recovery”
Section 21.5.1.3, “Using pdb to create a Windows crashdump”
Section 4.2.3.3, “Using Option Files”
Section 13.6.2.2, “Using Per-Table Tablespaces”
Section 5.5.6.2, “Using SSL Connections”
Section 21.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 7.9.6.3, “Using Symbolic Links for Databases on Windows”
Section 7.9.6.2, “Using Symbolic Links for Tables on Unix”
Section 16.6.7, “Using Two Replication Channels for MySQL Cluster Replication”
Section 21.5.1.5, “Using a Stack Trace”
Section 2.4.5, “Using the Bundled MySQL on Mac OS X Server”
Section 1.4, “What Is New in MySQL 5.1”
Section C.5.4.2, “What to Do If MySQL Keeps Crashing”
Section 5.4.6, “When Privilege Changes Take Effect”
Section C.5.4.4, “Where MySQL Stores Temporary Files”
Section 21.2.4, “Writing Plugins”

mysqld --print-defaults

Section 21.5.1, “Debugging a MySQL Server”

mysqld --remove

Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”

mysqld --console

Section 2.3.5.5, “Starting MySQL Server from the Windows Command Line”

mysqld --help

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

mysqld --no-defaults ...

Section 21.5.1, “Debugging a MySQL Server”

mysqld --print-defaults

Section 2.13.1, “Upgrading MySQL”

mysqld --verbose --help

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

mysqld [options]

Section 4.3.1, “mysqld — The MySQL Server”

mysqld-

Section 2.13.1, “Upgrading MySQL”

mysqld-.13

Section 2.13.1, “Upgrading MySQL”

mysqld-abc.exe

Description

mysqld-debug

Section 2.1.2.2, “Choosing a Distribution Format”
Section 21.5.1.2, “Creating Trace Files”
Description
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 5.1.2, “Server Command Options”
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”

mysqld-max

Description
Section 2.13.1, “Upgrading MySQL”
Section 2.13.1.1, “Upgrading from MySQL 5.0 to 5.1”

mysqld-nt

Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 5.1.2, “Server Command Options”
Section 5.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”

mysqld.exe

Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”

mysqld_multi

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

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 C.5.2.18, “'File' Not Found and Similar Errors”
Section 13.6.13.3, “InnoDB General Troubleshooting”
Section C.5.2.10, “Packet too large”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 21.5.1.1, “Compiling MySQL for Debugging”
Section 21.3.2.5, “Compiling and Installing User-Defined Functions”
Section 13.6.2.4, “Creating the InnoDB Tablespace”
Description
Description
Description
Description
Section 7.9.7, “Enabling Large Page Support”
Section C.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.4, “Installing MySQL on Mac OS X”
Section 2.10, “Installing MySQL on i5/OS”
Section C.5.8, “Known Issues in MySQL”
Section 5.3.3, “Making MySQL Secure Against Attackers”
Section 16.5.10.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 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 4.1, “Overview of MySQL Programs”
Section C.5.3.1, “Problems with File Permissions”
Section 5.6, “Running Multiple MySQL Instances on One Machine”
Section 5.6.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.12.1.2, “Starting and Stopping MySQL Automatically”
Section 2.12.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 C.5.4.6, “Time Zone Problems”
Section 7.9.2, “Tuning Server Parameters”
Section 2.12.1, “Unix Postinstallation Procedures”
Section 2.13.1, “Upgrading MySQL”
Section 2.13.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.7.2.2, “BACKUP TABLE Syntax”
Section 12.1.13, “CREATE INDEX Syntax”
Section 12.1.20, “CREATE VIEW Syntax”
Section 11.18.2, “DECIMAL Data Type Changes”
Section 13.6.4.4, “FOREIGN KEY Constraints”
Section 13.6.13.1, “InnoDB Performance Tuning Tips”
Section 12.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 12.4.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 12.7.3.4, “UNINSTALL PLUGIN Syntax”
Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 15.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
Section 15.3.1.1, “Backing Up a Slave Using mysqldump”
Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
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.13.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 4.2.2, “Connecting to the MySQL Server”
Section 6.4.5.2, “Copy a Database from one Server to Another”
Section 2.13.5, “Copying MySQL Databases to Another Machine”
Section 15.1.1.5, “Creating a Data Snapshot Using mysqldump”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 2.3.5.6, “Customizing the PATH for MySQL Tools”
Section 6.2, “Database Backup Methods”
Section 13.6.11.3, “Defragmenting a Table”
Description
Description
Description
Section 16.5.13, “Distributed MySQL Privileges for MySQL Cluster”
Section 2.13.2, “Downgrading MySQL”
Section 2.13.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.1, “Establishing a Backup Policy”
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 15.1.1, “How to Set Up Replication”
Section 8.2.2, “Identifier Case Sensitivity”
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”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.2.5, “MySQL Cluster Example with Tables and Data”
Section 16.1, “MySQL Cluster Overview”
Section 2.3.3.1.2, “MySQL Installation Wizard: Choosing an Install Type”
Section 5.2, “MySQL Server Logs”
Section 10.1.1, “Numeric Type Overview”
Section 16.5.3, “Online Backup of MySQL Cluster”
Section 4.1, “Overview of MySQL Programs”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
Section 16.6.5, “Preparing the MySQL Cluster for Replication”
Section C.5.5.8, “Problems with Floating-Point Values”
Section 2.13.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 15.3.4, “Replicating Different Databases to Different Slaves”
Section E.4, “Restrictions on Views”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 15.1.1.8, “Setting Up Replication with Existing Data”
Section 4.2.3, “Specifying Program Options”
Section 2.3.5.7, “Starting MySQL Server as a Microsoft Windows Service”
Section 2.3.4.1, “Starting the MySQL Server Instance Config Wizard”
Section 13.12, “The ARCHIVE Storage Engine”
Section 10.4.3, “The BLOB and TEXT Types”
Section 7.6.2, “The InnoDB Buffer Pool”
Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”
Section 9.6.2, “Time Zone Leap Second Support”
Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”
Section 16.2.7, “Upgrading and Downgrading MySQL Cluster”
Section 2.13.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 13.6.2.2, “Using Per-Table Tablespaces”
Section 15.3.1, “Using Replication for Backups”
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 1.4, “What Is New in MySQL 5.1”
Section 11.11, “XML Functions”

mysqldump --delete-master-logs

Section 6.3.1, “Establishing a Backup Policy”

mysqldump --flush-logs

Section 5.2.6, “Server Log Maintenance”

mysqldump --master-data

Section 15.1.1.4, “Obtaining the Replication Master Binary Log Coordinates”
Section 5.2.6, “Server Log Maintenance”

mysqldump --routines

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

mysqldump --help

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

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

Section 2.13.2.1, “Downgrading to MySQL 5.0”

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

Section C.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.13.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.7.2.2, “BACKUP TABLE Syntax”
Section 12.4.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.4.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 4.1, “Overview of MySQL Programs”
Section 2.13.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 1.4, “What Is New in MySQL 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.13.5, “Copying MySQL Databases to Another Machine”
Section 6.2, “Database Backup Methods”
Description
Section 2.13.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.13.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.7.5.15, “SHOW DATABASES Syntax”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Section 2.3.8, “MySQL Server on Microsoft Windows Postinstallation Procedures”
Section 4.1, “Overview of MySQL Programs”
Section 2.3.5.8, “Testing The MySQL Server Installation on Microsoft Windows”

mysqlshow --status db_name

Section 12.7.5.38, “SHOW TABLE STATUS Syntax”

mysqlshow -k db_name tbl_name

Section 12.7.5.23, “SHOW INDEX Syntax”

mysqlshow db_name

Section 12.7.5.39, “SHOW TABLES Syntax”

mysqlshow db_name tbl_name

Section 12.7.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.7.5.39, “SHOW TABLES Syntax”

mysqlshow mysql user

Section C.5.2.15, “Ignoring user”

mysqlslap

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

mysqlslap [options]

Section 4.5.7, “mysqlslap — Load Emulation Client”

mysqltest

Section 21.1.2, “The MySQL Test Suite”

ndb_config

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.4, “MySQL Cluster Programs”
Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”

ndb_config --configinfo

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

ndb_config --configinfo --xml

Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”

ndb_desc

Section 17.2.4, “KEY Partitioning”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.5.11.1, “MySQL Cluster Disk Data Objects”
Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 19.8, “The INFORMATION_SCHEMA FILES Table”
Section 19.12, “The INFORMATION_SCHEMA PARTITIONS Table”

ndb_desc -d db_name table_name

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ndb_desc -d db_name table_name

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ndb_error_reporter

Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”

ndb_mgm

Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.5.12.1, “Adding MySQL Cluster Data Nodes Online: General Issues”
Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.7, “Changes in MySQL Cluster NDB 6.X and 7.X”
Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Section 16.5.5, “Event Reports Generated in MySQL Cluster”
Section 16.2.4, “Initial Startup of MySQL Cluster”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 16.2.1, “Installing MySQL Cluster on Linux”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.5.5.1, “MySQL Cluster Logging Management Commands”
Chapter 16, MySQL Cluster NDB 6.X/7.X
Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 16.4, “MySQL Cluster Programs”
Section 16.5.10.1, “MySQL Cluster Security and Networking Issues”
Section 16.5.7, “MySQL Cluster Single User Mode”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 16.5.3, “Online Backup of MySQL Cluster”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 16.5.9.7, “The ndbinfo memoryusage Table”
Section 16.5.9.8, “The ndbinfo nodes Table”
Section 16.5.9.11, “The ndbinfo transporters Table”
Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”
Section 4.2.3.1, “Using Options on the Command Line”
Section 16.5.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

ndb_mgm -e "ALL REPORT MEMORYUSAGE"

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ndb_mgm -e "START BACKUP"

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

ndb_mgm -e "START BACKUP"

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

ndb_mgm.exe

Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”

ndb_mgmd

Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Section 16.3.2.5, “Defining a MySQL Cluster Management Server”
Description
Section 16.2.4, “Initial Startup of MySQL Cluster”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 16.2.1, “Installing MySQL Cluster on Linux”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”
Section 16.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.5.5.1, “MySQL Cluster Logging Management Commands”
Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 16.4, “MySQL Cluster Programs”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.3.1, “Quick Test Setup of MySQL Cluster”
Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 16.5.1, “Summary of MySQL Cluster Start Phases”
Section 16.3.2.3, “The MySQL Cluster Connectstring”

ndb_mgmd.exe

Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”

ndb_restore

Section 6.1, “Backup and Recovery Types”
Section 16.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.1.4, “MySQL Cluster Development History”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.4, “MySQL Cluster Development in MySQL Cluster NDB 6.3”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.4.2, “MySQL Cluster Development in MySQL Cluster NDB 7.1”
Section 16.1, “MySQL Cluster Overview”
Section 16.4, “MySQL Cluster Programs”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
Section 16.6.10, “MySQL Cluster Replication: Multi-Master and Circular Replication”
Section 16.5.7, “MySQL Cluster Single User Mode”
Section 16.5.3, “Online Backup of MySQL Cluster”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
Section 16.2.7, “Upgrading and Downgrading MySQL Cluster”

ndb_schema

Section 16.6.4, “MySQL Cluster Replication Schema and Tables”

ndb_select_all

Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”

ndb_show_tables

Section 16.4, “MySQL Cluster Programs”
Section 16.6.4, “MySQL Cluster Replication Schema and Tables”
Section 16.5.10.3, “MySQL Cluster and MySQL Security Procedures”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”

ndb_size.pl

Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 2.15, “Perl Installation Notes”

ndbd

Section 16.4.2, “ndbd — The MySQL Cluster Data Node Daemon”
Section 16.5.12.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.5.2, “Commands in the MySQL Cluster Management Client”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Description
Section 16.2.4, “Initial Startup of MySQL Cluster”
Section 16.2.1.2, “Installing MySQL Cluster from RPM”
Section 16.2.1, “Installing MySQL Cluster on Linux”
Section 16.1.6.10, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 16.5, “Management of MySQL Cluster”
Section 16.6.9, “MySQL Cluster Backups With MySQL Cluster Replication”
Section 16.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
Section 16.1.4.5, “MySQL Cluster Development in MySQL Cluster NDB 6.2”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.2, “MySQL Cluster Installation”
Section 16.3.5.2, “MySQL Cluster Interconnects and Performance”
Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 16.4, “MySQL Cluster Programs”
Section 16.3.4.2, “MySQL Server Options for MySQL Cluster”
Section 16.3.3, “Overview of MySQL Cluster Configuration Parameters”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
Section 16.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 16.3.1, “Quick Test Setup of MySQL Cluster”
Section 16.3.2.11, “SCI Transport Connections in MySQL Cluster”
Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 16.5.1, “Summary of MySQL Cluster Start Phases”
Section 16.5.9.8, “The ndbinfo nodes Table”
Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”
Section 16.2.7.1, “Upgrade and downgrade compatibility: MySQL Cluster NDB 7.x”
Section 16.5.5.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
Section 16.3.5, “Using High-Speed Interconnects with MySQL Cluster”

ndbd --initial

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

ndbd --nostart

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

ndbd --initial

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

ndbd -n

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

ndbd options

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

ndbd.exe

Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”

ndbinfo

Section 16.5.9, “The ndbinfo MySQL Cluster Information Database”

ndbmtd

Section 16.5.12.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 16.5.12.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 16.2.1.3, “Building MySQL Cluster from Source on Linux”
Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”
Description
Section 16.2.1, “Installing MySQL Cluster on Linux”
Section 16.1.1, “MySQL Cluster Core Concepts”
Section 16.3.3.1, “MySQL Cluster Data Node Configuration Parameters”
Section 16.1.4, “MySQL Cluster Development History”
Section 16.1.4.3, “MySQL Cluster Development in MySQL Cluster NDB 7.0”
Section 16.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 16.4, “MySQL Cluster Programs”
Section 2.11.4, “MySQL Source-Configuration Options”
Section 16.5.4, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.6.9.2, “Point-In-Time Recovery Using MySQL Cluster Replication”
Section 16.1.6.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1, MySQL Cluster NDB 6.x, and MySQL Cluster NDB 7.x”
Section 16.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 16.5.9.8, “The ndbinfo nodes Table”
Section 16.2.7.3, “Upgrade and downgrade compatibility: MySQL 5.1”
Section 16.2.7.1, “Upgrade and downgrade compatibility: MySQL Cluster NDB 7.x”

ndbmtd.exe

Section 16.2.2.2, “Compiling and Installing MySQL Cluster from Source on Windows”
Section 16.2.2.3, “Initial Startup of MySQL Cluster on Windows”
Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”
Section 16.2.2.1, “Installing MySQL Cluster on Windows from a Binary Release”

net start

Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”

net stop

Section 16.2.2.4, “Installing MySQL Cluster Processes as Windows Services”

nm

Section 21.5.1.5, “Using a Stack Trace”

nm --numeric-sort mysqld

Description

numactl

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

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”

perror

Section 4.8.1, “perror — Explain Error Codes”
Section C.5.2.18, “'File' Not Found and Similar Errors”
Section C.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 C.1, “Sources of Error Information”

perror [options] errorcode ...

Section 4.8.1, “perror — Explain Error Codes”

pfexec

Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.6.2, “Installing MySQL on OpenSolaris using IPS”

ping

Section 14.3, “Using Linux HA Heartbeat”

pkg

Section 2.6.2, “Installing MySQL on OpenSolaris using IPS”

pkgadd

Section 2.6.1, “Installing MySQL on Solaris using a Solaris PKG”

pkgrm

Section 2.6.1, “Installing MySQL on Solaris using a Solaris PKG”

ppm

Section 2.15, “Perl Installation Notes”

ps

Description
Section 5.3.2.2, “End-User Guidelines for Password Security”
Section 7.9.4, “How MySQL Uses Memory”
Section C.5.1, “How to Determine What Is Causing a Problem”
Section 2.12.1.3, “Starting and Troubleshooting the MySQL Server”

ps auxw

Section 4.2.2, “Connecting to the MySQL Server”

ps xa | grep mysqld

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

pthread

Description

rename

Section 5.2.6, “Server Log Maintenance”
Section 5.2.2, “The Error Log”
Section 5.2.3, “The General Query Log”

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 15.3.3, “Using Replication for Scale-Out”

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 21.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.4.1.1, “PURGE BINARY LOGS Syntax”

rpm

Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.1.4.2, “Signature Checking Using GnuPG”

rpm --import

Section 2.1.4.3, “Signature Checking Using RPM”

rpmbuild

Section 2.11, “Installing MySQL from Source”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”

rsync

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

safe_mysqld

Description
Section 2.4, “Installing MySQL on Mac OS X”

scp

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

sed

Section 3.3.4.7, “Pattern Matching”

service

Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”

set

Section 2.14, “Environment Variables”

setenv

Section 2.14, “Environment Variables”
Section 4.2.4, “Setting Environment Variables”

sh

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

sleep

Description

ssh

Section 16.5.10.1, “MySQL Cluster Security and Networking Issues”

strings

Section 5.3.1, “General Security Guidelines”

su root

Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

sudo

Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

swinstall

Section 2.8.2, “Installing MySQL on HP-UX using DEPOT”

tar

Section 15.3.1.2, “Backing Up Raw Data from a Slave”
Section 6.1, “Backup and Recovery Types”
Section 2.1.2.2, “Choosing a Distribution Format”
Section 15.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 2.8.1, “General Notes on Installing MySQL on HP-UX”
Section 1.7, “How to Report Bugs or Problems”
Section 2.1.5, “Installation Layouts”
Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.11, “Installing MySQL from Source”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.4, “Installing MySQL on Mac OS X”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.15.1, “Installing Perl on Unix”
Section 15.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”

tcpdump

Section 5.3.1, “General Security Guidelines”

tcsh

Section C.5.2.18, “'File' Not Found and Similar Errors”
Section 2.14, “Environment Variables”
Section 2.4.1, “General Notes on Installing MySQL on Mac OS X”
Section 2.4, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.4, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

tee

Section 4.5.1.2, “mysql Commands”

telnet

Section 5.3.1, “General Security Guidelines”

top

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

ulimit

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

ulimit -n

Description

ulimit -c

Description

ulimit -c unlimited

Section 5.1.2, “Server Command Options”

ulimit -d 256000

Section C.5.2.10, “Packet too large”

ulimit -l

Section 16.3.2.6, “Defining MySQL Cluster Data Nodes”

ulimit -n 256

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

update-rc.d

Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

useradd

Section 2.2, “Installing MySQL from Generic Binaries on Unix/Linux”
Section 2.5.1, “Installing MySQL from RPM Packages on Linux”
Section 2.11.2, “Installing MySQL from a Standard Source Distribution”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 16.2.1.1, “Installing a MySQL Cluster Binary Release on Linux”

usermod

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

vi

Section 4.5.1.2, “mysql Commands”
Section 16.2.3, “Initial Configuration of MySQL Cluster”
Section 3.3.4.7, “Pattern Matching”

winMd5Sum

Section 2.1.4.1, “Verifying the MD5 Checksum”

xlC_r

Section 21.5, “Debugging and Porting MySQL”

yacc

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

yum

Section 2.5.2, “Installing MySQL on Linux using Native Package Manager”

zip

Section 15.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”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices