Measurements updated on October 10: the SVG query fell from 5.04 s to 3.32 ms at one customer, with local-network download timings, MariaDB versions, configuration and an InnoDB/RocksDB table diagram.
Read article →
How InnoDB caches pages, protects hot data, warms up after a restart and interacts with redo, the change buffer and the adaptive hash index.
Read article →
Making PmaControl's chunked time-series inserts atomic was expected to cost a little. The benchmark says otherwise: 12.5% faster ingestion. Here's why.
Read article →
How PmaControl resolves the geolocation of hundreds of MariaDB/MySQL servers in real time by importing GeoLite2 ranges directly into MariaDB for instant SQL lookups — IPv4 and IPv6.
Read article →
New PmaControl feature: analyze master binlogs directly from the UI to diagnose MySQL/MariaDB replication lag causes.
Read article →
Analysis of LOCK_EX contention on PmaControl's pivot files: flock() works but the bottleneck is real beyond 100 servers.
Read article →
Missing indexes, untested backups, silent replication drifts — our analysis.
Read article →
How a DATE vs INT type mismatch in a join caused a 105-minute execution time, resolved to 17 seconds with a virtual generated column.
Read article →
Performance regression after MySQL 8 to MariaDB 11.4 migration: how a LEFT JOIN anti-pattern was resolved using a CTE and the EXCEPT operator.
Read article →
Understanding MariaDB's query cache: operating modes, monitoring, efficiency ratios, Galera limitations and the MaxScale cache filter alternative.
Read article →
PmaControl