Section 15.12, “InnoDB and Online DDL” Section 24.3.1, “Management of RANGE and LIST Partitions” Section 15.12.1, “Online DDL Operations” Section 15.12.2, “Online DDL Performance and Concurrency” Section 13.7.3.4, “OPTIMIZE TABLE Statement” Section 5.1.8, “Server System Variables” Section 15.12.4, “Simplifying DDL Statements with Online DDL” Section 1.3, “What Is New in MySQL 8.0” Section 5.1.12.1, “Connection Interfaces” Section B.3.2.16, “File Not Found and Similar Errors” Section 8.2.1.4, “Hash Join Optimization” Section 8.4.3.1, “How MySQL Opens and Closes Tables” Section 15.14, “InnoDB Startup Options and System Variables” Section 2.5.9, “Managing MySQL Server with systemd” Section 27.15, “Performance Schema System Variables” Section 24.6, “Restrictions and Limitations on Partitioning” Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations” Section 5.1.8, “Server System Variables” Section 1.3, “What Is New in MySQL 8.0” Section 8.9.1, “Controlling Query Plan Evaluation” Section 8.9.3, “Optimizer Hints” Section 8.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations” Section 5.1.8, “Server System Variables” Section 8.9.1, “Controlling Query Plan Evaluation” Section 5.1.8, “Server System Variables” Section 8.2.1.12, “Block Nested-Loop and Batched Key Access Joins” Section 8.2.1.13, “Condition Filtering” Section 13.2.11.7, “Correlated Subqueries” Section 8.2.2.5, “Derived Condition Pushdown Optimization” Section 8.2.1.5, “Engine Condition Pushdown Optimization” Section 8.2.1.4, “Hash Join Optimization” Section 8.2.1.6, “Index Condition Pushdown Optimization” Section 8.2.1.3, “Index Merge Optimization” Section 8.3.12, “Invisible Indexes” Section 8.2.1.19, “LIMIT Query Optimization” Section 8.2.1.11, “Multi-Range Read Optimization” Section 8.9.3, “Optimizer Hints” Section 8.9.6, “Optimizer Statistics” Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization” Section 8.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations” Section 8.2.2.2, “Optimizing Subqueries with Materialization” Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy” Section 8.2.1.2, “Range Optimization” Section 5.1.8, “Server System Variables” 6099 optimizer_switch optimizer_search_depth optimizer_prune_level open_files_limit