原文地址:https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam.html
- 10.6.1 Optimizing MyISAM Queries
- 10.6.2 Bulk Data Loading for MyISAM Tables
- 10.6.3 Optimizing REPAIR TABLE Statements
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
.