原文地址:https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb.html
- 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.