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