Database Benchmarks

MySQL 4.0.20d

MySQL has been a staple of our Linux tests since their inception. Below, you can see our results for sysbench on both the 64-bit RedHat 2.4 kernel. We ran the sysbench 0.3.1 oltp tests for 1,000,000 and 10,000,000 record sized table. Our MySQL configuration details are identical to Johan's earlier database benchmarks.



The difference between Solaris and SLES in this instance is almost negligible. We see a 58% speed boost from the quad Opteron server is certainly exciting, although it is a far cry from the 50-80% speed boost we were promised over a higher clocked quad Opteron 252 configuration.

The Test Apache Benchmarks
POST A COMMENT

47 Comments

View All Comments

  • kbsartain - Thursday, June 30, 2005 - link

    The Database benchmarks are likely bottlenecked on storage. Attach a high-speed array with multiple disks, and the scaling would be much more linear vs. 2-way. Reply
  • ceefka - Thursday, June 30, 2005 - link

    It would be nice if other Opteron-builders would add to the test so we can get an idea of how well the Opteron is implemented.

    I'd say webspace is best served with dualcore Opterons. 90% gain! Holy moly!

    #23 I have worked as a temporary at Sun in The Netherlands in 1987 when they were about to release their 4/ series. Their 3/ machines were already considered top notch then. They offered workstations with an optical mouse that moved over a special gridpad and full color screens. That was really something special then. No AMD CPUs at that time.

    To be perfectly honest as well, I also didn't know them before I worked there ;-)
    Reply
  • sprockkets - Thursday, June 30, 2005 - link

    SuSE Linux Enterprise not enterprise enough for u? Reply
  • KristopherKubicki - Thursday, June 30, 2005 - link

    hondaman: This is why we used SLES this time around instead of RH9. Unfortunately the previous single-core V40z tests were all done a few months ago when we had that machine.

    Kristopher
    Reply
  • Xenoterranos - Thursday, June 30, 2005 - link

    Wow, I wish my company had a use for a system like that. I'd take a paycut just to be able to play with it for a while... damned fine enginering on both Sun and AMD's part. And to be prefectly honest, I never really payed Sun that much attention until they started using AMD procs. Everyone else needs to get with the program and give AMD the market share they deserve...oh wait...I'll stop there. Reply
  • slashbinslashbash - Thursday, June 30, 2005 - link

    #21: Read the comments and you'll find your answer.

    Kristopher: Page 7, "Apache Benchmarks" text:

    "It's also interesting to note the difference between Solaris 10 and SLES 9 here. As the threads increased, there was a wider gap between performance of the Solaris configuration and the SLES configuration in favor of Solaris."

    The graph on that page shows the opposite, with SLES outperforming Solaris.
    Reply
  • finbarqs - Thursday, June 30, 2005 - link

    wait why the xbox360/ps3 article taken down? Reply
  • hondaman - Thursday, June 30, 2005 - link

    can you swap suse with a real enterprise os like rhel? Reply
  • themelon - Thursday, June 30, 2005 - link

    I guess I should have kept reading.

    Sorry.

    I have one of the v40's in my lab with 4 of the 875's. Very nice machine.
    Reply
  • Doormat - Thursday, June 30, 2005 - link

    Does anyone know if the v20zs were dual core-capable? I heard that if you negotiate with sun (go to sun's ebay sale for the v20z), you can get really good deals. I'd love to just get two 270s if/when the prices come down. Reply

Log in

Don't have an account? Sign up now