Chapter 10 Optimization
Table of Contents（官网）
- 10.1 Optimization Overview
- 10.2 Optimizing SQL Statements
- 10.3 Optimization and Indexes
- 10.4 Optimizing Database Structure
- 10.5 Optimizing for InnoDB Tables
- 10.6 Optimizing for MyISAM Tables
- 10.7 Optimizing for MEMORY Tables
- 10.8 Understanding the Query Execution Plan
- 10.9 Controlling the Query Optimizer
- 10.10 Buffering and Caching
- 10.11 Optimizing Locking Operations
- 10.12 Optimizing the MySQL Server
- 10.13 Measuring Performance (Benchmarking)
- 10.14 Examining Server Thread (Process) Information
This chapter explains how to optimize MySQL performance and provides examples. Optimization involves configuring, tuning, and measuring performance, at several levels. Depending on your job role (developer, DBA, or a combination of both), you might optimize at the level of individual SQL statements, entire applications, a single database server, or multiple networked database servers. Sometimes you can be proactive and plan in advance for performance, while other times you might troubleshoot a configuration or code issue after a problem occurs. Optimizing CPU and memory usage can also improve scalability, allowing the database to handle more load without slowing down.
本章解释了如何优化MySQL性能并提供了示例。优化涉及在多个级别上配置、调整和测量性能。根据您的工作角色（开发人员、DBA或两者的组合），您可能会在单个SQL语句、整个应用程序、单个数据库服务器或多个网络数据库服务器的级别进行优化。有时，您可以主动并提前计划性能，而其他时候，您可能会在问题发生后对配置或代码问题进行故障排除。优化CPU和内存使用还可以提高可扩展性，使数据库能够在不减慢速度的情况下处理更多负载。
