sysbench压力测试工具安装和参数介绍.docx

sysbench压力测试工具安装和参数介绍?一、sysbench压力测试工具简介：?sysbench是一个开源的、模块化的、跨平台的多线程性能测试工具，可以用来进行CPU、内存、磁盘I/O、线程、数据库的性能测试。目前支持的数据库有MySQL、Oracle和PostgreSQL。以下操作都将以支持MySQL数据库为例进行。?1.?sysbench工具安装：默认支持MySQL，如果需要测试Oracle/PostgreSQL，则在configure时需要加上–with-oracle或者–with-pgsql参数.1.1?安装环境CentOS release 6.3 (Final)MySQL 5.6.13?MySQL_HOME=/usr/local/mysql/Sysbench ?下载安装包# wget?/projects/sysbench/sysbench-0.4.12.tar.gz/projects/sysbench/sysbench-0.4.12.tar.gz?1.3?编译安装# ?tar –zxvf sysbench-0.4.12.tar.gz进入解压缩包sysbench-0.4.12,并执行脚本autogen.sh# cd sysbench-0.4.12# ./autogen.sh关键的三步：configure make make install首先是./configure命令，sysbench默认是支持MySQL的benchmarking的，如果不加任何选项则要求保证MySQL的安装路径都是默认的标准路径，headfile位于/usr/include目录下，libraries位于/usr/lib/目录下。因为我的MySQL是源码编译安装的，安装路径是放在/usr/local/mysql下，所以这里要添加相应的选项命令：# ./configure --prefix=/usr/local/sysbench --with-mysql=/usr/local/mysql \--with-mysql-includes=/usr/local/mysql/include/mysql/ \--with-mysql-libs=/usr/local/mysql/lib/mysql/注意：这里在编译时要将路径写到最后的include/mysql及lib/mysql，如下所示：–with-mysql-includes=/usr/local/mysql/include/mysql/--with-mysql-libs=/usr/local/mysql/lib/mysql/因为网上好多资料都没有提到这一层，在编译时总是编译不过去，这里浪费了好多精力。接下来执行如下命令：# make make install1.4??yum安装如果觉得源码安装麻烦，也可以采用yum安装，操作如下：# yum install -y sysbench2.?sysbench支持的功能参数?首先，看看sysbench都支持哪些功能参数：[root@db-master sysbench]#?sysbench --helpUsage: sysbench [general-options]... --test=?[test-options]... commandGeneral options: --num-threads=N??????????? number of threads to use [1] --max-requests=N?????????? limit for total number of requests [10000] --max-time=N?????????????? limit for total execution time in seconds [0] --forced-shutdown=STRING?? amount of time to wait after --max-time before forcing shutdown [off] --thread-stack-size=SIZE?? size of stack per thread [32K] --init-rng=[on|off]??????? initialize random number generator [off] --test=STRING????????????? test to run --debug=[on|off]?????????? print more debugging info [off] --validate=[on|off]??????? perform validation checks where possible [off] --help=[o