Database Performance Analysis

To make sense out of all these numbers, we summarized our findings below.

Database Performance (Linux)
MSI K2-102A2M Opteron 275 MSI K2-102A2M Opteron 280 Opteron 280 vs.
Opteron 275
Extrapolated Opteron 3 GHz Xeon 5160
3 GHz
MySQL - Dual-core 749 805 7% 946 996
MySQL - Quad-core 590 622 5% 703 904
PostgreSQL 490 524 7% 616 673


As the Xeon 5160 is not yet released, and it is unclear what AMD will do in response, we were curious how a 3 GHz Opteron would compare to our 3 GHz Woodcrest. Both architectures have similar pipeline lengths and will probably attain more or less the same clockspeeds under the same process technology, though of course Intel is ahead when it comes to process technology. It is interesting to see how the Opteron compares clock for clock with the new Xeon.

Database Scaling (Extrapolated)
Xeon 5160 vs.
Opteron 280
Xeon 5160 vs.
Extrapolated Opteron 3 GHz
MySQL - Dual-core 24% 5%
MySQL - Quad-core 45% 29%
PostgreSQL 28% 9%


The Xeon's advantage in Open source databases is significant but not as spectacular as the Spec 2000 Integer numbers. The fact that Woodcrest scales better, or should we say "less bad", is most likely a result of the massive 4 MB L2 cache. As said before, increasing the cache of the previous Xeon generation from 1 to 2 MB results in about 7-8% higher performance. While we cannot be sure that those number are also applicable to Opteron or Woodcrest, it is pretty clear that the 4 MB cache does give the newest Xeon a performance boost.

Despite the fact that Woodcrest is a behemoth when it comes to integer performance, it does not outperform the Opteron by a large margin in MySQL on clock for clock basis. The problem seems to be the FB-DIMM latency. A quick test with higher latency RAM on the Opteron showed that increasing the latency of the RAM subsystem by 20% resulted in a 20 to 25% decrease of MySQL performance. Although this doesn't allow us to get a precise idea of how memory latency influences Woodcrest's MySQL performance, it shows us clearly that memory latency has a big impact on MySQL's performance in our tests.

Web Server Performance Analysis

Below is our summary of web server performance. While we averaged the database numbers, we took the peak numbers of our web server tests. The reason is that at lower request rates, all systems perform the same. "Jsp" gives you the Java Server Page performance, AMP stands for Apache/MySQL/PHP.

Webserver Performance
  MSI K2-102A2M Opteron 275 MSI K2-102A2M Opteron 280 Opteron 280 vs.
Opteron 275
Extrapolated Opteron 3 GHz Xeon 5160
3 GHz
Jsp - Peak 144 154 7% 182 230
AMP - Peak 984 1042 6% 1178 1828


Extrapolating the performance of our 2.4 GHz Opteron 280 to 3 GHz again makes it for an interesting comparison.

Webserver Scaling (Extrapolated)
  Xeon 5160 vs.
Opteron 280
Xeon 5160 vs.
Extrapolated Opteron 3 GHz
Jsp - Peak 49% 26%
AMP - Peak 75% 55%


When it comes to web server performance, the newest Xeon is unbeatable and crushes the competition. A 3 GHz Opteron is not going to help.

Power

As our Woodcrest test system did not have DBS enabled, we decided to test only under full load. Again, take the results with a grain salt, as it is impossible to make everything equal. We tested all machines with only one power supply powered on, and we also tried to have a similar amount and type of fans (excluding the CPU fan, where the T1 doesn't have one). There are still differences between the motherboards, and the Sun uses 2.5 inch disks.

Max Power usage (100% CPU load - Watts)
  Configuration Power
Sun T2000 1CPU / 8 Cores - 8 GB RAM 188
Dual Opteron 275 HE 2CPU's (275HE) - 4 GB RAM 192
Dual Opteron 275 2CPU's - 4 GB RAM 239
Dual Xeon 5160 3 GHz 2 CPU's - 4 GB RAM 245
Dual Xeon "Irwindale" 3.6 GHz 2CPU's - 8 GB RAM 374


Simply looking at the power numbers, the T2000 server beats the rest. We were informed that the current T2000 Servers now ship with high efficiency 450W Power supplies (our T2000 uses a 550 Watt one), which will further reduce power consumption 10 Watts or more. From a performance/Watt point of view, the new Woodcrest CPU is the winner in most workloads.

MySQL Scaling and PostGreSQL Conclusion
Comments Locked

91 Comments

View All Comments

  • snorre - Thursday, June 8, 2006 - link

    Anandtech is going down the drain, there are no doubts left about it IMHO.

    "Woodcrest" may be a nice improvement for Intel, but comparing it to clearly crippled (both software and hardware wise) Opteron systems is pretty lame by any standard.

    Remember: Fool us once shame on us, fool us twice shame on YOU!

    This is your third strike in my book, so now your officially out in THG hell.

    I hope you wake up and smell the coffee soon...
  • Slappi - Thursday, June 8, 2006 - link

    Exactly.

    I just can't believe what I am seeing here.

    This site was once THE HARDWARE SITE for me and I always recommended it to others.

    If Intel has a better chip hey that's great! But.... what is with the OBVIOUS underhanded reporting against AMD and for INTEL that has been going on here for the past few months?


    It is so blatant here that I am starting to wonder of Intel's new chips are a lot of smoke and mirrors. If it is such a great chip it should speak for itself, not with all this closed testing and crippled AMD machines. Makes me wonder.


    You would think after reading all the Anand Intel press that the new CPUs could cure cancer and cook dinner.
  • duploxxx - Thursday, June 8, 2006 - link

    i can give 2 pages full of rather strange figures and compares about this review. but i hope you'll bring the readers the windows benches fast and compare with other published benches so everybody can see that the linux optimization can shift wherever you want.

    you use workstaion/budget motherboard against the intel server board. use a sun galaxy or hp proliant.

    the specint and specfp are not correct, even intel gives way other numbers

    some benches are done with one socket others with 2 socket. why?

    mysql benches are optimized for two cores thats very clear.. the perfromance drop on opteron is much more the the one on woodcrest. knowing the architecture of the opteron this should be the other way round. the opteron is lacking here due to the motherboard

    you can extrapolate it in a different way showing different results, again you use 2 different opterons and use thsi difference to calculate 3.0, both setups are workstation and therefore performance is wrong. some benches you even talk and calculate 2 systems but not showing on the graphs.

    your conclusion: is rather funny. you state that the wooodcrest is the best performing server on a platform that has maybe 2% worlwide support with benches that can not be compared to other publication. no linnear powerconsuption with other servers because no exual hardware setup and most systems use 2gb/cpu thats a +28w consumption for the woodcrest.

    as stated from line 1 give some real world benches where people can compare with other posted results.
  • zsdersw - Thursday, June 8, 2006 - link

    quote:

    you use workstaion/budget motherboard against the intel server board. use a sun galaxy or hp proliant.


    The MSI K8N Master2-FAR board is a server motherboard. So are the boards in the other two Opteron servers.
  • MrKaz - Thursday, June 8, 2006 - link

    I don’t know if you all already have realized but that is what it will look like the 4x4 boards.

    And that’s NOT a server board, ONLY ONE of the processors is accessing directly to the memory and that must IMPACT the performance.

    http://www.msi.com.tw/images/product_img/mbd_img/9...">http://www.msi.com.tw/images/product_img/mbd_img/9...
  • AnandThenMan - Thursday, June 8, 2006 - link

    Anyone that calls that MSI mobo a "server board" is a freakin retard.

    As for this "review" it has to be the worst on Anandtech in at least 6 months.
  • zsdersw - Thursday, June 8, 2006 - link

    quote:

    Anyone that calls that MSI mobo a "server board" is a freakin retard.


    I guess MSI themselves must be retards then. Look where it's listed: http://www.msi.com.tw/program/products/server/svr/...">http://www.msi.com.tw/program/products/server/svr/...
  • ashyanbhog - Thursday, June 8, 2006 - link

    for those who think MSI board must be good because they list it on their server pages,

    Just look at the memeory banks

    MSI has a single bank, forcing the 2nd CPU to share the memory channel, reducing memory bandwidth to both CPUs, and increasing memory latencies. They are discarding NUMA capabailities to keep the price at around 250$

    http://www.msi.com.tw/program/products/server/svr/...">http://www.msi.com.tw/program/products/server/svr/...

    Now check Tyan k8we and Supermicro h8dci boards linked below. Notice that they all carry two seperate memory banks, giving each processor its own dedicated bank. This doubles the available memory bandwidth and keeps lantencies low.

    http://www.tyan.com/products/html/thunderk8we.html">http://www.tyan.com/products/html/thunderk8we.html

    http://www.supermicro.com/Aplus/motherboard/Optero...">http://www.supermicro.com/Aplus/motherboard/Optero...

    Iwill D8kn is another similar board that I can recall. They all recommend that you put atleast on card in each bank in a two processor setup to utilize the extra bandwidth.

    But adding this extra bank comes at a cost, all the above boards are priced around $500 mark. Its common knowledge in the AMD community that one needs get the boards with seperate memory banks if on is looking for a high performance machine.

    If you still have doubt, check the review on GamePC, linked below. Notice that the Tyan TIGER k8we, (with single memory channel to both CPUs like the MSI board) is beaten in every benchmark by Tyan THUNDER k8we (which has dedicated memory channels for both CPUs)
  • BasMSI - Friday, June 9, 2006 - link

    MSI lists them as Workstation boards, not server boards.

    http://www.msi.com.tw/program/products/server/svr/...">>>See link<<

    They should have used the K8D-Master series, those are server boards and do have NUMA.
  • zsdersw - Friday, June 9, 2006 - link

    It's under the "Server and Rackmount" section of their website.

Log in

Don't have an account? Sign up now