by Yura Sorokin | Apr 15, 2025 | Insight for DBAs, MySQL, Percona Software
In Percona Server for MySQL 8.0.41 / 8.4.4, we significantly re-designed the Data Masking Component. In particular, we made the following changes: Changed the user on behalf of whom we execute internal queries for dictionary operations. Introduced an in-memory...
by Yura Sorokin | Apr 9, 2025 | MySQL, Percona Software, Security
In Percona Server for MySQL 8.0.41 / 8.4.4, we introduced several improvements in Encryption User-Defined Functions. Added support for RSAES-OAEP (OAEP) padding for RSA encrypt / decrypt operations. Added support for RSASSA-PSS (PSS) padding for RSA sign / verify...
by David Quilty | Apr 2, 2025 | Insight for DBAs, MariaDB, MySQL
This post was originally published in May 2024 and was updated in April 2025. MySQL and MariaDB are two major open source database management systems that share a common codebase and history. MariaDB started as a MySQL fork in 2009 to provide an alternate database...
by Satya Bodapati | Mar 24, 2025 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
When performing backups, reducing the amount of time your server is locked can significantly improve performance and minimize disruptions. Percona XtraBackup 8.4 Pro introduces improvements in how DDL (Data Definition Language) locks (aka Backup Locks) are managed,...
by David Quilty | Mar 19, 2025 | Insight for DBAs, MySQL
MySQL databases serve as the foundation of countless applications, powering everything from simple blogs to massive enterprise platforms. But as these applications evolve and user bases expand, MySQL performance issues tend to pop up and ensuring smooth database...
by Dov Endress | Mar 17, 2025 | Insight for DBAs, MySQL, Percona Software
In this blog, we will look at the differences between LTS (Long Term Stable) versions of Percona Server for MySQL. Released in April 2019, MySQL 8.0 represented a major change from the previous version, 5.7, introducing significant changes to the data dictionary and...
by Steve Hoffman | Mar 10, 2025 | MySQL, Percona Software
Percona is excited to announce the community release of our MySQL 5.7 End-of-Life (EOL) source code for both Percona Server for MySQL (PS) version 5.7.44-52 and Percona XtraDB Cluster (PXC) version 5.7.44-31.65.5. This release is an accumulation of several...
by Mike Benshoof | Mar 3, 2025 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in June 2020 and was updated in March 2025. One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket. While this can be caused by a multitude of factors, it is more often than not...
by Rituja Borse | Mar 1, 2025 | Hardware and Storage, Insight for DBAs, MySQL
This blog was originally published in March 2023 and was updated in March 2025. This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’, in 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for...
by Roberto De Bem | Feb 26, 2025 | Insight for DBAs, MySQL
Typically, we receive customer tickets regarding crashes or bugs, where we request a core dump to analyze and identify the root cause or understand the unexpected behavior. To read the core dumps, we also request the linked libraries used by the server’s MySQL....
by David Ducos | Feb 24, 2025 | Insight for DBAs, MySQL
I have been working on MyDumper for over three years now, and I usually don’t use the tax-consistency-only feature during backups because it wasn’t an option I quite understood. So, when reviewing another issue, I stepped into a curious scenario, and I finally got it...
by Anil Joshi | Feb 14, 2025 | Insight for DBAs, MySQL
by David Quilty | Feb 12, 2025 | Insight for DBAs, MySQL, Percona Software
You know about MySQL; we know about MySQL. After all, it’s been the most popular database system for years now. And now that we have that out of the way, on to the more important stuff! Because MySQL is so popular, you might be considering migrating your database to...
by Brian Sumpter | Feb 1, 2025 | Insight for DBAs, Monitoring, MySQL
This post was originally published in June 2020 and was updated in February 2025. While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL...
by Roberto De Bem | Jan 22, 2025 | Insight for DBAs, MySQL
Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the table definition. Since RDS replication does not use asynchronous for its replication, the typical switchover procedure is not feasible. However,...
by Przemysław Malkowski | Jan 17, 2025 | Insight for DBAs, Monitoring, MySQL
What index will be used when you count all rows in a table? Well, the MySQL documentation provides a straightforward answer to this, quoting: InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer...
by Yunus Shaikh | Jan 8, 2025 | Insight for DBAs, Monitoring, MySQL, Percona Software
This article will be helpful if you use the Percona Monitoring and Management (PMM) instance and alert notifications, as it is nice to capture the image of the graph when you receive the alert. We will see how to capture and attach the image of the graph when...
by Yunus Uyanik | Jan 7, 2025 | Insight for DBAs, MySQL
Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication Architecture). We are going to explore how MySQL handles thread termination using the KILL command, as visualized in the provided diagram, and...
by Przemyslaw Skibinski | Jan 6, 2025 | Benchmarks, Insight for DBAs, MySQL
At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. In particular, the performance deterioration in the MySQL 8.4.x and 9.y versions caught our attention, as highlighted in Marco...
by Juan Arruti | Jan 1, 2025 | Insight for DBAs, Monitoring, MySQL
This post was originally published in April 2020 and was updated in January 2025. One of our customers recently asked whether it is possible to identify, from the MySQL side, the query that is causing high CPU usage on his system.The usage of simple OS tools to find...
