MySQL's common storage engine

(1) InnoDB engine, InnoDB engine provides support for database acid transactions. It also provides row-level and foreign-key constraints. Its design goal is to deal with large data capacity of the database system.
(2) Myiasm engine (the original MySQL default engine), does not provide transaction support, and does not support row-level locks and foreign keys.
(3) Memory engine: All the data is in memory, the data processing speed is fast, but the security is not high.
Note: The same database can also use a variety of storage engine tables. If a table modification requires a relatively high transaction, you can choose InnoDB. This database can select MyISAM storage for tables with higher query requirements. If the database requires a temporary table for querying, you can select the memory storage engine.

MySQL's common storage engine