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:
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.
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.
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.