Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 47.0Mb
PDF (A4) - 47.0Mb
PDF (RPM) - 42.4Mb
HTML Download (TGZ) - 10.8Mb
HTML Download (Zip) - 10.9Mb
HTML Download (RPM) - 9.4Mb
Man Pages (TGZ) - 226.9Kb
Man Pages (Zip) - 333.7Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  Optimization

Chapter 8 Optimization

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.