MySQL 8 Administrator???s Guide

The common database server layer

The MySQL pluggable storage engine is responsible for executing I/O operations on the actual data and also to cater to the specific application needs that includes enabling and enforcing the required features whenever required. Using a specific or single storage engine will more likely result in more efficiency and higher database performance because the engine enables the features only needed for a particular application, and resulting in less system overhead on the database.

A storage engine supports the following unique infrastructure components or keys:

• Concurrency: Some applications have granular lock levels (such as row-level locks) requirements more than others. Overall performance and overhead due ...