{{ !articles[0].partner.isSponsoringArticle ? "Platinum" : "Portal" }} Partner

Intel SSD 910 in tpcc-mysql Benchmark

The content of this post was originally written by Vadim Tkachenko over at the MySQL Performance Blog.

I continue my benchmarks of Intel SSD 910, the raw IO results are available in my previous experiment. Now I want to test this card under MySQL workload to see if the card is suitable to use with MySQL.

  • Benchmark date: Sep-2012
  • Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with baseline Fusion-io ioDrive card
  • Hardware specification
    • Server: Dell PowerEdge R710
    • CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz
    • Memory: 192GB
    • Storage: Fusion-io ioDrive 640GB, Intel SSD 910 (software RAID over 2x200GB devices)
    • Filesystem: ext4
  • Software
    • OS: Ubuntu 12.04.1
    • MySQL Version: Percona Server 5.5.27-28.1
  • Benchmark specification
    • Benchmark name: tpcc-mysql
    • Scale factor: 2500W (~250GB of data)
    • Benchmark length: 2h, but the result is taken only for last 1h to remove warm-up phase
  • Parameters to vary: we vary innodb_buffer_pool_size: 13, 25, 50, 75GB to have different memory/data ration. And we test it on two storages: Fusion-io ioDrive and Intel SSD 910
  • Results
    There is graph of Throughput taken every 10 sec:

    Or to have final results I take total amount of transactions for 1h:

    BP size Fusion-io Intel SSD 910 Ratio (fio/i910)
    13 GB 397157 352750 1.13
    25 GB 724011 497769 1.45
    50 GB 1466559 1124223 1.30
    75 GB 2464135 1939415 1.27


    In conclusion I see that Intel SSD 910 handles MySQL workload quite well, I did not face any problem working with this card.
    Level of stability of results is about the same as with Fusion-io card. The performance of Intel SSD 910 is about ~30% worse, but
    it is expected for this price level. I think Intel SSD 910 is suitable to use with MySQL / Percona Server.

    Link to raw results and stats
    Raw results, config, OS and MySQL metrics are available from Benchmarks Launchpad.

    Published at DZone with permission of {{ articles[0].authors[0].realName }}, DZone MVB. (source)

    Opinions expressed by DZone contributors are their own.

    {{ tag }}, {{tag}},

    {{ parent.title || parent.header.title}}

    {{ parent.tldr }}

    {{ parent.urlSource.name }}
    {{ parent.authors[0].realName || parent.author}}

    {{ parent.authors[0].tagline || parent.tagline }}

    {{ parent.views }} ViewsClicks