Dual CPU Database Server Comparison
by Johan De Gelas on December 2, 2004 12:11 AM EST- 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.
Facebook
Twitter
RSS
46 Comments
View All Comments
smn198 - Thursday, December 2, 2004 - link
Would love to see how MS SQL performs in similar tests.mrVW - Thursday, December 2, 2004 - link
This test seems foolish to me. A 1GB database? All of that fits in ram.A database server is all about being the most reliable form of STORAGE, not some worthless repeat queries that you should cache anyway.
Transactions, logging... I mean how realistic is it to have a 1GB of database on a system with 4GB of RAM and expensive DB2 software.
A real e-commerce site likeMWave, NewEgg, Crucial could have 20GB per year! Names, addresses, order detail, customer support history, etc.
Once you get over a certain size, a database is all about disk (putting logging on one disk indepdent of the daata, etc.). The indexes do the main searching work.
This whole test seems geared to be CPU focused, but only a hardware hacker would apply software in such a crazy way.
mrdudesir - Thursday, December 2, 2004 - link
man i would love to have one of those systems. Great job on the review you guys, its good to know that there are places where you can still get great independent analysis.Zac42 - Thursday, December 2, 2004 - link
mmmmmmm Quad Opterons......Snoop - Thursday, December 2, 2004 - link
Great readksherman - Thursday, December 2, 2004 - link
is that pic from the 'lab'? (the one on pg 1)