Dual CPU Database Server Comparison
- Posted in
- IT Computing
Benchmarks MySQL 3.23.52: Intel versus AMD

A Linux database server report would not be complete without the open source database MySQL. It must be said that MySQL results had a large margin of error, especially at high levels of concurrency. At 100 concurrent threads, MySQL started to lose performance pretty quickly, and the margin of error grew fast. When we limit ourselves to a concurrency of 50, we get a decent margin of error (2% - 4%).
| conc lev | Dual Xeon 3,6 GHz | Dual Xeon 3,2 2 MB L3 | Dual Xeon 3.2 | Dual Xeon 3.06 1 MB L3 | Dual Xeon 3.06 | Opteron 250 DDR400 32 bit | Dual Opteron 250 DDR 400 64 bit | Dual Opteron 848 DDR400 - 64 bit |
| 1 | 127 | 105 | 107 | 110 | 104 | 156 | 201 | 190 |
| 2 | 191 | 166 | 161 | 175 | 158 | 249 | 317 | 287 |
| 5 | 239 | 206 | 194 | 206 | 189 | 303 | 368 | 337 |
| 10 | 249 | 221 | 203 | 218 | 194 | 289 | 381 | 353 |
| 20 | 251 | 226 | 195 | 218 | 190 | 309 | 403 | 377 |
| 35 | 259 | 226 | 190 | 223 | 189 | 315 | 405 | 375 |
| 50 | 251 | 225 | 186 | 222 | 185 | 300 | 388 | 363 |
Those were the raw numbers. Let us now analyze this:
| conc lev | Xeon 3.6 vs 3.2 | 2 MB L3-cache vs none | 1 MB L3-cache vs none | Xeon 3.2 vs 3.06 | Xeon 3.2 vs 3.06. both with L3 | Xeon 3.6 vs Opteron 250 | Opteron 64 bit vs 32 bit |
| 1 | 20% | -2% | 7% | -5% | -5% | -19% | 29% |
| 2 | 15% | 3% | 10% | -5% | -5% | -23% | 27% |
| 5 | 16% | 6% | 9% | 0% | 0% | -21% | 22% |
| 10 | 13% | 9% | 12% | 1% | 1% | -14% | 32% |
| 20 | 11% | 15% | 15% | 3% | 3% | -19% | 30% |
| 35 | 15% | 19% | 18% | 1% | 1% | -18% | 29% |
| 50 | 11% | 21% | 20% | 1% | 1% | -16% | 29% |
MySQL paints a totally different picture. Again, don't pay too much attention to the results of the lower concurrency levels.
This time, the Nocona Xeon is about 11% to 15% faster, more or less equal to the clock speed advantage of 13% that it has over the other Xeon brothers. Investing in large L3-caches pays off a lot more than it did in DB2. It seems that a 1 MB L3-cache is exactly what our application needs because that much delivers almost no boost at all (the margin of error may blur the results a bit).
And last, but not least, the Opteron makes a clean sweep of the Xeons. The 3.6 Nocona is up to 30% slower. When the Opteron moves to 64 bit, it can crunch through 30% more SQL statements.
Originally published at https://www.anandtech.com/show/1559 (Wayback Machine).