BestHub
Sign in
Tag

derived tables

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 21, 2025 · Databases

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.

EXPLAINMySQLOptimizer Switch
0 likes · 10 min read
Understanding MySQL EXPLAIN EXTRA Hints: Impossible, No Matching, Recursive, Rematerialize, and Canned N Databases
Aikesheng Open Source Community
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.

InnoDBMySQLPerformance Tuning
0 likes · 7 min read
Resolving MySQL InnoDB Lock Wait Timeout for Batch Inserts