sysbenchでMySQLのベンチマーク

Yoshinori Matsunobu's blog: Non-persistent connection performance improvements in 5.6
↑
これに触発されて僕もsysbenchをMySQLでやってみようと思いました。

CentOS。↓こんな感じでやれば出来ました。
しかしながら、なにを読み取っていいのか分かりません／(^o^)＼

# mysql -u root -p
# mysql>CREATE DATABASE test_db;
Query OK, 1 row affected (0.00 sec)
# mysql>Ctrl-C -- exit!
# sysbench --test=oltp --db-driver=mysql --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-user=root --mysql-password=root --mysql-host=localhost --mysql-port=3306 --mysql-db=test_db --oltp-table-name=test_t prepare
sysbench 0.4.12:  multi-threaded system evaluation benchmark

Creating table 'test_t'...
Creating 1000000 records in table 'test_t'...

# sysbench --test=oltp --num-threads=10 --db-driver=mysql --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-user=root --mysql-password=root --mysql-host=localhost --mysql-port=3306 --mysql-db=test_db --oltp-table-name=test_t run
sysbench 0.4.12:  multi-threaded system evaluation benchmark

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

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 10000
Threads started!
Done.

OLTP test statistics:
    queries performed:
        read:                            140084
        write:                           50030
        other:                           20012
        total:                           210126
    transactions:                        10006  (283.12 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 190114 (5379.21 per sec.)
    other operations:                    20012  (566.23 per sec.)

Test execution summary:
    total time:                          35.3424s
    total number of events:              10006
    total time taken by event execution: 353.0065
    per-request statistics:
         min:                                 10.70ms
         avg:                                 35.28ms
         max:                                123.77ms
         approx.  95 percentile:              51.98ms

Threads fairness:
    events (avg/stddev):           1000.6000/3.44
    execution time (avg/stddev):   35.3007/0.02