Apache/PHP/MySQL Performance

In our first review of the T2000, we took a look at the T2000 as a heavy Apache, MySQL and PHP web server (or SAMP web server) using a pretty complex weather report system. The PHP test script retrieves hourly-stored weather information out of a MySQL database, that can be overviewed by month. An 'opening page' displays all months that are stored in the database, and if you open a 'detail page', the month you have selected is submitted by query string parameters. Additional details about this test application are available if you would like to know more.

The problem with our first test was that with the caching file we are taking MySQL and PHP out of the equation most of the time, and emphasizing TCP/IP handling and Apache too much. As we want to get also an idea of the PHP/MySQL speed of the different CPUs, we decided to test with an uncached version, simulating the worst case of the application.

However, running the uncached version only means that we regenerate the PHP page with each request. We did enable the query cache in MySQL. A good webmaster knows that too many accesses to the database can completely wreck web server performance, thus, it is important to "shield" the database backend from too many concurrent accesses. The mod_deflate module was enabled to make gzip compression happen.

For benchmarking, httperf was used in conjunction with autobench, a Perl script written by Julian T. J. Midgley, designed to run httperf against a server several times, with the number of requests per second increasing with each iteration. The output from the program enables us to see exactly how well the system being tested performs as the workload is gradually increased until it becomes saturated. In each case, the server was benchmarked with 5 requests per connection. The client was connected via a gigabit connection to the server.

To interpret the graphs below precisely, you must know that the X-axis gives you the number of demanded requests and the Y-axis gives you the actual reply rate of the server. The first points all show the same performance for each server, as each server is capable of responding fast enough. Only one CPU with 2 (Opteron, Xeon) or 8 cores (Sun UltraSparc T1) was present in each server.



Intel's new Xeon wipes the floor here with the competition. Up to 75% faster than the 2.4 GHz Opteron, the new Xeon won't have any trouble with a 3 GHz Opteron. We have to investigate this further, but it seems that this is the result of massive 4 MB L2 cache and intrinsically better integer performance of Woodcrest. Additional tuning might push the T1 higher, but we are pretty sure it is not going to be a screamer in this benchmark.

SSL Benchmarks Java Webserving
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