MySql 中文参考指南
Chapter 10 Optimization
目录
Table of Contents
本章解释了如何优化 MySQL 性能并提供了实例。优化涉及配置、优化和测量性能，涉及到各个级别。根据你的职位角色（开发人员、DBA 或两者的组合），你可以在各个 SQL 语句、整个应用程序、单个数据库服务器，或多个网络数据库服务器上进行优化。有时，你可以在事先主动计划性能，而其他时候你可能在问题发生后对配置或代码问题进行故障排除。优化 CPU 和内存使用还可以提高可扩展性，从而允许数据库在不降低速度的情况下处理更多负载。
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.