Section 8.8.2, “EXPLAIN Output Format” Section 13.8.2, “EXPLAIN Statement” Section 12.10.6, “Fine-Tuning MySQL Full-Text Search” Section 8.14.3, “General Thread States” Including Delete-marked Records in Persistent Statistics Calculations Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration” Section 8.3.8, “InnoDB and MyISAM Index Statistics Collection” InnoDB Persistent Statistics Tables InnoDB Persistent Statistics Tables Example Section 15.14, “InnoDB Startup Options and System Variables” Section 24.3.4, “Maintenance of Partitions” Section 16.7.2, “MERGE Table Problems” Section 7.6, “MyISAM Table Maintenance and Crash Recovery” Section 4.6.4.1, “myisamchk General Options” Section 1.7.1, “MySQL Extensions to Standard SQL” MySQL Glossary Section 4.5.3, “mysqlcheck — A Table Maintenance Program” Section 4.5.4, “mysqldump — A Database Backup Program” Section 4.5.6, “mysqlpump — A Database Backup Program” Section 23.4.14, “ndb_index_stat — NDB Index Statistics Utility” Section 8.9.6, “Optimizer Statistics” Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries” 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 17.5.1.13, “Replication and FLUSH” Section 24.6, “Restrictions and Limitations on Partitioning” Section 5.1.8, “Server System Variables” Section 13.7.7.22, “SHOW INDEX Statement” Section 13.3.3, “Statements That Cause an Implicit Commit” Section 26.4.28, “The INFORMATION_SCHEMA INNODB_TABLESTATS View” Section 26.3.34, “The INFORMATION_SCHEMA STATISTICS Table” Section 26.3.38, “The INFORMATION_SCHEMA TABLES Table” Section 5.3, “The mysql System Schema” Section 5.4.5, “The Slow Query Log” [index top] Section 15.7.2.2, “autocommit, Commit, and Rollback” Section 13.6.1, “BEGIN ... END Compound Statement” Section 23.6.11, “NDB Cluster Replication Conflict Resolution” Section 27.12.7, “Performance Schema Transaction Tables” Section 17.1.6.3, “Replica Server Options and Variables” Section 17.5.1.35, “Replication and Transactions” Section 25.8, “Restrictions on Stored Programs” Section 5.1.8, “Server System Variables” Section 13.3.3, “Statements That Cause an Implicit Commit” Section 25.7, “Stored Program Binary Logging” Section 27.12.7.1, “The events_transactions_current Table” 5896 B BEGIN