Archive 1997–2024

Dual CPU Database Server Comparison


Benchmarks MySQL: Hyperthreading?

What can hyperthreading do for MySQL performance?

conc lev Dual Xeon 3.06 1 MB L3 no HT Dual Xeon 3.06 1 MB L3 HT HT Speedup
1 106 110 4%
2 158 175 11%
5 193 206 7%
10 213 217 2%
20 205 218 6%
35 206 232 13%
50 203 222 10%

Amazingly, Hyperthreading pushes performance quite a bit higher. Although, once again, the higher margin of error blurs the picture a bit. We measure a 6% to 10% speed increase. Let us see if the Xeon Nocona is any different.

conc lev Dual Xeon 3.6 no HT Dual Xeon 3.6 HT HT Speedup
1 127 127 0%
2 189 191 1%
5 215 239 11%
10 235 249 6%
20 238 251 5%
35 237 259 9%
50 236 251 6%

Again, when we concentrate on row 20 to 50, where the margin of error is a bit lower, we see that Nocona benefits a little less from Hyperthreading than the older Xeons despite being equipped with a slightly more advanced version.

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