by Peter Zaitsev | Sep 11, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer...
by Diana Muina | Aug 17, 2020 | Insight for DBAs, Monitoring, Percona Software
Every software story starts with a simple idea of how to serve a specific user need. However, with the growing number of applications and ways to deploy those applications (on-premise or in the cloud or both) our environments are becoming more and more complex. But...
by Agustín | Aug 5, 2020 | Monitoring, Percona Software
In this blog post, we will take a look at how we can manually remove a client instance from Percona Monitoring and Management (PMM) version 2. Under normal operations, this shouldn’t be necessary, since a graceful PMM client uninstall shouldn’t leave any...
by Agustín | Aug 4, 2020 | Cloud, Insight for DBAs, Monitoring, Percona Software
In this blog, we are going to see how to compile a Percona Monitoring and Management 2 (PMM v2) client in ARM. For this, we are going to use an AWS EC2 ARM instance with Amazon Linux 2. Installing Dependencies First, let’s get some basic packages out of the way,...
by Dmitriy Kostiuk | Jul 23, 2020 | Cloud, MongoDB, Monitoring, MySQL, Percona Software
The content of this article is outdated. See the official Percona Operator for MongoDB and Percona XtraDB Cluster Operator documentation for more up to date information. Percona Monitoring and Management (PMM) provides an excellent solution to monitor both Percona...
by Daniel Guzmán Burgos | Jul 22, 2020 | Insight for DBAs, Monitoring, Percona Software, Security
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...
by Roman Misyurin | Jul 16, 2020 | Monitoring, Percona Software
We’ve been improving the Query Analytics component of Percona Monitoring and Management (PMM). Here’s a summary of what we’ve done, beginning with a reminder of what PMM is and what it’s for. Database Troubleshooting and PMM Troubleshooting...
by Peter Zaitsev | Jul 15, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
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...
by Steve Hoffman | Jul 7, 2020 | Insight for DBAs, Monitoring, Percona Software
Many years ago I was banned from touching anything of critical importance as far as production infrastructure goes…something about “the leadership curse”, so the multiple layers of monitoring and notifications I once wrestled with were now overkill for my needs....
by Sergey Kuzmichev | Jul 6, 2020 | Insight for DBAs, Monitoring, Percona Software
I wanted to start this post with the words “eBPF is the hot new thing”, but I think it’s already too late to write that. Running eBPF programs in production is becoming less of a peculiarity and more of a normal way to operate. Famously, Facebook runs about 40 BPF...
by Tate McDaniel | Jul 1, 2020 | Insight for DBAs, Monitoring, MySQL
One of the most common errors encountered in the MySQL world at large is the infamous Error 1040: Shell ERROR 1040 (00000): Too many connections 1 ERROR 1040 (00000): Too many connections What this means in practical terms is that a MySQL instance has reached...
by David Quilty | Jul 1, 2020 | Monitoring, Percona Software, Security, Webinars
Data breaches seem to be a daily occurrence, so much so that seeing an article about the latest company to fall victim draws little attention outside of those immediately impacted. That is of course unless that company is yours and data security is your...
by Artem Gavrilov | Jun 29, 2020 | Insight for Developers, Monitoring, Percona Software, Security
Security Threat Tool (STT) is the new Percona Monitoring and Management (PMM) feature. It provides the ability to run automated security checks across all of your databases and detect potential security problems. For example: empty or default passwords, weak security...
by Carlos Tutte | Jun 19, 2020 | Insight for DBAs, Monitoring, Percona Software
Disclaimer: This blog post is about migrating Percona Monitoring and Management 2 (PMM) data between PMM2 versions, and not for migrating data from PMM1 to PMM2. Restoring data from PMM1 to PMM2 is NOT supported since there were many architectural changes. I...
by Peter Zaitsev | Jun 17, 2020 | Monitoring, MySQL, Percona Software
The RED Method (Rate, Errors, Duration) is one of the more popular performance monitoring approaches. It is often applied to Monitoring Microservices though there is nothing that prevents it from being applied to databases like MySQL. In Percona Monitoring and...
by Carlos Salguero | Jun 10, 2020 | Monitoring, MySQL, Percona Software
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...
by Roman Misyurin | Jun 2, 2020 | Insight for Developers, Monitoring, Open Source, Percona Software
The frontend part of Percona Monitoring and Management (PMM) is a set of extensions for Grafana, and the Grafana documentation provides a basic understanding of how things work. But after I studied it, it was still difficult to understand how to approach development...
by Roma Novikov | May 19, 2020 | Insight for DBAs, Monitoring, Percona Software
As we have just released the new Security Threat Tool (STT) as part of Percona Monitoring and Management (PMM) 2.6, I wanted to give you a basic overview of this new feature. Its goal is to advise PMM users on common security-related database problems they might have...
by Terri Schlosser | May 19, 2020 | Monitoring, Percona Software
If database security is a top concern and you are looking for ways to quickly find and remediate common data security risks, you should try the newly announced Percona Monitoring and Management 2.6. This includes a new Security Threat Tool which allows you to run...
by Agustín | May 18, 2020 | Monitoring, Percona Software
Two years ago, we showed how to use a different mount point on Percona Monitoring and Management (PMM) Docker deployments, in case you need to have data stored out of the default Docker paths. We have released PMM version 2 since, and the need for these steps is still...
