What is the storage engine of MYSQL ?, Mysql storage engine

What is the storage engine of MYSQL ?, Mysql storage engine

Based on personal opinions:

MySQL storage engine (composition, security, lock)

Myisam: a fast engine for data operations. It supports full-text retrieval. The file is saved in the directory name of the database

There are three files in the table definition file (. frm), data files (. MYD), index file (. MYI), emphasizing performance, high query efficiency, and does not support transactions and Foreign keys.

Innodb: a powerful engine that supports transaction processing and does not support full-text retrieval. The file is saved in two

The first is to store the table structure file in the directory named "database directory", and its data is stored in a common file.

MyISAM supports table locks, while InnoDB supports row locks.