Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 2, 2025
How to Migrate From MariaDB to MySQL
This post was originally published in May 2024 and was updated in April 2025. MySQL and MariaDB are two major [...]
March 24, 2025
Percona XtraBackup 8.4 Pro: Reduce Server Locking by up to 4300X
When performing backups, reducing the amount of time your server is locked can significantly improve performance and minimize disruptions. Percona [...]
March 19, 2025
Troubleshooting Common MySQL Performance Issues
MySQL databases serve as the foundation of countless applications, powering everything from simple blogs to massive enterprise platforms. But as [...]
March 17, 2025
Percona Server for MySQL 8.4.2 vs 8.0.40: Comparison of Variables and Keywords
In this blog, we will look at the differences between LTS (Long Term Stable) versions of Percona Server for MySQL. [...]
March 10, 2025
Extending MySQL 5.7: Percona Releases Post-End-of-Life Source Code to the Community
Percona is excited to announce the community release of our MySQL 5.7 End-of-Life (EOL) source code for both Percona Server [...]
March 3, 2025
MySQL 101: How to Find and Tune a Slow MySQL Query
This blog was originally published in June 2020 and was updated in March 2025. One of the most common support [...]
March 1, 2025
InnoDB Performance Optimization Basics
This blog was originally published in March 2023 and was updated in March 2025. This blog is in reference to [...]
February 26, 2025
Using VS Code and Docker to Debug MySQL Crashes
Typically, we receive customer tickets regarding crashes or bugs, where we request a core dump to analyze and identify the [...]
February 24, 2025
Understanding trx-consistency-only on MyDumper Before Removal
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 [...]
February 14, 2025
Orchestrator (for Managing MySQL) High Availability Using Raft
As we know, Orchestrator is a MySQL high availability and replication management tool that aids in managing farms of MySQL servers. [...]
February 12, 2025
Considering Alternatives for Your MySQL Migration? Why Percona Should Be Your First Choice
You know about MySQL; we know about MySQL. After all, it’s been the most popular database system for years now. [...]
February 1, 2025
MySQL Performance Tuning: Maximizing Database Efficiency and Speed
This post was originally published in June 2020 and was updated in February 2025. While there is no magic bullet [...]
January 22, 2025
Using Blue/Green Deployment For (near) Zero-Downtime Primary Key Updates in RDS MySQL
Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the [...]
January 17, 2025
What’s the Cost of Counting MySQL Table Rows?
What index will be used when you count all rows in a table? Well, the MySQL documentation provides a straightforward [...]
January 8, 2025
Attaching a Percona Monitoring and Management Graph Image Along with an Alerting Notification
This article will be helpful if you use the Percona Monitoring and Management (PMM) instance and alert notifications, as it [...]
January 7, 2025
MySQL with Diagrams Part Two: How KILL Works
Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication [...]
January 6, 2025
MySQL 8.4.3 and 9.1.0: Major Performance Gains Revealed
At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. [...]
January 1, 2025
MySQL High CPU Usage: Effective Troubleshooting Methods
This post was originally published in April 2020 and was updated in January 2025. One of our customers recently asked [...]
December 20, 2024
MySQL Transaction ERROR 1412 and Isolation Levels
This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific [...]
December 19, 2024
Percona XtraBackup 101: Decompress and Decrypt or Decrypt and Decompress?
This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper [...]