Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Recently, I encountered a Percona Monitoring and Management (PMM) server that was rapidly approaching complete disk exhaustion. This post outlines the steps taken to identify the issue and reclaim disk…
The post How to Resolve Disk Space Issues in PMM: Case Study first appeared on Change Is Inevitable.
This will be the third in my series of Percona Products on a Raspberry Pi. My previous posts:
Before I get started I would like to thank guriandoro, for the work he did in compiling the PMM Client tools in his 2021 blog.
My regular readers know how much I love the Raspberry Pi and
MySQL. I have several hobby projects that collect data, and MySQL
on Pi is great
solution!
I recently decided that I …
[Read more]As businesses grow and develop, the requirements that they have for their data platform grow along with it. As such, one of the more common questions I get from my clients is whether or not their system will be able to endure an anticipated load increase. Or worse yet, sometimes I get questions about regaining normal operations after a traffic increase caused performance destabilization.
As the subject of this blog post suggests, this all comes down to proper capacity planning. Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance. But we can discuss common bottlenecks, how to assess them, and have a better understanding as to why proactive monitoring is so important when it comes to responding to traffic growth.
Hardware considerations
The first thing we have to consider …
[Read more]2022 was an exciting year for Percona Monitoring and Management (PMM). We’ve added and improved many features, including Alerting and Backup Management. These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.
PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. Percona’s co-Founder Peter Zaitsev wrote a detailed post about migration from Prometheus to VictoriaMetrics, One of the most significant differences in …
[Read more]Percona Monitoring and Management (PMM) is an open source database monitoring, observability, and management tool that can be used for monitoring the health of your database infrastructure, exploring new patterns in database behavior, and managing and improving the performance of your databases no matter where they are located or deployed.
PMM is designed to work with MySQL (including Percona Server for MySQL, Percona XtraDB Cluster, Oracle MySQL Community Edition, Oracle MySQL Enterprise Edition, and MariaDB), PostgreSQL (including Percona Distribution for PostgreSQL), MongoDB (including Percona Server for MongoDB), Amazon RDS, Amazon Aurora, Proxy SQL, and Percona XtraDB Cluster.
Debian, Ubuntu, and Red Hat (AlmaLinux, Oracle Linux or Rocky Linux may also work) are supported. If you try installing on another …
[Read more]I started at Percona a few weeks ago and was looking for a quick way to learn about PMM (Percona Monitoring and Management), which is one of my favorite technologies within Percona to monitor the health of our database infrastructure, explore new patterns in the database behavior, manage and improve the performance of our databases, all with customizable dashboards and real-time alerts using Grafana and VictoriaMetrics.
The best of all is that PMM is Open Source, you can check the PMM repository in case you want to contribute.
There are many flavors for PMM installation, here I will describe the steps to install PMM on Ubuntu 20.04, using Docker for PMM Server on an Amazon EC2 instance.
This image summarizes our goal.
Requirements
In this blog, I will demonstrate how to use Percona Monitoring and Management (PMM) to find out the reason why the MySQL server is stalling. I will use only one typical situation for the MySQL server stall in this example, but the same dashboards, graphs, and principles will help you in all other cases.
Nobody wants it but database servers may stop handling connections at some point. As a result, the application will slow down and then will stop responding.
It is always better to know about the stall from a monitoring instrument rather than from your own customers.
PMM is a great help in this case. If you look at its graphs and notice that many of them started showing unusual behavior, you need to react. In the case of stalls, you will see that either some activity went to 0 or, otherwise, it increased to high …
[Read more]
Percona Monitoring and Management tool (PMM) is an Open Source product which was
developed to help DBAs and developers to monitor and manage
MySQL, PostgreSQL and MongoDB performances. In this blog post, we
will see that we can do much more with it!
I discovered this tool 2 years ago when I started a monitoring
study for a customer, and ever since, I’ve been in love with it.
I will explain you why.
It’s Open Source! Even if money is not everything…
PMM is completely Open Source, and this is not surprising coming
from Percona. But as we know, the advantage of Open
Source is not only the fact of being free…
Let’s …
[Read more]In the previous posts of this series, I presented how the Percona Support team approaches the analysis and troubleshooting of a MySQL server using a tried-and-tested method supported by specific tools found in the Percona Toolkit:
Inspecting MySQL Servers Part 1: The Percona Support Way
Inspecting MySQL Servers Part 2: Knowing the Server
Inspecting MySQL Servers Part 3: What MySQL?
Inspecting MySQL Servers Part 4: An Engine in …
[Read more]Visibility is a blessing, and with databases, visibility is a must. That’s true not only for metrics but for the queries themselves. Having info on all the stats around query execution is priceless, and Percona Monitoring and Management (PMM) offers that in the form of the Query Analytics dashboard (QAN).
But where to start? QAN helps you with that by calculating the query profile. What is the profile? It’s a rank of queries, ordered by Load, so it is easy to spot the heaviest queries hitting your database. The Load is defined as the “Average Active Queries” but can also be defined as a mix of Query Execution Time Plus Query count. In other words, all the time the query was alive and kicking.
The Profile in PMM 2.10.0 looks like this:
The purpose of this profile is to facilitate the task of finding the …
[Read more]