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:...
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 Peter Zaitsev | Nov 1, 2024 | MySQL, Open Source, PostgreSQL
When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome and still more popular than PostgreSQL (according to DB-Engines methodology at least), but it is losing ground while PostgreSQL’s growth in...
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 David Quilty | Sep 23, 2024 | Insight for DBAs, MySQL
When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing...
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...
by Valeria Bogatyreva | Sep 16, 2024 | MySQL, Percona Software
Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for...
by Oleksiy Lukin | Sep 13, 2024 | Insight for DBAs, MySQL, Percona Software
The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated...
by Przemysław Malkowski | Aug 30, 2024 | Insight for DBAs, MySQL
Mysterious warning Recently, I was involved in an investigation whose goal was to find out the reason for a warning message like this: [Warning] [MY-011825] [InnoDB] Cannot add field `c11` in table `db1`.`test` because after adding it, the row size is 8484 which is...
by Julia Vural | Aug 26, 2024 | Benchmarks, MySQL, Percona Software
At Percona, we have always prioritized database performance as a critical factor in selecting database technologies. Recently, we have observed a concerning trend in the community edition of MySQL, where performance appears to be declining across major releases,...