MySQL storage engine InnoDB and MyISAM comparison summary

InnoDB engine

The InnoDB is a transactional storage engine designed to provide high-performance services when processing large amounts of data, which, at run time, creates buffer pools in memory for buffering data and indexes.

InnoDB Engine Benefits

1. Support transaction processing, acid transaction characteristics;
2. The implementation of the SQL standard four isolation levels;
3. Support row-level lock and foreign KEY constraint;
4. You can use transaction logs for data recovery.

InnoDB Engine Disadvantages

1. An index of type Fulltext is not supported because it does not save the number of rows in the table, and the full table is scanned when count statistics are used.

InnoDB Engine Application Scenario

1. Operations that require transactions;
2. Row-level locks are required to update data;
3. Large data volume reading and writing;
4. Large-scale Internet applications.

MyISAM engine

MyISAM is the default engine for MySQL and is designed to be read quickly.

MyISAM Engine Benefits

1. High-performance reading;
2. Because it saves the number of rows in the table, the full table is not scanned when the count statistic is used;

MyISAM Engine Disadvantages

1. Database transactions are not supported;
2. Row-level locks and foreign keys are not supported;
3.INSERT and update operations need to lock the entire table;
4. Failure recovery is not supported;

MyISAM Engine Application Scenario

1. Operations that do not require transactions;
2. Insert, update less, read frequently;

3. Frequent statistical calculations.

MySQL storage engine InnoDB and MyISAM comparison summary