Related Documentation Download this Manual
PDF (US Ltr) - 38.1Mb
PDF (A4) - 38.1Mb
PDF (RPM) - 33.0Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 132.7Kb
Man Pages (Zip) - 189.0Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  Indexes  /  Command Index

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.12, “Adding a Character Set”
Section 27.7.4.2, “Building C API Client Programs Using pkg-config”
Section 6.4.5, “Building MySQL with Support for Encrypted Connections”
Section B.5.2.16, “Can't initialize character set”
Section 28.2.4.3, “Compiling and Installing Plugin Libraries”
Section 10.5, “Configuring Application Character Set and Collation”
Section 14.1, “Data Dictionary Schema”
Section 2.8.5, “Dealing with Problems Compiling MySQL”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 15.13, “InnoDB Startup Options and System Variables”
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 6.5.4.11, “Keyring System Variables”
Section 2.5.9, “Managing MySQL Server with systemd”
Section 4.9, “MySQL Program Environment Variables”
Section 28.3, “MySQL Services for Plugins”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 25.2, “Performance Schema Build Configuration”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 6.1.6, “Security Issues with 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 16.5, “The ARCHIVE Storage Engine”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 16.9, “The EXAMPLE Storage Engine”
Section 16.8, “The FEDERATED Storage Engine”
Section 1.3.2, “The Main Features of MySQL”
Section 28.4.2.5, “UDF Compiling and Installing”
Section 4.2.7, “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 8.0”
Section B.5.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.3.1, “ANALYZE TABLE Syntax”
Section 8.6.2, “Bulk Data Loading for MyISAM Tables”
Section 10.14, “Character Set Configuration”
Section 13.7.3.2, “CHECK TABLE Syntax”
Section 16.2.3.3, “Compressed Table Characteristics”
Section 16.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 Syntax”
Section 16.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.8, “InnoDB and MyISAM Index Statistics Collection”
Section C.10.3, “Limits on Table Size”
Section 13.7.7.5, “LOAD INDEX INTO CACHE Syntax”
Section 28.5.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 Syntax”
Section 5.1.6, “Server Command Options”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.7.6.22, “SHOW INDEX Syntax”
Section 13.7.6.36, “SHOW TABLE STATUS Syntax”
Section 16.2.3.1, “Static (Fixed-Length) Table Characteristics”
Section 24.24, “The INFORMATION_SCHEMA STATISTICS Table”
Section 24.27, “The INFORMATION_SCHEMA TABLES Table”
Section 1.3.2, “The Main Features of MySQL”
Section 16.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.2.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

mysql

Section 1.8.2.4, “'--' as the Start of a Comment”
Section 6.3.2, “Adding User Accounts”
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 Syntax”
Section 27.7.24, “C API Automatic Reconnection Control”
Section 6.5.1.3, “Caching SHA-2 Pluggable Authentication”
Section 2.10.1.2, “Changes Affecting Upgrades to MySQL 8.0”
Section 6.5.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 4.2.8, “Command-Line Options that Affect Option-File Handling”
Section 9.6, “Comment Syntax”
Section 10.5, “Configuring Application Character Set and Collation”
Section 6.4.1, “Configuring MySQL to Use Encrypted Connections”
Section 15.6.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 5.1.11.4, “Connecting Using IPv6 Nonlocal Host Addresses”
Section 5.1.11.3, “Connecting Using the IPv6 Local Host Address”
Section 10.4, “Connection Character Sets and Collations”
Section 1.9.1, “Contributors to MySQL”
Section 15.8.1.4, “Converting Tables from MyISAM to InnoDB”
Section 2.10.4, “Copying MySQL Databases to Another Machine”
Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 3.3.1, “Creating and Selecting a Database”
Section 2.3.5.7, “Customizing the PATH for MySQL Tools”
Section 14.1, “Data Dictionary Schema”
Section 28.5.2, “Debugging a MySQL Client”
Section 23.1, “Defining Stored Programs”
Section 4.5.1.6.5, “Disabling mysql Auto-Reconnect”
Section 15.16.2, “Enabling InnoDB Monitors”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 3.2, “Entering Queries”
Section 23.4.2, “Event Scheduler Configuration”
Section 7.3, “Example Backup and Recovery Strategy”
Section 27.7.3, “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.16.3, “Functions That Search JSON Values”
Section 2.4.1, “General Notes on Installing MySQL on macOS”
Section 13.6.7.3, “GET DIAGNOSTICS Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 13.8.3, “HELP Syntax”
Section B.5.1, “How to Determine What Is Causing a Problem”
Section 15.5.5.3, “How to Minimize and Handle Deadlocks”
Section 1.7, “How to Report Bugs or Problems”
Section 6.1.5, “How to Run MySQL as a Normal User”
Section 13.2.5, “IMPORT TABLE Syntax”
Section 12.14, “Information Functions”
Section 15.17.2, “InnoDB Recovery”
Section 4.5.1.6.1, “Input-Line Editing”
Section 4.2.1, “Invoking MySQL Programs”
Section 6.5.1.7, “LDAP Pluggable Authentication”
Section 8.2.1.17, “LIMIT Query Optimization”
Section 13.2.7, “LOAD DATA INFILE Syntax”
Section 13.2.8, “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.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 4.5.1.2, “mysql Commands”
MySQL Glossary
Section 2.3.3.1, “MySQL Installer Initial Setup”
Section 4.5.1.3, “mysql Logging”
Section 4.5.1.1, “mysql Options”
Section 4.9, “MySQL Program Environment Variables”
Section 5.1.12, “MySQL Server Time Zone Support”
Section 4.5.1.4, “mysql Server-Side Help”
Chapter 19, MySQL Shell
Section 4.5.1.6, “mysql Tips”
Section 2.10.1.1, “MySQL Upgrade Strategies”
Section 4.5.1, “mysql — The MySQL Command-Line Tool”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility”
Section 27.7.7.14, “mysql_errno()”
Section 27.7.7.76, “mysql_sqlstate()”
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 4.2.10, “Option Defaults, Options Expecting Values, and the = Sign”
Section B.5.2.7, “Out of memory”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.9, “Packet Too Large”
Section 6.5.1.5, “PAM Pluggable Authentication”
Section 6.3.10, “Pluggable Authentication”
Section 7.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 13.5, “Prepared SQL Statement Syntax”
Section 4.2.6, “Program Option Modifiers”
Section 22.2.3.1, “RANGE COLUMNS partitioning”
Section 2.10.3, “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.3.2.3, “Resetting the Root Password: Generic Instructions”
Section C.9, “Restrictions on Pluggable Authentication”
Section 13.7.1.8, “REVOKE Syntax”
Section 2.9.4, “Securing the Initial MySQL Account”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 13.2.10.1, “SELECT ... INTO Syntax”
Section B.3, “Server Error Codes and Messages”
Section 6.3.9, “Server Handling of Expired Passwords”
Section 5.1.7, “Server System Variables”
Section 5.1.14, “Server-Side Help”
Section 6.5.1.2, “SHA-256 Pluggable Authentication”
Section 13.7.6.34, “SHOW SLAVE STATUS Syntax”
Section 13.7.6.40, “SHOW WARNINGS Syntax”
Section 13.6.7.5, “SIGNAL Syntax”
Section 6.5.1.9, “Socket Peer-Credential Pluggable Authentication”
Section 4.2.4, “Specifying Program Options”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 9.1.1, “String Literals”
Section 2.9.3, “Testing the Server”
Section 11.4.3, “The BLOB and TEXT Types”
Section 26.4.4.2, “The diagnostics() Procedure”
Section 23.3.1, “Trigger Syntax and Examples”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Chapter 3, Tutorial
Section 1.2, “Typographical and Syntax Conventions”
Section 4.5.1.6.2, “Unicode Support on Windows”
Section 7.3.2, “Using Backups for Recovery”
Section 17.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 6.5.6.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.7, “Using Option Files”
Section 4.2.5, “Using Options on the Command Line”
Section 4.2.9, “Using Options to Set Program Variables”
Section 28.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 4.5.1.6.4, “Using the --safe-updates Option”
Section 28.2.4.11.1, “Using the Test Protocol Trace Plugin”
Section 28.2.4.11.2, “Using Your Own Protocol Trace Plugins”
Section 1.4, “What Is New in MySQL 8.0”
Section 2.3.7, “Windows Postinstallation Procedures”
Section 13.2.13, “WITH Syntax (Common Table Expressions)”
Section 12.11, “XML Functions”

mysql-test-run.pl test_name

Section 28.1.2, “The MySQL Test Suite”

mysqladmin

Section 6.3.7, “Assigning Account Passwords”
Section 17.3.1.1, “Backing Up a Slave Using mysqldump”
Section 6.5.1.3, “Caching SHA-2 Pluggable Authentication”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section 2.10.1.2, “Changes Affecting Upgrades to MySQL 8.0”
Section 6.5.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 5.1.1, “Configuring the Server”
Section 4.2.2, “Connecting to the MySQL Server”
Section 10.4, “Connection Character Sets and Collations”
Section 1.9.1, “Contributors to MySQL”
Section 13.1.11, “CREATE DATABASE Syntax”
Section 2.3.5.7, “Customizing the PATH for MySQL Tools”
Section 28.5.1, “Debugging a MySQL Server”
Section 13.1.22, “DROP DATABASE Syntax”
Section 27.7.3, “Example C API Client Programs”
Section 13.7.7.3, “FLUSH Syntax”
Section 2.4.1, “General Notes on Installing MySQL on macOS”
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 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 — Client for Administering a MySQL Server”
Section 4.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
Section 4.1, “Overview of MySQL Programs”
Section 25.11.9, “Performance Schema Connection Attribute Tables”
Section 6.3.10, “Pluggable Authentication”
Section 6.2.1, “Privileges Provided by MySQL”
Section C.9, “Restrictions on Pluggable Authentication”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 2.9.4, “Securing the Initial MySQL Account”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 6.5.1.2, “SHA-256 Pluggable Authentication”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 2.9.3, “Testing the Server”
Section 1.3.2, “The Main Features of MySQL”
Section 5.1.16, “The Server Shutdown Process”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 4.2.7, “Using Option Files”
Section 4.2.5, “Using Options on the Command Line”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”

mysqladmin processlist status

Section 28.5.1, “Debugging a MySQL Server”

mysqladmin variables extended-status processlist

Section 1.7, “How to Report Bugs or Problems”

mysqlbinlog

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 13.7.7.1, “BINLOG Syntax”
Section 6.5.1.3, “Caching SHA-2 Pluggable Authentication”
Section 17.3.11, “Delayed Replication”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.1.3.2, “GTID Life Cycle”
Section 17.4.5, “How to Report Replication Bugs or Problems”
Section 15.17.2, “InnoDB Recovery”
Section B.5.7, “Known Issues in MySQL”
Section 12.22, “Miscellaneous Functions”
MySQL Glossary
Section 4.5.1.1, “mysql Options”
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 4.1, “Overview of MySQL Programs”
Section 25.11.9, “Performance Schema Connection Attribute Tables”
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.19, “Replication and LOAD DATA INFILE”
Section 17.4.1.39, “Replication and Variables”
Section 5.1.7, “Server System Variables”
Section 6.5.1.2, “SHA-256 Pluggable Authentication”
Section 13.7.6.2, “SHOW BINLOG EVENTS Syntax”
Section 13.7.6.32, “SHOW RELAYLOG EVENTS Syntax”
Section 4.6.8.4, “Specifying the mysqlbinlog Server ID”
Section 13.4.2.6, “START SLAVE Syntax”
Section 5.4.4, “The Binary Log”
Section 5.4.3, “The General Query Log”
Section 17.2.4.1, “The Slave 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”

mysqld

Section 28.4.2, “Adding a New User-Defined Function”
Section 28.4, “Adding New Functions to MySQL”
Section 8.2.1.21, “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 6.4.5, “Building MySQL with Support for Encrypted Connections”
Section B.5.2.2, “Can't connect to [local] MySQL server”
Section B.5.2.12, “Can't create/write to file”
Section B.5.2.16, “Can't initialize character set”
Section 13.4.2.2, “CHANGE REPLICATION FILTER Syntax”
Section 4.2.8, “Command-Line Options that Affect Option-File Handling”
Section 9.6, “Comment Syntax”
Section B.5.2.10, “Communication Errors and Aborted Connections”
Section 4.4.1, “comp_err — Compile MySQL Error Message File”
Section 28.5.1.1, “Compiling MySQL for Debugging”
Section 5.1.1, “Configuring the Server”
Section 15.19.6.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 16.2.4.1, “Corrupted MyISAM Tables”
Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 28.5.1.2, “Creating Trace Files”
Section 14.1, “Data Dictionary Schema”
Section 15.5.5, “Deadlocks in InnoDB”
Section 28.5.1, “Debugging a MySQL Server”
Section 28.5, “Debugging and Porting MySQL”
Section 28.5.1.4, “Debugging mysqld under gdb”
Section 5.4.2.2, “Default Error Log Destination Configuration”
Section 15.4.6, “Doublewrite Buffer”
Section 15.16.2, “Enabling InnoDB Monitors”
Section 5.4.2.7, “Error Log File Flushing and Renaming”
Section 5.4.2.6, “Error Log Message Format”
Section 5.4.2.3, “Error Logging to the System Log”
Section 8.11.5, “External Locking”
Section B.5.2.17, “File Not Found and Similar Errors”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 15.20.2, “Forcing InnoDB Recovery”
Section 18.8, “Frequently Asked Questions”
Section 8.14.2, “General Thread States”
Section B.5.2.5, “Host 'host_name' is blocked”
Section 8.4.3.1, “How MySQL Opens and Closes Tables”
Section 8.12.3.1, “How MySQL Uses Memory”
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 B.5.2.14, “Ignoring user”
Section 12.14, “Information Functions”
Section 2.9.1.1, “Initializing the Data Directory Manually Using mysqld”
Section 15.17.1, “InnoDB Backup”
Section 15.11.1, “InnoDB Disk I/O”
Section 15.7.4, “InnoDB File-Per-Table Tablespaces”
Section 15.19.2, “InnoDB memcached Architecture”
Section 15.17.2, “InnoDB Recovery”
Section 15.6.1, “InnoDB Startup Configuration”
Section 15.13, “InnoDB Startup Options and System Variables”
Section 15.20, “InnoDB Troubleshooting”
Section 13.2.6.2, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 13.2.6, “INSERT Syntax”
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.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
Section 21.1, “Introducing InnoDB Cluster”
Section 13.7.7.4, “KILL Syntax”
Section 13.2.7, “LOAD DATA INFILE Syntax”
Section 28.5.1.7, “Making a Test Case If You Experience Table Corruption”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 2.5.9, “Managing MySQL Server with systemd”
Section 6.5.4.6, “Migrating Keys Between Keyring Keystores”
Section 12.22, “Miscellaneous Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 15.8.1.3, “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.3, “MySQL 8.0 FAQ: Server SQL Mode”
MySQL Glossary
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows”
Section 4.9, “MySQL Program Environment Variables”
Chapter 5, MySQL Server Administration
Section 4.3, “MySQL Server and Server-Startup Programs”
Section B.5.2.8, “MySQL server has gone away”
Section 5.4, “MySQL Server Logs”
Section 5.1.12, “MySQL Server Time Zone Support”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 1.8, “MySQL Standards Compliance”
Chapter 26, MySQL sys Schema
Section 2.10.1.1, “MySQL Upgrade Strategies”
Section 4.3.3, “mysql.server — MySQL Server Startup Script”
Section 27.7.7.1, “mysql_affected_rows()”
Section 27.7.7.50, “mysql_options()”
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 13.7.3.4, “OPTIMIZE TABLE Syntax”
Section B.5.5, “Optimizer-Related Issues”
Section 8.5.4, “Optimizing InnoDB Redo Logging”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.9, “Packet Too Large”
Section 25.3, “Performance Schema Startup Configuration”
Section 25.11.13.2, “Performance Schema variables_info Table”
Section 16.2.4.2, “Problems from Tables Not Being Closed Properly”
Section B.5.3.1, “Problems with File Permissions”
Section 4.2.6, “Program Option Modifiers”
Section 13.7.3.5, “REPAIR TABLE Syntax”
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.4.1.28, “Replication and Master or Slave Shutdowns”
Section 17.4.1.34, “Replication and Transaction Inconsistencies”
Section 17.1.6.2, “Replication Master Options and Variables”
Section 17.2.4, “Replication Relay and Status Logs”
Section 13.4.2.4, “RESET SLAVE Syntax”
Section B.5.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.5.3.2.1, “Resetting the Root Password: Windows Systems”
Section 4.7.3, “resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols”
Section 8.12.5, “Resource Groups”
Section 13.7.7.8, “RESTART Syntax”
Section B.5.4.5, “Rollback Failure for Nontransactional Tables”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 2.9.4, “Securing the Initial MySQL Account”
Section 6.1.6, “Security Issues with LOAD DATA LOCAL”
Section 6.1.4, “Security-Related mysqld Options and Variables”
Section 13.2.10.1, “SELECT ... INTO Syntax”
Section 2.3.5.3, “Selecting a MySQL Server Type”
Section 10.3.2, “Server Character Set and Collation”
Section 5.1.6, “Server Command Options”
Section 5.4.7, “Server Log Maintenance”
Section 28.2.4.2.2, “Server Plugin Status and System Variables”
Section 5.1.15, “Server Response to Signals”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 13.3.7, “SET TRANSACTION Syntax”
Section 10.11, “Setting the Error Message Language”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 17.1.3.4, “Setting Up Replication Using GTIDs”
Section 15.19.3, “Setting Up the InnoDB memcached Plugin”
Section 27.7.2, “Simultaneous MySQL Server and Connector/C Installations”
Section 13.4.2.6, “START SLAVE Syntax”
Section 2.9.5, “Starting and Stopping MySQL Automatically”
Section 5.7.2.2, “Starting Multiple MySQL Instances as Windows Services”
Section 5.7.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 2.3.5.6, “Starting MySQL from the Windows Command Line”
Section 17.2.3.3, “Startup Options and Replication Channels”
Section 5.1.12.1, “Staying Current with Time Zone Changes”
Section 1.9.5, “Supporters of MySQL”
Section 17.3.8, “Switching Masters During Failover”
Section 8.11.2, “Table Locking Issues”
Section B.5.2.18, “Table-Corruption Issues”
Section 2.3.5.9, “Testing The MySQL Installation”
Section 2.9.3, “Testing the Server”
Section 5.4.4, “The Binary Log”
Section 16.6, “The BLACKHOLE Storage Engine”
Section 28.5.3, “The DBUG Package”
Section 5.4.6, “The DDL Log”
Section 5.4.2, “The Error Log”
Section 5.4.3, “The General Query Log”
Section 15.19.7, “The InnoDB memcached Plugin and Replication”
Section 16.2, “The MyISAM Storage Engine”
Section 5.1, “The MySQL Server”
Section 28.1.2, “The MySQL Test Suite”
Section 5.4.5, “The Slow Query Log”
Section B.5.3.7, “Time Zone Problems”
Section B.5.2.6, “Too many connections”
Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”
Section 15.20.1, “Troubleshooting InnoDB I/O Problems”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 1.2, “Typographical and Syntax Conventions”
Section 28.4.2.5, “UDF Compiling and Installing”
Section 28.4.2.6, “UDF Security Precautions”
Section 2.3.8, “Upgrading MySQL on Windows”
Section 28.5.1.5, “Using a Stack Trace”
Section 7.6.1, “Using myisamchk for Crash Recovery”
Section 4.2.7, “Using Option Files”
Section 28.5.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 28.5.1.3, “Using WER with PDB to create a Windows crashdump”
Section 1.4, “What Is New in MySQL 8.0”
Section B.5.3.3, “What to Do If MySQL Keeps Crashing”
Section 6.2.8, “When Privilege Changes Take Effect”
Section B.5.3.5, “Where MySQL Stores Temporary Files”
Section 2.1.1, “Which MySQL Version and Distribution to Install”
Section 28.2.4, “Writing Plugins”

mysqld_safe

Section 28.5.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.5.2.17, “File Not Found and Similar Errors”
Section B.5.3.6, “How to Protect or Change the MySQL Unix Socket File”
Section 15.20, “InnoDB Troubleshooting”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 2.5.9, “Managing MySQL Server with systemd”
Section 5.1.12, “MySQL Server Time Zone Support”
Section 2.8.4, “MySQL Source-Configuration Options”
Section 2.10.1.1, “MySQL Upgrade Strategies”
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 4.2.10, “Option Defaults, Options Expecting Values, and the = Sign”
Section 4.1, “Overview of MySQL Programs”
Section B.5.2.9, “Packet Too Large”
Section 25.11.13.2, “Performance Schema variables_info Table”
Section B.5.3.1, “Problems with File Permissions”
Section 13.7.7.8, “RESTART Syntax”
Section 5.7, “Running Multiple MySQL Instances on One Machine”
Section 5.7.3, “Running Multiple MySQL Instances on Unix”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 2.9.5, “Starting and Stopping MySQL Automatically”
Section 2.9.2, “Starting the Server”
Section 2.9.3, “Testing the Server”
Section 5.4.2, “The Error Log”
Section B.5.3.7, “Time Zone Problems”
Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
Section 4.2.7, “Using Option Files”

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.5, “Bulk Data Loading for InnoDB Tables”
Section 6.5.1.3, “Caching SHA-2 Pluggable Authentication”
Section 2.10.1.2, “Changes Affecting Upgrades to MySQL 8.0”
Section 17.1.2.5, “Choosing a Method for Data Snapshots”
Section 6.5.1.4, “Client-Side Cleartext Pluggable Authentication”
Section 4.2.2, “Connecting to the MySQL Server”
Section 1.9.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 15.7.6, “Copying File-Per-Table Tablespaces to Another Instance”
Section 2.10.4, “Copying MySQL Databases to Another Machine”
Section 13.1.18, “CREATE TABLE Syntax”
Section 17.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
Section 15.8.1.1, “Creating InnoDB Tables”
Section 2.3.5.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 15.7.4.1, “Enabling and Disabling File-Per-Table Tablespaces”
Section 7.3.1, “Establishing a Backup Policy”
Section 7.3, “Example Backup and Recovery Strategy”
Section 1.7, “How to Report Bugs or Problems”
Section 13.2.5, “IMPORT TABLE Syntax”
Section 4.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
Section 15.17.1, “InnoDB Backup”
Section 2.6, “Installing MySQL Using Unbreakable Linux Network (ULN)”
Section 13.2.7, “LOAD DATA INFILE Syntax”
Section 13.2.8, “LOAD XML Syntax”
Section 7.4.5.1, “Making a Copy of a Database”
Section 11.3.4, “Migrating YEAR(2) Columns to YEAR(4)”
Section 15.8.1.3, “Moving or Copying InnoDB Tables”
Section 4.5.1.1, “mysql Options”
Section 5.4, “MySQL Server Logs”
Section 2.10.1.1, “MySQL Upgrade Strategies”
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 17.1.2.4, “Obtaining the Replication Master Binary Log Coordinates”
Section 4.1, “Overview of MySQL Programs”
Section 25.11.9, “Performance Schema Connection Attribute Tables”
Section B.5.4.8, “Problems with Floating-Point Values”
Section 2.10.3, “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.6, “Replicating Different Databases to Different Slaves”
Section 17.4.1.34, “Replication and Transaction Inconsistencies”
Section 15.7.1, “Resizing the InnoDB System Tablespace”
Section C.8, “Restrictions on Performance Schema”
Section 17.1.3.6, “Restrictions on Replication with GTIDs”
Section C.5, “Restrictions on Views”
Section 5.4.1, “Selecting General Query and Slow Query Log Output Destinations”
Section 5.4.7, “Server Log Maintenance”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 17.1.2.6.2, “Setting Up Replication with Existing Data”
Section 6.5.1.2, “SHA-256 Pluggable Authentication”
Section B.5.4.7, “Solving Problems with No Matching Rows”
Section 2.3.5.8, “Starting MySQL as a Windows Service”
Section 11.4.3, “The BLOB and TEXT Types”
Section 15.6.3.1, “The InnoDB Buffer Pool”
Section 15.19.7, “The InnoDB memcached Plugin and Replication”
Section 1.3.2, “The Main Features of MySQL”
Section 6.2.9, “Troubleshooting Problems Connecting to MySQL”
Section 13.7.4.6, “UNINSTALL PLUGIN Syntax”
Section 17.4.3, “Upgrading a Replication Setup”
Section 13.1.18.6, “Using FOREIGN KEY Constraints”
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.7, “Using Option Files”
Section 17.3.1, “Using Replication for Backups”
Section 17.3.4, “Using Replication with Different Master and Slave Storage Engines”
Section 26.2, “Using the sys Schema”
Section 1.4, “What Is New in MySQL 8.0”
Section 12.11, “XML Functions”

N

[index top]

O

[index top]

P

[index top]

R

[index top]

S

[index top]

T

[index top]

U

[index top]

V

[index top]

W

[index top]

Y

[index top]

Z

[index top]


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.