Command Index

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

A

[index top]

Access

Section 14.2.2, “DELETE Syntax”

addgroup

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

addr2line

Section 28.5.1.5, “Using a Stack Trace”

adduser

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

ALL STATUS

Section 21.5.8, “NDB Cluster Single User Mode”

APF

Section 21.5.12.1, “NDB Cluster Security and Networking Issues”

apt-get

Section 17.2.1, “Installing memcached
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.6, “Installing MySQL on Linux Using Debian Packages from Oracle”
Section 15.20.4, “Security Considerations for the InnoDB memcached Plugin”
Section 17.2.3.3, “Using libmemcached with C and C++”

B

[index top]

bash

Section 7.1.2.1, “End-User Guidelines for Password Security”
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section 5.2.1, “Invoking MySQL Programs”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 5.2.10, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

binary-configure.sh

Section 1.4, “What Is New in MySQL 5.7”

bison

Section 1.9.1, “Contributors to MySQL”
Section 2.9.5, “Dealing with Problems Compiling MySQL”
Section 2.9, “Installing MySQL from Source”

C

[index top]

c++filt

Section 28.5.1.5, “Using a Stack Trace”

cat

Section 5.5.1.1, “mysql Options”

cd

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

chkconfig

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 5.3.3, “mysql.server — MySQL Server Startup Script”

clang

Section 27.8.4.1, “Building C API Client Programs”

CMake

Section 11.3, “Adding a Character Set”
Section 27.8.4.2, “Building C API Client Programs Using pkg-config”
Section 7.4.2, “Building MySQL with Support for Secure Connections”
Section 21.2.2.4, “Building NDB Cluster from Source on Linux”
Section B.5.2.17, “Can't initialize character set”
Section 21.2.3.2, “Compiling and Installing NDB Cluster from Source on Windows”
Section 28.2.4.3, “Compiling and Installing Plugin Libraries”
Section 11.1.5, “Configuring Application Character Set and Collation”
Section 2.9.5, “Dealing with Problems Compiling MySQL”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 15.14, “InnoDB Startup Options and System Variables”
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 7.5.4.7, “Keyring System Variables”
Section 2.5.10, “Managing MySQL Server with systemd”
Chapter 21, MySQL NDB Cluster 7.5
Section 5.9, “MySQL Program Environment Variables”
Section 21.5.4, “MySQL Server Usage for NDB Cluster”
Section 28.3, “MySQL Services for Plugins”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 25.2.1, “Performance Schema Build Configuration”
Section 27.7.2, “Restrictions When Using the Embedded MySQL Server”
Section 6.6.3, “Running Multiple MySQL Instances on Unix”
Section 7.1.6, “Security Issues with LOAD DATA LOCAL”
Section 11.1.3.2, “Server Character Set and Collation”
Section 6.1.4, “Server Command Options”
Section 6.1.5, “Server System Variables”
Section 16.5, “The ARCHIVE Storage Engine”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 16.9, “The EXAMPLE Storage Engine”
Section 16.8, “The FEDERATED Storage Engine”
Section 1.3.2, “The Main Features of MySQL”
Section 6.7, “Tracing mysqld Using DTrace”
Section 28.4.2.5, “UDF Compiling and Installing”
Section 5.2.6, “Using Option Files”
Section 28.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 28.2.4.11.2, “Using Your Own Protocol Trace Plugins”
Section 1.4, “What Is New in MySQL 5.7”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

cmake

Section 2.9.2, “Installing MySQL Using a Standard Source Distribution”
Section 15.20.4, “Security Considerations for the InnoDB memcached Plugin”
Section 28.4.2.5, “UDF Compiling and Installing”

cmd

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

cmd.exe

Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 5.2.1, “Invoking MySQL Programs”
Section 1.2, “Typographical and Syntax Conventions”

command.com

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

comp_err

Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 5.1, “Overview of MySQL Programs”

configure

Section 1.7, “How to Report Bugs or Problems”
Section 17.2.1, “Installing memcached
Section 21.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 1.2, “Typographical and Syntax Conventions”
Section 17.2.3.3, “Using libmemcached with C and C++”
Section 17.2.3.6, “Using MySQL and memcached with PHP”

connect

Section 3.4.3, “MySQL Shell”
Section 3.5.3, “MySQL Shell”

copy

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

coreadm

Section 2.7, “Installing MySQL on Solaris and OpenSolaris”
Section 6.1.4, “Server Command Options”

cp

Section 18.1.2.6, “Adding Slaves to a Replication Environment”
Section 18.3.1.2, “Backing Up Raw Data from a Slave”
Section 8.1, “Backup and Recovery Types”
Section 18.1.2.4.2, “Creating a Data Snapshot Using Raw Data Files”

cron

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 14.7.2.2, “CHECK TABLE Syntax”
Section 16.2.1, “MyISAM Startup Options”
Section 6.4.7, “Server Log Maintenance”
Section 8.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 4.5, “Using mysql in Batch Mode”

csh

Section 5.2.1, “Invoking MySQL Programs”
Section 5.2.10, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

D

[index top]

daemon_memcached

Section 15.20.5.2, “Adapting a memcached Application for the InnoDB memcached Plugin”
Section 15.20.2, “InnoDB memcached Architecture”

date

Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”

df

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

Directory Utility

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

dnf

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”
Section 2.11.1.2, “Upgrading MySQL with the MySQL Yum Repository”

dnf config-manager

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”

dnf upgrade

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”

dnf upgrade mysql-server

Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”

dpkg

Section 2.5.6, “Installing MySQL on Linux Using Debian Packages from Oracle”

dump

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

E

[index top]

emerge

Section 17.2.1, “Installing memcached

execute()

Section 3.6, “Quick-Start Guide: MySQL for Visual Studio”

EXIT SINGLE USER MODE

Section 21.5.8, “NDB Cluster Single User Mode”

G

[index top]

gcc

Section 27.8.4.1, “Building C API Client Programs”
Section 27.7.1, “Compiling Programs with libmysqld”
Section 2.12.3, “Problems Using the Perl DBI/DBD Interface”
Section 1.9.4, “Tools that were used to create MySQL”
Section 28.4.2.5, “UDF Compiling and Installing”

gdb

Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 28.5.1.4, “Debugging mysqld under gdb”
Section 1.9.4, “Tools that were used to create MySQL”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

git branch

Section 2.9.3, “Installing MySQL Using a Development Source Tree”

git checkout

Section 2.9.3, “Installing MySQL Using a Development Source Tree”

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.3.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 6.1.9.5, “Obtaining an IPv6 Address from a Broker”

gpg

Section 2.1.3.2, “Signature Checking Using GnuPG”

grep

Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.3.4.7, “Pattern Matching”

groupadd

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.7, “Installing MySQL on Solaris and OpenSolaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

gtar

Section 2.9, “Installing MySQL from Source”
Section 2.7, “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 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 1.7, “How to Report Bugs or Problems”
Section 2.4, “Installing MySQL on OS X”

H

[index top]

help

Section 3.4.3, “MySQL Shell”
Section 3.5.3, “MySQL Shell”

help contents

Section 5.5.1.4, “mysql Server-Side Help”

hostname

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

I

[index top]

icc

Section 2.1.5, “Compiler-Specific Build Characteristics”
Section 28.5, “Debugging and Porting MySQL”

ifconfig

Section 6.1.9.1, “Verifying System Support for IPv6”

innochecksum

Section 14.7.2.2, “CHECK TABLE Syntax”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
MySQL Glossary
Section 5.1, “Overview of MySQL Programs”
Section 1.4, “What Is New in MySQL 5.7”

InnoDB

Section 14.1.8, “ALTER TABLE Syntax”

install.rb

Section 17.2.3.7, “Using MySQL and memcached with Ruby”

iptables

Section 19.8, “Frequently Asked Questions”
Section 21.5.12.1, “NDB Cluster Security and Networking Issues”

J

[index top]

java

Section 7.5.4.3, “Configuring the keyring_okv Oracle Key Vault Plugin”

K

[index top]

kill

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”

ksh

Section 5.2.1, “Invoking MySQL Programs”
Section 5.2.10, “Setting Environment Variables”

kswapd

Section 21.3.3.6, “Defining NDB Cluster Data Nodes”

L

[index top]

ldconfig

Section 28.4.2.5, “UDF Compiling and Installing”

ldd libmysqlclient.so

Section 27.8.4.1, “Building C API Client Programs”

less

Section 5.5.1.2, “mysql Commands”
Section 5.5.1.1, “mysql Options”

libmemcached

Section 17.2.3.3.6, “libmemcached Command-Line Utilities”

ln

Section 9.12.3.2, “Using Symbolic Links for MyISAM Tables on Unix”

logger

Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”

lsof +L1

Section B.5.3.5, “Where MySQL Stores Temporary Files”

lz4

Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.5.6, “mysqlpump — A Database Backup Program”

lz4_decompress

Section 5.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.1, “Overview of MySQL Programs”
Section 5.8.5, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

M

[index top]

m4

Section 2.9, “Installing MySQL from Source”

make

Section 28.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.9.5, “Dealing with Problems Compiling MySQL”
Section 17.2.1, “Installing memcached
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.12.3, “Problems Using the Perl DBI/DBD Interface”

make && make install

Section 21.2.2.4, “Building NDB Cluster from Source on Linux”

make install

Section 21.2.2.4, “Building NDB Cluster from Source on Linux”
Section 28.2.4.3, “Compiling and Installing Plugin Libraries”
Section 17.2.1, “Installing memcached
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.12.1, “Installing Perl on Unix”
Section 28.1.2, “The MySQL Test Suite”

make VERBOSE=1

Section 2.9.5, “Dealing with Problems Compiling MySQL”

md5

Section 2.1.3.1, “Verifying the MD5 Checksum”

md5.exe

Section 2.1.3.1, “Verifying the MD5 Checksum”

md5sum

Section 2.1.3.1, “Verifying the MD5 Checksum”

memcache

Section 17.2.2.5, “memcached Hashing/Distribution Types”
Section 17.2.3.5, “Using MySQL and memcached with Python”

memcached

Section 15.20.5.2, “Adapting a memcached Application for the InnoDB memcached Plugin”
Section 15.20.5.1, “Adapting an Existing MySQL Schema for the InnoDB memcached Plugin”
Section 15.20.5.5, “Adapting DML Statements to memcached Operations”
Section 17.2.3.1, “Basic memcached Operations”
Section 15.20.1, “Benefits of the InnoDB memcached Plugin”
Section 15.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 17.2.2.4, “Data Expiry”
Section 17.2.3, “Developing a memcached Application”
Section 17.2.4, “Getting memcached Statistics”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.20, “InnoDB memcached Plugin”
Section 15.20.7, “InnoDB memcached Plugin Internals”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 17.2.1, “Installing memcached
Section 17.2.3.3.6, “libmemcached Command-Line Utilities”
Section 17.2.3.3.3, “libmemcached Set Functions”
Section 17.2.2.1, “memcached Command-Line Options”
Section 17.2.2.2, “memcached Deployment”
Section 17.2.4.5, “memcached Detail Statistics”
Section 17.2.5, “memcached FAQ”
Section 17.2.4.1, “memcached General Statistics”
Section 17.2.2.5, “memcached Hashing/Distribution Types”
Section 17.2.4.3, “memcached Item Statistics”
Section 17.2.2.9, “memcached Logs”
Section 17.2.4.4, “memcached Size Statistics”
Section 17.2.4.2, “memcached Slabs Statistics”
Section 17.2.2.8, “memcached Thread Support”
Section 17.2.2.7, “Memory Allocation within memcached
MySQL Glossary
Section 2.9.4, “MySQL Source-Configuration Options”
Section 21.1.1, “NDB Cluster Core Concepts”
Section 15.20.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 15.20.4, “Security Considerations for the InnoDB memcached Plugin”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 15.20.6, “The InnoDB memcached Plugin and Replication”
Section 15.20.8, “Troubleshooting the InnoDB memcached Plugin”
Section 15.20.5.3, “Tuning InnoDB memcached Plugin Performance”
Section 17.2.3.3, “Using libmemcached with C and C++”
Section 17.2.2, “Using memcached
Section 17.2.2.6, “Using memcached and DTrace”
Section 17.2.3.2, “Using memcached as a MySQL Caching Layer”
Section 17.2.4.6, “Using memcached-tool
Section 17.2.3.8, “Using MySQL and memcached with Java”
Section 17.2.3.4, “Using MySQL and memcached with Perl”
Section 17.2.3.6, “Using MySQL and memcached with PHP”
Section 17.2.3.5, “Using MySQL and memcached with Python”
Section 17.2.3.7, “Using MySQL and memcached with Ruby”
Section 17.2, “Using MySQL with memcached
Section 17.2.2.3, “Using Namespaces”
Section 17.2.3.9, “Using the memcached TCP Text Protocol”
Section 15.20.5, “Writing Applications for the InnoDB memcached Plugin”

memcached-1.2.5 directory:

Section 17.2.1, “Installing memcached

memcached-tool

Section 17.2.4, “Getting memcached Statistics”
Section 17.2.4.6, “Using memcached-tool

memcapable

Section 15.20.2, “InnoDB memcached Architecture”

memcat

Section 15.20.2, “InnoDB memcached Architecture”
Section 17.2.3.3.6, “libmemcached Command-Line Utilities”

memcp

Section 15.20.2, “InnoDB memcached Architecture”
Section 17.2.3.3.6, “libmemcached Command-Line Utilities”

memflush

Section 15.20.2, “InnoDB memcached Architecture”
Section 17.2.3.3.6, “libmemcached Command-Line Utilities”

memrm

Section 15.20.2, “InnoDB memcached Architecture”
Section 17.2.3.3.6, “libmemcached Command-Line Utilities”

memslap

Section 17.2.3.3.6, “libmemcached Command-Line Utilities”
Section 15.20.5.3, “Tuning InnoDB memcached Plugin Performance”

mgmd

Section 21.2, “NDB Cluster Installation”

mkdir

Section 14.1.11, “CREATE DATABASE Syntax”

mklink

Section 9.12.3.3, “Using Symbolic Links for Databases on Windows”
Section 1.4, “What Is New in MySQL 5.7”

more

Section 5.5.1.2, “mysql Commands”
Section 5.5.1.1, “mysql Options”

msql2mysql

Section 1.4, “What Is New in MySQL 5.7”

mv

Section 6.4.7, “Server Log Maintenance”
Section 6.4.2, “The Error Log”
Section 6.4.3, “The General Query Log”

my_print_defaults

Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.7, “MySQL Program Development Utilities”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.1, “Overview of MySQL Programs”

myisam_ftdump

Section 13.9, “Full-Text Search Functions”
Section 5.6.2, “myisam_ftdump — Display Full-Text Index information”
Section 5.1, “Overview of MySQL Programs”

myisamchk

Section 14.7.2.1, “ANALYZE TABLE Syntax”
Section 9.6.2, “Bulk Data Loading for MyISAM Tables”
Section 11.5, “Character Set Configuration”
Section 14.7.2.2, “CHECK TABLE Syntax”
Section 16.2.3.3, “Compressed Table Characteristics”
Section 16.2.4.1, “Corrupted MyISAM Tables”
Section 8.2, “Database Backup Methods”
Section 28.5.1, “Debugging a MySQL Server”
Section 14.2.2, “DELETE Syntax”
Section 16.2.3.2, “Dynamic Table Characteristics”
Section 9.8.2, “EXPLAIN Output Format”
Section 9.11.5, “External Locking”
Section 13.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 8.6.2, “How to Check MyISAM Tables for Errors”
Section 8.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 9.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section C.10.3, “Limits on Table Size”
Section 14.7.6.5, “LOAD INDEX INTO CACHE Syntax”
Section 22.3.4, “Maintenance of Partitions”
Section 28.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 16.2.1, “MyISAM Startup Options”
Section 8.6, “MyISAM Table Maintenance and Crash Recovery”
Section 8.6.4, “MyISAM Table Optimization”
Section 16.2.3, “MyISAM Table Storage Formats”
Section 5.6.3.2, “myisamchk Check Options”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.3.6, “myisamchk Memory Usage”
Section 5.6.3.3, “myisamchk Repair Options”
Section 5.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.6.3.5, “Obtaining Table Information with myisamchk”
Section 9.6.1, “Optimizing MyISAM Queries”
Section 9.6.3, “Optimizing REPAIR TABLE Statements”
Section 5.6.3.4, “Other myisamchk Options”
Section 5.1, “Overview of MySQL Programs”
Section 16.2.4.2, “Problems from Tables Not Being Closed Properly”
Section 14.7.2.5, “REPAIR TABLE Syntax”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 6.1.4, “Server Command Options”
Section 8.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 14.7.5.22, “SHOW INDEX Syntax”
Section 14.7.5.36, “SHOW TABLE STATUS Syntax”
Section 16.2.3.1, “Static (Fixed-Length) Table Characteristics”
Section 9.12.1, “System Factors”
Section 1.3.2, “The Main Features of MySQL”
Section 16.2, “The MyISAM Storage Engine”
Section 8.6.1, “Using myisamchk for Crash Recovery”
Section 28.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 9.12.3.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

myisamchk *.MYI

Section 8.6.3, “How to Repair MyISAM Tables”

myisamchk tbl_name

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

myisamlog

Section 5.6.4, “myisamlog — Display MyISAM Log File Contents”
Section 5.1, “Overview of MySQL Programs”

myisampack

Section 9.6.2, “Bulk Data Loading for MyISAM Tables”
Section 16.2.3.3, “Compressed Table Characteristics”
Section 14.1.18, “CREATE TABLE Syntax”
Section 9.11.5, “External Locking”
Section C.10.3, “Limits on Table Size”
Section 16.7.1, “MERGE Table Advantages and Disadvantages”
Section 16.2.3, “MyISAM Table Storage Formats”
Section 5.6.3.3, “myisamchk Repair Options”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 5.6.3.5, “Obtaining Table Information with myisamchk”
Section 9.4.1, “Optimizing Data Size”
Section 5.1, “Overview of MySQL Programs”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 14.1.18.6, “Silent Column Specification Changes”
Section 16.7, “The MERGE Storage Engine”
Section 16.2, “The MyISAM Storage Engine”

mysql

Section 1.8.2.4, “'--' as the Start of a Comment”
Section 21.5.14.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 21.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 21.5.14.1, “Adding NDB Cluster Data Nodes Online: General Issues”
Section 7.3.2, “Adding User Accounts”
Section 14.1.8.1, “ALTER TABLE Partition Operations”
Section 8.1, “Backup and Recovery Types”
Section 14.6.1, “BEGIN ... END Compound-Statement Syntax”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 5.2.7, “Command-Line Options that Affect Option-File Handling”
Section 21.5.2, “Commands in the NDB Cluster Management Client”
Section 10.6, “Comment Syntax”
Section 21.3, “Configuration of NDB Cluster”
Section 11.1.5, “Configuring Application Character Set and Collation”
Section 7.4.4, “Configuring MySQL to Use Secure Connections”
Section 15.6.12.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 4.1, “Connecting to and Disconnecting from the Server”
Section 5.2.2, “Connecting to the MySQL Server”
Section 6.1.9.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 6.1.9.3, “Connecting Using the IPv6 Local Host Address”
Section 11.1.4, “Connection Character Sets and Collations”
Section 1.9.1, “Contributors to MySQL”
Section 27.8.16, “Controlling Automatic Reconnection Behavior”
Section 15.8.5, “Converting Tables from MyISAM to InnoDB”
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Section 14.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 4.3.1, “Creating and Selecting a Database”
Section 2.3.5.7, “Customizing the PATH for MySQL Tools”
Section 28.5.2, “Debugging a MySQL Client”
Section 21.3.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”
Section 23.1, “Defining Stored Programs”
Section 5.5.1.6.5, “Disabling mysql Auto-Reconnect”
Section 21.5.15, “Distributed MySQL Privileges for NDB Cluster”
Section 2.11.2, “Downgrading MySQL”
Section 15.17.2, “Enabling InnoDB Monitors”
Section 7.1.2.1, “End-User Guidelines for Password Security”
Section 4.2, “Entering Queries”
Section 21.5.7.3, “Event Buffer Reporting in the Cluster Log”
Section 23.4.2, “Event Scheduler Configuration”
Section 8.3, “Example Backup and Recovery Strategy”
Section 27.8.3, “Example C API Client Programs”
Section 4.6, “Examples of Common Queries”
Section 15.13.5, “Examples of Online DDL”
Section 22.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 5.5.1.5, “Executing SQL Statements from a Text File”
Chapter 13, Functions and Operators
Section 13.16.3, “Functions That Search JSON Values”
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section 14.6.7.3, “GET DIAGNOSTICS Syntax”
Section 14.7.1.4, “GRANT Syntax”
Section 14.8.3, “HELP Syntax”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 15.5.5.3, “How to Minimize and Handle Deadlocks”
Section 1.7, “How to Report Bugs or Problems”
Section 7.1.5, “How to Run MySQL as a Normal User”
Section B.5.2.15, “Ignoring user”
Section 13.14, “Information Functions”
Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 15.18.2, “InnoDB Recovery”
Section 5.5.1.6.1, “Input-Line Editing”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 5.2.1, “Invoking MySQL Programs”
Section 21.1.6.8, “Issues Exclusive to NDB Cluster”
Section 9.2.1.16, “LIMIT Query Optimization”
Section 14.2.6, “LOAD DATA INFILE Syntax”
Section 14.2.7, “LOAD XML Syntax”
Section 8.4.5.1, “Making a Copy of a Database”
Section 7.1.3, “Making MySQL Secure Against Attackers”
Section 21.5, “Management of NDB Cluster”
Section 9.13.1, “Measuring the Speed of Expressions and Functions”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 5.5.1.2, “mysql Commands”
MySQL Glossary
Section 5.5.1.3, “mysql Logging”
Chapter 21, MySQL NDB Cluster 7.5
Section 5.5.1.1, “mysql Options”
Section 5.9, “MySQL Program Environment Variables”
Section 11.6, “MySQL Server Time Zone Support”
Section 21.5.4, “MySQL Server Usage for NDB Cluster”
Section 5.5.1.4, “mysql Server-Side Help”
Section 5.5.1.6, “mysql Tips”
Section 5.5.1, “mysql — The MySQL Command-Line Tool”
Section 5.3.3, “mysql.server — MySQL Server Startup Script”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 27.8.7.14, “mysql_errno()”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 27.8.7.72, “mysql_sqlstate()”
Section 5.4.6, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 21.5.16, “NDB API Statistics Counters and Variables”
Section 21.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 21.5.13.1, “NDB Cluster Disk Data Objects”
Section 21.2.6, “NDB Cluster Example with Tables and Data”
Section 21.6, “NDB Cluster Replication”
Section 21.6.4, “NDB Cluster Replication Schema and Tables”
Section 21.4.10, “ndb_desc — Describe NDB Tables”
Section 21.4.5, “ndb_mgm — The NDB Cluster Management Client”
Section 21.5.10, “ndbinfo: The NDB Cluster Information Database”
Section 21.4.2, “ndbinfo_select_all — Select From ndbinfo Tables”
Section 9.9.3, “Optimizer Hints”
Section 5.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.2.8, “Out of memory”
Section 5.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section 7.3.7, “Password Expiration and Sandbox Mode”
Section 7.1.2.4, “Password Hashing in MySQL”
Section 7.3.8, “Pluggable Authentication”
Section 8.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 14.5, “Prepared SQL Statement Syntax”
Section 21.6.5, “Preparing the NDB Cluster for Replication”
Section 5.2.5, “Program Option Modifiers”
Section 22.2.3.1, “RANGE COLUMNS partitioning”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 8.4.4, “Reloading Delimited-Text Format Backups”
Section 8.4.2, “Reloading SQL-Format Backups”
Section 18.4.1.29, “Replication of Server-Side Help Tables”
Section B.5.3.2.3, “Resetting the Root Password: Generic Instructions”
Section C.9, “Restrictions on Pluggable Authentication”
Section 14.7.1.6, “REVOKE Syntax”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 7.1.6, “Security Issues with LOAD DATA LOCAL”
Section 14.2.9.1, “SELECT ... INTO Syntax”
Section 6.1.4, “Server Command Options”
Section B.3, “Server Error Codes and Messages”
Section 6.1.5, “Server System Variables”
Section 6.1.10, “Server-Side Help”
Section 3.3, “Setting Up MySQL as a Document Store”
Section 14.7.5.34, “SHOW SLAVE STATUS Syntax”
Section 14.7.5.40, “SHOW WARNINGS Syntax”
Section 14.6.7.5, “SIGNAL Syntax”
Section 5.2.3, “Specifying Program Options”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 21.6.6, “Starting NDB Cluster Replication (Single Replication Channel)”
Section 10.1.1, “String Literals”
Section 2.10.3, “Testing the Server”
Section 12.4.3, “The BLOB and TEXT Types”
Section 7.5.1.8, “The Cleartext Client-Side Authentication Plugin”
Section 26.4.4.2, “The diagnostics() Procedure”
Section 21.5.10.25, “The ndbinfo memory_per_fragment Table”
Section 21.5.10.41, “The ndbinfo transporters Table”
Section 7.5.1.4, “The SHA-256 Authentication Plugin”
Section 7.5.1.9, “The Socket Peer-Credential Authentication Plugin”
Section 23.3.1, “Trigger Syntax and Examples”
Section 15.21.3, “Troubleshooting InnoDB Data Dictionary Operations”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Chapter 4, Tutorial
Section 1.2, “Typographical and Syntax Conventions”
Section 5.5.1.6.2, “Unicode Support on Windows”
Section 7.5.1.5.5, “Unix Password Authentication with Proxy Users and Group Mapping”
Section 7.5.1.5.3, “Unix Password Authentication without Proxy Users”
Section 2.11.1, “Upgrading MySQL”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”
Section 8.3.2, “Using Backups for Recovery”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 7.5.6.3, “Using MySQL Enterprise Firewall”
Section 4.5, “Using mysql in Batch Mode”
Section 5.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 8.4, “Using mysqldump for Backups”
Section 5.2.6, “Using Option Files”
Section 5.2.4, “Using Options on the Command Line”
Section 5.2.8, “Using Options to Set Program Variables”
Section 28.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 21.5.13.2, “Using Symbolic Links with Disk Data Objects”
Section 5.5.1.6.4, “Using the --safe-updates Option”
Section 28.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 28.2.4.11.2, “Using Your Own Protocol Trace Plugins”
Section 1.4, “What Is New in MySQL 5.7”
Section 21.1.4, “What is New in MySQL NDB Cluster 7.5”
Section 2.3.7, “Windows Postinstallation Procedures”
Section 13.11, “XML Functions”

mysql < dump_file

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”

mysql ...

Section 28.5.1.1, “Compiling MySQL for Debugging”

mysql-server

Section 2.8, “Installing MySQL on FreeBSD”

mysql-test-run.pl

Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 28.1.2, “The MySQL Test Suite”
Section 5.2.6, “Using Option Files”

mysql-test-run.pl test_name

Section 28.1.2, “The MySQL Test Suite”

mysql.exe

Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 5.5.1.6.2, “Unicode Support on Windows”

mysql.server

Section 2.5, “Installing MySQL on Linux”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 7.1.3, “Making MySQL Secure Against Attackers”
Section 5.3.3, “mysql.server — MySQL Server Startup Script”
Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.1, “Overview of MySQL Programs”
Section 6.1.4, “Server Command Options”
Section 2.10.5, “Starting and Stopping MySQL Automatically”
Section B.5.3.7, “Time Zone Problems”

mysql.server stop

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

mysql_client_test_embedded

Section 1.4, “What Is New in MySQL 5.7”

mysql_config

Section 27.8.4.1, “Building C API Client Programs”
Section 27.8.4.2, “Building C API Client Programs Using pkg-config”
Section 27.7.1, “Compiling Programs with libmysqld”
Section 2.9.5, “Dealing with Problems Compiling MySQL”
Section 27.8.1, “MySQL C API Implementations”
Section 5.7.1, “mysql_config — Display Options for Compiling Clients”
Section 5.1, “Overview of MySQL Programs”
Section 28.2.3, “Plugin API Components”
Section 1.4, “What Is New in MySQL 5.7”

mysql_config_editor

Section 5.2.7, “Command-Line Options that Affect Option-File Handling”
Section 7.1.2.1, “End-User Guidelines for Password Security”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 5.6.3.1, “myisamchk General Options”
Section 5.5.1.1, “mysql Options”
Section 5.9, “MySQL Program Environment Variables”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 5.1, “Overview of MySQL Programs”
Section 5.2.6, “Using Option Files”

mysql_convert_table_format

Section 1.4, “What Is New in MySQL 5.7”

mysql_find_rows

Section 1.4, “What Is New in MySQL 5.7”

mysql_fix_extensions

Section 1.4, “What Is New in MySQL 5.7”

mysql_install_db

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 2.11.2, “Downgrading MySQL”
Section 2.10.1, “Initializing the Data Directory”
Section 2.10.1.2, “Initializing the Data Directory Manually Using mysql_install_db”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.9.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.9.4, “MySQL Source-Configuration Options”
Chapter 26, MySQL sys Schema
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 21.6.4, “NDB Cluster Replication Schema and Tables”
Section 5.1, “Overview of MySQL Programs”
Section 2.10.1.3, “Problems Running mysql_install_db”
Section 6.1.4, “Server Command Options”
Section 6.1.2, “Server Configuration Defaults”
Section 6.1.8, “Server SQL Modes”
Section 6.1.5, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

mysql_plugin

Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.1, “Overview of MySQL Programs”
Section 1.4, “What Is New in MySQL 5.7”

mysql_secure_installation

Section 2.10.1.2, “Initializing the Data Directory Manually Using mysql_install_db”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.6, “Installing MySQL on Linux Using Debian Packages from Oracle”
Section 2.7.2, “Installing MySQL on OpenSolaris Using IPS”
Section 2.7.1, “Installing MySQL on Solaris Using a Solaris PKG”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 5.1, “Overview of MySQL Programs”
Section 2.10.4, “Securing the Initial MySQL Accounts”

mysql_server_config

Section 5.7.1, “mysql_config — Display Options for Compiling Clients”

mysql_setpermission

Section 1.9.1, “Contributors to MySQL”
Section 1.4, “What Is New in MySQL 5.7”

mysql_ssl_rsa_setup

Section 7.4.4, “Configuring MySQL to Use Secure Connections”
Section 7.4.6.3, “Creating RSA Keys Using openssl”
Section 7.4.6.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 7.4.6.2, “Creating SSL Certificates and Keys Using openssl”
Section 2.10.1, “Initializing the Data Directory”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 5.4.5, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 5.1, “Overview of MySQL Programs”
Section 7.4, “Using Secure Connections”
Section 1.4, “What Is New in MySQL 5.7”

mysql_stmt_execute()

Section 6.1.7, “Server Status Variables”

mysql_stmt_prepare()

Section 6.1.7, “Server Status Variables”

mysql_tzinfo_to_sql

Section 11.6, “MySQL Server Time Zone Support”
Section 5.4.6, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 5.1, “Overview of MySQL Programs”

mysql_upgrade

Section 14.1.1, “ALTER DATABASE Syntax”
Section 14.1.8, “ALTER TABLE Syntax”
Section 2.11.2.1, “Changes Affecting Downgrades from MySQL 5.7”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 14.7.2.2, “CHECK TABLE Syntax”
Section 2.11.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 14.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 2.11.2, “Downgrading MySQL”
Section 7.2.2, “Grant Tables”
Section B.5.2.15, “Ignoring user”
Section 2.10.1, “Initializing the Data Directory”
Section 7.5.1.3, “Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin”
Chapter 26, MySQL sys Schema
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 21.6.4, “NDB Cluster Replication Schema and Tables”
Section 5.1, “Overview of MySQL Programs”
Section 7.1.2.4, “Password Hashing in MySQL”
Section 25.2.1, “Performance Schema Build Configuration”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”
Section 18.4.1.29, “Replication of Server-Side Help Tables”
Section 18.1.3.4, “Restrictions on Replication with GTIDs”
Section 6.1.4, “Server Command Options”
Section B.3, “Server Error Codes and Messages”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 21.2.8, “Upgrading and Downgrading NDB Cluster”
Section 2.11.1, “Upgrading MySQL”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”
Section 2.11.1.2, “Upgrading MySQL with the MySQL Yum Repository”
Section 7.3.10, “User Account Locking”
Section 1.4, “What Is New in MySQL 5.7”
Section 21.1.4, “What is New in MySQL NDB Cluster 7.5”
Section 12.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)”

mysql_waitpid

Section 1.4, “What Is New in MySQL 5.7”

mysql_zap

Section 1.4, “What Is New in MySQL 5.7”

mysqlaccess

Section 1.9.1, “Contributors to MySQL”
Section 1.4, “What Is New in MySQL 5.7”

mysqladmin

Section 7.3.5, “Assigning Account Passwords”
Section 18.3.1.1, “Backing Up a Slave Using mysqldump”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 6.1.1, “Configuring the Server”
Section 5.2.2, “Connecting to the MySQL Server”
Section 1.9.1, “Contributors to MySQL”
Section 14.1.11, “CREATE DATABASE Syntax”
Section 2.3.5.7, “Customizing the PATH for MySQL Tools”
Section 28.5.1, “Debugging a MySQL Server”
Section 14.1.22, “DROP DATABASE Syntax”
Section 27.8.3, “Example C API Client Programs”
Section 14.7.6.3, “FLUSH Syntax”
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 8.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 6.4, “MySQL Server Logs”
Section 5.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1, “Overview of MySQL Programs”
Section 25.10.9, “Performance Schema Connection Attribute Tables”
Section 7.2.1, “Privileges Provided by MySQL”
Section C.9, “Restrictions on Pluggable Authentication”
Section 6.6.3, “Running Multiple MySQL Instances on Unix”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 18.1.3.2, “Setting Up Replication Using GTIDs”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 2.10.3, “Testing the Server”
Section 7.5.1.8, “The Cleartext Client-Side Authentication Plugin”
Section 1.3.2, “The Main Features of MySQL”
Section 6.1.12, “The Server Shutdown Process”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 5.2.6, “Using Option Files”
Section 5.2.4, “Using Options on the Command Line”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

mysqladmin debug

Section 28.5.1, “Debugging a MySQL Server”
Section 23.4.5, “Event Scheduler Status”
Section 14.7.1.4, “GRANT Syntax”
Section 7.2.1, “Privileges Provided by MySQL”

mysqladmin extended-status

Section 14.7.5.35, “SHOW STATUS Syntax”

mysqladmin flush-hosts

Section 9.12.5.2, “DNS Lookup Optimization and the Host Cache”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 6.1.5, “Server System Variables”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”

mysqladmin flush-logs

Section 8.3.3, “Backup Strategy Summary”
Section 8.3.1, “Establishing a Backup Policy”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.4.7, “Server Log Maintenance”
Section 6.4.4, “The Binary Log”
Section 6.4.2, “The Error Log”
Section 18.2.4.1, “The Slave Relay Log”

mysqladmin flush-privileges

Section 2.11.5, “Copying MySQL Databases to Another Machine”
Section 7.2.2, “Grant Tables”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.1.4, “Server Command Options”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 7.2.6, “When Privilege Changes Take Effect”

mysqladmin flush-tables

Section 9.6.2, “Bulk Data Loading for MyISAM Tables”
Section 9.11.5, “External Locking”
Section 9.4.3.1, “How MySQL Opens and Closes Tables”
Section 9.12.4.1, “How MySQL Uses Memory”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 8.6.1, “Using myisamchk for Crash Recovery”

mysqladmin flush-xxx

Section 7.3.2, “Adding User Accounts”

mysqladmin kill

Section B.5.3.4, “How MySQL Handles a Full Disk”
Section 14.7.6.4, “KILL Syntax”
Section 13.20, “Miscellaneous Functions”
Section B.5.2.9, “MySQL server has gone away”
Section 7.2.1, “Privileges Provided by MySQL”

mysqladmin password

Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”

mysqladmin processlist

Section 7.3.2, “Adding User Accounts”
Section 9.14, “Examining Thread Information”
Section 14.7.6.4, “KILL Syntax”
Section 7.1.3, “Making MySQL Secure Against Attackers”
Section 28.1.1, “MySQL Threads”
Section 27.8.7.44, “mysql_list_processes()”
Section 7.2.1, “Privileges Provided by MySQL”
Section 14.7.5.29, “SHOW PROCESSLIST Syntax”

mysqladmin processlist status

Section 28.5.1, “Debugging a MySQL Server”

mysqladmin refresh

Section 7.3.2, “Adding User Accounts”
Section 9.4.3.1, “How MySQL Opens and Closes Tables”
Section 6.4.7, “Server Log Maintenance”

mysqladmin reload

Section 7.3.2, “Adding User Accounts”
Section 7.2.2, “Grant Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.4, “Server Command Options”
Section 7.3.4, “Setting Account Resource Limits”
Section 7.2.6, “When Privilege Changes Take Effect”

mysqladmin reload version

Section 1.7, “How to Report Bugs or Problems”

mysqladmin shutdown

Section 7.2.5, “Access Control, Stage 2: Request Verification”
Section 21.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 28.5.1.2, “Creating Trace Files”
Section 14.7.1.4, “GRANT Syntax”
Section 8.6.3, “How to Repair MyISAM Tables”
Section 7.1.5, “How to Run MySQL as a Normal User”
Section 2.4.2, “Installing MySQL on OS X Using Native Packages”
Section 28.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 5.3.3, “mysql.server — MySQL Server Startup Script”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 7.2.1, “Privileges Provided by MySQL”
Section 18.4.1.24, “Replication and Temporary Tables”
Section 21.2.7, “Safe Shutdown and Restart of NDB Cluster”
Section 14.7.6.7, “SHUTDOWN Syntax”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 6.1.12, “The Server Shutdown Process”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

mysqladmin status

Section 9.4.3.1, “How MySQL Opens and Closes Tables”
Section 27.8.7.74, “mysql_stat()”
Section 5.5.2, “mysqladmin — Client for Administering a MySQL Server”

mysqladmin variables

Section B.5.2.9, “MySQL server has gone away”
Section 14.7.5.39, “SHOW VARIABLES Syntax”

mysqladmin variables extended-status processlist

Section 1.7, “How to Report Bugs or Problems”

mysqladmin ver

Section 28.5.1.1, “Compiling MySQL for Debugging”

mysqladmin version

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 1.7, “How to Report Bugs or Problems”
Section B.5.2.9, “MySQL server has gone away”
Section 2.10.3, “Testing the Server”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

mysqlanalyze

Section 5.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlbackup

Section 8.1, “Backup and Recovery Types”
Section 18.1.2.4.2, “Creating a Data Snapshot Using Raw Data Files”
Section 15.18.1, “InnoDB Backup”
MySQL Glossary
Section 5.5.4, “mysqldump — A Database Backup Program”

mysqlbinlog

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 14.7.6.1, “BINLOG Syntax”
Section 13.12, “Bit Functions and Operators”
Section 6.7.1.2, “Command Probes”
Section 18.1.3.1, “GTID Concepts”
Section 18.4.5, “How to Report Replication Bugs or Problems”
Section 15.18.2, “InnoDB Recovery”
Section B.5.7, “Known Issues in MySQL”
Section 13.20, “Miscellaneous Functions”
MySQL Glossary
Section 5.5.1.1, “mysql Options”
Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 5.6.7.1, “mysqlbinlog Hex Dump Format”
Section 5.6.7.2, “mysqlbinlog Row Event Display”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.1, “Overview of MySQL Programs”
Section 25.10.9, “Performance Schema Connection Attribute Tables”
Section 8.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 8.5.2, “Point-in-Time Recovery Using Event Positions”
Section 8.5.1, “Point-in-Time Recovery Using Event Times”
Section 21.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 18.4.1.38, “Replication and Variables”
Section 6.1.5, “Server System Variables”
Section 14.7.5.2, “SHOW BINLOG EVENTS Syntax”
Section 14.7.5.32, “SHOW RELAYLOG EVENTS Syntax”
Section 5.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 14.4.2.6, “START SLAVE Syntax”
Section 6.4.4, “The Binary Log”
Section 6.4.3, “The General Query Log”
Section 18.2.4.1, “The Slave Relay Log”
Section 18.2.1.2, “Usage of Row-Based Logging and Replication”
Section 8.3.2, “Using Backups for Recovery”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 5.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 1.4, “What Is New in MySQL 5.7”

mysqlbinlog binary-log-file | mysql

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

mysqlbinlog|mysql

Section B.5.7, “Known Issues in MySQL”

mysqlbug

Section 1.4, “What Is New in MySQL 5.7”

mysqlcheck

Section 14.1.1, “ALTER DATABASE Syntax”
Section 2.11.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 22.3.4, “Maintenance of Partitions”
Section 10.2.3, “Mapping of Identifiers to File Names”
Section 5.7.2, “my_print_defaults — Display Options from Option Files”
Section 8.6, “MyISAM Table Maintenance and Crash Recovery”
Section 5.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.1, “Overview of MySQL Programs”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 6.1.5, “Server System Variables”
Section 1.3.2, “The Main Features of MySQL”
Section 16.2, “The MyISAM Storage Engine”
Section 1.4, “What Is New in MySQL 5.7”

mysqld

Section 28.4.2, “Adding a New User-Defined Function”
Section 28.4, “Adding New Functions to MySQL”
Section 9.2.1.19, “Avoiding Full Table Scans”
Section 6.4.4.1, “Binary Logging Formats”
Section 18.1.6.4, “Binary Logging Options and Variables”
Section 7.4.2, “Building MySQL with Support for Secure Connections”
Section 21.2.2.4, “Building NDB Cluster from Source on Linux”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section B.5.2.13, “Can't create/write to file”
Section B.5.2.17, “Can't initialize character set”
Section 14.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 2.11.2.1, “Changes Affecting Downgrades from MySQL 5.7”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section B.5.2.4, “Client does not support authentication protocol”
Section 21.5.2, “Commands in the NDB Cluster Management Client”
Section 10.6, “Comment Syntax”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 5.4.1, “comp_err — Compile MySQL Error Message File”
Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 21.3, “Configuration of NDB Cluster”
Section 18.1.4.2.1, “Configuring Multi-Source Replication”
Section 6.1.1, “Configuring the Server”
Section 15.20.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 16.2.4.1, “Corrupted MyISAM Tables”
Section 14.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 14.1.18, “CREATE TABLE Syntax”
Section 28.5.1.2, “Creating Trace Files”
Section 15.5.5, “Deadlocks in InnoDB”
Section 28.5.1, “Debugging a MySQL Server”
Section 28.5, “Debugging and Porting MySQL”
Section 28.5.1.4, “Debugging mysqld under gdb”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.3.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”
Section 15.4.7, “Doublewrite Buffer”
Section 2.11.2, “Downgrading MySQL”
Section 15.10.1, “Enabling File Formats”
Section 15.17.2, “Enabling InnoDB Monitors”
Section 21.5.7.3, “Event Buffer Reporting in the Cluster Log”
Section 9.11.5, “External Locking”
Section B.5.2.18, “File Not Found and Similar Errors”
Section 13.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 15.21.2, “Forcing InnoDB Recovery”
Section 19.8, “Frequently Asked Questions”
Section 21.6.2, “General Requirements for NDB Cluster Replication”
Section 9.14.2, “General Thread States”
Section 17.1.3, “Handling MySQL Recovery with ZFS”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 9.4.3.1, “How MySQL Opens and Closes Tables”
Section 9.12.4.1, “How MySQL Uses Memory”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 8.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 7.1.5, “How to Run MySQL as a Normal User”
Section 10.2.2, “Identifier Case Sensitivity”
Section B.5.2.15, “Ignoring user”
Section 21.6.8, “Implementing Failover with NDB Cluster Replication”
Section 13.14, “Information Functions”
Section 21.2.4, “Initial Configuration of NDB Cluster”
Section 21.2.5, “Initial Startup of NDB Cluster”
Section 2.10.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 15.18.1, “InnoDB Backup”
Section 15.12.1, “InnoDB Disk I/O”
Section 15.7.4, “InnoDB File-Per-Table Tablespaces”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.18.2, “InnoDB Recovery”
Section 15.6.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.21, “InnoDB Troubleshooting”
Section 14.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 14.2.5, “INSERT Syntax”
Section 21.2.2, “Installation of NDB Cluster on Linux”
Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.4.2, “Installing MySQL on OS X Using Native Packages”
Section 2.7, “Installing MySQL on Solaris and OpenSolaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”
Section 21.1.6.8, “Issues Exclusive to NDB Cluster”
Section 14.7.6.4, “KILL Syntax”
Section 21.6.3, “Known Issues in NDB Cluster Replication”
Section 14.2.6, “LOAD DATA INFILE Syntax”
Section 28.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 7.1.3, “Making MySQL Secure Against Attackers”
Section 21.5, “Management of NDB Cluster”
Section 2.5.10, “Managing MySQL Server with systemd”
Section 13.20, “Miscellaneous Functions”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 15.8.4, “Moving or Copying InnoDB Tables to Another Machine”
Section 16.2.1, “MyISAM Startup Options”
Section 5.6.3.2, “myisamchk Check Options”
Section 5.6.3.1, “myisamchk General Options”
Section 5.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 5.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section A.1, “MySQL 5.7 FAQ: General”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
MySQL Glossary
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows”
Chapter 21, MySQL NDB Cluster 7.5
Section 5.9, “MySQL Program Environment Variables”
Chapter 6, MySQL Server Administration
Section 5.3, “MySQL Server and Server-Startup Programs”
Section B.5.2.9, “MySQL server has gone away”
Section 6.4, “MySQL Server Logs”
Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 11.6, “MySQL Server Time Zone Support”
Section 21.5.4, “MySQL Server Usage for NDB Cluster”
Section 21.1.5, “MySQL Server Using InnoDB Compared with NDB Cluster”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 1.8, “MySQL Standards Compliance”
Chapter 26, MySQL sys Schema
Section 5.3.3, “mysql.server — MySQL Server Startup Script”
Section 27.8.7.1, “mysql_affected_rows()”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 27.8.7.50, “mysql_options()”
Section 5.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 5.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.5.3, “mysqlcheck — A Table Maintenance Program”
Section 5.3.1, “mysqld — The MySQL Server”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 21.5.16, “NDB API Statistics Counters and Variables”
Section 21.5.12.3, “NDB Cluster and MySQL Security Procedures”
Section 21.2.1.3.5, “NDB Cluster Auto-Installer Define Processes Screen”
Section 21.2.1.3.7, “NDB Cluster Auto-Installer Deploy Cluster Screen”
Section 21.2.1.1, “NDB Cluster Auto-Installer Requirements”
Section 21.3.3.1, “NDB Cluster Configuration: Basic Example”
Section 21.1.1, “NDB Cluster Core Concepts”
Section 21.2, “NDB Cluster Installation”
Section 21.3.2.5, “NDB Cluster mysqld Option and Variable Reference”
Section 21.1.2, “NDB Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 21.1, “NDB Cluster Overview”
Section 21.4, “NDB Cluster Programs”
Section 21.6, “NDB Cluster Replication”
Section 21.6.11, “NDB Cluster Replication Conflict Resolution”
Section 21.6.4, “NDB Cluster Replication Schema and Tables”
Section 21.6.10, “NDB Cluster Replication: Multi-Master and Circular Replication”
Section 21.3.3.8.3, “NDB Cluster Status Variables”
Section 21.3.3.8.2, “NDB Cluster System Variables”
Section 21.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 21.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 21.4.24, “ndb_show_tables — Display List of NDB Tables”
Section 21.5.10, “ndbinfo: The NDB Cluster Information Database”
Section 21.1.6.1, “Noncompliance with SQL Syntax in NDB Cluster”
Section 14.7.2.4, “OPTIMIZE TABLE Syntax”
Section B.5.5, “Optimizer-Related Issues”
Section 21.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 27.7.3, “Options with the Embedded Server”
Section 5.1, “Overview of MySQL Programs”
Section 21.3.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”
Section B.5.2.10, “Packet Too Large”
Section 25.2.2, “Performance Schema Startup Configuration”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 21.6.5, “Preparing the NDB Cluster for Replication”
Section 16.2.4.2, “Problems from Tables Not Being Closed Properly”
Section 2.10.1.3, “Problems Running mysql_install_db”
Section B.5.3.1, “Problems with File Permissions”
Section 5.2.5, “Program Option Modifiers”
Section 9.10.3.3, “Query Cache Configuration”
Section 21.3.3.2, “Recommended Starting Configuration for NDB Cluster”
Section 14.7.2.5, “REPAIR TABLE Syntax”
Section 18.1.6.1, “Replication and Binary Logging Option and Variable Reference”
Section 18.1.6, “Replication and Binary Logging Options and Variables”
Section 18.4.1.34, “Replication and Transaction Inconsistencies”
Section 18.1.6.2, “Replication Master Options and Variables”
Section 18.2.4, “Replication Relay and Status Logs”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 14.4.2.4, “RESET SLAVE Syntax”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.5.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section B.5.4.5, “Rollback Failure for Nontransactional Tables”
Section 6.6, “Running Multiple MySQL Instances on One Machine”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 7.1.6, “Security Issues with LOAD DATA LOCAL”
Section 7.1.4, “Security-Related mysqld Options and Variables”
Section 14.2.9.1, “SELECT ... INTO Syntax”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 11.1.3.2, “Server Character Set and Collation”
Section 6.1.4, “Server Command Options”
Section 6.4.7, “Server Log Maintenance”
Section 28.2.4.2.2, “Server Plugin Status and System Variables”
Section 6.1.11, “Server Response to Signals”
Section 6.1.7, “Server Status Variables”
Section 6.1.5, “Server System Variables”
Section 14.3.6, “SET TRANSACTION Syntax”
Section 11.2, “Setting the Error Message Language”
Section 8.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 18.1.3.2, “Setting Up Replication Using GTIDs”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 14.7.5.15, “SHOW ENGINE Syntax”
Section 27.8.2, “Simultaneous MySQL Server and Connector/C Installations”
Section 14.4.2.6, “START SLAVE Syntax”
Section 2.10.5, “Starting and Stopping MySQL Automatically”
Section 6.6.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 6.6.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 21.6.6, “Starting NDB Cluster Replication (Single Replication Channel)”
Section 18.2.3.3, “Startup Options and Replication Channels”
Section 11.6.1, “Staying Current with Time Zone Changes”
Section 1.9.5, “Supporters of MySQL”
Section 18.3.7, “Switching Masters During Failover”
Section 9.11.2, “Table Locking Issues”
Section B.5.2.19, “Table-Corruption Issues”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.10.3, “Testing the Server”
Section 6.4.4, “The Binary Log”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 28.5.3, “The DBUG Package”
Section 6.4.6, “The DDL Log”
Section 6.4.2, “The Error Log”
Section 6.4.3, “The General Query Log”
Section 15.20.6, “The InnoDB memcached Plugin and Replication”
Section 16.2, “The MyISAM Storage Engine”
Section 9.10.3, “The MySQL Query Cache”
Section 6.1, “The MySQL Server”
Section 28.1.2, “The MySQL Test Suite”
Section 21.5.10.27, “The ndbinfo operations_per_fragment Table”
Section 21.5.10.30, “The ndbinfo server_locks Table”
Section 6.4.5, “The Slow Query Log”
Section B.5.3.7, “Time Zone Problems”
Section B.5.2.7, “Too many connections”
Section 6.7, “Tracing mysqld Using DTrace”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 15.21.1, “Troubleshooting InnoDB I/O Problems”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 1.2, “Typographical and Syntax Conventions”
Section 28.4.2.5, “UDF Compiling and Installing”
Section 28.4.2.6, “UDF Security Precautions”
Section 21.2.8, “Upgrading and Downgrading NDB Cluster”
Section 2.11.1, “Upgrading MySQL”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”
Section 28.5.1.5, “Using a Stack Trace”
Section 8.6.1, “Using myisamchk for Crash Recovery”
Section 5.2.6, “Using Option Files”
Section 28.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 9.12.3.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section 21.6.7, “Using Two Replication Channels for NDB Cluster Replication”
Section 28.5.1.3, “Using WER with PDB to create a Windows crashdump”
Section 1.4, “What Is New in MySQL 5.7”
Section 21.1.4, “What is New in MySQL NDB Cluster 7.5”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”
Section 7.2.6, “When Privilege Changes Take Effect”
Section B.5.3.5, “Where MySQL Stores Temporary Files”
Section 2.1.1, “Which MySQL Version and Distribution to Install”
Section 28.2.4, “Writing Plugins”

mysqld mysqld.trace

Section 28.5.1.2, “Creating Trace Files”

mysqld-debug

Section 28.5.1.2, “Creating Trace Files”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.3.5.3, “Selecting a MySQL Server Type”

mysqld.exe

Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”

mysqld_multi

Section 2.5.10, “Managing MySQL Server with systemd”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.1, “Overview of MySQL Programs”
Section 6.6.3, “Running Multiple MySQL Instances on Unix”

mysqld_multi.server

Section 2.5.10, “Managing MySQL Server with systemd”

mysqld_safe

Section 21.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 2.11.2.1, “Changes Affecting Downgrades from MySQL 5.7”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 6.1.1, “Configuring the Server”
Section 2.11.2, “Downgrading MySQL”
Section 9.12.4.2, “Enabling Large Page Support”
Section B.5.2.18, “File Not Found and Similar Errors”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 2.10.1.2, “Initializing the Data Directory Manually Using mysql_install_db”
Section 15.21, “InnoDB Troubleshooting”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 7.1.3, “Making MySQL Secure Against Attackers”
Section 2.5.10, “Managing MySQL Server with systemd”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 11.6, “MySQL Server Time Zone Support”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.3.3, “mysql.server — MySQL Server Startup Script”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 5.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 21.5.12.3, “NDB Cluster and MySQL Security Procedures”
Section 5.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 5.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section B.5.3.1, “Problems with File Permissions”
Section 6.6, “Running Multiple MySQL Instances on One Machine”
Section 6.6.3, “Running Multiple MySQL Instances on Unix”
Section 6.1.4, “Server Command Options”
Section 6.1.2, “Server Configuration Defaults”
Section 6.1.5, “Server System Variables”
Section 2.10.5, “Starting and Stopping MySQL Automatically”
Section 2.10.2, “Starting the Server”
Section 2.10.3, “Testing the Server”
Section 6.4.2, “The Error Log”
Section B.5.3.7, “Time Zone Problems”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 2.11.1, “Upgrading MySQL”
Section 5.2.6, “Using Option Files”
Section 1.4, “What Is New in MySQL 5.7”

mysqldump

Section 18.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
Section 18.3.1.1, “Backing Up a Slave Using mysqldump”
Chapter 8, Backup and Recovery
Section 8.1, “Backup and Recovery Types”
Section 8.3.3, “Backup Strategy Summary”
Section 9.5.5, “Bulk Data Loading for InnoDB Tables”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 18.1.2.4, “Choosing a Method for Data Snapshots”
Section 5.2.2, “Connecting to the MySQL Server”
Section 1.9.1, “Contributors to MySQL”
Section 11.1.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”
Section 8.4.5.2, “Copy a Database from one Server to Another”
Section 15.7.6, “Copying File-Per-Table Tablespaces to Another Server”
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Section 14.1.18, “CREATE TABLE Syntax”
Section 18.1.2.4.1, “Creating a Data Snapshot Using mysqldump”
Section 15.8.1, “Creating InnoDB Tables”
Section 2.3.5.7, “Customizing the PATH for MySQL Tools”
Section 8.2, “Database Backup Methods”
Section 15.12.4, “Defragmenting a Table”
Section 21.5.15, “Distributed MySQL Privileges for NDB Cluster”
Section 2.11.2, “Downgrading MySQL”
Section 8.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 8.4.1, “Dumping Data in SQL Format with mysqldump”
Section 8.4.5.3, “Dumping Stored Programs”
Section 8.4.5.4, “Dumping Table Definitions and Content Separately”
Section 15.7.4.1, “Enabling and Disabling File-Per-Table Tablespaces”
Section 8.3.1, “Establishing a Backup Policy”
Section 8.3, “Example Backup and Recovery Strategy”
Section 1.7, “How to Report Bugs or Problems”
Section 10.2.2, “Identifier Case Sensitivity”
Section 5.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 15.18.1, “InnoDB Backup”
Section 2.6, “Installing MySQL Using Unbreakable Linux Network (ULN)”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 14.2.6, “LOAD DATA INFILE Syntax”
Section 14.2.7, “LOAD XML Syntax”
Section 8.4.5.1, “Making a Copy of a Database”
Section 10.2.3, “Mapping of Identifiers to File Names”
Section 15.8.4, “Moving or Copying InnoDB Tables to Another Machine”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 5.5.1.1, “mysql Options”
Section 6.4, “MySQL Server Logs”
Section 8.4.5, “mysqldump Tips”
Section 5.5.4, “mysqldump — A Database Backup Program”
Section 21.2.6, “NDB Cluster Example with Tables and Data”
Section 21.1, “NDB Cluster Overview”
Section 21.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 21.5.10, “ndbinfo: The NDB Cluster Information Database”
Section 18.1.2.3, “Obtaining the Replication Master Binary Log Coordinates”
Section 21.5.3, “Online Backup of NDB Cluster”
Section 5.1, “Overview of MySQL Programs”
Section 25.10.9, “Performance Schema Connection Attribute Tables”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 21.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 21.6.5, “Preparing the NDB Cluster for Replication”
Section B.5.4.8, “Problems with Floating-Point Values”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 8.4.4, “Reloading Delimited-Text Format Backups”
Section 8.4.2, “Reloading SQL-Format Backups”
Section 18.3.5, “Replicating Different Databases to Different Slaves”
Section 18.4.1.34, “Replication and Transaction Inconsistencies”
Section 15.7.1, “Resizing the InnoDB System Tablespace”
Section C.8, “Restrictions on Performance Schema”
Section 18.1.3.4, “Restrictions on Replication with GTIDs”
Section C.5, “Restrictions on Views”
Section 6.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 6.4.7, “Server Log Maintenance”
Section 6.1.8, “Server SQL Modes”
Section 6.1.5, “Server System Variables”
Section 18.1.2.5.4, “Setting Up Replication with Existing Data”
Section B.5.4.7, “Solving Problems with No Matching Rows”
Section 5.2.3, “Specifying Program Options”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 12.4.3, “The BLOB and TEXT Types”
Section 15.6.3.1, “The InnoDB Buffer Pool”
Section 15.20.6, “The InnoDB memcached Plugin and Replication”
Section 1.3.2, “The Main Features of MySQL”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 14.7.3.4, “UNINSTALL PLUGIN Syntax”
Section 2.11.1, “Upgrading MySQL”
Section 14.1.18.5, “Using FOREIGN KEY Constraints”
Section 18.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 5.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 8.4, “Using mysqldump for Backups”
Section 18.3.1, “Using Replication for Backups”
Section 18.3.3, “Using Replication with Different Master and Slave Storage Engines”
Section 26.2, “Using the sys Schema”
Section 1.4, “What Is New in MySQL 5.7”
Section 13.11, “XML Functions”
Section 12.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)”

mysqldump mysql

Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”

mysqldumpslow

Section 5.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 5.1, “Overview of MySQL Programs”
Section 6.4.5, “The Slow Query Log”

mysqlfailover

Section 18.3.7, “Switching Masters During Failover”

mysqlhotcopy

Section 1.9.1, “Contributors to MySQL”
Section 1.4, “What Is New in MySQL 5.7”

mysqlimport

Section 8.1, “Backup and Recovery Types”
Section 2.11.5, “Copying MySQL Databases to Another Machine”
Section 8.2, “Database Backup Methods”
Section 2.11.2, “Downgrading MySQL”
Section 14.2.6, “LOAD DATA INFILE Syntax”
Section 5.5.5, “mysqlimport — A Data Import Program”
Section 5.1, “Overview of MySQL Programs”
Section 8.4.4, “Reloading Delimited-Text Format Backups”
Section 7.1.6, “Security Issues with LOAD DATA LOCAL”

MySQLInstallerConsole

Section 2.3.3.2, “MySQL Installer Console”

MySQLInstallerConsole.exe

Section 2.3.3.2, “MySQL Installer Console”

mysqloptimize

Section 5.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlpump

Section 5.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section A.16, “MySQL 5.7 FAQ: InnoDB Tablespace Encryption”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.1, “Overview of MySQL Programs”
Section 26.2, “Using the sys Schema”
Section 5.8.5, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

mysqlrepair

Section 5.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlsh

Section 3.4.3, “MySQL Shell”
Section 3.5.3, “MySQL Shell”
Section 5.5.7, “mysqlsh — The MySQL Shell”
Section 5.1, “Overview of MySQL Programs”

mysqlshow

Section 5.2.2, “Connecting to the MySQL Server”
Section 27.8.3, “Example C API Client Programs”
Section 5.5.8, “mysqlshow — Display Database, Table, and Column Information”
Section 5.1, “Overview of MySQL Programs”
Section 14.7.5.14, “SHOW DATABASES Syntax”
Section 14.7.5.22, “SHOW INDEX Syntax”
Section 14.7.5.36, “SHOW TABLE STATUS Syntax”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.10.3, “Testing the Server”
Section 2.3.7, “Windows Postinstallation Procedures”

mysqlshow db_name

Section 14.7.5.37, “SHOW TABLES Syntax”

mysqlshow db_name tbl_name

Section 14.7.5.5, “SHOW COLUMNS Syntax”

mysqlslap

Section 15.16.2, “Monitoring InnoDB Mutex Waits Using Performance Schema”
Section 5.5.9, “mysqlslap — Load Emulation Client”
Section 5.1, “Overview of MySQL Programs”
Section 7.5.1.8, “The Cleartext Client-Side Authentication Plugin”
Section 9.13.2, “Using Your Own Benchmarks”

mysqltest

Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 28.1.2, “The MySQL Test Suite”
Section 7.5.1.4, “The SHA-256 Authentication Plugin”
Section 1.4, “What Is New in MySQL 5.7”

mysqltest_embedded

Section 1.4, “What Is New in MySQL 5.7”

N

[index top]

nbdmtd

Section 21.3.3.6, “Defining NDB Cluster Data Nodes”

NDB

Section 21.3.3.12, “SCI Transport Connections in NDB Cluster”

ndb_blob_tool

Section 21.4.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”

ndb_config

Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 21.4, “NDB Cluster Programs”
Section 21.4.7, “ndb_config — Extract NDB Cluster Configuration Information”
Section 21.3.3.12, “SCI Transport Connections in NDB Cluster”

ndb_cpcd

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

ndb_delete_all

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

ndb_desc

Section 21.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 22.2.5, “KEY Partitioning”
Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 21.5.12.3, “NDB Cluster and MySQL Security Procedures”
Section 21.5.13.1, “NDB Cluster Disk Data Objects”
Section 21.4.10, “ndb_desc — Describe NDB Tables”
Section 14.1.18.9, “Setting NDB_TABLE Options in Table Comments”
Section 24.8, “The INFORMATION_SCHEMA FILES Table”
Section 21.5.10.5, “The ndbinfo cluster_operations Table”
Section 21.5.10.31, “The ndbinfo server_operations Table”

ndb_drop_index

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

ndb_drop_table

Section 21.4.11, “ndb_drop_index — Drop Index from an NDB Table”
Section 21.4.12, “ndb_drop_table — Drop an NDB Table”

ndb_error_reporter

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

ndb_index_stat

Section 21.4.14, “ndb_index_stat — NDB Index Statistics Utility”

ndb_mgm

Section 21.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 21.5.14.1, “Adding NDB Cluster Data Nodes Online: General Issues”
Section 21.2.2.4, “Building NDB Cluster from Source on Linux”
Section 21.5.2, “Commands in the NDB Cluster Management Client”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.5.15, “Distributed MySQL Privileges for NDB Cluster”
Section 21.2.5, “Initial Startup of NDB Cluster”
Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.2, “Installation of NDB Cluster on Linux”
Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 21.2.2.3, “Installing NDB Cluster Using .deb Files”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Chapter 21, MySQL NDB Cluster 7.5
Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 21.1.1, “NDB Cluster Core Concepts”
Section 21.5.6.1, “NDB Cluster Logging Management Commands”
Section 21.4, “NDB Cluster Programs”
Section 21.5.12.1, “NDB Cluster Security and Networking Issues”
Section 21.5.8, “NDB Cluster Single User Mode”
Section 21.4.5, “ndb_mgm — The NDB Cluster Management Client”
Section 21.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 21.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 21.5.3, “Online Backup of NDB Cluster”
Section 21.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 21.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 21.2.7, “Safe Shutdown and Restart of NDB Cluster”
Section 21.5.10.1, “The ndbinfo arbitrator_validity_detail Table”
Section 21.5.10.23, “The ndbinfo membership Table”
Section 21.5.10.24, “The ndbinfo memoryusage Table”
Section 21.5.10.26, “The ndbinfo nodes Table”
Section 21.5.10.41, “The ndbinfo transporters Table”
Section 21.5.3.2, “Using The NDB Cluster Management Client to Create a Backup”
Section 21.1.4, “What is New in MySQL NDB Cluster 7.5”

ndb_mgm.exe

Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”

ndb_mgmd

Section 21.2.2.4, “Building NDB Cluster from Source on Linux”
Section 21.5.2, “Commands in the NDB Cluster Management Client”
Section 21.3.3.5, “Defining an NDB Cluster Management Server”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.2.5, “Initial Startup of NDB Cluster”
Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.2, “Installation of NDB Cluster on Linux”
Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 21.2.2.3, “Installing NDB Cluster Using .deb Files”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 21.2.1.3.5, “NDB Cluster Auto-Installer Define Processes Screen”
Section 21.3.3.1, “NDB Cluster Configuration: Basic Example”
Section 21.3.3.3, “NDB Cluster Connection Strings”
Section 21.1.1, “NDB Cluster Core Concepts”
Section 21.5.6.1, “NDB Cluster Logging Management Commands”
Section 21.1.2, “NDB Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 21.4, “NDB Cluster Programs”
Section 21.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 21.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 21.3.1, “Quick Test Setup of NDB Cluster”
Section 21.2.7, “Safe Shutdown and Restart of NDB Cluster”
Section 21.5.1, “Summary of NDB Cluster Start Phases”

ndb_mgmd.exe

Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”

ndb_print_backup_file

Section 21.4.15, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 21.4.17, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 21.4.18, “ndb_print_sys_file — Print NDB System File Contents”
Section 21.4.19, “ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 21.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”

ndb_print_file

Section 21.4.16, “ndb_print_file — Print NDB Disk Data File Contents”

ndb_print_schema_file

Section 21.4.15, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 21.4.16, “ndb_print_file — Print NDB Disk Data File Contents”
Section 21.4.17, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 21.4.18, “ndb_print_sys_file — Print NDB System File Contents”
Section 21.4.19, “ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 21.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”

ndb_print_sys_file

Section 21.4.15, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 21.4.16, “ndb_print_file — Print NDB Disk Data File Contents”
Section 21.4.17, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 21.4.18, “ndb_print_sys_file — Print NDB System File Contents”
Section 21.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”

ndb_restore

Section 8.1, “Backup and Recovery Types”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.5.15, “Distributed MySQL Privileges for NDB Cluster”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 21.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 21.1.1, “NDB Cluster Core Concepts”
Section 21.1, “NDB Cluster Overview”
Section 21.4, “NDB Cluster Programs”
Section 21.6.4, “NDB Cluster Replication Schema and Tables”
Section 21.6.10, “NDB Cluster Replication: Multi-Master and Circular Replication”
Section 21.5.8, “NDB Cluster Single User Mode”
Section 21.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 21.5.3, “Online Backup of NDB Cluster”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 21.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 21.1.4, “What is New in MySQL NDB Cluster 7.5”

ndb_select_all

Section 21.5.12.3, “NDB Cluster and MySQL Security Procedures”
Section 21.4.21, “ndb_select_all — Print Rows from an NDB Table”
Section 21.4.24, “ndb_show_tables — Display List of NDB Tables”

ndb_select_count

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

ndb_setup.py

Section 21.2.1.2, “NDB Cluster Auto-Installer Overview”
Section 21.2.1.1, “NDB Cluster Auto-Installer Requirements”
Section 21.2.1.3.2, “NDB Cluster Auto-Installer Welcome Screen”
Section 21.4, “NDB Cluster Programs”
Section 21.4.23, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster ”
Section 21.2.1.3.1, “Starting the NDB Cluster Auto-Installer”

ndb_show_tables

Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 21.5.12.3, “NDB Cluster and MySQL Security Procedures”
Section 21.4, “NDB Cluster Programs”
Section 21.6.4, “NDB Cluster Replication Schema and Tables”
Section 21.4.24, “ndb_show_tables — Display List of NDB Tables”
Section 21.5.10.4, “The ndbinfo cluster_locks Table”
Section 21.5.10.5, “The ndbinfo cluster_operations Table”
Section 21.5.10.20, “The ndbinfo locks_per_fragment Table”
Section 21.5.10.27, “The ndbinfo operations_per_fragment Table”
Section 21.5.10.30, “The ndbinfo server_locks Table”
Section 21.5.10.31, “The ndbinfo server_operations Table”

ndb_size.pl

Section 12.8, “Data Type Storage Requirements”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 21.4.25, “ndb_size.pl — NDBCLUSTER Size Requirement Estimator”

ndb_waiter

Section 21.4.26, “ndb_waiter — Wait for NDB Cluster to Reach a Given Status”

ndbd

Section 21.5.14.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 21.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 21.2.2.4, “Building NDB Cluster from Source on Linux”
Section 21.5.2, “Commands in the NDB Cluster Management Client”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.2.5, “Initial Startup of NDB Cluster”
Section 21.2.2, “Installation of NDB Cluster on Linux”
Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section 21.2.2.3, “Installing NDB Cluster Using .deb Files”
Section 21.5, “Management of NDB Cluster”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 21.3.3.8.1, “MySQL Server Options for NDB Cluster”
Section 21.2.1.3.5, “NDB Cluster Auto-Installer Define Processes Screen”
Section 21.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 21.3.3.1, “NDB Cluster Configuration: Basic Example”
Section 21.1.1, “NDB Cluster Core Concepts”
Section 21.3.2.1, “NDB Cluster Data Node Configuration Parameters”
Section 21.2, “NDB Cluster Installation”
Section 21.1.2, “NDB Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 21.4, “NDB Cluster Programs”
Section 21.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 21.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 21.4.26, “ndb_waiter — Wait for NDB Cluster to Reach a Given Status”
Section 21.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 21.4.3, “ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)”
Section 21.3.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 21.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 21.3.1, “Quick Test Setup of NDB Cluster”
Section 21.3.3.2, “Recommended Starting Configuration for NDB Cluster”
Section 21.2.7, “Safe Shutdown and Restart of NDB Cluster”
Section 21.3.3.12, “SCI Transport Connections in NDB Cluster”
Section 21.5.1, “Summary of NDB Cluster Start Phases”
Section 21.5.10.26, “The ndbinfo nodes Table”
Section 21.5.6.3, “Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client”
Section 21.3.4, “Using High-Speed Interconnects with NDB Cluster”

ndbd.exe

Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”

ndbd_redo_log_reader

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

ndbinfo_select_all

Section 21.4.2, “ndbinfo_select_all — Select From ndbinfo Tables”

ndbmtd

Section 21.5.14.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 21.5.14.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 21.2.2.4, “Building NDB Cluster from Source on Linux”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 21.2.2, “Installation of NDB Cluster on Linux”
Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 21.2.2.2, “Installing NDB Cluster from RPM”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 21.2.1.3.5, “NDB Cluster Auto-Installer Define Processes Screen”
Section 21.1.1, “NDB Cluster Core Concepts”
Section 21.3.2.1, “NDB Cluster Data Node Configuration Parameters”
Section 21.1.2, “NDB Cluster Nodes, Node Groups, Replicas, and Partitions”
Section 21.4, “NDB Cluster Programs”
Section 21.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 21.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 21.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 21.4.3, “ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)”
Section 21.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 21.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 21.3.3.2, “Recommended Starting Configuration for NDB Cluster”
Section 21.2.7, “Safe Shutdown and Restart of NDB Cluster”
Section 21.5.10.26, “The ndbinfo nodes Table”
Section 21.5.10.28, “The ndbinfo resources Table”
Section 21.1.4, “What is New in MySQL NDB Cluster 7.5”

ndbmtd.exe

Section 21.2.3.3, “Initial Startup of NDB Cluster on Windows”
Section 21.2.3.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”

NET

Section 2.3.5.8, “Starting MySQL as a Windows Service”

NET START

Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”
Section 6.6.2.2, “Starting Multiple MySQL Instances as Windows Services”

net start

Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”

NET START MySQL

Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 2.3.8, “Upgrading MySQL on Windows”

NET STOP

Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”
Section 6.6.2.2, “Starting Multiple MySQL Instances as Windows Services”

net stop

Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”

NET STOP MYSQL

Section 21.2.7, “Safe Shutdown and Restart of NDB Cluster”

NET STOP MySQL

Section 2.3.5.8, “Starting MySQL as a Windows Service”

nm

Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 28.5.1.5, “Using a Stack Trace”

numactl

Section 21.3.3.6, “Defining NDB Cluster Data Nodes”

O

[index top]

openssl

Section 7.4.6.3, “Creating RSA Keys Using openssl”
Section 7.4.6, “Creating SSL and RSA Certificates and Keys”
Section 7.4.6.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 7.4.6.2, “Creating SSL Certificates and Keys Using openssl”
Section 5.4.5, “mysql_ssl_rsa_setup — Create SSL/RSA Files”

openssl md5 package_name

Section 2.1.3.1, “Verifying the MD5 Checksum”

openssl zlib

Section 5.5.6, “mysqlpump — A Database Backup Program”

otool

Section 27.8.4.1, “Building C API Client Programs”

P

[index top]

perf

Section 25.10.16.3, “The threads Table”

perror

Section B.5.2.13, “Can't create/write to file”
Section B.5.2.18, “File Not Found and Similar Errors”
Section 8.6.3, “How to Repair MyISAM Tables”
Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”
Section 5.1, “Overview of MySQL Programs”
Section 5.8.2, “perror — Explain Error Codes”
Section B.1, “Sources of Error Information”

pfexec

Section 2.7.2, “Installing MySQL on OpenSolaris Using IPS”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

PGP

Section 2.1.3.2, “Signature Checking Using GnuPG”

ping6

Section 6.1.9.5, “Obtaining an IPv6 Address from a Broker”

pkg

Section 2.7.2, “Installing MySQL on OpenSolaris Using IPS”

pkg-config

Section 27.8.4.1, “Building C API Client Programs”
Section 27.8.4.2, “Building C API Client Programs Using pkg-config”
Section 5.9, “MySQL Program Environment Variables”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.7.1, “mysql_config — Display Options for Compiling Clients”

pkgadd

Section 2.7.1, “Installing MySQL on Solaris Using a Solaris PKG”

pkgrm

Section 2.7.1, “Installing MySQL on Solaris Using a Solaris PKG”

ppm

Section 2.12, “Perl Installation Notes”

ps

Section 7.1.2.1, “End-User Guidelines for Password Security”
Section 9.12.4.1, “How MySQL Uses Memory”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 25.10.16.3, “The threads Table”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”

ps auxw

Section 5.2.2, “Connecting to the MySQL Server”

ps xa | grep mysqld

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

R

[index top]

rename

Section 6.4.7, “Server Log Maintenance”
Section 6.4.2, “The Error Log”
Section 6.4.3, “The General Query Log”

replace

Section 5.1, “Overview of MySQL Programs”
Section 5.8.3, “replace — A String-Replacement Utility”
Section 18.3.4, “Using Replication for Scale-Out”
Section 1.4, “What Is New in MySQL 5.7”

resolve_stack_dump

Section 5.1, “Overview of MySQL Programs”
Section 5.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 28.5.1.5, “Using a Stack Trace”

resolveip

Section 5.1, “Overview of MySQL Programs”
Section 5.8.4, “resolveip — Resolve Host name to IP Address or Vice Versa”

restart

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”

rm

Section 14.4.1.1, “PURGE BINARY LOGS Syntax”

rpm

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.9.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.1.3.4, “Signature Checking Using RPM”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”

rpmbuild

Section 2.9, “Installing MySQL from Source”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.9.2, “Installing MySQL Using a Standard Source Distribution”

rsync

Section 18.1.2.6, “Adding Slaves to a Replication Environment”
Section 8.1, “Backup and Recovery Types”
Section 18.1.2.4.2, “Creating a Data Snapshot Using Raw Data Files”

S

[index top]

scp

Section 8.1, “Backup and Recovery Types”
Section 18.1.2.4.2, “Creating a Data Snapshot Using Raw Data Files”

sed

Section 4.3.4.7, “Pattern Matching”

SELECT

Section 21.2.6, “NDB Cluster Example with Tables and Data”

semanage port

Section 19.8, “Frequently Asked Questions”

service

Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.10, “Managing MySQL Server with systemd”

Service Control Manager

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

Services

Section 21.2.3.4, “Installing NDB Cluster Processes as Windows Services”
Section 2.3.5.8, “Starting MySQL as a Windows Service”

sestatus

Section 19.8, “Frequently Asked Questions”

setenv

Section 5.2.10, “Setting Environment Variables”

setrlimit

Section 17.2.2.1, “memcached Command-Line Options”
Section 17.2.2, “Using memcached

setup.bat

Section 21.2.1.3.1, “Starting the NDB Cluster Auto-Installer”

sh

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

SHOW

Section 21.4.20, “ndb_restore — Restore an NDB Cluster Backup”
Section 21.3.1, “Quick Test Setup of NDB Cluster”

SHOW ERRORS

Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”

SHOW WARNINGS

Section A.10, “MySQL 5.7 FAQ: MySQL Cluster”

sleep

Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”

ssh

Section 21.5.12.1, “NDB Cluster Security and Networking Issues”
Section 17.1.1, “Using ZFS for File System Replication”

start

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”

Start>Run>cmd.exe

Section 7.4.6.2, “Creating SSL Certificates and Keys Using openssl”

status

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”

stop

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”

strings

Section 7.1.1, “Security Guidelines”

su root

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”

sudo

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 5.4.2, “mysql_install_db — Initialize MySQL Data Directory”

System Preferences...

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

systemctl

Section 2.5.10, “Managing MySQL Server with systemd”

T

[index top]

tar

Section 18.1.2.6, “Adding Slaves to a Replication Environment”
Section 18.3.1.2, “Backing Up Raw Data from a Slave”
Section 8.1, “Backup and Recovery Types”
Section 18.1.2.4.2, “Creating a Data Snapshot Using Raw Data Files”
Section 4.3, “Creating and Using a Database”
Section 1.7, “How to Report Bugs or Problems”
Section 2.9, “Installing MySQL from Source”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.4, “Installing MySQL on OS X”
Section 2.7, “Installing MySQL on Solaris and OpenSolaris”
Section 2.7.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 21.2.2.2, “Installing NDB Cluster from RPM”
Section 2.12.1, “Installing Perl on Unix”
Section 27.8.2, “Simultaneous MySQL Server and Connector/C Installations”
Section 2.1.1, “Which MySQL Version and Distribution to Install”

tcpdump

Section 7.1.1, “Security Guidelines”

tcsh

Section B.5.2.18, “File Not Found and Similar Errors”
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section 5.2.1, “Invoking MySQL Programs”
Section 5.2.10, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

tee

Section 5.5.1.2, “mysql Commands”

Telnet

Section 17.2.4, “Getting memcached Statistics”

telnet

Section 17.2.4, “Getting memcached Statistics”
Section 15.20.2, “InnoDB memcached Architecture”
Section 7.1.1, “Security Guidelines”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”

Terminal

Section 2.4, “Installing MySQL on OS X”

Text in this style

Section 1.2, “Typographical and Syntax Conventions”

top

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

U

[index top]

ulimit

Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 9.12.4.2, “Enabling Large Page Support”
Section B.5.2.18, “File Not Found and Similar Errors”
Section 17.2.2.1, “memcached Command-Line Options”
Section 5.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 21.4.27, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section B.5.2.10, “Packet Too Large”
Section 6.1.4, “Server Command Options”

update-rc.d

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”

useradd

Section 21.2.2.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.7, “Installing MySQL on Solaris and OpenSolaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

V

[index top]

vi

Section 21.2.4, “Initial Configuration of NDB Cluster”
Section 5.5.1.2, “mysql Commands”
Section 4.3.4.7, “Pattern Matching”

vmstat

Section 17.2.2.1, “memcached Command-Line Options”

W

[index top]

watch

Section 26.4.4.25, “The statement_performance_analyzer() Procedure”

WinDbg

Section 28.5.1.3, “Using WER with PDB to create a Windows crashdump”

windbg.exe

Section 28.5.1.3, “Using WER with PDB to create a Windows crashdump”

winMd5Sum

Section 2.1.3.1, “Verifying the MD5 Checksum”

WinZip

Section 18.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 14.2.6, “LOAD DATA INFILE Syntax”

Y

[index top]

yacc

Section 2.9.5, “Dealing with Problems Compiling MySQL”
Section 10.3, “Keywords and Reserved Words”

yum

Section 17.2.1, “Installing memcached
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”
Section 2.11.1.2, “Upgrading MySQL with the MySQL Yum Repository”
Section 17.2.3.3, “Using libmemcached with C and C++”

yum install

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”

yum update

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”

yum update mysql-server

Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”

yum-config-manager

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”

Z

[index top]

zfs recv

Section 17.1.1, “Using ZFS for File System Replication”

zip

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

zlib_decompress

Section 5.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section 5.5.6, “mysqlpump — A Database Backup Program”
Section 5.1, “Overview of MySQL Programs”
Section 5.8.5, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

zsh

Section 5.2.10, “Setting Environment Variables”

zypper

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.11.1.4, “Upgrading MySQL with Directly-Downloaded RPM Packages”