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

  • Den - Thursday, June 30, 2005 - link

    Interesting article, I am confused why you are dissapointed in the GCC complile time though. The dual core machine took 369 seconds (with 9 jobs) and the single took 603.18 seconds (with 5 jobs). 603.18/369=1.635 or 63.5% faster which is well in the 50-80% range. Your article says 43% faster, so maybe the GCC compile conclusion is based on a typo? Reply
  • Kilim - Thursday, June 30, 2005 - link

    I saw the title to the PS3/XBOX article. It was a different one than the original article from last week. I clicked on it to read it and nothing showed up. It was an article critical of the CPU's on the two systems I believe. Matbe Anand find some insider stuff that was only limited to a few people inside MS. If so, I think the potential rewards of protecting the source is much better long term than getting them in trouble and burning a bridge. Along with the long term effects of insiders trusting Anand. Reply
  • jwbaker - Thursday, June 30, 2005 - link

    You can no longer get v20z via ebay. I managed to buy a half-dozen of them for $1200-$1500 each, although I admit I had to collude with another buyer to do so. Probably Sun has enough traction with the v\d+z series that they no longer need the eBay channel.

    The only beef I have with the v-series is Sun can ben recalcitrant about supplying the voltage regulator modules. In the v20z there are four removable VRMs and if you bought a single-CPU machine, you only get 2. Additional VRMs sell in pairs for $175 but the lead time is indeterminant and sometimes very long.
    Reply
  • Houdani - Thursday, June 30, 2005 - link

    32: The article was pulled in order to protect one of the anonymous sources (see comment #10). Reply
  • hondaman - Thursday, June 30, 2005 - link

    Actually, no its not. RHEL is by far and away more widely distributed, and more likely to show results to the people who can most relate to this review. Reply
  • finbarqs - Thursday, June 30, 2005 - link

    i did read the comments, but i still don't know why it was taken down... it just said that it wasn't up to kris to take the article down. Reply
  • Houdani - Thursday, June 30, 2005 - link

    30: What's with the hate?

    And it was quite obvious to me there were multiple sources.
    Reply
  • Questar - Thursday, June 30, 2005 - link

    So that article was based upon one source?!?!

    translation: It was crap, our source was an idiot.
    Reply
  • yacoub - Thursday, June 30, 2005 - link

    Is there no performance increase seen with PC3200 RAM over PC2700? Reply
  • PrinceXizor - Thursday, June 30, 2005 - link

    If whomever is really worried about protecting his "insider" source, you might want to contact Google to have them clear the article from their cache (I don't even know if that's possible).

    P-X
    Reply

Log in

Don't have an account? Sign up now