Aikesheng Open Source Community
Apr 3, 2020 · Databases
MySQL Internal Temporary Tables: When They Switch to Disk Storage
Through a hands‑on experiment, this article demonstrates how MySQL’s internal temporary tables, governed by tmp_table_size and max_heap_table_size, transition from in‑memory heap storage to on‑disk storage, showing the resulting I/O behavior, disk usage statistics, and the impact of engine configuration.
Database StorageDisk SpillPerformance Schema
0 likes · 5 min read