Command Index

--ndb-cluster

MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

--old-passwords

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

../dist/configure

Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.13.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

./configure

Section 2.10.3, “Installing from the Development Source Tree”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.10.2, “Typical configure Options”

./configure --help

Section 2.10.1, “Source Installation Overview”

./configure --without-server

Section 22.5, “Debugging and Porting MySQL”

./configure --help

Section 2.10.2, “Typical configure Options”

./configure; make; make install

Section 2.13.1.3, “Linux Source Distribution Notes”

./mysql-test-run.pl

Section 22.1.2, “MySQL Test Suite”

./mysql-test-run.pl test_name

Section 22.1.2, “MySQL Test Suite”

/etc/init.d/mysql

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

/etc/init.d/mysql stop

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

/usr/local/mysql/bin/mysql

Section 4.2.1, “Invoking MySQL Programs”

? [arg]

Section 4.5.1.2, “mysql Commands”

ALL STATUS

Section 17.7.6, “MySQL Cluster Single User Mode”

APF

Section 17.8.1, “MySQL Cluster Security and Networking Issues”

Access

Section 12.2.2, “DELETE Syntax”

BUILD/autorun.sh

Section 2.10.3, “Installing from the Development Source Tree”

BUILD/compile-pentium-max

Section 17.3.1, “Building MySQL Cluster from Source Code”

BUILD/compile-platform_name-max

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

CC

Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”

CRTUSRPRF

Section 2.7, “Installing MySQL on i5/OS”

EXIT SINGLE USER MODE

Section 17.7.6, “MySQL Cluster Single User Mode”

GnuPG

Section 2.1.4.2, “Signature Checking Using GnuPG

Help View

Section 2.5, “Installing MySQL on Mac OS X”

Hot Backup

Section 16.1.1, “How to Set Up Replication”

Hot Backup

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

InnoDB Hot Backup

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

InnoDB Hot Backup

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

InnoDB Hot Backup

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

Metrowerks CodeWarrior for NetWare

Section 2.8, “Installing MySQL on NetWare”

NET

Section 2.3.11, “Starting MySQL as a Windows Service”

NET START MySQL

Section 2.3.11, “Starting MySQL as a Windows Service”

NET STOP MySQL

Section 2.3.11, “Starting MySQL as a Windows Service”

NET START

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

NET START MySQL

Section 2.3.14, “Upgrading MySQL on Windows”

NET START MySQL

Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”

NET STOP

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

NET STOP MySQL

Section 2.3.11, “Starting MySQL as a Windows Service”

Notepad

Section 2.3.7, “Creating an Option File”
Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”

PGP

Section 2.1.4.2, “Signature Checking Using GnuPG

PowerArchiver

Section 16.1.1, “How to Set Up Replication”

Registry Editor

Section 2.3.11, “Starting MySQL as a Windows Service”

SELECT

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

SHOW

Description
Section 17.3.3, “Quick Test Setup of MySQL Cluster”

SHOW WARNINGS

MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

SHOW ERRORS

MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

Service Control Manager

Section 2.3, “Installing MySQL on Windows”
Section 2.3.11, “Starting MySQL as a Windows Service”

Services

Section 2.3.11, “Starting MySQL as a Windows Service”

Start>Run>cmd.exe

Section 5.5.7.4, “Setting Up SSL Certificates for MySQL”

Text in this style

Section 1.2, “Typographical and Syntax Conventions”

WinDbg

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

WinRAR

Section 16.1.1, “How to Set Up Replication”

WinZip

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

WordPad

Section 12.2.6, “LOAD DATA INFILE Syntax”

\! command

Section 4.5.1.2, “mysql Commands”

\#

Section 4.5.1.2, “mysql Commands”

\. file_name

Section 4.5.1.2, “mysql Commands”

\? [arg]

Section 4.5.1.2, “mysql Commands”

\C charset_name

Section 4.5.1.2, “mysql Commands”

\G

Section 4.5.1.2, “mysql Commands”

\P [command]

Section 4.5.1.2, “mysql Commands”

\R [str]

Section 4.5.1.2, “mysql Commands”

\T [file_name]

Section 4.5.1.2, “mysql Commands”

\W

Section 4.5.1.2, “mysql Commands”

\c

Section 4.5.1.2, “mysql Commands”

\d str

Section 4.5.1.2, “mysql Commands”

\e

Section 4.5.1.2, “mysql Commands”

\g

Section 4.5.1.2, “mysql Commands”

\h [arg]

Section 4.5.1.2, “mysql Commands”

\n

Section 4.5.1.2, “mysql Commands”

\p

Section 4.5.1.2, “mysql Commands”

\q

Section 4.5.1.2, “mysql Commands”

\r [db_name host_name]]

Section 4.5.1.2, “mysql Commands”

\s

Section 4.5.1.2, “mysql Commands”

\t

Section 4.5.1.2, “mysql Commands”

\u db_name

Section 4.5.1.2, “mysql Commands”

\w

Section 4.5.1.2, “mysql Commands”

aCC

Section 22.5, “Debugging and Porting MySQL”

addgroup

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 2.10.1, “Source Installation Overview”

adduser

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 2.10.1, “Source Installation Overview”

autoconf

Section 2.10.3, “Installing from the Development Source Tree”

automake

Section 2.10.3, “Installing from the Development Source Tree”

bash

Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 2.13.4.5, “BSD/OS Version 3.x Notes”
Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 2.5, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 4.2.4, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

bin/mysql_setpermission

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.10.1, “Source Installation Overview”

bin/mysqld_safe

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 2.10.1, “Source Installation Overview”
Section 2.11.2, “Unix Post-Installation Procedures”

bin/safe_mysqld

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.10.1, “Source Installation Overview”
Section 2.11.2, “Unix Post-Installation Procedures”

bison

Section 2.10.4, “Dealing with Problems Compiling MySQL”
Section 2.10.6, “Installing MySQL from Source on Windows”
Section 2.10.3, “Installing from the Development Source Tree”

bzr

Section 2.10.3, “Installing from the Development Source Tree”

c++

Section 2.10.4, “Dealing with Problems Compiling MySQL”

c++filt

Section 22.5.1.5, “Using a Stack Trace”

cat [> filename]

Section 4.5.1.1, “mysql Options”

cc

Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.13.5.2, “HP-UX Version 11.x Notes”
Section 22.5, “Debugging and Porting MySQL”
Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

charset

Section 4.5.1.2, “mysql Commands”

charset charset_name

Section 4.5.1.2, “mysql Commands”

charset_name charset_name

Section 4.5.1.2, “mysql Commands”

chkconfig

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 2.11.2.2, “Starting and Stopping MySQL Automatically”

chroot

Description

clear

Section 4.5.1.2, “mysql Commands”

cmake

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

cmake --help

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

cmd.exe

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

command.com

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

comp_err

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

comp_err [options]

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

comp_err [options] from_file ... to_file

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

compile-amd64-max-sci

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

compile-pentium-max

Section 17.3.1, “Building MySQL Cluster from Source Code”

compile-pentium64-max-sci

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

configure

Section 12.1.17, “CREATE TABLE Syntax”
Section B.1.2.17, “Can't initialize character set
Section 9.4, “Adding a New Character Set”
Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 2.13.4.6, “BSD/OS Version 4.x Notes”
Section 17.3.1, “Building MySQL Cluster from Source Code”
Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 22.2.3.3, “Creating a Plugin Library”
Section 2.10.4, “Dealing with Problems Compiling MySQL”
Section 2.14, “Environment Variables”
Section 2.13.4.1, “FreeBSD Notes”
Section 2.13.5.1, “HP-UX Version 10.20 Notes”
Section 2.13.5.2, “HP-UX Version 11.x Notes”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section B.1.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 1.6, “How to Report Bugs or Problems”
Section 2.13.5.3, “IBM-AIX notes”
Section 2.10.3, “Installing from the Development Source Tree”
Section 2.13.1.7, “Linux Alpha Notes”
Section 2.13.1.10, “Linux IA-64 Notes”
Section 2.13.1.3, “Linux Source Distribution Notes”
Section 2.13.1.5, “Linux x86 Notes”
Section 2.10.5, “MIT-pthreads Notes”
Section 2.13.2.1, “Mac OS X 10.x (Darwin)”
Section 2.1.2.4, “MySQL Binaries Compiled by Sun Microsystems, Inc.”
Section 2.10, “MySQL Installation Using a Source Distribution”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 5.6.2, “Running Multiple Servers on Unix”
Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.13.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”
Section 2.13.5.7, “SGI Irix Notes”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 9.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”
Section 2.13.3.1, “Solaris 2.7/2.8 Notes”
Section 2.13.3, “Solaris Notes”
Section 2.13.3.2, “Solaris x86 Notes”
Section 2.10.1, “Source Installation Overview”
Section 2.13.5.4, “SunOS 4 Notes”
The mysqld-max Extended MySQL Server
Section 13.12, “The ARCHIVE Storage Engine”
Section 13.14, “The BLACKHOLE Storage Engine”
Section 13.13, “The CSV Storage Engine”
Section 13.10, “The EXAMPLE Storage Engine”
Section 13.11, “The FEDERATED Storage Engine”
Section 13.5, “The MyISAM Storage Engine”
Section 9.2, “The Character Set Used for Data and Sorting”
Section 7.5.5, “The MySQL Query Cache”
Section 2.10.2, “Typical configure Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 4.2.3.3, “Using Option Files”
Section 5.5.7.2, “Using SSL Connections”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”
Section 21.9, “libmysqld, the Embedded MySQL Server Library”

configure --help

Section 2.10.2, “Typical configure Options”

configure.js

Section 17.3.1, “Building MySQL Cluster from Source Code”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 2.10.2, “Typical configure Options”

connect [db_name host_name]]

Section 4.5.1.2, “mysql Commands”

copy

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

coreadm

Section 5.1.2, “Server Command Options”

cp

Chapter 6, Backup and Recovery
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 22.2.3.3, “Creating a Plugin Library”
Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”

crash-me

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

cron

Section 12.5.2.3, “CHECK TABLE Syntax”
Section B.1.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.4.6, “Setting Up a Table Maintenance Schedule”
Section 3.5, “Using mysql in Batch Mode”

csh

Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 2.13.4.5, “BSD/OS Version 3.x Notes”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.4, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

cxx

Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 22.5, “Debugging and Porting MySQL”

delimiter str

Section 4.5.1.2, “mysql Commands”

df

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

drwtsn32.exe

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

dump

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

dyld

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

ecc/icc

Section 22.5, “Debugging and Porting MySQL”

edit

Section 4.5.1.2, “mysql Commands”

egcs

Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

ego

Section 4.5.1.2, “mysql Commands”

exit

Section 4.5.1.2, “mysql Commands”

fcc/FCC

Section 2.13.1.3, “Linux Source Distribution Notes”

fsadm

Section 2.13.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

g++

Section 2.10.4, “Dealing with Problems Compiling MySQL”

gcc

Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 21.9.1, “Compiling Programs with libmysqld
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.10.4, “Dealing with Problems Compiling MySQL”
Section 2.13.4.1, “FreeBSD Notes”
Section 2.13.5.1, “HP-UX Version 10.20 Notes”
Section 2.13.5.2, “HP-UX Version 11.x Notes”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 2.13.5.3, “IBM-AIX notes”
Section 2.13.1.7, “Linux Alpha Notes”
Section 2.13.1.10, “Linux IA-64 Notes”
Section 2.13.1.9, “Linux MIPS Notes”
Section 2.13.1.3, “Linux Source Distribution Notes”
Section 2.13.1.5, “Linux x86 Notes”
Section 2.10, “MySQL Installation Using a Source Distribution”
Section 22.5, “Debugging and Porting MySQL”
Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.13.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”
Section 2.13.5.7, “SGI Irix Notes”
Section 2.13.3.1, “Solaris 2.7/2.8 Notes”
Section 2.13.3, “Solaris Notes”
Section 2.13.3.2, “Solaris x86 Notes”
Section 2.10.2, “Typical configure Options”

gcc-c++

Section 2.10.4, “Dealing with Problems Compiling MySQL”

gdb

Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.5.1.4, “Debugging mysqld under gdb
Section 2.13.1.7, “Linux Alpha Notes”
Section 2.13.3.2, “Solaris x86 Notes”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

gmake

Section 2.13.4.1, “FreeBSD Notes”
Section 2.13.5.3, “IBM-AIX notes”
Section 2.10.3, “Installing from the Development Source Tree”
Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.13.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

gnutar

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.13.2, “Mac OS X Notes”
Section 2.10, “MySQL Installation Using a Source Distribution”

go

Section 4.5.1.2, “mysql Commands”

gpg

Section 2.1.4.2, “Signature Checking Using GnuPG

gpg --import

Section 2.1.4.2, “Signature Checking Using GnuPG

grep

Description
Section 3.3.4.7, “Pattern Matching”

groupadd

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.4, “Installing MySQL from RPM Packages on Linux”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 2.10.1, “Source Installation Overview”

gtar

Section 2.13.5.1, “HP-UX Version 10.20 Notes”
Section 2.13.5.2, “HP-UX Version 11.x Notes”
Section 2.6, “Installing MySQL on Solaris”
Section 2.13.3, “Solaris Notes”

gunzip

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.10.1, “Source Installation Overview”

gzip

Section 1.6, “How to Report Bugs or Problems”

gzip --fast

Section 17.3.4.6, “Defining MySQL Cluster Data Nodes”

hdparm

Section 13.6.3, “InnoDB Startup Options and System Variables”

help [arg]

Section 4.5.1.2, “mysql Commands”

help contents

Section 4.5.1.3, “mysql Server-Side Help”

hostname

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

ibback

Chapter 6, Backup and Recovery

ibbackup

Chapter 6, Backup and Recovery

icc

Section 22.5, “Debugging and Porting MySQL”
Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”

idtune

Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.13.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

idtune name parameter

Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.13.5.10, “SCO UnixWare 7.1.x and OpenUNIX 8.0.0 Notes”

innochecksum

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

innochecksum [options] file_name

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

iptables

Section 17.8.1, “MySQL Cluster Security and Networking Issues”

isamchk

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

isamchk -r

Section 4.6.3.3, “myisamchk Repair Options”

isamchk -rq

Description

isamchk [options] tbl_name

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

isamlog

Description
Section 4.1, “Overview of MySQL Programs”

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

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

kill

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

kill -9

Section D.5, “Restrictions on XA Transactions”

kswapd

Section 17.3.4.6, “Defining MySQL Cluster Data Nodes”

ld

Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”

ld-elf.so.1

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

ld.so

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

ldconfig

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

less

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

libtool

Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 22.2.3.3, “Creating a Plugin Library”
Section 2.10.3, “Installing from the Development Source Tree”
Section 2.10, “MySQL Installation Using a Source Distribution”
Section 2.13.5.4, “SunOS 4 Notes”

ln

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”

lockd

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

logger

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

ls

Section 6.1, “Database Backups”

m4

Section 2.10.3, “Installing from the Development Source Tree”

make

Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 2.13.4.5, “BSD/OS Version 3.x Notes”
Section 2.13.4.6, “BSD/OS Version 4.x Notes”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 22.2.3.3, “Creating a Plugin Library”
Section 2.10.4, “Dealing with Problems Compiling MySQL”
Section 2.13.4.1, “FreeBSD Notes”
Section 2.13.5.3, “IBM-AIX notes”
Section 2.10.3, “Installing from the Development Source Tree”
Section 2.10, “MySQL Installation Using a Source Distribution”
Section 2.13.4.2, “NetBSD Notes”
Section 2.15.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.13.3.1, “Solaris 2.7/2.8 Notes”
Section 2.13.5.4, “SunOS 4 Notes”
Section 2.10.2, “Typical configure Options”

make install

Section 22.2.3.3, “Creating a Plugin Library”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

make perl

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

make realclean

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

make test

Section 2.10.3, “Installing from the Development Source Tree”

make -f Makefile.aperl inst_perl MAP_TARGET=perl

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

make -k

Section 2.10.2, “Typical configure Options”

make distclean

Section 2.10.4, “Dealing with Problems Compiling MySQL”

make install

Section 22.2.3.3, “Creating a Plugin Library”
Section 2.13.4.1, “FreeBSD Notes”
Section 2.10.3, “Installing from the Development Source Tree”
Section 2.13.1.5, “Linux x86 Notes”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.10.1, “Source Installation Overview”

make perl

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

make test

Section 2.15.1, “Installing Perl on Unix”
Section 22.1.2, “MySQL Test Suite”

make_binary_distribution

Section 4.1, “Overview of MySQL Programs”

make_win_bin_dist

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

make_win_bin_dist [options] package_basename [copy_def ...]

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

make_win_src_distribution

Section 4.1, “Overview of MySQL Programs”

md5

Section 2.1.4.1, “Verifying the MD5 Checksum”

md5sum

Section 2.1.4.1, “Verifying the MD5 Checksum”

memcached

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

mkdev mysql

Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”

mkdev aio

Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”

mkdev mysql

Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”

mkdir

Section 12.1.10, “CREATE DATABASE Syntax”

mod_perl

Section 7.1.3, “What We Have Used MySQL For”

more

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

msql2mysql

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

msql2mysqlC-source-file ...

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

my_print_defaults

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

my_print_defaults [options] option_group ...

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

myisam_ftdump

Section 4.6.2, “myisam_ftdump — Display Full-Text Index information”
Description
Section 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.5, “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 12.5.2.6, “REPAIR TABLE Syntax”
Section 2.3.3.2, “Choosing an Install Type”
Section 13.5.3.3, “Compressed Table Characteristics”
Section 13.5.4.1, “Corrupted MyISAM Tables”
Section 6.1, “Database Backups”
Section 22.5.1, “Debugging a MySQL Server”
Description
Description
Description
Section 7.3.4, “External Locking”
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 6.4.5, “Getting Information About a Table”
Section 6.4.2, “How to Check MyISAM Tables for Errors”
Section 6.4.3, “How to Repair Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 2.8, “Installing MySQL on NetWare”
Section 4.6.3.4, “Other myisamchk Options”
Section 7.2.24, “Other Optimization Tips”
Section 4.1, “Overview of MySQL Programs”
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 5.1.2, “Server Command Options”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section 7.2.21, “Speed of INSERT Statements”
Section 13.5.3.1, “Static (Fixed-Length) Table Characteristics”
Section 7.5.2, “System Factors and Startup Parameter Tuning”
Section 6.4, “Table Maintenance and Crash Recovery”
Section 6.4.4, “Table Optimization”
Section 13.5, “The MyISAM Storage Engine”
Section 6.4.1, “Using myisamchk for Crash Recovery”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

myisamchk --analyze

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

myisamchk --description --verbose

Section 7.2.3, “Speed of SELECT Queries”

myisamchk --help

Section 4.6.3.1, “myisamchk General Options”

myisamchk --medium-check tbl_name

Section 12.5.2.3, “CHECK TABLE Syntax”

myisamchk --recover

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

myisamchk --safe-recover

Section 12.5.2.6, “REPAIR TABLE Syntax”

myisamchk --safe-recover tbl_name

Section 6.4.3, “How to Repair Tables”

myisamchk --stats_method=method_name --analyze

Section 7.4.6, “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 -dvv

Description

myisamchk -r

Section 6.1, “Database Backups”

myisamchk -rq

Description

myisamchk *.MYI

Section 6.4.3, “How to Repair Tables”

myisamchk --analyze

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

myisamchk --description --verbose tbl_name

Section 4.6.3.4, “Other myisamchk Options”

myisamchk --fast

Section 13.5, “The MyISAM Storage Engine”

myisamchk --help

Description

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

Section 7.2.21, “Speed of INSERT Statements”

myisamchk --medium-check

Section 4.6.3.2, “myisamchk Check Options”

myisamchk --recover tbl_name

Section 12.5.2.6, “REPAIR TABLE Syntax”

myisamchk --recover --quick

Section 12.5.2.6, “REPAIR TABLE Syntax”

myisamchk --safe-recover

Section 12.5.2.6, “REPAIR TABLE Syntax”

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

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

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

Section 7.2.3, “Speed of SELECT Queries”

myisamchk -a

Section 12.5.5.23, “SHOW INDEX Syntax”
Section 6.4.5, “Getting Information About a Table”

myisamchk -d

Section 6.4.5, “Getting Information About a Table”

myisamchk -d tbl_name

Section 6.4.5, “Getting Information About a Table”

myisamchk -d -v

Section 6.4.5, “Getting Information About a Table”

myisamchk -d -v tbl_name

Section 6.4.5, “Getting Information About a Table”

myisamchk -dv

Section 12.5.6.5, “LOAD INDEX INTO CACHE Syntax”

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

Section B.1.2.12, “The table is full

myisamchk -dv tbl_name

Section 4.6.3.5, “myisamchk Memory Usage”

myisamchk -dvv tbl_name

Section 9.6, “Problems With Character Sets”

myisamchk -e *.MYI

Section 6.4.3, “How to Repair Tables”

myisamchk -ed

Section 13.5.3.2, “Dynamic Table Characteristics”

myisamchk -ei

Section 13.5.3.2, “Dynamic Table Characteristics”

myisamchk -eis

Section 6.4.5, “Getting Information About a Table”

myisamchk -eis tbl_name

Section 6.4.5, “Getting Information About a Table”

myisamchk -eiv

Section 6.4.5, “Getting Information About a Table”

myisamchk -eiv tbl_name

Section 6.4.5, “Getting Information About a Table”

myisamchk -r

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

myisamchk -r database/table.MYI

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

myisamchk -r tbl_name

Section 6.4.3, “How to Repair Tables”

myisamchk -r -q

Section 6.4.3, “How to Repair Tables”

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

Section 2.12.1, “Upgrading MySQL”

myisamchk -r -q --set-collation=collation_name

Section 9.2, “The Character Set Used for Data and Sorting”
Section 2.10.2, “Typical configure Options”

myisamchk -r -q tbl_name

Section 6.4.3, “How to Repair Tables”

myisamchk -rq

Description

myisamchk -rq /path/to/db/tbl_name

Section 7.2.21, “Speed of INSERT Statements”

myisamchk -s

Section 6.4.6, “Setting Up a Table Maintenance Schedule”

myisamchk -s database/*.MYI

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

myisamchk [options] tbl_name ...

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

myisamlog

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

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

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

myisampack

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

myisampack [options] file_name ...

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

mysql

Section 1.7.5.6, “'--' as the Start of a Comment”
Section 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.1, “mysql Options”
Section 4.5.1.3, “mysql Server-Side Help”
Section 4.5.1.5, “mysql Tips”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.6.4.4, “FOREIGN KEY Constraints”
Section 12.3.3, “HELP Syntax”
Section B.1.2.15, “Ignoring user
Section 7.2.17, “LIMIT Optimization”
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 12.6.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section B.1.2.8, “Out of memory
Section B.1.2.10, “Packet too large
Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.5.5.36, “SHOW SLAVE STATUS Syntax”
Section 21.10.3.14, “mysql_errno()
Section 21.10.3.66, “mysql_sqlstate()
Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 17.7.8.1, “Adding MySQL Cluster Data Nodes Online: General Issues”
Section 5.5.2, “Adding User Accounts”
Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 11.13.5, “Analyzing Spatial Information”
Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Chapter 6, Backup and Recovery
Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.3.3.5, “Changes Made by MySQL Installation Wizard”
Changes in Release 4.1.x (Production)
Section 2.3.3.2, “Choosing an Install Type”
Section 4.2.3.3.1, “Command-Line Options that Affect Option-File Handling”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Section 8.5, “Comment Syntax”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 4.6.10.6, “Connecting to MySQL Instance Manager”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 9.1.4, “Connection Character Sets and Collations”
Section 21.10.11, “Controlling Automatic Reconnection Behavior”
Section 2.12.5, “Copying MySQL Databases to Another Machine”
Section 3.3.1, “Creating and Selecting a Database”
Section 13.6.2.3, “Creating the InnoDB Tablespace”
Section 22.5.2, “Debugging a MySQL Client”
Section 19.1, “Defining Stored Programs”
Description
Description
Description
Description
Description
Description
Section 4.5.1.5.3, “Disabling mysql Auto-Reconnect”
Section 2.12.2, “Downgrading MySQL”
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 3.2, “Entering Queries”
Section 2.14, “Environment Variables”
Section 6.2, “Example Backup and Recovery Strategy”
Section 3.6, “Examples of Common Queries”
Section 4.5.1.4, “Executing SQL Statements from a Text File”
Chapter 11, Functions and Operators
Section B.1.1, “How to Determine What Is Causing a Problem”
Section 1.6, “How to Report Bugs or Problems”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 11.11.3, “Information Functions”
Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.5, “Installing MySQL on Mac OS X”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.12.8, “Issues Exclusive to MySQL Cluster”
Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 5.3.2, “Making MySQL Secure Against Attackers”
MySQL 4.1 FAQ — MySQL Cluster
Section 1.4.1, “What Is New in MySQL 5.1”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Chapter 17, MySQL Cluster NDB 6.X/7.X
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 9.7, “MySQL Server Time Zone Support”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
Section B.1.8.1, “Open Issues in MySQL”
Section 7.2, “Optimizing SELECT and Other Statements”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 4.1, “Overview of MySQL Programs”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 6.3, “Point-in-Time Recovery”
Section 2.11.2.1, “Problems Running mysql_install_db
Section 4.2.3.2, “Program Option Modifiers”
Section 2.12.4, “Rebuilding or Repairing Tables or Indexes”
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section 12.2.9.11, “Rewriting Subqueries as Joins”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 5.3.3, “Security-Related mysqld Options”
Section B.3, “Server Error Codes and Messages”
Section 5.1.4, “Server System Variables”
Section 5.1.9, “Server-Side Help”
Section 4.2.3, “Specifying Program Options”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 2.11.2.2, “Starting and Stopping MySQL Automatically”
Section 2.3.12, “Testing The MySQL Installation”
Section 10.4.3, “The BLOB and TEXT Types”
Section 5.2.4, “The Binary Log”
Section 19.3.1, “Trigger Syntax”
Section 13.6.13.4, “Troubleshooting InnoDB Data Dictionary Operations”
Chapter 3, Tutorial
Section 2.10.2, “Typical configure Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.12.1, “Upgrading MySQL”
Section 3.5, “Using mysql in Batch Mode”
Section 6.2.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.7.2, “Using SSL Connections”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 4.5.1.5.2, “Using the --safe-updates Option”
Section 2.11.1, “Windows Post-Installation Procedures”
Section 11.10, “XML Functions”

mysql --help

Section 4.1, “Overview of MySQL Programs”

mysql -u root mysql

Section 2.11.2.1, “Problems Running mysql_install_db

mysql ... --debug

Section 22.5.1.1, “Compiling MySQL for Debugging”

mysql < file_name

Section 8.5, “Comment Syntax”

mysql [options] db_name

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

mysql {start|stop}

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

mysql-server

Section 2.13.4.1, “FreeBSD Notes”

mysql-test-run

Section 22.1.2, “MySQL Test Suite”

mysql-test-run.pl

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

mysql.exe

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

mysql.server

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

mysql.server stop

Section 2.11.2.2, “Starting and Stopping MySQL Automatically”

mysql_config

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

mysql_config --libmysqld-libs

Section 21.9.1, “Compiling Programs with libmysqld

mysql_config --plugindir

Section 22.2.1, “Characteristics of the Plugin Interface”

mysql_config options

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

mysql_convert_table_format

Section 4.1, “Overview of MySQL Programs”

mysql_create_system_tables

Section 4.1, “Overview of MySQL Programs”

mysql_explain_log

Section 4.1, “Overview of MySQL Programs”

mysql_find_rows

Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 4.1, “Overview of MySQL Programs”

mysql_fix_extensions

Section 4.1, “Overview of MySQL Programs”

mysql_fix_privilege_tables

Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 4.1, “Overview of MySQL Programs”
Section 5.5.6.3, “Password Hashing in MySQL”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

mysql_install_db

Section 5.5.2, “Adding User Accounts”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.1.5, “Installation Layouts”
Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.5, “Installing MySQL on Mac OS X”
Section 2.8, “Installing MySQL on NetWare”
Section 2.13.1.2, “Linux Binary Distribution Notes”
Section 4.1, “Overview of MySQL Programs”
Section 2.11.2.1, “Problems Running mysql_install_db
Section 13.6.14, “Restrictions on InnoDB Tables”
Section 2.11.3, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.1.9, “Server-Side Help”
Section 2.10.1, “Source Installation Overview”
Section 2.11.2, “Unix Post-Installation Procedures”
Section 2.11.1, “Windows Post-Installation Procedures”

mysql_install_db --force

Section 2.13.1.2, “Linux Binary Distribution Notes”

mysql_secure_installation

Section 4.1, “Overview of MySQL Programs”

mysql_setpermission

Section 4.1, “Overview of MySQL Programs”

mysql_stmt_execute()

Section 5.1.7, “Server Status Variables”

mysql_stmt_prepare()

Section 5.1.7, “Server Status Variables”

mysql_tableinfo

Section 4.1, “Overview of MySQL Programs”

mysql_tzinfo_to_sql

Section 9.7, “MySQL Server Time Zone Support”
Section 4.1, “Overview of MySQL Programs”

mysql_upgrade

Section 12.1.1, “ALTER DATABASE Syntax”
Section 12.1.11, “CREATE EVENT Syntax”
Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 22.2.1, “Characteristics of the Plugin Interface”
Section 2.12.3, “Checking Whether Table Indexes Must Be Rebuilt”
Description
Section 1.4.1, “What Is New in MySQL 5.1”
Section 4.1, “Overview of MySQL Programs”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 2.12.4, “Rebuilding or Repairing Tables or Indexes”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 22.2, “The MySQL Plugin Interface”
Section 2.12.1, “Upgrading MySQL”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

mysql_waitpid

Section 4.1, “Overview of MySQL Programs”

mysql_zap

Section B.1.2.2, “Can't connect to [local] MySQL server
Section 4.1, “Overview of MySQL Programs”

mysqlaccess

Section 4.6.6, “mysqlaccess — Client for Checking Access Privileges”
Section 5.4.7, “Causes of Access-Denied Errors”
Description
Section 1.6, “How to Report Bugs or Problems”
Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 4.1, “Overview of MySQL Programs”

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

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

mysqladmin

Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 12.1.10, “CREATE DATABASE Syntax”
Section B.1.2.2, “Can't connect to [local] MySQL server
Section 12.1.21, “DROP DATABASE Syntax”
Section 12.5.6.3, “FLUSH Syntax”
Section 5.5.5, “Assigning Account Passwords”
Section 2.13.4.6, “BSD/OS Version 4.x Notes”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Description
Section 6.4.3, “How to Repair Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 2.5, “Installing MySQL on Mac OS X”
Section 2.8, “Installing MySQL on NetWare”
Section 2.7, “Installing MySQL on i5/OS”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 4.1, “Overview of MySQL Programs”
Section 5.4.1, “Privileges Provided by MySQL”
Section 5.6.2, “Running Multiple Servers on Unix”
Section 2.11.3, “Securing the Initial MySQL Accounts”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 5.1.11, “The Shutdown Process”
Section 7.5.3, “Tuning Server Parameters”
Section 2.11.2, “Unix Post-Installation Procedures”
Section 2.3.14, “Upgrading MySQL on Windows”
Section 4.2.3.3, “Using Option Files”

mysqladmin create

Section 2.13.5.7, “SGI Irix Notes”

mysqladmin debug

Section 12.5.1.3, “GRANT Syntax”
Section 5.4.1, “Privileges Provided by MySQL”

mysqladmin flush-hosts

Section 7.5.11, “How MySQL Uses DNS”

mysqladmin flush-logs

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

mysqladmin flush-privileges

Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.12.5, “Copying MySQL Databases to Another Machine”
Section 5.4.2, “Privilege System Grant Tables”
Section 2.11.2.1, “Problems Running mysql_install_db
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.4.6, “When Privilege Changes Take Effect”

mysqladmin flush-tables

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

mysqladmin flush-xxx

Section 5.5.2, “Adding User Accounts”

mysqladmin kill

Section B.1.4.3, “How MySQL Handles a Full Disk”
Section 5.4.1, “Privileges Provided by MySQL”

mysqladmin password

Section 5.5.5, “Assigning Account Passwords”

mysqladmin processlist

Section 5.3.2, “Making MySQL Secure Against Attackers”

mysqladmin processlist status

Section 22.5.1, “Debugging a MySQL Server”

mysqladmin refresh

Section 5.5.2, “Adding User Accounts”
Section B.1.8.2, “Additional Known Issues”
Section 7.4.7, “How MySQL Opens and Closes Tables”
Section B.1.8.1, “Open Issues in MySQL”
Section 5.2.6, “Server Log Maintenance”

mysqladmin reload

Section 5.5.4, “Limiting Account Resources”
Section 2.11.2.1, “Problems Running mysql_install_db
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”

mysqladmin shutdown

Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 2.13.5.3, “IBM-AIX notes”
Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.22, “Replication and Temporary Tables”
Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 2.3.11, “Starting MySQL as a Windows Service”

mysqladmin variables

Section B.1.2.9, “MySQL server has gone away

mysqladmin ver

Section 22.5.1.1, “Compiling MySQL for Debugging”

mysqladmin version

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

mysqladmin --sleep

Section 2.10.5, “MIT-pthreads Notes”

mysqladmin -h localhost variables

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

mysqladmin -i 5 -r status

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

mysqladmin -i 5 status

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

mysqladmin -i10 processlist status

Section 22.5.1, “Debugging a MySQL Server”

mysqladmin -u root ping

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

mysqladmin -u root drop test

Section 2.11.2, “Unix Post-Installation Procedures”

mysqladmin -u root processlist

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

mysqladmin -u root processlist

Section B.1.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.5.5.34, “SHOW SCHEDULER STATUS Syntax”
Section 22.5.1, “Debugging a MySQL Server”

mysqladmin extended-status

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

mysqladmin flush-hosts

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

mysqladmin flush-logs

Section 6.2.1, “Backup Policy”
Section 6.2.3, “Backup Strategy Summary”
Section 16.4.2, “Replication Relay and Status Files”
Section 5.2.6, “Server Log Maintenance”
Section 16.4.2.1, “The Slave Relay Log”

mysqladmin flush-privileges

Description

mysqladmin flush-tables

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

mysqladmin kill

Section 12.5.6.4, “KILL Syntax”
Section B.1.2.9, “MySQL server has gone away
Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.13.5.3, “IBM-AIX notes”
Section 11.11.4, “Miscellaneous Functions”
Section 2.3.15, “MySQL on Windows Compared to MySQL on Unix”

mysqladmin password

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

mysqladmin processlist

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

mysqladmin refresh

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

mysqladmin reload

Section 5.5.2, “Adding User Accounts”
Description
Section 1.6, “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.6, “How to Report Bugs or Problems”

mysqladmin shutdown

Section 12.5.1.3, “GRANT Syntax”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 22.5.1.2, “Creating Trace Files”
Section 13.6.2.3, “Creating the InnoDB Tablespace”
Description
Section 6.4.3, “How to Repair Tables”
Section 2.5, “Installing MySQL on Mac OS X”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 2.3.15, “MySQL on Windows Compared to MySQL on Unix”
Section 5.4.1, “Privileges Provided by MySQL”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 2.11.2.2, “Starting and Stopping MySQL Automatically”
Section 5.1.11, “The Shutdown Process”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

mysqladmin status

Section 21.10.3.68, “mysql_stat()
Description
Section 7.4.7, “How MySQL Opens and Closes Tables”

mysqladmin variables

Section 12.5.5.41, “SHOW VARIABLES Syntax”

mysqladmin variables extended-status processlist

Section 1.6, “How to Report Bugs or Problems”

mysqladmin version

Section B.1.2.9, “MySQL server has gone away
Section 1.6, “How to Report Bugs or Problems”
Section 2.11.2, “Unix Post-Installation Procedures”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”

mysqlanalyze

Description

mysqlbinlog

Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 12.5.6.1, “BINLOG Syntax”
Section 12.5.4, “SET Syntax”
Section 12.5.5.3, “SHOW BINLOG EVENTS Syntax”
Section 12.6.2.7, “START SLAVE Syntax”
Section B.1.8.2, “Additional Known Issues”
Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Description
Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 11.11.4, “Miscellaneous Functions”
Section B.1.8.1, “Open Issues in MySQL”
Section 4.1, “Overview of MySQL Programs”
Section 6.3, “Point-in-Time Recovery”
Section 16.4.2, “Replication Relay and Status Files”
Section 16.3.1.28, “Replication and Variables”
Section 6.3.2, “Specifying Positions for Recovery”
Section 6.3.1, “Specifying Times for Recovery”
Section 5.2.4, “The Binary Log”
Section 16.4.2.1, “The Slave Relay Log”
Section 6.2.2, “Using Backups for Recovery”

mysqlbinlog binary-log-file | mysql

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

mysqlbinlog [options] log_file ...

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

mysqlbinlog|mysql

Section B.1.8.2, “Additional Known Issues”
Section B.1.8.1, “Open Issues in MySQL”

mysqlbug

Section 1.6, “How to Report Bugs or Problems”

mysqlc

Section 2.3.12, “Testing The MySQL Installation”

mysqlcheck

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

mysqlcheck --check-upgrade

Section 2.12.3, “Checking Whether Table Indexes Must Be Rebuilt”

mysqlcheck --check-upgrade

Section 2.12.3, “Checking Whether Table Indexes Must Be Rebuilt”

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

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqld

Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.3.1, “mysqld — The MySQL Server”
Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section B.1.2.18, “'File' Not Found and Similar Errors”
Section 12.5.2.4, “CHECKSUM TABLE Syntax”
Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 12.1.20, “CREATE VIEW Syntax”
Section B.1.2.2, “Can't connect to [local] MySQL server
Section B.1.2.13, “Can't create/write to file
Section B.1.2.17, “Can't initialize character set
Section B.1.2.4, “Client does not support authentication protocol
Section 12.5.6.3, “FLUSH Syntax”
Section B.1.2.6, “Host 'host_name' is blocked
Section 12.2.5.2, “INSERT DELAYED Syntax”
Section B.1.2.15, “Ignoring user
Section 13.6.2, “InnoDB Configuration”
Section 13.6.13.3, “InnoDB General Troubleshooting”
Section 13.6.3, “InnoDB Startup Options and System Variables”
Section 12.5.6.4, “KILL Syntax”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 13.5.1, “MyISAM Startup Options”
Section B.1.2.9, “MySQL server has gone away
Section 12.5.2.5, “OPTIMIZE TABLE Syntax”
Section B.1.2.10, “Packet too large
Section 12.2.8, “SELECT Syntax”
Section 12.4.6, “SET TRANSACTION Syntax”
Section 13.6.13.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.5.5.16, “SHOW ENGINE Syntax”
Section 12.5.5.41, “SHOW VARIABLES Syntax”
Section B.1.2.12, “The table is full
Section B.1.2.7, “Too many connections
Section 21.10.3.1, “mysql_affected_rows()
Section 21.10.3.49, “mysql_options()
Section 22.3, “Adding New Functions to MySQL”
Section 22.4, “Adding New Procedures to MySQL”
Section 22.3.2, “Adding a New User-Defined Function”
Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section B.1.8.2, “Additional Known Issues”
Section 2.13.5.6, “Alpha-DEC-OSF/1 Notes”
Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 2.13.4.5, “BSD/OS Version 3.x Notes”
Section 2.13.4.6, “BSD/OS Version 4.x Notes”
Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Section 16.1.3.4, “Binary Log Options and Variables”
Section 5.2.4.1, “Binary Logging Formats”
Section 2.10.6.1, “Building MySQL from Source Using CMake and Visual Studio”
Section 11.9, “Cast Functions and Operators”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.1.2.2, “Choosing a Distribution Format”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Section 8.5, “Comment Syntax”
Section B.1.2.11, “Communication Errors and Aborted Connections”
Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 7.2.7, “Condition Pushdown Optimization”
Section 13.6.4.3.2, “Configurable InnoDB Auto-Increment Locking”
Section 13.5.4.1, “Corrupted MyISAM Tables”
Section 22.5.1.2, “Creating Trace Files”
Section 13.6.2.3, “Creating the InnoDB Tablespace”
Section 13.6.2.4, “Dealing with InnoDB Initialization Problems”
Section 2.10.4, “Dealing with Problems Compiling MySQL”
Section 22.5.1.4, “Debugging mysqld under gdb
Section 22.5.1, “Debugging a MySQL Server”
Section 17.3.4.7, “Defining SQL and Other API Nodes in a MySQL Cluster”
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Description
Section 2.14, “Environment Variables”
Section 7.3.4, “External Locking”
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 13.6.6.2, “Forcing InnoDB Recovery”
Section 2.13.4.1, “FreeBSD Notes”
Section 7.5.6.2, “General Thread States”
Section 7.5.1, “How Compiling and Linking Affects the Speed of MySQL”
Section 7.4.7, “How MySQL Opens and Closes Tables”
Section 7.5.11, “How MySQL Uses DNS”
Section 7.5.8, “How MySQL Uses Memory”
Section 7.2.19, “How to Avoid Table Scans”
Section B.1.1, “How to Determine What Is Causing a Problem”
Section 6.4.3, “How to Repair Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 2.13.5.3, “IBM-AIX notes”
Section 8.2.2, “Identifier Case Sensitivity”
Section 17.2.4, “Initial Startup of MySQL Cluster”
Section 2.1.5, “Installation Layouts”
Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.4, “Installing MySQL from RPM Packages on Linux”
Section 2.5, “Installing MySQL on Mac OS X”
Section 2.7, “Installing MySQL on i5/OS”
Section 17.12.8, “Issues Exclusive to MySQL Cluster”
Section 2.13.1.7, “Linux Alpha Notes”
Section 2.13.1.2, “Linux Binary Distribution Notes”
Section 2.13.1.1, “Linux Operating System Notes”
Section 2.13.1.4, “Linux Post-Installation Notes”
Section 2.13.1.3, “Linux Source Distribution Notes”
Section 2.13.1.5, “Linux x86 Notes”
Section 2.10.5, “MIT-pthreads Notes”
Section 2.13.2.1, “Mac OS X 10.x (Darwin)”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 22.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 11.11.4, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
MySQL 4.1 FAQ — MySQL Cluster
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section A.3, “MySQL 5.1 FAQ — Server SQL Mode”
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 17.3.4.1, “MySQL Cluster Configuration — Basic Example”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.6, “MySQL Cluster Programs”
Section 17.4.1, “MySQL Cluster Server Option and Variable Reference”
Section 17.4.3, “MySQL Cluster System Variables”
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 4.6.10.2, “MySQL Instance Manager Configuration Files”
Chapter 5, MySQL Server Administration
Section 5.2, “MySQL Server Logs”
Section 9.7, “MySQL Server Time Zone Support”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
Section 4.3, “MySQL Server and Server-Startup Programs”
Section 22.1.2, “MySQL Test Suite”
Section 22.1.1, “MySQL Threads”
Section 2.3.15, “MySQL on Windows Compared to MySQL on Unix”
Section B.1.8.1, “Open Issues in MySQL”
Section B.1.6, “Optimizer-Related Issues”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 21.9.3, “Options with the Embedded Server”
Section 17.3.5, “Overview of MySQL Cluster Configuration Parameters”
Section 4.1, “Overview of MySQL Programs”
Section 17.5.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 22.5, “Debugging and Porting MySQL”
Section 17.12.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.x”
Section 5.4.2, “Privilege System Grant Tables”
Section 2.11.2.1, “Problems Running mysql_install_db
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section B.1.3.2, “Problems with File Permissions”
Section 4.2.3.2, “Program Option Modifiers”
Section 7.5.5.3, “Query Cache Configuration”
Section 17.3.4.2, “Recommended Starting Configurations for MySQL Cluster NDB 6.2 and Later”
Section 16.1.3.2, “Replication Master Options and Variables”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 16.1.3.1, “Replication and Binary Logging Option and Variable Reference”
Section 16.1.3, “Replication and Binary Logging Options and Variables”
Section B.1.4.1.2, “Resetting the Root Password on Unix Systems”
Section B.1.5.5, “Rollback Failure for Nontransactional Tables”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.2, “Running Multiple Servers on Unix”
Section 1.7.3, “Running MySQL in ANSI Mode”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 2.13.5.7, “SGI Irix Notes”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 5.3.3, “Security-Related mysqld Options”
Section 1.7.2, “Selecting SQL Modes”
Section 2.3.8, “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.10, “Server Response to Signals”
Section 5.1.8, “Server SQL Modes”
Section 5.1.7, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section 9.3, “Setting the Error Message Language”
Section 2.13.3, “Solaris Notes”
Section 2.13.3.2, “Solaris x86 Notes”
Section 2.10.1, “Source Installation Overview”
Section 5.6.1.2, “Starting Multiple Windows Servers as Services”
Section 5.6.1.1, “Starting Multiple Windows Servers at the Command Line”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 2.3.10, “Starting MySQL from the Windows Command Line”
Section 2.11.2.2, “Starting and Stopping MySQL Automatically”
Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 9.7.1, “Staying Current with Time Zone Changes”
Section 2.13.5.4, “SunOS 4 Notes”
Section 7.3.2, “Table Locking Issues”
Section B.1.2.19, “Table-Corruption Issues”
Section 2.3.12, “Testing The MySQL Installation”
The mysqld-max Extended MySQL Server
Section 13.14, “The BLACKHOLE Storage Engine”
Section 10.4.3, “The BLOB and TEXT Types”
Section 13.5, “The MyISAM Storage Engine”
Section 5.2.4, “The Binary Log”
Section 5.2.2, “The Error Log”
Section 5.2.3, “The General Query Log”
Section 7.5.5, “The MySQL Query Cache”
Section 5.1, “The MySQL Server”
Section 5.2.5, “The Slow Query Log”
Section B.1.4.6, “Time Zone Problems”
Section 2.3.13, “Troubleshooting a MySQL Installation Under Windows”
Section 7.5.3, “Tuning Server Parameters”
Section 2.10.2, “Typical configure Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.11.2, “Unix Post-Installation Procedures”
Section 2.12.1, “Upgrading MySQL”
Section 2.3.14, “Upgrading MySQL on Windows”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 22.3.2.6, “User-Defined Function Security Precautions”
Section 8.4, “User-Defined Variables”
Section 6.4.1, “Using myisamchk for Crash Recovery”
Section 22.5.1.3, “Using pdb to create a Windows crashdump”
Section 4.2.3.3, “Using Option Files”
Section 13.6.2.1, “Using Per-Table Tablespaces”
Section 5.5.7.2, “Using SSL Connections”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld
Section 7.6.1.3, “Using Symbolic Links for Databases on Windows”
Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
Section 22.5.1.5, “Using a Stack Trace”
Section 9.2.1, “Using the German Character Set”
Section B.1.4.2, “What to Do If MySQL Keeps Crashing”
Section 5.4.6, “When Privilege Changes Take Effect”
Section B.1.4.4, “Where MySQL Stores Temporary Files”
Section 22.2.3, “Writing Plugins”

mysqld --help

Section 7.5.3, “Tuning Server Parameters”

mysqld --print-defaults

Section 22.5.1, “Debugging a MySQL Server”

mysqld --remove

Section 5.6.1.2, “Starting Multiple Windows Servers as Services”

mysqld --console

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

mysqld --help

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

mysqld --no-defaults ...

Section 22.5.1, “Debugging a MySQL Server”

mysqld --print-defaults

Section 2.12.1, “Upgrading MySQL”

mysqld --verbose --help

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

mysqld [options]

Section 4.3.1, “mysqld — The MySQL Server”

mysqld-.13

Section 2.12.1, “Upgrading MySQL”

mysqld-4.0.18

Section 2.12.1, “Upgrading MySQL”

mysqld-abc.exe

Description

mysqld-debug

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

mysqld-max

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

mysqld-max-nt

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

mysqld-max.exe

The mysqld-max Extended MySQL Server

mysqld-nt

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

mysqld-opt

Section 2.3.8, “Selecting a MySQL Server Type”

mysqld_multi

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Description
Description
Section 4.1, “Overview of MySQL Programs”
Section 5.6.2, “Running Multiple Servers on Unix”

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

Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”

mysqld_safe

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section B.1.2.18, “'File' Not Found and Similar Errors”
Section 13.6.13.3, “InnoDB General Troubleshooting”
Section B.1.2.10, “Packet too large
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section B.1.8.2, “Additional Known Issues”
Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”
Section 22.5.1.1, “Compiling MySQL for Debugging”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 13.6.2.3, “Creating the InnoDB Tablespace”
Description
Description
Description
Section 7.5.9, “Enabling Large Page Support”
Section 2.13.4.1, “FreeBSD Notes”
Section B.1.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.13.5.3, “IBM-AIX notes”
Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.5, “Installing MySQL on Mac OS X”
Section 2.8, “Installing MySQL on NetWare”
Section 2.7, “Installing MySQL on i5/OS”
Section 2.13.1.4, “Linux Post-Installation Notes”
Section 5.3.2, “Making MySQL Secure Against Attackers”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 4.6.10.1, “MySQL Instance Manager Command Options”
Section 9.7, “MySQL Server Time Zone Support”
Section B.1.8.1, “Open Issues in MySQL”
Section 4.2.3.5, “Option Defaults, Options Expecting Values, and the = Sign”
Section 4.1, “Overview of MySQL Programs”
Section B.1.3.2, “Problems with File Permissions”
Section 5.6, “Running Multiple MySQL Servers on the Same Machine”
Section 5.6.2, “Running Multiple Servers on Unix”
Section 2.13.5.8, “SCO UNIX and OpenServer 5.0.x Notes”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section 2.10.1, “Source Installation Overview”
Section 2.11.2.2, “Starting and Stopping MySQL Automatically”
Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”
Section 4.6.10.3, “Starting the MySQL Server with MySQL Instance Manager”
Section 5.2.2, “The Error Log”
Section B.1.4.6, “Time Zone Problems”
Section 7.5.3, “Tuning Server Parameters”
Section 2.11.2, “Unix Post-Installation Procedures”
Section 2.12.1, “Upgrading MySQL”
Section 2.12.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 12.1.13, “CREATE INDEX Syntax”
Section 12.1.20, “CREATE VIEW Syntax”
Section 13.6.4.4, “FOREIGN KEY Constraints”
Section 13.6.13.1, “InnoDB Performance Tuning Tips”
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 12.6.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 12.5.3.4, “UNINSTALL PLUGIN Syntax”
Section 13.6.5, “Adding, Removing, or Resizing InnoDB Data and Log Files”
Section 13.6.6, “Backing Up and Recovering an InnoDB Database”
Section 6.2.1, “Backup Policy”
Section 6.2.3, “Backup Strategy Summary”
Chapter 6, Backup and Recovery
Section 5.4.7, “Causes of Access-Denied Errors”
Section 2.3.3.2, “Choosing an Install Type”
Section 4.2.2, “Connecting to the MySQL Server”
Section 2.12.5, “Copying MySQL Databases to Another Machine”
Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 6.1, “Database Backups”
Section 13.6.11.3, “Defragmenting a Table”
Description
Description
Section 2.12.2, “Downgrading MySQL”
Section 2.12.2.1, “Downgrading to MySQL 5.0”
Section 6.2, “Example Backup and Recovery Strategy”
Section 1.7.5.4, “Foreign Keys”
Section 1.6, “How to Report Bugs or Problems”
Section 16.1.1, “How to Set Up Replication”
Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 8.2.3, “Mapping of Identifiers to File Names”
Section 13.6.7, “Moving an InnoDB Database to Another Machine”
Section 1.4.1, “What Is New in MySQL 5.1”
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 4.1, “Overview of MySQL Programs”
Section 10.1.1, “Overview of Numeric Types”
Section B.1.5.8, “Problems with Floating-Point Comparisons”
Section 2.12.4, “Rebuilding or Repairing Tables or Indexes”
Section D.4, “Restrictions on Views”
Section 5.1.8, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 5.1.5, “Session System Variables”
Section 16.1.1.8, “Setting Up Replication with Existing Data”
Section 4.2.3, “Specifying Program Options”
Section 2.3.11, “Starting MySQL as a Windows Service”
Section 10.4.3, “The BLOB and TEXT Types”
Section 9.7.2, “Time Zone Leap Second Support”
Section 2.12.1, “Upgrading MySQL”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 7.6.1.2, “Using Symbolic Links for Tables on Unix”
Section 11.10, “XML Functions”

mysqldump --delete-master-logs

Section 6.2.1, “Backup Policy”

mysqldump --master-data

Section 16.1.1, “How to Set Up Replication”

mysqldump --routines

Section 2.12.2.1, “Downgrading to MySQL 5.0”

mysqldump --xml

Section 4.5.1.1, “mysql Options”

mysqldump --flush-logs

Section 6.1, “Database Backups”

mysqldump --help

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

mysqldump --master-data

Section 16.1.1, “How to Set Up Replication”
Section 16.1.1.4, “Obtaining the Master Replication Information”
Section 16.3.4, “Replication FAQ”

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

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

mysqldump --tab

Section 12.2.6, “LOAD DATA INFILE Syntax”
Section 2.12.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 --help

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.5.2.2, “BACKUP TABLE Syntax”
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.6.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Chapter 6, Backup and Recovery
Section 6.1, “Database Backups”
Description
Description
Section 4.1, “Overview of MySQL Programs”

mysqlhotcopy --flushlog

Section 6.1, “Database Backups”

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”
Chapter 6, Backup and Recovery
Section 2.12.5, “Copying MySQL Databases to Another Machine”
Section 6.1, “Database Backups”
Description
Section 2.12.2, “Downgrading MySQL”
Section 4.1, “Overview of MySQL Programs”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL
Section 2.12.1, “Upgrading MySQL”
Section 2.12.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.5.5.15, “SHOW DATABASES Syntax”
Section 4.2.2, “Connecting to the MySQL Server”
Description
Section 4.1, “Overview of MySQL Programs”
Section 2.3.12, “Testing The MySQL Installation”
Section 2.11.1, “Windows Post-Installation Procedures”

mysqlshow --status db_name

Section 12.5.5.38, “SHOW TABLE STATUS Syntax”

mysqlshow -k db_name tbl_name

Section 12.5.5.23, “SHOW INDEX Syntax”

mysqlshow db_name

Section 12.5.5.39, “SHOW TABLES Syntax”

mysqlshow db_name tbl_name

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

mysqlshow mysql user

Section B.1.2.15, “Ignoring user

mysqlslap

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

mysqlslap [options]

Section 4.5.7, “mysqlslap — Load Emulation Client”

mysqltest

Appendix B, Errors, Error Codes, and Common Problems
Section 22.1.2, “MySQL Test Suite”

ndb_config

Section 17.6.6, “ndb_config — Extract MySQL Cluster Configuration Information”
Description
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 17.6, “MySQL Cluster Programs”
Section 17.6.24.6, “Program Options for ndb_config

ndb_config options

Section 17.6.6, “ndb_config — Extract MySQL Cluster Configuration Information”

ndb_cpcd

Section 17.6.7, “ndb_cpcd — Automate Testing for NDB Development”
Description

ndb_cpcd options

Section 17.6.7, “ndb_cpcd — Automate Testing for NDB Development”

ndb_delete_all

Section 17.6.8, “ndb_delete_all — Delete All Rows from an NDB Table”
Description

ndb_delete_all options

Section 17.6.8, “ndb_delete_all — Delete All Rows from an NDB Table”

ndb_desc

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.9, “ndb_desc — Describe NDB Tables”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Description
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”

ndb_desc -d db_name table_name

Section 17.3.4.6, “Defining MySQL Cluster Data Nodes”

ndb_desc options

Section 17.6.9, “ndb_desc — Describe NDB Tables”

ndb_drop_index

Section 17.6.10, “ndb_drop_index — Drop Index from an NDB Table”
Description

ndb_drop_index options

Section 17.6.10, “ndb_drop_index — Drop Index from an NDB Table”

ndb_drop_table

Section 17.6.11, “ndb_drop_table — Drop an NDB Table”
Description
Description

ndb_drop_table options

Section 17.6.11, “ndb_drop_table — Drop an NDB Table”

ndb_error_reporter

Section 17.6.12, “ndb_error_reporter — NDB Error-Reporting Utility”
Description
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 17.6.24.7, “Program Options for ndb_error_reporter

ndb_error_reporter options

Section 17.6.12, “ndb_error_reporter — NDB Error-Reporting Utility”

ndb_mgm

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 17.7.8.1, “Adding MySQL Cluster Data Nodes Online: General Issues”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Description
Description
Section 17.7.4, “Event Reports Generated in MySQL Cluster”
Section 17.2.4, “Initial Startup of MySQL Cluster”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Chapter 17, MySQL Cluster NDB 6.X/7.X
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.14, “MySQL Cluster Glossary”
Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.6, “MySQL Cluster Programs”
Section 17.8.1, “MySQL Cluster Security and Networking Issues”
Section 17.6.23, “Options Common to MySQL Cluster Programs”
Section 17.5.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.6.24.4, “Program Options for ndb_mgm
Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 4.2.3.1, “Using Options on the Command Line”
Section 17.7.3.2, “Using The MySQL Cluster Management Client to Create a Backup”

ndb_mgm -e "START BACKUP"

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

ndb_mgm -e "START BACKUP"

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

ndb_mgm options

Section 17.6.5, “ndb_mgm — The MySQL Cluster Management Client”

ndb_mgmd

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.4, “ndb_mgmd — The MySQL Cluster Management Server Daemon”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Section 17.3.4.5, “Defining a MySQL Cluster Management Server”
Description
Section 17.2.4, “Initial Startup of MySQL Cluster”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.3.4.1, “MySQL Cluster Configuration — Basic Example”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.14, “MySQL Cluster Glossary”
Section 17.7.4.1, “MySQL Cluster Logging Management Commands”
Section 17.3.5.2, “MySQL Cluster Management Node Configuration Parameters”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.6, “MySQL Cluster Programs”
Section 17.3.5, “Overview of MySQL Cluster Configuration Parameters”
Section 17.5.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.6.24.3, “Program Options for ndb_mgmd
Section 17.3.3, “Quick Test Setup of MySQL Cluster”
Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 17.7.1, “Summary of MySQL Cluster Start Phases”
Section 17.3.4.3, “The MySQL Cluster Connectstring”

ndb_mgmd options

Section 17.6.4, “ndb_mgmd — The MySQL Cluster Management Server Daemon”

ndb_print_backup_file

Section 17.6.13, “ndb_print_backup_file — Print NDB Backup File Contents”
Description
Description
Description
Description

ndb_print_backup_file file_name

Section 17.6.13, “ndb_print_backup_file — Print NDB Backup File Contents”

ndb_print_schema_file

Section 17.6.14, “ndb_print_schema_file — Print NDB Schema File Contents”
Description
Description
Description
Description

ndb_print_schema_file file_name

Section 17.6.14, “ndb_print_schema_file — Print NDB Schema File Contents”

ndb_print_sys_file

Section 17.6.15, “ndb_print_sys_file — Print NDB System File Contents”
Description
Description
Description

ndb_print_sys_file file_name

Section 17.6.15, “ndb_print_sys_file — Print NDB System File Contents”

ndb_restore

Section 17.6.17, “ndb_restore — Restore a MySQL Cluster Backup”
Chapter 6, Backup and Recovery
Description
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.14, “MySQL Cluster Glossary”
Section 17.6, “MySQL Cluster Programs”
Section 17.7.6, “MySQL Cluster Single User Mode”
Section 17.6.24.8, “Program Options for ndb_restore

ndb_restore options

Section 17.6.17, “ndb_restore — Restore a MySQL Cluster Backup”

ndb_schema_backup_file

Description

ndb_select_all

Section 17.6.18, “ndb_select_all — Print Rows from an NDB Table”
Description
Description
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”

ndb_select_all -c connect_string tbl_name -d db_name [> file_name]

Section 17.6.18, “ndb_select_all — Print Rows from an NDB Table”

ndb_select_count

Section 17.6.19, “ndb_select_count — Print Row Counts for NDB Tables”
Description

ndb_select_count [-c connect_string] -ddb_name tbl_name[, tbl_name2[, ...]]

Section 17.6.19, “ndb_select_count — Print Row Counts for NDB Tables”

ndb_show_tables

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.20, “ndb_show_tables — Display List of NDB Tables”
Description
Section 17.6, “MySQL Cluster Programs”
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 17.6.24.9, “Program Options for ndb_show_tables

ndb_show_tables [options]

Section 17.6.20, “ndb_show_tables — Display List of NDB Tables”

ndb_size.pl

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.21, “ndb_size.pl — NDBCLUSTER Size Requirement Estimator”
Description
Section 2.15, “Perl Installation Notes”
Section 17.6.24.10, “Program Options for ndb_size.pl

ndb_size.pl arguments

Section 17.6.21, “ndb_size.pl — NDBCLUSTER Size Requirement Estimator”

ndb_waiter

Section 17.6.22, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”
Description
Section 17.14, “MySQL Cluster Glossary”

ndb_waiter options

Section 17.6.22, “ndb_waiter — Wait for MySQL Cluster to Reach a Given Status”

ndbd

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.6.2, “ndbd — The MySQL Cluster Data Node Daemon”
Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”
Section 17.3.4.6, “Defining MySQL Cluster Data Nodes”
Description
Description
Description
Description
Section 17.2.4, “Initial Startup of MySQL Cluster”
Section 17.12.10, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 17.7, “Management of MySQL Cluster”
MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 17.3.4.1, “MySQL Cluster Configuration — Basic Example”
Section 17.1.1, “MySQL Cluster Core Concepts”
Section 17.3.5.1, “MySQL Cluster Data Node Configuration Parameters”
Section 17.14, “MySQL Cluster Glossary”
Section 17.11.2, “MySQL Cluster Interconnects and Performance”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.1.2, “MySQL Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 17.6, “MySQL Cluster Programs”
Section 17.12.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 17.3.5, “Overview of MySQL Cluster Configuration Parameters”
Section 17.5.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 17.12.11, “Previous MySQL Cluster Issues Resolved in MySQL 5.1 and MySQL Cluster NDB 6.x”
Section 17.6.24.2, “Program Options for ndbd and ndbmtd
Section 17.3.3, “Quick Test Setup of MySQL Cluster”
Section 17.3.4.11, “SCI Transport Connections in MySQL Cluster”
Section 17.2.6, “Safe Shutdown and Restart of MySQL Cluster”
Section 17.7.1, “Summary of MySQL Cluster Start Phases”
Section 17.7.4.3, “Using CLUSTERLOG STATISTICS in the MySQL Cluster Management Client”
Section 17.11, “Using High-Speed Interconnects with MySQL Cluster”

ndbd --nostart

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

ndbd --initial

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

ndbd -n

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

ndbd options

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

ndbd_redo_log_reader

Section 17.6.16, “ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log”
Description
Section 17.6.24.5, “Program Options for ndbd_redo_log_reader

ndbd_redo_log_reader file_name [options]

Section 17.6.16, “ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log”

ndbmtd

Section 17.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”
Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 17.3.4.6, “Defining MySQL Cluster Data Nodes”
Description
Description
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.5.2, “MySQL Cluster 5.1 and MySQL Cluster NDB 6.x/7.x Upgrade and Downgrade Compatibility”
Section 17.3.5.1, “MySQL Cluster Data Node Configuration Parameters”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 17.6.24.2, “Program Options for ndbd and ndbmtd

ndbmtd options

Section 17.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”

ndbmtd.exe

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

nm

Section 22.5.1.5, “Using a Stack Trace”

nm --numeric-sort mysqld

Description

nohup

Section 2.13.5.5, “Alpha-DEC-UNIX Notes (Tru64)”

nopager

Section 4.5.1.2, “mysql Commands”

notee

Section 4.5.1.2, “mysql Commands”

nowarning

Section 4.5.1.2, “mysql Commands”

openssl

Section 5.5.7.4, “Setting Up SSL Certificates for MySQL”

openssl md5 package_name

Section 2.1.4.1, “Verifying the MD5 Checksum”

pack_isam

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

pack_isam [options] file_name

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

pager

Section 4.5.1.2, “mysql Commands”

pager [command]

Section 4.5.1.2, “mysql Commands”

perror

Section 4.8.1, “perror — Explain Error Codes”
Section B.1.2.18, “'File' Not Found and Similar Errors”
Section B.1.2.13, “Can't create/write to file
Description
Section 6.4.3, “How to Repair Tables”
Section 13.6.12.2, “Operating System Error Codes”
Section 4.1, “Overview of MySQL Programs”

perror --ndb error_code

MySQL 4.1 FAQ — MySQL Cluster
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

perror [options] errorcode ...

Section 4.8.1, “perror — Explain Error Codes”

pgcc

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

ping

Section 14.2, “Using Linux HA Heartbeat”

pkgadd

Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”

ppm

Section 2.15, “Perl Installation Notes”

print

Section 4.5.1.2, “mysql Commands”

process

Section 17.14, “MySQL Cluster Glossary”

prompt

Section 4.5.1.2, “mysql Commands”

prompt [str]

Section 4.5.1.2, “mysql Commands”

ps

Section 22.5.5, “Differences Between Thread Packages”
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 7.5.8, “How MySQL Uses Memory”
Section B.1.1, “How to Determine What Is Causing a Problem”
Section 2.13.1.4, “Linux Post-Installation Notes”
Section 2.11.2.3, “Starting and Troubleshooting the MySQL Server”

ps auxw

Section 4.2.2, “Connecting to the MySQL Server”

ps xa | grep mysqld

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

pthread

Description

pull

Section 2.10.3, “Installing from the Development Source Tree”

quit

Section 4.5.1.2, “mysql Commands”

rehash

Section 4.5.1.2, “mysql Commands”

replace

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

replace arguments

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

resolve_stack_dump

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

resolve_stack_dump [options] symbols_file [numeric_dump_file]

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

resolveip

Section 4.8.3, “resolveip — Resolve Host name to IP Address or Vice Versa”
Description
Section 2.13.1.2, “Linux Binary Distribution Notes”
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”

rpm

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

rpm --import

Section 2.1.4.3, “Signature Checking Using RPM

rpmbuild

Section 2.10.1, “Source Installation Overview”

rsync

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

safe_mysqld

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

scp

Chapter 6, Backup and Recovery
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”

sed

Section 3.3.4.7, “Pattern Matching”

setenv

Section 4.2.4, “Setting Environment Variables”

sh

Section B.1.2.18, “'File' Not Found and Similar Errors”
Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 2.13.4.5, “BSD/OS Version 3.x Notes”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.4, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

source file_name

Section 4.5.1.2, “mysql Commands”

ssh

Section 17.8.1, “MySQL Cluster Security and Networking Issues”

status

Section 4.5.1.2, “mysql Commands”

strings

Section 5.3.1, “General Security Guidelines”

su root

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

sudo

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

sysctl

Section 2.13.4.1, “FreeBSD Notes”

system

Section 4.5.1.2, “mysql Commands”

system command

Section 4.5.1.2, “mysql Commands”

tar

Chapter 6, Backup and Recovery
Section 2.1.2.2, “Choosing a Distribution Format”
Section 16.1.1.6, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 2.13.5.1, “HP-UX Version 10.20 Notes”
Section 2.13.5.2, “HP-UX Version 11.x Notes”
Section 1.6, “How to Report Bugs or Problems”
Section 16.1.1, “How to Set Up Replication”
Section 2.1.5, “Installation Layouts”
Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.5, “Installing MySQL on Mac OS X”
Section 2.6, “Installing MySQL on Solaris”
Section 2.15.1, “Installing Perl on Unix”
Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”
Section 2.13.2, “Mac OS X Notes”
Section 2.1.2.4, “MySQL Binaries Compiled by Sun Microsystems, Inc.”
Section 2.10, “MySQL Installation Using a Source Distribution”
Section 2.13.5.9, “SCO OpenServer 6.0.x Notes”
Section 2.13.3, “Solaris Notes”
Section 2.10.1, “Source Installation Overview”

tcpdump

Section 5.3.1, “General Security Guidelines”

tcsh

Section B.1.2.18, “'File' Not Found and Similar Errors”
Section 2.5, “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”

tee [file_name]

Section 4.5.1.2, “mysql Commands”

telnet

Section 5.3.1, “General Security Guidelines”

top

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

ulimit

Section B.1.2.18, “'File' Not Found and Similar Errors”
Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 2.13.4.5, “BSD/OS Version 3.x Notes”
Section 7.5.9, “Enabling Large Page Support”

ulimit -n

Description

ulimit -c

Description

ulimit -c unlimited

Section 17.6.23, “Options Common to MySQL Cluster Programs”

ulimit -c 1000000

Section 2.13.1.4, “Linux Post-Installation Notes”

ulimit -c unlimited

Section 5.1.2, “Server Command Options”

ulimit -d 256000

Section B.1.2.10, “Packet too large

ulimit -d unlimited

Section 2.13.5.3, “IBM-AIX notes”

ulimit -n 256

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

ulimit -v 80000

Section 2.13.4.4, “BSD/OS Version 2.x Notes”
Section 2.13.4.5, “BSD/OS Version 3.x Notes”

update-rc.d

Section 17.2.2, “MySQL Cluster Multi-Computer Installation”

use db_name

Section 4.5.1.2, “mysql Commands”

useradd

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”
Section 2.4, “Installing MySQL from RPM Packages on Linux”
Section 17.2.2, “MySQL Cluster Multi-Computer Installation”
Section 2.10.1, “Source Installation Overview”

usermod

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

vi

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

warnings

Section 4.5.1.2, “mysql Commands”

winMd5Sum

Section 2.1.4.1, “Verifying the MD5 Checksum”

xlC_r

Section 22.5, “Debugging and Porting MySQL”

yacc

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

zip

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

zsh

Section 4.2.4, “Setting Environment Variables”