Tag - PMM

Extending Percona Monitoring and Management for MySQL InnoDB Cluster with Custom Queries

pmm innodb custom queries

A few days ago, a customer got in touch asking how they could use Percona Monitoring and Management (PMM) to monitor the roles played by each node in an InnoDB cluster. More specifically, they wanted to check when one of the nodes changed its role from Primary to Secondary, or vice-versa. PMM allows for […]

Read more

Running Custom MySQL Queries in Percona Monitoring and Management

custom mysql queries

Even though Percona Monitoring and Management 2 (PMM) comes with a lot of dashboards and metrics out of the box, sometimes we need to extend the default metrics by running custom MySQL queries.
For example, suppose you want to have information about cached indexes from Innodb tables from innodb_cached_indexes table. That metric is not being […]

Read more

Optimizing Django ORM Queries with Percona Monitoring and Management

Optimizing Django ORM Queries

Django is a fantastic tool to quickly create an admin dashboard for managing entities.  But the magic of brevity oftentimes comes at the expense of suboptimal performance. The Django ORM is a coin with two sides.  It simplifies work with complex datasets and makes it easy and more intuitive to create queries. Unfortunately, it […]

Read more

Extending PMM’s Prometheus Configuration

Extending PMM Prometheus Configuration

Percona Monitoring and Management 2.4.0 (PMM), released several days ago, added support for custom extensions of the Prometheus configuration file. Before explaining what that is and how to use it, let me tell you a bit of history.
PMM 1.4.0, released 2.5 years ago, added support for hooking external Prometheus exporters into PMM’s Prometheus configuration […]

Read more

Percona Monitoring and Management Container, Are You Ready Yet?

Percona Monitoring Management Container

My boss asked me if there is a way to wait for the Percona Monitoring and Management (PMM) Server container to be fully ready so his automation script can start adding monitoring instances. I wanted to give him a general solution, not a PMM-specific one. Turned out, it is not so simple.
The root of […]

Read more