Command Index

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

A

[index top]

B

[index top]

C

[index top]

CMake

Section 10.13, “Adding a Character Set”
Section 28.4.2, “Adding a User-Defined Function”
Section 27.7.3.2, “Building C API Client Programs Using pkg-config”
Section 21.2.3.4, “Building NDB Cluster from Source on Linux”
Section B.4.2.16, “Can't initialize character set”
Section 21.2.4.2, “Compiling and Installing NDB Cluster from Source on Windows”
Section 28.2.4.3, “Compiling and Installing Plugin Libraries”
Section 10.5, “Configuring Application Character Set and Collation”
Section 2.9.6, “Configuring SSL Library Support”
Section 2.9.8, “Dealing with Problems Compiling MySQL”
Section 4.9, “Environment Variables”
Section B.4.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 14.15, “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.11, “Keyring System Variables”
Section 2.5.10, “Managing MySQL Server with systemd”
Chapter 21, MySQL NDB Cluster 7.5 and NDB Cluster 7.6
Section 21.5.9, “MySQL Server Usage for NDB Cluster”
Section 28.3, “MySQL Services for Plugins”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 27.7.6.50, “mysql_options()”
Section 25.2, “Performance Schema Build Configuration”
Section 27.6.2, “Restrictions When Using the Embedded MySQL Server”
Section 5.7.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.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 2.9.2, “Source Installation Prerequisites”
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.8, “Tracing mysqld Using DTrace”
Section 4.2.2.2, “Using Option Files”
Section 28.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 28.2.4.11.2, “Using Your Own Protocol Trace Plugins”
Section 1.4, “What Is New in MySQL 5.7”
Section B.4.3.3, “What to Do If MySQL Keeps Crashing”

D

[index top]

E

[index top]

G

[index top]

H

[index top]

I

[index top]

J

[index top]

K

[index top]

L

[index top]

M

[index top]

myisamchk

Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 13.7.2.2, “CHECK TABLE Statement”
Section 15.2.3.3, “Compressed Table Characteristics”
Section 15.2.4.1, “Corrupted MyISAM Tables”
Section 7.2, “Database Backup Methods”
Section 28.5.1, “Debugging a MySQL Server”
Section 13.2.2, “DELETE Statement”
Section 15.2.3.2, “Dynamic Table Characteristics”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.11.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 8.4.6, “Limits on Table Size”
Section 13.7.6.5, “LOAD INDEX INTO CACHE Statement”
Section 22.3.4, “Maintenance of Partitions”
Section 28.5.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.6.3.5, “Obtaining Table Information with myisamchk”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 8.6.3, “Optimizing REPAIR TABLE Statements”
Section 4.6.3.4, “Other myisamchk Options”
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 Statement”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 5.1.7, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.7.5.22, “SHOW INDEX Statement”
Section 13.7.5.36, “SHOW TABLE STATUS Statement”
Section 15.2.3.1, “Static (Fixed-Length) Table Characteristics”
Section 8.12.1, “System Factors”
Section 24.24, “The INFORMATION_SCHEMA STATISTICS Table”
Section 24.25, “The INFORMATION_SCHEMA TABLES Table”
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 28.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 8.12.3.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.4.3.3, “What to Do If MySQL Keeps Crashing”

mysql

Section 1.8.2.4, “'--' as the Start of a Comment”
Section 16.1.5.4, “Adding a Binary Log Based Source to a Multi-Source Replica”
Section 6.2.7, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
Section 16.1.5.3, “Adding GTID-Based Sources to a Multi-Source Replica”
Section 21.5.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
Section 21.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 21.5.7.1, “Adding NDB Cluster Data Nodes Online: General Issues”
Section 13.1.8.1, “ALTER TABLE Partition Operations”
Section 7.1, “Backup and Recovery Types”
Section 2.5.7.1, “Basic Steps for MySQL Server Deployment with Docker”
Section 13.6.1, “BEGIN ... END Compound Statement”
Section 27.7.19, “C API Automatic Reconnection Control”
Section 6.4.1.4, “Caching SHA-2 Pluggable Authentication”
Section 2.11.3, “Changes in MySQL 5.7”
Section B.3.2, “Client Error Message Reference”
Section 6.4.1.6, “Client-Side Cleartext Pluggable Authentication”
Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling”
Section 21.5.1, “Commands in the NDB Cluster Management Client”
Section 9.6, “Comment Syntax”
Section 21.3, “Configuration of NDB Cluster”
Section 10.5, “Configuring Application Character Set and Collation”
Section 16.1.5.1, “Configuring Multi-Source Replication”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 14.8.11.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 5.1.12.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.12.3, “Connecting Using the IPv6 Local Host Address”
Section 10.4, “Connection Character Sets and Collations”
Section 4.2.5, “Connection Transport Protocols”
Section 1.9.1, “Contributors to MySQL”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 2.11.13, “Copying MySQL Databases to Another Machine”
Section 13.1.16, “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 28.5.2, “Debugging a MySQL Client”
Section 21.3.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”
Section 23.1, “Defining Stored Programs”
Section 21.5.12, “Distributed Privileges Using Shared Grant Tables”
Section 2.12.5, “Downgrade Troubleshooting”
Section 2.12, “Downgrading MySQL”
Section 14.18.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 Components”
Section 21.5.2.3, “Event Buffer Reporting in the Cluster Log”
Section 23.4.2, “Event Scheduler Configuration”
Section 7.3, “Example Backup and Recovery Strategy”
Section 27.7.2, “Example C API Client Programs”
Section 3.6, “Examples of Common Queries”
Section 22.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.17.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.4, “GRANT Statement”
Section 13.8.3, “HELP Statement”
Section B.4.1, “How to Determine What Is Causing a Problem”
Section 14.7.5.3, “How to Minimize and Handle Deadlocks”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section B.4.2.14, “Ignoring user”
Section 12.15, “Information Functions”
Section 21.2.4.3, “Initial Startup of NDB Cluster on Windows”
Section 14.19.2, “InnoDB Recovery”
Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 21.2.3.2, “Installing NDB Cluster from RPM”
Section 21.2.4.1, “Installing NDB Cluster on Windows from a Binary Release”
Section 4.2.1, “Invoking MySQL Programs”
Section 21.1.7.8, “Issues Exclusive to NDB Cluster”
Section 6.4.1.9, “LDAP Pluggable Authentication”
Section 8.2.1.17, “LIMIT Query Optimization”
Section 13.2.6, “LOAD DATA Statement”
Section 13.2.7, “LOAD XML Statement”
Section 7.4.5.1, “Making a Copy of a Database”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 21.5, “Management of NDB Cluster”
Section 8.13.1, “Measuring the Speed of Expressions and Functions”
Section 2.5.7.2, “More Topics on Deploying MySQL Server with Docker”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section A.10, “MySQL 5.7 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 21, MySQL NDB Cluster 7.5 and NDB Cluster 7.6
Section 5.1.13, “MySQL Server Time Zone Support”
Section 21.5.9, “MySQL Server Usage for NDB Cluster”
Chapter 18, 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.6, “mysql_config_editor — MySQL Configuration Utility”
Section 27.7.6.14, “mysql_errno()”
Section 4.4.2, “mysql_install_db — Initialize MySQL Data Directory”
Section 27.7.6.72, “mysql_sqlstate()”
Section 4.4.6, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
Section 4.4.7, “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, “mysqlpump — A Database Backup Program”
Section 4.5.7, “mysqlshow — Display Database, Table, and Column Information”
Section 21.5.13, “NDB API Statistics Counters and Variables”
Section 21.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 21.5.10.1, “NDB Cluster Disk Data Objects”
Section 21.2.7, “NDB Cluster Example with Tables and Data”
Section 21.6, “NDB Cluster Replication”
Section 21.4.10, “ndb_desc — Describe NDB Tables”
Section 21.4.14, “ndb_import — Import CSV Data Into NDB”
Section 21.4.15, “ndb_index_stat — NDB Index Statistics Utility”
Section 21.4.5, “ndb_mgm — The NDB Cluster Management Client”
Section 21.5.14, “ndbinfo: The NDB Cluster Information Database”
Section 21.4.2, “ndbinfo_select_all — Select From ndbinfo Tables”
Section 8.9.3, “Optimizer Hints”
Section 4.2.2.6, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.4.2.7, “Out of memory”
Section 4.1, “Overview of MySQL Programs”
Section B.4.2.9, “Packet Too Large”
Section 6.4.1.7, “PAM Pluggable Authentication”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 6.2.13, “Pluggable Authentication”
Section 7.5.1, “Point-in-Time Recovery Using Binary Log”
Section 13.5, “Prepared Statements”
Section 21.6.5, “Preparing the NDB Cluster for Replication”
Section 4.2.2.4, “Program Option Modifiers”
Section 16.1.5.2, “Provisioning a Multi-Source Replica for GTID-Based Replication”
Section 22.2.3.1, “RANGE COLUMNS partitioning”
Section 2.11.12, “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.4.3.2.3, “Resetting the Root Password: Generic Instructions”
Section 21.4.24.1.2, “Restoring to More Nodes Than the Original”
Section 13.7.1.6, “REVOKE Statement”
Section 2.10.4, “Securing the Initial MySQL Account”
Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”
Section B.3.1, “Server Error Message Reference”
Section 6.2.12, “Server Handling of Expired Passwords”
Section 5.1.7, “Server System Variables”
Section 5.1.14, “Server-Side Help Support”
Section 19.2, “Setting Up MySQL as a Document Store”
Section 6.4.1.5, “SHA-256 Pluggable Authentication”
Section 13.7.5.34, “SHOW SLAVE STATUS Statement”
Section 13.7.5.40, “SHOW WARNINGS Statement”
Section 13.6.7.5, “SIGNAL Statement”
Section 6.4.1.11, “Socket Peer-Credential Pluggable Authentication”
Section 4.2.2, “Specifying Program Options”
Section 16.1.5.5, “Starting Multi-Source Replicas”
Section 2.3.4.8, “Starting MySQL as a Windows Service”
Section 21.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 26.4.4.2, “The diagnostics() Procedure”
Section 21.5.14.27, “The ndbinfo memory_per_fragment Table”
Section 21.5.14.44, “The ndbinfo transporters Table”
Section 23.3.1, “Trigger Syntax and Examples”
Section 14.22.3, “Troubleshooting InnoDB Data Dictionary Operations”
Section 6.2.17, “Troubleshooting Problems Connecting to MySQL”
Chapter 3, Tutorial
Section 1.2, “Typographical and Syntax Conventions”
Section 4.10, “Unix Signal Handling in MySQL”
Section 2.11, “Upgrading MySQL”
Section 2.11.10, “Upgrading MySQL with Directly-Downloaded RPM Packages”
Section 7.3.2, “Using Backups for Recovery”
Section 16.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 17.4.4, “Using MySQL Enterprise Backup with Group Replication”
Section 6.4.6.3, “Using MySQL Enterprise Firewall”
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.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 28.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 28.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 28.2.4.11.2, “Using Your Own Protocol Trace Plugins”
Section 1.4, “What Is New in MySQL 5.7”
Section 21.1.4.1, “What is New in NDB Cluster 7.5”
Section 21.1.4.2, “What is New in NDB Cluster 7.6”
Section 2.3.6, “Windows Postinstallation Procedures”
Section 12.11, “XML Functions”

mysql-test-run.pl test_name

Section 28.1.2, “The MySQL Test Suite”