The IBM POWER8 Review: Challenging the Intel Xeon
by Johan De Gelas on November 6, 2015 8:00 AM EST- Posted in
- IT Computing
- CPUs
- Enterprise
- Enterprise CPUs
- IBM
- POWER
- POWER8
Database Performance: MySQL
Both MySQL and PostgreSQL do not scale well enough to make use of 72 threads (Dual Xeon E5), let alone 160 threads (Dual POWER8). We installed Percona MySQL Server 5.6, which is the most scalable InnoDB based MySQL server.
We used the MySQL Sysbench benchmark, but we limited MySQL with taskset to run on 4 or 8 physical cores. We verified that this was actually the case by running "nmon" on top of the IBM server.
You can clearly see that the first 32 threads are used (CPU 0 - 7).
Sysbench allows us to place an OLTP load on a MySQL test database, and you can chose the regular test or the read-only test. We chose read only as even with solid state storage, Sysbench is quickly disk I/O limited.
We tested with 10 million records and 100,000 requests. The main reason why we tested with Sysbench is to get a huge amount of queries that only select very small parts (a few or one row) of the tables, Sysbench allows you to test with any number of threads you like, but there is no "think time" feature. That means all queries fire off as quickly as possible, so you cannot simulate "light" and "medium" loads.
The response times are very small, which is typical for an OLTP test. To take them into account, we are showing you the highest throughput at around 3-4 ms. As the results tend to vary a bit, we give you the average of three runs.
With only 4 cores active, the Xeon E5-2699 v3 is still running at 3.3 GHz. Once we use 8 cores, the clockspeed lowers to 2.9 GHz, and the POWER8 outperforms the best Xeon by a small margin. However, we are only testing a part of the CPUs, similar to running only one VM. Ultimately what this means is that total performance will be:
- the POWER8 will be around 36k (14400/8 * 20 cores)
- the Xeon E5-2699 v3 will be around 60k (13400/8 * 36 cores)
- the Xeon E5-2695 v3 will be around 45k (13000/8 * 28 cores)
So the current MySQL performance on top of POWER8 is good, but MySQL runs still a lot better on the Xeons.
Facebook
Twitter
RSS
146 Comments
View All Comments
JohanAnandtech - Saturday, November 7, 2015 - link
Ok, Europe adopt the dot, but maybe the US can adopt the metric system like the rest of the world? :-)bitaljus - Saturday, November 7, 2015 - link
or better yet recode this site to see from what country u are visiting and use the appropriate denote thousands symbol, appropriate metric system and even time for the viewer. how meany time i was irradiated when i need to google something like this just to make it in local. and this is easy to do in the site natively. (P.S. Sorry for bad English, not native)nils_ - Wednesday, November 11, 2015 - link
The browser already sends a header with Accept-Language, which should be the preferred way to for the web site to determine locale. For example, I live in Germany so my browser will send en, en_UK, en_US, de and DE (this can be set somewhere in the settings). Now you can determine the language and other localisation based upon that, and there are tools where you can set the locale to then display dates, times etc.. based n that.Many sites instead use Geolocation based on the IP address, which can be really awkward when you travel to a country where you can't read the language.
ZeDestructor - Saturday, November 7, 2015 - link
Even within EU it's not consistent.. UK uses commas for thousands, dot for decimal (and that's why the US and most anglophone countries use the same setup), Germany, Netherlands and France on the other hand favour dots for thousands, commas for decimal, so you see it used there.. and in a great number of their former colonies where the language and culture has stuck.nils_ - Wednesday, November 11, 2015 - link
Dates / Time are even funnier, that's also extremely inconsistent and can be very misleading. Think for examle a date like 12/11/2015, in some countries it'll mean the 12th of November while in others it will mean the 11th of December, and sometimes even the 2015th of November in 11 AD ;)I remember reading on the GTA IV in-game "Internet" a travel guide to Europe that said the months here have 12 days but there are 30 months a year or something to that effect ;)
powchie - Friday, November 6, 2015 - link
let Johan do more reviews. been reading his stuff from late 90's and consider him the best then followed by Anand.Ryan Smith - Saturday, November 7, 2015 - link
Trust me when I say that if I could whip Johan any harder and make him work any faster I would be doing just that.;-)juhatus - Saturday, November 7, 2015 - link
When the Balrog showed up for work he had everyone fired.ruthan - Friday, November 6, 2015 - link
In summary should be something about software support, raw power is here, but software stack isvery limited.
PowerCPU is good for old legacy apps - SAP, Oracle etc.. but otherwise its dead end.
I would like to see comparision of IBM LPAR virtualization against Xeon Vmware solution, or Oracle / MySQL benchmark on power vs. Oracle benchmark on Xeon.
Server with Power even cant to run Crysis, or maybe some QEMU magic..
ruthan - Friday, November 6, 2015 - link
Pleas Ad edit button like other civilized sites, i was hurry when i wrote it.