The Intel Xeon E5 v4 Review: Testing Broadwell-EP With Demanding Server Workloads
by Johan De Gelas on March 31, 2016 12:30 PM EST- Posted in
- CPUs
- Intel
- Xeon
- Enterprise
- Enterprise CPUs
- Broadwell
MySQL 5.7.0
Thanks to the excellent repository of Percona, we were able to vastly improve our MySQL benchmark with Sysbench. However due to these changes, you cannot compare this with any similar Sysbench based benchmarking we have done before.
In updating our SQL benchmarking, we first upgraded the standard mysql installation to the better performing Percona Server 5.7. Secondly, we used sysbench 0.5 (instead of 0.4) and we implemented the (lua) scripts that allow us to use multiple tables (8 in our case) instead of the default one. This makes the Sysbench benchmark much more realistic as running with one table creates a very artificial bottleneck.
For our testing we used the read-only OLTP benchmark, which is slightly less realistic, but still much more interesting than most other Sysbench tests. This allows us to measure CPU performance without creating an I/O bottleneck. Our humble S3500 SSDs were fast enough in this scenario.
We used to apply all kinds of hacks to get around the limited scalability of both mysql and the way sysbench tested. Any version older than 5.5 could hardly scale beyond 8 cores. It is still not perfect, but MySQL uses the first 22 cores and 44 threads of the Xeon E5-2699 v4 amazingly well. We only get a 24% performance increase if we double the core count again with a second CPU, but we are honestly surprised that MySQL can now make good use of those 88 threads. Thanks to our better testing methods and a more scalable mysql, we can now report that the latest Xeon is capable of doubling the performance of the best Xeon that was launched 4 years ago. Well done Oracle, Percona, and Intel!
Facebook
Twitter
RSS
112 Comments
View All Comments
Casper42 - Thursday, March 31, 2016 - link
HPE just dropped the 64GB LRDIMMs a week or two back.They are now exactly 2x the 32GB LRDIMM as far as List Price goes.
LRDIMMs across the board are 31% more expensive than RDIMMs.
wishgranter - Tuesday, April 5, 2016 - link
http://www.techpowerup.com/221459/samsung-starts-m...wishgranter - Tuesday, April 5, 2016 - link
While introducing a wide array of 10nm-class DDR4 modules with capacities ranging from 4GB for notebook PCs to 128GB for enterprise servers, Samsung will be extending its 20nm DRAM line-up with its new 10nm-class DRAM portfolio throughout the year.nathanddrews - Thursday, March 31, 2016 - link
Perf/W is obviously a very exciting metric for server farmers and it generally exciting from a basic technology perspective, but it's absolute performance isn't amazing. Anyway, it's not like I'll be buying one anyway. LOLasendra - Thursday, March 31, 2016 - link
This interest me in so far as this would be the updated processors in a supposedly-coming-this-year Mac Pro refresh. Not that I would personally fork that much cash, but I'm interested to see how much of a jump they will make.But things seam rather bleak. No wonder they decided to wait 3 years for a refresh.
MrSpadge - Thursday, March 31, 2016 - link
Not sure which years you're counting in, but for the majority of us it takes 1.5 years from 09/2014 to today.https://en.wikipedia.org/wiki/Haswell_%28microarch...
asendra - Thursday, March 31, 2016 - link
Apple didn't update the MacPros with Haswell-EP. They are still using Ivy Bridgetipoo - Thursday, March 31, 2016 - link
Wonder what they'll do on the GPU side though. Too early for next generation 14nm FF GPUs from anyone, if Nvidia was even a choice due to OpenCL politics. Another GCN 1.0 part in 2016 would be...A bag of hurt.
Still waiting on the high end 15" rMBP to have something better than GCN 1.0...The performance, shockingly, hasn't come all that far from even my Iris Pro model. Maybe double, which is something, but I'd like larger than that to upgrade from integrated...
extide - Thursday, March 31, 2016 - link
Nah, if they refresh it late this year, like in august or something like that, then 14/16nm FF GPU's will be available.At worst we would get GCN 1.2, but yeah it would suck to see 28nm GPU's put in there...
mdriftmeyer - Thursday, March 31, 2016 - link
On what planet do you not grasp FinFET 14nm end of June from AMD?