Command Index

A

[index top]

Access

Section 13.2.2, "DELETE Syntax"

addgroup

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

addr2line

Section 23.4.1.5, "Using a Stack Trace"

adduser

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

ALL STATUS

Section 17.5.8, "MySQL Cluster Single User Mode"

APF

Section 17.5.11.1, "MySQL Cluster Security and Networking Issues"

apt-get

Section 2.5.3, "Installing MySQL on Linux Using Native Package Managers"

B

[index top]

bash

Section 6.1.2.1, "End-User Guidelines for Password Security"

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

Section 4.2.1, "Invoking MySQL Programs"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section 4.2.4, "Setting Environment Variables"

Section 1.2, "Typographical and Syntax Conventions"

bison

Section 2.9.5, "Dealing with Problems Compiling MySQL"

Section 2.9, "Installing MySQL from Source"

Section 2.9.3, "Installing MySQL Using a Development Source Tree"

bzr

Section 2.9.3, "Installing MySQL Using a Development Source Tree"

C

[index top]

c++filt

Section 23.4.1.5, "Using a Stack Trace"

cat

Section 4.5.1.1, "mysql Options"

chkconfig

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 2.5.3, "Installing MySQL on Linux Using Native Package Managers"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

chroot

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

CMake

Section C.5.2.17, "Can't initialize character set"

Section 10.3, "Adding a Character Set"

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

Section 17.2.3.2, "Compiling and Installing MySQL Cluster from Source on Windows"

Section 23.2.4.3, "Compiling and Installing Plugin Libraries"

Section 23.3.2.5, "Compiling and Installing User-Defined Functions"

Section 6.3.9.2, "Configuring MySQL for SSL"

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

Section 2.9.5, "Dealing with Problems Compiling MySQL"

Section 2.12, "Environment Variables"

Section C.5.4.5, "How to Protect or Change the MySQL Unix Socket File"

Section 2.9, "Installing MySQL from Source"

Section 2.9.3, "Installing MySQL Using a Development Source Tree"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 22.7, "libmysqld, the Embedded MySQL Server Library"

Section 17.1.4.1, "MySQL Cluster Development in MySQL Cluster NDB 7.3"

Chapter 17, MySQL Cluster NDB 7.3

Section 17.5.4, "MySQL Server Usage for MySQL Cluster"

Section 23.2.5, "MySQL Services for Plugins"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 2.1.1, "Operating Systems Supported by MySQL Community Server"

Section 21.2.1, "Performance Schema Build Configuration"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

Section 6.1.6, "Security Issues with LOADDATA LOCAL"

Section 10.1.3.1, "Server Character Set and Collation"

Section 5.1.4, "Server System Variables"

Section 14.6, "The ARCHIVE Storage Engine"

Section 14.7, "The BLACKHOLE Storage Engine"

Section 14.10, "The EXAMPLE Storage Engine"

Section 14.9, "The FEDERATED Storage Engine"

Section 5.7, "Tracing mysqld Using DTrace"

Section 4.2.3.3, "Using Option Files"

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

cmake

Section 23.3.2.5, "Compiling and Installing User-Defined Functions"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 14.2.9.4.1, "Password-Protecting the memcached Interface throughSASL"

cmd

Section C.5.4.1.1, "Resetting the Root Password: Windows Systems"

cmd.exe

Section 4.2.1, "Invoking MySQL Programs"

Section 1.2, "Typographical and Syntax Conventions"

command.com

Section 4.2.1, "Invoking MySQL Programs"

Section 1.2, "Typographical and Syntax Conventions"

comp_err

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 4.1, "Overview of MySQL Programs"

configure

Section 17.4.25, "Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs"

Section 2.12, "Environment Variables"

Section 1.7, "How to Report Bugs or Problems"

Section 1.2, "Typographical and Syntax Conventions"

copy

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

coreadm

Section 2.6, "Installing MySQL on Solaris and OpenSolaris"

Section 5.1.3, "Server Command Options"

cp

Section 16.3.1.2, "Backing Up Raw Data from a Slave"

Section 7.1, "Backup and Recovery Types"

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

Section 16.1.1.9, "Introducing Additional Slaves to an Existing Replication Environment"

crash-me

Section 8.12.2, "The MySQL Benchmark Suite"

crc32

Section 14.2.6, "InnoDB Startup Options and System Variables"

cron

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

Section 13.7.2.2, "CHECK TABLE Syntax"

Section 14.3.1, "MyISAM Startup Options"

Section 5.2.6, "Server Log Maintenance"

Section 7.6.5, "Setting Up a MyISAM Table Maintenance Schedule"

Section 3.5, "Using mysql in Batch Mode"

csh

Section 4.2.1, "Invoking MySQL Programs"

Section 4.2.4, "Setting Environment Variables"

Section 1.2, "Typographical and Syntax Conventions"

D

[index top]

date

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

df

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

Directory Utility

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

drwtsn32.exe

Section 23.4.1.3, "Using pdb to create a Windows crashdump"

dump

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

E

[index top]

emerge

Section 2.5.3, "Installing MySQL on Linux Using Native Package Managers"

EXIT SINGLE USER MODE

Section 17.5.8, "MySQL Cluster Single User Mode"

G

[index top]

gcc

Section 23.3.2.5, "Compiling and Installing User-Defined Functions"

Section 22.7.1, "Compiling Programs with libmysqld"

Section 2.13.3, "Problems Using the Perl DBI/DBDInterface"

gdb

Section 23.4.1.1, "Compiling MySQL for Debugging"

Section 23.4.1.4, "Debugging mysqld under gdb"

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

gmake

Section 2.9, "Installing MySQL from Source"

Section 2.8, "Installing MySQL on FreeBSD"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

GnuPG

Section 2.1.4.2, "Signature Checking Using GnuPG"

gnutar

Section 2.9, "Installing MySQL from Source"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

gogoc

Section 5.1.9.5, "Obtaining an IPv6 Address from a Broker"

gpg

Section 2.1.4.2, "Signature Checking Using GnuPG"

grep

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 3.3.4.7, "Pattern Matching"

groupadd

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 2.6, "Installing MySQL on Solaris and OpenSolaris"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

gtar

Section 2.7.1, "General Notes on Installing MySQL on HP-UX"

Section 2.9, "Installing MySQL from Source"

Section 2.6, "Installing MySQL on Solaris and OpenSolaris"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

gunzip

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

gzip

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 1.7, "How to Report Bugs or Problems"

Section 2.4, "Installing MySQL on Mac OS X"

H

[index top]

hdparm

Section 14.2.6, "InnoDB Startup Options and System Variables"

help contents

Section 4.5.1.4, "mysql Server-Side Help"

hostname

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

I

[index top]

icc

Section 2.1.6, "Compiler-Specific Build Characteristics"

Section 23.4, "Debugging and Porting MySQL"

ifconfig

Section 5.1.9.1, "Verifying System Support for IPv6"

innochecksum

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 13.7.2.2, "CHECK TABLE Syntax"

Section 4.1, "Overview of MySQL Programs"

iptables

Section 17.5.11.1, "MySQL Cluster Security and Networking Issues"

K

[index top]

kill

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

Section 17.4.1, "ndbd — The MySQL Cluster Data Node Daemon"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section E.6, "Restrictions on XA Transactions"

ksh

Section 4.2.1, "Invoking MySQL Programs"

Section 4.2.4, "Setting Environment Variables"

kswapd

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

L

[index top]

ldconfig

Section 23.3.2.5, "Compiling and Installing User-Defined Functions"

less

Section 4.5.1.2, "mysql Commands"

Section 4.5.1.1, "mysql Options"

ln

Section 8.11.3.1.2, "Using Symbolic Links for MyISAM Tables on Unix"

logger

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

ls +L1

Section C.5.4.4, "Where MySQL Stores Temporary Files"

M

[index top]

m4

Section 2.9, "Installing MySQL from Source"

make

Section 23.2.4.3, "Compiling and Installing Plugin Libraries"

Section 2.9.5, "Dealing with Problems Compiling MySQL"

Section 2.9, "Installing MySQL from Source"

Section 2.8, "Installing MySQL on FreeBSD"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 2.13.3, "Problems Using the Perl DBI/DBDInterface"

make && make install

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

make install

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

Section 23.2.4.3, "Compiling and Installing Plugin Libraries"

Section 2.9.4, "MySQL Source-Configuration Options"

make package

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 2.9.4, "MySQL Source-Configuration Options"

make test

Section 2.9.3, "Installing MySQL Using a Development Source Tree"

Section 2.13.1, "Installing Perl on Unix"

Section 23.1.2, "The MySQL Test Suite"

md5

Section 2.1.4.1, "Verifying the MD5 Checksum"

md5.exe

Section 2.1.4.1, "Verifying the MD5 Checksum"

md5sum

Section 2.1.4.1, "Verifying the MD5 Checksum"

memcached

Section 14.2.6, "InnoDB Startup Options and System Variables"

Section 14.2.9.5.2, "Adapting an Existing memcached Application for the Integrated memcached Daemon"

Section 14.2.9.5.1, "Adapting an Existing MySQL Schema for a memcached Application"

Section 14.2.9.5.5, "Adapting DML Statements to memcached Operations"

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

Section 14.2.9.1, "Benefits of the InnoDB / memcached Combination"

Section 14.2.9.5.4, "Controlling Transactional Behavior of the InnoDB memcached Plugin"

Section 14.2.9.3, "Getting Started with InnoDB Memcached Plugin"

Section 14.2.9, "InnoDB Integration with memcached"

Section 14.2.9.3.2, "Installing and Configuring the InnoDB memcached Plugin"

Section 14.2.9.7, "Internals of the InnoDB memcached Plugin"

Section 17.1.1, "MySQL Cluster Core Concepts"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 14.2.9.4.1, "Password-Protecting the memcached Interface through SASL"

Section 14.2.9.5.6, "Performing DML and DDL Statements on the UnderlyingInnoDB Table"

Section 14.2.9.3.1, "Prerequisites for the InnoDB memcached Plugin"

Section 14.2.9.4, "Security Considerations for the InnoDB memcached Plugin"

Section 14.2.9.8, "Troubleshooting the InnoDB memcached Plugin"

Section 14.2.9.5.3, "Tuning Performance of the InnoDB memcached Plugin"

Section 15.6, "Using MySQL with memcached"

Section 14.2.9.6, "Using the InnoDB memcached Plugin with Replication"

Section 14.2.9.3.3, "Verifying the InnoDB and memcached Setup"

Section 1.4, "What Is New in MySQL 5.6"

Section 14.2.9.5, "Writing Applications for the InnoDB memcached Interface"

memcapable

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

memcat

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

Section 14.2.9.3.3, "Verifying the InnoDB and memcached Setup"

memcp

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

memflush

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

memrm

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

memslap

Section 14.2.9.5.3, "Tuning Performance of the InnoDB memcached Plugin"

mgmd

Section 17.2, "MySQL Cluster Installation"

mkdir

Section 13.1.10, "CREATE DATABASE Syntax"

mklink

Section 8.11.3.1.3, "Using Symbolic Links for Databases on Windows"

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"

Section 4.8.2, "replace — A String-Replacement Utility"

Section 4.1, "Overview of MySQL Programs"

msql2mysqlC-source-file ...

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

mv

Section 5.2.6, "Server Log Maintenance"

Section 5.2.2, "The Error Log"

Section 5.2.3, "The General Query Log"

my_print_defaults

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.7, "MySQL Program Development Utilities"

Section 4.1, "Overview of MySQL Programs"

myisam_ftdump

Section 4.6.2, "myisam_ftdump — Display Full-Text Index information"

Section 12.9, "Full-Text Search Functions"

Section 4.1, "Overview of MySQL Programs"

myisamchk

Section 4.6.3, "myisamchk — MyISAM Table-Maintenance Utility"

Section 4.6.3.2, "myisamchk Check Options"

Section 4.6.3.1, "myisamchk General Options"

Section 4.6.3.6, "myisamchk Memory Usage"

Section 4.6.3.3, "myisamchk Repair Options"

Section 13.7.2.1, "ANALYZE TABLE Syntax"

Section 13.7.2.2, "CHECK TABLE Syntax"

Section 13.2.2, "DELETE Syntax"

Section 8.8.2, "EXPLAIN Output Format"

Section 8.3.7, "InnoDB and MyISAM Index Statistics Collection"

Section 13.7.6.5, "LOAD INDEX INTOCACHE Syntax"

Section 14.3.1, "MyISAM Startup Options"

Section 7.6, "MyISAM Table Maintenance and Crash Recovery"

Section 7.6.4, "MyISAM Table Optimization"

Section 14.3.3, "MyISAM Table Storage Formats"

Section 13.7.2.5, "REPAIR TABLE Syntax"

Section 13.7.5.23, "SHOW INDEX Syntax"

Section 13.7.5.37, "SHOW TABLE STATUS Syntax"

Section 8.6.2, "Bulk Data Loading for MyISAM Tables"

Section 10.5, "Character Set Configuration"

Section 14.3.3.3, "Compressed Table Characteristics"

Section 14.3.4.1, "Corrupted MyISAM Tables"

Section 7.2, "Database Backup Methods"

Section 23.4.1, "Debugging a MySQL Server"

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

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 14.3.3.2, "Dynamic Table Characteristics"

Section 8.10.5, "External Locking"

Section 12.9.6, "Fine-Tuning MySQL Full-Text Search"

Section 7.6.2, "How to Check MyISAM Tables for Errors"

Section 7.6.3, "How to Repair MyISAM Tables"

Section 1.7, "How to Report Bugs or Problems"

Section E.10.3, "Limits on Table Size"

Section 18.3.4, "Maintenance of Partitions"

Section 23.4.1.7, "Making a Test Case If You Experience Table Corruption"

Section 4.6.3.5, "Obtaining Table Information with myisamchk"

Section 8.6.1, "Optimizing MyISAM Queries"

Section 4.6.3.4, "Other myisamchk Options"

Section 8.2.5, "Other Optimization Tips"

Section 4.1, "Overview of MySQL Programs"

Section 14.3.4.2, "Problems from Tables Not Being Closed Properly"

Section 18.6, "Restrictions and Limitations on Partitioning"

Section 5.1.3, "Server Command Options"

Section 7.6.5, "Setting Up a MyISAM Table Maintenance Schedule"

Section 8.6.3, "Speed of REPAIR TABLE Statements"

Section 14.3.3.1, "Static (Fixed-Length) Table Characteristics"

Section 8.11.1, "System Factors and Startup Parameter Tuning"

Section 14.3, "The MyISAM Storage Engine"

Section 7.6.1, "Using myisamchk for Crash Recovery"

Section 23.4.1.6, "Using Server Logs to Find Causes of Errors in mysqld"

Section 8.11.3.1.2, "Using Symbolic Links for MyISAM Tables on Unix"

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

myisamchk *.MYI

Section 7.6.3, "How to Repair MyISAM Tables"

myisamchk tbl_name

Section 7.6.2, "How to Check MyISAM Tables for Errors"

myisamlog

Section 4.6.4, "myisamlog — Display MyISAM Log File Contents"

Section 4.1, "Overview of MySQL Programs"

myisampack

Section 4.6.3.3, "myisamchk Repair Options"

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

Section 13.1.17, "CREATE TABLE Syntax"

Section 14.8.1, "MERGE Table Advantages and Disadvantages"

Section 14.3.3, "MyISAM Table Storage Formats"

Section 8.6.2, "Bulk Data Loading for MyISAM Tables"

Section 14.3.3.3, "Compressed Table Characteristics"

Section 8.10.5, "External Locking"

Section E.10.3, "Limits on Table Size"

Section 4.6.3.5, "Obtaining Table Information with myisamchk"

Section 8.4.1, "Optimizing Data Size"

Section 4.1, "Overview of MySQL Programs"

Section 13.1.17.3, "Silent Column Specification Changes"

Section 14.8, "The MERGE Storage Engine"

Section 14.3, "The MyISAM Storage Engine"

mysql

Section 1.8.5.5, "'--' as the Start of a Comment"

Section 4.5.1, "mysql — The MySQL Command-Line Tool"

Section 4.5.1.2, "mysql Commands"

Section 4.5.1.3, "mysql Logging"

Section 4.5.1.1, "mysql Options"

Section 4.5.1.4, "mysql Server-Side Help"

Section 4.5.1.6, "mysql Tips"

Section 13.1.7.1, "ALTER TABLE Partition Operations"

Section 13.6.1, "BEGIN ... END Compound-Statement Syntax"

Section 13.1.15, "CREATE PROCEDURE and CREATE FUNCTION Syntax"

Section 13.6.7.3, "GET DIAGNOSTICS Syntax"

Section 13.7.1.4, "GRANT Syntax"

Section 13.8.3, "HELP Syntax"

Section C.5.2.15, "Ignoring user"

Section 13.2.6, "LOAD DATA INFILE Syntax"

Section 13.2.7, "LOAD XML Syntax"

Section 22.8.7.14, "mysql_errno()"

Section 22.8.7.67, "mysql_sqlstate()"

Section C.5.2.8, "Out of memory"

Section 18.2.3.1, "RANGE COLUMNS partitioning"

Section 13.7.1.6, "REVOKE Syntax"

Section 13.2.9.1, "SELECT ... INTO Syntax"

Section 14.2.4.4, "SHOW ENGINE INNODB STATUS and the InnoDB Monitors"

Section 13.7.5.35, "SHOW SLAVE STATUS Syntax"

Section 13.6.7.5, "SIGNAL Syntax"

Section 17.5.13.2, "Adding MySQL Cluster Data Nodes Online: Basic procedure"

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

Section 17.5.13.1, "Adding MySQL Cluster Data Nodes Online: General Issues"

Section 6.3.2, "Adding User Accounts"

Section 14.2.2.4, "Backing Up and Recovering an InnoDB Database"

Section 7.1, "Backup and Recovery Types"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 17.5.2, "Commands in the MySQL Cluster Management Client"

Section 9.6, "Comment Syntax"

Section 10.1.5, "Configuring the Character Set and Collation for Applications"

Section 3.1, "Connecting to and Disconnecting from the Server"

Section 4.2.2, "Connecting to the MySQL Server"

Section 5.1.9.4, "Connecting Using IPv6 Nonlocal Host Addresses"

Section 5.1.9.3, "Connecting Using the IPv6 Local Host Address"

Section 10.1.4, "Connection Character Sets and Collations"

Section 22.8.16, "Controlling Automatic Reconnection Behavior"

Section 14.2.5.8, "Controlling Optimizer Statistics Estimation"

Section 5.4.3, "Converting Tables from MyISAM to InnoDB"

Section 2.11.5, "Copying MySQL Databases to Another Machine"

Section 3.3.1, "Creating and Selecting a Database"

Section 14.2.2.1, "Creating the InnoDB Tablespace"

Section 2.3.5.6, "Customizing the PATH for MySQL Tools"

Section 23.4.2, "Debugging a MySQL Client"

Section 19.1, "Defining Stored Programs"

Section 17.4.5, "ndb_mgm — The MySQL Cluster Management Client"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 4.4.6, "mysql_tzinfo_to_sql — Load the Time Zone Tables"

Section 4.5.1.6.5, "Disabling mysql Auto-Reconnect"

Section 17.5.14, "Distributed MySQL Privileges for MySQL Cluster"

Section 2.11.2, "Downgrading MySQL"

Section 6.1.2.1, "End-User Guidelines for Password Security"

Section 3.2, "Entering Queries"

Section 2.12, "Environment Variables"

Section 19.4.2, "Event Scheduler Configuration"

Section 7.3, "Example Backup and Recovery Strategy"

Section 22.8.3, "Example C API Client Programs"

Section 3.6, "Examples of Common Queries"

Section 5.5.5, "Examples of Online DDL"

Section 18.3.3, "Exchanging Partitions and Subpartitions with Tables"

Section 4.5.1.5, "Executing SQL Statements from a Text File"

Chapter 12, Functions and Operators

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

Section 14.2.3.10, "How to Cope with Deadlocks"

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

Section 1.7, "How to Report Bugs or Problems"

Section 6.1.5, "How to Run MySQL as a Normal User"

Section 12.14, "Information Functions"

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 4.5.1.6.1, "Input-Line Editing"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 4.2.1, "Invoking MySQL Programs"

Section 17.1.6.8, "Issues Exclusive to MySQL Cluster"

Section 7.4.5.1, "Making a Copy of a Database"

Section 6.1.3, "Making MySQL Secure Against Attackers"

Section 17.5, "Management of MySQL Cluster"

Section 8.12.1, "Measuring the Speed of Expressions and Functions"

Section 17.6.9, "MySQL Cluster Backups With MySQL Cluster Replication"

Section 17.5.12.1, "MySQL Cluster Disk Data Objects"

Section 17.2.6, "MySQL Cluster Example with Tables and Data"

Chapter 17, MySQL Cluster NDB 7.3

Section 17.6, "MySQL Cluster Replication"

Section 17.6.4, "MySQL Cluster Replication Schema and Tables"

Section 15.7, "MySQL Proxy"

Section 10.6, "MySQL Server Time Zone Support"

Section 17.5.4, "MySQL Server Usage for MySQL Cluster"

Section 17.5.15, "NDB API Statistics Counters and Variables"

Section 8.2.1.3, "Optimizing LIMIT Queries"

Section 4.2.3.6, "Option Defaults, Options Expecting Values, and the = Sign"

Section 4.1, "Overview of MySQL Programs"

Section C.5.2.10, "Packet Too Large"

Section 6.3.6, "Password Expiration and Sandbox Mode"

Section 6.1.2.4, "Password Hashing in MySQL"

Section 6.3.7, "Pluggable Authentication"

Section 7.5, "Point-in-Time (Incremental) Recovery Using the Binary Log"

Section 17.6.5, "Preparing the MySQL Cluster for Replication"

Section 2.10.1.1, "Problems Running mysql_install_db"

Section 4.2.3.2, "Program Option Modifiers"

Section 2.11.4, "Rebuilding or Repairing Tables or Indexes"

Section 7.4.4, "Reloading Delimited-Text Format Backups"

Section 7.4.2, "Reloading SQL-Format Backups"

Section C.5.4.1.3, "Resetting the Root Password: Generic Instructions"

Section E.9, "Restrictions on Pluggable Authentication"

Section 2.10.2, "Securing the Initial MySQL Accounts"

Section 6.1.6, "Security Issues with LOAD DATA LOCAL"

Section 5.1.3, "Server Command Options"

Section C.3, "Server Error Codes and Messages"

Section 5.1.4, "Server System Variables"

Section 5.1.10, "Server-Side Help"

Section 12.18.5, "Spatial Analysis Functions"

Section 4.2.3, "Specifying Program Options"

Section 13.5, "SQL Syntax for Prepared Statements"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Section 17.6.6, "Starting MySQL Cluster Replication (Single Replication Channel)"

Section 9.1.1, "String Literals"

Section 11.4.3, "The BLOB andTEXT Types"

Section 17.5.10.19, "The ndbinfo transporters Table"

Section 17.5.10, "The ndbinfo MySQL Cluster Information Database"

Section 6.3.7.5, "The Cleartext Client-Side Authentication Plugin"

Section 6.3.7.2, "The SHA-256 Authentication Plugin"

Section 6.3.7.6, "The Socket Peer-Credential Authentication Plugin"

Section 19.3.1, "Trigger Syntax and Examples"

Section 14.2.4.7, "Troubleshooting InnoDB Data Dictionary Operations"

Chapter 3, Tutorial

Section 22.2.4.8, "Tutorial: Using MySqlScript"

Section 1.2, "Typographical and Syntax Conventions"

Section 4.5.1.6.2, "Unicode Support on Windows"

Section 6.3.7.3.2.3, "Unix Password Authentication with Proxy Users and Group Mapping"

Section 6.3.7.3.2.1, "Unix Password Authentication without Proxy Users"

Section 2.10.1, "Unix Postinstallation Procedures"

Section 3.5, "Using mysql in Batch Mode"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 7.4, "Using mysqldump for Backups"

Section 7.3.2, "Using Backups for Recovery"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

Section 4.2.3.3, "Using Option Files"

Section 4.2.3.1, "Using Options on the Command Line"

Section 4.2.3.5, "Using Options to Set Program Variables"

Section 23.4.1.6, "Using Server Logs to Find Causes of Errors in mysqld"

Section 6.3.9.3, "Using SSL Connections"

Section 17.5.12.2, "Using Symbolic Links with Disk Data Objects"

Section 4.5.1.6.4, "Using the --safe-updates Option"

Section 1.4, "What Is New in MySQL 5.6"

Section 2.3.8, "Windows Postinstallation Procedures"

Section 12.11, "XML Functions"

mysql ...

Section 23.4.1.1, "Compiling MySQL for Debugging"

mysql {start|stop}

Section 4.3.3, "mysql.server — MySQL Server Startup Script"

mysql-server

Section 2.8, "Installing MySQL on FreeBSD"

mysql-test-run.pl

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 23.1.2, "The MySQL Test Suite"

Section 4.2.3.3, "Using Option Files"

mysql-test-run.pl test_name

Section 23.1.2, "The MySQL Test Suite"

mysql.exe

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 4.5.1.6.2, "Unicode Support on Windows"

mysql.script

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

mysql.server

Section 4.3.3, "mysql.server — MySQL Server Startup Script"

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 2.5, "Installing MySQL on Linux"

Section 6.1.3, "Making MySQL Secure Against Attackers"

Section 4.1, "Overview of MySQL Programs"

Section 5.1.3, "Server Command Options"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

Section C.5.4.6, "Time Zone Problems"

mysql.server stop

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

mysql_config

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

Section 22.8.4.1, "Building C API Client Programs"

Section 22.7.1, "Compiling Programs with libmysqld"

Section 2.9.5, "Dealing with Problems Compiling MySQL"

Section 22.8.1, "MySQL C API Implementations"

Section 4.1, "Overview of MySQL Programs"

Section 23.2.2, "Plugin API Components"

mysql_config options

Section 4.7.2, "mysql_config — Display Options for Compiling Clients"

mysql_config_editor

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling"

Section 6.1.2.1, "End-User Guidelines for Password Security"

Section 2.12, "Environment Variables"

Section 4.1, "Overview of MySQL Programs"

Section 4.2.3.3, "Using Option Files"

Section 1.4, "What Is New in MySQL 5.6"

mysql_config_editor options command

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

mysql_convert_table_format

Section 4.6.11, "mysql_convert_table_format — Convert Tables to Use a Given StorageEngine"

Section 4.1, "Overview of MySQL Programs"

mysql_find_rows

Section 4.6.12, "mysql_find_rows — Extract SQL Statements from Files"

Section 23.4.1.7, "Making a Test Case If You Experience Table Corruption"

Section 4.1, "Overview of MySQL Programs"

mysql_fix_extensions

Section 4.6.13, "mysql_fix_extensions — Normalize Table File Name Extensions"

Section 4.1, "Overview of MySQL Programs"

mysql_fix_extensions data_dir

Section 4.6.13, "mysql_fix_extensions — Normalize Table File Name Extensions"

mysql_install_db

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 6.3.2, "Adding User Accounts"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 16.1.4.5, "Global Transaction ID Options and Variables"

Section 2.5.3, "Installing MySQL on Linux Using Native Package Managers"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 2.4.2, "Installing MySQL on Mac OS X Using Native Packages"

Section 2.6.2, "Installing MySQL on OpenSolaris Using IPS"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 14.2.7, "Limits on InnoDB Tables"

Section 17.6.4, "MySQL Cluster Replication Schema and Tables"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 4.1, "Overview of MySQL Programs"

Section 2.10.1.1, "Problems Running mysql_install_db"

Section 2.10.2, "Securing the Initial MySQL Accounts"

Section 5.1.3, "Server Command Options"

Section 5.1.10, "Server-Side Help"

Section 5.6.1, "Setting Up Multiple Data Directories"

Section 2.10.1, "Unix Postinstallation Procedures"

Section 5.1.2.2, "Using a Sample Default Server Configuration File"

Section 1.4, "What Is New in MySQL 5.6"

mysql_plugin

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.1, "Overview of MySQL Programs"

mysql_secure_installation

Section 4.4.5, "mysql_secure_installation — Improve MySQL Installation Security"

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 2.5.3, "Installing MySQL on Linux Using Native Package Managers"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 2.6.2, "Installing MySQL on OpenSolaris Using IPS"

Section 2.6.1, "Installing MySQL on Solaris Using a Solaris PKG"

Section 4.1, "Overview of MySQL Programs"

Section 2.10.2, "Securing the Initial MySQL Accounts"

mysql_setpermission

Section 4.6.14, "mysql_setpermission — Interactively Set Permissions in GrantTables"

Section 4.1, "Overview of MySQL Programs"

Section 2.10.1, "Unix Postinstallation Procedures"

mysql_setpermissions

Section 4.6.14, "mysql_setpermission — Interactively Set Permissions in GrantTables"

mysql_stmt_execute()

Section 5.1.6, "Server Status Variables"

mysql_stmt_prepare()

Section 5.1.6, "Server Status Variables"

mysql_tzinfo_to_sql

Section 4.4.6, "mysql_tzinfo_to_sql — Load the Time Zone Tables"

Section 10.6, "MySQL Server Time Zone Support"

Section 4.1, "Overview of MySQL Programs"

mysql_tzinfo_to_sql arguments

Section 4.4.6, "mysql_tzinfo_to_sql — Load the Time Zone Tables"

mysql_upgrade

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 13.1.1, "ALTER DATABASE Syntax"

Section 13.7.3.1, "CREATE FUNCTION Syntax for User-Defined Functions"

Section 11.3.4, "YEAR(2) Limitations and Migrating toYEAR(4)"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 2.11.3, "Checking Whether Tables or Indexes Must Be Rebuilt"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 2.11.2, "Downgrading MySQL"

Section 16.1.4.5, "Global Transaction ID Options and Variables"

Section 4.1, "Overview of MySQL Programs"

Section 6.1.2.4, "Password Hashing in MySQL"

Section 21.2.1, "Performance Schema Build Configuration"

Section 2.11.4, "Rebuilding or Repairing Tables or Indexes"

Section 16.1.3.4, "Restrictions on Replication with GTIDs"

Section 5.1.3, "Server Command Options"

Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

Section 2.11.1, "Upgrading MySQL"

Section 2.3.7, "Upgrading MySQL on Windows"

Section 1.4, "What Is New in MySQL 5.6"

mysql_waitpid

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

Section 4.1, "Overview of MySQL Programs"

mysql_waitpid()

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

mysql_zap

Section 4.6.16, "mysql_zap — Kill Processes That Match a Pattern"

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

Section 4.1, "Overview of MySQL Programs"

mysqlaccess

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 1.7, "How to Report Bugs or Problems"

Section 4.1, "Overview of MySQL Programs"

Section 2.10.1, "Unix Postinstallation Procedures"

mysqladmin

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

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

Section 13.1.10, "CREATE DATABASE Syntax"

Section 13.1.21, "DROP DATABASE Syntax"

Section 13.7.6.3, "FLUSH Syntax"

Section 6.3.5, "Assigning Account Passwords"

Section 16.3.1.1, "Backing Up a Slave Using mysqldump"

Section 4.2.2, "Connecting to the MySQL Server"

Section 2.3.5.6, "Customizing the PATH for MySQL Tools"

Section 23.4.1, "Debugging a MySQL Server"

Section 4.6.6, "mysql_config_editor — MySQL Configuration Utility"

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 22.8.3, "Example C API Client Programs"

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

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

Section 7.6.3, "How to Repair MyISAM Tables"

Section 1.7, "How to Report Bugs or Problems"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 5.2, "MySQL Server Logs"

Section 4.1, "Overview of MySQL Programs"

Section 6.3.6, "Password Expiration and Sandbox Mode"

Section 6.2.1, "Privileges Provided by MySQL"

Section E.9, "Restrictions on Pluggable Authentication"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

Section 2.10.2, "Securing the Initial MySQL Accounts"

Section 16.1.3.2, "Setting Up Replication Using GTIDs"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Section 2.3.5.5, "Starting MySQL from the Windows Command Line"

Section 6.3.7.5, "The Cleartext Client-Side Authentication Plugin"

Section 5.1.12, "The Shutdown Process"

Section 8.11.2, "Tuning Server Parameters"

Section 2.10.1, "Unix Postinstallation Procedures"

Section 2.3.7, "Upgrading MySQL on Windows"

Section 4.2.3.3, "Using Option Files"

Section 4.2.3.1, "Using Options on the Command Line"

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

mysqladmin debug

Section 13.7.1.4, "GRANT Syntax"

Section 23.4.1, "Debugging a MySQL Server"

Section 19.4.5, "Event Scheduler Status"

Section 6.2.1, "Privileges Provided by MySQL"

mysqladmin extended-status

Section 13.2.5.2, "INSERT DELAYED Syntax"

Section 13.7.5.36, "SHOW STATUS Syntax"

mysqladmin flush-hosts

Section C.5.2.6, "Host 'host_name' isblocked"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 8.11.5.2, "DNS Lookup Optimization and the Host Cache"

Section 5.1.4, "Server System Variables"

mysqladmin flush-logs

Section 7.3.3, "Backup Strategy Summary"

Section 7.3.1, "Establishing a Backup Policy"

Section 5.2.6, "Server Log Maintenance"

Section 5.2.4, "The Binary Log"

Section 5.2.2, "The Error Log"

Section 16.2.2.1, "The Slave Relay Log"

mysqladmin flush-privileges

Section 6.2.7, "Causes of Access-Denied Errors"

Section 2.11.5, "Copying MySQL Databases to Another Machine"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 6.2.2, "Privilege System Grant Tables"

Section 2.10.1.1, "Problems Running mysql_install_db"

Section 5.1.3, "Server Command Options"

Section 6.2.6, "When Privilege Changes Take Effect"

mysqladmin flush-tables

Section 8.6.2, "Bulk Data Loading for MyISAM Tables"

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

Section 8.10.5, "External Locking"

Section 8.4.3.1, "How MySQL Opens and Closes Tables"

Section 8.11.4.1, "How MySQL Uses Memory"

Section 7.6.1, "Using myisamchk for Crash Recovery"

mysqladmin flush-xxx

Section 6.3.2, "Adding User Accounts"

mysqladmin kill

Section 13.7.6.4, "KILL Syntax"

Section C.5.2.9, "MySQL server has gone away"

Section C.5.4.3, "How MySQL Handles a Full Disk"

Section 12.16, "Miscellaneous Functions"

Section 6.2.1, "Privileges Provided by MySQL"

mysqladmin password

Section 6.3.5, "Assigning Account Passwords"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 6.3.6, "Password Expiration and Sandbox Mode"

mysqladmin processlist

Section 13.7.6.4, "KILL Syntax"

Section 22.8.7.43, "mysql_list_processes()"

Section 13.7.5.30, "SHOW PROCESSLIST Syntax"

Section 6.3.2, "Adding User Accounts"

Section 8.12.5, "Examining Thread Information"

Section 6.1.3, "Making MySQL Secure Against Attackers"

Section 23.1.1, "MySQL Threads"

Section 6.2.1, "Privileges Provided by MySQL"

mysqladmin processlist status

Section 23.4.1, "Debugging a MySQL Server"

mysqladmin refresh

Section 6.3.2, "Adding User Accounts"

Section 8.4.3.1, "How MySQL Opens and Closes Tables"

Section 5.2.6, "Server Log Maintenance"

mysqladmin reload

Section 6.3.2, "Adding User Accounts"

Section 4.6.7, "mysqlaccess — Client for Checking Access Privileges"

Section 1.7, "How to Report Bugs or Problems"

Section 6.2.2, "Privilege System Grant Tables"

Section 2.10.1.1, "Problems Running mysql_install_db"

Section 5.1.3, "Server Command Options"

Section 6.3.4, "Setting Account Resource Limits"

Section 6.2.6, "When Privilege Changes Take Effect"

mysqladmin reload version

Section 1.7, "How to Report Bugs or Problems"

mysqladmin shutdown

Section 13.7.1.4, "GRANT Syntax"

Section 6.2.5, "Access Control, Stage 2: Request Verification"

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

Section 14.2.2.1, "Creating the InnoDB Tablespace"

Section 23.4.1.2, "Creating Trace Files"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 7.6.3, "How to Repair MyISAM Tables"

Section 6.1.5, "How to Run MySQL as a Normal User"

Section 2.4.2, "Installing MySQL on Mac OS X Using Native Packages"

Section 23.4.1.7, "Making a Test Case If You Experience Table Corruption"

Section 6.2.1, "Privileges Provided by MySQL"

Section 16.4.1.22, "Replication and Temporary Tables"

Section 17.2.7, "Safe Shutdown and Restart of MySQL Cluster"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Section 5.1.12, "The Shutdown Process"

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

mysqladmin status

Section 22.8.7.69, "mysql_stat()"

Section 4.5.2, "mysqladmin — Client for Administering a MySQL Server"

Section 8.4.3.1, "How MySQL Opens and Closes Tables"

mysqladmin variables

Section C.5.2.9, "MySQL server has gone away"

Section 13.7.5.40, "SHOW VARIABLES Syntax"

mysqladmin variables extended-status processlist

Section 1.7, "How to Report Bugs or Problems"

mysqladmin ver

Section 23.4.1.1, "Compiling MySQL for Debugging"

mysqladmin version

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

Section C.5.2.9, "MySQL server has gone away"

Section 1.7, "How to Report Bugs or Problems"

Section 2.10.1, "Unix Postinstallation Procedures"

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

mysqlanalyze

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

mysqlbackup

Section 14.2.2.4, "Backing Up and Recovering an InnoDB Database"

Section 7.1, "Backup and Recovery Types"

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

Section 4.5.4, "mysqldump — A Database Backup Program"

mysqlbinlog

Section 4.5.1.1, "mysql Options"

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.8.1, "mysqlbinlog Hex Dump Format"

Section 4.6.8.2, "mysqlbinlog Row Event Display"

Section 13.7.6.1, "BINLOG Syntax"

Section 13.7.5.3, "SHOW BINLOG EVENTS Syntax"

Section 13.7.5.33, "SHOW RELAYLOG EVENTS Syntax"

Section 13.4.2.5, "START SLAVE Syntax"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 14.2.2.4, "Backing Up and Recovering an InnoDB Database"

Section 16.1.4.4, "Binary Log Options and Variables"

Section 5.7.1.2, "Command Probes"

Section 16.1.3.1, "GTID Concepts"

Section 16.4.5, "How to Report Replication Bugs or Problems"

Section C.5.8, "Known Issues in MySQL"

Section 12.16, "Miscellaneous Functions"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

Section 4.1, "Overview of MySQL Programs"

Section 7.5, "Point-in-Time (Incremental) Recovery Using the Binary Log"

Section 7.5.2, "Point-in-Time Recovery Using Event Positions"

Section 7.5.1, "Point-in-Time Recovery Using Event Times"

Section 17.6.9.2, "Point-In-Time Recovery Using MySQL Cluster Replication"

Section 16.4.1.33, "Replication and Variables"

Section 16.1.3.4, "Restrictions on Replication with GTIDs"

Section 4.6.8.4, "Specifying the mysqlbinlog Server ID"

Section 5.2.4, "The Binary Log"

Section 16.2.2.1, "The Slave Relay Log"

Section 16.1.2.2, "Usage of Row-Based Logging and Replication"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 7.3.2, "Using Backups for Recovery"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

Section 1.4, "What Is New in MySQL 5.6"

mysqlbinlog binary-log-file | mysql

Section 23.4.1.7, "Making a Test Case If You Experience Table Corruption"

mysqlbinlog|mysql

Section C.5.8, "Known Issues in MySQL"

mysqlbug

Section 4.4.2, "mysqlbug — Generate Bug Report"

mysqlcheck

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 13.1.1, "ALTER DATABASE Syntax"

Section 7.6, "MyISAM Table Maintenance and Crash Recovery"

Section 2.11.3, "Checking Whether Tables or Indexes Must Be Rebuilt"

Section 4.7.3, "my_print_defaults — Display Options from Option Files"

Section 4.4.7, "mysql_upgrade — Check and Upgrade MySQL Tables"

Section 18.3.4, "Maintenance of Partitions"

Section 9.2.3, "Mapping of Identifiers to File Names"

Section 4.1, "Overview of MySQL Programs"

Section 2.11.4, "Rebuilding or Repairing Tables or Indexes"

Section 18.6, "Restrictions and Limitations on Partitioning"

Section 5.1.4, "Server System Variables"

Section 14.3, "The MyISAM Storage Engine"

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 5.7.1, "mysqld DTrace Probe Reference"

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

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

Section C.5.2.13, "Can't create/write to file"

Section C.5.2.17, "Can't initialize character set"

Section C.5.2.4, "Client does not support authentication protocol"

Section 13.7.3.1, "CREATE FUNCTION Syntax for User-Defined Functions"

Section 13.1.17, "CREATE TABLE Syntax"

Section C.5.2.6, "Host 'host_name' is blocked"

Section C.5.2.15, "Ignoring user"

Section 14.2.4.5, "InnoDB General Troubleshooting"

Section 14.2.6, "InnoDB Startup Options and System Variables"

Section 13.2.5.3, "INSERT ... ON DUPLICATE KEY UPDATE Syntax"

Section 13.2.5.2, "INSERT DELAYED Syntax"

Section 13.2.5, "INSERT Syntax"

Section 13.7.6.4, "KILL Syntax"

Section 13.2.6, "LOAD DATA INFILE Syntax"

Section 14.3.1, "MyISAM Startup Options"

Section C.5.2.9, "MySQL server has gone away"

Section 22.8.7.1, "mysql_affected_rows()"

Section 22.8.7.49, "mysql_options()"

Section 13.7.2.4, "OPTIMIZE TABLE Syntax"

Section 13.7.2.5, "REPAIR TABLE Syntax"

Section 13.4.2.3, "RESET SLAVE Syntax"

Section 13.2.9.1, "SELECT ... INTO Syntax"

Section 13.3.6, "SET TRANSACTION Syntax"

Section 14.2.4.4, "SHOW ENGINE INNODB STATUS and the InnoDB Monitors"

Section 13.7.5.16, "SHOW ENGINE Syntax"

Section 13.7.5.40, "SHOW VARIABLES Syntax"

Section C.5.2.7, "Too many connections"

Section 23.3.2, "Adding a New User-Defined Function"

Section 23.3, "Adding New Functions to MySQL"

Section 14.2.2.2, "Adding, Removing, or Resizing InnoDB Data and Log Files"

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

Section 14.2.2.4, "Backing Up and Recovering an InnoDB Database"

Section 16.1.4.4, "Binary Log Options and Variables"

Section 5.2.4.1, "Binary Logging Formats"

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 2.1.2.2, "Choosing a Distribution Format"

Section 17.5.2, "Commands in the MySQL Cluster Management Client"

Section 9.6, "Comment Syntax"

Section C.5.2.11, "Communication Errors and Aborted Connections"

Section 23.3.2.5, "Compiling and Installing User-Defined Functions"

Section 23.4.1.1, "Compiling MySQL for Debugging"

Section 14.2.1.2, "Configuring InnoDB"

Section 6.3.9.2, "Configuring MySQL for SSL"

Section 14.3.4.1, "Corrupted MyISAM Tables"

Section 14.2.2.1, "Creating the InnoDB Tablespace"

Section 23.4.1.2, "Creating Trace Files"

Section 23.4.1.4, "Debugging mysqld under gdb"

Section 23.4.1, "Debugging a MySQL Server"

Section 23.4, "Debugging and Porting MySQL"

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 17.3.2.7, "Defining SQL and Other API Nodes in a MySQL Cluster"

Section 17.4.25, "Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs"

Section 17.4.4, "ndb_mgmd — The MySQL Cluster Management Server Daemon"

Section 17.4.22, "ndb_show_tables — Display List of NDB Tables"

Section 4.6.3, "myisamchk — MyISAM Table-Maintenance Utility"

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

Section 4.6.8, "mysqlbinlog — Utility for Processing Binary Log Files"

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

Section 4.5.4, "mysqldump — A Database Backup Program"

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

Section 4.4.1, "comp_err — Compile MySQL Error Message File"

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 4.4.4, "mysql_plugin — Configure MySQL Server Plugins"

Section 4.3.3, "mysql.server — MySQL Server Startup Script"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 2.12, "Environment Variables"

Section 8.10.5, "External Locking"

Section 12.9.6, "Fine-Tuning MySQL Full-Text Search"

Section 17.6.2, "General Requirements for MySQL Cluster Replication"

Section 8.12.5.2, "General Thread States"

Section 8.4.3.1, "How MySQL Opens and Closes Tables"

Section 8.11.4.1, "How MySQL Uses Memory"

Section 8.2.1.4, "How to Avoid Full Table Scans"

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

Section 7.6.3, "How to Repair MyISAM Tables"

Section 1.7, "How to Report Bugs or Problems"

Section 6.1.5, "How to Run MySQL as a Normal User"

Section 9.2.2, "Identifier Case Sensitivity"

Section 17.6.8, "Implementing Failover with MySQL Cluster Replication"

Section 12.14, "Information Functions"

Section 17.2.4, "Initial Configuration of MySQL Cluster"

Section 17.2.5, "Initial Startup of MySQL Cluster"

Section 17.2.2, "Installation of MySQL Cluster on Linux"

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 14.2.9.3.2, "Installing and Configuring the InnoDB memcached Plugin"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 2.4.2, "Installing MySQL on Mac OS X Using Native Packages"

Section 2.6, "Installing MySQL on Solaris and OpenSolaris"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

Section 17.1.6.8, "Issues Exclusive to MySQL Cluster"

Section 17.6.3, "Known Issues in MySQL Cluster Replication"

Section 23.4.1.7, "Making a Test Case If You Experience Table Corruption"

Section 6.1.3, "Making MySQL Secure Against Attackers"

Section 17.5, "Management of MySQL Cluster"

Section 12.16, "Miscellaneous Functions"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 14.2.2.5, "Moving or Copying InnoDB Tables to Another Machine"

Section 17.3.4.1, "MySQL Cluster mysqld Option and Variable Reference"

Section 17.5.11.3, "MySQL Cluster and MySQL Security Procedures"

Section 17.2.1.3.5, "MySQL Cluster Auto-Installer Define Processes Screen"

Section 17.3.2.1, "MySQL Cluster Configuration: Basic Example"

Section 17.1.1, "MySQL Cluster Core Concepts"

Section 17.2, "MySQL Cluster Installation"

Chapter 17, MySQL Cluster NDB 7.3

Section 17.1.2, "MySQL Cluster Nodes, Node Groups, Replicas, and Partitions"

Section 17.1, "MySQL Cluster Overview"

Section 17.4, "MySQL Cluster Programs"

Section 17.6, "MySQL Cluster Replication"

Section 17.6.11, "MySQL Cluster Replication Conflict Resolution"

Section 17.6.4, "MySQL Cluster Replication Schema and Tables"

Section 17.6.10, "MySQL Cluster Replication: Multi-Master and Circular Replication"

Section 17.3.4.4, "MySQL Cluster Status Variables"

Section 17.3.4.3, "MySQL Cluster System Variables"

Section 2.3.1, "MySQL Installation Layout on Microsoft Windows"

Chapter 5, MySQL Server Administration

Section 4.3, "MySQL Server and Server-Startup Programs"

Section 5.2, "MySQL Server Logs"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

Section 10.6, "MySQL Server Time Zone Support"

Section 17.5.4, "MySQL Server Usage for MySQL Cluster"

Section 17.1.5, "MySQL Server Using InnoDB Compared with MySQL Cluster"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 23.1.1, "MySQL Threads"

Section 17.5.15, "NDB API Statistics Counters and Variables"

Section C.5.6, "Optimizer-Related Issues"

Section 22.7.3, "Options with the Embedded Server"

Section 17.3.3, "Overview of MySQL Cluster Configuration Parameters"

Section 4.1, "Overview of MySQL Programs"

Section C.5.2.10, "Packet Too Large"

Section 21.2.2, "Performance Schema Startup Configuration"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section 17.6.5, "Preparing the MySQL Cluster for Replication"

Section 6.2.2, "Privilege System Grant Tables"

Section 14.3.4.2, "Problems from Tables Not Being Closed Properly"

Section 2.10.1.1, "Problems Running mysql_install_db"

Section C.5.3.1, "Problems with File Permissions"

Section 4.2.3.2, "Program Option Modifiers"

Section 8.9.3.3, "Query Cache Configuration"

Section 17.3.2.2, "Recommended Starting Configuration for MySQL Cluster"

Section 16.1.4.1, "Replication and Binary Logging Option and Variable Reference"

Section 16.1.4, "Replication and Binary Logging Options and Variables"

Section 16.1.4.2, "Replication Master Options and Variables"

Section 16.2.2, "Replication Relay and Status Logs"

Section 16.1.4.3, "Replication Slave Options and Variables"

Section C.5.4.1.3, "Resetting the Root Password: Generic Instructions"

Section C.5.4.1.2, "Resetting the Root Password: Unix Systems"

Section 16.1.3.4, "Restrictions on Replication with GTIDs"

Section C.5.5.5, "Rollback Failure for Nontransactional Tables"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 1.8.3, "Running MySQL in ANSI Mode"

Section 6.1.6, "Security Issues with LOADDATA LOCAL"

Section 6.1.4, "Security-Related mysqld Options and Variables"

Section 2.3.5.3, "Selecting a MySQL Server Type"

Section 1.8.2, "Selecting SQL Modes"

Section 10.1.3.1, "Server Character Set and Collation"

Section 5.1.3, "Server Command Options"

Section 23.2.4.2.2, "Server Plugin Status and System Variables"

Section 5.1.11, "Server Response to Signals"

Section 5.1.7, "Server SQL Modes"

Section 5.1.6, "Server Status Variables"

Section 5.1.4, "Server System Variables"

Section 10.2, "Setting the Error Message Language"

Section 7.6.5, "Setting Up a MyISAM Table Maintenance Schedule"

Section 16.1.3.2, "Setting Up Replication Using GTIDs"

Section 22.8.2, "Simultaneous MySQL Server and MySQL Connector/C Installations"

Section 14.2.4.6, "Starting InnoDB on a Corrupted Database"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

Section 2.10.1.3, "Starting and Troubleshooting the MySQL Server"

Section 5.6.2.2, "Starting Multiple MySQL Instances as Windows Services"

Section 5.6.2.1, "Starting Multiple MySQL Instances at the Windows Command Line"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Section 17.6.6, "Starting MySQL Cluster Replication (Single Replication Channel)"

Section 2.3.5.5, "Starting MySQL from the Windows Command Line"

Section 10.6.1, "Staying Current with Time Zone Changes"

Section 8.10.2, "Table Locking Issues"

Section C.5.2.19, "Table-Corruption Issues"

Section 2.3.5.8, "Testing The MySQL Installation"

Section 14.7, "The BLACKHOLE Storage Engine"

Section 14.3, "The MyISAM Storage Engine"

Section 17.5.10, "The ndbinfo MySQL Cluster Information Database"

Section 5.2.4, "The Binary Log"

Section 5.2.2, "The Error Log"

Section 5.2.3, "The General Query Log"

Section 8.9.3, "The MySQL Query Cache"

Section 5.1, "The MySQL Server"

Section 23.1.2, "The MySQL Test Suite"

Section 5.2.5, "The Slow Query Log"

Section C.5.4.6, "Time Zone Problems"

Section 5.7, "Tracing mysqld Using DTrace"

Section 14.2.4.5.1, "Troubleshooting InnoDB I/O Problems"

Section 2.3.6, "Troubleshooting a Microsoft Windows MySQL Server Installation"

Section 8.11.2, "Tuning Server Parameters"

Section 1.2, "Typographical and Syntax Conventions"

Section 2.10.1, "Unix Postinstallation Procedures"

Section 2.11.1, "Upgrading MySQL"

Section 2.3.7, "Upgrading MySQL on Windows"

Section 23.3.2.6, "User-Defined Function Security Precautions"

Section 7.6.1, "Using myisamchk for Crash Recovery"

Section 23.4.1.3, "Using pdb to create a Windows crashdump"

Section 23.4.1.5, "Using a Stack Trace"

Section 4.2.3.3, "Using Option Files"

Section 23.4.1.6, "Using Server Logs to Find Causes of Errors in mysqld"

Section 8.11.3.1.2, "Using Symbolic Links for MyISAM Tables on Unix"

Section 8.11.3.1.3, "Using Symbolic Links for Databases on Windows"

Section 2.4.5, "Using the Bundled MySQL on Mac OS X Server"

Section 14.2.9.6, "Using the InnoDB memcached Plugin with Replication"

Section 17.6.7, "Using Two Replication Channels for MySQL Cluster Replication"

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

Section 6.2.6, "When Privilege Changes Take Effect"

Section C.5.4.4, "Where MySQL Stores Temporary Files"

Section 23.2.4, "Writing Plugins"

mysqld mysqld.trace

Section 23.4.1.2, "Creating Trace Files"

mysqld-

Section 2.11.1, "Upgrading MySQL"

mysqld-debug

Section 2.1.2.2, "Choosing a Distribution Format"

Section 23.4.1.2, "Creating Trace Files"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

Section 2.3.5.3, "Selecting a MySQL Server Type"

Section 5.6.2.1, "Starting Multiple MySQL Instances at the Windows Command Line"

mysqld.exe

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

mysqld_multi

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 4.1, "Overview of MySQL Programs"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

mysqld_safe

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

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

Section 14.2.4.5, "InnoDB General Troubleshooting"

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

Section 23.4.1.1, "Compiling MySQL for Debugging"

Section 14.2.2.1, "Creating the InnoDB Tablespace"

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 4.3.3, "mysql.server — MySQL Server Startup Script"

Section 4.3.4, "mysqld_multi — Manage Multiple MySQL Servers"

Section 8.11.4.2, "Enabling Large Page Support"

Section C.5.4.5, "How to Protect or Change the MySQL Unix Socket File"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 6.1.3, "Making MySQL Secure Against Attackers"

Section 17.5.11.3, "MySQL Cluster and MySQL Security Procedures"

Section 10.6, "MySQL Server Time Zone Support"

Section 4.2.3.6, "Option Defaults, Options Expecting Values, and the =Sign"

Section 4.1, "Overview of MySQL Programs"

Section C.5.2.10, "Packet Too Large"

Section C.5.3.1, "Problems with File Permissions"

Section 5.6, "Running Multiple MySQL Instances on One Machine"

Section 5.6.3, "Running Multiple MySQL Instances on Unix"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 16.1.3.2, "Setting Up Replication Using GTIDs"

Section 2.10.1.2, "Starting and Stopping MySQL Automatically"

Section 2.10.1.3, "Starting and Troubleshooting the MySQL Server"

Section 5.2.2, "The Error Log"

Section C.5.4.6, "Time Zone Problems"

Section 8.11.2, "Tuning Server Parameters"

Section 2.10.1, "Unix Postinstallation Procedures"

Section 5.1.2.2, "Using a Sample Default Server Configuration File"

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.1.1, "mysql Options"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 7.4.5, "mysqldump Tips"

Section 13.1.17, "CREATE TABLE Syntax"

Section 13.2.6, "LOAD DATA INFILE Syntax"

Section 13.2.7, "LOAD XML Syntax"

Section 13.7.3.4, "UNINSTALL PLUGIN Syntax"

Section 11.3.4, "YEAR(2) Limitations and Migrating to YEAR(4)"

Section 14.2.2.2, "Adding, Removing, or Resizing InnoDB Data and Log Files"

Section 16.3.1.3, "Backing Up a Master or Slave by Making It Read Only"

Section 16.3.1.1, "Backing Up a Slave Using mysqldump"

Section 14.2.2.4, "Backing Up and Recovering an InnoDB Database"

Chapter 7, Backup and Recovery

Section 7.1, "Backup and Recovery Types"

Section 7.3.3, "Backup Strategy Summary"

Section 8.5.4, "Bulk Data Loading for InnoDB Tables"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 2.11.3, "Checking Whether Tables or Indexes Must Be Rebuilt"

Section 4.2.2, "Connecting to the MySQL Server"

Section 7.4.5.2, "Copy a Database from one Server to Another"

Section 2.11.5, "Copying MySQL Databases to Another Machine"

Section 5.4.1.3, "Copying Tablespaces to Another Server (Transportable Tablespaces)"

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 5.4, "Creating and Using InnoDB Tables and Indexes"

Section 2.3.5.6, "Customizing the PATH for MySQL Tools"

Section 7.2, "Database Backup Methods"

Section 5.3.4, "Defragmenting a Table"

Section 17.4.18, "ndb_restore — Restore a MySQL Cluster Backup"

Section 4.6.1, "innochecksum — Offline InnoDB File Checksum Utility"

Section 17.5.14, "Distributed MySQL Privileges for MySQL Cluster"

Section 2.11.2, "Downgrading MySQL"

Section 7.4.3, "Dumping Data in Delimited-Text Format with mysqldump"

Section 7.4.1, "Dumping Data in SQL Format with mysqldump"

Section 7.4.5.3, "Dumping Stored Programs"

Section 7.4.5.4, "Dumping Table Definitions and Content Separately"

Section 5.4.1.1, "Enabling and Disabling File-Per-Table Mode"

Section 7.3.1, "Establishing a Backup Policy"

Section 7.3, "Example Backup and Recovery Strategy"

Section 1.8.5.4, "Foreign Key Differences"

Section 1.7, "How to Report Bugs or Problems"

Section 16.1.1, "How to Set Up Replication"

Section 9.2.2, "Identifier Case Sensitivity"

Section 7.4.5.1, "Making a Copy of a Database"

Section 9.2.3, "Mapping of Identifiers to File Names"

Section 14.2.2.5, "Moving or Copying InnoDB Tables to Another Machine"

Section 17.2.6, "MySQL Cluster Example with Tables and Data"

Section 17.1, "MySQL Cluster Overview"

Section 5.2, "MySQL Server Logs"

Section 16.1.1.4, "Obtaining the Replication Master Binary Log Coordinates"

Section 17.5.3, "Online Backup of MySQL Cluster"

Section 4.1, "Overview of MySQL Programs"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section 17.6.9.2, "Point-In-Time Recovery Using MySQL Cluster Replication"

Section 17.6.5, "Preparing the MySQL Cluster for Replication"

Section C.5.5.8, "Problems with Floating-Point Values"

Section 2.11.4, "Rebuilding or Repairing Tables or Indexes"

Section 7.4.4, "Reloading Delimited-Text Format Backups"

Section 7.4.2, "Reloading SQL-Format Backups"

Section 16.3.4, "Replicating Different Databases to Different Slaves"

Section 16.2.2, "Replication Relay and Status Logs"

Section E.8, "Restrictions on Performance Schema"

Section 16.1.3.4, "Restrictions on Replication with GTIDs"

Section E.5, "Restrictions on Views"

Section 5.2.1, "Selecting General Query and Slow Query Log Output Destinations"

Section 5.2.6, "Server Log Maintenance"

Section 5.1.7, "Server SQL Modes"

Section 5.1.4, "Server System Variables"

Section 16.1.1.8, "Setting Up Replication with Existing Data"

Section C.5.5.7, "Solving Problems with No Matching Rows"

Section 4.2.3, "Specifying Program Options"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Section 11.4.3, "The BLOB andTEXT Types"

Section 8.9.1, "The InnoDB Buffer Pool"

Section 17.5.10, "The ndbinfo MySQL Cluster Information Database"

Section 2.11.1.1, "Upgrading from MySQL 5.5 to 5.6"

Section 10.1.11, "Upgrading from Previous to Current Unicode Support"

Section 4.6.8.3, "Using mysqlbinlog to Back Up Binary Log Files"

Section 7.4, "Using mysqldump for Backups"

Section 7.4.5.5, "Using mysqldump to Test for Upgrade Incompatibilities"

Section 13.1.17.2, "Using FOREIGN KEY Constraints"

Section 16.1.3.3, "Using GTIDs for Failover and Scaleout"

Section 16.3.1, "Using Replication for Backups"

Section 16.3.2, "Using Replication with Different Master and Slave Storage Engines"

Section 14.2.9.6, "Using the InnoDB memcached Plugin with Replication"

Section 12.11, "XML Functions"

mysqldump mysql

Section 6.2.7, "Causes of Access-Denied Errors"

mysqldumpslow

Section 4.6.9, "mysqldumpslow — Summarize Slow Query Log Files"

Section 4.1, "Overview of MySQL Programs"

Section 5.2.5, "The Slow Query Log"

mysqlhotcopy

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

Chapter 7, Backup and Recovery

Section 7.1, "Backup and Recovery Types"

Section 7.2, "Database Backup Methods"

Section 4.5.4, "mysqldump — A Database Backup Program"

Section 4.1, "Overview of MySQL Programs"

mysqlhotcopy arguments

Section 4.6.10, "mysqlhotcopy — A Database Backup Program"

mysqlimport

Section 4.5.5, "mysqlimport — A Data Import Program"

Section 13.2.6, "LOAD DATA INFILE Syntax"

Section 7.1, "Backup and Recovery Types"

Section 2.11.5, "Copying MySQL Databases to Another Machine"

Section 7.2, "Database Backup Methods"

Section 2.11.2, "Downgrading MySQL"

Section 4.1, "Overview of MySQL Programs"

Section 7.4.4, "Reloading Delimited-Text Format Backups"

Section 6.1.6, "Security Issues with LOADDATA LOCAL"

mysqloptimize

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

mysqlrepair

Section 4.5.3, "mysqlcheck — A Table Maintenance Program"

mysqlshow

Section 4.5.6, "mysqlshow — Display Database, Table, and Column Information"

Section 13.7.5.15, "SHOW DATABASES Syntax"

Section 13.7.5.23, "SHOW INDEX Syntax"

Section 13.7.5.37, "SHOW TABLE STATUS Syntax"

Section 4.2.2, "Connecting to the MySQL Server"

Section 22.8.3, "Example C API Client Programs"

Section 4.1, "Overview of MySQL Programs"

Section 2.3.5.8, "Testing The MySQL Installation"

Section 2.3.8, "Windows Postinstallation Procedures"

mysqlshow db_name

Section 13.7.5.38, "SHOW TABLES Syntax"

mysqlshow db_name tbl_name

Section 13.7.5.6, "SHOW COLUMNS Syntax"

mysqlshow mysql user

Section C.5.2.15, "Ignoring user"

mysqlslap

Section 4.5.7, "mysqlslap — Load Emulation Client"

Section 4.1, "Overview of MySQL Programs"

Section 6.3.7.5, "The Cleartext Client-Side Authentication Plugin"

Section 8.12.3, "Using Your Own Benchmarks"

mysqltest

Section 6.3.6, "Password Expiration and Sandbox Mode"

Section 23.1.2, "The MySQL Test Suite"

Section 6.3.7.2, "The SHA-256 Authentication Plugin"

N

[index top]

ndb_config

Section 17.4.6, "ndb_config — Extract MySQL Cluster Configuration Information"

Section 17.4, "MySQL Cluster Programs"

ndb_config options

Section 17.4.6, "ndb_config — Extract MySQL Cluster Configuration Information"

ndb_cpcd

Section 17.4.7, "ndb_cpcd — Automate Testing for NDB Development"

ndb_cpcd options

Section 17.4.7, "ndb_cpcd — Automate Testing for NDB Development"

ndb_delete_all

Section 17.4.8, "ndb_delete_all — Delete All Rows from an NDB Table"

ndb_delete_all options

Section 17.4.8, "ndb_delete_all — Delete All Rows from an NDB Table"

ndb_desc

Section 17.4.9, "ndb_desc — Describe NDB Tables"

Section 18.2.5, "KEY Partitioning"

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 17.5.11.3, "MySQL Cluster and MySQL Security Procedures"

Section 17.5.12.1, "MySQL Cluster Disk Data Objects"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

Section 17.5.10.4, "The ndbinfo cluster_operations Table"

Section 17.5.10.15, "The ndbinfo server_operations Table"

ndb_desc options

Section 17.4.9, "ndb_desc — Describe NDB Tables"

ndb_drop_index

Section 17.4.10, "ndb_drop_index — Drop Index from an NDB Table"

ndb_drop_index options

Section 17.4.10, "ndb_drop_index — Drop Index from an NDB Table"

ndb_drop_table

Section 17.4.11, "ndb_drop_table — Drop an NDB Table"

Section 17.4.10, "ndb_drop_index — Drop Index from an NDB Table"

ndb_drop_table options

Section 17.4.11, "ndb_drop_table — Drop an NDB Table"

ndb_error_reporter

Section 17.4.12, "ndb_error_reporter — NDB Error-Reporting Utility"

ndb_error_reporter options

Section 17.4.12, "ndb_error_reporter — NDB Error-Reporting Utility"

ndb_index_stat

Section 17.4.13, "ndb_index_stat — NDB Index Statistics Utility"

ndb_index_stat options

Section 17.4.13, "ndb_index_stat — NDB Index Statistics Utility"

ndb_mgm

Section 17.4.5, "ndb_mgm — The MySQL Cluster Management Client"

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

Section 17.5.13.1, "Adding MySQL Cluster Data Nodes Online: General Issues"

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

Section 17.5.2, "Commands in the MySQL Cluster Management Client"

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 17.4.4, "ndb_mgmd — The MySQL Cluster Management Server Daemon"

Section 17.4.18, "ndb_restore — Restore a MySQL Cluster Backup"

Section 17.5.14, "Distributed MySQL Privileges for MySQL Cluster"

Section 17.5.6, "Event Reports Generated in MySQL Cluster"

Section 17.2.5, "Initial Startup of MySQL Cluster"

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.2, "Installation of MySQL Cluster on Linux"

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 17.1.1, "MySQL Cluster Core Concepts"

Section 17.5.6.1, "MySQL Cluster Logging Management Commands"

Chapter 17, MySQL Cluster NDB 7.3

Section 17.1.2, "MySQL Cluster Nodes, Node Groups, Replicas, and Partitions"

Section 17.4, "MySQL Cluster Programs"

Section 17.5.11.1, "MySQL Cluster Security and Networking Issues"

Section 17.5.8, "MySQL Cluster Single User Mode"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

Section 17.5.3, "Online Backup of MySQL Cluster"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section 17.6.9.2, "Point-In-Time Recovery Using MySQL Cluster Replication"

Section 17.2.7, "Safe Shutdown and Restart of MySQL Cluster"

Section 17.5.10.1, "The ndbinfo arbitrator_validity_detail Table"

Section 17.5.10.11, "The ndbinfo membership Table"

Section 17.5.10.12, "The ndbinfo memoryusage Table"

Section 17.5.10.13, "The ndbinfo nodes Table"

Section 17.5.10.19, "The ndbinfo transporters Table"

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

ndb_mgm options

Section 17.4.5, "ndb_mgm — The MySQL Cluster Management Client"

ndb_mgm.exe

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

ndb_mgmd

Section 17.4.4, "ndb_mgmd — The MySQL Cluster Management Server Daemon"

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

Section 17.5.2, "Commands in the MySQL Cluster Management Client"

Section 17.3.2.5, "Defining a MySQL Cluster Management Server"

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 17.4.1, "ndbd — The MySQL Cluster Data Node Daemon"

Section 17.2.5, "Initial Startup of MySQL Cluster"

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.2, "Installation of MySQL Cluster on Linux"

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 17.2.1.3.5, "MySQL Cluster Auto-Installer Define ProcessesScreen"

Section 17.3.2.1, "MySQL Cluster Configuration: Basic Example"

Section 17.1.1, "MySQL Cluster Core Concepts"

Section 17.5.6.1, "MySQL Cluster Logging Management Commands"

Section 17.1.2, "MySQL Cluster Nodes, Node Groups, Replicas, and Partitions"

Section 17.4, "MySQL Cluster Programs"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 17.3.3, "Overview of MySQL Cluster Configuration Parameters"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section 17.3.1, "Quick Test Setup of MySQL Cluster"

Section 17.2.7, "Safe Shutdown and Restart of MySQL Cluster"

Section 17.5.1, "Summary of MySQL Cluster Start Phases"

Section 17.3.2.3, "The MySQL Cluster Connectstring"

ndb_mgmd options

Section 17.4.4, "ndb_mgmd — The MySQL Cluster Management Server Daemon"

ndb_mgmd.exe

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

ndb_print_backup_file

Section 17.4.14, "ndb_print_backup_file — Print NDB Backup File Contents"

Section 17.4.25, "Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs"

Section 17.4.15, "ndb_print_schema_file — Print NDB Schema File Contents"

Section 17.4.16, "ndb_print_sys_file — Print NDB System File Contents"

Section 17.4.17, "ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log"

ndb_print_backup_file file_name

Section 17.4.14, "ndb_print_backup_file — Print NDB Backup File Contents"

ndb_print_schema_file

Section 17.4.15, "ndb_print_schema_file — Print NDB Schema File Contents"

Section 17.4.25, "Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs"

Section 17.4.14, "ndb_print_backup_file — Print NDB Backup File Contents"

Section 17.4.16, "ndb_print_sys_file — Print NDB System File Contents"

Section 17.4.17, "ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log"

ndb_print_schema_file file_name

Section 17.4.15, "ndb_print_schema_file — Print NDB Schema File Contents"

ndb_print_sys_file

Section 17.4.16, "ndb_print_sys_file — Print NDB System File Contents"

Section 17.4.25, "Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs"

Section 17.4.14, "ndb_print_backup_file — Print NDB Backup File Contents"

Section 17.4.15, "ndb_print_schema_file — Print NDB Schema File Contents"

ndb_print_sys_file file_name

Section 17.4.16, "ndb_print_sys_file — Print NDB System File Contents"

ndb_restore

Section 17.4.18, "ndb_restore — Restore a MySQL Cluster Backup"

Section 7.1, "Backup and Recovery Types"

Section 17.5.14, "Distributed MySQL Privileges for MySQL Cluster"

Section 17.6.9, "MySQL Cluster Backups With MySQL Cluster Replication"

Section 17.1.1, "MySQL Cluster Core Concepts"

Section 17.1, "MySQL Cluster Overview"

Section 17.4, "MySQL Cluster Programs"

Section 17.6.4, "MySQL Cluster Replication Schema and Tables"

Section 17.6.10, "MySQL Cluster Replication: Multi-Master and Circular Replication"

Section 17.5.8, "MySQL Cluster Single User Mode"

Section 17.5.3, "Online Backup of MySQL Cluster"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section 17.6.9.2, "Point-In-Time Recovery Using MySQL Cluster Replication"

ndb_restore options

Section 17.4.18, "ndb_restore — Restore a MySQL Cluster Backup"

ndb_schema_backup_file

Section 17.4.15, "ndb_print_schema_file — Print NDB Schema File Contents"

ndb_select_all

Section 17.4.19, "ndb_select_all — Print Rows from an NDB Table"

Section 17.4.22, "ndb_show_tables — Display List of NDB Tables"

Section 17.5.11.3, "MySQL Cluster and MySQL Security Procedures"

ndb_select_count

Section 17.4.20, "ndb_select_count — Print Row Counts for NDB Tables"

ndb_setup.py

Section 17.4.21, "ndb_setup.py — Start browser-based Auto-Installer forMySQL Cluster"

Section 17.2.1.3.2, "MySQL Cluster Auto-Installer Welcome Screen"

Section 17.2.1.2, "MySQL Cluster Auto-Installer Overview"

Section 17.2.1.1, "MySQL Cluster Auto-Installer Requirements"

Section 17.4, "MySQL Cluster Programs"

Section 17.2.1.3.1, "Starting the MySQL Cluster Auto-Installer"

ndb_show_tables

Section 17.4.22, "ndb_show_tables — Display List of NDB Tables"

Section 17.5.11.3, "MySQL Cluster and MySQL Security Procedures"

Section 17.4, "MySQL Cluster Programs"

Section 17.6.4, "MySQL Cluster Replication Schema and Tables"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

Section 17.5.10.4, "The ndbinfo cluster_operations Table"

Section 17.5.10.15, "The ndbinfo server_operations Table"

ndb_size.pl

Section 17.4.23, "ndb_size.pl — NDBCLUSTER Size Requirement Estimator"

Section 11.6, "Data Type Storage Requirements"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

ndb_size.pl arguments

Section 17.4.23, "ndb_size.pl — NDBCLUSTER Size Requirement Estimator"

ndb_waiter

Section 17.4.24, "ndb_waiter — Wait for MySQL Cluster to Reach a Given Status"

ndb_waiter options

Section 17.4.24, "ndb_waiter — Wait for MySQL Cluster to Reach a Given Status"

ndbd

Section 17.4.1, "ndbd — The MySQL Cluster Data Node Daemon"

Section 17.5.13.2, "Adding MySQL Cluster Data Nodes Online: Basic procedure"

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

Section 17.5.2, "Commands in the MySQL Cluster Management Client"

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 17.4.4, "ndb_mgmd — The MySQL Cluster Management Server Daemon"

Section 17.4.18, "ndb_restore — Restore a MySQL Cluster Backup"

Section 17.4.24, "ndb_waiter — Wait for MySQL Cluster to Reach a Given Status"

Section 17.4.3, "ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)"

Section 17.2.5, "Initial Startup of MySQL Cluster"

Section 17.2.2, "Installation of MySQL Cluster on Linux"

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 17.5, "Management of MySQL Cluster"

Section 17.2.1.3.5, "MySQL Cluster Auto-Installer Define Processes Screen"

Section 17.6.9, "MySQL Cluster Backups With MySQL Cluster Replication"

Section 17.3.2.1, "MySQL Cluster Configuration: Basic Example"

Section 17.1.1, "MySQL Cluster Core Concepts"

Section 17.3.3.1, "MySQL Cluster Data Node Configuration Parameters"

Section 17.2, "MySQL Cluster Installation"

Section 17.3.5.2, "MySQL Cluster Interconnects and Performance"

Section 17.1.2, "MySQL Cluster Nodes, Node Groups, Replicas, and Partitions"

Section 17.4, "MySQL Cluster Programs"

Section 17.3.4.2, "MySQL Server Options for MySQL Cluster"

Section 17.3.3, "Overview of MySQL Cluster Configuration Parameters"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section 17.6.9.2, "Point-In-Time Recovery Using MySQL Cluster Replication"

Section 17.3.1, "Quick Test Setup of MySQL Cluster"

Section 17.3.2.2, "Recommended Starting Configuration for MySQL Cluster"

Section 17.2.7, "Safe Shutdown and Restart of MySQL Cluster"

Section 17.3.2.11, "SCI Transport Connections in MySQL Cluster"

Section 17.5.1, "Summary of MySQL Cluster Start Phases"

Section 17.5.10.13, "The ndbinfo nodes Table"

Section 17.5.6.3, "Using CLUSTERLOG STATISTICS in the MySQL ClusterManagement Client"

Section 17.3.5, "Using High-Speed Interconnects with MySQL Cluster"

ndbd options

Section 17.4.1, "ndbd — The MySQL Cluster Data Node Daemon"

ndbd.exe

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

ndbd_redo_log_reader

Section 17.4.17, "ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log"

ndbd_redo_log_reader file_name

Section 17.4.17, "ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log"

ndbinfo_select_all

Section 17.4.2, "ndbinfo_select_all — Select From ndbinfo Tables"

ndbinfo_select_all options

Section 17.4.2, "ndbinfo_select_all — Select From ndbinfo Tables"

ndbmtd

Section 17.4.3, "ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)"

Section 17.5.13.2, "Adding MySQL Cluster Data Nodes Online: Basic procedure"

Section 17.5.13.3, "Adding MySQL Cluster Data Nodes Online: Detailed Example"

Section 17.2.2.3, "Building MySQL Cluster from Source on Linux"

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 17.4.4, "ndb_mgmd — The MySQL Cluster Management Server Daemon"

Section 17.4.1, "ndbd — The MySQL Cluster Data Node Daemon"

Section 17.2.2, "Installation of MySQL Cluster on Linux"

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 17.2.2.2, "Installing MySQL Cluster from RPM"

Section 17.2.1.3.5, "MySQL Cluster Auto-Installer Define ProcessesScreen"

Section 17.1.1, "MySQL Cluster Core Concepts"

Section 17.3.3.1, "MySQL Cluster Data Node Configuration Parameters"

Section 17.1.2, "MySQL Cluster Nodes, Node Groups, Replicas, and Partitions"

Section 17.4, "MySQL Cluster Programs"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 17.5.5, "Performing a Rolling Restart of a MySQL Cluster"

Section 17.6.9.2, "Point-In-Time Recovery Using MySQL Cluster Replication"

Section 17.3.2.2, "Recommended Starting Configuration for MySQL Cluster"

Section 17.2.7, "Safe Shutdown and Restart of MySQL Cluster"

Section 17.5.10.13, "The ndbinfo nodes Table"

ndbmtd options

Section 17.4.3, "ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)"

ndbmtd.exe

Section 17.2.3.3, "Initial Startup of MySQL Cluster on Windows"

Section 17.2.3.1, "Installing MySQL Cluster on Windows from a Binary Release"

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

NET

Section 2.3.5.7, "Starting MySQL as a Windows Service"

NET START

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

Section 5.6.2.2, "Starting Multiple MySQL Instances as Windows Services"

net start

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

NET START MySQL

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Section 2.3.6, "Troubleshooting a Microsoft Windows MySQL Server Installation"

Section 2.3.7, "Upgrading MySQL on Windows"

NET STOP

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

Section 5.6.2.2, "Starting Multiple MySQL Instances as Windows Services"

net stop

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

NET STOP MYSQL

Section 17.2.7, "Safe Shutdown and Restart of MySQL Cluster"

NET STOP MySQL

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Netinfo Manager

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

nm

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

Section 23.4.1.5, "Using a Stack Trace"

numactl

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

O

[index top]

openssl

Section 6.3.9.5, "Setting Up SSL Certificates and Keys for MySQL"

openssl md5 package_name

Section 2.1.4.1, "Verifying the MD5 Checksum"

P

[index top]

perror

Section 4.8.1, "perror — Explain Error Codes"

Section C.5.2.18, "'File' Not Found andSimilar Errors"

Section C.5.2.13, "Can't create/write to file"

Section 7.6.3, "How to Repair MyISAM Tables"

Section 14.2.3.14.2, "Operating System Error Codes"

Section 4.1, "Overview of MySQL Programs"

Section C.1, "Sources of Error Information"

pfexec

Section 2.6.2, "Installing MySQL on OpenSolaris Using IPS"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

PGP

Section 2.1.4.2, "Signature Checking Using GnuPG"

ping6

Section 5.1.9.5, "Obtaining an IPv6 Address from a Broker"

pkg

Section 2.6.2, "Installing MySQL on OpenSolaris Using IPS"

pkgadd

Section 2.6.1, "Installing MySQL on Solaris Using a Solaris PKG"

pkgrm

Section 2.6.1, "Installing MySQL on Solaris Using a Solaris PKG"

ppm

Section 2.13, "Perl Installation Notes"

ps

Section 4.6.16, "mysql_zap — Kill Processes That Match a Pattern"

Section 6.1.2.1, "End-User Guidelines for Password Security"

Section 8.11.4.1, "How MySQL Uses Memory"

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

Section 2.10.1.3, "Starting and Troubleshooting the MySQL Server"

ps auxw

Section 4.2.2, "Connecting to the MySQL Server"

ps xa | grep mysqld

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

R

[index top]

rename

Section 5.2.6, "Server Log Maintenance"

Section 5.2.2, "The Error Log"

Section 5.2.3, "The General Query Log"

replace

Section 1.8.5.5, "'--' as the Start of a Comment"

Section 4.8.2, "replace — A String-Replacement Utility"

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

Section 4.1, "Overview of MySQL Programs"

Section 16.3.3, "Using Replication for Scale-Out"

replace arguments

Section 4.8.2, "replace — A String-Replacement Utility"

resolve_stack_dump

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

Section 4.1, "Overview of MySQL Programs"

Section 23.4.1.5, "Using a Stack Trace"

resolveip

Section 4.8.3, "resolveip — Resolve Host name to IP Address or ViceVersa"

Section 4.1, "Overview of MySQL Programs"

rm

Section 13.4.1.1, "PURGE BINARY LOGS Syntax"

rpm

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 2.1.4.4, "Signature Checking Using RPM"

rpmbuild

Section 2.9, "Installing MySQL from Source"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

rsync

Section 7.1, "Backup and Recovery Types"

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

Section 16.1.1.9, "Introducing Additional Slaves to an Existing Replication Environment"

S

[index top]

scp

Section 7.1, "Backup and Recovery Types"

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

sed

Section 3.3.4.7, "Pattern Matching"

SELECT

Section 17.2.6, "MySQL Cluster Example with Tables and Data"

service

Section 2.5.3, "Installing MySQL on Linux Using Native Package Managers"

Service Control Manager

Section 2.3, "Installing MySQL on Microsoft Windows"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

Services

Section 17.2.3.4, "Installing MySQL Cluster Processes as Windows Services"

Section 2.3.5.7, "Starting MySQL as a Windows Service"

setenv

Section 4.2.4, "Setting Environment Variables"

setup.bat

Section 17.2.1.3.1, "Starting the MySQL Cluster Auto-Installer"

sh

Section C.5.2.18, "'File' Not Found andSimilar Errors"

Section 4.2.1, "Invoking MySQL Programs"

Section 4.2.4, "Setting Environment Variables"

Section 1.2, "Typographical and Syntax Conventions"

SHOW

Section 17.4.18, "ndb_restore — Restore a MySQL Cluster Backup"

Section 17.3.1, "Quick Test Setup of MySQL Cluster"

sleep

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

ssh

Section 17.5.11.1, "MySQL Cluster Security and Networking Issues"

Start>Run>cmd.exe

Section 6.3.9.5, "Setting Up SSL Certificates and Keys for MySQL"

strings

Section 6.1.1, "Security Guidelines"

su root

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

sudo

Section 4.4.3, "mysql_install_db — Initialize MySQL Data Directory"

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

swinstall

Section 2.7.2, "Installing MySQL on HP-UX Using DEPOT Packages"

System Preferences...

Section 2.4.4, "Installing and Using the MySQL Preference Pane"

T

[index top]

tar

Section 16.3.1.2, "Backing Up Raw Data from a Slave"

Section 7.1, "Backup and Recovery Types"

Section 2.1.2.2, "Choosing a Distribution Format"

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

Section 3.3, "Creating and Using a Database"

Section 2.7.1, "General Notes on Installing MySQL on HP-UX"

Section 1.7, "How to Report Bugs or Problems"

Section 2.9, "Installing MySQL from Source"

Section 2.4, "Installing MySQL on Mac OS X"

Section 2.6, "Installing MySQL on Solaris and OpenSolaris"

Section 2.6.1, "Installing MySQL on Solaris Using a Solaris PKG"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

Section 2.13.1, "Installing Perl on Unix"

Section 16.1.1.9, "Introducing Additional Slaves to an Existing Replication Environment"

Section 22.8.2, "Simultaneous MySQL Server and MySQL Connector/C Installations"

tcpdump

Section 6.1.1, "Security Guidelines"

tcsh

Section C.5.2.18, "'File' Not Found andSimilar Errors"

Section 2.4.1, "General Notes on Installing MySQL on Mac OS X"

Section 4.2.1, "Invoking MySQL Programs"

Section 4.2.4, "Setting Environment Variables"

Section 1.2, "Typographical and Syntax Conventions"

tee

Section 4.5.1.2, "mysql Commands"

telnet

Section 14.2.9.2, "Architecture of InnoDB and memcached Integration"

Section 6.1.1, "Security Guidelines"

Section 14.2.9.3.3, "Verifying the InnoDB and memcached Setup"

Terminal

Section 2.4, "Installing MySQL on Mac OS X"

Text in this style

Section 1.2, "Typographical and Syntax Conventions"

top

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

U

[index top]

ulimit

Section C.5.2.18, "'File' Not Found andSimilar Errors"

Section 17.3.2.6, "Defining MySQL Cluster Data Nodes"

Section 17.4.25, "Options Common to MySQL Cluster Programs — Options Common to MySQL Cluster Programs"

Section 4.3.2, "mysqld_safe — MySQL Server Startup Script"

Section 8.11.4.2, "Enabling Large Page Support"

Section C.5.2.10, "Packet Too Large"

Section 14.2.9.3.1, "Prerequisites for the InnoDB memcached Plugin"

Section 5.1.3, "Server Command Options"

update-rc.d

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

useradd

Section 17.2.2.1, "Installing a MySQL Cluster Binary Release on Linux"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Section 2.6, "Installing MySQL on Solaris and OpenSolaris"

Section 2.2, "Installing MySQL on Unix/Linux Using Generic Binaries"

usermod

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

V

[index top]

vi

Section 4.5.1.2, "mysql Commands"

Section 17.2.4, "Initial Configuration of MySQL Cluster"

Section 3.3.4.7, "Pattern Matching"

W

[index top]

WinDbg

Section 23.4.1.3, "Using pdb to create a Windows crashdump"

winMd5Sum

Section 2.1.4.1, "Verifying the MD5 Checksum"

WinZip

Section 16.3.1.2, "Backing Up Raw Data from a Slave"

Section 2.9, "Installing MySQL from Source"

Section 2.9.2, "Installing MySQL Using a Standard Source Distribution"

WordPad

Section 13.2.6, "LOAD DATA INFILESyntax"

Y

[index top]

yacc

Section 2.9.5, "Dealing with Problems Compiling MySQL"

Section 9.3, "Reserved Words"

yum

Section 2.5.3, "Installing MySQL on Linux Using Native Package Managers"

Section 2.5.1, "Installing MySQL on Linux Using RPM Packages"

Z

[index top]

zip

Section 16.1.1.6, "Creating a Data Snapshot Using Raw Data Files"

Section 1.7, "How to Report Bugs or Problems"

zsh

Section 4.2.4, "Setting Environment Variables"