Result of ioDrive benchmark. (MySQL)

benchmark.sh

#!/bin/bash

for DIR in "fio1" "fio2" "hdd1" "hdd2"
do
	sync
	echo 3 >  /proc/sys/vm/drop_caches
	sync

	sysbench \
	--test=oltp \
	--db-driver=mysql \
	--oltp-table-size=1000000 \
	--mysql-socket=/${DIR}/mysql/mysql.sock \
	--mysql-user=sbtestuser \
	--mysql-password=sbtestpass \
	--num-threads=4 --max-requests=100000 --max-time=0 --oltp-test-mode=complex \
	run
done

fio1txt

sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 4

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 100000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            1400000
        write:                           500000
        other:                           200000
        total:                           2100000
    transactions:                        100000 (629.17 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1900000 (11954.29 per sec.)
    other operations:                    200000 (1258.35 per sec.)

Test execution summary:
    total time:                          158.9387s
    total number of events:              100000
    total time taken by event execution: 634.8596
    per-request statistics:
         min:                                  4.56ms
         avg:                                  6.35ms
         max:                                192.74ms
         approx.  95 percentile:               7.96ms

Threads fairness:
    events (avg/stddev):           25000.0000/13.67
    execution time (avg/stddev):   158.7149/0.00

fio2.txt

sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 4

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 100000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            1400014
        write:                           500005
        other:                           200002
        total:                           2100021
    transactions:                        100001 (664.69 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1900019 (12629.04 per sec.)
    other operations:                    200002 (1329.37 per sec.)

Test execution summary:
    total time:                          150.4484s
    total number of events:              100001
    total time taken by event execution: 600.9279
    per-request statistics:
         min:                                  3.01ms
         avg:                                  6.01ms
         max:                                165.48ms
         approx.  95 percentile:               7.78ms

Threads fairness:
    events (avg/stddev):           25000.2500/50.27
    execution time (avg/stddev):   150.2320/0.00

hdd1.txt

sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 4

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 100000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            1400056
        write:                           500020
        other:                           200008
        total:                           2100084
    transactions:                        100004 (731.56 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1900076 (13899.72 per sec.)
    other operations:                    200008 (1463.13 per sec.)

Test execution summary:
    total time:                          136.6989s
    total number of events:              100004
    total time taken by event execution: 546.1231
    per-request statistics:
         min:                                  2.86ms
         avg:                                  5.46ms
         max:                                285.08ms
         approx.  95 percentile:               7.84ms

Threads fairness:
    events (avg/stddev):           25001.0000/44.73
    execution time (avg/stddev):   136.5308/0.00

hdd2.txt

sysbench 0.4.12:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 4

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 100000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            1400014
        write:                           500005
        other:                           200002
        total:                           2100021
    transactions:                        100001 (819.10 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 1900019 (15562.82 per sec.)
    other operations:                    200002 (1638.19 per sec.)

Test execution summary:
    total time:                          122.0871s
    total number of events:              100001
    total time taken by event execution: 487.7381
    per-request statistics:
         min:                                  2.75ms
         avg:                                  4.88ms
         max:                                359.32ms
         approx.  95 percentile:               6.80ms

Threads fairness:
    events (avg/stddev):           25000.2500/76.20
    execution time (avg/stddev):   121.9345/0.00

prepare.sh

#!/bin/bash

for DIR in "fio1" "fio2" "hdd1" "hdd2"
do
	sysbench \
	--test=oltp \
	--db-driver=mysql \
	--oltp-table-size=1000000 \
	--mysql-socket=/${DIR}/mysql/mysql.sock \
	--mysql-user=sbtestuser \
	--mysql-password=sbtestpass \
	prepare
done