Documentation Grafana documentation Data sources MySQL

MySQL data source

Grafana ships with built-in support for MySQL. You can query and visualize data from MySQL-compatible databases like MariaDB or Percona Server.

Use this data source to create dashboards, explore SQL data, and monitor MySQL-based workloads in real time.

Give it a try using Grafana Play

With Grafana Play, you can explore and see how it works, learning from practical examples to accelerate your development. This feature can be seen on MySQL Overview.

Try it

Supported databases

This data source supports the following MySQL-compatible databases:

• MySQL 5.7 and newer
• MariaDB 10.2 and newer
• Percona Server 5.7 and newer
• Amazon Aurora MySQL
• Azure Database for MySQL
• Google Cloud SQL for MySQL

Grafana recommends using the latest available version for your database for optimal compatibility.

Key capabilities

The MySQL data source supports:

• Time series queries: Visualize metrics over time using built-in time grouping macros.
• Table queries: Display query results in table format for any valid SQL query.
• Template variables: Create dynamic dashboards with variable-driven queries.
• Annotations: Overlay events from MySQL on your dashboard graphs.
• Alerting: Create alerts based on MySQL query results.
• Macros: Simplify queries with built-in macros for time filtering and grouping.

Get started

The following documentation helps you get started with the MySQL data source:

• Configure the MySQL data source
• MySQL query editor
• MySQL template variables
• MySQL annotations
• MySQL alerting
• Troubleshoot MySQL data source issues

Additional resources

After configuring the MySQL data source, you can also:

• Create a wide variety of visualizations.
• Configure and use templates and variables.
• Add transformations.
• Optimize performance with query caching.

Pre-configured dashboards

If you want to monitor your MySQL server’s performance metrics (connections, queries, replication, and more), Grafana provides pre-configured dashboards through the MySQL integration:

• MySQL Overview - Key performance metrics for your MySQL server.
• MySQL Logs - Log analysis for troubleshooting.

The MySQL integration uses the Prometheus MySQL Exporter to collect server metrics and includes 15 pre-configured alert rules.

To use these dashboards:

1. In Grafana Cloud, navigate to Connections > Add new connection.
2. Search for MySQL and select the MySQL integration.
3. Follow the setup instructions to install the MySQL Exporter.
4. Import the pre-configured dashboards from the integration page.

For more MySQL dashboards, browse the Grafana dashboard catalog.

Related data sources

• PostgreSQL - For PostgreSQL databases.
• Microsoft SQL Server - For Microsoft SQL Server and Azure SQL databases.