Tag: #Performance
-
How MariaDB 11.8 became about 3× faster on some in-memory workloads, fixing a regression dating back to 10.5
Publishing on behalf of Alessandro Vetere.
Conclusions first: InnoDB in-memory workloads started paying for LRU management in 10.5, a performance regression, and I think the reason is that a clock, which was meant to say “eviction has started”, began ticking much earlier. A minimal fix would bring back the old meaning of the clock. The fix that we pushed tries to do more: it takes buf_pool.mutex out of the LRU promotion on a page access, not only for in-memory workloads. […]
-
MariaDB Foundation: Reproducing and Validating MDEV‑37992 with TAF
Thanks to Mark Callaghan for filing MDEV‑37992. This regression only appears under specific LRU and buffer‑pool conditions, and requires a memory‑resident workload to expose.
Using TAF, I reproduced the issue across 11.8, 12.3, and 13.1 using both parent commits and patched commits from MDEV‑33966. The fix restores expected throughput in all branches.
The workload used was POINTS‑COVERED‑PK with 10M rows × 8 tables, 40 threads, warmup enabled, and a 90G buffer pool. TAF’s warmup iteration, rest detection, and stable‑state perf […]