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...
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 Fernando Mattera | Dec 19, 2024 | Insight for DBAs, MySQL, Percona Software
This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying...
by Przemysław Malkowski | Dec 18, 2024 | Insight for DBAs, Insight for Developers, MariaDB, MySQL
An application down due to not being able to write into a table anymore due to a maximum allowed auto-increment value may be one of the worst nightmares of a DBA. Typical errors related to this problem in MySQL will look like this: ERROR 1062 (23000): Duplicate entry...
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:...
