MySQL Server Exporter

MySQL Server Exporter

Overview Installation Recording rules Dashboards Alerting rules Grafana Cloud Integration

Introduction

The following quickstart provides setup instructions and preconfigured dashboards, alerting rules, and recording rules for the MySQL Exporter. After running through the steps in this quickstart, you will have:

  • Set up and configured MySQL Exporter to collect MySQL metrics like queries per second (QPS) and InnoDB buffer pool size. MySQL Exporter will expose these as Prometheus-style metrics.

  • Configured Prometheus to scrape MySQL Exporter metrics and optionally ship them to Grafana Cloud.

  • Set up a preconfigured and curated set of recording rules to cache frequent queries.

  • Imported Grafana dashboards to visualize your metrics data.

  • Set up Prometheus alerting rules to alert on your metrics data.

Metrics usage

This exporter publishes roughly 1000 Prometheus time series by default. To see a list of metrics shipped by default with this exporter, please download a sample metrics scrape here.

Note that depending on its configuration, MySQL Exporter may collect and publish far more metrics than this default set. To learn more about configuring MySQL Exporter and toggling its collectors, please see the MySQL Exporter GitHub repository.

Beyond toggling MySQL Exporter’s settings, you can reduce metrics usage by dropping time series you don’t need to store in Prometheus or Grafana Cloud. To learn how to do this, please see Reducing Prometheus metrics usage with relabeling from the Grafana Cloud docs.

Grafana Cloud’s Linux Node Integration

If you’re using Grafana Cloud, you can skip all of the steps in this guide by installing the MySQL Integration, which is designed to help you get up and running in a few commands and clicks. Sign up for free.

To learn how to get MySQL metrics using the MySQL Integration, please see MySQL Integration from the Grafana Cloud docs.