O OPTIMIZE PARTITION OPTIMIZE TABLE Section 13.6.2, “Statement Labels” [index top] Section 15.12.1, “Online DDL Operations” Section 23.5.7.2, “Adding NDB Cluster Data Nodes Online: Basic procedure” Section 23.5.7.3, “Adding NDB Cluster Data Nodes Online: Detailed Example” Section 5.9.1, “Debugging a MySQL Server” Section 13.2.2, “DELETE Statement” Section 16.2.3.2, “Dynamic Table Characteristics” Section 12.10.6, “Fine-Tuning MySQL Full-Text Search” Section 8.14.3, “General Thread States” Section B.3.3.4, “How MySQL Handles a Full Disk” Section 15.6.1.3, “Importing InnoDB Tables” Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables” Section 15.9.2, “InnoDB Page Compression” Section 15.10, “InnoDB Row Formats” Section 15.14, “InnoDB Startup Options and System Variables” Section 13.7.8.4, “KILL Statement” Section 23.1.7.2, “Limits and Differences of NDB Cluster from Standard MySQL Limits” Section 13.3.5, “LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements” Section 24.3.4, “Maintenance of Partitions” Section 16.7.2, “MERGE Table Problems” Section 7.6, “MyISAM Table Maintenance and Crash Recovery” Section 7.6.4, “MyISAM Table Optimization” Section 4.6.4.1, “myisamchk General Options” Section 1.7.1, “MySQL Extensions to Standard SQL” MySQL Server Options for NDB Cluster Section 4.5.3, “mysqlcheck — A Table Maintenance Program” Section 23.5.10.2, “NDB Cluster Disk Data Storage Requirements” Section 15.12.6, “Online DDL Limitations” Section 23.5.11, “Online Operations with ALTER TABLE in NDB Cluster” Section 13.7.3.4, “OPTIMIZE TABLE Statement” Section 8.6.1, “Optimizing MyISAM Queries” Section 8.2.5.2, “Optimizing UPDATE Statements” Section 8.2.7, “Other Optimization Tips” Section 6.2.2, “Privileges Provided by MySQL” Section 17.5.1.13, “Replication and FLUSH” Section 24.6, “Restrictions and Limitations on Partitioning” Section 5.1.7, “Server Command Options” Section 5.1.8, “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 16.2.3.1, “Static (Fixed-Length) Table Characteristics” Section 16.5, “The ARCHIVE Storage Engine” Section 26.4.14, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table” Section 26.4.15, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table” Section 26.4.17, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table” 5942