Announcement

Announcement Module
Collapse
No announcement yet.

80 core server and XtraDB

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 80 core server and XtraDB

    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.

    http://www.mysqlperformanceblog.com/...nch-benchmark/
    http://www.mysqlperformanceblog.com/...intel-320-ssd/

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

    http://www.percona.com/doc/percona-s...omparison.html

    Comment


    • #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):
      http://dimitrik.free.fr/blog/archive...alability.html

      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: http://www.mysqlperformanceblog.com/...-with-gnuplot/

      Comment

      Working...
      X