Tag - PMM

Nested Data Structures in ClickHouse

Nested Data Structures

In this blog post, we’ll look at nested data structures in ClickHouse and how this can be used with PMM to look at queries.
Nested structures are not common in Relational Database Management Systems. Usually, it’s just flat tables. Sometimes it would be convenient to store unstructured information in structured databases.
We are working to adapt ClickHouse as […]

Read more

Percona Monitoring and Management 1.2.2 is Now Available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.2.2 on August 23, 2017.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
This release contains bug fixes related to performance and introduces various improvements. It also contains an updated version of Grafana.

Changes in PMM Server
We introduced the following changes in PMM Server 1.2.2:

Bug fixes¶

PMM-927: The error “Cannot read property […]

Read more

Percona Monitoring and Management 1.2.1 is Now Available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.2.1 on August 16, 2017.
For install and upgrade instructions, see Deploying Percona Monitoring and Management.
This hotfix release improves memory consumption.
Changes in PMM Server
We’ve introduced the following changes in PMM Server 1.2.1:

Bug fixes

PMM-1280: PMM server affected by nGinx CVE-2017-7529. An integer overflow exploit could result in a DOS (Denial of Service) for the affected nginx […]

Read more

Saturation Metrics in PMM 1.2.0

Saturation Metrics 5 small

One of the new graphs added to Percona Monitoring and Management (PMM) is saturation metrics. This blog post explains how to use the information provided by these graphs.
You might have heard about Brendan Gregg’s USE Method  (Utilization-Saturation-Errors) as a way to analyze the performance of any system. Our goal in PMM is to support […]

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

Three Methods of Installing Percona Monitoring and Management

Installing Percona Monitoring and Management

In this blog post, we’ll look at three different methods for installing Percona Monitoring and Management (PMM).
Percona offers multiple methods of installing Percona Monitoring and Management, depending on your environment and scale. I’ll also share comments on which installation methods we’ve decided to forego for now. Let’s begin by reviewing the three supported methods:

Virtual […]

Read more

Percona Monitoring and Management 1.1.4 is Now Available

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.1.4 on May 29, 2017.
For installation instructions, see the Deployment Guide.
This release includes experimental support for MongoDB in Query Analytics, including updated QAN interface.
(more…)

Read more

What About ProxySQL and Mirroring?

ProxySQL and Mirroring

In this blog post, we’ll look at how ProxySQL and mirroring go together.
Overview
Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I want to correctly set some expectations, and avoid selling carbon […]

Read more

Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017

Percona Software and Services

This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017).
A full recording of this webinar, along with the presentation slide deck, can be found here.
Percona Software
Below are the latest and […]

Read more