Tag - PMM

Percona Audit Log Plugin and the Percona Monitoring and Management Security Threat Tool

Percona Audit Log Plugin

The Security Threat Tool has been available since Percona Monitoring and Management 2.6.0 (PMM) and starting from that first release it is proving to be a severely-needed feature. If you’re not familiar with the Security Threat Tool (STT), it helps you to ensure compliance as you have the ability to run checks daily, get […]

Read more

MySQL Query Performance Troubleshooting: Resource-Based Approach

MySQL Query Performance Troubleshooting

When I speak about MySQL performance troubleshooting (or frankly any other database), I tend to speak about four primary resources which typically end up being a bottleneck and limiting system performance: CPU, Memory, Disk, and Network.
It would be great if when seeing what resource is a bottleneck, we could also easily see what queries […]

Read more

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