MySQL: MyISAM

MyISAM supported features

https://www.safaribooksonline.com/library/view/high-performance-mysql/9781449332471/ch01.html#the_myisam_engine

nontransactional, non-crash-safe

doesn’t support transactions or row-level locks

support full-text indexing, compression, and spatial (GIS) functions

哪些工作适合 MyISAM 来做，相比于InnoDB效率更高？

If you need read-only data, or if your tables aren’t large and won’t be painful to repair,

Locking and concurrency

MyISAM locks entire tables, not rows. Readers obtain shared (read) locks on all tables they need to read. Writers obtain exclusive (write) locks. However, you can insert new rows into the tablewhile select queries are running against it (concurrent inserts).

As MySQL’s default storage engine in versions 5.1 and older, MyISAM