Extending Percona Monitoring and Management With Custom Collectors

on YouTube ↗53m

" summary

Extends Percona Monitoring and Management by showing exactly how custom YAML custom query collector files and Prometheus-format text file collector outputs are written, where they live, and how PMM adds labels so dashboards just work. Uses Grafana + VictoriaMetrics back end, warns heavy high‑resolution queries can kill a server, and demonstrates a working text-file script that measures Postgres WAL LSN bytes to compute write rate and justify changing max_wal_size. Also covers external exporters and practical troubleshooting steps.

AI-written summary · about

" chapters (10)

1. 0:00Intro
2. 1:15What is Percona Monitoring and Management (PMM)
3. 3:56Why is Monitoring Needed?
4. 8:35Extending PMM
5. 11:15Custom Query Collector
6. 22:12Replication Lag
7. 26:15Textfile Collector
8. 37:09Optimizing WAL size
9. 42:44External Exporters
10. 43:35Troubleshooting

" related talks

• 51mHow to improve PostgreSQL Monitoring and ...Charly Batista, Agustin Gallego · PGConf NYC 2021
• 21mEasy way of application monitoringCihan Tunali · Percona University Istanbul 2022
• 30mWhy we recommend PMM to our clientsMatthias Crauwels · OSMC 2018
• 22mGetting Started with Percona Monitoring and ManagementSergei Krupnik · Percona University Istanbul 2022
• 28mThe "411" on PMMSteve Hoffman, Brandon Fleisher · Percona Live Online 2020
• 11h 43mPercona Community Live Conference - Day 1 - Open Source Databases ConferenceBruce Momjian, Lenz Grimmer, Ravikumar Buragapu, Keao Yang, Anton Bystrov · Percona Community Live 2022
• 35mBest Practices for MySQL PerformanceRoman Novykov · Highload fwdays'17
• 51mCollectd and Graphite: Monitoring PostgreSQL w/StyleShaun Thomas · PostgresOpen 2014