ProxySQL 2.7 → 3.0: a nice improvement spotted during PmaControl benchmarks. 🚀

While benchmarking PmaControl’s query-cache audit, we measured the same complete audit workflow against ProxySQL 2.7.3 and 3.0.5.

Average elapsed time:
• ProxySQL 2.7.3: 8.112 ms/audit
• ProxySQL 3.0.5: 2.015 ms/audit

That is 75.2% less time per audit — roughly 4× faster in this test.

“ms/audit” means milliseconds for one complete cache-audit check, measured from PmaControl’s side. It includes two read-only queries to ProxySQL Admin: reading active cache rules and their match counters, then cache statistics and configuration. SQL execution, loopback communication, result fetching and PHP processing are included.

Connection setup, process startup, HTTP and UI rendering are outside the timer.

The setup: Ubuntu 24.04.4, 2 vCPU, 4 GiB RAM and PHP 8.4.26. We measured 150 complete audits per version, in 15 batches of 10 after warmup, using the same audit code and SQL.

The median batch mean also fell from 7.896 to 2.054 ms/audit. PHP’s allocated peak stayed at 4 MiB for both versions.

These results describe this specific Admin audit workload on a shared test VM. Query-routing throughput and standalone server execution time were outside the benchmark.

Nice improvement, ProxySQL team! It is good to see a measurable gain in the work our monitoring actually performs.

#ProxySQL #PmaControl #MySQL #DatabasePerformance #Benchmarking