Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative.
Recently, I published a series of posts on MySQL and MariaDB where MariaDB 10.5.4 did not perform well in some scenarios:
In comments on the NVMe post, it was noted that MariaDB 10.5.4 had known performance bugs that would be fixed in MariaDB 10.5.5. Now that MariaDB 10.5.5 is available, it includes:
This post revisits those benchmarks using MariaDB 10.5.5.
All tests use sysbench-tpcc (1000 warehouses, ~100GB dataset) under the following scenarios:
After warm-up differences, performance is roughly the same between versions.
This scenario shows improvements in MariaDB 10.5.5:
MariaDB 10.5.5 improves throughput and even exceeds MySQL 8.0.21 on average, though with higher variability.
Performance is similar to 10.5.4, with slightly worse results and an initial drop before recovery.
This scenario exposes a severe issue in MariaDB 10.5.5 (MDEV-23399).
Throughput frequently drops below 100 TPS, compared to over 5000 TPS in MySQL.
MariaDB 10.5.5 introduces improvements in some IO-bound scenarios, particularly on SATA SSD.
However, performance on NVMe under IO-bound workloads is significantly degraded due to a critical bug.
This makes MariaDB 10.5.5 unsuitable for certain production workloads until the issue is resolved.
