MySQL Server Exporter

MySQL Server Exporter

Overview Installation Recording rules Dashboards Alerting rules Grafana Cloud Integration

On this page:

You should load the following recording rules before loading the dashboards in this guide. The dashboard queries use recording rules to reduce load on the Prometheus or Grafana Cloud Metrics servers, depending on where you’re evaluating the rules.

This quickstart includes the following recording rules:

  • record: instance:mysql_slave_lag_seconds
    • PromQL: mysql_slave_status_seconds_behind_master - mysql_slave_status_sql_delay
  • instance:mysql_heartbeat_lag_seconds
    • PromQL: mysql_heartbeat_now_timestamp_seconds - mysql_heartbeat_stored_timestamp_seconds
  • job:mysql_transactions:rate5m
    • PromQL: sum without (command) (rate(mysql_global_status_commands_total{command=~"(commit|rollback)"}[5m]))
Download the following recording rules YAML file
groups:
- name: mysqld_rules
  rules:
  - expr: mysql_slave_status_seconds_behind_master - mysql_slave_status_sql_delay
    record: instance:mysql_slave_lag_seconds
  - expr: mysql_heartbeat_now_timestamp_seconds - mysql_heartbeat_stored_timestamp_seconds
    record: instance:mysql_heartbeat_lag_seconds
  - expr: sum without (command) (rate(mysql_global_status_commands_total{command=~"(commit|rollback)"}[5m]))
    record: job:mysql_transactions:rate5m

This recording rule YAML file was generated using the MySQL Exporter mixin.