Author - Daniel Guzmán Burgos

PMM’s Custom Queries in Action: Adding a Graph for InnoDB mutex waits

PMM mutex wait graph

One of the great things about Percona Monitoring and Management (PMM) is its flexibility. An example of that is how one can go beyond the exporters to collect data. One approach to achieve that is using textfile collectors, as explained in   1.15.0, PMM provides user the ability to take a SQL SELECT statement […]

Read more

Adding Custom Graphs and Dashboards to Percona Monitoring and Management

PMM custom graphs

In this blog post, we’ll look at how to create PMM custom graphs and dashboards to track what you need to see in your database.
Percona Monitoring and Management (PMM)‘s default set of graphs is pretty complete: it covers most of the stuff a DBA requires to fully visualize database servers. However, sometimes custom information […]

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

Enabling and Disabling Jemalloc on Percona Server

MariaDB ColumnStore

This post discusses enabling and disabling jemalloc on Percona Server for MySQL.
The benefits of jemalloc versus glibc for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) you have less memory fragmentation, and thus more efficient resource management of the available server memory.
For standard installations of Percona Server 5.6+ (releases […]

Read more