- 7.5.1. Optimizing Storage Layout for
InnoDBTables - 7.5.2. Optimizing
InnoDBTransaction Management - 7.5.3. Optimizing
InnoDBLogging - 7.5.4. Bulk Data Loading for
InnoDBTables - 7.5.5. Optimizing
InnoDBQueries - 7.5.6. Optimizing
InnoDBDDL Operations - 7.5.7. Optimizing
InnoDBDisk I/O - 7.5.8. Optimizing
InnoDBConfiguration Variables - 7.5.9. Optimizing
InnoDBfor Systems with Many Tables
InnoDB is the storage engine that
MySQL customers typically use in production databases where
reliability and concurrency are important. Because
InnoDB is the default storage engine in MySQL
5.5 and higher, you can expect to see InnoDB
tables more often than before. This section explains how to
optimize database operations for InnoDB tables.