Database Monitoring

Percona Consulting can help you determine the right database monitoring solution for your system and help with its deployment, while ensuring optimal performance. Percona Support includes monitoring and management tools which put Percona’s deep operational expertise in your hands to provide visibility into problems before they happen. And if you lack the resources to manage your deployment, Managed Services team can take over the full operation, administration, and monitoring of your database.

Webinar Tuesday, September 19, 2017: A Percona Support Engineer Walkthrough for pt-stalk

percona toolkit

Join Percona’s, Principal Support Engineer, Markus Albe as he presents A Percona Support Engineer Walkthrough for pt-stalk on Tuesday, September 19, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7).
Register Now

As a support engineer, I get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE INNODB […]

Read more

Percona Live Europe Featured Talks: Debugging with Logs (and Other Events) Featuring Charity Majors

Percona Live Europe 2017

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.
This blog post is with Charity Majors, CEO/Cofounder […]

Read more

Percona Live Europe Featured Talks: Monitoring Open Source Databases with Icinga with Bernd Erk

Percona Live Europe 2017

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.
This blog post is with Bernd Erk, CEO […]

Read more

Percona Live Europe Featured Talks: Visualize Your Data with Grafana Featuring Daniel Lee

Percona Live Europe 2017

Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter.
This blog post is with Daniel Lee, a […]

Read more

Massive Parallel Log Processing with ClickHouse

ClickHouse

In this blog, I’ll look at how to use ClickHouse for parallel log processing.
Percona is seen primarily for our expertise in MySQL and MongoDB (at this time), but neither is quite suitable to perform heavy analytical workloads. There is a need to analyze data sets, and a very popular task is crunching log files. Below […]

Read more

Upcoming Webinar September 14, 2017: Supercharge Your Analytics with ClickHouse

ClickHouse

Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7).
Reserve Your Spot
 
ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved […]

Read more

Updating InnoDB Table Statistics Manually

InnoDB Tables

In this post, we will discuss how to fix cardinality for InnoDB tables manually.
As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default. Instead it looks at random pages, as determined […]

Read more

Upcoming Webinar Thursday, September 7: Using PMM to Troubleshoot MySQL Performance Issues

Percona Monitoring and Management

Join Percona’s Product Manager, Michael Coburn as he presents Using Percona Monitoring and Management to Troubleshoot MySQL Performance Issues on Thursday, September 7, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7).
Reserve Your Spot
 
Successful applications often become limited by MySQL performance. Michael will show you how to get great MySQL performance using Percona […]

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