Buy Percona ServicesBuy Now!

Percona Monitoring and Management 1.13.0 Is Now Available

 | August 1, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM

PREVIOUS POST
NEXT POST

Percona Monitoring and ManagementPMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM 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.

The most significant feature in this release is Prometheus 2, however we also packed a lot of visual changes into release 1.13:

  • Prometheus 2 – Consumes less resources, and Dashboards load faster!
  • New Dashboard: Network Overview – New dashboard for all things IPv4!
  • New Dashboard: NUMA Overview – New Dashboard! Understand memory allocation across DIMMs
  • Snapshots and Updates Improvements – Clearer instructions for snapshot sharing, add ability to disable update reporting
  • System Overview Dashboard improvements – See high level summary, plus drill in on CPU, Memory, Disk, and Network
  • Improved SingleStat for percentages – Trend line now reflects percentage value

We addressed 13 new features and improvements, and fixed 13 bugs.

Prometheus 2

The long awaited Prometheus 2 release is here!  By upgrading to PMM release 1.13, Percona’s internal testing has shown you will achieve a 3x-10x reduction in CPU usage, which translates into PMM Server being able to handle more instances than you could in 1.12.  You won’t see any gaps in graphs since internally PMM Server will run two instances of Prometheus and leverage remote_read in order to provide consistent graphs!

Our Engineering teams have worked very hard to make this upgrade as transparent as possible – hats off to them for their efforts!!

Lastly on Prometheus 2, we also included a new set of graphs to the Prometheus Dashboard to help you better understand when your PMM Server may run out of space. We hope you find this useful!

Network Overview Dashboard

We’re introducing a new dashboard that focuses on all things Networking – we placed a Last Hour panel highlighting high-level network metrics, and then drill into Network Traffic + Details, then focus on TCP, UDP, and ICMP behavior.

Snapshots and Updates Improvements

Of most interest to current Percona Customers, we’ve clarified the instructions on how to take a snapshot of a Dashboard in order to highlight that you are securely sharing with Percona. We’ve also configured the sharing timeout to 30 seconds (up from 4 seconds) so that we more reliably share useful data to Percona Support Engineers, as shorter timeout led to incomplete graphs being shared.

Packed into this feature is also a change to how we report installed version, latest version, and what’s new information:

Lastly, we modified the behavior of the docker environment option DISABLE_UPDATES to remove the Update button.  As a reminder, you can choose to disable update reporting for environments where you want tighter control over (i.e. lock down) who can initiate an update by launching the PMM docker container along with the environment variable as follows:

System Overview Dashboard Improvements

We’ve updated our System Overview Dashboard to focus on the four criteria of CPU, Memory, Disk, and Network, while also presenting a single panel row of high level information (uptime, count of CPUs, load average, etc)

Our last feature we’re introducing in 1.13 is a fix to SingleStat panels where the percentage value is reflected in the level of the trend line in the background.  For example, if you have a stat panel at 20% and 86%, the line in the background should fill the respective amount of the box:Improved SingleStat for percentages

New Features & Improvements

  • PMM-2225 – Add new Dashboard: Network Overview
  • PMM-2485 – Improve Singlestat for percentage values to accurately display trend line
  • PMM-2550 – Update to Prometheus 2
  • PMM-1667 – New Dashboard: NUMA Overview
  • PMM-1930 – Reduce Durability for MySQL
  • PMM-2291 – Add Prometheus Disk Space Utilization Information
  • PMM-2444 – Increase space for legends
  • PMM-2594 – Upgrade to Percona Toolkit 3.0.10
  • PMM-2610 – Configure Snapshot Timeout Default Higher and Update Instructions
  • PMM-2637 – Check for Updates and Disable Updates Improvements
  • PMM-2652 – Fix “Unexpected error” on Home dashboard after upgrade
  • PMM-2661 – Data resolution on Dashboards became 15sec min instead of 1sec
  • PMM-2663 – System Overview Dashboard Improvements

Bug Fixes

  • PMM-1977 – after upgrade pmm-client (1.6.1-1) can’t start mysql:metrics – can’t find .my.cnf
  • PMM-2379 – Invert colours for Memory Available graph
  • PMM-2413 – Charts on MySQL InnoDB metrics are not fully displayed
  • PMM-2427 – Information loss in CPU Graph with Grafana 5 upgrade
  • PMM-2476 – AWS PMM is broken on C5/M5 instances
  • PMM-2576 – Error in logs for MySQL 8 instance on CentOS
  • PMM-2612 – Wrong information in PMM Scrapes Task
  • PMM-2639 – mysql:metrics does not work on Ubuntu 18.04
  • PMM-2643 – Socket detection and MySQL 8
  • PMM-2698 – Misleading Graphs for Rare Events
  • PMM-2701 – MySQL 8 – Innodb Checkpoint Age
  • PMM-2722 – Memory auto-configuration for Prometheus evaluates to minimum of 128MB in entrypoint.sh

How to get PMM Server

PMM is available for installation using three methods:

PREVIOUS POST
NEXT POST
Michael Coburn

Michael joined Percona as a Consultant in 2012 after having worked with high volume stock photography websites and email service provider platforms. With a foundation in Systems Administration, Michael is now the Product Manager responsible for Percona Monitoring and Management (PMM), Percona XtraBackup, and Percona Toolkit. A Canadian, Michael currently lives in México with his family.

8 Comments

    • Hi Fernando,

      Yes it is safe! No data is migrated, so in fact there is no data loss possible, except for the time when you have the binaries stopping and starting back up. 🙂 If you want to hold off upgrading until you hear from others’ experiences, please feel free to follow and contribute on the Percona Forums for PMM: https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management

  • Hi Fernando,

    Yes it is safe! No data is migrated, so in fact there is no data loss possible, except for the time when you have the binaries stopping and starting back up. 🙂 If you want to hold off upgrading until you hear from others’ experiences, please feel free to follow and contribute on the Percona Forums for PMM: https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management

  • Do you guys think you’ll ever add backup scheduling and point in time recovery functionality to PMM? That would be amazing. I seriously think you’d get a crazy amount of adoption.

  • Hi, thanks for the new cool features.

    But my Numa Dashboard is empty.

    Any ideas how to fill it with data? I have also updated the pmm-client.

    Greetings
    Andre

    • Hi Andre thanks for the post. Could I possibly persuade you to enter a post on the community forum please? I’ll let the team know, but the forum is where they mostly deal with tech questions. www.percona.com/forums

  • Hi,are you have a plan to add Redis monitor to PMM?In Production we use mongoDB、Percona、redis,PMM is great to
    monitor metrics。But how to integate the Redis monitor into PMM? could you give an example? and how to monitor Group replication(MySQL and Percona)by PMM?Thanks.

    • You can monitor external services by leveraging PMM’s External Exporters support.
      Here’s how Nickolay provides an example using PostgreSQL: https://www.percona.com/blog/2018/02/09/collect-postgresql-metrics-with-percona-monitoring-and-management-pmm/

      We haven’t yet made an effort to include InnoDB Group Replication into mysqld_exporter, but we’d welcome PRs!
      https://github.com/percona/mysqld_exporter/

Leave a Reply