by Matthew Boehm | Nov 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
So you’ve just added some more memory to your MySQL server; now what? If you’ve been around the MySQL block for a while, you know that nothing is automatically changed to take advantage of this new system RAM. Let’s have a look at a few parameters...
by Peter Zaitsev | Nov 2, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings. Early in MySQL...
by Paul Jacobs | Oct 26, 2020 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Percona is making changes in its documentation processes for Percona Monitoring and Management (PMM) to make it easier and more welcoming for community members to contribute to our documentation. Percona Monitoring and Management (PMM) is a free, open-source database...
by Steve Hoffman | Oct 22, 2020 | Insight for DBAs, Monitoring, Percona Software
About the Author – This blog was written as a collaboration with my colleague Jiri Ctvrtka. Jiri is a senior software developer from Brno, Czech Republic, and has been partnering with Percona for almost a year working on various components of our Percona...
by Mike Grayson | Oct 19, 2020 | Insight for DBAs, Insight for Developers, MongoDB, Monitoring, Percona Software
Percona Monitoring and Management (PMM) is an open-source tool developed by Percona that allows you to monitor and manage your MongoDB, MySQL, and PostgreSQL databases. This blog will give you an overview of troubleshooting your MongoDB deployments with PMM. Let’s...
by Peter Zaitsev | Oct 14, 2020 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
I am very passionate about database observability, and I believe query performance observability is the most important insight you can get in your database. Why? Because if you look from an application developer’s point of view, once a database is provisioned and you...
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...
by Rituja Borse | Oct 8, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is a free and open source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL databases. In this blog, we will look at troubleshooting MySQL issues and performance bottlenecks with the help of PMM. We can start...
by Nicola Lamacchia | Sep 29, 2020 | Insight for Developers, Monitoring, Percona Software, Security
With version 2.9.1 of Percona Monitoring and Management (PMM) we delivered some new improvements to its Security Threat Tool (STT). Aside from an updated user interface, you now have the ability to run STT checks manually at any time, instead of waiting for the normal...
by Peter Zaitsev | Sep 28, 2020 | Monitoring, Percona Software
Percona Monitoring and Management 2.10 shipped a few days ago and while it is a minor release, it introduces some features which I absolutely love. In this blog post, I will talk about those features – what they are and why they are worth loving. 🙂 1. Query...
by Rituja Borse | Sep 23, 2020 | Insight for DBAs, Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL databases, along with Load Balancing tools like ProxySQL. It is also ‘cloud ready’, meaning it has support for monitoring DBaaS...
by Carlos Salguero | Sep 22, 2020 | MongoDB, Monitoring, Percona Software
by Avinash Vallarapu | Sep 22, 2020 | Monitoring, Percona Software, PostgreSQL, Security
I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The pg_monitor role restricts a monitoring user...
by Roman Misyurin | Sep 16, 2020 | Monitoring, Percona Software
As you may know, Percona Monitoring and Management (PMM) is based on Grafana, and all our frontend applications are either Grafana plugins or dashboards. We’ve just released PMM version 2.10 and it includes a lot of improvements and new functionality. In this...
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 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 Rick Golba | Jul 16, 2020 | Monitoring, Percona Announcements, Percona Software
Effective August 1, 2020, Percona is moving the Percona Monitoring Plugins to end of life status. This means that no new versions, enhancements, bug fixes, or security updates will be released. The software will continue to be available at our download site. The...
