by Arunjith Aravindan | May 29, 2025 | Insight for DBAs, MySQL
by Arunjith Aravindan | May 20, 2025 | Insight for DBAs, MySQL
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 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 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 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 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 Yunus Shaikh | Mar 18, 2024 | MySQL, Percona Software, Security
Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption...
by Vinicius Grippa | Jan 18, 2024 | Insight for DBAs, MySQL
In this blog post, we will discuss how to validate at the operating system level the effects of changing the innodb_flush_method to variations other than the default (particularly for O_DIRECT which is most commonly used) and the use of innodb_use_fdatasync....
by Anil Joshi | Aug 25, 2023 | Insight for DBAs, MySQL
by Arunjith Aravindan | Aug 7, 2023 | Insight for DBAs, MySQL
In InnoDB, the undo log and the redo log are two indispensable components that play a vital role in maintaining data integrity and ensuring transactional consistency. Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of...
by Manjot Singh | Aug 5, 2023 | Insight for DBAs, MySQL
This blog was originally published in July 2017 and was updated in August 2023. It’s a pretty common question around here, so let’s see what we can do about that. So, What is MySQL Partitioning? Partitioning is a way in which a database (MySQL in this...
by Pep Pla | Jul 5, 2023 | Insight for DBAs, Insight for Developers, MySQL
Fragmentation is a common concern in some database systems. Highly fragmented tables can affect performance and resource allocation. But reducing fragmentation often involves rebuilding the table completely. This blog post will discuss fragmentation and its impact on...
by Colin Charles | Jun 4, 2023 | Insight for DBAs, MariaDB, MySQL
This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL). Introduction: MariaDB vs. MySQL The goal of this blog post is to...
by Mauricio Cacho | Mar 6, 2023 | Insight for DBAs, MySQL
MySQL uses Redo Logs internally during crash recovery to correct data written by incomplete transactions. But how do you know what the right Redo Log size is? We will walk through how to figure that out in this blog. We already have a couple of posts related to this...
by Larry Xia | Nov 14, 2022 | Insight for DBAs, MySQL
At Percona Managed Services, sometimes clients’ applications face deadlock situations and need all historic deadlock information for application tuning. We could get the LATEST DETECTED DEADLOCK from SHOW ENGINE INNODB STATUSG: Shell …. ------------------------...
by Kedar Vaijanapurkar | Sep 7, 2022 | Insight for DBAs, MySQL
A large table is a pain for many reasons as long as it is in a system. And as if that’s not enough, it is also a difficult task to get rid of it. In this post, we will understand why it is a pain to do this operation and what we can do about it. It will be like...
by Sveta Smirnova | Jul 13, 2022 | Monitoring, MySQL, Percona Software
In this blog, I will demonstrate how to use Percona Monitoring and Management (PMM) to find out the reason why the MySQL server is stalling. I will use only one typical situation for the MySQL server stall in this example, but the same dashboards, graphs, and...
by Marco Tusa | Nov 9, 2021 | Insight for DBAs, Insight for Developers, MySQL
Well, let me say if that happens it’s because there is a logic mistake in your application. But you need to know and understand what happens in MySQL to be able to avoid the problem. In short, the WHY of this article is to inform you about possible pitfalls and...
by Francisco Bordenave | Sep 21, 2021 | Benchmarks, Cloud, Insight for DBAs, MySQL
Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice. In short, we...
