Blog
MEMORY Storage Engine
MEMORY Storage Engine
In this tutorial, we will learn about the MEMORY storage engine in MySQL. MEMORY storage engine tables are temporary in the sense that their contents disappear when the server terminates. The tables still exists when the server restarts, but will be empty.
MEMORY Storage Engine
MEMORY storage engine uses tables that are stored in memory and that have fixed-length rows, two characteristics that make them very fast.
The MEMORY storage engine manages tables that have the following characteristics:
Each table is represented on disk by an .frm format file in the database directory. Table data and indexes area stored in memory
In-memory storage results i vary fast performance
Contents do not survive a restart of the server (structure survives, but table contains zero rows)
Limited by max_heap_table_size so they do not get too large
MySQL manages query contention using-level locking. Deadlock cannot occur.
Cannot contain TEXT or BLOB columns
The MEMORY storage engine was formerly called the HEAP engine. You might still see HEAP in older SQL code, and MySQL Server still recognizes HEAP for backward compatibility.
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: