- 7.5.1. Optimizing Storage Layout for
InnoDB
Tables - 7.5.2. Optimizing
InnoDB
Transaction Management - 7.5.3. Optimizing
InnoDB
Logging - 7.5.4. Bulk Data Loading for
InnoDB
Tables - 7.5.5. Optimizing
InnoDB
Queries - 7.5.6. Optimizing
InnoDB
DDL Operations - 7.5.7. Optimizing
InnoDB
Disk I/O - 7.5.8. Optimizing
InnoDB
Configuration Variables - 7.5.9. Optimizing
InnoDB
for 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.