Command Index

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

A

[index top]

Access

Section 13.2.2, “DELETE Statement”

addgroup

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

addr2line

Section 5.9.1.5, “Using a Stack Trace”

adduser

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

ant

Section 2.9.7, “MySQL Source-Configuration Options”

APF

Section 23.5.17.1, “NDB Cluster Security and Networking Issues”

apt-get

Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.5, “Installing MySQL on Linux Using Debian Packages from Oracle”
Section 15.20.5, “Security Considerations for the InnoDB memcached Plugin”

audit2allow

Section 6.7.6, “Troubleshooting SELinux”

B

[index top]

bash

Section 1.1, “About This Manual”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 2.4.1, “General Notes on Installing MySQL on macOS”
Section 4.2.1, “Invoking MySQL Programs”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 13.7.8.8, “RESTART Statement”
Section 4.2.9, “Setting Environment Variables”

bison

Section 1.8.1, “Contributors to MySQL”
Section 2.9.8, “Dealing with Problems Compiling MySQL”
Section 2.9.2, “Source Installation Prerequisites”

C

[index top]

cat

Section 15.14, “InnoDB Startup Options and System Variables”
Section 4.5.1.1, “mysql Client Options”

cd

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

chkconfig

Section 23.2.1.1, “Installing an NDB Cluster Binary Release on Linux”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”

CMake

Section 10.13, “Adding a Character Set”
Section 23.2.1.4, “Building NDB Cluster from Source on Linux”
Section B.3.2.15, “Can't initialize character set”
Section 23.2.2.2, “Compiling and Installing NDB Cluster from Source on Windows”
Section 10.5, “Configuring Application Character Set and Collation”
Section 2.9.6, “Configuring SSL Library Support”
Section 14.1, “Data Dictionary Schema”
Section 2.9.8, “Dealing with Problems Compiling MySQL”
Section 4.9, “Environment Variables”
Section B.3.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 2.9.5, “Installing MySQL Using a Development Source Tree”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 6.4.4.13, “Keyring System Variables”
Section 2.5.9, “Managing MySQL Server with systemd”
Chapter 23, MySQL NDB Cluster 8.0
Section 23.5.9, “MySQL Server Usage for NDB Cluster”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 27.2, “Performance Schema Build Configuration”
Section 5.8.3, “Running Multiple MySQL Instances on Unix”
Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”
Section 10.3.2, “Server Character Set and Collation”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 2.9.2, “Source Installation Prerequisites”
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 5.9.3, “The LOCK_ORDER Tool”
Section 1.2.2, “The Main Features of MySQL”
Section 27.12.19.9, “The processlist Table”
Section 4.2.2.2, “Using Option Files”
Section 1.3, “What Is New in MySQL 8.0”
Section B.3.3.3, “What to Do If MySQL Keeps Crashing”

cmake

Section 2.9.10, “Generating MySQL Doxygen Documentation Content”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 15.20.5, “Security Considerations for the InnoDB memcached Plugin”

cmd

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

cmd.exe

Section 1.1, “About This Manual”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 4.2.1, “Invoking MySQL Programs”

command.com

Section 1.1, “About This Manual”
Section 4.2.1, “Invoking MySQL Programs”

comp_err

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

configure

Section 1.1, “About This Manual”
Section 1.6, “How to Report Bugs or Problems”
Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”

copy

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

coreadm

Section 2.7, “Installing MySQL on Solaris”
Section 5.1.7, “Server Command Options”

cp

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 17.4.1.2, “Backing Up Raw Data from a Replica”
Section 7.1, “Backup and Recovery Types”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”

cron

Section B.3.2.2, “Can't connect to [local] MySQL server”
Section 13.7.3.2, “CHECK TABLE Statement”
Section 16.2.1, “MyISAM Startup Options”
Section 5.4.6, “Server Log Maintenance”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 3.5, “Using mysql in Batch Mode”

csh

Section 1.1, “About This Manual”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.9, “Setting Environment Variables”

curl

Section 2.9.7, “MySQL Source-Configuration Options”

D

[index top]

daemon_memcached

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

date

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

df

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

dig

Section 1.3, “What Is New in MySQL 8.0”

Directory Utility

Section 2.4.1, “General Notes on Installing MySQL on macOS”

dnf

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 2.11.7, “Upgrading MySQL with the MySQL Yum Repository”

dnf config-manager

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

dnf upgrade

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

docker exec

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”

docker images

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”

docker inspect

Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”

docker logs mysqld-container

Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”

docker ps

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”

docker pull

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”
Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”

docker rm

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”

docker run

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”
Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”

docker stop

Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”

dot

Section 2.9.10, “Generating MySQL Doxygen Documentation Content”

doxygen

Section 2.9.10, “Generating MySQL Doxygen Documentation Content”

dpkg

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

dump

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

F

[index top]

flex

Section 2.9.7, “MySQL Source-Configuration Options”
Section 5.9.3, “The LOCK_ORDER Tool”

G

[index top]

gcc

Section 2.13.3, “Problems Using the Perl DBI/DBD Interface”
Section 1.8.4, “Tools that were used to create MySQL”

gdb

Section 5.9.1.1, “Compiling MySQL for Debugging”
Section 5.9.1.4, “Debugging mysqld under gdb”
Section 1.8.4, “Tools that were used to create MySQL”
Section B.3.3.3, “What to Do If MySQL Keeps Crashing”

getcap

Section 5.1.16, “Resource Groups”

getenforce

Section 6.7.2, “Changing the SELinux Mode”

git branch

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

git checkout

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

gmake

Section 2.8, “Installing MySQL on FreeBSD”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 2.9.2, “Source Installation Prerequisites”

GnuPG

Section 2.1.4.2, “Signature Checking Using GnuPG”

gnutar

Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.9.2, “Source Installation Prerequisites”

gogoc

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

gold

Section 2.9.7, “MySQL Source-Configuration Options”

gpg

Section 2.1.4.2, “Signature Checking Using GnuPG”

grep

Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 3.3.4.7, “Pattern Matching”

groupadd

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

gtar

Section 2.7, “Installing MySQL on Solaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.9.2, “Source Installation Prerequisites”

gunzip

Section 6.4.5.5, “Configuring Audit Logging Characteristics”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”

gzip

Section 6.4.5.5, “Configuring Audit Logging Characteristics”
Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section 1.6, “How to Report Bugs or Problems”
Section 2.4, “Installing MySQL on macOS”

H

[index top]

help contents

Section 4.5.1.4, “mysql Client Server-Side Help”

host

Section 1.3, “What Is New in MySQL 8.0”

hostname

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

I

[index top]

ibd2sdi

Section 4.6.1, “ibd2sdi — InnoDB Tablespace SDI Extraction Utility”
MySQL Glossary
Section 14.6, “Serialized Dictionary Information (SDI)”
Section 1.3, “What Is New in MySQL 8.0”

icc

Section 2.1.6, “Compiler-Specific Build Characteristics”

ifconfig

Section 5.1.13.1, “Verifying System Support for IPv6”

innochecksum

Section 13.7.3.2, “CHECK TABLE Statement”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
MySQL Glossary
Section 4.1, “Overview of MySQL Programs”

ip

Section 5.1.14, “Network Namespace Support”

iptables

Section 18.10, “Frequently Asked Questions”
Section 23.5.17.1, “NDB Cluster Security and Networking Issues”

J

[index top]

java

Section 6.4.4.4, “Using the keyring_okv KMIP Plugin”

K

[index top]

kill

Section B.3.2.2, “Can't connect to [local] MySQL server”
Section 23.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 4.10, “Unix Signal Handling in MySQL”

kinit

Section 6.4.1.7, “LDAP Pluggable Authentication”

klist

Section 6.4.1.7, “LDAP Pluggable Authentication”

ksh

Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.9, “Setting Environment Variables”

kswapd

Section 23.3.3.6, “Defining NDB Cluster Data Nodes”

kswitch

Section 6.4.1.7, “LDAP Pluggable Authentication”

L

[index top]

ldapsearch

Section 6.4.1.7, “LDAP Pluggable Authentication”

ldd mysqld

Section 2.8, “Installing MySQL on FreeBSD”

less

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

lld

Section 2.9.7, “MySQL Source-Configuration Options”

llvm

Section 2.9.7, “MySQL Source-Configuration Options”

ln

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

logger

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

ls

Section 6.7, “SELinux”

lsof +L1

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

lz4

Section 4.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 4.5.6, “mysqlpump — A Database Backup Program”

lz4_decompress

Section 4.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.3, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

M

[index top]

m4

Section 2.9.2, “Source Installation Prerequisites”

make

Section 2.9.8, “Dealing with Problems Compiling MySQL”
Section 2.8, “Installing MySQL on FreeBSD”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 2.13.3, “Problems Using the Perl DBI/DBD Interface”
Section 2.9.2, “Source Installation Prerequisites”

make && make install

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

make install

Section 23.2.1.4, “Building NDB Cluster from Source on Linux”
Section 2.9.7, “MySQL Source-Configuration Options”

make package

Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 2.9.7, “MySQL Source-Configuration Options”

make test

Section 2.9.5, “Installing MySQL Using a Development Source Tree”
Section 2.13.1, “Installing Perl on Unix”

make VERBOSE=1

Section 2.9.8, “Dealing with Problems Compiling MySQL”

md5

Section 2.1.4.1, “Verifying the MD5 Checksum”

md5.exe

Section 2.1.4.1, “Verifying the MD5 Checksum”

md5sum

Section 2.1.4.1, “Verifying the MD5 Checksum”

memcached

Section 15.20.6.2, “Adapting a memcached Application for the InnoDB memcached Plugin”
Section 15.20.6.1, “Adapting an Existing MySQL Schema for the InnoDB memcached Plugin”
Section 15.20.6.5, “Adapting DML Statements to memcached Operations”
Section 15.20.1, “Benefits of the InnoDB memcached Plugin”
Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.20.4, “InnoDB memcached Multiple get and Range Query Support”
Section 15.20, “InnoDB memcached Plugin”
Section 15.20.8, “InnoDB memcached Plugin Internals”
Section 15.14, “InnoDB Startup Options and System Variables”
MySQL Glossary
Section 2.9.7, “MySQL Source-Configuration Options”
Section 15.20.6.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 15.20.5, “Security Considerations for the InnoDB memcached Plugin”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”
Section 15.20.9, “Troubleshooting the InnoDB memcached Plugin”
Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”
Section 1.3, “What Is New in MySQL 8.0”
Section 15.20.6, “Writing Applications for the InnoDB memcached Plugin”

memcapable

Section 15.20.2, “InnoDB memcached Architecture”

memcat

Section 15.20.2, “InnoDB memcached Architecture”

memcp

Section 15.20.2, “InnoDB memcached Architecture”

memflush

Section 15.20.2, “InnoDB memcached Architecture”

memrm

Section 15.20.2, “InnoDB memcached Architecture”

memslap

Section 15.20.6.3, “Tuning InnoDB memcached Plugin Performance”

mgmd

Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2, “NDB Cluster Installation”
Section 23.1.4, “What is New in NDB Cluster”

mkdir

Section 13.1.12, “CREATE DATABASE Statement”
Section 14.8, “Data Dictionary Limitations”

mklink

Section 8.12.2.3, “Using Symbolic Links for Databases on Windows”

more

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

mv

Section 5.4.2.10, “Error Log File Flushing and Renaming”
Section 5.4.6, “Server Log Maintenance”
Section 5.4.3, “The General Query Log”
Section 8.12.2.1, “Using Symbolic Links for Databases on Unix”

my_print_defaults

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

myisam_ftdump

Section 12.10, “Full-Text Search Functions”
Section 4.6.3, “myisam_ftdump — Display Full-Text Index information”
Section 4.1, “Overview of MySQL Programs”

myisamchk

Section 13.7.3.1, “ANALYZE TABLE Statement”
Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 13.7.3.2, “CHECK TABLE Statement”
Section 16.2.3.3, “Compressed Table Characteristics”
Section 16.2.4.1, “Corrupted MyISAM Tables”
Section 7.2, “Database Backup Methods”
Section 5.9.1, “Debugging a MySQL Server”
Section 13.2.2, “DELETE Statement”
Section 16.2.3.2, “Dynamic Table Characteristics”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.11.5, “External Locking”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 8.3.8, “InnoDB and MyISAM Index Statistics Collection”
Section 8.4.6, “Limits on Table Size”
Section 13.7.8.5, “LOAD INDEX INTO CACHE Statement”
Section 5.9.1.7, “Making a Test Case If You Experience Table Corruption”
Section 16.2.1, “MyISAM Startup Options”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 7.6.4, “MyISAM Table Optimization”
Section 16.2.3, “MyISAM Table Storage Formats”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.4.6, “myisamchk Memory Usage”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.4, “myisamchk — MyISAM Table-Maintenance Utility”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.4.5, “Obtaining Table Information with myisamchk”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 4.6.4.4, “Other myisamchk Options”
Section 4.1, “Overview of MySQL Programs”
Section 16.2.4.2, “Problems from Tables Not Being Closed Properly”
Section 13.7.3.5, “REPAIR TABLE Statement”
Section 5.1.8, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.7.7.22, “SHOW INDEX Statement”
Section 13.7.7.38, “SHOW TABLE STATUS Statement”
Section 16.2.3.1, “Static (Fixed-Length) Table Characteristics”
Section 26.34, “The INFORMATION_SCHEMA STATISTICS Table”
Section 26.38, “The INFORMATION_SCHEMA TABLES Table”
Section 1.2.2, “The Main Features of MySQL”
Section 16.2, “The MyISAM Storage Engine”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 5.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.12.2.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.3.3.3, “What to Do If MySQL Keeps Crashing”

myisamchk *.MYI

Section 7.6.3, “How to Repair MyISAM Tables”

myisamchk tbl_name

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

myisamlog

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

myisampack

Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 16.2.3.3, “Compressed Table Characteristics”
Section 13.1.20, “CREATE TABLE Statement”
Section 8.11.5, “External Locking”
Section 8.4.6, “Limits on Table Size”
Section 16.7.1, “MERGE Table Advantages and Disadvantages”
Section 16.2.3, “MyISAM Table Storage Formats”
Section 4.6.4.3, “myisamchk Repair Options”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.4.5, “Obtaining Table Information with myisamchk”
Section 8.4.1, “Optimizing Data Size”
Section 4.1, “Overview of MySQL Programs”
Section 13.1.20.7, “Silent Column Specification Changes”
Section 16.7, “The MERGE Storage Engine”
Section 16.2, “The MyISAM Storage Engine”

mysql

Section 1.7.2.4, “'--' as the Start of a Comment”
Section 1.1, “About This Manual”
Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 17.1.5.4, “Adding Binary Log Based Replication Sources to a Multi-Source Replica”
Section 17.1.5.3, “Adding GTID-Based Sources to a Multi-Source Replica”
Section 23.5.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 23.5.7.1, “Adding NDB Cluster Data Nodes Online: General Issues”
Section 7.1, “Backup and Recovery Types”
Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”
Section 13.6.1, “BEGIN ... END Compound Statement”
Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 2.11.4, “Changes in MySQL 8.0”
Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”
Section 23.5.1, “Commands in the NDB Cluster Management Client”
Section 9.7, “Comments”
Section 23.3, “Configuration of NDB Cluster”
Section 10.5, “Configuring Application Character Set and Collation”
Section 17.1.5.1, “Configuring Multi-Source Replication”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 4.2.6, “Connecting to the Server Using DNS SRV Records”
Section 4.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”
Section 5.1.13.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.13.3, “Connecting Using the IPv6 Local Host Address”
Section 10.4, “Connection Character Sets and Collations”
Section 4.2.8, “Connection Compression Control”
Section 4.2.7, “Connection Transport Protocols”
Section 1.8.1, “Contributors to MySQL”
Section 15.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 2.11.14, “Copying MySQL Databases to Another Machine”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 3.3.1, “Creating and Selecting a Database”
Section 2.3.4.7, “Customizing the PATH for MySQL Tools”
Section 14.1, “Data Dictionary Schema”
Section 5.9.2, “Debugging a MySQL Client”
Section 23.3.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”
Section 25.1, “Defining Stored Programs”
Section 23.5.12, “Distributed MySQL Privileges with NDB_STORED_USER”
Section 15.17.2, “Enabling InnoDB Monitors”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 3.2, “Entering Queries”
Section 4.9, “Environment Variables”
Section B.2, “Error Information Interfaces”
Section B.1, “Error Message Sources and Elements”
Section 23.5.2.3, “Event Buffer Reporting in the Cluster Log”
Section 25.4.2, “Event Scheduler Configuration”
Section 7.3, “Example Backup and Recovery Strategy”
Section 3.6, “Examples of Common Queries”
Section 24.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Chapter 12, Functions and Operators
Section 12.18.3, “Functions That Search JSON Values”
Section 2.4.1, “General Notes on Installing MySQL on macOS”
Section 13.6.7.3, “GET DIAGNOSTICS Statement”
Section 13.7.1.6, “GRANT Statement”
Section 13.8.3, “HELP Statement”
Section B.3.1, “How to Determine What Is Causing a Problem”
Section 15.7.5.3, “How to Minimize and Handle Deadlocks”
Section 1.6, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 13.2.5, “IMPORT TABLE Statement”
Section 12.16, “Information Functions”
Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 15.18.2, “InnoDB Recovery”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 4.2.1, “Invoking MySQL Programs”
Section 23.1.7.8, “Issues Exclusive to NDB Cluster”
Section 6.4.1.7, “LDAP Pluggable Authentication”
Section 8.2.1.19, “LIMIT Query Optimization”
Section 13.2.7, “LOAD DATA Statement”
Section 13.2.8, “LOAD XML Statement”
Section 7.4.5.1, “Making a Copy of a Database”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 23.5, “Management of NDB Cluster”
Section 8.13.1, “Measuring the Speed of Expressions and Functions”
Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 4.5.1.2, “mysql Client Commands”
Section 4.5.1.3, “mysql Client Logging”
Section 4.5.1.1, “mysql Client Options”
Section 4.5.1.4, “mysql Client Server-Side Help”
Section 4.5.1.6, “mysql Client Tips”
MySQL Glossary
Section 2.3.3.1, “MySQL Installer Initial Setup”
Chapter 23, MySQL NDB Cluster 8.0
Section 5.1.15, “MySQL Server Time Zone Support”
Section 23.5.9, “MySQL Server Usage for NDB Cluster”
Chapter 19, MySQL Shell
Section 4.5.1, “mysql — The MySQL Command-Line Client”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.4, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 23.5.13, “NDB API Statistics Counters and Variables”
Section 23.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 23.5.10.1, “NDB Cluster Disk Data Objects”
Section 23.2.5, “NDB Cluster Example with Tables and Data”
Section 23.6, “NDB Cluster Replication”
Section 23.4.9, “ndb_desc — Describe NDB Tables”
Section 23.4.11, “ndb_drop_table — Drop an NDB Table”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 23.4.14, “ndb_index_stat — NDB Index Statistics Utility”
Section 23.4.5, “ndb_mgm — The NDB Cluster Management Client”
Section 23.4.17, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 23.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 23.5.14, “ndbinfo: The NDB Cluster Information Database”
Section 23.4.2, “ndbinfo_select_all — Select From ndbinfo Tables”
Section 23.4.31, “ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster”
Section 5.1.14, “Network Namespace Support”
Section 4.2.2.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.3.2.6, “Out of memory”
Section 4.1, “Overview of MySQL Programs”
Section B.3.2.8, “Packet Too Large”
Section 6.4.1.5, “PAM Pluggable Authentication”
Section 27.12.9, “Performance Schema Connection Attribute Tables”
Section 6.2.17, “Pluggable Authentication”
Section 7.5.1, “Point-in-Time Recovery Using Binary Log”
Section 13.5, “Prepared Statements”
Section 23.6.5, “Preparing the NDB Cluster for Replication”
Section 4.2.2.4, “Program Option Modifiers”
Section 17.1.5.2, “Provisioning a Multi-Source Replica for GTID-Based Replication”
Section 5.7.3, “Query Attribute User-Defined Functions”
Section 9.6, “Query Attributes”
Section 24.2.3.1, “RANGE COLUMNS partitioning”
Section 2.11.13, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section B.3.3.2.3, “Resetting the Root Password: Generic Instructions”
Section 23.4.23.1.2, “Restoring an NDB backup to a later version of NDB Cluster”
Section 23.4.23.2.2, “Restoring to More Nodes Than the Original”
Section 13.7.1.8, “REVOKE Statement”
Section 2.10.4, “Securing the Initial MySQL Account”
Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”
Section 6.2.16, “Server Handling of Expired Passwords”
Section 5.1.8, “Server System Variables”
Section 5.1.17, “Server-Side Help Support”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement”
Section 13.7.7.42, “SHOW WARNINGS Statement”
Section 13.6.7.5, “SIGNAL Statement”
Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”
Section 4.2.2, “Specifying Program Options”
Section 17.1.5.5, “Starting Multi-Source Replicas”
Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 23.6.6, “Starting NDB Cluster Replication (Single Replication Channel)”
Section 9.1.1, “String Literals”
Section 2.10.3, “Testing the Server”
Section 11.3.4, “The BLOB and TEXT Types”
Section 28.4.4.2, “The diagnostics() Procedure”
Section 23.5.14.3, “The ndbinfo backup_id Table”
Section 23.5.14.37, “The ndbinfo memory_per_fragment Table”
Section 23.5.14.55, “The ndbinfo transporters Table”
Section 25.3.1, “Trigger Syntax and Examples”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Chapter 3, Tutorial
Section 4.10, “Unix Signal Handling in MySQL”
Section 2.11, “Upgrading MySQL”
Section 7.3.2, “Using Backups for Recovery”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”
Section 6.4.7.3, “Using MySQL Enterprise Firewall”
Section 3.5, “Using mysql in Batch Mode”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 7.4, “Using mysqldump for Backups”
Section 4.2.2.2, “Using Option Files”
Section 4.2.2.1, “Using Options on the Command Line”
Section 4.2.2.5, “Using Options to Set Program Variables”
Section 5.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 1.3, “What Is New in MySQL 8.0”
Section 23.1.4, “What is New in NDB Cluster”
Section 2.3.6, “Windows Postinstallation Procedures”
Section 13.2.15, “WITH (Common Table Expressions)”
Section 12.12, “XML Functions”

mysql ...

Section 5.9.1.1, “Compiling MySQL for Debugging”

mysql-server

Section 2.8, “Installing MySQL on FreeBSD”

mysql-test-run.pl

Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 5.9.3, “The LOCK_ORDER Tool”
Section 4.2.2.2, “Using Option Files”

mysql.exe

Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 4.5.1.6, “mysql Client Tips”

mysql.server

Section 2.5, “Installing MySQL on Linux”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.7, “Server Command Options”
Section 2.10.5, “Starting and Stopping MySQL Automatically”
Section B.3.3.7, “Time Zone Problems”

mysql.server stop

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

mysql_client_test_embedded

Section 1.3, “What Is New in MySQL 8.0”

mysql_config

Section 2.9.8, “Dealing with Problems Compiling MySQL”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.1, “Overview of MySQL Programs”
Section 1.3, “What Is New in MySQL 8.0”

mysql_config_editor

Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 4.9, “Environment Variables”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.4.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Client Options”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.8, “mysqlslap — A Load Emulation Client”
Section 4.1, “Overview of MySQL Programs”
Section 4.2.2.2, “Using Option Files”

mysql_install_db

Section 1.3, “What Is New in MySQL 8.0”

mysql_plugin

Section 1.3, “What Is New in MySQL 8.0”

mysql_secure_installation

Section 2.10.1, “Initializing the Data Directory”
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.5, “Installing MySQL on Linux Using Debian Packages from Oracle”
Section 2.7.1, “Installing MySQL on Solaris Using a Solaris PKG”
Section 4.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.1, “Overview of MySQL Programs”
Section 2.10.4, “Securing the Initial MySQL Account”

mysql_setpermission

Section 1.8.1, “Contributors to MySQL”

mysql_ssl_rsa_setup

Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.3.3.3, “Creating RSA Keys Using openssl”
Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 6.3.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 2.10.1, “Initializing the Data Directory”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 4.1, “Overview of MySQL Programs”

mysql_stmt_execute()

Section 5.1.10, “Server Status Variables”

mysql_stmt_prepare()

Section 5.1.10, “Server Status Variables”

mysql_tzinfo_to_sql

Section 5.1.15, “MySQL Server Time Zone Support”
Section 4.4.4, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 4.1, “Overview of MySQL Programs”

mysql_upgrade

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 18.2.1.2, “Configuring an Instance for Group Replication”
Section 4.2.8, “Connection Compression Control”
Section 4.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 23.6.4, “NDB Cluster Replication Schema and Tables”
Section 4.1, “Overview of MySQL Programs”
Section 2.11.13, “Rebuilding or Repairing Tables or Indexes”
Section 17.1.3.7, “Restrictions on Replication with GTIDs”
Section 5.1.8, “Server System Variables”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 17.5.3, “Upgrading a Replication Setup”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
Section 2.11.10, “Upgrading MySQL on Windows”
Section 2.11.7, “Upgrading MySQL with the MySQL Yum Repository”
Section 1.3, “What Is New in MySQL 8.0”
Section 2.11.3, “What the MySQL Upgrade Process Upgrades”

mysqlaccess

Section 1.8.1, “Contributors to MySQL”

mysqladmin

Section 6.2.14, “Assigning Account Passwords”
Section 17.4.1.1, “Backing Up a Replica Using mysqldump”
Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section B.3.2.2, “Can't connect to [local] MySQL server”
Section 2.11.4, “Changes in MySQL 8.0”
Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 5.1.1, “Configuring the Server”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 10.4, “Connection Character Sets and Collations”
Section 4.2.8, “Connection Compression Control”
Section 1.8.1, “Contributors to MySQL”
Section 13.1.12, “CREATE DATABASE Statement”
Section 2.3.4.7, “Customizing the PATH for MySQL Tools”
Section 5.9.1, “Debugging a MySQL Server”
Section 13.1.24, “DROP DATABASE Statement”
Section 13.7.8.3, “FLUSH Statement”
Section 2.4.1, “General Notes on Installing MySQL on macOS”
Section B.3.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 2.3.3.1, “MySQL Installer Initial Setup”
Section 5.4, “MySQL Server Logs”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.1, “Overview of MySQL Programs”
Section 27.12.9, “Performance Schema Connection Attribute Tables”
Section 6.2.17, “Pluggable Authentication”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.8.3, “Running Multiple MySQL Instances on Unix”
Section 2.10.4, “Securing the Initial MySQL Account”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 2.3.4.6, “Starting MySQL from the Windows Command Line”
Section 2.10.3, “Testing the Server”
Section 1.2.2, “The Main Features of MySQL”
Section 5.1.19, “The Server Shutdown Process”
Section 2.11.10, “Upgrading MySQL on Windows”
Section 4.2.2.2, “Using Option Files”
Section 4.2.2.1, “Using Options on the Command Line”
Section B.3.3.3, “What to Do If MySQL Keeps Crashing”

mysqladmin debug

Section 5.9.1, “Debugging a MySQL Server”
Section 25.4.5, “Event Scheduler Status”
Section 13.7.1.6, “GRANT Statement”
Section 6.2.2, “Privileges Provided by MySQL”

mysqladmin extended-status

Section 13.7.7.37, “SHOW STATUS Statement”

mysqladmin flush-hosts

Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”

mysqladmin flush-logs

Section 7.3.3, “Backup Strategy Summary”
Section 5.4.2.10, “Error Log File Flushing and Renaming”
Section 7.3.1, “Establishing a Backup Policy”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 5.4.6, “Server Log Maintenance”
Section 5.4.4, “The Binary Log”
Section 17.2.4.1, “The Relay Log”

mysqladmin flush-privileges

Section 2.11.14, “Copying MySQL Databases to Another Machine”
Section 6.2.3, “Grant Tables”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 5.1.7, “Server Command Options”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 6.2.13, “When Privilege Changes Take Effect”

mysqladmin flush-tables

Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 8.11.5, “External Locking”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.12.3.1, “How MySQL Uses Memory”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 7.6.1, “Using myisamchk for Crash Recovery”

mysqladmin flush-xxx

Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”

mysqladmin kill

Section B.3.3.4, “How MySQL Handles a Full Disk”
Section 13.7.8.4, “KILL Statement”
Section 12.15, “Locking Functions”
Section B.3.2.7, “MySQL server has gone away”
Section 6.2.2, “Privileges Provided by MySQL”

mysqladmin password

Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”

mysqladmin processlist

Section 8.14.1, “Accessing the Process List”
Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 13.7.8.4, “KILL Statement”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.2.2, “Privileges Provided by MySQL”
Section 27.12.19.9, “The processlist Table”

mysqladmin processlist status

Section 5.9.1, “Debugging a MySQL Server”

mysqladmin refresh

Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 5.4.6, “Server Log Maintenance”

mysqladmin reload

Section 6.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 6.2.3, “Grant Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 5.1.7, “Server Command Options”
Section 6.2.20, “Setting Account Resource Limits”
Section 6.2.13, “When Privilege Changes Take Effect”

mysqladmin reload version

Section 1.6, “How to Report Bugs or Problems”

mysqladmin shutdown

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 5.9.1.2, “Creating Trace Files”
Section 13.7.1.6, “GRANT Statement”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 2.4.2, “Installing MySQL on macOS Using Native Packages”
Section 5.9.1.7, “Making a Test Case If You Experience Table Corruption”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.5.1.31, “Replication and Temporary Tables”
Section 23.2.6, “Safe Shutdown and Restart of NDB Cluster”
Section 13.7.8.9, “SHUTDOWN Statement”
Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 5.1.19, “The Server Shutdown Process”
Section 18.7.3.2, “Upgrading a Group Replication Member”
Section B.3.3.3, “What to Do If MySQL Keeps Crashing”

mysqladmin status

Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”

mysqladmin variables

Section B.3.2.7, “MySQL server has gone away”
Section 13.7.7.41, “SHOW VARIABLES Statement”

mysqladmin variables extended-status processlist

Section 1.6, “How to Report Bugs or Problems”

mysqladmin ver

Section 5.9.1.1, “Compiling MySQL for Debugging”

mysqladmin version

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

mysqlanalyze

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlbackup

Section 7.1, “Backup and Recovery Types”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 18.7.3.4, “Group Replication Upgrade with mysqlbackup
Section 15.18.1, “InnoDB Backup”
Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
MySQL Glossary
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 18.4.6, “Using MySQL Enterprise Backup with Group Replication”

mysqlbinlog

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 5.4.4.5, “Binary Log Transaction Compression”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.7.8.1, “BINLOG Statement”
Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 4.2.8, “Connection Compression Control”
Section 17.4.11, “Delayed Replication”
Section 17.3.2, “Encrypting Binary Log Files and Relay Log Files”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.1.3.2, “GTID Life Cycle”
Section 17.5.5, “How to Report Replication Bugs or Problems”
Section 15.18.2, “InnoDB Recovery”
Section 13.1.20.10, “Invisible Columns”
Section B.3.7, “Known Issues in MySQL”
Section 12.24, “Miscellaneous Functions”
Section 5.4.4.5.3, “Monitoring Binary Log Transaction Compression”
Section 4.5.1.1, “mysql Client Options”
MySQL Glossary
Section 4.6.8.1, “mysqlbinlog Hex Dump Format”
Section 4.6.8.2, “mysqlbinlog Row Event Display”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 24.3.5, “Obtaining Information About Partitions”
Section 4.1, “Overview of MySQL Programs”
Section 27.12.9, “Performance Schema Connection Attribute Tables”
Section 7.5.1, “Point-in-Time Recovery Using Binary Log”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”
Section 23.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 17.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.3.3.3, “Recovering From Failed Replication Privilege Checks”
Section 17.5.1.19, “Replication and LOAD DATA”
Section 17.5.1.39, “Replication and Variables”
Section 17.3.3, “Replication Privilege Checks”
Section 17.3.2.1, “Scope of Binary Log Encryption”
Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”
Section 5.1.8, “Server System Variables”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 13.7.7.2, “SHOW BINLOG EVENTS Statement”
Section 13.7.7.32, “SHOW RELAYLOG EVENTS Statement”
Section 17.1.7.3, “Skipping Transactions”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 13.4.2.7, “START REPLICA | SLAVE Statement”
Section 5.4.4, “The Binary Log”
Section 5.4.3, “The General Query Log”
Section 17.2.4.1, “The Relay Log”
Section 17.2.1.2, “Usage of Row-Based Logging and Replication”
Section 7.3.2, “Using Backups for Recovery”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”

mysqlbinlog binary-log-file | mysql

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

mysqlbinlog|mysql

Section B.3.7, “Known Issues in MySQL”

mysqlcheck

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 2.11.4, “Changes in MySQL 8.0”
Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 10.4, “Connection Character Sets and Collations”
Section 4.2.8, “Connection Compression Control”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.1, “Overview of MySQL Programs”
Section 2.11.5, “Preparing Your Installation for Upgrade”
Section 2.11.13, “Rebuilding or Repairing Tables or Indexes”
Section 5.1.8, “Server System Variables”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 1.2.2, “The Main Features of MySQL”
Section 16.2, “The MyISAM Storage Engine”
Section 1.3, “What Is New in MySQL 8.0”

mysqld

Section 1.1, “About This Manual”
Section 13.1.2, “ALTER DATABASE Statement”
Section 8.2.1.23, “Avoiding Full Table Scans”
Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”
Section 5.4.4.1, “Binary Logging Formats”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 23.2.1.4, “Building NDB Cluster from Source on Linux”
Section B.3.2.2, “Can't connect to [local] MySQL server”
Section B.3.2.11, “Can't create/write to file”
Section B.3.2.15, “Can't initialize character set”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Statement”
Section 2.11.4, “Changes in MySQL 8.0”
Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”
Section 23.5.1, “Commands in the NDB Cluster Management Client”
Section 9.7, “Comments”
Section B.3.2.9, “Communication Errors and Aborted Connections”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 5.9.1.1, “Compiling MySQL for Debugging”
Section 23.3, “Configuration of NDB Cluster”
Section 2.9.6, “Configuring SSL Library Support”
Section 5.1.1, “Configuring the Server”
Section 5.1.12.1, “Connection Interfaces”
Section 15.20.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 16.2.4.1, “Corrupted MyISAM Tables”
Section 13.1.20, “CREATE TABLE Statement”
Section 5.9.1.2, “Creating Trace Files”
Section 14.1, “Data Dictionary Schema”
Section 15.7.5, “Deadlocks in InnoDB”
Section 5.9.1, “Debugging a MySQL Server”
Section 5.9.1.4, “Debugging mysqld under gdb”
Section 5.4.2.2, “Default Error Log Destination Configuration”
Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section 23.3.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”
Section 5.1.12.3, “DNS Lookups and the Host Cache”
Section 15.6.4, “Doublewrite Buffer”
Section 15.17.2, “Enabling InnoDB Monitors”
Section 8.2.1.5, “Engine Condition Pushdown Optimization”
Section 4.9, “Environment Variables”
Section 5.4.2.3, “Error Event Fields”
Section 5.4.2.10, “Error Log File Flushing and Renaming”
Section 5.4.2.9, “Error Log Output Format”
Section 5.4.2.8, “Error Logging to the System Log”
Section 23.5.2.3, “Event Buffer Reporting in the Cluster Log”
Section 15.8.3.7, “Excluding Buffer Pool Pages from Core Files”
Section 8.11.5, “External Locking”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 15.6.3.2, “File-Per-Table Tablespaces”
Section 12.10.6, “Fine-Tuning MySQL Full-Text Search”
Section 15.21.2, “Forcing InnoDB Recovery”
Section 23.6.2, “General Requirements for NDB Cluster Replication”
Section 8.14.3, “General Thread States”
Section 8.12.3.1, “How MySQL Uses Memory”
Section B.3.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section B.3.2.13, “Ignoring user”
Section 23.6.8, “Implementing Failover with NDB Cluster Replication”
Section 12.16, “Information Functions”
Section 23.2.3, “Initial Configuration of NDB Cluster”
Section 23.2.4, “Initial Startup of NDB Cluster”
Section 2.10.1, “Initializing the Data Directory”
Section 15.18.1, “InnoDB Backup”
Section 15.11.1, “InnoDB Disk I/O”
Section 15.20.2, “InnoDB memcached Architecture”
Section 15.18.2, “InnoDB Recovery”
Section 15.8.1, “InnoDB Startup Configuration”
Section 15.14, “InnoDB Startup Options and System Variables”
Section 15.21, “InnoDB Troubleshooting”
Section 13.2.6.2, “INSERT ... ON DUPLICATE KEY UPDATE Statement”
Section 13.2.6, “INSERT Statement”
Section 23.2.1, “Installation of NDB Cluster on Linux”
Section 23.2.1.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.4.2, “Installing MySQL on macOS Using Native Packages”
Section 2.3, “Installing MySQL on Microsoft Windows”
Section 2.7, “Installing MySQL on Solaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”
Section 23.1.7.8, “Issues Exclusive to NDB Cluster”
Section 13.7.8.4, “KILL Statement”
Section 23.6.3, “Known Issues in NDB Cluster Replication”
Section 13.2.7, “LOAD DATA Statement”
Section 5.9.1.7, “Making a Test Case If You Experience Table Corruption”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 23.5, “Management of NDB Cluster”
Section 2.5.9, “Managing MySQL Server with systemd”
Section 6.4.4.9, “Migrating Keys Between Keyring Keystores”
Section 12.24, “Miscellaneous Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 15.6.1.4, “Moving or Copying InnoDB Tables”
Section 16.2.1, “MyISAM Startup Options”
Section 4.6.4.2, “myisamchk Check Options”
Section 4.6.4.1, “myisamchk General Options”
Section 4.6.4, “myisamchk — MyISAM Table-Maintenance Utility”
Section 4.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section A.1, “MySQL 8.0 FAQ: General”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 4.5.1.6, “mysql Client Tips”
MySQL Glossary
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows”
Chapter 23, MySQL NDB Cluster 8.0
Chapter 5, MySQL Server Administration
Section B.3.2.7, “MySQL server has gone away”
Section 5.4, “MySQL Server Logs”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 5.1.15, “MySQL Server Time Zone Support”
Section 23.5.9, “MySQL Server Usage for NDB Cluster”
Section 23.1.6, “MySQL Server Using InnoDB Compared with NDB Cluster”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 1.7, “MySQL Standards Compliance”
Chapter 28, MySQL sys Schema
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.6.8, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.3.1, “mysqld — The MySQL Server”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 23.5.13, “NDB API Statistics Counters and Variables”
Section 23.5.17.3, “NDB Cluster and MySQL Security Procedures”
Section 23.2.8.1, “NDB Cluster Auto-Installer Requirements”
Section 23.3.3.1, “NDB Cluster Configuration: Basic Example”
Section 23.1.1, “NDB Cluster Core Concepts”
Section 23.2, “NDB Cluster Installation”
Section 23.3.2.5, “NDB Cluster mysqld Option and Variable Reference”
Section 23.1.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
Section 23.1, “NDB Cluster Overview”
Section 23.4, “NDB Cluster Programs”
Section 23.6, “NDB Cluster Replication”
Section 23.6.11, “NDB Cluster Replication Conflict Resolution”
Section 23.6.4, “NDB Cluster Replication Schema and Tables”
Section 23.6.10, “NDB Cluster Replication: Bidrectional and Circular Replication”
Section 23.3.3.9.3, “NDB Cluster Status Variables”
Section 23.3.3.9.2, “NDB Cluster System Variables”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 23.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 23.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 23.4.27, “ndb_show_tables — Display List of NDB Tables”
Section 23.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 23.5.14, “ndbinfo: The NDB Cluster Information Database”
Section 5.1.14, “Network Namespace Support”
Section 23.1.7.1, “Noncompliance with SQL Syntax in NDB Cluster”
Section 13.7.3.4, “OPTIMIZE TABLE Statement”
Section B.3.5, “Optimizer-Related Issues”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 23.1.5, “Options, Variables, and Parameters Added, Deprecated or Removed in NDB 8.0”
Section 4.1, “Overview of MySQL Programs”
Section 23.3.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”
Section B.3.2.8, “Packet Too Large”
Section 27.3, “Performance Schema Startup Configuration”
Section 27.12.14.2, “Performance Schema variables_info Table”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 23.6.5, “Preparing the NDB Cluster for Replication”
Section 16.2.4.2, “Problems from Tables Not Being Closed Properly”
Section B.3.3.1, “Problems with File Permissions”
Section 4.2.2.4, “Program Option Modifiers”
Section 23.3.3.2, “Recommended Starting Configuration for NDB Cluster”
Section 13.7.3.5, “REPAIR TABLE Statement”
Section 17.1.6.1, “Replication and Binary Logging Option and Variable Reference”
Section 17.1.6, “Replication and Binary Logging Options and Variables”
Section 17.5.1.28, “Replication and Source or Replica Shutdowns”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”
Section 17.2.4.2, “Replication Metadata Repositories”
Section 17.3.3, “Replication Privilege Checks”
Section 17.1.6.2, “Replication Source Options and Variables”
Section 13.4.2.5, “RESET REPLICA | SLAVE Statement”
Section B.3.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.3.3.2.1, “Resetting the Root Password: Windows Systems”
Section 5.1.16, “Resource Groups”
Section 13.7.8.8, “RESTART Statement”
Section 23.4.23.1.2, “Restoring an NDB backup to a later version of NDB Cluster”
Section 23.4.23.1.1, “Restoring an NDB backup to a previous version of NDB Cluster”
Section 23.4.23.2.2, “Restoring to More Nodes Than the Original”
Section B.3.4.5, “Rollback Failure for Nontransactional Tables”
Section 5.8, “Running Multiple MySQL Instances on One Machine”
Section 2.10.4, “Securing the Initial MySQL Account”
Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”
Section 6.1.4, “Security-Related mysqld Options and Variables”
Section 13.2.10.1, “SELECT ... INTO Statement”
Section 2.3.4.3, “Selecting a MySQL Server Type”
Section 6.7, “SELinux”
Section 4.3, “Server and Server-Startup Programs”
Section 10.3.2, “Server Character Set and Collation”
Section 5.1.7, “Server Command Options”
Section 5.4.6, “Server Log Maintenance”
Section 5.1.10, “Server Status Variables”
Section 5.1.8, “Server System Variables”
Section 10.12, “Setting the Error Message Language”
Section 6.7.5.2, “Setting the TCP Port Context for MySQL Features”
Section 6.7.5.1, “Setting the TCP Port Context for mysqld”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”
Section 13.7.7.15, “SHOW ENGINE Statement”
Section 4.2.2, “Specifying Program Options”
Section 13.4.2.7, “START REPLICA | SLAVE Statement”
Section 2.10.5, “Starting and Stopping MySQL Automatically”
Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.8.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 2.3.4.6, “Starting MySQL from the Windows Command Line”
Section 23.6.6, “Starting NDB Cluster Replication (Single Replication Channel)”
Section 17.2.2.3, “Startup Options and Replication Channels”
Section 1.8.5, “Supporters of MySQL”
Section 17.4.8, “Switching Sources During Failover”
Section 8.11.2, “Table Locking Issues”
Section B.3.2.17, “Table-Corruption Issues”
Section 2.3.4.9, “Testing The MySQL Installation”
Section 2.10.3, “Testing the Server”
Section 5.4.4, “The Binary Log”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 5.9.4, “The DBUG Package”
Section 5.4.2, “The Error Log”
Section 5.4.3, “The General Query Log”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”
Section 16.2, “The MyISAM Storage Engine”
Section 5.1, “The MySQL Server”
Section 23.5.14.39, “The ndbinfo operations_per_fragment Table”
Section 23.5.14.44, “The ndbinfo server_locks Table”
Section 5.4.5, “The Slow Query Log”
Section B.3.3.7, “Time Zone Problems”
Section B.3.2.5, “Too many connections”
Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 15.21.1, “Troubleshooting InnoDB I/O Problems”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 4.10, “Unix Signal Handling in MySQL”
Section 2.11.12, “Upgrade Troubleshooting”
Section 23.2.7, “Upgrading and Downgrading NDB Cluster”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
Section 2.11.10, “Upgrading MySQL on Windows”
Section 5.9.1.5, “Using a Stack Trace”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.2.2, “Using Option Files”
Section 5.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.12.2.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section 23.2.8.2, “Using the NDB Cluster Auto-Installer”
Section 23.6.7, “Using Two Replication Channels for NDB Cluster Replication”
Section 5.9.1.3, “Using WER with PDB to create a Windows crashdump”
Section 1.3, “What Is New in MySQL 8.0”
Section 23.1.4, “What is New in NDB Cluster”
Section 2.11.3, “What the MySQL Upgrade Process Upgrades”
Section B.3.3.3, “What to Do If MySQL Keeps Crashing”
Section 6.2.13, “When Privilege Changes Take Effect”
Section B.3.3.5, “Where MySQL Stores Temporary Files”
Section 2.1.2, “Which MySQL Version and Distribution to Install”

mysqld mysqld.trace

Section 5.9.1.2, “Creating Trace Files”

mysqld-auto.cnf

Section 4.2.2, “Specifying Program Options”

mysqld-debug

Section 5.9.1.2, “Creating Trace Files”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 4.3.1, “mysqld — The MySQL Server”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.3.4.3, “Selecting a MySQL Server Type”

mysqld.exe

Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”

mysqld_multi

Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.1, “Overview of MySQL Programs”
Section 5.8.3, “Running Multiple MySQL Instances on Unix”

mysqld_multi.server

Section 2.5.9, “Managing MySQL Server with systemd”

mysqld_safe

Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 5.9.1.1, “Compiling MySQL for Debugging”
Section 5.1.1, “Configuring the Server”
Section 5.4.2.2, “Default Error Log Destination Configuration”
Section 8.12.3.2, “Enabling Large Page Support”
Section B.3.2.16, “File Not Found and Similar Errors”
Section B.3.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 15.21, “InnoDB Troubleshooting”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 2.5.9, “Managing MySQL Server with systemd”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 5.1.15, “MySQL Server Time Zone Support”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 23.5.17.3, “NDB Cluster and MySQL Security Procedures”
Section 4.2.2.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section 4.1, “Overview of MySQL Programs”
Section B.3.2.8, “Packet Too Large”
Section 27.12.14.2, “Performance Schema variables_info Table”
Section B.3.3.1, “Problems with File Permissions”
Section 13.7.8.8, “RESTART Statement”
Section 5.8, “Running Multiple MySQL Instances on One Machine”
Section 5.8.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “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 5.4.2, “The Error Log”
Section B.3.3.7, “Time Zone Problems”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
Section 4.2.2.2, “Using Option Files”

mysqldump

Section 13.1.2, “ALTER DATABASE Statement”
Section 17.4.1.1, “Backing Up a Replica Using mysqldump”
Section 17.4.1.3, “Backing Up a Source or Replica by Making It Read Only”
Chapter 7, Backup and Recovery
Section 7.1, “Backup and Recovery Types”
Section 7.3.3, “Backup Strategy Summary”
Section 15.5.1, “Buffer Pool”
Section 8.5.5, “Bulk Data Loading for InnoDB Tables”
Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 2.11.4, “Changes in MySQL 8.0”
Section 17.1.2.5, “Choosing a Method for Data Snapshots”
Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 4.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”
Section 4.2.8, “Connection Compression Control”
Section 4.2.7, “Connection Transport Protocols”
Section 1.8.1, “Contributors to MySQL”
Section 10.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”
Section 7.4.5.2, “Copy a Database from one Server to Another”
Section 2.11.14, “Copying MySQL Databases to Another Machine”
Section 13.1.20, “CREATE TABLE Statement”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 17.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 2.3.4.7, “Customizing the PATH for MySQL Tools”
Section 14.7, “Data Dictionary Usage Differences”
Section 7.2, “Database Backup Methods”
Section 15.11.4, “Defragmenting a Table”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 7.3.1, “Establishing a Backup Policy”
Section 7.3, “Example Backup and Recovery Strategy”
Section 13.1.20.5, “FOREIGN KEY Constraints”
Section 17.1.6.5, “Global Transaction ID System Variables”
Section 1.6, “How to Report Bugs or Problems”
Section 13.2.5, “IMPORT TABLE Statement”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 15.18.1, “InnoDB Backup”
Section 2.6, “Installing MySQL Using Unbreakable Linux Network (ULN)”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 13.1.20.10, “Invisible Columns”
Section 13.2.7, “LOAD DATA Statement”
Section 13.2.8, “LOAD XML Statement”
Section 7.4.5.1, “Making a Copy of a Database”
Section 15.6.1.4, “Moving or Copying InnoDB Tables”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 4.5.1.1, “mysql Client Options”
Section 5.4, “MySQL Server Logs”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 7.4.5, “mysqldump Tips”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 23.2.5, “NDB Cluster Example with Tables and Data”
Section 23.1, “NDB Cluster Overview”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 23.5.14, “ndbinfo: The NDB Cluster Information Database”
Section 17.1.2.4, “Obtaining the Replication Source Binary Log Coordinates”
Section 23.5.8, “Online Backup of NDB Cluster”
Section 4.1, “Overview of MySQL Programs”
Section 27.12.9, “Performance Schema Connection Attribute Tables”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 23.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 23.6.5, “Preparing the NDB Cluster for Replication”
Section 6.2.2, “Privileges Provided by MySQL”
Section B.3.4.8, “Problems with Floating-Point Values”
Section 17.1.5.2, “Provisioning a Multi-Source Replica for GTID-Based Replication”
Section 15.8.9, “Purge Configuration”
Section 2.11.13, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 17.4.6, “Replicating Different Databases to Different Replicas”
Section 17.5.1.34, “Replication and Transaction Inconsistencies”
Section 23.4.23.1.2, “Restoring an NDB backup to a later version of NDB Cluster”
Section 23.4.23.1.1, “Restoring an NDB backup to a previous version of NDB Cluster”
Section 23.4.23.2.2, “Restoring to More Nodes Than the Original”
Section 27.20, “Restrictions on Performance Schema”
Section 25.9, “Restrictions on Views”
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.4.6, “Server Log Maintenance”
Section 5.1.11, “Server SQL Modes”
Section 5.1.8, “Server System Variables”
Section 13.4.1.3, “SET sql_log_bin Statement”
Section 17.1.2.6.2, “Setting Up Replication with Existing Data”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section B.3.4.7, “Solving Problems with No Matching Rows”
Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 17.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 11.3.4, “The BLOB and TEXT Types”
Section 15.20.7, “The InnoDB memcached Plugin and Replication”
Section 1.2.2, “The Main Features of MySQL”
Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”
Section 13.7.4.6, “UNINSTALL PLUGIN Statement”
Section 17.5.3, “Upgrading a Replication Setup”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 4.6.8.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 7.4, “Using mysqldump for Backups”
Section 4.2.2.2, “Using Option Files”
Section 17.4.1, “Using Replication for Backups”
Section 17.4.4, “Using Replication with Different Source and Replica Storage Engines”
Section 28.2, “Using the sys Schema”
Section 1.3, “What Is New in MySQL 8.0”
Section 12.12, “XML Functions”

mysqldump mysql

Section 6.2.21, “Troubleshooting Problems Connecting to MySQL”

mysqldump's

Section 2.11.14, “Copying MySQL Databases to Another Machine”

mysqldumpslow

Section 4.6.9, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.1, “Overview of MySQL Programs”
Section 5.4.5, “The Slow Query Log”

mysqlhotcopy

Section 1.8.1, “Contributors to MySQL”

mysqlimport

Section 7.1, “Backup and Recovery Types”
Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 10.4, “Connection Character Sets and Collations”
Section 4.2.8, “Connection Compression Control”
Section 2.11.14, “Copying MySQL Databases to Another Machine”
Section 7.2, “Database Backup Methods”
Section 13.2.7, “LOAD DATA Statement”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 4.1, “Overview of MySQL Programs”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”

MySQLInstallerConsole.exe

Section 2.3.3.5, “MySQLInstallerConsole Reference”

mysqloptimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlpump

Section 13.1.2, “ALTER DATABASE Statement”
Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 4.2.8, “Connection Compression Control”
Section 13.1.21, “CREATE TABLESPACE Statement”
Section 14.7, “Data Dictionary Usage Differences”
Section 2.6, “Installing MySQL Using Unbreakable Linux Network (ULN)”
Section 4.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section A.17, “MySQL 8.0 FAQ: InnoDB Data-at-Rest Encryption”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.1, “Overview of MySQL Programs”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 17.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
Section 28.2, “Using the sys Schema”
Section 4.8.3, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

mysqlrepair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlsh

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 20.3.1, “MySQL Shell”
Section 20.4.1, “MySQL Shell”
Section 4.1, “Overview of MySQL Programs”

mysqlshow

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 10.4, “Connection Character Sets and Collations”
Section 4.2.8, “Connection Compression Control”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 4.1, “Overview of MySQL Programs”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 13.7.7.14, “SHOW DATABASES Statement”
Section 13.7.7.22, “SHOW INDEX Statement”
Section 13.7.7.38, “SHOW TABLE STATUS Statement”
Section 2.3.4.9, “Testing The MySQL Installation”
Section 2.10.3, “Testing the Server”
Section 2.3.6, “Windows Postinstallation Procedures”

mysqlshow db_name

Section 13.7.7.39, “SHOW TABLES Statement”

mysqlshow db_name tbl_name

Section 13.7.7.5, “SHOW COLUMNS Statement”

mysqlslap

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 6.4.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 4.2.8, “Connection Compression Control”
Section 15.16.2, “Monitoring InnoDB Mutex Waits Using Performance Schema”
Section 4.5.8, “mysqlslap — A Load Emulation Client”
Section 4.1, “Overview of MySQL Programs”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 8.13.2, “Using Your Own Benchmarks”

mysqltest

Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication”
Section 4.2.8, “Connection Compression Control”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 5.1.18, “Server Tracking of Client Session State Changes”
Section 6.4.1.3, “SHA-256 Pluggable Authentication”
Section 1.3, “What Is New in MySQL 8.0”

mysqltest_embedded

Section 1.3, “What Is New in MySQL 8.0”

mysqlxtest

Section 5.1.14, “Network Namespace Support”

N

[index top]

nbdmtd

Section 23.3.3.6, “Defining NDB Cluster Data Nodes”

ndb_blob_tool

Section 23.4.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_config

Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 23.4, “NDB Cluster Programs”
Section 23.4.7, “ndb_config — Extract NDB Cluster Configuration Information”

ndb_delete_all

Section 23.4.8, “ndb_delete_all — Delete All Rows from an NDB Table”
Section 23.1.4, “What is New in NDB Cluster”

ndb_desc

Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 24.2.5, “KEY Partitioning”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.5.17.3, “NDB Cluster and MySQL Security Procedures”
Section 23.5.10.1, “NDB Cluster Disk Data Objects”
Section 23.4.9, “ndb_desc — Describe NDB Tables”
Section 23.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 13.1.20.11, “Setting NDB_TABLE Options”
Section 26.15, “The INFORMATION_SCHEMA FILES Table”
Section 26.21, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 23.5.14.6, “The ndbinfo cluster_operations Table”
Section 23.5.14.45, “The ndbinfo server_operations Table”
Section 23.1.4, “What is New in NDB Cluster”

ndb_drop_index

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

ndb_drop_table

Section 2.9.7, “MySQL Source-Configuration Options”
Section 23.4.10, “ndb_drop_index — Drop Index from an NDB Table”
Section 23.4.11, “ndb_drop_table — Drop an NDB Table”
Section 23.2.7, “Upgrading and Downgrading NDB Cluster”
Section 23.1.4, “What is New in NDB Cluster”

ndb_error_reporter

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

ndb_import

Section 23.4.13, “ndb_import — Import CSV Data Into NDB”

ndb_index_stat

Section 23.4.14, “ndb_index_stat — NDB Index Statistics Utility”

ndb_mgm

Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 23.5.7.1, “Adding NDB Cluster Data Nodes Online: General Issues”
Section 23.2.1.4, “Building NDB Cluster from Source on Linux”
Section 23.5.1, “Commands in the NDB Cluster Management Client”
Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section 23.2.4, “Initial Startup of NDB Cluster”
Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 23.2.1, “Installation of NDB Cluster on Linux”
Section 23.2.1.1, “Installing an NDB Cluster Binary Release on Linux”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 23.2.1.3, “Installing NDB Cluster Using .deb Files”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Chapter 23, MySQL NDB Cluster 8.0
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.1.1, “NDB Cluster Core Concepts”
Section 23.5.3.1, “NDB Cluster Logging Management Commands”
Section 23.4, “NDB Cluster Programs”
Section 23.5.17.1, “NDB Cluster Security and Networking Issues”
Section 23.5.6, “NDB Cluster Single User Mode”
Section 23.4.5, “ndb_mgm — The NDB Cluster Management Client”
Section 23.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 23.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 23.5.8, “Online Backup of NDB Cluster”
Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 23.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 23.4.23.1.2, “Restoring an NDB backup to a later version of NDB Cluster”
Section 23.4.23.2.2, “Restoring to More Nodes Than the Original”
Section 23.2.6, “Safe Shutdown and Restart of NDB Cluster”
Section 23.5.14.1, “The ndbinfo arbitrator_validity_detail Table”
Section 23.5.14.3, “The ndbinfo backup_id Table”
Section 23.5.14.35, “The ndbinfo membership Table”
Section 23.5.14.36, “The ndbinfo memoryusage Table”
Section 23.5.14.38, “The ndbinfo nodes Table”
Section 23.5.14.55, “The ndbinfo transporters Table”
Section 23.5.8.2, “Using The NDB Cluster Management Client to Create a Backup”
Section 23.1.4, “What is New in NDB Cluster”

ndb_mgm.exe

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

ndb_mgmd

Section 23.2.1.4, “Building NDB Cluster from Source on Linux”
Section 23.5.1, “Commands in the NDB Cluster Management Client”
Section 23.3.3.5, “Defining an NDB Cluster Management Server”
Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section 23.2.4, “Initial Startup of NDB Cluster”
Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 23.2.1, “Installation of NDB Cluster on Linux”
Section 23.2.1.1, “Installing an NDB Cluster Binary Release on Linux”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2.1.3, “Installing NDB Cluster Using .deb Files”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 23.3.3.1, “NDB Cluster Configuration: Basic Example”
Section 23.3.3.3, “NDB Cluster Connection Strings”
Section 23.1.1, “NDB Cluster Core Concepts”
Section 23.5.3.1, “NDB Cluster Logging Management Commands”
Section 23.1.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
Section 23.4, “NDB Cluster Programs”
Section 23.3.3.10, “NDB Cluster TCP/IP Connections”
Section 23.4.13, “ndb_import — Import CSV Data Into NDB”
Section 23.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 23.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 23.3.1, “Quick Test Setup of NDB Cluster”
Section 23.2.6, “Safe Shutdown and Restart of NDB Cluster”
Section 23.5.4, “Summary of NDB Cluster Start Phases”
Section 23.2.8.2, “Using the NDB Cluster Auto-Installer”
Section 23.1.4, “What is New in NDB Cluster”

ndb_mgmd.exe

Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”

ndb_move_data

Section 23.4.15, “ndb_move_data — NDB Data Copy Utility”

ndb_perror

Section B.2, “Error Information Interfaces”
Section 23.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 23.5.14.30, “The ndbinfo error_messages Table”
Section 1.3, “What Is New in MySQL 8.0”
Section 23.1.4, “What is New in NDB Cluster”

ndb_print_backup

Section 23.4.31, “ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster”

ndb_print_backup_file

Section 23.4.17, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 23.4.19, “ndb_print_frag_file — Print NDB Fragment List File Contents”
Section 23.4.20, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 23.4.21, “ndb_print_sys_file — Print NDB System File Contents”
Section 23.4.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section 23.5.8.2, “Using The NDB Cluster Management Client to Create a Backup”
Section 23.1.4, “What is New in NDB Cluster”

ndb_print_file

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

ndb_print_frag_file

Section 23.4.19, “ndb_print_frag_file — Print NDB Fragment List File Contents”

ndb_print_schema_file

Section 23.4.17, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 23.4.18, “ndb_print_file — Print NDB Disk Data File Contents”
Section 23.4.19, “ndb_print_frag_file — Print NDB Fragment List File Contents”
Section 23.4.20, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 23.4.21, “ndb_print_sys_file — Print NDB System File Contents”
Section 23.4.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”

ndb_print_sys_file

Section 23.4.17, “ndb_print_backup_file — Print NDB Backup File Contents”
Section 23.4.18, “ndb_print_file — Print NDB Disk Data File Contents”
Section 23.4.19, “ndb_print_frag_file — Print NDB Fragment List File Contents”
Section 23.4.20, “ndb_print_schema_file — Print NDB Schema File Contents”
Section 23.4.21, “ndb_print_sys_file — Print NDB System File Contents”
Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”

ndb_redo_log_reader

Section 23.4.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”

ndb_restore

Section 7.1, “Backup and Recovery Types”
Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 23.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 23.1.1, “NDB Cluster Core Concepts”
Section 23.1, “NDB Cluster Overview”
Section 23.4, “NDB Cluster Programs”
Section 23.6.4, “NDB Cluster Replication Schema and Tables”
Section 23.6.10, “NDB Cluster Replication: Bidrectional and Circular Replication”
Section 23.5.6, “NDB Cluster Single User Mode”
Section 23.4.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 23.4.31, “ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster”
Section 23.5.8, “Online Backup of NDB Cluster”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 23.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 23.4.23.3.1, “Restoring a parallel backup in parallel”
Section 23.4.23.3.2, “Restoring a parallel backup serially”
Section 23.4.23.1.2, “Restoring an NDB backup to a later version of NDB Cluster”
Section 23.4.23.1.1, “Restoring an NDB backup to a previous version of NDB Cluster”
Section 23.4.23.2.1, “Restoring to Fewer Nodes Than the Original”
Section 23.4.23.2.2, “Restoring to More Nodes Than the Original”
Section 23.5.8.5, “Taking an NDB Backup with Parallel Data Nodes”
Section 23.5.8.2, “Using The NDB Cluster Management Client to Create a Backup”
Section 23.1.4, “What is New in NDB Cluster”

ndb_select_all

Section 23.5.12, “Distributed MySQL Privileges with NDB_STORED_USER”
Section 23.5.17.3, “NDB Cluster and MySQL Security Procedures”
Section 23.4.24, “ndb_select_all — Print Rows from an NDB Table”
Section 23.4.27, “ndb_show_tables — Display List of NDB Tables”
Section 23.1.4, “What is New in NDB Cluster”

ndb_select_count

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

ndb_setup.py

Section 23.2.8.1, “NDB Cluster Auto-Installer Requirements”
Section 23.4, “NDB Cluster Programs”
Section 23.4.26, “ndb_setup.py — Start browser-based Auto-Installer for NDB Cluster (DEPRECATED)”
Section 23.2.8, “The NDB Cluster Auto-Installer (No longer supported)”
Section 23.2.8.2, “Using the NDB Cluster Auto-Installer”
Section 23.1.4, “What is New in NDB Cluster”

ndb_show_tables

Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.5.17.3, “NDB Cluster and MySQL Security Procedures”
Section 23.4, “NDB Cluster Programs”
Section 23.4.27, “ndb_show_tables — Display List of NDB Tables”
Section 23.5.14.5, “The ndbinfo cluster_locks Table”
Section 23.5.14.6, “The ndbinfo cluster_operations Table”
Section 23.5.14.32, “The ndbinfo locks_per_fragment Table”
Section 23.5.14.39, “The ndbinfo operations_per_fragment Table”
Section 23.5.14.44, “The ndbinfo server_locks Table”
Section 23.5.14.45, “The ndbinfo server_operations Table”
Section 23.1.4, “What is New in NDB Cluster”

ndb_size.pl

Section 11.7, “Data Type Storage Requirements”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.4.28, “ndb_size.pl — NDBCLUSTER Size Requirement Estimator”

ndb_top

Section 23.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 23.1.4, “What is New in NDB Cluster”

ndb_waiter

Section 23.4.30, “ndb_waiter — Wait for NDB Cluster to Reach a Given Status”
Section 23.1.4, “What is New in NDB Cluster”

ndbd

Section 23.5.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 23.2.1.4, “Building NDB Cluster from Source on Linux”
Section 23.5.1, “Commands in the NDB Cluster Management Client”
Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section 23.2.4, “Initial Startup of NDB Cluster”
Section 23.2.1, “Installation of NDB Cluster on Linux”
Section 23.2.1.1, “Installing an NDB Cluster Binary Release on Linux”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2.1.3, “Installing NDB Cluster Using .deb Files”
Section 23.5, “Management of NDB Cluster”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 23.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 23.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 23.3.3.1, “NDB Cluster Configuration: Basic Example”
Section 23.1.1, “NDB Cluster Core Concepts”
Section 23.3.2.1, “NDB Cluster Data Node Configuration Parameters”
Section 23.2, “NDB Cluster Installation”
Section 23.1.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
Section 23.4, “NDB Cluster Programs”
Section 23.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 23.4.30, “ndb_waiter — Wait for NDB Cluster to Reach a Given Status”
Section 23.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 23.4.3, “ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)”
Section 23.3.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 23.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 23.3.1, “Quick Test Setup of NDB Cluster”
Section 23.3.3.2, “Recommended Starting Configuration for NDB Cluster”
Section 23.2.6, “Safe Shutdown and Restart of NDB Cluster”
Section 23.5.4, “Summary of NDB Cluster Start Phases”
Section 23.5.8.5, “Taking an NDB Backup with Parallel Data Nodes”
Section 23.5.14.38, “The ndbinfo nodes Table”
Section 23.5.3.3, “Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client”
Section 23.2.8.2, “Using the NDB Cluster Auto-Installer”
Section 23.1.4, “What is New in NDB Cluster”

ndbd.exe

Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”

ndbinfo_select_all

Section 23.4.2, “ndbinfo_select_all — Select From ndbinfo Tables”

ndbmtd

Section 23.5.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 23.2.1.4, “Building NDB Cluster from Source on Linux”
Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section 23.2.1, “Installation of NDB Cluster on Linux”
Section 23.2.1.1, “Installing an NDB Cluster Binary Release on Linux”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 23.1.1, “NDB Cluster Core Concepts”
Section 23.3.2.1, “NDB Cluster Data Node Configuration Parameters”
Section 23.1.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
Section 23.4, “NDB Cluster Programs”
Section 23.4.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
Section 23.4.29, “ndb_top — View CPU usage information for NDB threads”
Section 23.4.1, “ndbd — The NDB Cluster Data Node Daemon”
Section 23.4.3, “ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 23.6.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
Section 23.3.3.2, “Recommended Starting Configuration for NDB Cluster”
Section 23.4.23.3, “Restoring from a backup taken in parallel”
Section 23.4.23.2.1, “Restoring to Fewer Nodes Than the Original”
Section 23.2.6, “Safe Shutdown and Restart of NDB Cluster”
Section 23.5.8.5, “Taking an NDB Backup with Parallel Data Nodes”
Section 23.5.14.38, “The ndbinfo nodes Table”
Section 23.5.14.42, “The ndbinfo resources Table”
Section 23.2.8.2, “Using the NDB Cluster Auto-Installer”
Section 23.1.4, “What is New in NDB Cluster”

ndbmtd.exe

Section 23.2.2.3, “Initial Startup of NDB Cluster on Windows”
Section 23.2.2.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”

ndbxfrm

Section 23.4.31, “ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster”
Section 23.5.8.2, “Using The NDB Cluster Management Client to Create a Backup”
Section 23.1.4, “What is New in NDB Cluster”

NET

Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”
Section 2.3.4.8, “Starting MySQL as a Windows Service”

NET START

Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”
Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services”

NET START mysqld_service_name

Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 2.11.10, “Upgrading MySQL on Windows”

NET STOP

Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”
Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services”

NET STOP mysqld_service_name

Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 2.11.10, “Upgrading MySQL on Windows”

NET STOP service_name

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

nslookup

Section 1.3, “What Is New in MySQL 8.0”

numactl

Section 23.3.3.6, “Defining NDB Cluster Data Nodes”

O

[index top]

openssl

Section 6.4.5.5, “Configuring Audit Logging Characteristics”
Section 6.3.3.3, “Creating RSA Keys Using openssl”
Section 6.3.3, “Creating SSL and RSA Certificates and Keys”
Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
Section 6.3.3.2, “Creating SSL Certificates and Keys Using openssl”
Section 4.4.3, “mysql_ssl_rsa_setup — Create SSL/RSA Files”
Section 5.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
Section 6.4.4.4, “Using the keyring_okv KMIP Plugin”

openssl md5 package_name

Section 2.1.4.1, “Verifying the MD5 Checksum”

openssl zlib

Section 2.9.7, “MySQL Source-Configuration Options”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.8.3, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

P

[index top]

patchelf

Section 2.9.7, “MySQL Source-Configuration Options”

perf

Section 27.12.19.10, “The threads Table”

perror

Section B.3.2.11, “Can't create/write to file”
Section B.2, “Error Information Interfaces”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section A.10, “MySQL 8.0 FAQ: NDB Cluster”
Section 23.4.16, “ndb_perror — Obtain NDB Error Message Information”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.2, “perror — Display MySQL Error Message Information”
Section 5.4.2.6, “Rule-Based Error Log Filtering (log_filter_dragnet)”
Section 23.5.14.30, “The ndbinfo error_messages Table”
Section 1.3, “What Is New in MySQL 8.0”
Section 23.1.4, “What is New in NDB Cluster”

pfexec

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

PGP

Section 2.1.4.2, “Signature Checking Using GnuPG”

ping6

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

pkg-config

Section 4.9, “Environment Variables”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 4.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.13, “Perl Installation Notes”

ps

Section 6.2.14, “Assigning Account Passwords”
Section 4.2.4, “Connecting to the MySQL Server Using Command Options”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 4.9, “Environment Variables”
Section 8.12.3.1, “How MySQL Uses Memory”
Section B.3.1, “How to Determine What Is Causing a Problem”
Section 4.5.2, “mysqladmin — A MySQL Server Administration Program”
Section 6.7, “SELinux”
Section 27.12.19.10, “The threads Table”
Section 2.10.2.1, “Troubleshooting Problems Starting the MySQL Server”

ps xa | grep mysqld

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

R

[index top]

rename

Section 5.4.2.10, “Error Log File Flushing and Renaming”
Section 5.4.6, “Server Log Maintenance”
Section 5.4.3, “The General Query Log”

resolve_stack_dump

Section 1.3, “What Is New in MySQL 8.0”

resolveip

Section 1.3, “What Is New in MySQL 8.0”

restart

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

rm

Section 13.4.1.1, “PURGE BINARY LOGS Statement”

rpm

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 2.1.4.4, “Signature Checking Using RPM”

rpmbuild

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 2.9.2, “Source Installation Prerequisites”

rsync

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 7.1, “Backup and Recovery Types”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”

S

[index top]

SC

Section 2.3.4.8, “Starting MySQL as a Windows Service”

SC DELETE

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

SC DELETE mysqld_service_name

Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 2.3.4.8, “Starting MySQL as a Windows Service”

SC DELETE service_name

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

SC START

Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services”

SC START mysqld_service_name

Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 2.11.10, “Upgrading MySQL on Windows”

sc start mysqld_service_name

Section 2.3.4.8, “Starting MySQL as a Windows Service”

SC STOP

Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”
Section 23.5.5, “Performing a Rolling Restart of an NDB Cluster”
Section 5.8.2.2, “Starting Multiple MySQL Instances as Windows Services”

SC STOP mysqld_service_name

Section 2.3.4.8, “Starting MySQL as a Windows Service”

sc stop mysqld_service_name

Section 2.3.4.8, “Starting MySQL as a Windows Service”

SC STOP service_name

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

scp

Section 7.1, “Backup and Recovery Types”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”

sed

Section 3.3.4.7, “Pattern Matching”

SELECT

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

semanage

Section 6.7.6, “Troubleshooting SELinux”

semodule

Section 6.7.3, “MySQL Server SELinux Policies”

service

Section 2.5.4, “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.9, “Managing MySQL Server with systemd”

Service Control Manager

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

Services

Section 23.2.2.4, “Installing NDB Cluster Processes as Windows Services”
Section 2.3.4.8, “Starting MySQL as a Windows Service”

sestatus

Section 6.7.2, “Changing the SELinux Mode”
Section 6.7.1, “Check if SELinux is Enabled”
Section 18.10, “Frequently Asked Questions”

setcap

Section 5.1.14, “Network Namespace Support”
Section 5.1.16, “Resource Groups”

setenforce

Section 6.7.2, “Changing the SELinux Mode”
Section 6.7.6, “Troubleshooting SELinux”

setenv

Section 4.2.9, “Setting Environment Variables”

setup.bat

Section 23.2.8.2, “Using the NDB Cluster Auto-Installer”

sh

Section 1.1, “About This Manual”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.9, “Setting Environment Variables”

SHOW

Section 23.3.1, “Quick Test Setup of NDB Cluster”

SHOW ERRORS

Section A.10, “MySQL 8.0 FAQ: NDB Cluster”

SHOW WARNINGS

Section A.10, “MySQL 8.0 FAQ: NDB Cluster”

sleep

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

ssh

Section 23.5.17.1, “NDB Cluster Security and Networking Issues”

start

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

Start>Run>cmd.exe

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

status

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

stop

Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

strings

Section 6.1.1, “Security Guidelines”

su root

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

sudo

Section 23.2.1.1, “Installing an NDB Cluster Binary Release on Linux”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 5.1.14, “Network Namespace Support”
Section 5.1.16, “Resource Groups”

sudo ip

Section 5.1.14, “Network Namespace Support”

sudo setcap

Section 5.1.14, “Network Namespace Support”

systemctl

Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.4, “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.9, “Managing MySQL Server with systemd”

T

[index top]

tar

Section 17.1.2.8, “Adding Replicas to a Replication Environment”
Section 17.4.1.2, “Backing Up Raw Data from a Replica”
Section 7.1, “Backup and Recovery Types”
Section 17.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 1.6, “How to Report Bugs or Problems”
Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.4, “Installing MySQL on macOS”
Section 2.7, “Installing MySQL on Solaris”
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.4, “Installing MySQL Using a Standard Source Distribution”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 2.13.1, “Installing Perl on Unix”
Section 2.9.1, “Source Installation Methods”
Section 2.9.2, “Source Installation Prerequisites”
Section 8.12.2.1, “Using Symbolic Links for Databases on Unix”
Section 6.4.4.4, “Using the keyring_okv KMIP Plugin”
Section 2.1.2, “Which MySQL Version and Distribution to Install”

tcpdump

Section 6.1.1, “Security Guidelines”

tcsh

Section 1.1, “About This Manual”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 2.4.1, “General Notes on Installing MySQL on macOS”
Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.9, “Setting Environment Variables”

tee

Section 4.5.1.2, “mysql Client Commands”

telnet

Section 15.20.2, “InnoDB memcached Architecture”
Section 6.1.1, “Security Guidelines”
Section 15.20.3, “Setting Up the InnoDB memcached Plugin”

Terminal

Section 2.4, “Installing MySQL on macOS”

Text in this style

Section 1.1, “About This Manual”

top

Section B.3.1, “How to Determine What Is Causing a Problem”
Section 23.5.14.41, “The ndbinfo processes Table”

U

[index top]

ulimit

Section 23.3.3.6, “Defining NDB Cluster Data Nodes”
Section 8.12.3.2, “Enabling Large Page Support”
Section B.3.2.16, “File Not Found and Similar Errors”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”
Section B.3.2.8, “Packet Too Large”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

unix_chkpwd

Section 6.4.1.5, “PAM Pluggable Authentication”

update-rc.d

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

useradd

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

V

[index top]

vault

Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

vault server

Section 6.4.4.6, “Using the HashiCorp Vault Keyring Plugin”

vi

Section 23.2.3, “Initial Configuration of NDB Cluster”
Section 4.5.1.2, “mysql Client Commands”
Section 3.3.4.7, “Pattern Matching”

W

[index top]

watch

Section 28.4.4.25, “The statement_performance_analyzer() Procedure”

WinDbg

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

windbg.exe

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

winMd5Sum

Section 2.1.4.1, “Verifying the MD5 Checksum”

WinZip

Section 17.4.1.2, “Backing Up Raw Data from a Replica”
Section 2.9.4, “Installing MySQL Using a Standard Source Distribution”
Section 2.9.2, “Source Installation Prerequisites”

WordPad

Section 13.2.7, “LOAD DATA Statement”

X

[index top]

xz

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

Y

[index top]

yacc

Section 2.9.8, “Dealing with Problems Compiling MySQL”
Section 9.3, “Keywords and Reserved Words”

yum

Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 23.2.1.2, “Installing NDB Cluster from RPM”
Section 2.11.7, “Upgrading MySQL with the MySQL Yum Repository”

yum install

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

yum update

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

yum-config-manager

Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”

Z

[index top]

zip

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

zlib_decompress

Section 4.8.1, “lz4_decompress — Decompress mysqlpump LZ4-Compressed Output”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.3, “zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output”

zsh

Section 4.2.9, “Setting Environment Variables”

zypper

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