Statement/Syntax Index

A | B | C | D | E | F | G | H | I | K | L | O | P | R | S | T | U | W | X

A

[index top]

ALTER DATABASE ... UPGRADE DATA DIRECTORY NAME

Section 13.3.3, “Statements That Cause an Implicit Commit”

ALTER TABLE

Section 11.2.5, “2-Digit YEAR(2) Limitations and Migrating to 4-Digit YEAR”
Section 21.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”
Section 13.1.8.2, “ALTER TABLE and Generated Columns”
Section 13.1.8.3, “ALTER TABLE Examples”
Section 13.1.8.1, “ALTER TABLE Partition Operations”
Section 13.1.8, “ALTER TABLE Statement”
Section 14.6.1.6, “AUTO_INCREMENT Handling in InnoDB”
Section 16.1.6.4, “Binary Logging Options and Variables”
Section 13.7.2.2, “CHECK TABLE Statement”
Section 10.3.5, “Column Character Set and Collation”
Section 10.7, “Column Character Set Conversion”
Section 8.3.4, “Column Indexes”
Section 14.8.11, “Configuring Optimizer Statistics for InnoDB”
Section 14.8.11.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 14.8.12, “Configuring the Merge Threshold for Index Pages”
Section 14.7.2.3, “Consistent Nonlocking Reads”
Section 14.21.5.4, “Controlling Transactional Behavior of the InnoDB memcached Plugin”
Section 10.9.8, “Converting Between 3-Byte and 4-Byte Unicode Character Sets”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.14, “CREATE INDEX Statement”
Section 13.1.18, “CREATE TABLE Statement”
Section 3.3.2, “Creating a Table”
Section 14.9.1.2, “Creating Compressed Tables”
Section 14.6.1.1, “Creating InnoDB Tables”
Section 11.4.5, “Creating Spatial Columns”
Section 11.4.9, “Creating Spatial Indexes”
Section 14.6.1.2, “Creating Tables Externally”
Section 21.3.3.6, “Defining NDB Cluster Data Nodes”
Section 14.12.4, “Defragmenting a Table”
Section 13.1.25, “DROP INDEX Statement”
Section 14.10.1, “Enabling File Formats”
Section 14.8.11.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 22.3.3, “Exchanging Partitions and Subpartitions with Tables”
Section 8.8.2, “EXPLAIN Output Format”
Section 15.8.3, “FEDERATED Storage Engine Notes and Tips”
Section 14.6.3.2, “File-Per-Table Tablespaces”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 14.22.2, “Forcing InnoDB Recovery”
Section 1.8.3.2, “FOREIGN KEY Constraints”
Section 13.1.18.5, “FOREIGN KEY Constraints”
Section 12.9, “Full-Text Search Functions”
Section 14.6.3.3, “General Tablespaces”
Section 8.14.3, “General Thread States”
Section 13.7.1.4, “GRANT Statement”
Section 14.9.1.5, “How Compression Works for InnoDB Tables”
Section B.4.3.4, “How MySQL Handles a Full Disk”
Section 8.10.3.1, “How the Query Cache Operates”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 12.15, “Information Functions”
Section 21.2.5, “Initial Configuration of NDB Cluster”
Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 14.13, “InnoDB and Online DDL”
Section 14.14, “InnoDB Data-at-Rest Encryption”
Section 14.6.2.4, “InnoDB FULLTEXT Indexes”
Section 14.17, “InnoDB Integration with MySQL Performance Schema”
Section 14.9.2, “InnoDB Page Compression”
Section 14.11, “InnoDB Row Formats”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 14.9.1, “InnoDB Table Compression”
Section 21.1.7.8, “Issues Exclusive to NDB Cluster”
Section 13.7.6.4, “KILL Statement”
Section B.4.7, “Known Issues in MySQL”
Section 21.1.7.10, “Limitations Relating to Multiple NDB Cluster Nodes”
Section 21.1.7.2, “Limits and Differences of NDB Cluster from Standard MySQL Limits”
Section 8.4.6, “Limits on Table Size”
Section 21.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 22.3.4, “Maintenance of Partitions”
Section 22.3.2, “Management of HASH and KEY Partitions”
Section 22.3.1, “Management of RANGE and LIST Partitions”
Section 12.9.9, “MeCab Full-Text Parser Plugin”
Section 15.7.2, “MERGE Table Problems”
Section 14.17.1, “Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema”
Section 14.6.1.4, “Moving or Copying InnoDB Tables”
Section 15.2.1, “MyISAM Startup Options”
Section 15.2.3, “MyISAM Table Storage Formats”
Section 4.6.3.1, “myisamchk General Options”
Section A.10, “MySQL 5.7 FAQ: NDB Cluster”
Section 1.8.1, “MySQL Extensions to Standard SQL”
MySQL Glossary
Section 21.3.3.9.1, “MySQL Server Options for NDB Cluster”
Section 27.7.6.36, “mysql_info()”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.6, “mysqlpump — A Database Backup Program”
Section 21.3.3.1, “NDB Cluster Configuration: Basic Example”
Section 21.5.10.1, “NDB Cluster Disk Data Objects”
Section 21.2.7, “NDB Cluster Example with Tables and Data”
Section 21.6.4, “NDB Cluster Replication Schema and Tables”
Section 21.3.3.9.2, “NDB Cluster System Variables”
Section 21.4.10, “ndb_desc — Describe NDB Tables”
Section 21.4.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 12.9.8, “ngram Full-Text Parser”
Section 21.1.7.1, “Noncompliance with SQL Syntax in NDB Cluster”
Section 14.13.5, “Online DDL Failure Conditions”
Section 14.13.6, “Online DDL Limitations”
Section 14.13.1, “Online DDL Operations”
Section 14.13.2, “Online DDL Performance and Concurrency”
Section 21.5.11, “Online Operations with ALTER TABLE in NDB Cluster”
Section 13.7.2.4, “OPTIMIZE TABLE Statement”
Section 8.4.1, “Optimizing Data Size”
Section 11.1.7, “Out-of-Range and Overflow Handling”
Section 22.1, “Overview of Partitioning in MySQL”
Section 14.9.1.1, “Overview of Table Compression”
Section 22.3, “Partition Management”
Section 22.6.4, “Partitioning and Locking”
Section 22.6.1, “Partitioning Keys, Primary Keys, and Unique Keys”
Section 22.6.2, “Partitioning Limitations Relating to Storage Engines”
Section 25.12.5, “Performance Schema Stage Event Tables”
Section 6.2.2, “Privileges Provided by MySQL”
Section B.4.6.1, “Problems with ALTER TABLE”
Section 22.2.3.1, “RANGE COLUMNS partitioning”
Section 22.2.1, “RANGE Partitioning”
Section 2.11.12, “Rebuilding or Repairing Tables or Indexes”
Section 13.1.33, “RENAME TABLE Statement”
Section 16.4.1.1, “Replication and AUTO_INCREMENT”
Section 16.4.1.25, “Replication and Reserved Words”
Section 16.4.1.10.1, “Replication with More Columns on Source or Replica”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 23.9, “Restrictions on Views”
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.6, “Server Command Options”
Section B.3.1, “Server Error Message Reference”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 13.1.18.9, “Setting NDB_TABLE Options”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 15.1, “Setting the Storage Engine”
Section 13.7.5.15, “SHOW ENGINE Statement”
Section 13.7.5.22, “SHOW INDEX Statement”
Section 13.7.5.40, “SHOW WARNINGS Statement”
Section 13.1.18.6, “Silent Column Specification Changes”
Section 14.13.4, “Simplifying DDL Statements with Online DDL”
Section 14.9.1.7, “SQL Compression Syntax Warnings and Errors”
Section 13.3.3, “Statements That Cause an Implicit Commit”
Section 11.3.1, “String Data Type Syntax”
Section 10.3.4, “Table Character Set and Collation”
Section B.4.6.2, “TEMPORARY Table Problems”
Section 5.4.6, “The DDL Log”
Section 24.32.22, “The INFORMATION_SCHEMA INNODB_SYS_TABLES Table”
Section 24.16, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 24.24, “The INFORMATION_SCHEMA STATISTICS Table”
Section 15.3, “The MEMORY Storage Engine”
Section 15.2, “The MyISAM Storage Engine”
Section 5.4.5, “The Slow Query Log”
Section 14.22.3, “Troubleshooting InnoDB Data Dictionary Operations”
Section 21.1.7.6, “Unsupported or Missing Features in NDB Cluster”
Section 3.6.9, “Using AUTO_INCREMENT”
Section 16.3.3, “Using Replication with Different Source and Replica Storage Engines”
Section 8.12.3.2, “Using Symbolic Links for MyISAM Tables on Unix”
Section 14.10.2, “Verifying File Format Compatibility”
Section 1.4, “What Is New in MySQL 5.7”
Section 21.1.4.1, “What is New in NDB Cluster 7.5”
Section B.4.3.3, “What to Do If MySQL Keeps Crashing”

ALTER TABLE ... ADD FOREIGN KEY

Section 13.1.8, “ALTER TABLE Statement”

ALTER TABLE ... ALGORITHM=INPLACE ...

Section 21.1.4.1, “What is New in NDB Cluster 7.5”

ALTER TABLE ... COMPRESSION=None

Section 14.9.2, “InnoDB Page Compression”

ALTER TABLE ... DISABLE KEYS

Section 13.2.6, “LOAD DATA Statement”

ALTER TABLE ... DISCARD PARTITION ... TABLESPACE

Section 14.6.1.3, “Importing InnoDB Tables”

ALTER TABLE ... DROP FOREIGN KEY

Section 13.1.8, “ALTER TABLE Statement”

ALTER TABLE ... ENABLE KEYS

Section 13.2.6, “LOAD DATA Statement”

ALTER TABLE ... ENGINE permitted_engine

Section 5.1.7, “Server System Variables”

ALTER TABLE ... IMPORT PARTITION ... TABLESPACE

Section 14.6.1.3, “Importing InnoDB Tables”

ALTER TABLE ... TRUNCATE PARTITION ALL

Section 22.3.4, “Maintenance of Partitions”

ALTER TABLE mysql.ndb_apply_status ENGINE=MyISAM

Section 21.6.3, “Known Issues in NDB Cluster Replication”

ALTER TABLE t TRUNCATE PARTITION ()

Section 13.2.2, “DELETE Statement”

ALTER TABLE t3 DROP PARTITION p2

Section 5.4.6, “The DDL Log”

ALTER TABLE table_name ENGINE=InnoDB;

Section 14.1.4, “Testing and Benchmarking with InnoDB”

ALTER TABLE table_name UPGRADE PARTITIONING

Section 2.11.3, “Changes in MySQL 5.7”

ALTER TABLESPACE ... ADD DATAFILE

Section 13.1.19, “CREATE TABLESPACE Statement”

ALTER TABLESPACE ... DROP DATAFILE

Section 13.1.30, “DROP TABLESPACE Statement”

ALTER TABLESPACE ... DROP DATATFILE

Section 13.1.19, “CREATE TABLESPACE Statement”

ALTER TABLESPACE ... ENGINE

Section 5.1.7, “Server System Variables”

ALTER TABLESPACE tablespace_name ENCRYPTION = 'Y'

Section A.17, “MySQL 5.7 FAQ: InnoDB Data-at-Rest Encryption”

ALTER USER

Section 6.2.5, “Access Control, Stage 1: Connection Verification”
Section 6.2.15, “Account Locking”
Section 13.7.1.1, “ALTER USER Statement”
Section 6.2.10, “Assigning Account Passwords”
Section 16.1.6.4, “Binary Logging Options and Variables”
Section 4.2.3, “Command Options for Connecting to the Server”
Section 6.3.1, “Configuring MySQL to Use Encrypted Connections”
Section 6.1.2.1, “End-User Guidelines for Password Security”
Section 13.7.1.4, “GRANT Statement”
Section 6.2.3, “Grant Tables”
Section 2.10.1, “Initializing the Data Directory”
Section 6.1.3, “Making MySQL Secure Against Attackers”
Section 6.4.1.3, “Migrating Away from Pre-4.1 Password Hashing and the mysql_old_password Plugin”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 6.2.11, “Password Management”
Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.2.2, “Privileges Provided by MySQL”
Section 6.2.14, “Proxy Users”
Section B.4.3.2.3, “Resetting the Root Password: Generic Instructions”
Section B.4.3.2.2, “Resetting the Root Password: Unix and Unix-Like Systems”
Section B.4.3.2.1, “Resetting the Root Password: Windows Systems”
Section 6.2.12, “Server Handling of Expired Passwords”
Section 5.1.7, “Server System Variables”
Section 13.7.1.7, “SET PASSWORD Statement”
Section 6.2.16, “Setting Account Resource Limits”
Section 6.4.1.11, “Socket Peer-Credential Pluggable Authentication”
Section 13.3.3, “Statements That Cause an Implicit Commit”
Section 6.4.3, “The Password Validation Plugin”
Section 28.2.1, “Types of Plugins”
Section 1.4, “What Is New in MySQL 5.7”

ANALYZE TABLE

Section 13.1.8, “ALTER TABLE Statement”
Section 13.7.2.1, “ANALYZE TABLE Statement”
Section 14.8.11.1.1, “Configuring Automatic Statistics Calculation for Persistent Optimizer Statistics”
Section 14.8.11.2, “Configuring Non-Persistent Optimizer Statistics Parameters”
Section 14.8.11, “Configuring Optimizer Statistics for InnoDB”
Section 14.8.11.1.2, “Configuring Optimizer Statistics Parameters for Individual Tables”
Section 14.8.11.1.3, “Configuring the Number of Sampled Pages for InnoDB Optimizer Statistics”
Section 13.1.14, “CREATE INDEX Statement”
Section 13.1.18, “CREATE TABLE Statement”
Section 14.8.11.3, “Estimating ANALYZE TABLE Complexity for InnoDB Tables”
Section 8.8.2, “EXPLAIN Output Format”
Section 13.8.2, “EXPLAIN Statement”
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 8.14.3, “General Thread States”
Section 16.1.6.5, “Global Transaction ID System Variables”
Section 14.8.11.1.4, “Including Delete-marked Records in Persistent Statistics Calculations”
Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”
Section 14.8.11.1.5, “InnoDB Persistent Statistics Tables”
Section 14.8.11.1.6, “InnoDB Persistent Statistics Tables Example”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 22.3.4, “Maintenance of Partitions”
Section 15.7.2, “MERGE Table Problems”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.6.3.1, “myisamchk General Options”
Section 1.8.1, “MySQL Extensions to Standard SQL”
MySQL Glossary
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 21.4.15, “ndb_index_stat — NDB Index Statistics Utility”
Section 8.6.1, “Optimizing MyISAM Queries”
Section 8.8.1, “Optimizing Queries with EXPLAIN”
Section 8.2.1, “Optimizing SELECT Statements”
Section 6.2.2, “Privileges Provided by MySQL”
Section 8.2.1.2, “Range Optimization”
Section 16.4.1.14, “Replication and FLUSH”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 5.1.7, “Server System Variables”
Section 13.7.5.22, “SHOW INDEX Statement”
Section 13.3.3, “Statements That Cause an Implicit Commit”
Section 24.32.24, “The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View”
Section 24.24, “The INFORMATION_SCHEMA STATISTICS Table”
Section 5.4.5, “The Slow Query Log”

B

[index top]

C

[index top]

CHANGE MASTER TO

Section 16.1.5.4, “Adding a Binary Log Based Source to a Multi-Source Replica”
Section 16.1.5.3, “Adding GTID-Based Sources to a Multi-Source Replica”
Section 6.2.10, “Assigning Account Passwords”
Section 16.3.1.2, “Backing Up Raw Data from a Replica”
Section 16.1.1, “Binary Log File Position Based Replication Configuration Overview”
Section 13.4.2.1, “CHANGE MASTER TO Statement”
Section 2.11.3, “Changes in MySQL 5.7”
Section 16.1.7.1, “Checking Replication Status”
Section 16.2.3.1, “Commands for Operations on a Single Channel”
Section 16.2.3.2, “Compatibility with Previous Replication Statements”
Section 16.1.2.4.1, “Creating a Data Snapshot Using mysqldump”
Section 16.3.10, “Delayed Replication”
Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”
Section 17.8, “Frequently Asked Questions”
Section 16.1.6.5, “Global Transaction ID System Variables”
Section 13.7.1.4, “GRANT Statement”
Section 16.1.3.3, “GTID Auto-Positioning”
Section 21.6.8, “Implementing Failover with NDB Cluster Replication”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 21.6.9, “NDB Cluster Backups With NDB Cluster Replication”
Section 21.6.10, “NDB Cluster Replication: Bidrectional and Circular Replication”
Section 25.12.11, “Performance Schema Replication Tables”
Section 21.6.5, “Preparing the NDB Cluster for Replication”
Section 6.2.2, “Privileges Provided by MySQL”
Section 16.1.6.3, “Replica Server Options and Variables”
Section 16.1.6, “Replication and Binary Logging Options and Variables”
Section 16.4.1.26, “Replication and Source or Replica Shutdowns”
Section 16.4.1.32, “Replication and Transaction Inconsistencies”
Section 16.2.4.2, “Replication Applier Metadata Repositories”
Section 8.14.8, “Replication Replica Connection Thread States”
Section 8.14.6, “Replication Replica I/O Thread States”
Section 8.14.7, “Replication Replica SQL Thread States”
Section 13.4.2.4, “RESET SLAVE Statement”
Section 16.1.3.6, “Restrictions on Replication with GTIDs”
Section 5.1.9, “Server Status Variables”
Section 16.1.2.5.2, “Setting the Source Configuration on the Replica”
Section 16.1.2.5.3, “Setting Up Replication between a New Source and Replicas”
Section 16.3.8, “Setting Up Replication to Use Encrypted Connections”
Section 16.1.3.4, “Setting Up Replication Using GTIDs”
Section 16.1.2.5.4, “Setting Up Replication with Existing Data”
Section 13.7.5.34, “SHOW SLAVE STATUS Statement”
Section 16.1.7.3.2.2, “Skipping Transactions With CHANGE MASTER TO
Section 16.1.7.3.2, “Skipping Transactions Without GTIDs”
Section 13.4.2.5, “START SLAVE Statement”
Section 13.3.3, “Statements That Cause an Implicit Commit”
Section 16.3.7, “Switching Sources During Failover”
Section 14.21.6, “The InnoDB memcached Plugin and Replication”
Section 25.12.11.3, “The replication_applier_configuration Table”
Section 25.12.11.1, “The replication_connection_configuration Table”
Section 16.2.1.2, “Usage of Row-Based Logging and Replication”
Section 17.2.1.3, “User Credentials”
Section 16.1.3.5, “Using GTIDs for Failover and Scaleout”
Section 1.4, “What Is New in MySQL 5.7”

CHANGE REPLICATION FILTER REPLICATE_DO_DB

Section 16.1.6.3, “Replica Server Options and Variables”

CHANGE REPLICATION FILTER REPLICATE_DO_TABLE

Section 16.1.6.3, “Replica Server Options and Variables”

CHANGE REPLICATION FILTER REPLICATE_IGNORE_DB

Section 16.1.6.3, “Replica Server Options and Variables”

CHANGE REPLICATION FILTER REPLICATE_IGNORE_TABLE

Section 16.1.6.3, “Replica Server Options and Variables”

CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB

Section 16.1.6.3, “Replica Server Options and Variables”

CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE

Section 16.1.6.3, “Replica Server Options and Variables”

CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE

Section 16.1.6.3, “Replica Server Options and Variables”

CHECK TABLE

Section 11.2.5, “2-Digit YEAR(2) Limitations and Migrating to 4-Digit YEAR”
Section 13.1.8.1, “ALTER TABLE Partition Operations”
Section 2.11.3, “Changes in MySQL 5.7”
Section 13.7.2.2, “CHECK TABLE Statement”
Section 15.2.4.1, “Corrupted MyISAM Tables”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.21, “CREATE VIEW Statement”
Section 8.11.5, “External Locking”
Section 16.1.6.5, “Global Transaction ID System Variables”
Section 7.6.3, “How to Repair MyISAM Tables”
Section 1.7, “How to Report Bugs or Problems”
Section 4.6.1, “innochecksum — Offline InnoDB File Checksum Utility”
Section 14.19.2, “InnoDB Recovery”
Section 14.22, “InnoDB Troubleshooting”
Section 22.3.4, “Maintenance of Partitions”
Section 7.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”
Section A.6, “MySQL 5.7 FAQ: Views”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section B.4.2.8, “MySQL server has gone away”
Section 27.7.6.75, “mysql_store_result()”
Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”
Section 27.7.6.77, “mysql_use_result()”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 15.2.4.2, “Problems from Tables Not Being Closed Properly”
Section 2.11.12, “Rebuilding or Repairing Tables or Indexes”
Section 15.4.1, “Repairing and Checking CSV Tables”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 13.6.6.5, “Restrictions on Server-Side Cursors”
Section 23.8, “Restrictions on Stored Programs”
Section 23.9, “Restrictions on Views”
Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”
Section 5.1.7, “Server System Variables”
Section 7.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.3.3, “Statements That Cause an Implicit Commit”
Section 15.5, “The ARCHIVE Storage Engine”
Section 15.7, “The MERGE Storage Engine”
Section 5.4.5, “The Slow Query Log”

COMMIT

Section 14.7.2.2, “autocommit, Commit, and Rollback”
Section 8.5.5, “Bulk Data Loading for InnoDB Tables”
Section 14.6.1.5, “Converting Tables from MyISAM to InnoDB”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 14.2, “InnoDB and the ACID Model”
Section 14.22.4, “InnoDB Error Handling”
Section 14.15, “InnoDB Startup Options and System Variables”
Section 14.7.3, “Locks Set by Different SQL Statements in InnoDB”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 21.3.3.9.2, “NDB Cluster System Variables”
Section 16.1.2.3, “Obtaining the Replication Source's Binary Log Coordinates”
Section 8.5.3, “Optimizing InnoDB Read-Only Transactions”
Section 25.12.7, “Performance Schema Transaction Tables”
Section 16.1.6.3, “Replica Server Options and Variables”
Section 16.4.1.33, “Replication and Transactions”
Section 5.5.4.3.2, “Rewriter Query Rewrite Plugin Procedures and Functions”
Section 13.3.4, “SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements”
Section 5.1.9, “Server Status Variables”
Section 5.1.7, “Server System Variables”
Section 5.1.15, “Server Tracking of Client Session State Changes”
Section 13.7.5.36, “SHOW TABLE STATUS Statement”
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”
Section 13.3.3, “Statements That Cause an Implicit Commit”
Section 23.7, “Stored Program Binary Logging”
Section 5.4.4, “The Binary Log”
Section 25.12.7.1, “The events_transactions_current Table”
Section 24.25, “The INFORMATION_SCHEMA TABLES Table”
Section 13.3, “Transactional and Locking Statements”
Section 23.3.1, “Trigger Syntax and Examples”