You’ll then configure Prometheus to scrape MySQL metrics and optionally ship them to Grafana Cloud. In this guide you’ll learn how to set up and configure the MySQL Server Exporter to collect MySQL metrics like queries per second (QPS) and InnoDB buffer pool size, and expose them as Prometheus-style metrics. To learn how to get MySQL metrics using the MySQL Integration, please see MySQL Integration from the Grafana Cloud docs. 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. To learn how to do this, please see Reducing Prometheus metrics usage with relabeling from the Grafana Cloud docs. To learn more about configuring MySQL Exporter and toggling its collectors, please see the MySQL Exporter GitHub repository.īeyond 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. Note that depending on its configuration, MySQL Exporter may collect and publish far more metrics than this default set. To see a list of metrics shipped by default with this exporter, please download a sample metrics scrape here. This exporter publishes roughly 1000 Prometheus time series by default. Set up Prometheus alerting rules to alert on your metrics data. Imported Grafana dashboards to visualize your metrics data. Set up a preconfigured and curated set of recording rules to cache frequent queries. ![]() MySQL Exporter will expose these as Prometheus-style metrics.Ĭonfigured Prometheus to scrape MySQL Exporter metrics and optionally ship them to Grafana Cloud. Set up and configured MySQL Exporter to collect MySQL metrics like queries per second (QPS) and InnoDB buffer pool size. ![]() After running through the steps in this quickstart, you will have: The following quickstart provides setup instructions and preconfigured dashboards, alerting rules, and recording rules for the MySQL Exporter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |