prometheus & grafana config for mysqld_exporter-0.15.0.windows-amd64

curl https://github.com/prometheus/mysqld_exporter/releases/download/v0.15.0/mysqld_exporter-0.15.0.windows-amd64.zip -o mysqld_exporter-0.15.0.win-amd64

upzip mysqld_exporter-0.15.0.windows-amd64.zip 

touch .my.cnf

cat .\.my.cnf
[client]
user=exporter
password=exporter

 

vim promethus.yml

- job_name: "mysqld_exporter"
　　static_configs:
- targets: ['localhost:9104']
　　labels:
　　app: mysqld_exporter
　　node: node1
　　role: mysqld_exporter

 

* [MySQL Overview - Dashboards - Grafana](http://127.0.0.1:3000/d/MQWgroiiz/mysql-overview?orgId=1&refresh=1m&var-interval=$__auto_interval_interval&var-host=localhost:9104)

*[GitHub - prometheus/mysqld\_exporter: Exporter for MySQL server metrics](https://github.com/prometheus/mysqld_exporter)

mysqld_exporter --config.my-cnf=.my.cnf --mysqld.address=localhost:6033

* [八、Prometheus监控实战之mysql\_exporter使用 - 老王教你学Linux - 博客园](https://www.cnblogs.com/wangyongqiang/p/15823372.html)

* [Install and Configure Prometheus MySQL Exporter - DevOpsSchool.com](https://www.devopsschool.com/blog/install-and-configure-prometheus-mysql-exporter/#:~:text=Install%20and%20Configure%20Prometheus%20MySQL%20Exporter%201%20Step,reload%20systemd%20and%20start%20mysql_exporter%20service%20...%20%E6%9B%B4%E5%A4%9A%E9%A1%B9%E7%9B%AE)