Skip navigation links
MySQL 5.6 Reference Manual :: 8 Optimization :: 8.6 Optimizing for MyISAM Tables
8.6.1 Optimizing MyISAM Queries »
Section Navigation      [Toggle]

8.6. Optimizing for MyISAM Tables

[+/-]

8.6.1. Optimizing MyISAM Queries
8.6.2. Bulk Data Loading for MyISAM Tables
8.6.3. Speed of 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 5.6, InnoDB is the default storage engine rather than MyISAM.

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices