Intel's newest Quad Xeon MP versus HP's DL585 Quad Opteron
by Johan De Gelas on November 10, 2006 12:00 PM EST- Posted in
- IT Computing
MySQL Configuration
As our loyal readers know from our previous MySQL adventures, the MySQL database is a highly tweakable but somewhat badly scaling database. Most workloads scale well from one to two cores, but from two to four cores scaling is very mediocre, and in the "SELECT intensive" workload that we benchmark even negative. This has surprised quite a few people, but it is an issue that the InnoDB team is well aware of, and the issue will be resolved in one of the next releases of InnoDB. Until then, we compiled version 5.0.26 with Peter Zaitsev's Mutex patch. This Patch gives much better scaling and performance. Scaling is no longer negative, and we saw a 20% to 40% increase going from two to four cores. However, our workload still doesn't scale beyond four cores, so we tested all CPUs with two CPUs and four cores. That way we have at least an impression on how the different server CPUs compare.
All testing was thus done with InnoDB as our storage engine in MySQL 5.0.26. We optimized for a server with 4GB of RAM. 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.
MySQL results
All numbers are expressed in queries per second (Y-axis), and the X-axis shows the number of concurrent accesses.
On average is the Xeon DP 5160 is about 22% faster than the Opteron. That means that the Opteron is clock for clock as fast as the Xeon 5160, which is not bad news for AMD at all, although Woodcrest currently has the raw clock speed advantage. Considering the HP DL585 can only use DDR-333 with the Opteron 880, the picture might even get better with the DL885 which can use DDR-400.
There is little doubt that MySQL is not the favorite application of the Xeon MP: the Opteron 880 beats Xeon MP by 20% to 30%. We have seen this before as the Opteron has always outrun "NetBurst" based CPUs in MySQL. The good news for Intel is that the new Core architecture is no less than 52% faster in MySQL when we compare the 3 GHz Xeon DP with the 3.2 GHz Xeon MP.
We also noted something strange: the Xeon MP performs better with hardware prefetch disabled. Below you can see our findings. All numbers are expressed in queries per second served by the server (Y-axis); and the X-axis shows the number of concurrent accesses.
Hardware prefetch lowers performance by about 1% to 4%, while Hyper-Threading allows the Xeon MP to make better use of its potential and increases performance by 7% to 9% at the higher concurrencies.
As our loyal readers know from our previous MySQL adventures, the MySQL database is a highly tweakable but somewhat badly scaling database. Most workloads scale well from one to two cores, but from two to four cores scaling is very mediocre, and in the "SELECT intensive" workload that we benchmark even negative. This has surprised quite a few people, but it is an issue that the InnoDB team is well aware of, and the issue will be resolved in one of the next releases of InnoDB. Until then, we compiled version 5.0.26 with Peter Zaitsev's Mutex patch. This Patch gives much better scaling and performance. Scaling is no longer negative, and we saw a 20% to 40% increase going from two to four cores. However, our workload still doesn't scale beyond four cores, so we tested all CPUs with two CPUs and four cores. That way we have at least an impression on how the different server CPUs compare.
All testing was thus done with InnoDB as our storage engine in MySQL 5.0.26. We optimized for a server with 4GB of RAM. 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.
MySQL results
All numbers are expressed in queries per second (Y-axis), and the X-axis shows the number of concurrent accesses.
On average is the Xeon DP 5160 is about 22% faster than the Opteron. That means that the Opteron is clock for clock as fast as the Xeon 5160, which is not bad news for AMD at all, although Woodcrest currently has the raw clock speed advantage. Considering the HP DL585 can only use DDR-333 with the Opteron 880, the picture might even get better with the DL885 which can use DDR-400.
There is little doubt that MySQL is not the favorite application of the Xeon MP: the Opteron 880 beats Xeon MP by 20% to 30%. We have seen this before as the Opteron has always outrun "NetBurst" based CPUs in MySQL. The good news for Intel is that the new Core architecture is no less than 52% faster in MySQL when we compare the 3 GHz Xeon DP with the 3.2 GHz Xeon MP.
We also noted something strange: the Xeon MP performs better with hardware prefetch disabled. Below you can see our findings. All numbers are expressed in queries per second served by the server (Y-axis); and the X-axis shows the number of concurrent accesses.
Hardware prefetch lowers performance by about 1% to 4%, while Hyper-Threading allows the Xeon MP to make better use of its potential and increases performance by 7% to 9% at the higher concurrencies.
88 Comments
View All Comments
BradleyNow - Tuesday, September 1, 2020 - link
Приветствую!Нашел познавательную фотосессию на этом сайте: http://limonos.ru :
http://limonos.ru/772-zhenschiny-kotorye-izmenili-... Женщины, которые изменили историю
http://limonos.ru/9370-start-kosmicheskogo-korably...
http://limonos.ru/gifki-gif-animacii/">gif ru ass gif
Georgebug - Monday, September 7, 2020 - link
Всем привет!Нашел интересную тему на этом сайте: http://watafak.ru :
здоровьесберег технологии http://watafak.ru/tekhnologii_gadzhety/
новости шоу бизнеса сегодня свежие http://watafak.ru/novosti-shou-biznesa/
http://watafak.ru/foto-prikoly-interesnoe/4898-mol... Молочные реки, кисельные берега
http://watafak.ru/foto-prikoly-interesnoe/3376-fot..."> Фотограф Nathaniel Goldberg Фотограф Nathaniel Goldberg Натаниэль Гольдберг (Nathaniel Goldberg) — знаменитый портретный и фэшн-фотограф. Родилась и выросла в Париже. Живет
http://watafak.ru/foto-prikoly-interesnoe/3441-kak...
Ronaldlig - Monday, September 7, 2020 - link
watch breaking dawn part 2 online vodlockerhttp://saikerutochi39.zapto.org/92.html">surfacetoair
varutha padatha valibar sangam movie dialogues ringtones
http://zansatein41.myvnc.com/2.html
Josephwet - Monday, September 7, 2020 - link
Всем привет! класный у вас сайт!Нашел прикольную базу кино: старые комедии онлайн бесплатно в хорошем качестве http://kinoserialtv.net/">http://kinoserialtv.net/
Здесь: смотреть бесплатно лучшие семейные фильмы http://kinoserialtv.net/semeynyy/ список 2020
Здесь: фантастика 2020 список лучших фильмов смотреть http://kinoserialtv.net/fantastika/ список 2020
Здесь: http://kinoserialtv.net/fentezi/">смотреть лучшие фильмы фэнтези в 720 hd онлайн хорошая качества фэнтези рейтинг 2020
Здесь: http://kinoserialtv.net/2595-chasti-tela-nip-tuck-... Части тела / Nip Tuck (Сезон 1-7) (2003-2010) смотреть онлайн бесплатно
Тут: Свинячий восторг: реакция актеров из «Звездных войн» на новый трейлер http://kinoserialtv.net/9418-svinyachiy-vostorg-re..."> Свинячий восторг: реакция актеров из «Звездных войн» на новый трейлер
Michaelsleks - Tuesday, September 8, 2020 - link
Привет! Класный у вас сайт!Что думаете по этим новостям?:
http://energynews.su/41808-raschlenennoe-svetilo-v... «Расчлененное светило»: В Новомосковске заметили атаку Нибиру на Солнце - очевидец
http://energynews.su/37139-otstavka-lavrova.html
http://energynews.su/news/">лета новости новости мира сегодня
Ещё много всего нашел тут: новости в политике России сегодня http://energynews.su/"> новости экономики России
PeterBoace - Saturday, September 12, 2020 - link
bmc remedy software https://www.prevencionintegral.com/comunidad/forum...">https://www.prevencionintegral.com/comunidad/forum... dermatitis natural remediesCarRox - Saturday, September 12, 2020 - link
https://megaremont.pro/podolsk-restavratsiya-vann/...">Eliminate the chips on the bath Podolsk enamelCindyFah - Sunday, September 13, 2020 - link
Сделал заказ 14.07.2020 на контрактный двигатель для Ford Focus II Sedan в организации Магазин Online автозапчастей "AutoLTD" https://autoltd.ru/"> мошенники кидают людей как потом узнал . Сразу на почту пришло письмо как всегда при заказе с интернет магазина приходит подтверждение. Далее хотел заплатить, но почему-то скидывает автоматом на сайт яндекс деньги. Не стал оплачивать сразу. 15.07.2020 примерно в 11 часу позвонила девушка ну и как обычно бла-бла-бла такой то сайт, заказывали такая то-такая то контрактный двигатель, такой то адрес. Ну я подтвердил . Сказали заказ приняли ждем оплату. Я спросил ее что меня скидывает на яндекс деньги, он ответила что все нормально мы работаем через яндекс кошелек . Ну я и заплатил с карты сбербанка. Сразу на почту пришло оповещение что такой то заказ оплачен и т.д. После пришло письмо что все хорошо ждите заказа от 3 до 5 дней. А так как я нахожусь в Туле от Москвы 190 км решил что это норм. Сегодня решил написать письмо и узнать что да как. Но ни кто на письмо не ответил. Зашел на их сайт и решил позвонить на горячую линию, на номер +7 985 263 03 33, но вот не задача телефон долго думает , а после просто отключается и все. Ну пока я пытался дозвониться появился оператор в чате. Я спросил, мол такой то номер заказа — заказ 4596887.После не продолжительной паузы пришел ответ что планируемая дата доставки 22.07.2020. Ну я обрадовался ответил спасибо и закрыл чат. Позже понял и я решил почитать отзывы об этом сайте. Много искал, но нашел и типа лохотрон и типа спасибо. Вечером включил комп и что я вижу? Страница сайта не загружается. Пишет что таковой сайт не существует . Решил снова набрать номер горячей линии и опять таже тишина, я понял телефон https://autoltd.ru/"> +7 985 263 03 33 принадлежит жуликам и мошенникам .Чует мое сердце, что по ходу я подарил свои деньги мерзавцам. Подожду еще завтра, а после распечатаю в онлайнбанке квитанцию перевода и отправлюсь в милицию заявление писать. А потом если ничего не примут и в прокуратуру. Вот потом хорошие магазины страдают из-за этих мошенников, что спокойно обувают и сваливаются. После такого боишься что либо покупать в интернете с сайтов, в каждом видешь подвох. При всем этом они даже не стесняются. Ладно буду ждать что да как. Движок хотел сменить на форд фокус 2 уже старенький и стучит хотел сделать своей жене подарок. А как получается подарок сделал http://auto-ltd.com/"> жуликам и мошенникам из Магазин Online автозапчастей "AutoLTD"
Чтобы остальные не попались как я скидываю адреса мошенников
магазина Online автозапчастей "AutoLTD" - http://auto-ltd.com/"> осторожно мошенники кидают людей
https://autoltd.ru/ - https://autoltd.ru/"> осторожно мошенники кидают людей
http://auto-ltd.com/ - http://auto-ltd.com/"> осторожно мошенники кидают людей
https://www.instagram.com/autoltd_cp/ - https://www.instagram.com/autoltd_cp/"> осторожно мошенники кидают людей
https://vk.com/club108466068 - https://vk.com/club108466068"> осторожно мошенники кидают людей
+79852630333 - осторожно мошенники кидают людей
MasdirGok - Monday, September 14, 2020 - link
https://maybeloan.com/">[img]https://a.radikal.ru/a28/2009/76/565c6e212080.jpg[/img]Better part of men in Canada, Europe, and the Unites States of America requirement more dollars even years. According to different data, more than 60% of working guys can’t satisfy their needs. That is why different loans from websites are in demand nowadays. You could find the best loan, using verified websites. Usually, guys like to get a tille loan, because these types of loans probable to transfer to private e-wallet very fast.
Americans know about a new option, that is why many families from the United States like using loan options, then alternative banks. A lot of young guys dealing with a financial emergency don’t trust national banks. Generally, banking houses asking about clear revenues. Different supervisors could ask about year earnings.
Likewise, Americans prefer to change their work from year to year. It is the global reason, why banks don’t provide cash advance. If you want to obtain fast loan, the best way – visiting the link, where possible to get an instant loan. With the development of startups, men like using iOs and Android devices. You can get a payday loan at iOs or Android. At maybeloan.com there are many variants for loans. The best online money system gives out money to different e-wallets: PayPal, Skrill, Payeer, AdvCash, etc.
At the website really specifically receive cash with U.S. and European Union passports. If you need long-term credit or you need https://maybeloan.com/payday-loans/in">payday loans in Indiana you can get money without a good credit history. Instead of necessarily preparing a stack of papers, you can use various variants at the site and find different variants of a short-term loan.
There are a lot of benefits to a personal loan. Instant cash possible to use in different types of vacation. If you need cash for marriage, instant dollars will be a good variant of solving different marriage items. However, it is probable to use cash for diverse marriage costs. If the cashbox will ask you about insurance or other assets, maybeloan company don’t require pledging of different collateral.
If you want to find the best type of student loan, it means that you are a student and would like to search the best condition. The best solution – personal loan, which supports you in a hard time. Long-term loans from maybeloan web service have a lot of pluses. It means, that you need to have minimum papers. Specialists from the digital store don’t ask you about collateral. All process is very ordinary and easy, cause of diverse sum it is very easy to get. Even you wish to get money for renting a car or vacation, specialists don’t ask you about how you will spend a cash.
Web loans possible receiving if your inquiry will be approved. As rule, more than 98% of clients are approved. That is why guys like maybeloan online service and using it when they have a financial crisis. Bad checks and fees in banks make you unhappy?
Don’t worry about the rates and another items. You should choose between the best short-term option and then you can get your payment. If you don’t know, how it better to transfer cash back with PayPal, you may use Visa or MasterCard card from a diverse bank and transfer cash from your account to the company account.
There are many advantages to this type of credit, for example:
- The process of transferring of request takes five minutes;
- The instant cash probable to receive, making a click on the table "Interested";
- Online service working every day and every night;
- Free web financial questions for support;
- Clear dollars without criminal history;
- No additional fees;
- Fast cash with the support of a site or app.
In people's minds, fast cash could help everyone. But it is very intricate to receive an instant loan, that is why better to borrow cash in the digital area.
MalAdurb - Thursday, September 17, 2020 - link
https://megaremont.pro/domodedovo-restavratsiya-va...">Domodedovo restoration of baths