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.
- 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
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
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.