Fundamentals of Performance Analysis and Tuning Using Statistical Data on MySQL Server, MySQL NDB Cluster, and HeatWave
(Doc ID 3042815.1)
Last updated on APRIL 06, 2025
Applies to:
HeatWave on AWS - Version N/A and later MySQL Server - Version 4.0 and later MySQL NDB Cluster - Version 4.1 and later HeatWave - Version N/A and later Information in this document applies to any platform.
Purpose
This document describes the overall lifecycle of performance tuning of MySQL Server including MySQL NDB Cluster, and HeatWave instances. This document covers:
How to collect performance statistical data from MySQL Server
How to analyze performance statistical data to identify bottlenecks
How to identify non-optimal queries which can cause bottlenecks
How to make queries more efficient
Further performance improvement scenarios such as scale-up, scale-out, and parameters tuning
You can figure out a big picture of performance tuning required for MySQL Server.
Scope
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
