PMM

Percona Monitoring and Management (PMM) is a free, open-source platform designed to monitor and manage database performance. It focuses on providing visibility into MySQL-compatible databases and related systems by collecting metrics, offering dashboards, and enabling query analytics to help identify bottlenecks and optimize workloads. PMM can be deployed on premises, in private data centers, or in cloud environments and is built around commonly used open-source tooling.

PMM uses a two-part architecture consisting of PMM Server and PMM Client. The PMM Server provides the web user interface and stores collected data, dashboards, and configuration. The PMM Client (or PMM agents) runs on monitored hosts and uses exporters to gather metrics from database servers and the underlying system. Administrators configure monitoring with the pmm-admin command-line tool, which registers hosts, enables exporters (such as mysqld_exporter, mongodb_exporter, and node_exporter), and links them to the PMM Server.

Key features include comprehensive metrics collection, Grafana dashboards, and Prometheus-backed data stores that support long-term analysis. A notable capability is Query Analytics (QAN), which surfaces slow and resource-intensive SQL statements to aid performance tuning. PMM also supports alerting through Grafana and can operate in containerized environments or traditional server setups.

Supported databases and environments typically include MySQL, MariaDB, PostgreSQL, and MongoDB, with compatibility for monitoring in Docker and Kubernetes clusters. PMM is maintained by Percona and remains a widely used tool for database performance management and capacity planning in both small-scale and enterprise deployments.