MySQL 9.1 Release Notes
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | R | S | T | U | V | W | X | Y | Z
addgroup
addr2line
adduser
apt-get
audit2allow
bash
- Section 1.1, “About This Manual”
- Section 8.1.2.1, “End-User Guidelines for Password Security”
- Section 2.4.1, “General Notes on Installing MySQL on macOS”
- Section 6.2.1, “Invoking MySQL Programs”
- Section 19.1.6.3, “Replica Server Options and Variables”
- Section 15.7.8.8, “RESTART Statement”
- Section 6.2.9, “Setting Environment Variables”
bison
cat
chkconfig
CMake
- Section 12.13, “Adding a Character Set”
- Section 25.3.1.4, “Building NDB Cluster from Source on Linux”
- Section B.3.2.15, “Can't initialize character set”
- Section 25.3.2.2, “Compiling and Installing NDB Cluster from Source on Windows”
- Section 12.5, “Configuring Application Character Set and Collation”
- Section 2.8.6, “Configuring SSL Library Support”
- Section 16.1, “Data Dictionary Schema”
- Section 2.8.8, “Dealing with Problems Compiling MySQL”
- Section 6.9, “Environment Variables”
- Section 25.1, “General Information”
- Section B.3.3.6, “How to Protect or Change the MySQL Unix Socket File”
- Section 17.14, “InnoDB Startup Options and System Variables”
- Section 2.8.5, “Installing MySQL Using a Development Source Tree”
- Section 2.8.4, “Installing MySQL Using a Standard Source Distribution”
- Section 2.5.9, “Managing MySQL Server with systemd”
- Section 25.6.10, “MySQL Server Usage for NDB Cluster”
- Section 2.8.7, “MySQL Source-Configuration Options”
- Section 29.2, “Performance Schema Build Configuration”
- Section 7.8.3, “Running Multiple MySQL Instances on Unix”
- Section 8.1.6, “Security Considerations for LOAD DATA LOCAL”
- Section 12.3.2, “Server Character Set and Collation”
- Section 7.1.7, “Server Command Options”
- Section 7.1.8, “Server System Variables”
- Section 2.8.2, “Source Installation Prerequisites”
- Section 18.5, “The ARCHIVE Storage Engine”
- Section 18.6, “The BLACKHOLE Storage Engine”
- Section 18.9, “The EXAMPLE Storage Engine”
- Section 18.8, “The FEDERATED Storage Engine”
- Section 7.9.3, “The LOCK_ORDER Tool”
- Section 1.2.2, “The Main Features of MySQL”
- Section 29.12.22.8, “The processlist Table”
- Section 8.3, “Using Encrypted Connections”
- Section 6.2.2.2, “Using Option Files”
- Section B.3.3.3, “What to Do If MySQL Keeps Crashing”
cmd.exe
comp_err
cp
cron
csh
Directory Utility
dnf
dnf config-manager
dnf upgrade mysql-server
docker logs mysqld-container
docker pull
docker run
dpkg
gcc
gdb
getenforce
gmake
gnutar
grep
groupadd
gtar
gunzip
gzip
help contents
ibd2sdi
innochecksum
iptables
kill
kinit
klist
make
make && make install
make package
make test
make VERBOSE=1
mgmd
mv
my_print_defaults
myisam_ftdump
myisamchk
- Section 15.7.3.1, “ANALYZE TABLE Statement”
- Section 10.6.2, “Bulk Data Loading for MyISAM Tables”
- Section 15.7.3.2, “CHECK TABLE Statement”
- Section 18.2.3.3, “Compressed Table Characteristics”
- Section 18.2.4.1, “Corrupted MyISAM Tables”
- Section 9.2, “Database Backup Methods”
- Section 7.9.1, “Debugging a MySQL Server”
- Section 15.2.2, “DELETE Statement”
- Section 18.2.3.2, “Dynamic Table Characteristics”
- Section 10.8.2, “EXPLAIN Output Format”
- Section 10.11.5, “External Locking”
- Section 14.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 9.6.2, “How to Check MyISAM Tables for Errors”
- Section 9.6.3, “How to Repair MyISAM Tables”
- Section 1.6, “How to Report Bugs or Problems”
- Section 10.3.8, “InnoDB and MyISAM Index Statistics Collection”
- Section 10.4.6, “Limits on Table Size”
- Section 15.7.8.5, “LOAD INDEX INTO CACHE Statement”
- Section 7.9.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 18.2.1, “MyISAM Startup Options”
- Section 9.6, “MyISAM Table Maintenance and Crash Recovery”
- Section 9.6.4, “MyISAM Table Optimization”
- Section 18.2.3, “MyISAM Table Storage Formats”
- Section 6.6.4.2, “myisamchk Check Options”
- Section 6.6.4.1, “myisamchk General Options”
- Section 6.6.4.6, “myisamchk Memory Usage”
- Section 6.6.4.3, “myisamchk Repair Options”
- Section 6.6.4, “myisamchk — MyISAM Table-Maintenance Utility”
- Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
- Section 6.6.4.5, “Obtaining Table Information with myisamchk”
- Section 10.6.1, “Optimizing MyISAM Queries”
- Section 10.6.3, “Optimizing REPAIR TABLE Statements”
- Section 6.6.4.4, “Other myisamchk Options”
- Section 6.1, “Overview of MySQL Programs”
- Section 18.2.4.2, “Problems from Tables Not Being Closed Properly”
- Section 15.7.3.5, “REPAIR TABLE Statement”
- Section 7.1.8, “Server System Variables”
- Section 9.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
- Section 15.7.7.23, “SHOW INDEX Statement”
- Section 15.7.7.37, “SHOW TABLE STATUS Statement”
- Section 18.2.3.1, “Static (Fixed-Length) Table Characteristics”
- Section 28.3.34, “The INFORMATION_SCHEMA STATISTICS Table”
- Section 28.3.38, “The INFORMATION_SCHEMA TABLES Table”
- Section 1.2.2, “The Main Features of MySQL”
- Section 18.2, “The MyISAM Storage Engine”
- Section 9.6.1, “Using myisamchk for Crash Recovery”
- Section 7.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
- Section 10.12.2.2, “Using Symbolic Links for MyISAM Tables on Unix”
- Section B.3.3.3, “What to Do If MySQL Keeps Crashing”
myisamchk *.MYI
myisamchk tbl_name
myisamlog
myisampack
- Section 10.6.2, “Bulk Data Loading for MyISAM Tables”
- Section 18.2.3.3, “Compressed Table Characteristics”
- Section 15.1.20, “CREATE TABLE Statement”
- Section 10.11.5, “External Locking”
- Section 10.4.6, “Limits on Table Size”
- Section 18.7.1, “MERGE Table Advantages and Disadvantages”
- Section 18.2.3, “MyISAM Table Storage Formats”
- Section 6.6.4.3, “myisamchk Repair Options”
- Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
- Section 6.6.4.5, “Obtaining Table Information with myisamchk”
- Section 10.4.1, “Optimizing Data Size”
- Section 6.1, “Overview of MySQL Programs”
- Section 15.1.20.7, “Silent Column Specification Changes”
- Section 18.7, “The MERGE Storage Engine”
- Section 18.2, “The MyISAM Storage Engine”
mysql
- Section 1.1, “About This Manual”
- Section 8.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
- Section 19.1.5.4, “Adding Binary Log Based Replication Sources to a Multi-Source Replica”
- Section 19.1.5.3, “Adding GTID-Based Sources to a Multi-Source Replica”
- Section 25.6.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
- Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 25.6.7.1, “Adding NDB Cluster Data Nodes Online: General Issues”
- Section 14.19.1, “Aggregate Function Descriptions”
- Section 15.7.1.1, “ALTER USER Statement”
- Section 8.4.5.11, “Audit Log Reference”
- Section 9.1, “Backup and Recovery Types”
- Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”
- Section 15.6.1, “BEGIN ... END Compound Statement”
- Section 14.12, “Bit Functions and Operators”
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 14.10, “Cast Functions and Operators”
- Section 8.4.1.3, “Client-Side Cleartext Pluggable Authentication”
- Section 6.2.3, “Command Options for Connecting to the Server”
- Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
- Section 25.6.1, “Commands in the NDB Cluster Management Client”
- Section 11.7, “Comments”
- Section 25.4, “Configuration of NDB Cluster”
- Section 12.5, “Configuring Application Character Set and Collation”
- Section 19.1.5.1, “Configuring Multi-Source Replication”
- Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”
- Section 17.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
- Section 5.1, “Connecting to and Disconnecting from the Server”
- Section 6.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 6.2.6, “Connecting to the Server Using DNS SRV Records”
- Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”
- Section 7.1.13.4, “Connecting Using IPv6 Nonlocal Host Addresses”
- Section 7.1.13.3, “Connecting Using the IPv6 Local Host Address”
- Section 12.4, “Connection Character Sets and Collations”
- Section 6.2.8, “Connection Compression Control”
- Section 6.2.7, “Connection Transport Protocols”
- Section 17.6.1.5, “Converting Tables from MyISAM to InnoDB”
- Section 3.15, “Copying MySQL Databases to Another Machine”
- Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
- Section 5.3.1, “Creating and Selecting a Database”
- Section 2.3.3.7, “Customizing the PATH for MySQL Tools”
- Section 16.1, “Data Dictionary Schema”
- Section 7.9.2, “Debugging a MySQL Client”
- Section 25.4.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”
- Section 27.1, “Defining Stored Programs”
- Section 10.15.13, “Displaying Traces in Other Applications”
- Section 17.17.2, “Enabling InnoDB Monitors”
- Section 14.13, “Encryption and Compression Functions”
- Section 8.1.2.1, “End-User Guidelines for Password Security”
- Section 5.2, “Entering Queries”
- Section 6.9, “Environment Variables”
- Section B.2, “Error Information Interfaces”
- Section B.1, “Error Message Sources and Elements”
- Section 25.6.2.3, “Event Buffer Reporting in the Cluster Log”
- Section 27.5.2, “Event Scheduler Configuration”
- Section 9.3, “Example Backup and Recovery Strategy”
- Section 5.6, “Examples of Common Queries”
- Section 26.3.3, “Exchanging Partitions and Subpartitions with Tables”
- Section 6.5.1.5, “Executing SQL Statements from a Text File”
- Chapter 14, Functions and Operators
- Section 14.17.3, “Functions That Search JSON Values”
- Section 25.1, “General Information”
- Section 2.4.1, “General Notes on Installing MySQL on macOS”
- Section 15.6.7.3, “GET DIAGNOSTICS Statement”
- Section 15.7.1.6, “GRANT Statement”
- Section B.3.1, “How to Determine What Is Causing a Problem”
- Section 17.7.5.3, “How to Minimize and Handle Deadlocks”
- Section 1.6, “How to Report Bugs or Problems”
- Section 8.1.5, “How to Run MySQL as a Normal User”
- Section 15.2.6, “IMPORT TABLE Statement”
- Section 25.6.9, “Importing Data Into MySQL Cluster”
- Section 14.15, “Information Functions”
- Section 25.3.2.3, “Initial Startup of NDB Cluster on Windows”
- Section 17.18.2, “InnoDB Recovery”
- Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 25.3.2.1, “Installing NDB Cluster on Windows from a Binary Release”
- Section 6.2.1, “Invoking MySQL Programs”
- Section 25.2.7.8, “Issues Exclusive to NDB Cluster”
- Section 27.3.1, “JavaScript Stored Program Creation and Management”
- Section 27.3.10, “JavaScript Stored Program Examples”
- Section 8.4.1.7, “Kerberos Pluggable Authentication”
- Section 20.2.1.4, “Launching Group Replication”
- Section 8.4.1.6, “LDAP Pluggable Authentication”
- Section 10.2.1.19, “LIMIT Query Optimization”
- Section 15.2.9, “LOAD DATA Statement”
- Section 15.2.10, “LOAD XML Statement”
- Section 9.4.5.1, “Making a Copy of a Database”
- Section 8.1.3, “Making MySQL Secure Against Attackers”
- Section 25.6, “Management of NDB Cluster”
- Section 10.13.1, “Measuring the Speed of Expressions and Functions”
- Section 14.24, “Miscellaneous Functions”
- Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
- Section 8.2.18, “Multifactor Authentication”
- Section A.11, “MySQL 9.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 6.5.1.2, “mysql Client Commands”
- Section 6.5.1.3, “mysql Client Logging”
- Section 6.5.1.1, “mysql Client Options”
- Section 6.5.1.4, “mysql Client Server-Side Help”
- Section 6.5.1.6, “mysql Client Tips”
- Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
- MySQL Glossary
- Section 7.1.15, “MySQL Server Time Zone Support”
- Section 25.6.10, “MySQL Server Usage for NDB Cluster”
- Chapter 21, MySQL Shell
- Section 6.5.1, “mysql — The MySQL Command-Line Client”
- Section 6.3.3, “mysql.server — MySQL Server Startup Script”
- Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
- Section 6.4.3, “mysql_tzinfo_to_sql — Load the Time Zone Tables”
- Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
- Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 6.5.4, “mysqldump — A Database Backup Program”
- Section 6.5.6, “mysqlshow — Display Database, Table, and Column Information”
- Section 25.6.16, “NDB API Statistics Counters and Variables”
- Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”
- Section 25.6.11.1, “NDB Cluster Disk Data Objects”
- Section 25.3.5, “NDB Cluster Example with Tables and Data”
- Section 25.7, “NDB Cluster Replication”
- Section 25.7.12, “NDB Cluster Replication Conflict Resolution”
- Section 25.4.3.9.2, “NDB Cluster System Variables”
- Section 25.5.9, “ndb_desc — Describe NDB Tables”
- Section 25.5.13, “ndb_import — Import CSV Data Into NDB”
- Section 25.5.14, “ndb_index_stat — NDB Index Statistics Utility”
- Section 25.5.5, “ndb_mgm — The NDB Cluster Management Client”
- Section 25.5.17, “ndb_print_backup_file — Print NDB Backup File Contents”
- Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
- Section 25.6.17, “ndbinfo: The NDB Cluster Information Database”
- Section 25.5.2, “ndbinfo_select_all — Select From ndbinfo Tables”
- Section 25.5.32, “ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster”
- Section 7.1.14, “Network Namespace Support”
- Section 8.4.1.9, “OpenID Connect Pluggable Authentication”
- Section 6.2.2.6, “Option Defaults, Options Expecting Values, and the = Sign”
- Section 7.5.9, “Option Tracker Component”
- Section 7.5.9.1, “Option Tracker Tables”
- Section B.3.2.6, “Out of memory”
- Section 6.1, “Overview of MySQL Programs”
- Section B.3.2.8, “Packet Too Large”
- Section 8.4.1.4, “PAM Pluggable Authentication”
- Section 29.12.9, “Performance Schema Connection Attribute Tables”
- Section 8.2.17, “Pluggable Authentication”
- Section 9.5.1, “Point-in-Time Recovery Using Binary Log”
- Section 15.5, “Prepared Statements”
- Section 27.3.6.7, “PreparedStatement Object”
- Section 25.7.5, “Preparing the NDB Cluster for Replication”
- Section 25.6.13, “Privilege Synchronization and NDB_STORED_USER”
- Section 6.2.2.4, “Program Option Modifiers”
- Section 19.1.5.2, “Provisioning a Multi-Source Replica for GTID-Based Replication”
- Section 11.6, “Query Attributes”
- Section 26.2.3.1, “RANGE COLUMNS partitioning”
- Section 8.4.5.6, “Reading Audit Log Files”
- Section 3.14, “Rebuilding or Repairing Tables or Indexes”
- Section 9.4.4, “Reloading Delimited-Text Format Backups”
- Section 9.4.2, “Reloading SQL-Format Backups”
- Section B.3.3.2.3, “Resetting the Root Password: Generic Instructions”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 15.7.1.8, “REVOKE Statement”
- Section 2.9.4, “Securing the Initial MySQL Account”
- Section 8.1.6, “Security Considerations for LOAD DATA LOCAL”
- Section 8.2.16, “Server Handling of Expired Passwords”
- Section 7.1.8, “Server System Variables”
- Section 7.1.17, “Server-Side Help Support”
- Section 27.3.6.1, “Session Object”
- Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT”
- Section 15.1.20.12, “Setting NDB Comment Options”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
- Section 15.7.7.34, “SHOW REPLICA STATUS Statement”
- Section 15.7.7.41, “SHOW WARNINGS Statement”
- Section 15.6.7.5, “SIGNAL Statement”
- Section 8.4.1.10, “Socket Peer-Credential Pluggable Authentication”
- Section 6.2.2, “Specifying Program Options”
- Section 27.3.6.3, “SqlResult Object”
- Section 19.1.5.5, “Starting Multi-Source Replicas”
- Section 2.3.3.8, “Starting MySQL as a Windows Service”
- Section 25.7.6, “Starting NDB Cluster Replication (Single Replication Channel)”
- Section 14.8.1, “String Comparison Functions and Operators”
- Section 14.8, “String Functions and Operators”
- Section 11.1.1, “String Literals”
- Section 2.9.3, “Testing the Server”
- Section 13.3.3, “The BINARY and VARBINARY Types”
- Section 12.10.8, “The Binary Character Set”
- Section 13.3.4, “The BLOB and TEXT Types”
- Section 30.4.4.2, “The diagnostics() Procedure”
- Section 25.6.17.3, “The ndbinfo backup_id Table”
- Section 25.6.17.47, “The ndbinfo memory_per_fragment Table”
- Section 25.6.17.66, “The ndbinfo transporters Table”
- Section 27.4.1, “Trigger Syntax and Examples”
- Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”
- Chapter 5, Tutorial
- Section 6.10, “Unix Signal Handling in MySQL”
- Chapter 3, Upgrading MySQL
- Section 9.3.2, “Using Backups for Recovery”
- Section 19.1.3.5, “Using GTIDs for Failover and Scaleout”
- Section 20.5.6, “Using MySQL Enterprise Backup with Group Replication”
- Section 8.4.7.3, “Using MySQL Enterprise Firewall”
- Section 5.5, “Using mysql in Batch Mode”
- Section 6.6.9.3, “Using mysqlbinlog to Back Up Binary Log Files”
- Section 9.4, “Using mysqldump for Backups”
- Section 6.2.2.2, “Using Option Files”
- Section 6.2.2.1, “Using Options on the Command Line”
- Section 6.2.2.5, “Using Options to Set Program Variables”
- Section 7.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
- Section 10.12.2.3, “Using Symbolic Links for Databases on Windows”
- Section 8.4.1.11, “WebAuthn Pluggable Authentication”
- Section 1.4, “What Is New in MySQL 9.1”
- Section 2.3.5, “Windows Postinstallation Procedures”
- Section 15.2.20, “WITH (Common Table Expressions)”
- Section 14.11, “XML Functions”
mysql-test-run.pl
mysql.exe
mysql.server
- Section 2.5, “Installing MySQL on Linux”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 8.1.3, “Making MySQL Secure Against Attackers”
- Section 6.3.3, “mysql.server — MySQL Server Startup Script”
- Section 6.6.10, “mysqldumpslow — Summarize Slow Query Log Files”
- Section 6.1, “Overview of MySQL Programs”
- Section 7.1.7, “Server Command Options”
- Section 2.9.5, “Starting and Stopping MySQL Automatically”
- Section B.3.3.7, “Time Zone Problems”
mysql.server stop
mysql_config
mysql_config_editor
- Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
- Section 8.1.2.1, “End-User Guidelines for Password Security”
- Section 6.9, “Environment Variables”
- Section 6.7.2, “my_print_defaults — Display Options from Option Files”
- Section 6.6.4.1, “myisamchk General Options”
- Section 6.5.1.1, “mysql Client Options”
- Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
- Section 6.6.8, “mysql_migrate_keyring — Keyring Key Migration Utility”
- Section 6.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
- Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
- Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 6.5.3, “mysqlcheck — A Table Maintenance Program”
- Section 6.5.4, “mysqldump — A Database Backup Program”
- Section 6.5.5, “mysqlimport — A Data Import Program”
- Section 6.5.6, “mysqlshow — Display Database, Table, and Column Information”
- Section 6.5.7, “mysqlslap — A Load Emulation Client”
- Section 6.1, “Overview of MySQL Programs”
- Section 6.2.2.2, “Using Option Files”
mysql_migrate_keyring
mysql_secure_installation
- Section 2.9.1, “Initializing the Data Directory”
- Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
- Section 2.5.5, “Installing MySQL on Linux Using Debian Packages from Oracle”
- Section 2.5.2, “Installing MySQL on Linux Using the MySQL APT Repository”
- Section 2.7.1, “Installing MySQL on Solaris Using a Solaris PKG”
- Section 6.4.2, “mysql_secure_installation — Improve MySQL Installation Security”
- Section 6.1, “Overview of MySQL Programs”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 2.9.4, “Securing the Initial MySQL Account”
mysql_stmt_execute()
mysql_stmt_prepare()
mysql_tzinfo_to_sql
mysqladmin
- Section 8.2.14, “Assigning Account Passwords”
- Section 19.4.1.1, “Backing Up a Replica Using mysqldump”
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section B.3.2.2, “Can't connect to [local] MySQL server”
- Section 8.4.1.3, “Client-Side Cleartext Pluggable Authentication”
- Section 7.1.1, “Configuring the Server”
- Section 6.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 12.4, “Connection Character Sets and Collations”
- Section 6.2.8, “Connection Compression Control”
- Section 15.1.12, “CREATE DATABASE Statement”
- Section 2.3.3.7, “Customizing the PATH for MySQL Tools”
- Section 7.9.1, “Debugging a MySQL Server”
- Section 15.1.24, “DROP DATABASE Statement”
- Section 15.7.8.3, “FLUSH Statement”
- Section 2.4.1, “General Notes on Installing MySQL on macOS”
- Section B.3.1, “How to Determine What Is Causing a Problem”
- Section 9.6.3, “How to Repair MyISAM Tables”
- Section 1.6, “How to Report Bugs or Problems”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 20.4, “Monitoring Group Replication”
- Section A.11, “MySQL 9.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 7.4, “MySQL Server Logs”
- Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
- Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
- Section 6.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
- Section 6.1, “Overview of MySQL Programs”
- Section 29.12.9, “Performance Schema Connection Attribute Tables”
- Section 8.2.17, “Pluggable Authentication”
- Section 8.2.2, “Privileges Provided by MySQL”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 7.8.3, “Running Multiple MySQL Instances on Unix”
- Section 2.9.4, “Securing the Initial MySQL Account”
- Section 19.1.3.4, “Setting Up Replication Using GTIDs”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
- Section 2.3.3.8, “Starting MySQL as a Windows Service”
- Section 2.3.3.6, “Starting MySQL from the Windows Command Line”
- Section 2.9.3, “Testing the Server”
- Section 1.2.2, “The Main Features of MySQL”
- Section 7.1.19, “The Server Shutdown Process”
- Section 3.11, “Upgrading MySQL on Windows”
- Section 6.2.2.2, “Using Option Files”
- Section 6.2.2.1, “Using Options on the Command Line”
- Section 7.6.4.2, “Using the Rewriter Query Rewrite Plugin”
- Section B.3.3.3, “What to Do If MySQL Keeps Crashing”
mysqladmin debug
mysqladmin extended-status
mysqladmin flush-hosts
mysqladmin flush-logs
mysqladmin flush-logs binary
mysqladmin flush-privileges
- Section 3.15, “Copying MySQL Databases to Another Machine”
- Section 8.2.3, “Grant Tables”
- Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
- Section 19.3.3.3, “Recovering From Failed Replication Privilege Checks”
- Section 19.3.3, “Replication Privilege Checks”
- Section 7.1.7, “Server Command Options”
- Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”
- Section 8.2.13, “When Privilege Changes Take Effect”
mysqladmin flush-tables
- Section 10.6.2, “Bulk Data Loading for MyISAM Tables”
- Section 10.11.5, “External Locking”
- Section 10.4.3.1, “How MySQL Opens and Closes Tables”
- Section 10.12.3.1, “How MySQL Uses Memory”
- Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
- Section 9.6.1, “Using myisamchk for Crash Recovery”
mysqladmin flush-xxx
mysqladmin kill
mysqladmin password
mysqladmin processlist
mysqladmin processlist status
mysqladmin refresh
mysqladmin reload
- Section 8.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”
- Section 8.2.3, “Grant Tables”
- Section 1.6, “How to Report Bugs or Problems”
- Section 19.3.3.3, “Recovering From Failed Replication Privilege Checks”
- Section 19.3.3, “Replication Privilege Checks”
- Section 7.1.7, “Server Command Options”
- Section 8.2.21, “Setting Account Resource Limits”
- Section 8.2.13, “When Privilege Changes Take Effect”
mysqladmin reload version
mysqladmin shutdown
- Section 8.2.7, “Access Control, Stage 2: Request Verification”
- Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 7.9.1.2, “Creating Trace Files”
- Section 15.7.1.6, “GRANT Statement”
- Section 9.6.3, “How to Repair MyISAM Tables”
- Section 8.1.5, “How to Run MySQL as a Normal User”
- Section 2.4.2, “Installing MySQL on macOS Using Native Packages”
- Section 7.9.1.7, “Making a Test Case If You Experience Table Corruption”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 6.3.3, “mysql.server — MySQL Server Startup Script”
- Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
- Section 25.5.13, “ndb_import — Import CSV Data Into NDB”
- Section 8.2.2, “Privileges Provided by MySQL”
- Section 19.5.1.32, “Replication and Temporary Tables”
- Section 25.3.6, “Safe Shutdown and Restart of NDB Cluster”
- Section 15.7.8.9, “SHUTDOWN Statement”
- Section 2.3.3.8, “Starting MySQL as a Windows Service”
- Section 7.1.19, “The Server Shutdown Process”
- Section 20.8.3.2, “Upgrading a Group Replication Member”
- Section B.3.3.3, “What to Do If MySQL Keeps Crashing”
mysqladmin status
mysqladmin variables
mysqladmin variables extended-status processlist
mysqladmin ver
mysqladmin version
mysqlbackup
- Section 9.1, “Backup and Recovery Types”
- Section 19.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
- Section 20.8.3.4, “Group Replication Upgrade with mysqlbackup”
- Section 17.18.1, “InnoDB Backup”
- Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
- MySQL Glossary
- Section 6.5.4, “mysqldump — A Database Backup Program”
- Section 19.1.3.5, “Using GTIDs for Failover and Scaleout”
- Section 20.5.6, “Using MySQL Enterprise Backup with Group Replication”
mysqlbinlog
- Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 7.4.4.5, “Binary Log Transaction Compression”
- Section 19.1.6.4, “Binary Logging Options and Variables”
- Section 15.7.8.1, “BINLOG Statement”
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 6.2.8, “Connection Compression Control”
- Section 19.4.11, “Delayed Replication”
- Section 19.3.2, “Encrypting Binary Log Files and Relay Log Files”
- Section 19.1.3.1, “GTID Format and Storage”
- Section 19.1.3.2, “GTID Life Cycle”
- Section 19.5.5, “How to Report Replication Bugs or Problems”
- Section 17.18.2, “InnoDB Recovery”
- Section 15.1.20.10, “Invisible Columns”
- Section B.3.7, “Known Issues in MySQL”
- Section 14.24, “Miscellaneous Functions”
- Section 7.4.4.5.3, “Monitoring Binary Log Transaction Compression”
- Section 6.5.1.1, “mysql Client Options”
- MySQL Glossary
- Section 6.6.9.1, “mysqlbinlog Hex Dump Format”
- Section 6.6.9.2, “mysqlbinlog Row Event Display”
- Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 25.7.11, “NDB Cluster Replication Using the Multithreaded Applier”
- Section 25.4.3.9.2, “NDB Cluster System Variables”
- Section 26.3.5, “Obtaining Information About Partitions”
- Section 6.1, “Overview of MySQL Programs”
- Section 29.12.9, “Performance Schema Connection Attribute Tables”
- Section 9.5.1, “Point-in-Time Recovery Using Binary Log”
- Section 9.5.2, “Point-in-Time Recovery Using Event Positions”
- Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
- Section 19.3.3.1, “Privileges For The Replication PRIVILEGE_CHECKS_USER Account”
- Section 8.2.2, “Privileges Provided by MySQL”
- Section 19.3.3.3, “Recovering From Failed Replication Privilege Checks”
- Section 19.5.1.20, “Replication and LOAD DATA”
- Section 19.5.1.40, “Replication and Variables”
- Section 19.3.3, “Replication Privilege Checks”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 19.3.2.1, “Scope of Binary Log Encryption”
- Section 8.1.6, “Security Considerations for LOAD DATA LOCAL”
- Section 7.1.8, “Server System Variables”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
- Section 15.7.7.3, “SHOW BINLOG EVENTS Statement”
- Section 15.7.7.33, “SHOW RELAYLOG EVENTS Statement”
- Section 19.1.7.3, “Skipping Transactions”
- Section 6.6.9.4, “Specifying the mysqlbinlog Server ID”
- Section 15.4.2.4, “START REPLICA Statement”
- Section 7.4.4, “The Binary Log”
- Section 7.4.3, “The General Query Log”
- Section 19.2.4.1, “The Relay Log”
- Section 19.2.1.2, “Usage of Row-Based Logging and Replication”
- Section 9.3.2, “Using Backups for Recovery”
- Section 19.1.3.5, “Using GTIDs for Failover and Scaleout”
- Section 6.6.9.3, “Using mysqlbinlog to Back Up Binary Log Files”
- Section 7.6.4.2, “Using the Rewriter Query Rewrite Plugin”
mysqlbinlog binary-log-file | mysql
mysqlbinlog|mysql
mysqlcheck
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 8.4.1.3, “Client-Side Cleartext Pluggable Authentication”
- Section 12.4, “Connection Character Sets and Collations”
- Section 6.2.8, “Connection Compression Control”
- Section 6.7.2, “my_print_defaults — Display Options from Option Files”
- Section 9.6, “MyISAM Table Maintenance and Crash Recovery”
- Section 6.5.3, “mysqlcheck — A Table Maintenance Program”
- Section 6.1, “Overview of MySQL Programs”
- Section 3.6, “Preparing Your Installation for Upgrade”
- Section 3.14, “Rebuilding or Repairing Tables or Indexes”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 7.1.8, “Server System Variables”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
- Section 1.2.2, “The Main Features of MySQL”
- Section 18.2, “The MyISAM Storage Engine”
mysqld
- Section 1.1, “About This Manual”
- Section 15.1.2, “ALTER DATABASE Statement”
- Section 10.2.1.23, “Avoiding Full Table Scans”
- Section 2.5.6.1, “Basic Steps for MySQL Server Deployment with Docker”
- Section 7.4.4.5, “Binary Log Transaction Compression”
- Section 7.4.4.1, “Binary Logging Formats”
- Section 19.1.6.4, “Binary Logging Options and Variables”
- Section 25.3.1.4, “Building NDB Cluster from Source on Linux”
- Section B.3.2.2, “Can't connect to [local] MySQL server”
- Section B.3.2.11, “Can't create/write to file”
- Section B.3.2.15, “Can't initialize character set”
- Section 15.4.2.1, “CHANGE REPLICATION FILTER Statement”
- Section 6.2.2.3, “Command-Line Options that Affect Option-File Handling”
- Section 25.6.1, “Commands in the NDB Cluster Management Client”
- Section 11.7, “Comments”
- Section B.3.2.9, “Communication Errors and Aborted Connections”
- Section 6.4.1, “comp_err — Compile MySQL Error Message File”
- Section 7.9.1.1, “Compiling MySQL for Debugging”
- Section 25.4, “Configuration of NDB Cluster”
- Section 2.8.6, “Configuring SSL Library Support”
- Section 7.1.1, “Configuring the Server”
- Section 7.1.12.1, “Connection Interfaces”
- Section 18.2.4.1, “Corrupted MyISAM Tables”
- Section 15.1.20, “CREATE TABLE Statement”
- Section 7.9.1.2, “Creating Trace Files”
- Section 17.7.5, “Deadlocks in InnoDB”
- Section 7.9.1, “Debugging a MySQL Server”
- Section 7.9.1.4, “Debugging mysqld under gdb”
- Section 7.4.2.2, “Default Error Log Destination Configuration”
- Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
- Section 25.4.3.7, “Defining SQL and Other API Nodes in an NDB Cluster”
- Section 7.1.12.3, “DNS Lookups and the Host Cache”
- Section 17.6.4, “Doublewrite Buffer”
- Section 17.17.2, “Enabling InnoDB Monitors”
- Section 10.12.3.3, “Enabling Large Page Support”
- Section 10.2.1.5, “Engine Condition Pushdown Optimization”
- Section 6.9, “Environment Variables”
- Section 7.4.2.3, “Error Event Fields”
- Section 7.4.2.10, “Error Log File Flushing and Renaming”
- Section 7.4.2.9, “Error Log Output Format”
- Section 7.4.2.8, “Error Logging to the System Log”
- Section 25.6.2.3, “Event Buffer Reporting in the Cluster Log”
- Section 17.8.3.7, “Excluding or Including Buffer Pool Pages from Core Files”
- Section 10.11.5, “External Locking”
- Section B.3.2.16, “File Not Found and Similar Errors”
- Section 17.6.3.2, “File-Per-Table Tablespaces”
- Section 14.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 17.20.3, “Forcing InnoDB Recovery”
- Section 25.1, “General Information”
- Section 25.7.2, “General Requirements for NDB Cluster Replication”
- Section 10.14.3, “General Thread States”
- Section 10.12.3.1, “How MySQL Uses Memory”
- Section B.3.1, “How to Determine What Is Causing a Problem”
- Section 9.6.3, “How to Repair MyISAM Tables”
- Section 1.6, “How to Report Bugs or Problems”
- Section 8.1.5, “How to Run MySQL as a Normal User”
- Section B.3.2.13, “Ignoring user”
- Section 25.7.8, “Implementing Failover with NDB Cluster Replication”
- Section 14.15, “Information Functions”
- Section 25.3.3, “Initial Configuration of NDB Cluster”
- Section 25.3.4, “Initial Startup of NDB Cluster”
- Section 2.9.1, “Initializing the Data Directory”
- Section 17.18.1, “InnoDB Backup”
- Section 17.11.1, “InnoDB Disk I/O”
- Section 17.8.1, “InnoDB Startup Configuration”
- Section 17.14, “InnoDB Startup Options and System Variables”
- Section 17.20, “InnoDB Troubleshooting”
- Section 15.2.7.2, “INSERT ... ON DUPLICATE KEY UPDATE Statement”
- Section 15.2.7, “INSERT Statement”
- Section 25.3.1, “Installation of NDB Cluster on Linux”
- Section 25.3.1.1, “Installing an NDB Cluster Binary Release on Linux”
- Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
- Section 2.4.2, “Installing MySQL on macOS Using Native Packages”
- Section 2.3, “Installing MySQL on Microsoft Windows”
- Section 2.7, “Installing MySQL on Solaris”
- Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 25.3.2.1, “Installing NDB Cluster on Windows from a Binary Release”
- Section 25.3.2.4, “Installing NDB Cluster Processes as Windows Services”
- Section 25.2.7.8, “Issues Exclusive to NDB Cluster”
- Section 8.4.4.2, “Keyring Component Installation”
- Section 15.7.8.4, “KILL Statement”
- Section 25.7.3, “Known Issues in NDB Cluster Replication”
- Section 15.2.9, “LOAD DATA Statement”
- Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
- Section 14.14, “Locking Functions”
- Section 7.9.1.7, “Making a Test Case If You Experience Table Corruption”
- Section 8.1.3, “Making MySQL Secure Against Attackers”
- Section 25.6, “Management of NDB Cluster”
- Section 2.5.9, “Managing MySQL Server with systemd”
- Section 8.4.4.12, “Migrating Keys Between Keyring Keystores”
- Section 14.24, “Miscellaneous Functions”
- Section 7.4.4.3, “Mixed Binary Logging Format”
- Section 17.6.1.4, “Moving or Copying InnoDB Tables”
- Section 18.2.1, “MyISAM Startup Options”
- Section 6.6.4.2, “myisamchk Check Options”
- Section 6.6.4.1, “myisamchk General Options”
- Section 6.6.4, “myisamchk — MyISAM Table-Maintenance Utility”
- Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”
- Section A.1, “MySQL 9.1 FAQ: General”
- Section A.11, “MySQL 9.1 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section A.3, “MySQL 9.1 FAQ: Server SQL Mode”
- Section 6.5.1.6, “mysql Client Tips”
- MySQL Glossary
- Chapter 7, MySQL Server Administration
- Section B.3.2.7, “MySQL server has gone away”
- Section 7.4, “MySQL Server Logs”
- Section 25.4.3.9.1, “MySQL Server Options for NDB Cluster”
- Section 7.1.15, “MySQL Server Time Zone Support”
- Section 25.6.10, “MySQL Server Usage for NDB Cluster”
- Section 25.2.6, “MySQL Server Using InnoDB Compared with NDB Cluster”
- Section 2.8.7, “MySQL Source-Configuration Options”
- Section 1.7, “MySQL Standards Compliance”
- Chapter 30, MySQL sys Schema
- Section 6.3.3, “mysql.server — MySQL Server Startup Script”
- Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”
- Section 6.5.3, “mysqlcheck — A Table Maintenance Program”
- Section 6.3.1, “mysqld — The MySQL Server”
- Section 6.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
- Section 6.3.2, “mysqld_safe — MySQL Server Startup Script”
- Section 6.5.4, “mysqldump — A Database Backup Program”
- Section 25.6.16, “NDB API Statistics Counters and Variables”
- Section 25.6.21.3, “NDB Cluster and MySQL Security Procedures”
- Section 25.4.3.1, “NDB Cluster Configuration: Basic Example”
- Section 25.2.1, “NDB Cluster Core Concepts”
- Section 25.3, “NDB Cluster Installation”
- Section 25.4.2.5, “NDB Cluster mysqld Option and Variable Reference”
- Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
- Section 25.2, “NDB Cluster Overview”
- Section 25.5, “NDB Cluster Programs”
- Section 25.7, “NDB Cluster Replication”
- Section 25.7.12, “NDB Cluster Replication Conflict Resolution”
- Section 25.7.4, “NDB Cluster Replication Schema and Tables”
- Section 25.7.11, “NDB Cluster Replication Using the Multithreaded Applier”
- Section 25.7.10, “NDB Cluster Replication: Bidirectional and Circular Replication”
- Section 25.4.3.9.3, “NDB Cluster Status Variables”
- Section 25.4.3.9.2, “NDB Cluster System Variables”
- Section 25.5.13, “ndb_import — Import CSV Data Into NDB”
- Section 25.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
- Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
- Section 25.5.27, “ndb_show_tables — Display List of NDB Tables”
- Section 25.5.30, “ndb_top — View CPU usage information for NDB threads”
- Section 25.6.17, “ndbinfo: The NDB Cluster Information Database”
- Section 7.1.14, “Network Namespace Support”
- Section 25.2.7.1, “Noncompliance with SQL Syntax in NDB Cluster”
- Section 25.6.12, “Online Operations with ALTER TABLE in NDB Cluster”
- Section 15.7.3.4, “OPTIMIZE TABLE Statement”
- Section B.3.5, “Optimizer-Related Issues”
- Section 10.5.4, “Optimizing InnoDB Redo Logging”
- Section 7.5.9, “Option Tracker Component”
- Section 7.5.9.2, “Option Tracker Supported Components”
- Section 25.2.5, “Options, Variables, and Parameters Added, Deprecated or Removed in NDB 9.1”
- Section 6.1, “Overview of MySQL Programs”
- Section 25.4.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”
- Section B.3.2.8, “Packet Too Large”
- Section 29.3, “Performance Schema Startup Configuration”
- Section 29.12.14.3, “Performance Schema variables_info Table”
- Section 29.12.14.4, “Performance Schema variables_metadata Table”
- Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
- Section 25.7.5, “Preparing the NDB Cluster for Replication”
- Section 18.2.4.2, “Problems from Tables Not Being Closed Properly”
- Section B.3.3.1, “Problems with File Permissions”
- Section 6.2.2.4, “Program Option Modifiers”
- Section 15.7.3.5, “REPAIR TABLE Statement”
- Section 19.1.6.1, “Replication and Binary Logging Option and Variable Reference”
- Section 19.1.6, “Replication and Binary Logging Options and Variables”
- Section 19.5.1.29, “Replication and Source or Replica Shutdowns”
- Section 19.5.1.35, “Replication and Transaction Inconsistencies”
- Section 19.2.4.2, “Replication Metadata Repositories”
- Section 19.1.6.2, “Replication Source Options and Variables”
- Section B.3.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
- Section B.3.3.2.1, “Resetting the Root Password: Windows Systems”
- Section 7.1.16, “Resource Groups”
- Section 15.7.8.8, “RESTART Statement”
- Section B.3.4.5, “Rollback Failure for Nontransactional Tables”
- Section 7.8, “Running Multiple MySQL Instances on One Machine”
- Section 2.9.4, “Securing the Initial MySQL Account”
- Section 8.1.6, “Security Considerations for LOAD DATA LOCAL”
- Section 8.1.4, “Security-Related mysqld Options and Variables”
- Section 15.2.13.1, “SELECT ... INTO Statement”
- Section 2.3.3.3, “Selecting a MySQL Server Type”
- Section 8.7, “SELinux”
- Section 6.3, “Server and Server-Startup Programs”
- Section 12.3.2, “Server Character Set and Collation”
- Section 7.1.7, “Server Command Options”
- Section 7.4.6, “Server Log Maintenance”
- Section 7.1.10, “Server Status Variables”
- Section 7.1.8, “Server System Variables”
- Section 12.12, “Setting the Error Message Language”
- Section 8.7.5.2, “Setting the TCP Port Context for MySQL Features”
- Section 8.7.5.1, “Setting the TCP Port Context for mysqld”
- Section 9.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
- Section 19.1.3.4, “Setting Up Replication Using GTIDs”
- Section 15.7.7.16, “SHOW ENGINE Statement”
- Section 6.2.2, “Specifying Program Options”
- Section 15.4.2.4, “START REPLICA Statement”
- Section 2.9.5, “Starting and Stopping MySQL Automatically”
- Section 7.8.2.2, “Starting Multiple MySQL Instances as Windows Services”
- Section 7.8.2.1, “Starting Multiple MySQL Instances at the Windows Command Line”
- Section 2.3.3.8, “Starting MySQL as a Windows Service”
- Section 2.3.3.6, “Starting MySQL from the Windows Command Line”
- Section 25.7.6, “Starting NDB Cluster Replication (Single Replication Channel)”
- Section 19.2.2.3, “Startup Options and Replication Channels”
- Section 19.4.8, “Switching Sources During Failover”
- Section 10.11.2, “Table Locking Issues”
- Section B.3.2.17, “Table-Corruption Issues”
- Section 2.3.3.9, “Testing The MySQL Installation”
- Section 2.9.3, “Testing the Server”
- Section 7.4.4, “The Binary Log”
- Section 18.6, “The BLACKHOLE Storage Engine”
- Section 7.9.4, “The DBUG Package”
- Section 7.4.2, “The Error Log”
- Section 7.4.3, “The General Query Log”
- Section 18.2, “The MyISAM Storage Engine”
- Section 7.1, “The MySQL Server”
- Section 29.12.22.6, “The mysql_option Table”
- Section 25.6.17.49, “The ndbinfo operations_per_fragment Table”
- Section 25.6.17.54, “The ndbinfo server_locks Table”
- Section 29.12.2.3, “The setup_instruments Table”
- Section 7.4.5, “The Slow Query Log”
- Section B.3.3.7, “Time Zone Problems”
- Section B.3.2.5, “Too many connections”
- Section 2.3.4, “Troubleshooting a Microsoft Windows MySQL Server Installation”
- Section 17.20.1, “Troubleshooting InnoDB I/O Problems”
- Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”
- Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
- Section 6.10, “Unix Signal Handling in MySQL”
- Section 3.13, “Upgrade Troubleshooting”
- Section 3.7, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
- Section 3.11, “Upgrading MySQL on Windows”
- Section 7.9.1.5, “Using a Stack Trace”
- Section 9.6.1, “Using myisamchk for Crash Recovery”
- Section 6.2.2.2, “Using Option Files”
- Section 7.9.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
- Section 10.12.2.3, “Using Symbolic Links for Databases on Windows”
- Section 10.12.2.2, “Using Symbolic Links for MyISAM Tables on Unix”
- Section 25.6.15.3, “Using TLS Connections”
- Section 25.7.7, “Using Two Replication Channels for NDB Cluster Replication”
- Section 7.9.1.3, “Using WER with PDB to create a Windows crashdump”
- Section B.3.3.3, “What to Do If MySQL Keeps Crashing”
- Section 8.2.13, “When Privilege Changes Take Effect”
- Section B.3.3.5, “Where MySQL Stores Temporary Files”
- Section 2.1.2, “Which MySQL Version and Distribution to Install”
mysqld mysqld.trace
mysqld-auto.cnf
mysqld-debug
mysqld.exe
mysqld_multi
mysqld_multi.server
mysqld_safe
- Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 7.9.1.1, “Compiling MySQL for Debugging”
- Section 7.1.1, “Configuring the Server”
- Section 7.4.2.2, “Default Error Log Destination Configuration”
- Section B.3.2.16, “File Not Found and Similar Errors”
- Section B.3.3.6, “How to Protect or Change the MySQL Unix Socket File”
- Section 17.20, “InnoDB Troubleshooting”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 8.1.3, “Making MySQL Secure Against Attackers”
- Section 2.5.9, “Managing MySQL Server with systemd”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 7.1.15, “MySQL Server Time Zone Support”
- Section 2.8.7, “MySQL Source-Configuration Options”
- Section 6.3.3, “mysql.server — MySQL Server Startup Script”
- Section 6.3.4, “mysqld_multi — Manage Multiple MySQL Servers”
- Section 6.3.2, “mysqld_safe — MySQL Server Startup Script”
- Section 25.6.21.3, “NDB Cluster and MySQL Security Procedures”
- Section 6.2.2.6, “Option Defaults, Options Expecting Values, and the = Sign”
- Section 6.1, “Overview of MySQL Programs”
- Section B.3.2.8, “Packet Too Large”
- Section 29.12.14.3, “Performance Schema variables_info Table”
- Section B.3.3.1, “Problems with File Permissions”
- Section 15.7.8.8, “RESTART Statement”
- Section 7.8, “Running Multiple MySQL Instances on One Machine”
- Section 7.8.3, “Running Multiple MySQL Instances on Unix”
- Section 7.1.7, “Server Command Options”
- Section 7.1.8, “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 7.4.2, “The Error Log”
- Section B.3.3.7, “Time Zone Problems”
- Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
- Section 3.7, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
- Section 6.2.2.2, “Using Option Files”
mysqldump
- Section 15.1.2, “ALTER DATABASE Statement”
- Section 19.4.1.1, “Backing Up a Replica Using mysqldump”
- Section 19.4.1.3, “Backing Up a Source or Replica by Making It Read Only”
- Chapter 9, Backup and Recovery
- Section 9.1, “Backup and Recovery Types”
- Section 9.3.3, “Backup Strategy Summary”
- Section 17.5.1, “Buffer Pool”
- Section 10.5.5, “Bulk Data Loading for InnoDB Tables”
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 19.1.2.5, “Choosing a Method for Data Snapshots”
- Section 8.4.1.3, “Client-Side Cleartext Pluggable Authentication”
- Section 6.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”
- Section 6.2.8, “Connection Compression Control”
- Section 6.2.7, “Connection Transport Protocols”
- Section 12.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”
- Section 9.4.5.2, “Copy a Database from one Server to Another”
- Section 3.15, “Copying MySQL Databases to Another Machine”
- Section 15.1.20, “CREATE TABLE Statement”
- Section 15.1.21, “CREATE TABLESPACE Statement”
- Section 19.1.2.5.1, “Creating a Data Snapshot Using mysqldump”
- Section 2.3.3.7, “Customizing the PATH for MySQL Tools”
- Section 16.7, “Data Dictionary Usage Differences”
- Section 9.2, “Database Backup Methods”
- Section 17.11.4, “Defragmenting a Table”
- Section 9.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
- Section 9.4.1, “Dumping Data in SQL Format with mysqldump”
- Section 9.4.5.3, “Dumping Stored Programs”
- Section 9.4.5.4, “Dumping Table Definitions and Content Separately”
- Section 9.3.1, “Establishing a Backup Policy”
- Section 9.3, “Example Backup and Recovery Strategy”
- Section 15.1.20.5, “FOREIGN KEY Constraints”
- Section 15.1.20.11, “Generated Invisible Primary Keys”
- Section 19.1.6.5, “Global Transaction ID System Variables”
- Section 1.6, “How to Report Bugs or Problems”
- Section 15.2.6, “IMPORT TABLE Statement”
- Section 25.6.9, “Importing Data Into MySQL Cluster”
- Section 6.6.2, “innochecksum — Offline InnoDB File Checksum Utility”
- Section 17.18.1, “InnoDB Backup”
- Section 2.6, “Installing MySQL Using Unbreakable Linux Network (ULN)”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 15.1.20.10, “Invisible Columns”
- Section 8.4.1.7, “Kerberos Pluggable Authentication”
- Section 15.2.9, “LOAD DATA Statement”
- Section 15.2.10, “LOAD XML Statement”
- Section 9.4.5.1, “Making a Copy of a Database”
- Section 2.5.6.2, “More Topics on Deploying MySQL Server with Docker”
- Section 17.6.1.4, “Moving or Copying InnoDB Tables”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 6.5.1.1, “mysql Client Options”
- Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”
- Section 1.3, “MySQL Releases: Innovation and LTS”
- Section 2.3.2.1.1, “MySQL Server Installations”
- Section 7.4, “MySQL Server Logs”
- Section 6.6.7, “mysql_config_editor — MySQL Configuration Utility”
- Section 9.4.5, “mysqldump Tips”
- Section 6.5.4, “mysqldump — A Database Backup Program”
- Section 25.3.5, “NDB Cluster Example with Tables and Data”
- Section 25.2, “NDB Cluster Overview”
- Section 25.5.13, “ndb_import — Import CSV Data Into NDB”
- Section 25.6.17, “ndbinfo: The NDB Cluster Information Database”
- Section 19.1.2.4, “Obtaining the Replication Source Binary Log Coordinates”
- Section 25.6.8, “Online Backup of NDB Cluster”
- Section 6.1, “Overview of MySQL Programs”
- Section 29.12.9, “Performance Schema Connection Attribute Tables”
- Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
- Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
- Section 25.7.5, “Preparing the NDB Cluster for Replication”
- Section 8.2.2, “Privileges Provided by MySQL”
- Section B.3.4.8, “Problems with Floating-Point Values”
- Section 19.1.5.2, “Provisioning a Multi-Source Replica for GTID-Based Replication”
- Section 17.8.9, “Purge Configuration”
- Section 3.14, “Rebuilding or Repairing Tables or Indexes”
- Section 9.4.4, “Reloading Delimited-Text Format Backups”
- Section 9.4.2, “Reloading SQL-Format Backups”
- Section 19.4.6, “Replicating Different Databases to Different Replicas”
- Section 19.5.1.35, “Replication and Transaction Inconsistencies”
- Section 29.20, “Restrictions on Performance Schema”
- Section 27.10, “Restrictions on Views”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
- Section 7.4.6, “Server Log Maintenance”
- Section 7.1.11, “Server SQL Modes”
- Section 7.1.8, “Server System Variables”
- Section 15.4.1.3, “SET sql_log_bin Statement”
- Section 19.1.2.6.2, “Setting Up Replication with Existing Data”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
- Section B.3.4.7, “Solving Problems with No Matching Rows”
- Section 2.3.3.8, “Starting MySQL as a Windows Service”
- Section 19.1.3.8, “Stored Function Examples to Manipulate GTIDs”
- Section 13.3.4, “The BLOB and TEXT Types”
- Section 1.2.2, “The Main Features of MySQL”
- Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”
- Section 15.7.4.6, “UNINSTALL PLUGIN Statement”
- Section 3.7, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”
- Section 19.1.3.5, “Using GTIDs for Failover and Scaleout”
- Section 6.6.9.3, “Using mysqlbinlog to Back Up Binary Log Files”
- Section 9.4, “Using mysqldump for Backups”
- Section 6.2.2.2, “Using Option Files”
- Section 19.4.1, “Using Replication for Backups”
- Section 19.4.4, “Using Replication with Different Source and Replica Storage Engines”
- Section 7.6.4.2, “Using the Rewriter Query Rewrite Plugin”
- Section 30.2, “Using the sys Schema”
- Section 14.11, “XML Functions”
mysqldump mysql
mysqldumpslow
mysqlimport
- Section 9.1, “Backup and Recovery Types”
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 12.4, “Connection Character Sets and Collations”
- Section 6.2.8, “Connection Compression Control”
- Section 3.15, “Copying MySQL Databases to Another Machine”
- Section 9.2, “Database Backup Methods”
- Section 15.2.9, “LOAD DATA Statement”
- Section 6.5.5, “mysqlimport — A Data Import Program”
- Section 6.1, “Overview of MySQL Programs”
- Section 9.4.4, “Reloading Delimited-Text Format Backups”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 8.1.6, “Security Considerations for LOAD DATA LOCAL”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
mysqlsh
mysqlshow
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 8.4.1.3, “Client-Side Cleartext Pluggable Authentication”
- Section 6.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 12.4, “Connection Character Sets and Collations”
- Section 6.2.8, “Connection Compression Control”
- Section 6.5.6, “mysqlshow — Display Database, Table, and Column Information”
- Section 6.1, “Overview of MySQL Programs”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
- Section 15.7.7.15, “SHOW DATABASES Statement”
- Section 15.7.7.23, “SHOW INDEX Statement”
- Section 15.7.7.37, “SHOW TABLE STATUS Statement”
- Section 2.3.3.9, “Testing The MySQL Installation”
- Section 2.9.3, “Testing the Server”
- Section 2.3.5, “Windows Postinstallation Procedures”
mysqlshow db_name
mysqlshow db_name tbl_name
mysqlslap
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 8.4.1.3, “Client-Side Cleartext Pluggable Authentication”
- Section 6.2.8, “Connection Compression Control”
- Section 17.16.2, “Monitoring InnoDB Mutex Waits Using Performance Schema”
- Section 6.5.7, “mysqlslap — A Load Emulation Client”
- Section 6.1, “Overview of MySQL Programs”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
- Section 10.13.2, “Using Your Own Benchmarks”
mysqltest
- Section 8.4.1.1, “Caching SHA-2 Pluggable Authentication”
- Section 6.2.8, “Connection Compression Control”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 8.3.5, “Reusing SSL Sessions”
- Section 7.1.18, “Server Tracking of Client Session State”
- Section 8.4.1.2, “SHA-256 Pluggable Authentication”
mysqlxtest
ndb_blob_tool
ndb_config
ndb_desc
- Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 26.2.5, “KEY Partitioning”
- Section 25.6.21.3, “NDB Cluster and MySQL Security Procedures”
- Section 25.6.11.1, “NDB Cluster Disk Data Objects”
- Section 25.5.9, “ndb_desc — Describe NDB Tables”
- Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
- Section 15.1.20.12, “Setting NDB Comment Options”
- Section 28.3.15, “The INFORMATION_SCHEMA FILES Table”
- Section 28.3.21, “The INFORMATION_SCHEMA PARTITIONS Table”
- Section 25.6.17.8, “The ndbinfo cluster_operations Table”
- Section 25.6.17.55, “The ndbinfo server_operations Table”
ndb_drop_table
ndb_error_reporter
ndb_import
ndb_index_stat
ndb_mgm
- Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 25.6.7.1, “Adding NDB Cluster Data Nodes Online: General Issues”
- Section 25.3.1.4, “Building NDB Cluster from Source on Linux”
- Section 25.6.1, “Commands in the NDB Cluster Management Client”
- Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
- Section 25.6.3, “Event Reports Generated in NDB Cluster”
- Section 25.1, “General Information”
- Section 25.3.4, “Initial Startup of NDB Cluster”
- Section 25.3.2.3, “Initial Startup of NDB Cluster on Windows”
- Section 25.3.1, “Installation of NDB Cluster on Linux”
- Section 25.3.1.1, “Installing an NDB Cluster Binary Release on Linux”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 25.3.1.3, “Installing NDB Cluster Using .deb Files”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 25.2.1, “NDB Cluster Core Concepts”
- Section 25.2.3, “NDB Cluster Hardware, Software, and Networking Requirements”
- Section 25.6.3.1, “NDB Cluster Logging Management Commands”
- Section 25.5, “NDB Cluster Programs”
- Section 25.6.21.1, “NDB Cluster Security and Networking Issues”
- Section 25.6.6, “NDB Cluster Single User Mode”
- Section 25.5.5, “ndb_mgm — The NDB Cluster Management Client”
- Section 25.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
- Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
- Section 25.5.28, “ndb_sign_keys — Create, Sign, and Manage TLS Keys and Certificates for NDB Cluster”
- Section 25.6.8, “Online Backup of NDB Cluster”
- Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
- Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
- Section 25.3.6, “Safe Shutdown and Restart of NDB Cluster”
- Section 25.6.17.1, “The ndbinfo arbitrator_validity_detail Table”
- Section 25.6.17.3, “The ndbinfo backup_id Table”
- Section 25.6.17.45, “The ndbinfo membership Table”
- Section 25.6.17.46, “The ndbinfo memoryusage Table”
- Section 25.6.17.48, “The ndbinfo nodes Table”
- Section 25.6.17.66, “The ndbinfo transporters Table”
- Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”
- Section 25.6.15.3, “Using TLS Connections”
ndb_mgm.exe
ndb_mgmd
- Section 25.3.1.4, “Building NDB Cluster from Source on Linux”
- Section 25.6.1, “Commands in the NDB Cluster Management Client”
- Section 25.4.3.5, “Defining an NDB Cluster Management Server”
- Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
- Section 25.3.4, “Initial Startup of NDB Cluster”
- Section 25.3.1, “Installation of NDB Cluster on Linux”
- Section 25.3.1.1, “Installing an NDB Cluster Binary Release on Linux”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 25.3.2.1, “Installing NDB Cluster on Windows from a Binary Release”
- Section 25.3.1.3, “Installing NDB Cluster Using .deb Files”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 2.8.7, “MySQL Source-Configuration Options”
- Section 25.4.3.1, “NDB Cluster Configuration: Basic Example”
- Section 25.4.3.3, “NDB Cluster Connection Strings”
- Section 25.2.1, “NDB Cluster Core Concepts”
- Section 25.6.3.1, “NDB Cluster Logging Management Commands”
- Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
- Section 25.5, “NDB Cluster Programs”
- Section 25.4.3.10, “NDB Cluster TCP/IP Connections”
- Section 25.5.6, “ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables”
- Section 25.5.8, “ndb_delete_all — Delete All Rows from an NDB Table”
- Section 25.5.9, “ndb_desc — Describe NDB Tables”
- Section 25.5.10, “ndb_drop_index — Drop Index from an NDB Table”
- Section 25.5.11, “ndb_drop_table — Drop an NDB Table”
- Section 25.5.13, “ndb_import — Import CSV Data Into NDB”
- Section 25.5.14, “ndb_index_stat — NDB Index Statistics Utility”
- Section 25.5.5, “ndb_mgm — The NDB Cluster Management Client”
- Section 25.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
- Section 25.5.15, “ndb_move_data — NDB Data Copy Utility”
- Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
- Section 25.5.25, “ndb_select_all — Print Rows from an NDB Table”
- Section 25.5.26, “ndb_select_count — Print Row Counts for NDB Tables”
- Section 25.5.27, “ndb_show_tables — Display List of NDB Tables”
- Section 25.5.28, “ndb_sign_keys — Create, Sign, and Manage TLS Keys and Certificates for NDB Cluster”
- Section 25.5.31, “ndb_waiter — Wait for NDB Cluster to Reach a Given Status”
- Section 25.5.1, “ndbd — The NDB Cluster Data Node Daemon”
- Section 25.5.2, “ndbinfo_select_all — Select From ndbinfo Tables”
- Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
- Section 25.4.1, “Quick Test Setup of NDB Cluster”
- Section 25.3.6, “Safe Shutdown and Restart of NDB Cluster”
- Section 25.6.4, “Summary of NDB Cluster Start Phases”
- Section 25.6.15.3, “Using TLS Connections”
ndb_mgmd.exe
ndb_move_data
ndb_perror
ndb_print_backup
ndb_print_backup_file
- Section 25.5.17, “ndb_print_backup_file — Print NDB Backup File Contents”
- Section 25.5.19, “ndb_print_frag_file — Print NDB Fragment List File Contents”
- Section 25.5.20, “ndb_print_schema_file — Print NDB Schema File Contents”
- Section 25.5.21, “ndb_print_sys_file — Print NDB System File Contents”
- Section 25.5.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
- Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”
ndb_print_frag_file
ndb_print_schema_file
- Section 25.5.17, “ndb_print_backup_file — Print NDB Backup File Contents”
- Section 25.5.18, “ndb_print_file — Print NDB Disk Data File Contents”
- Section 25.5.19, “ndb_print_frag_file — Print NDB Fragment List File Contents”
- Section 25.5.20, “ndb_print_schema_file — Print NDB Schema File Contents”
- Section 25.5.21, “ndb_print_sys_file — Print NDB System File Contents”
- Section 25.5.22, “ndb_redo_log_reader — Check and Print Content of Cluster Redo Log”
ndb_print_sys_file
- Section 25.5.17, “ndb_print_backup_file — Print NDB Backup File Contents”
- Section 25.5.18, “ndb_print_file — Print NDB Disk Data File Contents”
- Section 25.5.19, “ndb_print_frag_file — Print NDB Fragment List File Contents”
- Section 25.5.20, “ndb_print_schema_file — Print NDB Schema File Contents”
- Section 25.5.21, “ndb_print_sys_file — Print NDB System File Contents”
ndb_redo_log_reader
ndb_restore
- Section 9.1, “Backup and Recovery Types”
- Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
- Section 25.6.9, “Importing Data Into MySQL Cluster”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”
- Section 25.2.1, “NDB Cluster Core Concepts”
- Section 25.2, “NDB Cluster Overview”
- Section 25.5, “NDB Cluster Programs”
- Section 25.7.4, “NDB Cluster Replication Schema and Tables”
- Section 25.7.10, “NDB Cluster Replication: Bidirectional and Circular Replication”
- Section 25.6.6, “NDB Cluster Single User Mode”
- Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
- Section 25.5.32, “ndbxfrm — Compress, Decompress, Encrypt, and Decrypt Files Created by NDB Cluster”
- Section 25.6.8, “Online Backup of NDB Cluster”
- Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
- Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
- Section 25.6.8.5, “Taking an NDB Backup with Parallel Data Nodes”
- Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”
ndb_secretsfile_reader
ndb_select_all
ndb_show_tables
- Section 25.6.21.3, “NDB Cluster and MySQL Security Procedures”
- Section 25.5, “NDB Cluster Programs”
- Section 25.5.27, “ndb_show_tables — Display List of NDB Tables”
- Section 25.6.17.7, “The ndbinfo cluster_locks Table”
- Section 25.6.17.8, “The ndbinfo cluster_operations Table”
- Section 25.6.17.42, “The ndbinfo locks_per_fragment Table”
- Section 25.6.17.49, “The ndbinfo operations_per_fragment Table”
- Section 25.6.17.54, “The ndbinfo server_locks Table”
- Section 25.6.17.55, “The ndbinfo server_operations Table”
ndb_sign_keys
ndb_size.pl
ndbd
- Section 25.6.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
- Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 25.3.1.4, “Building NDB Cluster from Source on Linux”
- Section 25.6.1, “Commands in the NDB Cluster Management Client”
- Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
- Section 25.3.4, “Initial Startup of NDB Cluster”
- Section 25.3.1, “Installation of NDB Cluster on Linux”
- Section 25.3.1.1, “Installing an NDB Cluster Binary Release on Linux”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 25.3.2.1, “Installing NDB Cluster on Windows from a Binary Release”
- Section 25.3.1.3, “Installing NDB Cluster Using .deb Files”
- Section 25.6, “Management of NDB Cluster”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”
- Section 25.4.3.1, “NDB Cluster Configuration: Basic Example”
- Section 25.2.1, “NDB Cluster Core Concepts”
- Section 25.4.2.1, “NDB Cluster Data Node Configuration Parameters”
- Section 25.3, “NDB Cluster Installation”
- Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
- Section 25.5, “NDB Cluster Programs”
- Section 25.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
- Section 25.5.31, “ndb_waiter — Wait for NDB Cluster to Reach a Given Status”
- Section 25.5.1, “ndbd — The NDB Cluster Data Node Daemon”
- Section 25.5.3, “ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)”
- Section 25.4.2, “Overview of NDB Cluster Configuration Parameters, Options, and Variables”
- Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
- Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
- Section 25.4.1, “Quick Test Setup of NDB Cluster”
- Section 25.4.3.2, “Recommended Starting Configuration for NDB Cluster”
- Section 25.3.6, “Safe Shutdown and Restart of NDB Cluster”
- Section 25.6.4, “Summary of NDB Cluster Start Phases”
- Section 25.6.8.5, “Taking an NDB Backup with Parallel Data Nodes”
- Section 25.6.17.48, “The ndbinfo nodes Table”
- Section 25.6.3.3, “Using CLUSTERLOG STATISTICS in the NDB Cluster Management Client”
ndbd.exe
ndbinfo_select_all
ndbmtd
- Section 25.6.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure”
- Section 25.6.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
- Section 25.3.1.4, “Building NDB Cluster from Source on Linux”
- Section 25.4.3.6, “Defining NDB Cluster Data Nodes”
- Section 25.3.1, “Installation of NDB Cluster on Linux”
- Section 25.3.1.1, “Installing an NDB Cluster Binary Release on Linux”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 2.8.7, “MySQL Source-Configuration Options”
- Section 25.2.1, “NDB Cluster Core Concepts”
- Section 25.4.2.1, “NDB Cluster Data Node Configuration Parameters”
- Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”
- Section 25.5, “NDB Cluster Programs”
- Section 25.5.4, “ndb_mgmd — The NDB Cluster Management Server Daemon”
- Section 25.5.30, “ndb_top — View CPU usage information for NDB threads”
- Section 25.5.1, “ndbd — The NDB Cluster Data Node Daemon”
- Section 25.5.3, “ndbmtd — The NDB Cluster Data Node Daemon (Multi-Threaded)”
- Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”
- Section 25.7.9.2, “Point-In-Time Recovery Using NDB Cluster Replication”
- Section 25.4.3.2, “Recommended Starting Configuration for NDB Cluster”
- Section 25.3.6, “Safe Shutdown and Restart of NDB Cluster”
- Section 25.6.8.5, “Taking an NDB Backup with Parallel Data Nodes”
- Section 25.6.17.48, “The ndbinfo nodes Table”
- Section 25.6.17.52, “The ndbinfo resources Table”
ndbmtd.exe
ndbxfrm
NET
NET START
NET START mysqld_service_name
NET STOP
NET STOP mysqld_service_name
NET STOP service_name
openssl
- Section 8.4.5.5, “Configuring Audit Logging Characteristics”
- Section 8.3.1, “Configuring MySQL to Use Encrypted Connections”
- Section 8.3.3.3, “Creating RSA Keys Using openssl”
- Section 8.3.3, “Creating SSL and RSA Certificates and Keys”
- Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”
- Section 8.3.3.2, “Creating SSL Certificates and Keys Using openssl”
- Section 7.1.9.4, “Nonpersistible and Persist-Restricted System Variables”
- Section 8.4.4.6, “Using the keyring_okv KMIP Plugin”
- Section 25.6.15.3, “Using TLS Connections”
openssl md5 package_name
perror
- Section B.3.2.11, “Can't create/write to file”
- Section B.2, “Error Information Interfaces”
- Section B.3.2.16, “File Not Found and Similar Errors”
- Section 9.6.3, “How to Repair MyISAM Tables”
- Section A.10, “MySQL 9.1 FAQ: NDB Cluster”
- Section 25.5.16, “ndb_perror — Obtain NDB Error Message Information”
- Section 6.1, “Overview of MySQL Programs”
- Section 6.8.1, “perror — Display MySQL Error Message Information”
- Section 7.4.2.6, “Rule-Based Error Log Filtering (log_filter_dragnet)”
pkg-config
ps
- Section 8.2.14, “Assigning Account Passwords”
- Section 6.2.4, “Connecting to the MySQL Server Using Command Options”
- Section 8.1.2.1, “End-User Guidelines for Password Security”
- Section 6.9, “Environment Variables”
- Section 10.12.3.1, “How MySQL Uses Memory”
- Section B.3.1, “How to Determine What Is Causing a Problem”
- Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”
- Section 8.7, “SELinux”
- Section 29.12.2.3, “The setup_instruments Table”
- Section 29.12.22.9, “The threads Table”
- Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”
ps xa | grep mysqld
rename
restart
rpm
rpmbuild
rsync
SC DELETE mysqld_service_name
SC DELETE service_name
SC START
SC START mysqld_service_name
sc start mysqld_service_name
SC STOP
SC STOP mysqld_service_name
sc stop mysqld_service_name
SC STOP service_name
scp
service
- Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
- Section 2.5.2, “Installing MySQL on Linux Using the MySQL APT Repository”
- Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
- Section 2.5.9, “Managing MySQL Server with systemd”
- Section 2.5.3, “Using the MySQL SLES Repository”
Service Control Manager
Services
sestatus
sh
SHOW ERRORS
SHOW WARNINGS
ssh
ssl_session_data_print
start
Start>Run>cmd.exe
status
stop
sudo
sudo setcap
systemctl
- Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
- Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
- Section 2.5.2, “Installing MySQL on Linux Using the MySQL APT Repository”
- Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
- Section 2.5.9, “Managing MySQL Server with systemd”
- Section 2.5.3, “Using the MySQL SLES Repository”
tar
- Section 19.1.2.8, “Adding Replicas to a Replication Environment”
- Section 19.4.1.2, “Backing Up Raw Data from a Replica”
- Section 9.1, “Backup and Recovery Types”
- Section 19.1.2.5.2, “Creating a Data Snapshot Using Raw Data Files”
- Section 5.3, “Creating and Using a Database”
- Section 1.6, “How to Report Bugs or Problems”
- Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
- Section 2.4, “Installing MySQL on macOS”
- Section 2.7, “Installing MySQL on Solaris”
- Section 2.7.1, “Installing MySQL on Solaris Using a Solaris PKG”
- Section 2.2, “Installing MySQL on Unix/Linux Using Generic Binaries”
- Section 2.8.4, “Installing MySQL Using a Standard Source Distribution”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 2.10.1, “Installing Perl on Unix”
- Section 2.8.1, “Source Installation Methods”
- Section 2.8.2, “Source Installation Prerequisites”
- Section 10.12.2.1, “Using Symbolic Links for Databases on Unix”
- Section 8.4.4.6, “Using the keyring_okv KMIP Plugin”
- Section 2.1.2, “Which MySQL Version and Distribution to Install”
tcsh
Text in this style
top
ulimit
unix_chkpwd
useradd
util.checkForServerUpgrade()
vi
WinZip
yacc
yum
- Section 2.5.7, “Installing MySQL on Linux from the Native Software Repositories”
- Section 2.5.4, “Installing MySQL on Linux Using RPM Packages from Oracle”
- Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”
- Section 25.3.1.2, “Installing NDB Cluster from RPM”
- Section 3.8, “Upgrading MySQL with the MySQL Yum Repository”