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
  • 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
      • Restoring the previous version
      • Removing the backup container
    • Backing Up PMM Data from the Docker Container
    • Restoring Backed-up Information to a 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
    • 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
      • Settings
      • Metrics resolution
      • Telemetry
      • Check for updates
      • Security Threat Tool
      • SSH Key Details
      • Prometheus Alertmanager integration
      • 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
    • 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
• 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
  • Navigating across Dashboards
    • Zooming in on a single metric
• The Query Analytics Dashboard
  • 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)
      • 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
    • MySQL InnoDB Compression
      • Compression level and failure rate threshold
      • Statistics of Compression Operations
      • CPU Core Usage
      • Buffer Pool Total
      • Buffer Pool All
    • MySQL InnoDB Metrics (Advanced)
      • 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 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 MyISAM Aria Metrics
      • Aria Storage Engine
      • Aria Pagecache Reads/Writes
      • Aria Pagecache Blocks
      • Aria Transactions Log Syncs
    • MySQL MyRocks Metrics
    • 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
    • Performance Schema Wait Event Analysis
    • MySQL Performance Schema
    • 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
    • MongoDB MMAPv1
    • 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
    • MongoDB WiredTiger
  • 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
• Contact Us
  • Contacting the developers
  • Reporting bugs
  • Contributing to development
• Glossary
• Release Notes
  • 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?
• 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

What is Percona Monitoring and Management?