My Oracle Support Banner

How TempTable Storage Engine Manages RAM and Disk Space; Explanation of temptable_max_ram Option (Doc ID 2413219.1)

Last updated on DECEMBER 06, 2023

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Goal

As of MySQL 8.0, the default internal temporary table storage engine is changed from HEAP to TempTable. TempTable is a newly added storage engine on MySQL 8.0, it is dedicated to use for internal temporary tables (it is not possible to manually create a table using TempTable storage engine). TempTable storage engine is efficient in terms of both computational resources and ram/disk space.

You will learn how TempTable storage engine allocates and manages RAM and disk space. Exact meanings of temptable_max_ram, temptable_use_mmap, and temptable_max_mmap options are also explained.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.