mysql远程压力测试_使用sysbench进行MySQL压力测试

1. 安装 sysbench

[root@benchserver ~]# yum install sysbench

[root@benchserver ~]# rpm -ql sysbench-1.0.17-2.el7.x86_64 | grep lua$

sysbench使用lua脚本编写，所以最终测试都需要调用lua脚本。

[root@benchserver ~]# sysbench --help

实际使用中参数不多，核心参数如下：

General options:

--config-file=FILENAME          File containing command line options

--threads=N                     number of threads to use [1]

--time=N                        limit for total execution time in seconds [10]

--report-interval=N             periodically report intermediate statistics with a specified interval in seconds.

--db-driver=STRING  specifies database driver to use [mysql]

Compiled-in database drivers:

mysql - MySQL driver

pgsql - PostgreSQL driver

mysql options:

--mysql-host=[LIST,...]          MySQL server host