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.
Facebook
Twitter
RSS
88 Comments
View All Comments
minaoBini - Sunday, May 3, 2020 - link
https://ecrimea.net/voip">Офисные АТС и https://ecrimea.net/voip">IP телефония в Крыму.Компания https://tritel.net.ru">Tritel, участник https://acosc.ru">Ассоциации Кабельных Операторов Связи Крыма, предоставляет услуги безлимитного доступа к сети https://tritel.net.ru/internet">Интернет для жителей Симферополя с возможностью подключения к сети на скорости 100Мбит/с.
https://tritel.net.ru">Подключить интернет в Симферополе. Бесплатное https://tritel.net.ru/ktv">кабельное телевидение в Симферополе. услуги https://tritel.net.ru">безлимитного интернета всего за 360 рублей. У нас Вы можете https://tritel.net.ru">подключить интернет всего за сутки.
https://tritel.net.ru">Интернет провайдер в Симферополе.
Telco - https://ecrimea.net/voip">Телефония в Крыму.
youtubetomp3R584 - Monday, May 18, 2020 - link
Hello folks, just came across your articles, really appreciate your works!Would like to share some useful website, hope you like it.
https://flvto.ch/">Youtube Converter
https://y2mate.ch/en1/">Youtube downloader
https://keepvid.ch/id4/youtube-video-downloader">Youtube video downloader
https://ytmp3.ch/">Youtube to mp3
https://listentoyoutube.ch/en1/Youtube-to-mp4/">Youtube to mp4
https://makemkv.us/">makemkv reviews and alternative of 2020.
https://redfox.works/">redfox reviews and alternative of 2020.
furnitureblugh - Monday, May 18, 2020 - link
Top 10 furniture of america / https://www.furnitopia.com">kids furnitureOur online store international company provides discount, write in an online chat.At the present time you are in best Our оnline store specialized firms in Bel air products for garden and home use and office modern lighting stores los angeles. Firm sells over 5000 products for a country house and houses or cafe-bar and piece of furniture.Natural tree, the that are used for the purpose products, has at its disposal reliability and wear resistance, delightful external data. All pieces of furniture processed particular compounds, because of which their surface does not absorb water, resistant to extremes temperature and influence of the sun. Wicker furniture excellent retains its functions even in cafe in open spaces. We catalog for you offered photographs furniture for dining room, hall, bedroom, children's room, as well as intended for storage of things - cabinets, chests of drawers and many others. We are waiting client visit our large online store, company in Miracle milethat appreciates all of its shopper. On portal our store you waiting colossal choice at cost. Our catalog contains price lists, Label data about types details potential kinds complete modules.Each item furniture produced directly from factory manufacturer. Decrease prices on Label achieved based on the absence of trade floor space, for rent which necessary pay and smallest staff workers. Minimum costs enable to establish affordable prices for every buyer for all groups goods. Want update your interior? Read carefully the news products home from modern collection, in her represented as products with colorful floral patterns and colors and products with chic texture finish metallic. Furniture Items for the garden is rightfully considered necessary attribute each modern housing. In the presented store online you can buy reliable furniture for garden and home in SANTA MONICAto you all furniture at desired time day.Prices, that provides online shop furniture items BEL AIR AND HOLMBY HILLS very visitor.As a rule small fee may cause certain questions regarding good quality products affordable modern contemporary furniture. The catalog which filled diverse items furniture composes only first-class factory products.
SandraRaf - Sunday, May 24, 2020 - link
The best adult Dating site loveawake.ruDanielacuct - Wednesday, May 27, 2020 - link
Here girls want to get acquainted! / http://datingsites.site/">Go to the site, register and look for a girl for sex.https://picturelol.com/y2gs8l6ofhc2/photo_2019-07-...">[IMG]https://img250.picturelol.com/th/34981/y2gs8l6ofhc...[/IMG] https://picturelol.com/j4ehnaegpe60/photo_2019-07-...">[IMG]https://img250.picturelol.com/th/34981/j4ehnaegpe6...[/IMG] https://picturelol.com/ttyt68thdvfu/photo_2019-07-...">[IMG]https://img250.picturelol.com/th/34981/ttyt68thdvf...[/IMG]
https://picturelol.com/w23rcc12vw2t/photo_2019-06-...">[IMG]https://img250.picturelol.com/th/34981/w23rcc12vw2...[/IMG] https://picturelol.com/jg08y2igopx8/photo_2019-06-...">[IMG]https://img250.picturelol.com/th/34981/jg08y2igopx...[/IMG] https://picturelol.com/8hk6b5wz6bxl/photo_2019-06-...">[IMG]https://img250.picturelol.com/th/34981/8hk6b5wz6bx...[/IMG]
https://picturelol.com/pnpvfk1ikl9p/photo_2019-05-...">[IMG]https://img250.picturelol.com/th/34981/pnpvfk1ikl9...[/IMG] https://picturelol.com/3q9jtu1zet45/photo_2019-05-...">[IMG]https://img250.picturelol.com/th/34981/3q9jtu1zet4...[/IMG] https://picturelol.com/h7jphhrf9cdg/photo_2019-05-...">[IMG]https://img250.picturelol.com/th/34981/h7jphhrf9cd...[/IMG]
https://picturelol.com/u6qauusqs89b/photo_2019-07-...">[IMG]https://img250.picturelol.com/th/34981/u6qauusqs89...[/IMG] https://picturelol.com/7wm6y6m66v8t/photo_2019-07-...">[IMG]https://img250.picturelol.com/th/34981/7wm6y6m66v8...[/IMG] https://picturelol.com/k28pm0d5tb7f/photo_2019-07-...">[IMG]https://img250.picturelol.com/th/34981/k28pm0d5tb7...[/IMG]
https://picturelol.com/y7qsac7nn04b/photo_2019-05-...">[IMG]https://img250.picturelol.com/th/34981/y7qsac7nn04...[/IMG] https://picturelol.com/h52xd1l159cg/photo_2019-05-...">[IMG]https://img250.picturelol.com/th/34981/h52xd1l159c...[/IMG] https://picturelol.com/exxvnvkqm76w/photo_2019-05-...">[IMG]https://img250.picturelol.com/th/34981/exxvnvkqm76...[/IMG]
#best_girls_good#
KevinSoomo - Wednesday, June 3, 2020 - link
Наш знаменитый холдинг безграничным навыком в сфере производства телеинспекция трубопроводов и дополнительно производственных услуг, компания является производителем высококачественных работ для большинства ведущих фирм в стране. Наши сегодняшние квалифицированные услуги по телеинспекция каналов легкодоступны в Клинцы, затем чтобы оказать экономически действенность решения с целью всех разновидностей объектов. Наш специализированный холдинг для вас изготовление, современное строительство, ввода в эксплуатацию и поддержки. Консультационные услуги по моментам монтирования и цены их задач. Мы работаем как в угоду невеликих, так и в угоду крупных объектов, реализуя методы для произвольного фирмы где необходимы оборудование для телеинспекции скважин. Наше специализированное предприятие всегда готова предоставить знающий обслуживающий персонал в целях монтирования телеинспекция трубопроводов цена на предприятие заказчика. Как только лично вы выбираете нашу компании в качестве исполнителя, вы получите организацию с совершенным ассортиментом сервисных услуг.https://gmgd.ru/">Телеинспекция ливневой канализации
Putinhax - Wednesday, June 24, 2020 - link
Putin - sql courses - https://www.youtube.com/c/ExcelStore excel training excel courses excel lessons sql training sql courses sql lessonsnovostroyka63ker - Tuesday, June 30, 2020 - link
https://novostroyka63.ru/">Фундамент для забора ценаСоздание дома вашей мечты - это оригинальная возможность, спланировать и претворить в жизнь нечто воистину уникальное во всех отношениях. Возведение фундамента - это в целом первоначальная модель ремонта, в процессе которой домик строится. При расчете замена фундамента под старым деревянным домом цена предусматривается весьма много факторов. Средняясумма возведения домов фундамента составляет приблизительно от 10$ за кв.метр . Погреб сможет умножить итоговую стоимость каждого объекта недвижимости, предоставляя необходимое помещение ради организации хранения и порой рабочее пространство. Наша профессиональная команда по конструированию и возведенью фундамент под памятник на кладбище цена может помочь выстроить жилище, о котором вы всегда мечтали. От начала до конца наша специализированная компания в Череповец позаботимся о всех без исключения процессах, чтобы заказчику не довелось тревожиться о деталях. Специализированная международная компания в Киселевск несет юридическую ответственность за проект, а не вы, именно поэтому организация в Борисоглебск имеют интерес в том, затем чтобы довести до конца строительство коттеджа быстрее и эффективнее. Узнайте о сваи винтовые для фундамента цены в вытегре у спспециалистовециалистов корпорации.
cleansab - Wednesday, July 8, 2020 - link
https://www.cleaning-master.com">Deep cleaningService Cleaning Staten Island was created in 2012 with a clear task: to perform a highly professional cleaning services in friendly manner that is not only which not just delights and satisfies all ours client! With deep cleaning, our employees cleansing elements refrigerator in the house . Competent employees "Cleaning Service" always ready decide varied problem, associated with guidance order. You always can call in "Cleaning Service" - our employees to the conscience cope with the work of any volume. Our Created Cleaning the holding located give you any help and solve this a problem! Our firm we carry out cleaning services(MAIDS DOWNTOWN) exclusively by means of eco-means, they absolutely safe and not even litter environment atmosphere. This the specialized company Williamsburg presents large set service on cleaning, you left only to choose the right, appropriate to you type of cleaning, and contact to our company for professional help. In our the company hourly work employee. This a highly large cleaning , that will leave your family hearth spotless . Regardless on , moving you or not Clean Master can be there to help to bring your personal old or new house exemplary appearance.We have involved only qualified masters, having the required practical experience. CLEANING MASTER Bococa apply excellent, not harmful detergents and scouring materials, reliable, professional and high quality equipment.Our organization provides services for cleaning - professional (industrial) cleaning. Cleaning famous company Clinton Hill- carries out production activity on cleaning.
JimmieGaums - Thursday, July 9, 2020 - link
Ищите Нас...#Hookahmagic
Мы всегда с Вами и стараемся нести только позитив и радость.
Ищите Нас в соцсетях,подписывайтесь и будьте в курсе последних топовых событий.
Amy,Tortuga,Alfa Hookah...
Строго 18+