Section 2 · Set up Database Observability

Set up Database Observability for MySQL

Estimated time: 2 min

MySQL with Database Observability

Database Observability gives you deep visibility into MySQL query performance, whether your database is self-managed or running on a managed cloud service.

What it monitorsQuery performance, explain plans, wait events, query samples, table schemas
How it worksGrafana Alloy reads from MySQL Performance Schema (enabled by default in 8.0+)
What you seeTop queries by duration, explain plans with cost highlighting, wait events, query samples
Supported variantsSelf-managed MySQL 8.0+, Amazon RDS, Amazon Aurora, Google Cloud SQL, Azure Database

What you’ll get

  • Queries Overview dashboard showing RED metrics for every query
  • Explain plans revealing full table scans, missing indexes, and expensive joins
  • Wait events showing lock contention, I/O bottlenecks, and resource waits
  • Query samples with individual execution timing
  • Table schemas highlighting index coverage and constraints

Before you start

A few things to keep in mind:

  • MySQL 8.0 or later is required. MariaDB isn’t supported.
  • You’ll need a monitoring user with specific privileges.
  • There’s some initial setup before data starts flowing.

The path below walks you through each step.


Learning path

MySQL Database Observability

Set up Grafana Cloud Database Observability for MySQL to monitor query performance, explain plans, wait events, and query samples.

13 min
Intermediate
Docs & blog posts

Open in Grafana Cloud

Complete this learning path directly in your Grafana Cloud stack, or in the Grafana Play stack, with an interactive learning experience.

Path completed