Managing Temporary Table Memory Allocation

How the engine handles internal temporary tables for GROUP BY/DISTINCT.

MySQL 8.0 uses the TempTable storage engine, which allocates memory more efficiently and can spill to disk using memory-mapped files.