MySQL Configuration

To get an idea what a typical SLES 10 user will experience, we simply used the MySQL version which is supported by the latest SLES 10 SP1, i.e. MySQL 5.0.26. Unfortunately, this means that we see the typically bad scaling. Therefore we focus on the single CPU, dual core results. It doesn't make sense to use a quad Xeon 5345 here: more than two CPUs give negative scaling as we have reported before. The 2.33GHz Xeon 5345 scored between 700 and 750 queries per second as a result of this. For those who are surprised by this: notice that Intel's own benchmarks use four parallel runs of the Sysbench MySQL benchmark to get higher scores out of MySQL. All testing was done with InnoDB as our storage engine in MySQL 5.0.26. Here is our MySQL configuration:

MySQL Configuration
default-storage-engine InnoDB
skip-external-locking  
skip-locking  
key_buffer 256M
.
table_cache 64
max_allowed_packet 1M
thread_stack 128K
.
sort_buffer_size 2M
read_buffer_size 2M
innodb_buffer_pool_size 1G
.
thread_concurrency 16
innodb_thread_concurrency 16
innodb_additional_mem_pool_size 8MB
read_rnd_buffer_size 8MB
thread_cache 64
max_heap_table 256MB
tmp_table 128MB
.
innodb_log_file_size 250MB
innodb_table_locks 0
innodb_flush_log_at_trx_commit 0
max_user_connections 2000
max_connections 2000

The "query cache" was off, as we wanted to test worst case performance. Our test database is still the same 1GB database. The workload consists of more than 90% selects, mostly a "read intensive" workload. All numbers are expressed in queries per second (Y-axis), and the X-axis shows the number of concurrent accesses.

MySQL results



The Xeon 5160 keeps a 10-14% lead on the Opteron 2224. Our time was limited, and you'll see other versions of MySQL pop up in later reviews. The first results seem to indicate that the difference between the Opteron and Xeon gets smaller.

SPECjbb2005 Render Servers
Comments Locked

30 Comments

View All Comments

  • Spoelie - Monday, August 6, 2007 - link

    Thanks for the clarification, I was under the impression the only real states were idle (1ghz) and full tilt (3.2ghz). Never seen any other states but all I ever use are the desktop chips, I wasn't aware CnQ could be more dynamic than that.
  • yuchai - Monday, August 6, 2007 - link

    I believe all A64 chips including the desktop ones have the different power states. For example my X2 4200+ has 4 states. 1.0, 1.8, 2.0 and 2.2 Ghz.
  • ButterFlyEffect78 - Monday, August 6, 2007 - link

    Are they talking about the barcelona?

    If not, then this is old news.

    I'm sure everyone by now knows that intels new cpu's are better then the current AMD opterons.
  • KingofFah - Monday, August 6, 2007 - link

    It really isn't. The were demonstrating the new 3.2ghz opteron. Also, this was a dual socket setup, and anand said, and everyone who monitors the server world knows, that the opterons come out ahead overall in the 4S environment.

    The more sockets, the more performance advantage opterons have on intel in the server space. This is well known. The purpose of this was to show it in the dual socket environment.
  • duploxxx - Monday, August 6, 2007 - link

    confused, no it is the stupidity of people like you that think that all Intel offerings are better then the ones for AMD.

    @anand, you're conclusion of the database world that the quadcore still rules..... where are the benchmarks?

    now it is nice to see all these benches next to each other, when are you going to combine benches, no longer servers are used for one application, they are more combined these days with more apps. Maybe its time you also have a look at vmware esx etc.... will probably give you a different look at the offerings of AMD these days.
  • clairvoyant129 - Monday, August 6, 2007 - link

    You don't have to get hostile because he does have a point. In the desktop market, Intel is clearly better unless we're talking about low end. Server market, it's still a toss up but Intel still has a lead.
  • yyrkoon - Monday, August 6, 2007 - link

    Um, you guys obviously have not been paying much attention have you ?

    1) AMD CPUs=cheaper
    2) AMD CPUs of comparrible speed perform nearly as good if not as good or better than their Intel counterparts. ie: I think you better check the last benchmarks anandtech post 'homie', because I saw a lot of AMD on top of the game benches. (6000+ vs e6600).
    3) Yes, a C2D *may* overclock better, and if it is you intention to overclock, it makes perfect sense to buy one, just be prepared to pay more for the CPU.
    4) Up until recently, or possibly still happening into the near future, AMD system boards availible often offered more features for less cost. It does seem however with the P35 Chipset, vendors are starting to come around.
    5) last, but not least, THIS article IS NOT about desktop hardware now IS IT ?! why bring some stupid lame ass coment into some place that it does not even fit ? GOd, and I thought I needed a new life . . .
  • Final Hamlet - Monday, August 6, 2007 - link

    It is these "but"s, that make the difference.
    If they exist, you can't state "all Intel CPUs" anymore, because there are exceptions.
  • ButterFlyEffect78 - Monday, August 6, 2007 - link

    I'm sorry everybody.

    English is my 2nd language so I sometimes can't always express what I want to say.

    What i meant to say is that Intel's new line of cpu's based on Core 2 duo tech. are better-(more advanced) then those based on K8 technology. If this is not true then there should not be a reason to introduce the K10 later this year to counterattack core 2 duo/quad.

    But again, I could be wrong.
  • Calin - Monday, August 6, 2007 - link

    Core2Duo technology from Intel is better overall than the K8 technology from AMD - this includes basic architecture, current improvements on the initial architecture (K8 is older and has more of those small improvements), and process/production technology.
    However, Intel lagged in introduction of Core2 based server processors, and even now their FBDIMM technology is slower and hotter (power hungry) than AMD's Opteron/DDR. Until this changes, AMD still has a market in servers, albeit not as good as before the Core2Duo Xeon processors.

Log in

Don't have an account? Sign up now