10.6 Optimizing for MyISAM Tables
MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4
The MyISAM storage engine performs
best with read-mostly data or with low-concurrency operations,
because table locks limit the ability to perform simultaneous
updates. In MySQL, InnoDB is the
default storage engine rather than MyISAM.
