MySQL 5.6.0

Last time we made a small error in our script, causing the Sysbench test to write to our SSDs anyway. That did not make the test invalid, but as we really want to isolate the CPU performance. However due to these changes, you cannot compare this with any similar Sysbench based benchmarking we have done before.

The Intel servers were running Percona Server 5.6 (the best-optimized MySQL server for x86), the ThunderX system was running a special ThunderX optimized version of MySQL 5.6. 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. According to Cavium, there is still a lot headroom to improve MySQL performance. A ThunderX optimized version of Percona Server 5.7 should improved performance quite a bit.

For our testing we used the read-only OLTP benchmark, which is slightly less realistic, but a good first indication for MySQL Select performance.

MySQL Sysbench Read-only

A single ThunderX core is capable of 270 transactions/s and scales well: with 32 threads and one thread per core we still get about 8000 tr/s (or 250 tr/s/core). But beyond that point, scaling is much more worse: add another 16 cores and we only get 17% more performance.

MySQL Sysbench Read-only: 95th percentile response time

But when we look at the response times, things look a lot less rosy. The ThunderX is a lot slower when handling the more heavy SQL statements.

It is clear that the ThunderX is no match for high frequency trading and other database intensive applications. However, when MySQL serves as just a backend for a website and satisfies simple "get data x or y" requests, the 4 extra ms are a small nuisance.

Compression & Decompression Java Performance
Comments Locked

82 Comments

View All Comments

  • Daniel Egger - Wednesday, June 15, 2016 - link

    I could hardly disagree more about the remote management of SuperMicro vs. HP. Remote management of HP is *the horror*, I've never seen worse and I've seen a lot. It's clunky, it requires a license to be useful (others do to but SuperMicro does not have such nonsense), the BCM tends to crash a lot (which is very annoying for a remote management solution), boot is even slower than all other systems I know due to the way they integrate the BIOS and remote management on the system and it also uses Java unless you have Windows machines around to use the .NET version.

    For the remote management alone I would chose SuperMicro over most other vendors any day.
  • JohanAnandtech - Thursday, June 16, 2016 - link

    I found the .Net client of HP much less sluggish, and I have seen no crashing at all. I guess there is no optimal remote management client, but I really like the "boot into firmware" option that Intel implemented.
  • rahvin - Thursday, June 16, 2016 - link

    Not only that but Supermicro actually releases updates for their BCM's. I had the same shocked reaction to the HP claim. Started to wonder if I was the only one that thought supermicro was light years ahead in usability.

    I should note that Supermicro's awful Java tool works on Linux as well as windows. Though it refuses to run if your Java isn't the newest version available.
  • pencea - Wednesday, June 15, 2016 - link

    All these articles and yet still no review for the GTX 1080, while other major sites have already posted their reviews of both 1070 & 1080. Guru3D already has 2 custom 1080 and a custom 1070 review up.
  • Ryan Smith - Wednesday, June 15, 2016 - link

    It'll be done when it's done.
  • pencea - Wednesday, June 15, 2016 - link

    Unacceptably late for something that should've been posted weeks ago.
  • Meteor2 - Thursday, June 16, 2016 - link

    Will anyone read it though? Your ad impressions are going to suffer.
  • Ryan Smith - Thursday, June 16, 2016 - link

    Maybe. Maybe not. But it's my own fault regardless. All I can do is get it done as soon as I reasonably can, and hope it's something you guys find useful.
  • name99 - Thursday, June 16, 2016 - link

    Give it a freaking rest. No-one is impressed by your constant whining about this.
  • pencea - Thursday, June 16, 2016 - link

    Not looking to impress anyone. As a long time viewer of this site, I'm simply disappointed that a reputational site like this is constantly late for GPU reviews.

Log in

Don't have an account? Sign up now