Tag

Filesort

0 views collected around this technical thread.

Aikesheng Open Source Community

Mar 12, 2025 · Databases

Understanding Common MySQL EXPLAIN EXTRA Hints: Using filesort, Using temporary, and Using join buffer

This article explains the most frequent MySQL EXPLAIN EXTRA hints—Using filesort, Using temporary, and Using join buffer—detailing when they appear, how to interpret them, and practical optimization strategies illustrated with concrete SQL examples and execution‑plan outputs.

EXPLAINFilesortMySQL

0 likes · 9 min read

Understanding Common MySQL EXPLAIN EXTRA Hints: Using filesort, Using temporary, and Using join buffer

Aikesheng Open Source Community

Apr 2, 2020 · Databases

Understanding MySQL Filesort: Algorithms, Memory Allocation, and Temporary File Impact

This article provides an in‑depth analysis of MySQL's filesort mechanism, explaining the original and modified algorithms, how sort and addon fields are calculated, memory allocation strategies, the role of temporary files, and practical tips to reduce excessive disk usage during sorting operations.

DatabaseFilesortMySQL

0 likes · 35 min read

Understanding MySQL Filesort: Algorithms, Memory Allocation, and Temporary File Impact