What is a Heap table in MySQL?

In MySQL there are tables that are present in memory. These are called Heap tables. During table creation we specify TYPE as HEAP for HEAP tables.

Heap tables provide very fast access to data.

We can not store BLOB or TEXT datatype in a HEAP table. These tables also do not support AUTO_INCREMENT.

Once we restart the Database, data in HEAP tables is lost.

Leave a Reply

Your email address will not be published. Required fields are marked *