Local Mysql 5.7.29, check the supported storage engines

show engines;

InnoDB

InnoDB, Mysql’s default engine, stores tables centrally in a system table space that consists of multiple files and can contain multiple raw partitions.

Features: Transaction support, good concurrency

  1. Provide transactions and transaction security
  2. The system automatically recovers after a crash
  3. Support FULLTEXT search drink FULLTEXT index

MyISAM

MYISAM indexes are separate from data and its indexes are compressed, which gives better query performance than INNODB.

Features: Good query performance

  1. Compress keys when saving consecutive similar string index values.
  2. More functionality for the AUTO_INCREATMENT column
  3. Support for FULLTEXT retrieval and FULLTEXT indexing
  4. Supports SPATIAL data types and SPATIAL indexes

MEMORY

The table is stored in memory, and the length of the table is fixed. To some extent, MEMORY tables are temporary, and their contents disappear when the server loses power.

Features: Fast speed

  1. By default, MEMORY tables use hash indexes, which are very fast for want to wait comparisons, but very slow for range comparisons.
  2. Rows stored in MEMORY tables are in a fixed-length format that cannot use BLOB and TEXT data types.