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.