Percona Monitoring and Management Documentation Percona Monitoring and Management Documentation¶
Percona Monitoring and Management (PMM) is an open-source platform for managing and monitoring MySQL, PostgreSQL, MongoDB, and ProxySQL performance. It is developed by Percona in collaboration with experts in the field of managed database services, support and consulting.
PMM is a free and open-source solution that you can run in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL, PostgreSQL and MongoDB servers to ensure that your data works as efficiently as possible.
- PMM Concepts
- Installing PMM Server
- Running PMM Server via Docker
- Running PMM Server Using AWS Marketplace
- PMM Server as a Virtual Appliance
- Verifying PMM Server
- Configuring PMM Server
- Installing PMM Client
- Using PMM Client
- Percona Platform
- Service configuration for best results
- Adding AWS RDS and Aurora services
- Using PMM Metrics Monitor
- Using PMM Query Analytics
- Dashboards references
- Insight
- OS Dashboards
- Prometheus Dashboards
- MySQL Dashboards
- MySQL Amazon Aurora Metrics
- MySQL Command/Handler Counters Compare Dashboard
- MySQL InnoDB Compression Dashboard
- MySQL InnoDB Metrics
- MySQL InnoDB Metrics (Advanced) Dashboard
- Change Buffer Performance
- InnoDB Log Buffer Performance
- InnoDB Page Splits
- InnoDB Page Reorgs
- InnoDB Purge Performance
- InnoDB Locking
- InnoDB Main Thread Utilization
- InnoDB Transactions Information
- InnoDB Undo Space Usage
- InnoDB Activity
- InnoDB Contention - OS Waits
- InnoDB Contention - Spin Rounds
- InnoDB Group Commit Batch Size
- InnoDB Purge Throttling
- InnoDB AHI Usage
- InnoDB AHI Maintenance
- InnoDB Online DDL
- InnoDB Defragmentation
- MySQL MyISAM Aria Metrics Dashboard
- MySQL MyRocks Metrics Dashboard
- MySQL Overview
- MySQL Uptime
- Current QPS
- InnoDB Buffer Pool Size
- Buffer Pool Size % of Total RAM
- MySQL Connections
- MySQL Active Threads
- MySQL Questions
- MySQL Thread Cache
- MySQL Select Types
- MySQL Sorts
- MySQL Slow Queries
- Aborted Connections
- Table Locks
- MySQL Network Traffic
- MySQL Network Usage Hourly
- MySQL Internal Memory Overview
- Top Command Counters and Top Command Counters Hourly
- MySQL Handlers
- MySQL Query Cache Memory and MySQL Query Cache Activity
- MySQL Open Tables, MySQL Table Open Cache Status, and MySQL Table Definition Cache
- MySQL Performance Schema Dashboard
- Performance Schema Wait Event Analysis Dashboard
- MySQL Query Response Time
- MySQL Replication
- MySQL Table Statistics
- MySQL User Statistics
- MongoDB Dashboards
- PostgreSQL Dashboards
- PostgreSQL Overview
- Connected
- Version
- Shared Buffers
- Disk-Page Buffers
- Memory Size for each Sort
- Disk Cache Size
- Autovacuum
- PostgreSQL Connections
- PostgreSQL Tuples
- PostgreSQL Transactions
- Temp Files
- Conflicts and Locks
- Buffers and Blocks Operations
- Canceled Queries
- Cache Hit Ratio
- Checkpoint Stats
- PostgreSQL Settings
- System Summary
- PostgreSQL Overview
- HA Dashboards
- How to Contact Percona
- Glossary
- Data retention
- Data Source Name
- DSN
- Grand Total Time
- %GTT
- External Monitoring Service
- Metrics
- Metrics Monitor (MM)
- Monitoring service
- PMM
- pmm-admin
- PMM Client
- PMM Docker Image
- PMM Home Page
- PMM Server
- PMM Server Version
- PMM user permissions for AWS
- PMM Version
- QAN
- Query Analytics (QAN)
- Query Load
- Query Metrics Summary Table
- Query Metrics Table
- Query Summary Table
- Quick ranges
- Selected Time or Date Range
- Telemetry
- Version
- Release Notes
- FAQ
- How can I contact the developers?
- What are the minimum system requirements for PMM?
- How to control data retention for PMM?
- How often are nginx logs in PMM Server rotated?
- What privileges are required to monitor a MySQL instance?
- Can I monitor multiple service instances?
- Can I rename instances?
- Can I add an AWS RDS MySQL or Aurora MySQL instance from a non-default AWS partition?
- How to troubleshoot communication issues between PMM Client and PMM Server?
- What resolution is used for metrics?
- How to set up Alerting in PMM?
- How to use a custom Prometheus configuration file inside of a PMM Server?
- Reference
Table Of Contents
- PMM Concepts
- Installing PMM Server
- Running PMM Server via Docker
- Running PMM Server Using AWS Marketplace
- PMM Server as a Virtual Appliance
- Verifying PMM Server
- Configuring PMM Server
- Installing PMM Client
- Using PMM Client
- Percona Platform
- Service configuration for best results
- Adding AWS RDS and Aurora services
- Using PMM Metrics Monitor
- Using PMM Query Analytics
- Dashboards references
- Insight
- OS Dashboards
- Prometheus Dashboards
- MySQL Dashboards
- MySQL Amazon Aurora Metrics
- MySQL Command/Handler Counters Compare Dashboard
- MySQL InnoDB Compression Dashboard
- MySQL InnoDB Metrics
- MySQL InnoDB Metrics (Advanced) Dashboard
- Change Buffer Performance
- InnoDB Log Buffer Performance
- InnoDB Page Splits
- InnoDB Page Reorgs
- InnoDB Purge Performance
- InnoDB Locking
- InnoDB Main Thread Utilization
- InnoDB Transactions Information
- InnoDB Undo Space Usage
- InnoDB Activity
- InnoDB Contention - OS Waits
- InnoDB Contention - Spin Rounds
- InnoDB Group Commit Batch Size
- InnoDB Purge Throttling
- InnoDB AHI Usage
- InnoDB AHI Maintenance
- InnoDB Online DDL
- InnoDB Defragmentation
- MySQL MyISAM Aria Metrics Dashboard
- MySQL MyRocks Metrics Dashboard
- MySQL Overview
- MySQL Uptime
- Current QPS
- InnoDB Buffer Pool Size
- Buffer Pool Size % of Total RAM
- MySQL Connections
- MySQL Active Threads
- MySQL Questions
- MySQL Thread Cache
- MySQL Select Types
- MySQL Sorts
- MySQL Slow Queries
- Aborted Connections
- Table Locks
- MySQL Network Traffic
- MySQL Network Usage Hourly
- MySQL Internal Memory Overview
- Top Command Counters and Top Command Counters Hourly
- MySQL Handlers
- MySQL Query Cache Memory and MySQL Query Cache Activity
- MySQL Open Tables, MySQL Table Open Cache Status, and MySQL Table Definition Cache
- MySQL Performance Schema Dashboard
- Performance Schema Wait Event Analysis Dashboard
- MySQL Query Response Time
- MySQL Replication
- MySQL Table Statistics
- MySQL User Statistics
- MongoDB Dashboards
- PostgreSQL Dashboards
- PostgreSQL Overview
- Connected
- Version
- Shared Buffers
- Disk-Page Buffers
- Memory Size for each Sort
- Disk Cache Size
- Autovacuum
- PostgreSQL Connections
- PostgreSQL Tuples
- PostgreSQL Transactions
- Temp Files
- Conflicts and Locks
- Buffers and Blocks Operations
- Canceled Queries
- Cache Hit Ratio
- Checkpoint Stats
- PostgreSQL Settings
- System Summary
- PostgreSQL Overview
- HA Dashboards
- How to Contact Percona
- Glossary
- Data retention
- Data Source Name
- DSN
- Grand Total Time
- %GTT
- External Monitoring Service
- Metrics
- Metrics Monitor (MM)
- Monitoring service
- PMM
- pmm-admin
- PMM Client
- PMM Docker Image
- PMM Home Page
- PMM Server
- PMM Server Version
- PMM user permissions for AWS
- PMM Version
- QAN
- Query Analytics (QAN)
- Query Load
- Query Metrics Summary Table
- Query Metrics Table
- Query Summary Table
- Quick ranges
- Selected Time or Date Range
- Telemetry
- Version
- Release Notes
- FAQ
- How can I contact the developers?
- What are the minimum system requirements for PMM?
- How to control data retention for PMM?
- How often are nginx logs in PMM Server rotated?
- What privileges are required to monitor a MySQL instance?
- Can I monitor multiple service instances?
- Can I rename instances?
- Can I add an AWS RDS MySQL or Aurora MySQL instance from a non-default AWS partition?
- How to troubleshoot communication issues between PMM Client and PMM Server?
- What resolution is used for metrics?
- How to set up Alerting in PMM?
- How to use a custom Prometheus configuration file inside of a PMM Server?
- Reference