The difference between MySQL advanced storage engine MyISAM and InnoDB

One, Storage engine (table type)

In general, a database is a collection of data, and a computer database can be a collection of some files on a memory or a collection of some memory data. The MySQL database, SQL Server database, and so on, we usually say, are database management systems (databases Management system, or DBMS) that can store data and provide functions such as querying and updating.

The storage engine is how to index the stored data, how to update and query the data, and so on. Because the storage of data in a relational database is stored as a table, the storage engine is also known as a table type.

Ii. InnoDB and MyISAM

InnoDB and MyISAM are the most commonly used two table types, with the basic differences being mainly:

MyISAM storage Engine is characterized by: table-level lock, not support transaction and full-text index, suitable for some CMS content management system as a back-end database to use, but the use of large concurrency, heavy-duty production system, the structure of the table lock appears to be inadequate;

The InnoDB storage engine is characterized by row-level locking, transactional security (acid-compatible), foreign key support, and an index that does not support fulltext types (5.6.4 later versions support fulltext-type indexes). The InnoDB storage Engine provides a transactional secure storage engine with commit, rollback, and crash resiliency. The InnoDB is designed for maximum performance when handling large quantities. Its CPU efficiency could be unmatched by any other disk-based relational database engine.

The difference between MySQL advanced storage engine MyISAM and InnoDB