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 Andrii Skomorokhov | Apr 13, 2020 | Monitoring, Percona Software
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...
by Alexey Palazhchenko | Mar 23, 2020 | Monitoring, Percona Software
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,...
by Alexey Palazhchenko | Mar 12, 2020 | Monitoring, Percona Software
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,...
by Terri Schlosser | Feb 26, 2020 | Monitoring, Percona Software
As a new member of the Percona team, one of the first things I was interested in understanding was our software adoption. I decided to take a look at the information we have about adoption (instances running) of Percona Monitoring and Management (PMM) and found some...
by Peter Zaitsev | Jan 20, 2020 | Monitoring, MySQL, Percona Software
If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table. You might assume these hashes are stable between different versions, so, for example,...
by Peter Zaitsev | Jan 15, 2020 | Monitoring, Percona Software
April 2021 Update: From Percona Monitoring and Management 2.27, the procedure is now simplified and it is possible by running: docker exec pmm-server change-admin-password <new_password> 1 docker exec pmm-server change-admin-password <new_password> ...
by Vinicius Grippa | Jan 8, 2020 | Monitoring, MySQL
Percona Monitoring and Management (PMM) has been on the road for a while now, and it brings exciting new features and improvements. For those who are not familiar with the tool, PMM allows deep insight into the performance of applications and databases. The most...
by Daniel Guzmán Burgos | Dec 19, 2019 | Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is built upon the shoulder of giants like Prometheus and Grafana. And speaking of Grafana, one of the coolest features that come with it is the ability to customize the experience through 3rd party plugins. Plugins are an easy...
by Vadim Yalovets | Nov 27, 2019 | Monitoring, Percona Services, Percona Software
Want to try out Percona Monitoring and Management 2 (PMM 2) but you’re not ready to turn off your PMM 1 environment? This blog is for you! Keep in mind that the methods described are not intended to be a long-term migration strategy, but rather, simply a way to...
by Peter Zaitsev | Nov 22, 2019 | Monitoring, MySQL, Percona Software
As Grafana powers our star product – Percona Monitoring and Management (PMM) – we have developed a lot of experience creating Grafana Dashboards over the last few years. In this article, I will share some of the considerations for designing Grafana...
by Avinash Vallarapu | Oct 29, 2019 | Percona Software, PostgreSQL
PostgreSQL is a widely-used Open Source database and has been the DBMS of the year for the past 2 years in DB-Engine rankings. As such, there is always a need for reliable and robust monitoring solutions. While there are some commercial monitoring tools, there is an...
by Ceri Williams | Oct 22, 2019 | Monitoring, Percona Software
In this article, we will take a look at how to run Percona Monitoring and Management (PMM) Server in a container without root privileges. Some of the concerns companies have about using Docker relate to the security risks that exist due to the requirement for root...
by Rachel Pescador | Oct 14, 2019 | Monitoring, Percona Software, Webinars
How can you ensure you are properly managing and optimizing the performance of your database environment? Join Percona’s Product Manager Michael Coburn as he presents “What’s New in Percona Monitoring and Management 2?” and walks you through practical...
by Peter Zaitsev | Sep 25, 2019 | Monitoring, Percona Software
As the saying goes, a picture is worth 1000 words – and this is why we don’t just talk about Percona Monitoring and Management (PMM) but also have a demo which allows you to explore many PMM features without having to install it. Though there is only so...
by Stephen Thorn | Sep 9, 2019 | Monitoring, MySQL, Percona Software, Storage Engine
One of the great things about working at Percona is the constant innovation that occurs as a result of a deep level of technical expertise. A more recent conversation about the Information Schema table: here. The README.md has installation instructions. Download the...
by Stephen Thorn | Aug 30, 2019 | Monitoring, Percona Software, PostgreSQL
As a Solutions Engineer at Percona, one of my responsibilities is to support our customer-facing roles such as the sales and customer success teams. This affords me the opportunity to speak to many current and new customers who partner with Percona. I often find that...
by Peter Zaitsev | Aug 21, 2019 | Cloud, Percona Software
While testing our PMM2 Beta and other Dockerized applications, you may want to clean up your docker install and start from scratch. If you’re not very familiar with Docker it may not be that trivial. This post focuses on cleaning up everything in docker so you can...
by Stephen Thorn | Jul 23, 2019 | MongoDB, Monitoring, Percona Software
As a Solutions Engineer at Percona, one of my responsibilities is to support our customer-facing roles such as the sales and customer success teams, which affords me the opportunity to speak to many current and new customers who partner with Percona. I often find that...
by Daniel Guzmán Burgos | Mar 12, 2019 | Insight for DBAs, MySQL, Percona Software