The Percona Database Performance Blog

Technical guides, deep dives, and perspectives across MySQL, PostgreSQL, MongoDB, Valkey, Redis, and more.

Interested in writing for the Percona Blog?

Blog

April 22, 2026

Percona Live 2026 is Back in the Bay Area — Here’s Why You Don’t Want to Miss It

We’re thrilled to welcome the open source database community back in person for Percona Live 2026, taking place May 27–29 in the Bay Area. After the e...

Blog

April 21, 2026

Impacts of updates in open-source databases

We recently looked at how various open-source database engines maintain their secondary indexes (in a previous analysis) and found significant differe...

Blog

April 21, 2026

Percona Operator for MySQL 1.1.0: PITR, Incremental Backups, and Compression

The latest release of the Percona Operator for MySQL, 1.1.0, is here. It brings point-in-time recovery, incremental backups, zstd backup compression, ...

Blog

April 21, 2026

PostgreSQL Performance: Is Your Query Slow or Just Long-Running?

Introduction: Recently I was having a conversation with a DB Enthusiast, and he mentioned that when he was a fresher, he tuned an ETL/reporting query ...

Blog

April 20, 2026

Deploying Cross-Site Replication in Percona Operator for MySQL (PXC)

Having a separate DR cluster for production databases is a modern day requirement or necessity for tech and other related businesses that rely heavily...

Blog

April 17, 2026

MariaDB’s Snapshot Isolation: A Fix That Breaks More Than It Fixes

Jepsen’s analysis of MySQL 8.0.34 walked through a set of concurrency and isolation anomalies in InnoDB. MariaDB, which inherits the same codeba...

Blog

April 16, 2026

Why A Goat?

New Brand. Same Independence. If you read today’s announcement, you know Percona has a lot to say about what’s broken in modern data infra...

Blog

April 13, 2026

Pipelining and Transactions in Redis and Valkey

Pipelining and transactions are two important features in Redis and Valkey. Both involve sending multiple commands together. But they solve completely...

Blog

April 13, 2026

MongoDB Query Plan Cache Explained: Performance, Pitfalls, and Re-Planning

When MongoDB receives a query, it performs the following steps: Evaluate the available indexes that could be used. Generate and test multiple executio...

Blog

April 13, 2026

Auditing Login Attempts in MySQL and MariaDB

My colleague Miguel wrote about ways to audit login attempts in MySQL over 13 years ago, and this is still a relevant subject. I decided to refresh th...