10.5 Optimizing for InnoDB Tables

10.5.1 Optimizing Storage Layout for InnoDB Tables

10.5.2 Optimizing InnoDB Transaction Management

10.5.3 Optimizing InnoDB Read-Only Transactions

10.5.4 Optimizing InnoDB Redo Logging

10.5.5 Bulk Data Loading for InnoDB Tables

10.5.6 Optimizing InnoDB Queries

10.5.7 Optimizing InnoDB DDL Operations

10.5.8 Optimizing InnoDB Disk I/O

10.5.9 Optimizing InnoDB Configuration Variables

10.5.10 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. InnoDB is the default storage engine in MySQL. This section explains how to optimize database operations for InnoDB tables.