Percona Monitoring and Management 2.2.2 Percona Monitoring and Management 2.2.2¶
| Date: | February 4, 2020 |
|---|
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.
For PMM install instructions, see Installing PMM Server and Installing PMM Client.
Note
PMM 2 is designed to be used as a new installation — your existing PMM 1 environment can’t be upgraded to this version.
Improvements and new features¶
- PMM-5321: The optimization of the Query Analytics parser code for PostgreSQL queries allowed us to reduce the memory resources consumption by 1-5%, and the parsing time of an individual query by 30-40%
- PMM-5184: The
pmm-admin summarycommand have gained a new--skip-serverflag which makes it operating in a local-only mode, creating summary file without contacting the PMM Server
Fixed bugs¶
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
- 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?
Previous topic
Percona Monitoring and Management 2.3.0