Understanding MySQL EXPLAIN EXTRA Hints: Impossible, No Matching, Recursive, Rematerialize, and Canned N Databases

This article explains the meaning and optimization strategies for various MySQL EXPLAIN EXTRA hints—including Impossible WHERE/HAVING, No matching rows, Recursive queries, Rematerialize, and canned N databases—provides example execution plans, code snippets, and performance comparisons to help developers write more efficient SQL statements.

Derived TablesRecursive CTEexplain

0 likes · 10 min read

Understanding MySQL EXPLAIN EXTRA Hints: Impossible, No Matching, Recursive, Rematerialize, and Canned N Databases

Aikesheng Open Source Community

Nov 15, 2022 · Databases

Resolving MySQL InnoDB Lock Wait Timeout for Batch Inserts

This article analyzes a MySQL InnoDB lock wait timeout caused by batch INSERT operations, examines configuration parameters and slow‑query diagnostics, and presents a rewritten SQL solution that reduces execution time from over 100 seconds to under one second.

Derived TablesInnoDBlock_wait_timeout

0 likes · 7 min read

Resolving MySQL InnoDB Lock Wait Timeout for Batch Inserts

Ops Development Stories

Nov 12, 2021 · Databases

Unlock MySQL Performance: Mastering EXPLAIN Execution Plans

This article explains what an execution plan is, how to use the EXPLAIN keyword in MySQL 5.7, interprets each column of the EXPLAIN output—including id, select_type, table, type, possible_keys, key, key_len, rows, and Extra—provides detailed examples of different query scenarios, and shows how optimizer settings like derived_merge affect the plan.

Derived Tablesexecution planexplain

0 likes · 20 min read

Unlock MySQL Performance: Mastering EXPLAIN Execution Plans

Alibaba Cloud Developer

Sep 17, 2021 · Databases

How MySQL 8.0 Optimizer Transforms Complex Subqueries and Joins

This article explains MySQL 8.0’s optimizer architecture and walks through the detailed transformation steps for subqueries, scalar‑to‑derived conversions, flattening, join simplification, partition pruning, and condition push‑down, illustrating each phase with code examples and execution‑plan screenshots.

Derived TablesJOINSubquery

0 likes · 25 min read

How MySQL 8.0 Optimizer Transforms Complex Subqueries and Joins

dbaplus Community

Nov 12, 2015 · Databases

Mastering MySQL View Optimization: Techniques, Limits, and Best Practices

This article explains how MySQL versions up to 5.5 process and optimize views, outlines the exact conditions required for view merge rewriting, compares derived table handling with the SQL standard, and provides concrete test cases to illustrate performance pitfalls.

Database PerformanceDerived TablesSQL

0 likes · 6 min read

Mastering MySQL View Optimization: Techniques, Limits, and Best Practices

Understanding MySQL EXPLAIN EXTRA Hints: Impossible, No Matching, Recursive, Rematerialize, and Canned N Databases

Resolving MySQL InnoDB Lock Wait Timeout for Batch Inserts

Unlock MySQL Performance: Mastering EXPLAIN Execution Plans

How MySQL 8.0 Optimizer Transforms Complex Subqueries and Joins

Mastering MySQL View Optimization: Techniques, Limits, and Best Practices

How MySQL 8.0 Optimizer Transforms Complex Subqueries and Joins