Powered by Percona Server for PostgreSQL and pgvector
Introduction Many MySQL configurations inherit redo log sizing from defaults, aging blog posts, or configuration folklore....
May 2 #OpenSource #Percona #MySQL #InnoDB
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-performa...
March 20 #Event #opensource #database #in-memory
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 Gatewa...
March 11 #Event #opensource #sponsorship #PostgreSQL
Traffic spikes and “noisy neighbors” can quickly saturate backend resources. In this session, Martin Visser (Valkey and Redis Tech Lead @ Percona) explores robu...
February 26 #Community #Events #Valkey #Redis
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, Mart...
February 12 #Community #Events #Valkey #Redis
Setting up efficient LLM applications requires more than just calling an API. In this session, Martin Visser explains how semantic caching can significantly red...
January 23 #Community #Events #Valkey #Redis
...
June 23, 2022 #performance #ranking
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...
June 1, 2022 #Percona #MySQL #Replication #LAG
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 thi...
April 23, 2020 #Intermediate Level #MySQL #Percona Server for M #performance
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...
February 5, 2020 #cacheline #MariaDB #MySQL #perf
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 ...
August 7, 2019 #MariaDB #MySQL #performance
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 pr...
July 29, 2019 #bugs #MySQL #optimizer #performance