Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
December 18, 2024
How To Deal with a AUTO_INCREMENT Max Value Problem in MySQL and MariaDB
An application down due to not being able to write into a table anymore due to a maximum allowed auto-increment [...]
December 12, 2024
MySQL with Diagrams Part One: Replication Architecture
In this series, “MySQL with Diagrams,” I’ll use diagrams to explain internals, architectures, and structures as detailed as possible. In [...]
December 3, 2024
Who Ate My MySQL Table Rows?
TL;DR ALTER TABLE and OPTIMIZE TABLE on an InnoDB table, which rebuilds the table without blocking concurrent changes to it [...]
November 14, 2024
Exploring Kubernetes CPU Resources in View of Percona XtraDB Cluster’s Flow Control
Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not [...]
November 1, 2024
How Can MySQL Catch Up with PostgreSQL’s Momentum?
When I talk to old-timers in the MySQL community, I often hear this question: “How come MySQL is so awesome [...]
October 31, 2024
Tracking Dual Passwords in MySQL
We already have blog posts about Dual Password in MySQL from Brian Sumpter – Using MySQL 8 Dual Passwords, and [...]
October 5, 2024
Upgrade MySQL to 8.0? Yes, but Avoid Disaster!
This post was originally published in July 2023 and was updated in October 2024. Upgrading to MySQL version 8.0 is [...]
September 25, 2024
How Network Splits/Partitions Impact Group Replication in MySQL
In this blog post, we will explore how network partitions impact group replication and the way it detects and responds [...]
September 23, 2024
Understanding MySQL Indexes: Types, Benefits, and Best Practices
When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring [...]
September 17, 2024
MySQL 8.0 vs. 5.7: Are the Newer Versions More Problematic?
There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are [...]
September 16, 2024
Introducing RHEL9-Certified Builds for Percona MySQL: Ensure Maximum Compatibility and Compliance
Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and [...]
September 13, 2024
All UUID Functions in Percona Server for MySQL: RFC 9562 Implemented
The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, [...]
September 10, 2024
How to Migrate a Production Database to Percona Everest (MySQL) Using Clone
This long article aims to provide you with the instructions and tools to migrate your production database from your current [...]
September 4, 2024
Percona In-Product Telemetry: Updates, Findings, and News
This article is, in fact, two topics merged into one publication. Both are related to anonymous statistical data collection within [...]