MySQL

We ran two free, open sourced database benchmarks for this portion of the analysis.  The first uses MySQLd 4.0.20d installed from x86_64 RPM; precompiled by the SuSE team.  We ran the test-select and test-insert sql-bench exams.

MySQL 4.0.20d - Test-Select

MySQL 4.0.20d - Test-Insert

Postgres

Adding Postgres to the SQL benchmarks was fairly easy.  Although this may not be the most optimized way to benchmark Postgres, our time was limited.  We installed the DBD-pg Perl library, and then reran our sql-bench results as above in the MySQL tests Postgres was started with the "-o - F" flags. 

PostgreSQL 7.4.2 - Test-Select
PostgreSQL 7.4.2 - Test-Insert

Remember, even though times are significantly longer in this benchmark, they do not show whether or not one database is faster than the other.  However, there are some extreme conclusions we can draw from this test.  The Opteron 150 really advances over the Xeon processor in this benchmark.  We have shown in previous reviews that HyperThreading seems to hurt MySQL performance as some unnecessary threading probably occurs. 

Index Chess Benchmarks
Comments Locked

92 Comments

View All Comments

  • tfranzese - Thursday, August 12, 2004 - link

    Much better Kris, and I was only disappointed in not getting to see the 32-bit comparisons to see how well the current iAMD64 implementation is running.

    Only thing you left me confused on was the last paragraph on the John The Ripper benchmark. Might only be me who can't understand what you mean.
  • KristopherKubicki - Thursday, August 12, 2004 - link

    datacipher:

    Datacipher, it really depends on your point of view. For server performance benchmarks, like the SQL stuff, another server chip was the way to go (like we did here).

    If we go the desktop route, the line becomes a little blurry, particularly on Intel's end. Intel defines UP servers and high end workstations almost identically.

    If we were to go on price alone, we still don't have the fairest comparison since the 150 is priced cheaper than the Xeon and the 3.6F. Some of my sources have said the 3.6F may debut considerably lower than its Xeon 3.6GHz server counterpart, even though they are the same processor with different pin outs.

    Regardless of what you think, the 3.6F and Xeon 3.6GHz processors will compete against AMD dual channel offerings in the 2.4GHz range. If you read some of our other reviews, L2 cache size doesnot seem as critical on the A64 platform.

    Whelp, anyway, hope that helps. When the 3.6F actually shows up at newegg with a price, then i will tell you for sure what it competes against :)

    Kristopher
  • srg - Thursday, August 12, 2004 - link

    Stellar Job on this one, you earnt the vacation. Anyway the reason this one seems more correct is that in the 32-bit tests, opteron beats the Xeon (so why should this one be so different), now everywhere else I've read are saying that the Xeon's 64-bit performance wasn't much and yours was a contradiction. That's why there was the contravercy. Anyway, this confirms the party line.

    srg
  • datacipher - Thursday, August 12, 2004 - link

    Kristopher:

    Now I'm really confused! In the original article you say that the chips were not meant to compete...but then you also said things like "it turned out to be more appropriate than antipated". Now you are saying that since the 3.6F will be marketed against the 3500+...that it is the correct choice...

    Now I'm trying to understand...forgive my ignorance. Basically you took a server chip as a stand in for the 3.6F against the 3500+ in what amounts to basically a desktop shootout? What I don't understand about this is how can Intel release a 3.6F with a roughly comparable cost to the 3500+ but with the same performance as the xeon 3.6?

    Also, if the cpu choice was correct...why did you then switch to the opeteron 150?

    Thanks in advance.
  • KristopherKubicki - Thursday, August 12, 2004 - link

    Lynx516:

    I posted the GCC -v at the beginning of the review, please let me know if there is something else i should do.

    Kristopher
  • KristopherKubicki - Thursday, August 12, 2004 - link

    To be honest i wouldnt have known some of the mistakes i made had people not been so critical. I am not upset with the final outcome, it happens to everyone.

    Kristopher
  • Lynx516 - Thursday, August 12, 2004 - link

    Sorry to be a bit harsh there Kris but they are not in the standard GCC3.3.3 manual which I was using as a reference. It would be nice to state that you are using a ported compiler in your config to prevent any future confusion. Though its a pretty good article over all. much better than some recent ones on Anand. I hope this standard is kept up.

    Humblest appologies
    Lynx
  • Spectre999 - Thursday, August 12, 2004 - link

    I posting because I was complaining about the first review on another board. The first review was horribly done.

    But it takes a real stand up person to take all the bitching that went on and be able to go back and look at what they did and decide to redo it because they made a mistake. For that I will give you much praise. The other hand is the first review shouldn't have been turned in the way it was but it isn't always the way someone does something that is the most important but the way they respond to the criticism they get.

    So thanks for all the effort on redoing the article and you provided you are a stand up guy who simply made a mistake. It happens and everyone can move on.

  • manno - Thursday, August 12, 2004 - link

    "Now will all of you A-Holes get off KrizK's & AT editorial staff's back!!"

    HAHHAHAHAHAHA I'm laughing my ass off.
    Great Job getting in the first post, and a good first post at that.

    -manno
  • hifisoftware - Thursday, August 12, 2004 - link

    Good review. All sins are forgotten now :-)

Log in

Don't have an account? Sign up now