Advanced MySQL 8

The MEMORY storage engine

When we need to retrieve frequently-used data quickly, we can use the MEMORY storage engine. The MEMORY storage engine stores data via an in-memory table, so it is faster to retrieve information. As the data in this table is in-memory, however, it is only valid until a database service is restarted; on shutdown, data is lost. The MEMORY storage engine is often used when needing to retrieve static data that is hardly changed, such as the properties of an application or zip code data.

Some of the features of the MEMORY storage engine include:

• Storage is limited to RAM capacity
• B-tree indexes
• Backup (PTR)
• Replication support
• Query cache support
• Table-level locking for concurrency
• Hash indexes
• Encryption
• Updated statistics ...