Percona Monitoring and Management 1.1.2 is Now Available

Percona announces the release of Percona Monitoring and Management 1.1.2 on April 3, 2017.

For installation instructions, see the Deployment Guide.

This release includes several new dashboards in Metrics Monitor, updated versions of software components used in PMM Server, and a number of small bug fixes.

Thank You to the Community!

We would like to mention some of the key contributors in this release, and thank the community for continued support of PMM:

• tcaxias for fixing our Docker deployment so that supervisor is PID 1
• pschultz who helped us improve the Disk Performance and Percona XtraDB Cluster graphs to better leverage Grafana tooltips
• Andrii Skomorokhov from Percona for fixing the Grafana tooltip bug #7708
• Tim Vaillancourt from Percona for a number of improvements to mongodb_exporter

New Dashboards and Graphs

This release includes the following new dashboards:

• MongoDB MMAPv1 dashboard provides insight for the MMAPv1 storage engine:

• MongoDB InMemory dashboard includes graphs related to the InMemory storage engine:

• MariaDB dashboard includes three new graphs for the Aria storage engine. There will be a detailed blog post about monitoring possibilities with these new graphs:

The new MariaDB dashboard also includes three new graphs for monitoring InnoDB within MariaDB. We are planning to move them into one of the existing InnoDB dashboards in the next PMM release:

• The InnoDB Defragmentation graph shows how OPTIMIZE TABLE impacts defragmentation on tables when running MariaDB with innodb_file_per_table=1 and innodb_defragment=1.

• The InnoDB Online DDL graph includes metrics related to online DDL operations when using ALTER TABLE ... ALGORITHM=INPLACE in MariaDB.

• The InnoDB Deadlocks Detected graph currently works only with MariaDB 10.1. We are planning to add support for MariaDB 10.2, Percona Server, and MySQL in the next PMM release.

• The Index Condition Pushdown graph shows how InnoDB leverages the Index Condition Pushdown (ICP) routines. Currently this graph works only with MariaDB, but we are planning to add support for Percona Server and MySQL in the next PMM release.

Updated Software

PMM is based on several third-party open-source software components. We ensure that PMM includes the latest versions of these components in every release, making it the most secure, stable and feature-rich database monitoring platform possible. Here are some highlights of changes in the latest releases:

• Grafana 4.2 (from 4.1.1)
  • HipChat integration
  • Templating improvements
  • Alerting enhancements
• Consul 0.7.5 (from 0.7.3)
  • Bug fix for serious server panic
• Prometheus 1.5.2 (from 1.5.1)
  • Prometheus binaries are built with Go1.7.5
  • Fixed two panic conditions and one series corruption bug
• Orchestrator 2.0.3 (from 2.0.1)
  • GTID improvements
  • Logging enhancements
  • Improved timing resolution and faster discoveries

Other Changes in PMM Server

• Migrated the PMM Server docker container to use CentOS 7 as the base operating system.
• Changed the entry point so that supervisor is PID 1.
• PMM-633: Set the following default values in my.cnf:
  
  [mysqld] # Default MySQL Settings innodb_buffer_pool_size=128M innodb_log_file_size=5M innodb_flush_log_at_trx_commit=1 innodb_file_per_table=1 innodb_flush_method=O_DIRECT # Disable Query Cache by default query_cache_size=0 query_cache_type=0

  1 2 3 4 5 6 7 8 9 10 11 12

  [mysqld]   # Default MySQL Settings innodb_buffer_pool_size=128M innodb_log_file_size=5M innodb_flush_log_at_trx_commit=1 innodb_file_per_table=1 innodb_flush_method=O_DIRECT   # Disable Query Cache by default query_cache_size=0 query_cache_type=0

• PMM-676: Added descriptions for graphs in Disk Performance and Galera dashboards.

Changes in PMM Client

• Fixed pmm-admin remove --all to clear all saved credentials.
• Several fixes to mongodb_exporter including PMM-629 and PMM-642.
• PMM-504: Added ability to change the name of a client with running services:
  $ sudo pmm-admin config --client-name new_name --force

  1	$ sudo pmm-admin config --client-name new_name --force

  WARNING: Some Metrics Monitor data may be lost when renaming a running client.

About Percona Monitoring and Management

Percona Monitoring and Management is an open-source platform for managing and monitoring MySQL and MongoDB performance. Percona developed it in collaboration with experts in the field of managed database services, support and consulting.

PMM is a free and open-source solution that you can run in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible.

A live demo of PMM is available at pmmdemo.percona.com.

Please provide your feedback and questions on the PMM forum.

About the Author

Alexey Zhebel
Alexey works for Percona as a Technical Writer responsible for open source software documentation. He joined the company in March 2015 with almost 8 years of prior experience in writing and managing technical documentation. Before joining Percona, Alexey worked for Oracle on Java SE and Java ME documentation. And before that his writing experience revolved around virtualization and information security software. Alexey has a degree in Electrical Engineering and a supplementary qualification in translation theory (Russian-English). He lives in Saint Petersburg, Russia with his wife and son. He spends his free time practicing and playing ultimate frisbee in a local team.