by Arunjith Aravindan | Apr 17, 2025 | MySQL
MySQL has been evolving rapidly, and with the recent release of MySQL 8.4, there’s a lot to unpack. While MySQL 8.4 is officially dubbed a Long-Term Support (LTS) release, many features introduced between 8.0 and 8.4 have now matured into defaults or become...
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 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 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 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 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 Lalit Choudhary | Dec 20, 2024 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific Isolation level settings. Background As per the MySQL documentation, this error should occur for “operations that make...
by Yunus Uyanik | Dec 12, 2024 | Insight for DBAs, MySQL
In this series, “MySQL with Diagrams,” I’ll use diagrams to explain internals, architectures, and structures as detailed as possible. In basic terms, here’s how replication works: the transactions are written into a binary log on the source side, carried into...
by Dmitry Lenev | Dec 3, 2024 | Insight for DBAs, MySQL
TL;DR ALTER TABLE and OPTIMIZE TABLE on an InnoDB table, which rebuilds the table without blocking concurrent changes to it (i.e., executed using INPLACE algorithm) and concurrent DML or purge activity on the table can occasionally lead to two significant problems:...
by Fernando Laudares Camargos | Nov 14, 2024 | Cloud, Insight for DBAs, MySQL, Percona Software
Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not explicitly allocating (or requesting, in Kubernetes vocabulary) CPU resources to my Percona XtraDB Cluster (PXC) pods or yet making just a small request,...
by Yunus Uyanik | Oct 31, 2024 | Insight for DBAs, MySQL
by Przemysław Malkowski | Oct 5, 2024 | Insight for DBAs, MySQL
This post was originally published in July 2023 and was updated in October 2024. Upgrading to MySQL version 8.0 is a hot topic since version 5.7 reached EOL. MySQL 5.7 EOL was at the end of October 2023. If you feel unprepared for the upgrade, consider post-EOL...
by Anil Joshi | Sep 25, 2024 | Benchmarks, Insight for DBAs, MySQL
In this blog post, we will explore how network partitions impact group replication and the way it detects and responds to failures. In case you haven’t checked out my previous blog post about group replication recovery strategies, please have a look at them for...
by Vinicius Grippa | Sep 17, 2024 | Database Trends, Insight for DBAs, MySQL
There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are voicing concerns, especially after encountering several issues in the newer versions. Issues with MySQL 8.0.38 Let’s start with...
