MySQL性能测试

工具

• sysbench

安装

测试

准备阶段

sysbench --test=oltp_point_select.lua --tables=1 --table-size=200000 --threads=16 --time=120 --report-interval=3 --mysql-user=root --mysql-password=xxxx --mysql-host=10.18.xx --max-requests=0 --mysql-db=sbtest prepare

参数	描述
--test	指定测试脚本，可自己写也可使用默认的，安装sysbench后在/usr/share/sysbench目录下
--tables	生成表的数量，可根据自己需要多生成几个
--tables-size	成的数据量
--threads	启动的线程
--time	时间，单位秒
--report-interval	几秒报告一次
--max-requests	最大请求数

执行阶段

sysbench --test=oltp_point_select.lua --tables=1 --table-size=200000 --threads=16 --time=120 --report-interval=3 --mysql-user=root --mysql-password=xxxx --mysql-host=10.18.xx --max-requests=0 --mysql-db=sbtest run

将prepare改成run则可

Running the test with following options:
Number of threads: 24
Initializing random number generator from current time


Initializing worker threads...

Threads started!

SQL statistics:
    queries performed:
        read:                            0
        write:                           148351
        other:                           0
        total:                           148351
    transactions:                        148351 (14826.49 per sec.)
    queries:                             148351 (14826.49 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          10.0044s
    total number of events:              148351

Latency (ms):
         min:                                    0.80
         avg:                                    1.61
         max:                                  152.09
         95th percentile:                        2.22
         sum:                               239142.52

Threads fairness:
    events (avg/stddev):           6181.2917/31.60
    execution time (avg/stddev):   9.9643/0.00