Table Of Contents

• PMM 1
• PMM 2

• What is Percona Monitoring and Management?
• PMM Concepts
  • Client/Server Architecture - an Overview
    • PMM Client
    • PMM Server
    • Percona Platform
      • Security Threat Tool
  • Services
    • MySQL requirements
      • Creating a MySQL User Account for PMM
    • MongoDB requirements
      • Configuring MongoDB for Monitoring in PMM Query Analytics
      • Setting Up the Required Permissions
      • Enabling Profiling
        • Enabling Profiling on Command Line
        • Enabling Profiling in the Configuration File
    • PostgreSQL requirements
• Installing PMM Server
  • PMM Server as a Docker container
    • Introduction
    • Run an image
    • Backup and upgrade
    • Downgrade and restore
  • Running PMM Server Using AWS Marketplace
    • Setting Up a PMM Instance Using the website GUI
    • Setting up a VPC and an EC2 Instance Type
    • Limiting Access to the instance: security group and a key pair
    • Applying settings
    • Adjusting instance settings in the EC2 Console
    • Running the instance
    • Resizing the EBS Volume
    • Upgrading PMM Server on AWS
      • Upgrading EC2 instance class
      • Expanding the PMM Data EBS Volume
      • Expand existing EBS volume
  • PMM Server as a Virtual Appliance
    • Supported Platforms for Running the PMM Server Virtual Appliance
    • VirtualBox Using the Command Line
    • VirtualBox Using the GUI
    • VMware Workstation Player
    • Identifying PMM Server IP Address
    • Accessing PMM Server
    • Accessing the Virtual Machine
    • Next Steps
  • Verifying PMM Server
    • Accessing the Components of the Web Interface
  • Configuring PMM Server
    • PMM Settings Page
      • Metrics resolution
      • Advanced Settings
      • SSH Key Details
      • Alertmanager integration
      • Percona Platform
      • Diagnostics
    • Exploring PMM API
  • Updating a Server
• Installing PMM Client
  • Installing Clients
  • Installing DEB packages using apt-get
  • Installing RPM packages using yum
• Using PMM Client
  • Configuring PMM Client with pmm-admin config
    • Connecting PMM Clients to the PMM Server
  • Adding MySQL Service Monitoring
    • USAGE
  • Adding MongoDB Service Monitoring
  • Adding a ProxySQL host
    • USAGE
  • PostgreSQL
    • Adding PostgreSQL extension for queries monitoring
    • Adding PostgreSQL queries and metrics monitoring
    • Setting up the required user permissions and authentication
  • Adding Linux metrics
    • Adding general system metrics service
  • Adding External Services
    • Adding general external services
      • Usage
  • Removing monitoring services with pmm-admin remove
    • USAGE
    • SERVICES
    • EXAMPLES
  • Annotating important Application Events
    • Adding annotations
    • Combining flags
    • Annotation Visibility
• Percona Platform
  • Introduction
  • Security Threat Tool
    • Where to see the results of checks
    • How to enable the Security Threat Tool
    • Checks made by the Security Threat Tool
  • PMM DBaaS
    • Add a Kubernetes cluster
    • Delete a Kubernetes cluster
• Service configuration for best results
  • MySQL
    • Slow Log Settings
      • Configuring the Slow Log File
      • Fine tune
      • Slow log file rotation
    • Configuring Performance Schema
    • Improving PMM Performance with Table Statistics Options
      • Disable per-table statistics for an instance
        • USAGE
      • Change the number of tables beyond which per-table statistics is disabled
        • USAGE
        • EXAMPLE
    • MySQL InnoDB Metrics
    • Percona Server specific settings
      • MySQL User Statistics (userstat)
      • Query Response Time Plugin
      • log_slow_rate_limit
      • log_slow_verbosity
      • slow_query_log_use_global_control
    • Configuring MySQL 8.0 for PMM
  • MongoDB
    • Passing SSL parameters to the mongodb monitoring service
  • PostgreSQL
    • Adding PostgreSQL extension for queries monitoring
    • Adding PostgreSQL queries and metrics monitoring
    • Setting up the required user permissions and authentication
• Configuring AWS RDS or Aurora Services
  • Required AWS settings
    • Creating an IAM user with permission to access Amazon RDS DB instances
    • Creating a policy
    • Creating an IAM user
    • Creating an access key for an IAM user
    • Attaching a policy to an IAM user
    • Setting up the Amazon RDS DB Instance
  • Adding an Amazon RDS MySQL, Aurora MySQL, or Remote Instance
• Using PMM Metrics Monitor
  • Understanding Dashboards
    • Opening a Dashboard
    • Viewing More Information about a Graph
    • Rendering Dashboard Images
  • Navigating across Dashboards
    • Zooming in on a single metric
• Query Analytics
  • Filters Panel
  • Overview Panel
  • Details Panel
    • Details Tab
    • Examples Tab
    • Explain Tab
    • Tables Tab
  • Query Analytics for MongoDB
• Dashboards Reference
  • Insight
    • Advanced Data Exploration
      • View actual metric values (Gauge)
      • View actual metric values (Counters)
      • Metric Rates
    • Home Dashboard
      • General Information
      • Shared and Recently Used Dashboards
      • Statistics
      • Environment Overview
    • Prometheus
      • Prometheus Overview
      • Resources
      • Storage (TSDB) Overview
      • Scraping
      • Queries
      • Network
      • Time Series Information
      • System Level Metrics
      • PMM Server Logs
    • Prometheus Exporter Status
    • Prometheus Exporters Overview
      • Prometheus Exporters Summary
      • Prometheus Exporters Resource Usage by Node
      • Prometheus Exporters Resource Usage by Type
      • List of Hosts
  • PMM
    • PMM Inventory
      • Removing items from the inventory
  • OS Dashboards
    • CPU Utilization Details
      • Overall CPU Utilization
      • Current CPU Threads Utilization
      • CPU Threads Frequency
      • Current CPU Cores Temperature
      • Overall CPU Threads Utilization Details
    • Disk Details
      • Mountpoint Usage
      • Mountpoint
      • Disk Latency
      • Disk Operations
      • Disk Bandwidth
      • Disk Load
      • Disk IO Utilization
      • Avg Disks Operations Merge Ratio
      • Disk IO Size
    • Network Details
      • Last Hour Statistic
      • Network Traffic
      • Network Traffic Details
      • Network Netstat TCP
      • Network Netstat UDP
      • ICMP
    • Memory Details
      • Memory Usage
    • Node Temperature Details
      • CPU Cores Temperatures
      • Chip Temperatures
      • Fan Rotation Speeds
      • Fan Power Usage
    • Nodes Compare
    • Nodes Overview
    • Node Summary
      • System Summary
      • CPU Usage
      • CPU Saturation and Max Core Usage
      • Interrupts and Context Switches
      • Processes
      • Memory Utilization
      • Virtual Memory Utilization
      • Swap Space
      • Swap Activity
      • I/O Activity
      • Global File Descriptors Usage
      • Disk IO Latency
      • Disk IO Load
      • Network Traffic
      • Network Utilization Hourly
      • Local Network Errors
      • TCP Retransmission
    • NUMA Details
      • Memory Usage
      • Free Memory Percent
      • NUMA Memory Usage Types
      • NUMA Allocation Hits
      • NUMA Allocation Missed
      • Anonymous Memory
      • NUMA File (PageCache)
      • Shared Memory
      • HugePages Statistics
      • Local Processes
      • Remote Processes
      • Slab Memory
    • Processes Details
      • Number of PIDs
      • Percentage of Max PIDs Limit
      • Number of Threads
      • Percentage of Max Threads Limit
      • Runnable Processes
      • Blocked Processes Waiting for I/O
      • Sleeping Processes
      • Running Processes
      • Disk Sleep Processes
      • Stopped Processes
      • Zombie Processes
      • Dead Processes
  • Prometheus Dashboards
    • Prometheus
      • Prometheus Overview
      • Resources
      • Storage (TSDB) Overview
      • Scraping
      • Queries
      • Network
      • Time Series Information
      • System Level Metrics
      • PMM Server Logs
    • Prometheus Exporter Status
    • Prometheus Exporters Overview
      • Prometheus Exporters Summary
      • Prometheus Exporters Resource Usage by Node
      • Prometheus Exporters Resource Usage by Type
      • List of Hosts
  • MySQL Dashboards
    • MySQL Amazon Aurora Details
      • Amazon Aurora Transaction Commits
      • Amazon Aurora Load
      • Aurora Memory Used
      • Amazon Aurora Statement Latency
      • Amazon Aurora Special Command Counters
      • Amazon Aurora Problems
    • MySQL Command/Handler Counters Compare
    • MySQL InnoDB Compression Details
      • Compression level and failure rate threshold
      • Statistic of compression operations
      • CPU Core Usage
      • Buffer Pool Total
    • MySQL InnoDB Details
      • InnoDB Checkpoint Age
      • InnoDB Transactions
      • InnoDB Row Operations
      • InnoDB Row Lock Time
      • InnoDB I/O
      • InnoDB Log File Usage Hourly
      • InnoDB Deadlocks
      • InnoDB Condition Pushdown
      • Other Metrics
    • MySQL MyISAM/Aria Details
      • MyISAM Key Buffer Performance
      • Aria Pagecache Reads/Writes
      • Aria Transaction Log Syncs
      • Aria Pagecache Blocks
    • MySQL MyRocks Details
    • MySQL Instance Summary
      • MySQL Connections
      • MySQL Aborted Connections
      • MySQL Client Thread Activity
      • MySQL Thread Cache
      • MySQL Slow Queries
      • MySQL Select Types
      • MySQL Sorts
      • MySQL Table Locks
      • MySQL Questions
      • MySQL Network Traffic
      • MySQL Network Usage Hourly
      • MySQL Internal Memory Overview
      • Top Command Counters
      • Top Command Counters Hourly
      • MySQL Handlers
      • MySQL Query Cache Memory
      • MySQL Query Cache Activity
      • MySQL Table Open Cache Status
      • MySQL Open Tables
      • MySQL Table Definition Cache
    • MySQL Instances Compare
    • MySQL Instances Overview
    • MySQL Wait Event Analyses Details
    • MySQL Performance Schema Details
    • MySQL Query Response Time Details
      • Average Query Response Time
      • Query Response Time Distribution
      • Average Query Response Time
      • Read Query Response Time Distribution
      • Write Query Response Time Distribution
    • MySQL Replication Summary
      • IO Thread Running
      • SQL Thread Running
      • Replication Error No
      • Read only
      • MySQL Replication Delay
      • Binlog Size
      • Binlog Data Written Hourly
      • Binlogs Count
      • Binlogs Created Hourly
      • Relay Log Space
      • Relay Log Written Hourly
    • MySQL Group Replication Summary
      • Overview
      • Transactions
      • Conflicts
    • MySQL Table Details
      • Largest Tables
      • Pie
      • Table Activity
      • Rows read
      • Rows Changed
      • Auto Increment Usage
    • MySQL User Details
    • MySQL TokuDB Details
  • MongoDB Dashboards
    • MongoDB Cluster Summary
      • Current Connections Per Shard
      • Total Connections
      • Cursors Per Shard
      • Mongos Cursors
      • Operations Per Shard
      • Total Mongos Operations
      • Change Log Events
      • Oplog Range by Set
    • MongoDB Instance Summary
      • Command Operations
      • Latency Detail
      • Connections
      • Cursors
      • Document Operations
      • Queued Operations
      • Query Efficiency
      • Scanned and Moved Objects
      • getLastError Write Time
      • getLastError Write Operations
      • Assert Events
      • Page Faults
    • MongoDB Instances Overview
      • Command Operations
      • Connections
      • Cursors
      • Document Operations
      • Queued Operations
      • getLastError Write Time, getLastError Write Operations
      • Asserts
      • Memory Faults
    • MongoDB Instances Compare
      • Connections
      • Cursors
      • Latency
      • Scan Ratios
      • Index Filtering Effectiveness
      • Requests
      • Document Operations
      • Queued Operations
      • Used Memory
    • MongoDB ReplSet Summary
      • Replication Lag
      • Operations - by service name
      • Max Member Ping Time - by service name
      • Max Heartbeat Time
      • Elections
      • Oplog Recovery Window - by service name
    • MongoDB InMemory Details
      • InMemory Transactions
      • InMemory Capacity
      • InMemory Sessions
      • InMemory Pages
      • InMemory Concurrency Tickets
      • Queued Operations
      • Document Changes
      • InMemory Cache Eviction
      • Scanned and Moved Objects
      • Page Faults
    • MongoDB MMAPv1 Details
      • Document Activity
      • MMAPv1 Lock Wait Time
      • MMAPv1 Page Faults
      • MMAPv1 Journal Write Activity
      • MMAPv1 Journal Commit Activity
      • MMAPv1 Background Flushing Time
      • Queued Operations
      • Client Operations
      • Scanned and Moved Objects
    • MongoDB WiredTiger Details
      • WiredTiger Transactions
      • WiredTiger Cache Activity
      • WiredTiger Block Activity
      • WiredTiger Sessions
      • WiredTiger Concurrency Tickets Available
      • Queued Operations
      • WiredTiger Checkpoint Time
      • WiredTiger Cache Eviction
      • WiredTiger Cache Capacity
      • WiredTiger Cache Pages
      • WiredTiger Log Operations
      • WiredTiger Log Activity
      • WiredTiger Log Records
      • Document Changes
      • Scanned and Moved Objects
      • Page Faults
  • PostgreSQL Dashboards
    • PostgreSQL Instances 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 Instance Summary
      • Number of Temp Files
      • Size of Temp Files
      • Temp Files Activity
      • Temp Files Utilization
      • Canceled Queries
    • PostgreSQL Instances Compare
  • ProxySQL Dashboards
    • ProxySQL Instance Summary
      • Network Traffic
  • HA Dashboards
    • PXC/Galera Node Summary
      • Galera Replication Latency
      • Galera Replication Queues
      • Galera Cluster Size
      • Galera Flow Control
      • Galera Parallelization Efficiency
      • Galera Writing Conflicts
      • Available Downtime before SST Required
      • Galera Writeset Count
      • Galera Writeset Size
      • Galera Writeset Traffic
      • Galera Network Usage Hourly
    • PXC/Galera Cluster Summary
    • PXC/Galera Nodes Compare
      • $cluster - Galera Cluster Size
• Contact Us
  • Contacting the developers
  • Reporting bugs
  • Contributing to development
• Glossary
• Release Notes
  • Percona Monitoring and Management 2.10.0
    • New Features
    • Improvements
    • Bugs Fixed
    • Known Issues
  • Percona Monitoring and Management 2.9.1
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.9.0
    • Highlights
    • New Features
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.8.0
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.7.0
    • New Features
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.6.1
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.6.0
    • New Features
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.5.0
    • New Features
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.4.0
    • New Features
    • Improvements
    • Bugs Fixed
  • Percona Monitoring and Management 2.3.0
    • Improvements and new features
    • Fixed bugs
  • Percona Monitoring and Management 2.2.2
    • Improvements and new features
    • Fixed bugs
  • Percona Monitoring and Management 2.2.1
    • Improvements and new features
    • Fixed bugs
  • Percona Monitoring and Management 2.2.0
    • Improvements and new features
    • Fixed bugs
  • Percona Monitoring and Management 2.1.0
    • Improvements and new features
    • Fixed bugs
  • Percona Monitoring and Management 2.0.1
    • Improvements
    • Fixed bugs
  • Percona Monitoring and Management 2.0.0
• Frequently Asked Questions
  • 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 do I troubleshoot communication issues between PMM Client and PMM Server?
  • What resolution is used for metrics?
  • How do I set up Alerting in PMM?
  • How do I use a custom Prometheus configuration file inside PMM Server?
  • How to troubleshoot an Update?
• Reference
  • pmm-admin - PMM Administration Tool
    • NAME
    • SYNOPSIS
    • DESCRIPTION
    • FLAGS
    • COMMANDS
      • GENERAL COMMANDS
      • INFORMATION COMMANDS
      • CONFIGURATION COMMANDS
      • DATABASE COMMANDS
        • MongoDB
        • MySQL
        • PostgreSQL
        • ProxySQL
    • EXAMPLES

Previous topic

Percona Monitoring and Management 2.9.0

Next topic

Percona Monitoring and Management 2.7.0