Percona Monitoring and Management
An open source database monitoring, observability, and management tool
Monitor, manage, and improve the performance of your databases no matter where they are located or deployed.
Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management tool for use with MySQL, PostgreSQL, MongoDB, and the servers on which they run. It enables you to view node- to single-query performance metrics for all of your databases in a single place. With Query Analytics, you can quickly locate costly and slow-running queries to address bottlenecks. Additionally, Percona Advisors equip you with performance, security, and configuration recommendations that help you keep your databases performing at their best. Alerting and management features like backup, restore, and built-in open source Private DBaaS are designed to increase the velocity of your IT team.
Supported Technologies and Dashboards
- MySQL
- MongoDB
- PostgreSQL
- Amazon RDS and Amazon Aurora
- ProxySQL
- Percona XtraDB Cluster
Percona Monitoring and Management 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 MyRocks Metrics
- MySQL Performance Schema/Performance Schema Waits Analysis
- MySQL Replication
- MySQL Table Statistics
- MySQL User Statistics
Optimize and Troubleshoot MySQL using PMM
Peter Zaitsev talked about the Optimizing #MySQL performance and troubleshooting #MySQL problems are two of the most critical and challenging tasks for #MySQL #DBA's.
Percona Monitoring and Management provides actionable performance data for MongoDB variants, including Percona Server for MongoDB, MongoDB Community Server, and MongoDB Enterprise Server.
PMM includes these specialized MongoDB dashboards for graphing WiredTiger, MMAPv1, InMemory, and RocksDB storage engines:
- MongoDB Cluster Summary
- MongoDB ReplSet
- MongoDB Overview
- MongoDB Oplog Details
- MongoDB WiredTiger
- MongoDB InMemory/MMAPv1/RocksDB
Tips and Tricks: How to Find and Prevent MongoDB Database Issues in PMM
Percona Monitoring and Management monitors and provides actionable performance data for PostgreSQL. It captures metrics and data for PostgreSQL such as Connections, Active Connections, Tuples, Tuple Activity, and more. PMM provides:
- PostgreSQL Overview
- PostgreSQL Vacuum monitoring
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
Optimize and Troubleshoot MySQL using PMM
Peter Zaitsev talked about the Optimizing #MySQL performance and troubleshooting #MySQL problems are two of the most critical and challenging tasks for #MySQL #DBA's.
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 use this dashboard overview to gather metrics for ProxySQL and its interactions with the database and applications.
- ProxySQL Overview
Optimize and Troubleshoot MySQL using PMM
Peter Zaitsev talked about the Optimizing #MySQL performance and troubleshooting #MySQL problems are two of the most critical and challenging tasks for #MySQL #DBA's.
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. Dashboard information includes:
- Percona XtraDB Cluster / Galera Cluster Overview
- Percona XtraDB Cluster / Galera Graphs
Optimize and Troubleshoot MySQL using PMM
Peter Zaitsev talked about the Optimizing #MySQL performance and troubleshooting #MySQL problems are two of the most critical and challenging tasks for #MySQL #DBA's.
Trusted by global brands to unify, monitor, manage, secure and optimize their database environments
Jose M Ortega,
Python teacher
Yoann L.,
DBA
Jishnu V.,
Software Development Engineer
Warren R.,
Team Lead
Need help with your open source setup?
By submitting my information I agree that Percona may use my personal data in sending communication to me about Percona services. I understand that I can unsubscribe from the communication at any time in accordance with the Percona Privacy Policy. This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
RECOMMENDED ARTICLES
MongoDB Performance Regression Benchmarking and the Truth Behind Journaling
September 9, 2024
Blog
Percona Server for MySQL Performance Improvements – August 2024
August 26, 2024
Blog
Ultimate Guide to Improving MySQL Query Performance
July 17, 2024
Blog
MOST POPULAR ARTICLES
Auditing Login attempts in MySQL
December 28, 2012
Blog
Deploy Django on Kubernetes With Percona Operator for PostgreSQL
June 20, 2023
Blog
MySQL “Got an error reading communication packet”
May 16, 2016
Blog