Command Index

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

A

[index top]

Access

Section 13.2.2, “DELETE Syntax”

addgroup

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

addr2line

Section 23.4.1.5, “Using a Stack Trace”

adduser

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

apt-get

Section 16.6.1, “Installing memcached
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 16.6.3.3, “Using libmemcached with C and C++”

B

[index top]

bash

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

binary-configure.sh

Section 1.4, “What Is New in MySQL 5.7”

bison

Section 1.9.1, “Contributors to MySQL”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.8, “Installing MySQL from Source”

bzr

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

C

[index top]

c++filt

Section 23.4.1.5, “Using a Stack Trace”

cat

Section 4.5.1.1, “mysql Options”

chkconfig

Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”

CMake

Section 10.3, “Adding a Character Set”
Section B.5.2.17, “Can't initialize character set”
Section 23.2.4.3, “Compiling and Installing Plugin Libraries”
Section 23.3.2.5, “Compiling and Installing User-Defined Functions”
Section 6.3.11.2, “Configuring MySQL for SSL”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 2.11, “Environment Variables”
Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 2.8, “Installing MySQL from Source”
Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 23.2.5, “MySQL Services for Plugins”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 21.2.1, “Performance Schema Build Configuration”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.4, “Server System Variables”
Section 15.5, “The ARCHIVE Storage Engine”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 15.9, “The EXAMPLE Storage Engine”
Section 15.8, “The FEDERATED Storage Engine”
Section 1.3.2, “The Main Features of MySQL”
Section 5.4, “Tracing mysqld Using DTrace”
Section 4.2.6, “Using Option Files”
Section 23.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 23.2.4.11.2, “Using Your Own Protocol Trace Plugins”
Section 1.4, “What Is New in MySQL 5.7”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

cmake

Section 23.3.2.5, “Compiling and Installing User-Defined Functions”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 14.18.4.1, “Password-Protecting the memcached Interface through SASL”

cmd

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

cmd.exe

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

command.com

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

comp_err

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

configure

Section 1.7, “How to Report Bugs or Problems”
Section 16.6.1, “Installing memcached
Section 1.2, “Typographical and Syntax Conventions”
Section 16.6.3.3, “Using libmemcached with C and C++”
Section 16.6.3.6, “Using MySQL and memcached with PHP”

copy

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

coreadm

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

cp

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.1, “Backup and Recovery Types”
Section 17.1.1.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 17.1.1.7, “Introducing Additional Slaves to an Existing Replication Environment”

crash-me

Section 8.12.2, “The MySQL Benchmark Suite”

cron

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 13.7.2.2, “CHECK TABLE Syntax”
Section 15.2.1, “MyISAM Startup Options”
Section 5.2.7, “Server Log Maintenance”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 3.5, “Using mysql in Batch Mode”

csh

Section 4.2.1, “Invoking MySQL Programs”
Section 4.2.10, “Setting Environment Variables”
Section 1.2, “Typographical and Syntax Conventions”

D

[index top]

date

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

dd

Section 16.4.1, “Setting Up MySQL on an EC2 AMI”

delete

Section 14.18.7, “Internals of the InnoDB memcached Plugin”

df

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

Directory Utility

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

drwtsn32.exe

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

dump

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

E

[index top]

emerge

Section 16.6.1, “Installing memcached
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”

F

[index top]

flush

Section 14.18.7, “Internals of the InnoDB memcached Plugin”

G

[index top]

gcc

Section 23.3.2.5, “Compiling and Installing User-Defined Functions”
Section 22.7.1, “Compiling Programs with libmysqld”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 2.12.3, “Problems Using the Perl DBI/DBD Interface”
Section 1.9.4, “Tools that were used to create MySQL”

gdb

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

get

Section 14.18.7, “Internals of the InnoDB memcached Plugin”

git branch

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

git checkout

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

gmake

Section 2.8, “Installing MySQL from Source”
Section 2.7, “Installing MySQL on FreeBSD”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”

GnuPG

Section 2.1.4.2, “Signature Checking Using GnuPG”

gnutar

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

gogoc

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

gpg

Section 2.1.4.2, “Signature Checking Using GnuPG”

grep

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

groupadd

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

gtar

Section 2.8, “Installing MySQL from Source”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

gunzip

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

gzip

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

H

[index top]

hdparm

Section 14.12, “InnoDB Startup Options and System Variables”

help contents

Section 4.5.1.4, “mysql Server-Side Help”

hostname

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

I

[index top]

icc

Section 2.1.6, “Compiler-Specific Build Characteristics”

ifconfig

Section 5.1.9.1, “Verifying System Support for IPv6”

innochecksum

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

install.rb

Section 16.6.3.7, “Using MySQL and memcached with Ruby”

K

[index top]

kill

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section D.6, “Restrictions on XA Transactions”

ksh

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

L

[index top]

ldconfig

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

less

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

libmemcached

Section 16.6.3.3.6, “libmemcached Command-Line Utilities”

ln

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

logger

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

lsof +L1

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

M

[index top]

m4

Section 2.8, “Installing MySQL from Source”

make

Section 23.2.4.3, “Compiling and Installing Plugin Libraries”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 16.6.1, “Installing memcached
Section 2.8, “Installing MySQL from Source”
Section 2.7, “Installing MySQL on FreeBSD”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.12.3, “Problems Using the Perl DBI/DBD Interface”

make install

Section 23.2.4.3, “Compiling and Installing Plugin Libraries”
Section 16.6.1, “Installing memcached

make package

Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.8.4, “MySQL Source-Configuration Options”

make test

Section 2.8.3, “Installing MySQL Using a Development Source Tree”
Section 2.12.1, “Installing Perl on Unix”
Section 23.1.2, “The MySQL Test Suite”

make VERBOSE=1

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

memcache

Section 16.6.2.4, “memcached Hashing/Distribution Types”
Section 16.6.3.5, “Using MySQL and memcached with Python”

memcached

Section 14.18.5.2, “Adapting an Existing memcached Application for the Integrated memcached Daemon”
Section 14.18.5.1, “Adapting an Existing MySQL Schema for a memcached Application”
Section 14.18.5.5, “Adapting DML Statements to memcached Operations”
Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 16.6.3.1, “Basic memcached Operations”
Section 14.18.1, “Benefits of the InnoDB / memcached Combination”
Section 14.18.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 16.6.2.3, “Data Expiry”
Section 16.4.3, “Deploying a MySQL Database Using EC2”
Section 16.6.3, “Developing a memcached Application”
Section 16.6.4, “Getting memcached Statistics”
Section 14.18.3, “Getting Started with InnoDB Memcached Plugin”
Section 14.18, “InnoDB Integration with memcached”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.18.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 16.6.1, “Installing memcached
Section 14.18.7, “Internals of the InnoDB memcached Plugin”
Section 16.6.3.3.6, “libmemcached Command-Line Utilities”
Section 16.6.3.3.3, “libmemcached Set Functions”
Section 16.6.2.1, “memcached Deployment”
Section 16.6.4.5, “memcached Detail Statistics”
Section 16.6.5, “memcached FAQ”
Section 16.6.4.1, “memcached General Statistics”
Section 16.6.2.4, “memcached Hashing/Distribution Types”
Section 16.6.4.3, “memcached Item Statistics”
Section 16.6.2.8, “memcached Logs”
Section 16.6.4.4, “memcached Size Statistics”
Section 16.6.4.2, “memcached Slabs Statistics”
Section 16.6.2.7, “memcached Thread Support”
Section 16.6.2.6, “Memory Allocation within memcached
MySQL Glossary
Section 14.18.4.1, “Password-Protecting the memcached Interface through SASL”
Section 14.18.5.6, “Performing DML and DDL Statements on the Underlying InnoDB Table”
Section 14.18.3.1, “Prerequisites for the InnoDB memcached Plugin”
Section 14.18.4, “Security Considerations for the InnoDB memcached Plugin”
Section 16.4.1, “Setting Up MySQL on an EC2 AMI”
Section 14.18.8, “Troubleshooting the InnoDB memcached Plugin”
Section 14.18.5.3, “Tuning Performance of the InnoDB memcached Plugin”
Section 16.6.3.3, “Using libmemcached with C and C++”
Section 16.6.2, “Using memcached
Section 16.6.2.5, “Using memcached and DTrace”
Section 16.6.3.2, “Using memcached as a MySQL Caching Layer”
Section 16.6.4.6, “Using memcached-tool
Section 16.6.3.8, “Using MySQL and memcached with Java”
Section 16.6.3.4, “Using MySQL and memcached with Perl”
Section 16.6.3.6, “Using MySQL and memcached with PHP”
Section 16.6.3.5, “Using MySQL and memcached with Python”
Section 16.6.3.7, “Using MySQL and memcached with Ruby”
Section 16.6, “Using MySQL with memcached
Section 16.6.2.2, “Using Namespaces”
Section 14.18.6, “Using the InnoDB memcached Plugin with Replication”
Section 16.6.3.9, “Using the memcached TCP Text Protocol”
Section 14.18.3.3, “Verifying the InnoDB and memcached Setup”
Section 14.18.5, “Writing Applications for the InnoDB memcached Interface”

memcached-1.2.5 directory:

Section 16.6.1, “Installing memcached

memcached-tool

Section 16.6.4, “Getting memcached Statistics”
Section 16.6.4.6, “Using memcached-tool

memcapable

Section 14.18.2, “Architecture of InnoDB and memcached Integration”

memcat

Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 16.6.3.3.6, “libmemcached Command-Line Utilities”
Section 14.18.3.3, “Verifying the InnoDB and memcached Setup”

memcp

Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 16.6.3.3.6, “libmemcached Command-Line Utilities”

memflush

Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 16.6.3.3.6, “libmemcached Command-Line Utilities”

memrm

Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 16.6.3.3.6, “libmemcached Command-Line Utilities”

memslap

Section 16.6.3.3.6, “libmemcached Command-Line Utilities”
Section 14.18.5.3, “Tuning Performance of the InnoDB memcached Plugin”

mkdir

Section 13.1.8, “CREATE DATABASE Syntax”

mklink

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

more

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

msql2mysql

Section 1.4, “What Is New in MySQL 5.7”

mv

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

my_print_defaults

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

myisam_ftdump

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

myisamchk

Section 13.7.2.1, “ANALYZE TABLE Syntax”
Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 10.5, “Character Set Configuration”
Section 13.7.2.2, “CHECK TABLE Syntax”
Section 15.2.3.3, “Compressed Table Characteristics”
Section 15.2.4.1, “Corrupted MyISAM Tables”
Section 7.2, “Database Backup Methods”
Section 23.4.1, “Debugging a MySQL Server”
Section 13.2.2, “DELETE Syntax”
Section 15.2.3.2, “Dynamic Table Characteristics”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.10.5, “External Locking”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 7.6.2, “How to Check MyISAM Tables for Errors”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section D.10.3, “Limits on Table Size”
Section 13.7.6.5, “LOAD INDEX INTO CACHE Syntax”
Section 18.3.4, “Maintenance of Partitions”
Section 23.4.1.7, “Making a Test Case If You Experience Table Corruption”
Section 15.2.1, “MyISAM Startup Options”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 7.6.4, “MyISAM Table Optimization”
Section 15.2.3, “MyISAM Table Storage Formats”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3.6, “myisamchk Memory Usage”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 4.6.3.4, “Other myisamchk Options”
Section 8.2.5, “Other Optimization Tips”
Section 4.1, “Overview of MySQL Programs”
Section 15.2.4.2, “Problems from Tables Not Being Closed Properly”
Section 13.7.2.5, “REPAIR TABLE Syntax”
Section 18.6, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server Command Options”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.7.5.21, “SHOW INDEX Syntax”
Section 13.7.5.35, “SHOW TABLE STATUS Syntax”
Section 8.6.3, “Speed of REPAIR TABLE Statements”
Section 15.2.3.1, “Static (Fixed-Length) Table Characteristics”
Section 8.11.1, “System Factors and Startup Parameter Tuning”
Section 1.3.2, “The Main Features of MySQL”
Section 15.2, “The MyISAM Storage Engine”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 23.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.11.3.1.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

myisamchk *.MYI

Section 7.6.3, “How to Repair MyISAM Tables”

myisamchk tbl_name

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

myisamlog

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

myisampack

Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 15.2.3.3, “Compressed Table Characteristics”
Section 13.1.14, “CREATE TABLE Syntax”
Section 8.10.5, “External Locking”
Section D.10.3, “Limits on Table Size”
Section 15.7.1, “MERGE Table Advantages and Disadvantages”
Section 15.2.3, “MyISAM Table Storage Formats”
Section 4.6.3.3, “myisamchk Repair Options”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section 4.6.3.5, “Obtaining Table Information with myisamchk”
Section 8.4.1, “Optimizing Data Size”
Section 4.1, “Overview of MySQL Programs”
Section 18.6, “Restrictions and Limitations on Partitioning”
Section 13.1.14.3, “Silent Column Specification Changes”
Section 15.7, “The MERGE Storage Engine”
Section 15.2, “The MyISAM Storage Engine”

mysql

Section 1.8.2.5, “'--' as the Start of a Comment”
Section 6.3.2, “Adding User Accounts”
Section 13.1.6.1, “ALTER TABLE Partition Operations”
Section 7.1, “Backup and Recovery Types”
Section 13.6.1, “BEGIN ... END Compound-Statement Syntax”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 9.6, “Comment Syntax”
Section 14.13.16.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 10.1.5, “Configuring the Character Set and Collation for Applications”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 5.1.9.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.9.3, “Connecting Using the IPv6 Local Host Address”
Section 10.1.4, “Connection Character Sets and Collations”
Section 1.9.1, “Contributors to MySQL”
Section 22.8.16, “Controlling Automatic Reconnection Behavior”
Section 14.6.4, “Converting Tables from MyISAM to InnoDB”
Section 2.10.5, “Copying MySQL Databases to Another Machine”
Section 13.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 3.3.1, “Creating and Selecting a Database”
Section 14.5.1, “Creating the InnoDB Tablespace”
Section 2.3.5.6, “Customizing the PATH for MySQL Tools”
Section 23.4.2, “Debugging a MySQL Client”
Section 19.1, “Defining Stored Programs”
Section 4.5.1.6.5, “Disabling mysql Auto-Reconnect”
Section 2.10.2, “Downgrading MySQL”
Section 14.15.2, “Enabling InnoDB Monitors”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 3.2, “Entering Queries”
Section 2.11, “Environment Variables”
Section 19.4.2, “Event Scheduler Configuration”
Section 7.3, “Example Backup and Recovery Strategy”
Section 22.8.3, “Example C API Client Programs”
Section 3.6, “Examples of Common Queries”
Section 14.11.5, “Examples of Online DDL”
Section 18.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 4.5.1.5, “Executing SQL Statements from a Text File”
Chapter 12, Functions and Operators
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section 13.6.7.3, “GET DIAGNOSTICS Syntax”
Section 13.7.1.4, “GRANT Syntax”
Section 13.8.3, “HELP Syntax”
Section 14.2.12, “How to Cope with Deadlocks”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section B.5.2.15, “Ignoring user”
Section 12.14, “Information Functions”
Section 14.16, “InnoDB Backup and Recovery”
Section 4.5.1.6.1, “Input-Line Editing”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 4.2.1, “Invoking MySQL Programs”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.7, “LOAD XML Syntax”
Section 7.4.5.1, “Making a Copy of a Database”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 8.12.1, “Measuring the Speed of Expressions and Functions”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 4.5.1.2, “mysql Commands”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 10.6, “MySQL Server Time Zone Support”
Section 4.5.1.4, “mysql Server-Side Help”
Section 4.5.1.6, “mysql Tips”
Section 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 22.8.7.14, “mysql_errno()”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 22.8.7.71, “mysql_sqlstate()”
Section 4.4.5, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 8.2.1.19, “Optimizing LIMIT Queries”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.2.8, “Out of memory”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 6.3.8, “Pluggable Authentication”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 2.9.1.1, “Problems Running mysql_install_db”
Section 4.2.5, “Program Option Modifiers”
Section 18.2.3.1, “RANGE COLUMNS partitioning”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 17.4.1.27, “Replication of Server-Side Help Tables”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section D.9, “Restrictions on Pluggable Authentication”
Section 13.7.1.6, “REVOKE Syntax”
Section 2.9.2, “Securing the Initial MySQL Accounts”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 5.1.3, “Server Command Options”
Section B.3, “Server Error Codes and Messages”
Section 5.1.4, “Server System Variables”
Section 5.1.10, “Server-Side Help”
Section 13.7.5.33, “SHOW SLAVE STATUS Syntax”
Section 13.6.7.5, “SIGNAL Syntax”
Section 4.2.3, “Specifying Program Options”
Section 13.5, “SQL Syntax for Prepared Statements”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 9.1.1, “String Literals”
Section 11.4.3, “The BLOB and TEXT Types”
Section 6.3.9.6, “The Cleartext Client-Side Authentication Plugin”
Section 6.3.9.4, “The SHA-256 Authentication Plugin”
Section 6.3.9.7, “The Socket Peer-Credential Authentication Plugin”
Section 19.3.1, “Trigger Syntax and Examples”
Section 14.19.3, “Troubleshooting InnoDB Data Dictionary Operations”
Chapter 3, Tutorial
Section 1.2, “Typographical and Syntax Conventions”
Section 4.5.1.6.2, “Unicode Support on Windows”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 7.3.2, “Using Backups for Recovery”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 3.5, “Using mysql in Batch Mode”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 7.4, “Using mysqldump for Backups”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”
Section 4.2.8, “Using Options to Set Program Variables”
Section 23.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 6.3.11.3, “Using SSL Connections”
Section 4.5.1.6.4, “Using the --safe-updates Option”
Section 23.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 23.2.4.11.2, “Using Your Own Protocol Trace Plugins”
Section 1.4, “What Is New in MySQL 5.7”
Section 2.3.8, “Windows Postinstallation Procedures”
Section 12.11, “XML Functions”

mysql < dump_file

Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”

mysql ...

Section 23.4.1.1, “Compiling MySQL for Debugging”

mysql-server

Section 2.7, “Installing MySQL on FreeBSD”

mysql-test-run.pl

Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 23.1.2, “The MySQL Test Suite”
Section 4.2.6, “Using Option Files”

mysql-test-run.pl test_name

Section 23.1.2, “The MySQL Test Suite”

mysql.exe

Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 4.5.1.6.2, “Unicode Support on Windows”

mysql.script

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

mysql.server

Section 2.5, “Installing MySQL on Linux”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.6.8, “mysqldumpslow — Summarize Slow Query Log Files”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.3, “Server Command Options”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section B.5.4.6, “Time Zone Problems”

mysql.server stop

Section 2.9.1.2, “Starting and Stopping MySQL Automatically”

mysql_config

Section 22.8.4.1, “Building C API Client Programs”
Section 22.7.1, “Compiling Programs with libmysqld”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 22.8.1, “MySQL C API Implementations”
Section 4.7.1, “mysql_config — Display Options for Compiling Clients”
Section 4.1, “Overview of MySQL Programs”
Section 23.2.2, “Plugin API Components”

mysql_config_editor

Section 4.2.7, “Command-Line Options that Affect Option-File Handling”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 2.11, “Environment Variables”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 4.6.3.1, “myisamchk General Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.6.7, “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, “mysqlshow — Display Database, Table, and Column Information”
Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.1, “Overview of MySQL Programs”
Section 5.1.3, “Server Command Options”
Section 4.2.6, “Using Option Files”

mysql_convert_table_format

Section 1.4, “What Is New in MySQL 5.7”

mysql_find_rows

Section 1.4, “What Is New in MySQL 5.7”

mysql_fix_extensions

Section 1.4, “What Is New in MySQL 5.7”

mysql_install_db

Section 6.3.2, “Adding User Accounts”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.6.2, “Installing MySQL on OpenSolaris Using IPS”
Section 2.4.2, “Installing MySQL on OS X Using Native Packages”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 14.6.7, “Limits on InnoDB Tables”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.1, “Overview of MySQL Programs”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 2.9.1.1, “Problems Running mysql_install_db”
Section 2.9.2, “Securing the Initial MySQL Accounts”
Section 5.1.3, “Server Command Options”
Section 5.1.2, “Server Configuration Defaults”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 5.1.10, “Server-Side Help”
Section 5.3.1, “Setting Up Multiple Data Directories”
Section 1.4, “What Is New in MySQL 5.7”

mysql_plugin

Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.1, “Overview of MySQL Programs”

mysql_secure_installation

Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
Section 2.6.2, “Installing MySQL on OpenSolaris Using IPS”
Section 2.6.1, “Installing MySQL on Solaris Using a Solaris PKG”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.4, “mysql_secure_installation — Improve MySQL Installation Security”
Section 4.1, “Overview of MySQL Programs”
Section 2.9.2, “Securing the Initial MySQL Accounts”

mysql_server_config

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

mysql_setpermission

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

mysql_stmt_execute()

Section 5.1.6, “Server Status Variables”

mysql_stmt_prepare()

Section 5.1.6, “Server Status Variables”

mysql_tzinfo_to_sql

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

mysql_upgrade

Section 13.1.1, “ALTER DATABASE Syntax”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 2.10.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 17.1.4.5, “Global Transaction ID Options and Variables”
Section 6.3.9.3, “Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.1, “Overview of MySQL Programs”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 21.2.1, “Performance Schema Build Configuration”
Section 6.2.2, “Privilege System Grant Tables”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 2.5.2, “Replacing a Third-Party Distribution of MySQL Using the MySQL Yum Repository”
Section 17.4.1.27, “Replication of Server-Side Help Tables”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section 5.1.3, “Server Command Options”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 2.10.1, “Upgrading MySQL”
Section 2.3.7, “Upgrading MySQL on Windows”
Section 2.10.1.1, “Upgrading MySQL with the MySQL Yum Repository”
Section 1.4, “What Is New in MySQL 5.7”
Section 11.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)”

mysql_waitpid

Section 1.4, “What Is New in MySQL 5.7”

mysql_zap

Section 1.4, “What Is New in MySQL 5.7”

mysqlaccess

Section 1.9.1, “Contributors to MySQL”
Section 1.7, “How to Report Bugs or Problems”
Section 1.4, “What Is New in MySQL 5.7”

mysqladmin

Section 6.3.5, “Assigning Account Passwords”
Section 17.3.1.1, “Backing Up a Slave Using mysqldump”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 1.9.1, “Contributors to MySQL”
Section 13.1.8, “CREATE DATABASE Syntax”
Section 2.3.5.6, “Customizing the PATH for MySQL Tools”
Section 23.4.1, “Debugging a MySQL Server”
Section 13.1.17, “DROP DATABASE Syntax”
Section 22.8.3, “Example C API Client Programs”
Section 13.7.6.3, “FLUSH Syntax”
Section 2.4.1, “General Notes on Installing MySQL on OS X”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 5.2, “MySQL Server Logs”
Section 4.6.6, “mysql_config_editor — MySQL Configuration Utility”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.1, “Overview of MySQL Programs”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 6.2.1, “Privileges Provided by MySQL”
Section D.9, “Restrictions on Pluggable Authentication”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 2.9.2, “Securing the Initial MySQL Accounts”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 6.3.9.6, “The Cleartext Client-Side Authentication Plugin”
Section 1.3.2, “The Main Features of MySQL”
Section 5.1.12, “The Shutdown Process”
Section 8.11.2, “Tuning Server Parameters”
Section 2.3.7, “Upgrading MySQL on Windows”
Section 4.2.6, “Using Option Files”
Section 4.2.4, “Using Options on the Command Line”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

mysqladmin debug

Section 23.4.1, “Debugging a MySQL Server”
Section 19.4.5, “Event Scheduler Status”
Section 13.7.1.4, “GRANT Syntax”
Section 6.2.1, “Privileges Provided by MySQL”

mysqladmin extended-status

Section 13.7.5.34, “SHOW STATUS Syntax”

mysqladmin flush-hosts

Section 6.2.7, “Causes of Access-Denied Errors”
Section 8.11.5.2, “DNS Lookup Optimization and the Host Cache”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 5.1.4, “Server System Variables”

mysqladmin flush-logs

Section 7.3.3, “Backup Strategy Summary”
Section 7.3.1, “Establishing a Backup Policy”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.2.7, “Server Log Maintenance”
Section 5.2.4, “The Binary Log”
Section 5.2.2, “The Error Log”
Section 17.2.2.1, “The Slave Relay Log”

mysqladmin flush-privileges

Section 6.2.7, “Causes of Access-Denied Errors”
Section 2.10.5, “Copying MySQL Databases to Another Machine”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.2.2, “Privilege System Grant Tables”
Section 2.9.1.1, “Problems Running mysql_install_db”
Section 5.1.3, “Server Command Options”
Section 6.2.6, “When Privilege Changes Take Effect”

mysqladmin flush-tables

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

mysqladmin flush-xxx

Section 6.3.2, “Adding User Accounts”

mysqladmin kill

Section B.5.4.3, “How MySQL Handles a Full Disk”
Section 13.7.6.4, “KILL Syntax”
Section 12.17, “Miscellaneous Functions”
Section B.5.2.9, “MySQL server has gone away”
Section 6.2.1, “Privileges Provided by MySQL”

mysqladmin password

Section 6.3.5, “Assigning Account Passwords”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

mysqladmin processlist

Section 6.3.2, “Adding User Accounts”
Section 8.12.5, “Examining Thread Information”
Section 13.7.6.4, “KILL Syntax”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 23.1.1, “MySQL Threads”
Section 22.8.7.44, “mysql_list_processes()”
Section 6.2.1, “Privileges Provided by MySQL”
Section 13.7.5.28, “SHOW PROCESSLIST Syntax”

mysqladmin processlist status

Section 23.4.1, “Debugging a MySQL Server”

mysqladmin refresh

Section 6.3.2, “Adding User Accounts”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 5.2.7, “Server Log Maintenance”

mysqladmin reload

Section 6.3.2, “Adding User Accounts”
Section 1.7, “How to Report Bugs or Problems”
Section 6.2.2, “Privilege System Grant Tables”
Section 2.9.1.1, “Problems Running mysql_install_db”
Section 5.1.3, “Server Command Options”
Section 6.3.4, “Setting Account Resource Limits”
Section 6.2.6, “When Privilege Changes Take Effect”

mysqladmin reload version

Section 1.7, “How to Report Bugs or Problems”

mysqladmin shutdown

Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 14.5.1, “Creating the InnoDB Tablespace”
Section 23.4.1.2, “Creating Trace Files”
Section 13.7.1.4, “GRANT Syntax”
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 OS X Using Native Packages”
Section 23.4.1.7, “Making a Test Case If You Experience Table Corruption”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 6.2.1, “Privileges Provided by MySQL”
Section 17.4.1.22, “Replication and Temporary Tables”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 5.1.12, “The Shutdown Process”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”

mysqladmin status

Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 22.8.7.73, “mysql_stat()”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

mysqladmin variables

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

mysqladmin variables extended-status processlist

Section 1.7, “How to Report Bugs or Problems”

mysqladmin ver

Section 23.4.1.1, “Compiling MySQL for Debugging”

mysqladmin version

Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 1.7, “How to Report Bugs or Problems”
Section B.5.2.9, “MySQL server has gone away”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section B.5.4.2, “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.1.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 14.16, “InnoDB Backup and Recovery”
Section 4.5.4, “mysqldump — A Database Backup Program”

mysqlbinlog

Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.7.6.1, “BINLOG Syntax”
Section 5.4.1.2, “Command Probes”
Section 17.1.3.1, “GTID Concepts”
Section 17.4.5, “How to Report Replication Bugs or Problems”
Section 14.16, “InnoDB Backup and Recovery”
Section B.5.8, “Known Issues in MySQL”
Section 12.17, “Miscellaneous Functions”
MySQL Glossary
Section 4.5.1.1, “mysql Options”
Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.1, “Overview of MySQL Programs”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 7.5.2, “Point-in-Time Recovery Using Event Positions”
Section 7.5.1, “Point-in-Time Recovery Using Event Times”
Section 17.4.1.34, “Replication and Variables”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.7.5.2, “SHOW BINLOG EVENTS Syntax”
Section 13.7.5.31, “SHOW RELAYLOG EVENTS Syntax”
Section 4.6.7.4, “Specifying the mysqlbinlog Server ID”
Section 13.4.2.6, “START SLAVE Syntax”
Section 5.2.4, “The Binary Log”
Section 17.2.2.1, “The Slave Relay Log”
Section 17.1.2.2, “Usage of Row-Based Logging and Replication”
Section 7.3.2, “Using Backups for Recovery”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 1.4, “What Is New in MySQL 5.7”

mysqlbinlog binary-log-file | mysql

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

mysqlbinlog|mysql

Section B.5.8, “Known Issues in MySQL”

mysqlbug

Section 1.4, “What Is New in MySQL 5.7”

mysqlcheck

Section 13.1.1, “ALTER DATABASE Syntax”
Section 2.10.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 18.3.4, “Maintenance of Partitions”
Section 9.2.3, “Mapping of Identifiers to File Names”
Section 4.7.2, “my_print_defaults — Display Options from Option Files”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.4.6, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 4.1, “Overview of MySQL Programs”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 18.6, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”
Section 1.3.2, “The Main Features of MySQL”
Section 15.2, “The MyISAM Storage Engine”
Section 1.4, “What Is New in MySQL 5.7”

mysqld

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 23.3.2, “Adding a New User-Defined Function”
Section 23.3, “Adding New Functions to MySQL”
Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 5.2.4.1, “Binary Logging Formats”
Section 17.1.4.4, “Binary Logging Options and Variables”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section B.5.2.13, “Can't create/write to file”
Section B.5.2.17, “Can't initialize character set”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section B.5.2.4, “Client does not support authentication protocol”
Section 9.6, “Comment Syntax”
Section B.5.2.11, “Communication Errors and Aborted Connections”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 23.3.2.5, “Compiling and Installing User-Defined Functions”
Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 6.3.11.2, “Configuring MySQL for SSL”
Section 14.18.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 15.2.4.1, “Corrupted MyISAM Tables”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 14.5.1, “Creating the InnoDB Tablespace”
Section 23.4.1.2, “Creating Trace Files”
Section 23.4.1, “Debugging a MySQL Server”
Section 23.4, “Debugging and Porting MySQL”
Section 23.4.1.4, “Debugging mysqld under gdb”
Section 2.10.2.1, “Downgrading to MySQL 5.6”
Section 14.15.2, “Enabling InnoDB Monitors”
Section 2.11, “Environment Variables”
Section 8.10.5, “External Locking”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 14.19.2, “Forcing InnoDB Recovery”
Section 8.12.5.2, “General Thread States”
Section 16.5.3, “Handling MySQL Recovery with ZFS”
Section B.5.2.6, “Host 'host_name' is blocked”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.11.4.1, “How MySQL Uses Memory”
Section 8.2.1.20, “How to Avoid Full Table Scans”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 9.2.2, “Identifier Case Sensitivity”
Section B.5.2.15, “Ignoring user”
Section 12.14, “Information Functions”
Section 14.16, “InnoDB Backup and Recovery”
Section 14.3, “InnoDB Configuration”
Section 14.10.1, “InnoDB Disk I/O”
Section 14.5.2, “InnoDB File-Per-Table Mode”
Section 14.12, “InnoDB Startup Options and System Variables”
Section 14.19, “InnoDB Troubleshooting”
Section 13.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 13.2.5, “INSERT Syntax”
Section 14.18.3.2, “Installing and Configuring the InnoDB memcached Plugin”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 2.4.2, “Installing MySQL on OS X Using Native Packages”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 13.7.6.4, “KILL Syntax”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 23.4.1.7, “Making a Test Case If You Experience Table Corruption”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 12.17, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 14.6.2, “Moving or Copying InnoDB Tables to Another Machine”
Section 15.2.1, “MyISAM Startup Options”
Section 4.6.3.2, “myisamchk Check Options”
Section 4.6.3.1, “myisamchk General Options”
Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
Section A.1, “MySQL 5.7 FAQ: General”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
MySQL Glossary
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows”
Chapter 5, MySQL Server Administration
Section 4.3, “MySQL Server and Server-Startup Programs”
Section B.5.2.9, “MySQL server has gone away”
Section 5.2, “MySQL Server Logs”
Section 10.6, “MySQL Server Time Zone Support”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 1.8, “MySQL Standards Compliance”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 22.8.7.1, “mysql_affected_rows()”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 22.8.7.50, “mysql_options()”
Section 4.4.3, “mysql_plugin — Configure MySQL Server Plugins”
Section 4.6.7, “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 13.7.2.4, “OPTIMIZE TABLE Syntax”
Section B.5.6, “Optimizer-Related Issues”
Section 22.7.3, “Options with the Embedded Server”
Section 4.1, “Overview of MySQL Programs”
Section 14.11.1, “Overview of Online DDL”
Section B.5.2.10, “Packet Too Large”
Section 21.2.2, “Performance Schema Startup Configuration”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section 6.2.2, “Privilege System Grant Tables”
Section 15.2.4.2, “Problems from Tables Not Being Closed Properly”
Section 2.9.1.1, “Problems Running mysql_install_db”
Section B.5.3.1, “Problems with File Permissions”
Section 4.2.5, “Program Option Modifiers”
Section 8.9.3.3, “Query Cache Configuration”
Section 13.7.2.5, “REPAIR TABLE Syntax”
Section 17.1.4.1, “Replication and Binary Logging Option and Variable Reference”
Section 17.1.4, “Replication and Binary Logging Options and Variables”
Section 17.1.4.2, “Replication Master Options and Variables”
Section 17.2.2, “Replication Relay and Status Logs”
Section 17.1.4.3, “Replication Slave Options and Variables”
Section 13.4.2.4, “RESET SLAVE Syntax”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section B.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 6.1.4, “Security-Related mysqld Options and Variables”
Section 13.2.9.1, “SELECT ... INTO Syntax”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 10.1.3.1, “Server Character Set and Collation”
Section 5.1.3, “Server Command Options”
Section 23.2.4.2.2, “Server Plugin Status and System Variables”
Section 5.1.11, “Server Response to Signals”
Section 5.1.6, “Server Status Variables”
Section 5.1.4, “Server System Variables”
Section 13.3.6, “SET TRANSACTION Syntax”
Section 10.2, “Setting the Error Message Language”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 13.7.5.38, “SHOW VARIABLES Syntax”
Section 22.8.2, “Simultaneous MySQL Server and Connector/C Installations”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.3.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 2.3.5.5, “Starting MySQL from the Windows Command Line”
Section 10.6.1, “Staying Current with Time Zone Changes”
Section 1.9.5, “Supporters of MySQL”
Section 17.3.6, “Switching Masters During Failover”
Section 8.10.2, “Table Locking Issues”
Section B.5.2.19, “Table-Corruption Issues”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 5.2.4, “The Binary Log”
Section 15.6, “The BLACKHOLE Storage Engine”
Section 23.4.3, “The DBUG Package”
Section 5.2.2, “The Error Log”
Section 5.2.3, “The General Query Log”
Section 15.2, “The MyISAM Storage Engine”
Section 8.9.3, “The MySQL Query Cache”
Section 5.1, “The MySQL Server”
Section 23.1.2, “The MySQL Test Suite”
Section 5.2.5, “The Slow Query Log”
Section B.5.4.6, “Time Zone Problems”
Section B.5.2.7, “Too many connections”
Section 5.4, “Tracing mysqld Using DTrace”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 14.19.1, “Troubleshooting InnoDB I/O Problems”
Section 8.11.2, “Tuning Server Parameters”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.10.1, “Upgrading MySQL”
Section 2.3.7, “Upgrading MySQL on Windows”
Section 23.3.2.6, “User-Defined Function Security Precautions”
Section 23.4.1.5, “Using a Stack Trace”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.6, “Using Option Files”
Section 23.4.1.3, “Using pdb to create a Windows crashdump”
Section 23.4.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.11.3.1.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section 14.18.6, “Using the InnoDB memcached Plugin with Replication”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
Section 6.2.6, “When Privilege Changes Take Effect”
Section B.5.4.4, “Where MySQL Stores Temporary Files”
Section 2.1.2, “Which MySQL Version and Distribution to Install”
Section 23.2.4, “Writing Plugins”

mysqld mysqld.trace

Section 23.4.1.2, “Creating Trace Files”

mysqld-5.6

Section 2.10.1, “Upgrading MySQL”

mysqld-debug

Section 23.4.1.2, “Creating Trace Files”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 5.3.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”

mysqld_multi

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

mysqld_safe

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 23.4.1.1, “Compiling MySQL for Debugging”
Section 14.5.1, “Creating the InnoDB Tablespace”
Section 2.10.2.1, “Downgrading to MySQL 5.6”
Section 8.11.4.2, “Enabling Large Page Support”
Section B.5.4.5, “How to Protect or Change the MySQL Unix Socket File”
Section 14.19, “InnoDB Troubleshooting”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 10.6, “MySQL Server Time Zone Support”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section 4.2.9, “Option Defaults, Options Expecting Values, and the = Sign”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.10, “Packet Too Large”
Section 2.9.1, “Postinstallation Procedures for Unix-like Systems”
Section B.5.3.1, “Problems with File Permissions”
Section 5.3, “Running Multiple MySQL Instances on One Machine”
Section 5.3.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.3, “Server Command Options”
Section 5.1.2, “Server Configuration Defaults”
Section 5.1.4, “Server System Variables”
Section 17.1.3.2, “Setting Up Replication Using GTIDs”
Section 2.9.1.2, “Starting and Stopping MySQL Automatically”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”
Section 5.2.2, “The Error Log”
Section B.5.4.6, “Time Zone Problems”
Section 8.11.2, “Tuning Server Parameters”
Section 4.2.6, “Using Option Files”
Section 1.4, “What Is New in MySQL 5.7”

mysqldump

Section 17.3.1.3, “Backing Up a Master or Slave by Making It Read Only”
Section 17.3.1.1, “Backing Up a Slave Using mysqldump”
Chapter 7, Backup and Recovery
Section 7.1, “Backup and Recovery Types”
Section 7.3.3, “Backup Strategy Summary”
Section 8.5.4, “Bulk Data Loading for InnoDB Tables”
Section 6.2.7, “Causes of Access-Denied Errors”
Section 14.5.8, “Changing the Number or Size of InnoDB Log Files and Resizing the InnoDB Tablespace”
Section 2.10.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 17.1.1.5, “Choosing a Method for Data Snapshots”
Section 4.2.2, “Connecting to the MySQL Server”
Section 1.9.1, “Contributors to MySQL”
Section 7.4.5.2, “Copy a Database from one Server to Another”
Section 2.10.5, “Copying MySQL Databases to Another Machine”
Section 14.5.5, “Copying Tablespaces to Another Server (Transportable Tablespaces)”
Section 13.1.14, “CREATE TABLE Syntax”
Section 17.1.1.5.1, “Creating a Data Snapshot Using mysqldump”
Section 14.6.1, “Creating InnoDB Tables”
Section 2.3.5.6, “Customizing the PATH for MySQL Tools”
Section 7.2, “Database Backup Methods”
Section 14.10.4, “Defragmenting a Table”
Section 2.10.2, “Downgrading MySQL”
Section 7.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 7.4.1, “Dumping Data in SQL Format with mysqldump”
Section 7.4.5.3, “Dumping Stored Programs”
Section 7.4.5.4, “Dumping Table Definitions and Content Separately”
Section 16.4.2, “EC2 Instance Limitations”
Section 14.5.3, “Enabling and Disabling File-Per-Table Mode”
Section 7.3.1, “Establishing a Backup Policy”
Section 7.3, “Example Backup and Recovery Strategy”
Section 1.8.2.4, “Foreign Key Differences”
Section 1.7, “How to Report Bugs or Problems”
Section 9.2.2, “Identifier Case Sensitivity”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 14.16, “InnoDB Backup and Recovery”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section 13.2.7, “LOAD XML Syntax”
Section 7.4.5.1, “Making a Copy of a Database”
Section 9.2.3, “Mapping of Identifiers to File Names”
Section 14.6.2, “Moving or Copying InnoDB Tables to Another Machine”
Section 4.5.1.1, “mysql Options”
Section 5.2, “MySQL Server Logs”
Section 7.4.5, “mysqldump Tips”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 17.1.1.4, “Obtaining the Replication Master Binary Log Coordinates”
Section 4.1, “Overview of MySQL Programs”
Section B.5.5.8, “Problems with Floating-Point Values”
Section 2.10.4, “Rebuilding or Repairing Tables or Indexes”
Section 7.4.4, “Reloading Delimited-Text Format Backups”
Section 7.4.2, “Reloading SQL-Format Backups”
Section 17.3.4, “Replicating Different Databases to Different Slaves”
Section D.8, “Restrictions on Performance Schema”
Section 17.1.3.4, “Restrictions on Replication with GTIDs”
Section D.5, “Restrictions on Views”
Section 5.2.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.2.7, “Server Log Maintenance”
Section 5.1.7, “Server SQL Modes”
Section 5.1.4, “Server System Variables”
Section 17.1.1.6.2, “Setting Up Replication with Existing Data”
Section B.5.5.7, “Solving Problems with No Matching Rows”
Section 4.2.3, “Specifying Program Options”
Section 2.3.5.7, “Starting MySQL as a Windows Service”
Section 11.4.3, “The BLOB and TEXT Types”
Section 8.9.1, “The InnoDB Buffer Pool”
Section 1.3.2, “The Main Features of MySQL”
Section 13.7.3.4, “UNINSTALL PLUGIN Syntax”
Section 2.10.1.3, “Upgrading from MySQL 5.6 to 5.7”
Section 10.1.11, “Upgrading from Previous to Current Unicode Support”
Section 13.1.14.2, “Using FOREIGN KEY Constraints”
Section 17.1.3.3, “Using GTIDs for Failover and Scaleout”
Section 4.6.7.3, “Using mysqlbinlog to Back Up Binary Log Files”
Section 7.4, “Using mysqldump for Backups”
Section 17.3.1, “Using Replication for Backups”
Section 17.3.2, “Using Replication with Different Master and Slave Storage Engines”
Section 14.18.6, “Using the InnoDB memcached Plugin with Replication”
Section 1.4, “What Is New in MySQL 5.7”
Section 12.11, “XML Functions”
Section 11.3.4, “YEAR(2) Limitations and Migrating to YEAR(4)”

mysqldump mysql

Section 6.2.7, “Causes of Access-Denied Errors”

mysqldumpslow

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

mysqlfailover

Section 17.3.6, “Switching Masters During Failover”

mysqlhotcopy

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

mysqlimport

Section 7.1, “Backup and Recovery Types”
Section 2.10.5, “Copying MySQL Databases to Another Machine”
Section 7.2, “Database Backup Methods”
Section 2.10.2, “Downgrading MySQL”
Section 13.2.6, “LOAD DATA INFILE Syntax”
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 Issues with LOAD DATA LOCAL”

MySQLInstallerConsole

Section 2.3.3.2, “MySQL Installer Console”

mysqloptimize

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlrepair

Section 4.5.3, “mysqlcheck — A Table Maintenance Program”

mysqlshow

Section 4.2.2, “Connecting to the MySQL Server”
Section 22.8.3, “Example C API Client Programs”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 4.1, “Overview of MySQL Programs”
Section 13.7.5.13, “SHOW DATABASES Syntax”
Section 13.7.5.21, “SHOW INDEX Syntax”
Section 13.7.5.35, “SHOW TABLE STATUS Syntax”
Section 2.3.5.8, “Testing The MySQL Installation”
Section 2.3.8, “Windows Postinstallation Procedures”

mysqlshow db_name

Section 13.7.5.36, “SHOW TABLES Syntax”

mysqlshow db_name tbl_name

Section 13.7.5.5, “SHOW COLUMNS Syntax”

mysqlshow mysql user

Section B.5.2.15, “Ignoring user”

mysqlslap

Section 4.5.7, “mysqlslap — Load Emulation Client”
Section 4.1, “Overview of MySQL Programs”
Section 6.3.9.6, “The Cleartext Client-Side Authentication Plugin”
Section 8.12.3, “Using Your Own Benchmarks”

mysqltest

Section 23.1.2, “The MySQL Test Suite”
Section 6.3.9.4, “The SHA-256 Authentication Plugin”

N

[index top]

ndb_restore

Section 7.1, “Backup and Recovery Types”

NET

Section 2.3.5.7, “Starting MySQL as a Windows Service”

NET START

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

NET START MySQL

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

NET STOP

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

NET STOP MySQL

Section 2.3.5.7, “Starting MySQL as a Windows Service”

nm

Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 23.4.1.5, “Using a Stack Trace”

O

[index top]

openssl

Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”

openssl md5 package_name

Section 2.1.4.1, “Verifying the MD5 Checksum”

P

[index top]

perror

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section B.5.2.13, “Can't create/write to file”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 14.19.6, “Operating System Error Codes”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.1, “perror — Explain Error Codes”
Section B.1, “Sources of Error Information”

pfexec

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

PGP

Section 2.1.4.2, “Signature Checking Using GnuPG”

ping6

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

pkg

Section 2.6.2, “Installing MySQL on OpenSolaris Using IPS”

pkgadd

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

pkgrm

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

ppm

Section 2.12, “Perl Installation Notes”

ps

Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 8.11.4.1, “How MySQL Uses Memory”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 2.9.1.3, “Starting and Troubleshooting the MySQL Server”

ps auxw

Section 4.2.2, “Connecting to the MySQL Server”

ps xa | grep mysqld

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

R

[index top]

rename

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

replace

Section 1.8.2.5, “'--' as the Start of a Comment”
Section 4.1, “Overview of MySQL Programs”
Section 4.8.2, “replace — A String-Replacement Utility”
Section 17.3.3, “Using Replication for Scale-Out”

resolve_stack_dump

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

resolveip

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

rm

Section 13.4.1.1, “PURGE BINARY LOGS Syntax”

rpm

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.1.4.4, “Signature Checking Using RPM”

rpmbuild

Section 2.8, “Installing MySQL from Source”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”

rsync

Section 7.1, “Backup and Recovery Types”
Section 17.1.1.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 17.1.1.7, “Introducing Additional Slaves to an Existing Replication Environment”

S

[index top]

scp

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

sed

Section 3.3.4.7, “Pattern Matching”

service

Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”

Service Control Manager

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

Services

Section 2.3.5.7, “Starting MySQL as a Windows Service”

set

Section 14.18.7, “Internals of the InnoDB memcached Plugin”

setenv

Section 4.2.10, “Setting Environment Variables”

setrlimit

Section 16.6.2, “Using memcached

sh

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

sleep

Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”

ssh

Section 16.5.1, “Using ZFS for File System Replication”

Start>Run>cmd.exe

Section 6.3.11.5, “Setting Up SSL Certificates and Keys for MySQL”

strings

Section 6.1.1, “Security Guidelines”

sudo

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”

System Preferences...

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

T

[index top]

tar

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section 7.1, “Backup and Recovery Types”
Section 17.1.1.5.2, “Creating a Data Snapshot Using Raw Data Files”
Section 3.3, “Creating and Using a Database”
Section 1.7, “How to Report Bugs or Problems”
Section 2.8, “Installing MySQL from Source”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 2.4, “Installing MySQL on OS X”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.6.1, “Installing MySQL on Solaris Using a Solaris PKG”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”
Section 2.12.1, “Installing Perl on Unix”
Section 17.1.1.7, “Introducing Additional Slaves to an Existing Replication Environment”
Section 22.8.2, “Simultaneous MySQL Server and Connector/C Installations”
Section 2.1.2, “Which MySQL Version and Distribution to Install”

tcpdump

Section 6.1.1, “Security Guidelines”

tcsh

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

tee

Section 4.5.1.2, “mysql Commands”

Telnet

Section 16.6.4, “Getting memcached Statistics”

telnet

Section 14.18.2, “Architecture of InnoDB and memcached Integration”
Section 16.6.4, “Getting memcached Statistics”
Section 6.1.1, “Security Guidelines”
Section 14.18.3.3, “Verifying the InnoDB and memcached Setup”

Terminal

Section 2.4, “Installing MySQL on OS X”

Text in this style

Section 1.2, “Typographical and Syntax Conventions”

top

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

U

[index top]

ulimit

Section B.5.2.18, “'File' Not Found and Similar Errors”
Section 8.11.4.2, “Enabling Large Page Support”
Section 4.3.2, “mysqld_safe — MySQL Server Startup Script”
Section B.5.2.10, “Packet Too Large”
Section 5.1.3, “Server Command Options”
Section 16.6.2, “Using memcached

useradd

Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 2.6, “Installing MySQL on Solaris and OpenSolaris”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”

usermod

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

V

[index top]

vi

Section 4.5.1.2, “mysql Commands”
Section 3.3.4.7, “Pattern Matching”

vmstat

Section 16.6.2, “Using memcached

W

[index top]

WinDbg

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

winMd5Sum

Section 2.1.4.1, “Verifying the MD5 Checksum”

WinZip

Section 17.3.1.2, “Backing Up Raw Data from a Slave”
Section 2.8, “Installing MySQL from Source”
Section 2.8.2, “Installing MySQL Using a Standard Source Distribution”

WordPad

Section 13.2.6, “LOAD DATA INFILE Syntax”

Y

[index top]

yacc

Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section 9.3, “Reserved Words”

yum

Section 16.6.1, “Installing memcached
Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
Section 2.5.5, “Installing MySQL on Linux Using RPM Packages”
Section 16.4.1, “Setting Up MySQL on an EC2 AMI”
Section 16.6.3.3, “Using libmemcached with C and C++”

yum install MySQL*rpm

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

yum update

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

yum update mysql-server

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

yum-config-manager

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

Z

[index top]

zfs recv

Section 16.5.1, “Using ZFS for File System Replication”

zip

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

zsh

Section 4.2.10, “Setting Environment Variables”