A brief description of the differences between MyISAM and InnoDB in MySQL database

The difference is mainly the following points:

(1) Composition, MyISAM table on disk has three files, respectively, table definition file (. frm), data file (. MYD), index file (. MYI), while the InnoDB table consists of a table definition file (. frm), tablespace data, and log files.

(2) Security, MyISAM emphasizes performance, its query query efficiency is high, but does not support the transaction and foreign keys and other security features, and InnoDB support transactions and foreign keys and other advanced features, query efficiency is slightly lower.

(3) Support for locks, MyISAM supports table locks, while InnoDB supports row locks.

A brief description of the differences between MyISAM and InnoDB in MySQL database