by Vadim Yalovets | Aug 23, 2021 | Insight for DBAs, Insight for Developers, Percona Events, Percona Software
The engineering marvel that is Percona Monitoring and Management (PMM), has to be, for me, one of the best examples out there of how a large number of vastly different community projects can successfully combine into something whose value and features far exceeds the... by Vadim Yalovets | Jul 6, 2021 | Insight for Developers, Monitoring, Percona Software
Percona Monitoring and Management (PMM2) Server runs as a Docker container, a Virtual appliance, or as an instance on Amazon or Azure cloud services. Here I’ll show how to move the PMM Server and its data from one type to another.Note, this is only for PMM2 to... by Vadim Yalovets | Apr 16, 2021 | Cloud, Monitoring, Open Source, Percona Software
The Microsoft Azure SQL Database is among the most popular databases of 2020, according to DB-Engine’s DBMS of the Year award. Also, it’s steadily climbing up in DB-Engines Ranking. The ranking is updated monthly and places database management systems... by Vadim Yalovets | Mar 30, 2021 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
In this blog post, I’ll look at how to import custom dashboards into Percona Monitoring and Management (PMM) 2.x, and give some tips on how to automate it.The number of dashboards in PMM2 is constantly growing. For example, we recently added a new HAProxy... by Vadim Yalovets | Jan 29, 2021 | Insight for DBAs, Monitoring, Percona Software
In Percona Monitoring and Management 2.12.0 (PMM), we replaced Prometheus with VictoriaMetrics. Metrics data can now be ‘pushed’ to the server as well as being ‘pulled’ by the server.This is useful if you want to keep open ports to a minimum or... by Vadim Yalovets | Oct 12, 2020 | Insight for DBAs, Monitoring, Percona Software
From time to time we are asked how to limit users to viewing only some dashboards or servers in Percona Monitoring and Management (PMM). Here are some hints on how to do this.Let’s imagine you want the following: Users user1 and user2 are only allowed to see the... by Vadim Yalovets | Mar 12, 2020 | Monitoring, Percona Software, PostgreSQL
This blog post is about how you can gain detailed information in Percona Monitoring and Management (PMM2) of PostgreSQL disk usage. We take a look at using a catalog called pg_class, which catalogs tables and most everything else that has columns or is otherwise... 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... by Vadim Yalovets | Apr 23, 2019 | Percona Software, PostgreSQL
Following on the heels of our PostgreSQL Tuples Statistics Dashboard, here’s another blog post describing how you can gain additional visibility of PostgreSQL queries using PMM. We take a look at using an extension called pg_stat_statements. This allows us to... by Vadim Yalovets | Apr 8, 2019 | Percona Software, PostgreSQL
While the PMM Engineering team is working on the polish for release of PMM 2, I wanted to share with you some of the dashboard improvements we’re making around PostgreSQL, specifically how you can plot Tuple Statistics using PMM. PMM (Percona Monitoring and... by Vadim Yalovets | Jan 31, 2019 | MariaDB, MongoDB, MySQL, Percona Software
While the PMM team works hard on our PMM 2.0 release, we have been working on a few things in the background which we’d like to show off ! In particular we have developed a new dashboard that displays metrics related to memory usage on Linux systems.... by Vadim Yalovets | Aug 28, 2018 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Software
Percona Monitoring and Management (PMM) provides an excellent solution for system monitoring. Sometimes, though, you’ll have the need for a metric that’s not present in the list of node_exporter metrics out of the box. In this post, we introduce a...