Prometheus

Scaling Percona Monitoring and Management (PMM)

PMM tested with 1000 nodes

Starting with PMM 1.13,  PMM uses Prometheus 2 for metrics storage, which tends to be heaviest resource consumer of CPU and RAM.  With Prometheus 2 Performance Improvements, PMM can scale to more than 1000 monitored nodes per instance in default configuration. In this blog post we will look into PMM scaling and capacity planning—how […]

Read more

Prometheus 2 Times Series Storage Performance Analyses

cpu saturation and max core usage

Prometheus 2 time series database (TSDB) is an amazing piece of engineering, offering a dramatic improvement compared to “v2” storage in Prometheus 1 in terms of ingest performance, query performance and resource use efficiency. As we’ve been adopting Prometheus 2 in Percona Monitoring and Management (PMM), I had a chance to look into the […]

Read more

Monitoring S.M.A.R.T. Metrics with Prometheus and PMM

visualized using Grafana

In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM)
A quick search led me to the  text_collector plugin SmartMon, which can be easily integrated with any Prometheus Installation
For PMM, Vadim Yalovets recently showed how […]

Read more

This Week in Data with Colin Charles 45: OSCON and Percona Live Europe 2018 Call for Papers

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Hello again after the hiatus last week. I’m en route to Portland for OSCON, and am very excited as it is the conference’s 20th anniversary! I hope to see some of you at my talk on […]

Read more

Percona Monitoring and Management: Look After Your pmm-data Container

looking after pmm-datamcontainers

If you have already deployed PMM server using Docker you might be aware that we begin by creating a special container for persistent PMM data. In this post, I aim to explain the importance of pmm-data container when you deploy PMM server with Docker. By the end of this post, you will have a […]

Read more

Understand Your Prometheus Exporters with Percona Monitoring and Management (PMM)

Prometheus Exporters 2 small

In this blog post, I will look at the new dashboards in Percona Monitoring and Management (PMM) for Prometheus exporters.
Percona Monitoring and Management (PMM) uses Prometheus exporters to capture metrics data from the system it monitors. Those Prometheus exporters are an important part of your monitoring infrastructure, and understanding their performance and other operational […]

Read more

Using Prometheus to Check for auto_increment Value Exhaustion

auto_increment Value Exhaustion small

In this blog post, we’ll look at how to use Prometheus to check for auto_increment value exhaustion.
One of the proactive tasks DBAs perform is checking if a field defined as auto_increment is about to reach the maximum allowed value of the int definition. For example, if a field is defined as smallint unsigned and […]

Read more

This Week in Data with Colin Charles #3: More Percona Live Europe!

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
We are five weeks out to the conference! The tutorials and the sessions have been released, and there’s an added bonus – you can now look at all this in a grid view: tutorials, day […]

Read more

Percona Monitoring and Management 1.2.0 is Now Available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017.
For installation instructions, see the Deployment Guide.

Changes in PMM Server
PMM Server 1.2.0 introduced the following changes:

Updated Components

Consul 0.8.5
Grafana 4.3.2
Orchestrator 2.1.5
Prometheus 1.7.1

New Features

PMM-737: New graphs in System Overview dashboard:

Memory Advanced Details
Saturation Metrics

PMM-1090: Added ESXi support for PMM Server virtual appliance.

UI Fixes

PMM-707: Fixed QPS metric in MySQL Overview dashboard to always show queries […]

Read more

Percona Monitoring and Management 1.1.5 is Now Available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.1.5 on June 21, 2017.
For installation instructions, see the Deployment Guide.

Changes in PMM Server

PMM-667: Fixed the Latency graph in the ProxySQL Overview dashboard to plot microsecond values instead of milliseconds.

PMM-800: Fixed the InnoDB Page Splits graph in the MySQL InnoDB Metrics Advanced dashboard to show correct page […]

Read more