Benchmarking Sysbench (OLTP)

Following on from the last benchmarks performed, the ApacheBench tests Apache Benchmarks we wanted to understand how well databases would perform on our Viridis platform. Typically DBs go hand in hand with apache instances and used throughout enterprises in various roles. The tests we will focus on today are OLTP (online transaction processing) random reads from a database.

The Setup:

  • Identical versions on Ubuntu used, 12.04 (different arch versions!)
  • 1GB per core/hyper-threaded core of RAM
  • Single 256GB SSD per server
  • Databases created with 1,000,000 entries
  • Random Reads were performed across 100,000 entries (10% of the database)

The Sysbench Commands used:

(setup the DB): sysbench --test=oltp --mysql-table-engine=myisam --oltp-table-size=1000000 --mysql-user=root prepare

(Viridis Test): sysbench --mysql-user=root --num-threads=4 --max-requests=100000 --test=oltp --oltp-table-size=1000000 --oltp-read-only run

(Intel Server Test): sysbench --mysql-user=root --num-threads=32 --max-requests=100000 --test=oltp --oltp-table-size=1000000 --oltp-read-only run

The Results:

So as expected, node vs node our system achieved ~18% of what the Intel server did. However when you consider the performance per watt, or transactions per watt the overall picture looks much better for Viridiis platform.

Linux Format Review

Our friends over at Linux Format put the Viridis server through its paces and it featured in the Christmas release of their mag Issue 165.

The Raspberry Pi isn’t the only ARM-based computer to be upsetting the status quo. At the other end of the scale, another British firm is packing ARM processors into rack-mounted servers.

Read the LXF Viridis Review

If you havent already got a subscription (shame on you!), you can subscripe here