8.5 Optimizing for InnoDB TablesInnoDB表的优化

8.5.1 Optimizing Storage Layout for InnoDB Tables优化InnoDB表的存储布局
8.5.2 Optimizing InnoDB Transaction Management优化InnoDB事务管理
8.5.3 Optimizing InnoDB Read-Only Transactions优化InnoDB只读事务
8.5.4 Optimizing InnoDB Redo Logging优化InnoDB重做日志记录
8.5.5 Bulk Data Loading for InnoDB TablesInnoDB表的批量数据加载
8.5.6 Optimizing InnoDB Queries优化InnoDB查询
8.5.7 Optimizing InnoDB DDL Operations优化InnoDB DDL操作
8.5.8 Optimizing InnoDB Disk I/O优化InnoDB磁盘I/O
8.5.9 Optimizing InnoDB Configuration Variables优化InnoDB配置变量
8.5.10 Optimizing InnoDB for Systems with Many Tables针对多表系统优化InnoDB

InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. InnoDB是MySQL客户通常在可靠性和并发性非常重要的生产数据库中使用的存储引擎。InnoDB is the default storage engine in MySQL. InnoDB是MySQL中的默认存储引擎。This section explains how to optimize database operations for InnoDB tables.本节介绍如何优化InnoDB表的数据库操作。

8.5.1 Optimizing Storage Layout for InnoDB Tables优化InnoDB表的存储布局
8.5.2 Optimizing InnoDB Transaction Management优化InnoDB事务管理
8.5.3 Optimizing InnoDB Read-Only Transactions优化InnoDB只读事务
8.5.4 Optimizing InnoDB Redo Logging优化InnoDB重做日志记录
8.5.5 Bulk Data Loading for InnoDB TablesInnoDB表的批量数据加载
8.5.6 Optimizing InnoDB Queries
8.5.7 Optimizing InnoDB DDL Operations
8.5.8 Optimizing InnoDB Disk I/O
8.5.9 Optimizing InnoDB Configuration Variables
8.5.10 Optimizing InnoDB for Systems with Many Tables