Archive 1997–2024

Dual CPU Database Server Comparison


Benchmarks MySQL: Single versus Dual

Let us check how MySQL scales from one Xeon to a second one. As always, Hyperthreading is enabled on both CPUs.

conc lev Single Xeon 3.06 1 MB L3 Dual Xeon 3.06 1 MB L3 Dual Speedup
1 102 110 8%
2 137 175 28%
5 153 206 34%
10 158 218 38%
20 162 218 35%
35 160 233 45%
50 157 222 42%

MySQL doesn't seem to scale as well as DB2. We measured a 40% performance increase when the concurrency level is high enough. Might this be an important difference between the big established players and the Open Source database?

Originally published at https://www.anandtech.com/show/1559 (Wayback Machine).