8.6 Optimizing for MyISAM TablesMyISAM表的优化

8.6.1 Optimizing MyISAM Queries优化MyISAM查询
8.6.2 Bulk Data Loading for MyISAM TablesMyISAM表的批量数据加载
8.6.3 Optimizing REPAIR TABLE Statements优化REPAIR TABLE语句

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. MyISAM存储引擎在以读取为主的数据或低并发操作时表现最好,因为表锁限制了同时执行更新的能力。In MySQL, InnoDB is the default storage engine rather than MyISAM.在MySQL中,InnoDB是默认的存储引擎,而不是MyISAM

8.6.1 Optimizing MyISAM Queries
8.6.2 Bulk Data Loading for MyISAM Tables
8.6.3 Optimizing REPAIR TABLE Statements