PERCONA MONITORING AND MANAGEMENT DOCUMENTATION
Percona Monitoring and Management
Initializing search
percona/pmm
Percona Monitoring and Management
percona/pmm
Home
Get help from Percona
Discover
Discover
Why PMM?
Key features
Quickstart guide
Install
Install
PMM installation overview
Plan your PMM installation
Plan your PMM installation
Choose a PMM deployment strategy
Hardware and system requirements
Network and firewall requirements
Install PMM Server
Install PMM Server
Server installation overview
Prerequisites
Deployment options
Deployment options
Install on Docker
Install on Docker
Install PMM Server with Docker
Run Docker via the Easy-install script
Storage setup
Storage setup
Docker volumes (recommended)
Host directory (not recommended)
Setup and configuration
Setup and configuration
Environment variables
Preview environment variables
Install PMM Server in isolated environments
Container settings
Container settings
Back up PMM Server Docker container
Restore PMM Server Docker container
Remove PMM Server Docker container
Upgrade PMM Server Docker container
Install on Podman
Install on Podman
Install PMM Server with Podman
Setup and configuration
Setup and configuration
Back up PMM Server Podman container
Restore PMM Server Podman container
Remove PMM Server Podman container
Install on virtual machines
Install on virtual machines
Install on Virtual Appliance
Install on Virtual Appliance
Overview
Download OVA
Deploy on VirtualBox
Deploy on VMware (deprecated)
Install on AWS Marketplace
Install on AWS Marketplace
Planning
Deployment
Initial setup
VM configuration
VM configuration
Configure environment variables
Access PMM UI
Remove VM
SSH key
Install on Kubernetes
Install on Kubernetes
Install PMM Server with Helm on Kubernetes clusters
Backup & maintenance
Backup & maintenance
Back up PMM Server Helm deployment
Restore Helm chart
Install PMM Client
Install PMM Client
Client installation overview
Prerequisites for PMM Client
Deployment options
Deployment options
Install with Package Manager
Install from binaries
Install on Docker
Configure monitoring
Configure monitoring
Database monitoring
Database monitoring
Overview
MySQL
MongoDB
PostgreSQL
Valkey/Redis
Cloud services monitoring
Cloud services monitoring
AWS
Azure
Google Cloud
System monitoring
System monitoring
Linux
Remote
Proxy services monitoring
Proxy services monitoring
HAproxy
ProxySQL
External services monitoring
External services monitoring
Connect external instance
Install PMM in HA mode
Use
Use
About using PMM
PMM user interface
PMM user interface
UI components
Log into PMM
Set timezones
PMM Inventory
Remove services
Metrics monitoring
Metrics monitoring
About monitoring in PMM
PMM metrics
PMM metrics
About PMM metrics
Extend metrics
Dashboards
Dashboards
Dashboards overview
Manage dashboards
Manage dashboards
Create dashboard folders
Manage dashboard folders
Setting custom Home dashboard
Share dashboards and panels
Annotate
Query Analytics
Query Analytics
About Query Analytics (QAN)
Query Analytics with MySQL
Query Analytics for MongoDB
Share a link for Query Analytics
Panels on QAN dashboard
Panels on QAN dashboard
Overview Panel
QAN Filters panel
Details panel
Percona Advisors
Percona Advisors
Advisor details
Develop custom advisors
List of advisors and checks
List of advisors and checks
Advisor details
Configuration advisors
Configuration advisors
Version configuration checks
Version configuration checks
MongoDB version check
MongoDB Versions
Unsupported MySQL version
Percona Server for MySQL 5.7 End-Of-Life
Percona Distribution for PostgreSQL End Of Life
PostgreSQL outdated extensions
PostgreSQL version compatibility
PostgreSQL version
Generic configuration checks
Generic configuration checks
Adviosor check: MongoDB active vs available connections
Check WiredTiger cache size
MongoDB journal enabled
MongoDB logLevel is not default
MongoDB read ticket is more than 128
MongoDB write ticket is more than 128
Write tickets during runtime are > 128
Automatic_sp_privileges configuration for MySQL
MySQL binlog_expire_logs_seconds too low
MySQL binlog_row_image set to MINIMAL
MySQL binlog checksum not set
MySQL General log is active
MySQL Redo log (binary log) not enabled
MySQL SQL mode not fitting best practice
MySQL Temporary tables dimension is capped by max_heap_table_size
Warnings are not being logged
Time zone data not loaded
fsync is disabled on PostgreSQL configuration
PostgreSQL log_checkpoints is not enabled
Minimim PostgreSQL logging features
Postgres WAL retention check
PostgreSQL Archiver is failing
Resources configuration checks
Resources configuration checks
MongoDB fragmented collections
MongoDB CPU cores check
MongoDB DBPATH mount
MongoDB FeatureCompatibilityVersion
Check the maxSessions value
MongoDB Swap Allocation
Check taskExecutorPoolsize value
MongoDB XFS Filesystem type
MySQL binaries are 32-bit
Connection configuration checks
Connection configuration checks
MongoDB Connections sudden spike
MongoDB high connections
MySQL max connection usage check
PostgreSQL max_connections set too high
Replication configuration checks
Replication configuration checks
MongoDB PSA Architecture
MongoDB replica set topology
MongoDB replica set topology
Check the replica set topology
MySQL relay log on the replica node is not automatically purged
MySQL Replica node is not configured as READ-ONLY
MySQL enforced data integrity checking is disabled
MySQL enforced data integrity checking is disabled
Replica SQL processing not multi-threaded
MySQL check binary log sync status
MySQL server replicating events are not logged
The advisor checks for two replication specific configuration options
InnoDB configuration checks
InnoDB configuration checks
InnoDB redo log size advisor
Redo log is disabled in this instance
MySQL InnoDB file format in use
MySQL InnoDB tablespace has a max cap and cannot auto-extend
MySQL innodb_file_per_table configuration is enabled
MySQL InnoDB file format in use
MySQL InnoDB strict mode not correct
Vacuum configuration checks
Vacuum configuration checks
PostgreSQL log_autovacuum_min_duration is disabled (Set to -1)
Check the tables that have “per table” vacuum settings
Transaction ID wraparound is approaching
PostgreSQL Vacuum sanity
Performance advisors
Performance advisors
Generic performance checks
Generic performance checks
MongoDB - Multiple mongod service running in a single node
PostgreSQL cache hit ratio
Settings changed on a instance that requires a restart
PostgreSQL temporary files written to disk check
Vacuum performance checks
Vacuum performance checks
Check Table bloat in bytes
Table bloat in percentage of table size
Replication performance checks
Replication performance checks
MongoDB sharding - chunk imbalance across shards
MongoDB Oplog Sizing
MongoDB replication lag
PostgreSQL stale replication slot
Security advisors
Security advisors
CVE security checks
CVE security checks
Security vulnerabilities
Configuration security checks
Configuration security checks
MongoDB not using the default SCRAM-SHA-256 authentication
Verify if local infile global variable is disabled
MySQL secure_file_priv configuration option empty check
MySQL expired passwords
MySQL secure transport only
MySQL InnoDB password lifetime
Policy-based password validation does not perform dictionary checks
PostgreSQL roles with expiring passwords
Authentication security checks
Authentication security checks
Check mongodb localhost bypass
Anonymous users
User with open to the word scope
Root account can log in remotely
s: User not using SSL protocol to connect
Too many accounts with SUPER privileges
s: There are users without passwords
Replication security checks
Replication security checks
Replica without replication slave account
Replication privileges
Connection security checks
Connection security checks
MongoDB BindIP Check
Query advisors
Query advisors
Index query checks
Index query checks
MongoDB sharding - inconsistent indexes across sharded collections
MongoDB unused indexes
Performance check for On-Disk Temporary MySQL tables
Found tables without primary keys
Check for relations with high number of indexes
PostgreSQL excessive sequential scans
Check for relations with unused indexes for PostgreSQL
Schema design query checks
Schema design query checks
Index size is larger than data size
Percona Alerting
Percona Alerting
About Percona Alerting
Alert rules and alert templates
Contact points
List of available alert templates
Silence alerts
Disable Percona Alerting
Back up and restore
Back up and restore
Back up and restore
Prepare a storage location
MongoDB backups
MongoDB backups
Supported setups for MongoDB backups
MongoDB backup prerequisites
Create MongoDB on-demand and scheduled backups
Create MongoDB PITR backups
Restore a MongoDB backup
MongoDB Backup and Restore support matrix
MySQL backups
MySQL backups
MySQL backup prerequisites
Supported setups for MySQL backups
Create a MySQL backup
Restore a MySQL backup
Edit a scheduled backup
Delete a backup
Configure
Configure
Configure PMM
Metrics resolution
Advanced PMM settings
SSH key
Security in PMM
Security in PMM
About security in PMM
SSL encryption
Grafana HTTPS secure cookies
PMM data encryption
Percona Platform
Percona Platform
Integrate PMM with Percona Platform
Connect PMM to Percona Platform
Check Percona Portal account information
Administer
Administer
About PMM administration
Manage users
Manage users
About user management in PMM
Add users
Edit users
Delete users
Roles and permissions
Roles and permissions
Standard role permissions
Label-based access control
Label-based access control
About label based access control (LBAC) in PMM
Labels for access control
Enable access control
Create access roles
Manage access roles
Assign access roles to users
Implementing LBAC: practical scenarios
Upgrade
Upgrade
Upgrade PMM Server
Upgrade PMM Server
About PMM Server upgrade
Upgrade PMM v3 Server from the UI
Migrate external PostgreSQL configuration for PMM 3.2.0+ upgrades
Manual upgrade
Manual upgrade
Manual upgrade: Upgrade PMM Server using Docker
Manual upgrade: Upgrade PMM Server using Podman
Upgrade PMM Server in K8s
Upgrade PMM Server in K8s
Upgrade PMM Server using Helm
Migrate PMM 2 to PMM 3
Migrate from VMware to alternative platforms
Upgrade PMM Server on AWS
Upgrade PMM Client
Uninstall
Uninstall
About uninstalling PMM
Unregister PMM Client from PMM Server
Uninstall PMM Client
Uninstall PMM Client
Docker
Helm
Package manager
Troubleshoot
Troubleshoot
Troubleshoot PMM
Troubleshooting checklist
Troubleshoot upgrade issues
Configuration issues
Percona Alerting issues
QAN issues
Plugin issues
Export PMM data with PMM Dump
Missing data
Release notes
Release notes
Release notes index
PMM 3.5.0 (2025-11-19)
PMM 3.4.1 (2025-10-13)
PMM 3.4.0 (2025-09-15)
PMM 3.3.1 (2025-07-30)
PMM 3.3.0 (2025-07-09)
PMM 3.2.0 (2025-05-29)
PMM 3.1.0 (2025-03-31)
PMM 3.0.0-1 (2025-02-10)
PMM 3.0.0 (2025-01-30)
Reference
Reference
Architecture
Architecture
PMM Architecture
Third-party components in PMM
Third-party components in PMM
VictoriaMetrics
Use external ClickHouse with PMM
Configure PMM with external PostgreSQL
PMM components and versions
Data handling in PMM
PMM API
PMM API
About PMM API
Service accounts authentication
PMM commands
PMM commands
About PMM commands
pmm-admin - PMM administration tool
pmm-agent - PMM Client agent
PMM dashboards
PMM dashboards
Insight
Insight
Home Dashboard
Advanced Data Exploration
VictoriaMetrics
VictoriaMetrics Agents Overview
Environments
Environments
Environment Overview
Environment Summary
Kubernetes
Kubernetes
Kubernetes Cluster Summary
Kubernetes monitoring for Percona Operators
DB clusters managed with Percona Kubernetes Operators
OS Dashboards
OS Dashboards
CPU Utilization Details
Disk Details
Network Details
Memory Details
Node Temperature Details
Nodes Compare
Nodes Overview
Node Summary
NUMA Details
Processes Details
Prometheus dashboards
Prometheus dashboards
Prometheus Exporter Status
Prometheus Exporters Overview
MySQL dashboards
MySQL dashboards
MySQL Amazon Aurora Details
MySQL Command/Handler Counters Compare
MySQL InnoDB Compression Details
MySQL InnoDB Details
MySQL MyISAM/Aria Details
MySQL MyRocks Details
MySQL Instance Summary
MySQL Instances Compare
MySQL Instances Overview
MySQL Wait Event Analyses Details
MySQL Performance Schema Details
MySQL Query Response Time Details
MySQL Replication Summary
MySQL Group Replication Summary
MySQL Table Details
MySQL User Details
MySQL TokuDB Details
MongoDB dashboards
MongoDB dashboards
Experimental MongoDB Collection Overview
Experimental MongoDB Collection Details
Experimental MongoDB Oplog Details
MongoDB Sharded Cluster Summary
MongoDB Instance Summary
MongoDB Instances Overview
MongoDB Instances Compare
MongoDB ReplSet Summary
MongoDB Router Summary
MongoDB InMemory Details
MongoDB MMAPv1 Details
MongoDB WiredTiger Details
MongoDB PBM Details dashboard
PostgreSQL dashboards
PostgreSQL dashboards
PostgreSQL Checkpoints, Buffers and WAL Usage
PostgreSQL Instance Summary
PostgreSQL Instances Compare
PostgreSQL Instances Overview
PostgreSQL Instances Overview Extended
PostgreSQL Patroni Details
PostgreSQL Replication Overview
PostgreSQL Top Queries
ProxySQL dashboards
ProxySQL dashboards
ProxySQL Instance Summary
Valkey/Redis dashboards
Valkey/Redis dashboards
Overview
Clients
Cluster Details
Command Detail
Load
Memory
Network
Persistence Details
Replication
Slowlog
HA dashboards
HA dashboards
PXC/Galera Node Summary
PXC/Galera Cluster Summary
Experimental PXC/Galera Cluster Summary
PXC/Galera Nodes Compare
HAProxy Instance Summary
Configure Nomad
Glossary
FAQ
Trademark policy
Copyright and licensing information
Download PDF
Rate this page
☆
☆
☆
☆
☆
Thanks for your feedback
Thank you! The feedback has been submitted.
×
Email
(optional)
Send
Edit this page on GitHub
Get free database assistance or contact our experts for personalized support.
Get help from Percona
Page not found
Back to top