MySQL 8.4 Release Notes
Chapter 10 优化
Table of Contents
- 10.1 优化 Overview
- 10.2 Optimizing SQL 语句
- 10.3 优化 and Indexes
-
- 10.3.1 How MySQL Uses 索引
- 10.3.2 Primary Key 优化
- 10.3.3 SPATIAL Index 优化
- 10.3.4 Foreign Key 优化
- 10.3.5 Column 索引
- 10.3.6 Multiple-Column 索引
- 10.3.7 验证索引使用情况
- 10.3.8 InnoDB和MyISAM索引统计信息收集
- 10.3.9 Comparison of B-Tree and Hash 索引
- 10.3.10 索引扩展的使用
- 10.3.11 Optimizer Use of Generated Column 索引
- 10.3.12 Invisible 索引
- 10.3.13 Descending 索引
- 10.3.14 从TIMESTAMP列进行索引查找
- 10.4 优化数据库结构
- 10.5 Optimizing for InnoDB 表
- 10.6 MyISAM 表优化
- 10.7 MEMORY 表优化
- 10.8 理解查询执行计划
- 10.9 控制查询优化器
- 10.10 缓冲和缓存
- 10.11 优化锁定操作
- 10.12 优化 MySQL 服务器
- 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.