Why mysqlslap Shows Smoother Results Than sysbench for SQL Performance Testing

The article explains that mysqlslap appears to produce smoother latency results than sysbench because mysqlslap reports metrics per test round rather than per individual SQL statement, leading to mis‑interpretation of Max/Avg/Min values, while sysbench can reveal per‑statement latency variations.

BenchmarkingPerformance TestingSQL latency

0 likes · 4 min read

Why mysqlslap Shows Smoother Results Than sysbench for SQL Performance Testing

Java Backend Technology

Aug 1, 2020 · Databases

Why Smaller DB Connection Pools Boost Performance: Real-World Test Insights

Through a series of Oracle and PostgreSQL benchmarks, this article demonstrates that reducing database connection pool size can dramatically lower request latency—from around 100 ms to just 3 ms—by aligning pool size with CPU cores and I/O characteristics, and provides a practical formula for sizing.

Database Connection PoolI/O bottleneckSQL latency

0 likes · 10 min read

Why Smaller DB Connection Pools Boost Performance: Real-World Test Insights

Programmer DD

Mar 11, 2020 · Databases

Why Smaller DB Connection Pools Boost Performance: Lessons from HikariCP Tests

This article explains how reducing the size of a database connection pool can dramatically lower request latency and improve throughput, using HikariCP performance experiments, a simple sizing formula, and practical guidelines for configuring pools on modern hardware.

Database Connection PoolHikariCPSQL latency

0 likes · 10 min read

Why Smaller DB Connection Pools Boost Performance: Lessons from HikariCP Tests