Dual CPU Database Server Comparison
- Posted in
- IT Computing
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).