by Michael Patrick | Jul 8, 2020 | Monitoring, MySQL, Open Source
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 Przemysław Malkowski | Jun 29, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option. Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona...
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 Daniil Bazhenov | Jun 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona engineers often need to analyze and review complex SQL database queries. Good formatting can make these SQL queries much easier to understand and work with. Without clear formatting, queries can become confusing and hard to debug. Online query formatting...
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...
by Uday Varagani | Apr 24, 2020 | Insight for DBAs, Monitoring, MySQL
A couple of weeks ago, one of our customers reached us asking about the WARNING messages in their MySQL error log. After a while, there were a few more requests from some other customers asking whether to worry about these messages or not. In this post, I am going to...
by Lalit Choudhary | Apr 17, 2020 | MongoDB, Monitoring, Percona Software
Percona provides the mongodb_exporter for monitoring MongoDB. It can feed a Prometheus time-series database by exporting sharding, replication, and storage engine metrics. So basically, it’s the way we monitor MongoDB through Percona Monitoring and Management....
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 Steve Hoffman | Apr 7, 2020 | Monitoring, Percona Software
Last month, our new Director of Product wrote a blog about all the cool things she learned about how we track Percona Monitoring and Management (PMM) adoption and even went into what conclusions we can draw from that. As you can imagine, I was excited she geeked out...
by Brian Sumpter | Apr 1, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I...
by Peter Zaitsev | Mar 30, 2020 | Monitoring, MySQL, Percona Software
In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries to ClickHouse for advanced query analysis tasks. In the followup Webinar Q&A, I promised to describe it in more detail and share some...
![[Warning] InnoDB: Difficult to Find Free Blocks in the Buffer Pool](https://www.percona.com/blog/wp-content/uploads/2020/04/InnoDB-Buffer-Pool.png)
