Brief introduction to mysql storage engine MyISAM and InnoDB_MySQL

The mysql storage engine MyISAM, InnoDB MyISAM, and InnoDB are the two most commonly used storage engines in MySQL, each having its own advantages and disadvantages. Next let's talk about them.

MyISAM

MyISAM is the default storage engine of MySQL and has full-text indexes. when the index data exceeds the resource allocation, the system allocates cache. The storage is simple and the efficiency is relatively higher than that of InnoDB. However, foreign keys and transactions are not supported.

InnoDB

InnoDB provides MySQL with transaction security tables with the capabilities of transactions, rollback, and crash recovery. InnoDB provides row locks that are consistent with those of the Oracle type. These improve the performance of multi-user concurrency. And provides foreign key constraints.