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

  • Questar - Thursday, June 8, 2006 - link

    Why? Because AMD got creamed?
  • ashyanbhog - Thursday, June 8, 2006 - link

    and Intel woodcrest may have fantastic performance when compared to earlier xeons,

    but Intel is 3 years late to the party, Opteron was here in 2003!

    also remember, woodcrest is a brand new design from PIII base, manufactured on 65nm process. It is still to make its debut in the market and be available in volumes. Amd its indeed nice to see it being compared to a 3 year old design manufactued on 90nm process.

    AMD still has two product launches to come this year. Move to DDR2 for opterons which should cut some power usage for the total system AND introduction of products manufactured on 65nm at the fag end of the year. Will woodcrest and conroe still retain their performance margins then? if not, for how many months or weeks has Intel grabbed this "performance crown"?
  • zsdersw - Thursday, June 8, 2006 - link

    Consider the following:

    - If comparisons could be made between new products from both companies (i.e., Woodcrest versus K8L), they would be made. In the game of leapfrog that we have betweeen AMD and Intel, the comparisons will always be between existing tech and new tech. Will you be pointing out how AMD is "late to the party" when they release their new stuff?

    - Making its debut and availability in volume is an issue for both AMD and Intel. It's not a valid point unless you make it across the board.

    - 65nm will allow clock speeds of Opterons/A64's to increase.. but Conroe/Woodcrest speeds will be increasing as well.
  • ashyanbhog - Thursday, June 8, 2006 - link

    not because AMD got creamed!

    a 35 billion$ dollar turnover company (Intel) is bound to make a comeback one day.

    it Anandtech's review setup, its full of holes

    the mysql benchmark on Dual Dual core opterons where they see a 30% drop against single core dual processor numbers in this becnhmark contradicts their own earlier benchmark where they see a 10% performance increase.

    http://www.anandtech.com/IT/showdoc.aspx?i=2447&am...">http://www.anandtech.com/IT/showdoc.aspx?i=2447&am...

    they also use a substandard MSI motherboard in one of the Opteron systems and fail to mention which system was used for the benchmarks

    mistakes like this, genuine or intentional, are rife throughout the review report

    the whole thing looks like the rig was setup to push the performance diff b/w woodcrest and Opterons to the max,

    why would anybody two months to tweak settings before they publish the review!
  • Questar - Thursday, June 8, 2006 - link

    Why? Because AMD got creamed?
  • duploxxx - Thursday, June 8, 2006 - link

    yeah right its a workstation motherboard it uses an nforce controller so maybe they rate it as server board it still is a budget board used for workstations, not a real server board or server chipset like they used on the intel woodcrest.

    check the servers like sun galaxy and hp dl385 they have amd chipsets... big difference.
    the nforce has a shared memory bus...
  • zsdersw - Thursday, June 8, 2006 - link

    Yeah, that's one of the 3 Opteron servers. At any rate, the MSI board is a basic server board.. it's still a server board.
  • duploxxx - Thursday, June 8, 2006 - link

    yeah they have done 1 real bench with an hp. all other benches were done with the 2 MSI basic boards...

    still waiting for the wintel benches
  • wolaris - Thursday, June 8, 2006 - link

    In corporate environments, no-one with any hardware budget at all runs webserver and database on the same machine, as it hurts both performance and reliability. This affects T1 most, as its low clock speed and simple cores are not meant for database workloads.
    I think that you should run web serving tests using common, high-performance Opteron DB server and separate webservers, as it would be the case in real-world scenarios.
  • MrKaz - Thursday, June 8, 2006 - link

    So Power consuming of the new Intel processor on .65nm at already high clock speed of 3.0Ghz is already consuming more than the older AMD Opteron on .90nm 2.8Ghz and DDR.

    When AMD releases socket F will go DDR2 (less power) and better .90nm samples (lower power). So then "new" Intel is already getting beaten...

    And those tests where done with Cool&Quite?

    Also don’t forget this tests where done with Woodcrest 3.0Ghz VS Opteron 2.2Ghz and 2.4Ghz, so when AMD releases the 2.8Ghz and 3.0Ghz with socket F the performance lead of Intel will vanish…

    I think the biggest surprise here is how bad Xeon (P4) was (IS!!), and people keep buying it.

Log in

Don't have an account? Sign up now