Created to support open source DBAs and developers, Percona Monitoring and Management (PMM) allows deep insight into the performance of applications and databases.
Used by thousands of organizations around the globe to manage complex database environments, PMM enables you to embrace different platforms, while maintaining confidence in your ability to monitor the performance of your data. It can be used on-premises and in the cloud. and is compatible with major cloud providers such as Amazon Web Services (AWS), Google Cloud, and Microsoft Azure, with specific dashboards for AWS RDS and Amazon Aurora.
Key Benefits of Percona Monitoring and Management
Optimize database performance by utilizing and acting upon query and metric information. Easily find, fix, and prevent scaling issues, bottlenecks, and potential outages.
Achieve faster issue resolution by displaying current and potential query issues. Monitor complex environments with multi-databases, technologies, and providers.
Group like-systems together based on Cluster, Replication Set, Geographic Area, custom labels, and more. Manage and monitor all your servers at once, filtering down to the real issues.
Map queries against specific metrics to gain insight on database resources, such as platform, growth, team focus, and activity so high-quality releases won’t negatively impact your business.
Query Analytics and Metrics — A Vital Part of Any Deployment
Query Analytics (QAN) enables you to optimize database performance by making sure that MySQL, MongoDB, and PostgreSQL queries are executed as expected, within the shortest time possible. If your database is experiencing problems, you can identify which queries may be the cause and review detailed metrics, which will help direct the action you should take to resolve the issue.
Our Metrics Monitor tool provides a historical view of any metrics that are critical to a database server. Time-based graphs are separated into dashboards by themes, such as database services from MySQL, MongoDB, or PostgreSQL, or general system metrics such as CPU, Network, Memory, or Disk performance.
Features of Percona Monitoring and Management
New performance and usability query improvements allow visualization queries for fleets of servers, sort by any column, or from multiple dimensions.
New query analytics for PostgreSQL allows you to visualize query performance for PostgreSQL servers alongside MySQL and MongoDB.
New labeling with Leverage Standard (system-generated) and Custom tags to conveniently group servers for analysis.
New administrative API with sdd/change/remove nodes and services from monitoring using PMM Server API.
Review fleets of servers and drill down to Clusters, Replication Sets, and individual instances with new service-level dashboards.
Point-in-time visibility and historical trending of database performance.
Data from MySQL Performance Schema and MySQL slow query log.
Amazon RDS and Amazon Aurora dashboards for AWS-specific monitoring.
Data from the MongoDB query profiler.
Historical view of metrics, critical to a database server.
Query metrics, including bytes sent, lock time, rows sent, and more
Best-of-breed tools, including Grafana, Prometheus, and Percona Distribution for PostgreSQL.
DBTA Trend-Setting Product 2019
PMM is a leading, free and open-source platform with over 3,500 daily active server instances, and over 250,000 downloads.
Built-in Technology and Software Support
Percona Monitoring and Management monitors and provides actionable performance data for MySQL variants, including Percona Server for MySQL, Percona XtraDB Cluster, Oracle MySQL Community Edition, Oracle MySQL Enterprise Edition, and MariaDB.
PMM captures metrics and data for the InnoDB, XtraDB, and MyRocks storage engines, and has specialized dashboards for specific engine details.
- MySQL InnoDB Metrics
- MySQL MyISAM Metrics/Aria Metrics
- MySQL MyRocks Metrics
- MySQL Performance Schema/Perfomance Schema Waits Analysis
- MySQL Replication
- MySQL Table Statistics
- MySQL User Statistics
Percona Monitoring and Management monitors and provides actionable performance data for MongoDB variants, including Percona Server for MongoDB, MongoDB Community Server, and MongoDB Enterprise Server.
PMM includes specialized MongoDB dashboards for graphing WiredTiger, MMAPv1, InMemory, and RocksDB storage engines.
- MongoDB Cluster Summary
- MongoDB ReplSet
- MongoDB Overview
- MongoDB WiredTiger
- MongoDB InMemory/MMAPv1/RocksDB
Percona XtraDB Cluster
Percona XtraDB Cluster is an active/active high availability and high scalability open source solution for MySQL clustering. It integrates Percona Server for MySQL and Percona XtraBackup with the Codership Galera library of MySQL high availability solutions in a single package that enables you to create a cost-effective MySQL high availability cluster.
- Percona XtraDB Cluster / Galera Cluster Overview
- Percona XtraDB Cluster / Galera Graphs
Amazon RDS MySQL and Amazon Aurora MySQL
Percona Monitoring and Management is designed to work with Amazon RDS MySQL and Amazon Aurora MySQL. PMM has a specific dashboard for monitoring Amazon Aurora MySQL using Cloudwatch and direct sampling of MySQL metrics.
- MySQL Amazon Aurora Metrics
Percona Monitoring and Management is designed to work with ProxySQL. ProxySQL is a high-performance SQL proxy. ProxySQL runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash, to minimize downtime.
With PMM, you can gather metrics for ProxySQL and its interactions with the database and applications.
- ProxySQL Overview