MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Table of Contents [+/-]
- 8.1 Optimization Overview
- 8.2 Optimizing SQL Statements [+/-]
- 8.3 Optimization and Indexes [+/-]
- 8.4 Optimizing Database Structure [+/-]
- 8.5 Optimizing for InnoDB Tables [+/-]
- 8.6 Optimizing for MyISAM Tables [+/-]
- 8.7 Optimizing for MEMORY Tables
- 8.8 Understanding the Query Execution Plan [+/-]
- 8.9 Controlling the Query Optimizer [+/-]
- 8.10 Buffering and Caching [+/-]
- 8.11 Optimizing Locking Operations [+/-]
- 8.12 Optimizing the MySQL Server [+/-]
- 8.13 Measuring Performance (Benchmarking) [+/-]
- 8.14 Examining Thread 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.