80 core server and XtraDB

MySQL & MariaDB Other MySQL® Questions
1

Hello.
I plan to buy a new server based on 8 x Intel Xeon E7-8870 processors. Server is dedicated to MySQL. There are 80 physical cores (160 with HT). Can percona server (XtraDB) utilize all that cores and threads?

Where I can find benchmarks MySQL 5.5 vs Percona Server 5.5?

2

Hi,

It will help with CPU bounded load caused by many queries in parallel.
There are some benchmarks available between Oracle MySQL & Percona Server. You can check following.

[url]http://www.mysqlperformanceblog.com/2013/05/08/mysql-and-percona-server-in-linkbench-benchmark/[/url]
[url]http://www.mysqlperformanceblog.com/2012/02/23/percona-server-vs-mysql-on-intel-320-ssd/[/url]

And for your interest feature comparison between percona server & oracle mysql,

[url]Percona Server for MySQL 8.0 - Documentation — Percona Server 8.0 Documentation

3

Hi,
I don’t think any MySQL version is able to scale up to 80 or 160 cores at the moment. Lot has been done in both MySQL and Percona Server 5.5 and 5.6 in this regard, but still the scalability will depend on actual workload and has some limits. In fact, there are no reliable benchmarks on hardware having so many cores that I am aware of. Even Oracle did not publish such AFAIK. You can get some additional picture from these (it’s 32/64HT though):
[url]http://dimitrik.free.fr/blog/archives/2013/02/mysql-performance-mysql-56-ga-and-mysql-55-scalability.html[/url]

Also, I think it’s very possible that you will gain actually better performance if you disable HT and stay with real 80 cores.
If you will purchase such decent hardware, we will be more than happy to see some of your test results on various MySQL versions and both HT disabled/enabled.
This guide can help you doing some benchmarks and graph them btw: [url]http://www.mysqlperformanceblog.com/2013/07/01/tpcc-mysql-simple-usage-steps-and-how-to-build-graphs-with-gnuplot/[/url]