MEMORY Storage Engine
You are viewing an old version of this article. View
the current version here.
Contents of the MEMORY storage engine (previously known as HEAP) are stored in memory rather than on disk.
It is best-used for read-only caches of data from other tables, or for temporary work areas.
Since the data is stored in memory, it is highly vulnerable to power outages or hardware failure, and is unsuitable for permanent data storage.
BLOB or TEXT columns are not supported for MEMORY tables.
Index type
The MEMORY storage engine permits indexes to be either B-tree or Hash. See Storage Engine index types for more on their characteristics.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
