Table Of Contents

• PMM 1
• PMM 2

• PMM Concepts
  • Client/Server Architecture - an Overview
    • PMM Client
    • PMM Server
    • Percona Platform
      • Security Threat Tool
  • Services
    • MySQL requirements
      • Creating a MySQL User Account to Be Used with 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
      • Supported versions of PostgreSQL
• Installing PMM Server
  • Running PMM Server via Docker
    • Setting Up a Docker Container for PMM Server
      • Pulling the PMM Server Docker Image
      • Creating the pmm-data Container
      • Creating and Launching the PMM Server Container
      • Installing and using specific PMM Server version
    • Updating PMM Server Using Docker
      • Creating a backup version of the current pmm-server Docker container
      • Pulling a new Docker Image
      • Creating a new Docker container based on the new image
      • Removing the backup container
    • Backing Up PMM Data from the Docker Container
    • Restoring the Backed Up Information to the PMM Data Container
  • 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
    • Identifying PMM Server IP Address
    • Accessing PMM Server
    • Accessing the Virtual Machine
    • Next Steps
  • Verifying PMM Server
  • Configuring PMM Server
    • PMM Settings Page
      • Settings
      • Metrics resolution
      • Telemetry
      • Check for updates
      • Security Threat Tool
      • SSH Key Details
      • Prometheus Alertmanager integration
      • Diagnostics
    • Exploring PMM API
• 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
  • Adding MongoDB Service Monitoring
  • Adding a ProxySQL host
    • Adding ProxySQL metrics service
  • Adding Linux metrics
    • Adding general system metrics service
  • Adding External Services
    • Adding general external services
      • Usage
  • Removing monitoring services with pmm-admin remove
  • Annotating important Application Events
    • Adding annotations
    • 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
• Service configuration for best results
  • MySQL
    • Slow Log Settings
    • 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
• Adding AWS RDS and 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
  • Navigating across Dashboards
    • Zooming in on a single metric
• Using PMM Query Analytics
  • Introduction
  • Navigating to Query Analytics
  • Understanding Top 10
    • Query Detail Section
  • Filtering Queries
    • Totals of the Query Summary
    • Queries in the Query Summary Table
    • Viewing a Specific Value of a Metric
  • MongoDB specific
    • Query Analytics for MongoDB
• Dashboards references
  • Insight
    • Advanced Data Exploration
      • View actual metric values (Gauge)
      • View actual metric values (Counters)
      • View actual metric values (Counters)
    • 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 Host
      • Prometheus Exporters Resource Usage by Type
      • List of Hosts
  • OS Dashboards
    • CPU Utilization Details
      • Overall CPU Utilization
      • Current CPU Core Utilization
      • All Cores - Total
    • Disk Details
      • Mountpoint Usage
      • Mountpoint
    • Network Details
      • Last Hour Statistic
      • Network Traffic
      • Network Traffic Details
      • Network Netstat TCP
      • Network Netstat UDP
      • ICMP
    • Node Temperature Details
    • Nodes Compare
    • Nodes Overview
    • 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
  • 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 Host
      • Prometheus Exporters Resource Usage by Type
      • List of Hosts
  • MySQL Dashboards
    • MySQL Amazon Aurora Metrics
      • 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 Dashboard
    • MySQL InnoDB Compression Dashboard
      • Compression level and failure rate threshold
      • Statistics of Compression Operations
      • CPU Core Usage
      • Buffer Pool Total
      • Buffer Pool All
    • MySQL InnoDB Metrics
      • 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 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
      • Aria Storage Engine
      • Aria Pagecache Reads/Writes
      • Aria Pagecache Blocks
      • Aria Transactions Log Syncs
    • 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
      • Average Query Response Time
      • Query Response Time Distribution
      • Average Query Response Time (Read/Write Split)
      • Read Query Response Time Distribution
      • Write Query Response Time Distribution
    • MySQL Replication
      • IO Thread Running
      • SQL Thread Running
      • Replication Error No
      • Read only
      • MySQL Replication Delay
      • Binlog Size
      • Binlog Data Written Hourly
      • Binlog Count
      • Binlogs Created Hourly
      • Relay Log Space
      • Relay Log Written Hourly
    • MySQL Table Statistics
      • Largest Tables
      • Pie
      • Table Activity
      • Rows read
      • Rows Changed
      • Auto Increment Usage
    • MySQL User Statistics
  • MongoDB Dashboards
    • MongoDB Cluster Summary
    • MongoDB inMemory Dashboard
    • MongoDB MMAPv1 Dashboard
    • MongoDB Overview
      • Command Operations
      • Connections
      • Cursors
      • Document Operations
      • Queued Operations
      • getLastError Write Time, getLastError Write Operations
      • Asserts
      • Memory Faults
    • MongoDB ReplSet
      • Replication Operations
      • ReplSet State
      • ReplSet Members
      • ReplSet Last Election
      • ReplSet Lag
      • Storage Engine
      • Oplog Insert Time
      • Oplog Recovery Window
      • Replication Lag
      • Elections
      • Member State Uptime
      • Max Heartbeat Time
      • Max Member Ping Time
    • MongoDB RocksDB Dashboard
    • MongoDB WiredTiger Dashboard
  • 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
  • HA Dashboards
    • PXC/Galera Cluster Overview Dashboard
• How to Contact Percona
• Glossary
• Release Notes
  • PMM 2.8.0
    • Improvements
    • Bugs Fixed
  • PMM 2.7.0
    • New Features
    • Improvements
    • Bugs Fixed
  • PMM 2.6.1
    • Improvements
    • Bugs Fixed
  • PMM 2.6.0
    • New Features
    • Improvements
    • Bugs Fixed
  • PMM 2.5.0
    • New Features
    • Improvements
    • Bugs Fixed
  • PMM 2.4.0
    • New Features
    • Improvements
    • Bugs Fixed
  • PMM 2.3.0
    • Improvements and new features
    • Fixed bugs
  • PMM 2.2.2
    • Improvements and new features
    • Fixed bugs
  • PMM 2.2.1
    • Improvements and new features
    • Fixed bugs
  • PMM 2.2.0
    • Improvements and new features
    • Fixed bugs
  • PMM 2.1.0
    • Improvements and new features
    • Fixed bugs
  • PMM 2.0.1
    • Improvements
    • Fixed bugs
  • PMM 2.0.0
• 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 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?
• Reference
  • pmm-admin - PMM Administration Tool
    • NAME
    • SYNOPSIS
    • DESCRIPTION
    • FLAGS
    • COMMANDS
      • GENERAL COMMANDS
      • INFORMATION COMMANDS
      • CONFIGURATION COMMANDS
      • DATABASE COMMANDS
        • MongoDB
        • MySQL
        • PostgreSQL
        • ProxySQL
    • EXAMPLES

Next topic

PMM Concepts