#Performance articles and events

Introduction Many MySQL configurations inherit redo log sizing from defaults, aging blog posts, or configuration folklore....

Percona is taking part in the DB Mastery: In-Memory Databases summit on March 20, 2026. This virtual event focuses on how teams design and operate high-performance in-memory systems, covering low-late...

Percona is proud to sponsor PGConf India 2026 as a Gold Sponsor, taking place from March 11th to March 13th, 2026, at the Sheraton Grand Hotel at Brigade Gateway in Bengaluru, India....

Traffic spikes and “noisy neighbors” can quickly saturate backend resources. In this session, Martin Visser (Valkey and Redis Tech Lead @ Percona) explores robust rate-limiting strategies to protect s...

Sorted Sets are one of the most powerful data structures in Valkey and Redis, but they are often only associated with gaming leaderboards. In this session, Martin Visser (Valkey and Redis Tech Lead @ ...

Setting up efficient LLM applications requires more than just calling an API. In this session, Martin Visser explains how semantic caching can significantly reduce the cost and latency of Large Langua...

...

Replication Lag is just a fact of life with async-replication. We can’t stop lag, but we can help to reduce it. Many times the Seconds_Behind_Source can be very deciving, I have seen it go from 1 hour...

Usually one would expect that ALTER TABLE with ALGORITHM=COPY will be slower than the default ALGORITHM=INPLACE. In this blog post we describe the case when this is not so....

The thing I wish I’d learned while still a DBA is how to use perf. Conversely after moving to a developer role, getting access to real external client workloads to get a perf recording directly is rar...

Late one evening, I was staring at one of our large MySQL installations and noticed the database was hovering around 7-10 run queue length (48 cores, ~500 gigs memory, fusionIO cards). I had been scra...

Sometimes, the MySQL Optimizer chooses a wrong plan, and a query that should execute in less than 0.1 second ends-up running for 12 minutes!This is not a new problem: bugs about this can be traced bac...