10.6 Optimizing for MyISAM Tables
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
.