Mysql 测试

centos7

sysbench --test=oltp --mysql-user=root --mysql-password=123456 --mysql-host=127.0.0.1 --mysql-port=3306 --db-driver=mysql-mysql-socket=/usr/local/mysql/mysql.sock --oltp-table-size=1000000 --oltp-table-name=normal --mysql-db=test --max-requests=100000 --num-threads=200 --mysql-table-engine=innodb prepare
OLTP test statistics:
    queries performed:
        read:                            1404900
        write:                           500732
        other:                           200359
        total:                           2105991
    transactions:                        100009 (551.55 per sec.)
    deadlocks:                           341    (1.88 per sec.)
    read/write requests:                 1905632 (10509.49 per sec.)
    other operations:                    200359 (1104.97 per sec.)

Test execution summary:
    total time:                          181.3249s
    total number of events:              100009
    total time taken by event execution: 36248.7636
    per-request statistics:
         min:                                 25.06ms
         avg:                                362.46ms
         max:                               1591.09ms
         approx.  95 percentile:             687.84ms

Threads fairness:
    events (avg/stddev):           500.0450/10.17
    execution time (avg/stddev):   181.2438/0.02