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

  • zsdersw - Thursday, June 8, 2006 - link

    I'm not saying the board is particularly stellar.. I'm saying that it's referred to by MSI as a "server" product.
  • ashyanbhog - Thursday, June 8, 2006 - link

    Irespective of what MSI says,

    fact is there were better mainstream boards for Anandtech to choose from if a honest, independent review was their intention

  • zsdersw - Thursday, June 8, 2006 - link

    I.E., your comment belongs under someone else's.. not mine.
  • zsdersw - Thursday, June 8, 2006 - link

    And that's completely irrelevant to what I was saying.
  • ashyanbhog - Thursday, June 8, 2006 - link

    all I was saying is, its nice to see Intel finally making a comeback

    but Anandtech seems have conducted a skewed benchmark that favours Intel, that unfairly increases the performance gap between Opteron and Woodcrest

    In the final summary of the review he says

    "In one word: Woodcrest rocks!"

    There are quite a few holes in the review, the motherboard is just on of them,

    I quoted MySQL number errors in my posts above,

    just search for "ashyanbhog" in the page and read my earlier comments if you are interested.

  • AnandThenMan - Thursday, June 8, 2006 - link

    quote:

    And that's completely irrelevant to what I was saying.


    What you're saying in general is irrelevant. Intel calls their integrated graphics "high performance" but that doesn't make it so.

    MSI calling that a server board is just marketing, it does not represent what a true, high performance server class mobo is all about. Not that it's a bad piece of hardware, it is good for the price to be sure. But it is NOT a server class product.
  • zsdersw - Thursday, June 8, 2006 - link

    At a certain price point, it could certainly be a nice entry-level server board.

    Performance alone isn't what makes a server-class motherboard a server-class motherboard.
  • ashyanbhog - Thursday, June 8, 2006 - link

    quote:

    Performance alone isn't what makes a server-class motherboard a server-class motherboard.


    One of the motherboards used in this review is a cheap piece that trades performance to keep price low.

    Why was that motherboard selected over mainstream server/workstation boards that are proven to offer slightly better performance? Why pick a 250$ MSI board for opteron over $500 boards from Tyan, Iwill, Supermicro or others. The Intel Xeon "Inderwale" gets a $500 board, so price could not have been the issue.

    So what's the point in using a Single Channel board for this benchmark, when price was not a limitation?

    Single memory channel boards like the one from MSI, are known to offer lower performance than dual / dedicated memory channel boards when used in 2P Opteron configurations. Dual Channel boards are the mainstream boards for 2P Opteron systems. There are plently Server boards available in Dual / dedicated memory lane configuration. There are enough reviews on the net to show the performance diff b/w single memory channel boards and dual memory channel boards

    The issue is not about the MSI or its class, the issue is why did Anandtech pick a Single memeory channel board instead of a more mainstream dual memory channel board.

    Hope that clears up "zsdersw"'s query
  • zsdersw - Thursday, June 8, 2006 - link

    I'm not making excuses for the choices that were made regarding this comparison test. I'm talking about what constitutes a "server-class" motherboard.
  • ashyanbhog - Thursday, June 8, 2006 - link

    Game PC review link for the above comment

    http://www.gamepc.com/labs/view_content.asp?id=tig...">http://www.gamepc.com/labs/view_content.asp?id=tig...

Log in

Don't have an account? Sign up now