sysbench安装与测试

一.安装
有一段时间没有使用sysbench了，安装的时候有遇到一些问题，还是记录下来，供以后查阅
1. ./autogen.sh
2. ./configure --with-mysql-includes=/usr/local/mysql/include/ --with-mysql-libs=/usr/local/mysql/lib/ 
3. make && make install
在安装的时候会出现以下的报错信息

../libtool: line 841: X--tag=CC: command not found
../libtool: line 874: libtool: ignoring unknown tag : command not found
../libtool: line 841: X--mode=link: command not found
../libtool: line 1007: *** Warning: inferring the mode of operation is deprecated.: command not found
../libtool: line 1008: *** Future versions of Libtool will require --mode=MODE be specified.: command not found
../libtool: line 2234: X-g: command not found
../libtool: line 2234: X-O2: command not found
../libtool: line 1954: X-L/usr/local/mysql/lib/: No such file or directory
../libtool: line 2403: Xsysbench: command not found
../libtool: line 2408: X: command not found
../libtool: line 2415: Xsysbench: command not found
../libtool: line 2550: X-lmysqlclient_r: command not found
../libtool: line 2550: X-lrt: command not found
../libtool: line 2550: X-lm: command not found
../libtool: line 2632: X-L/root/sysbench-0.4.12/sysbench: No such file or directory
../libtool: line 2550: X-lmysqlclient_r: command not found
../libtool: line 2550: X-lrt: command not found
../libtool: line 2550: X-lm: command not found
../libtool: line 2632: X-L/root/sysbench-0.4.12/sysbench: No such file or directory
../libtool: line 2550: X-lmysqlclient_r: command not found
../libtool: line 2550: X-lrt: command not found
../libtool: line 2550: X-lm: command not found

这个错误的原因是sysbench源代码中自带的libtool版本太旧了，可以使用系统的libtool替代之，在sysbench的源代码根目录下执行如下的命令即可：
cp /usr/bin/libtool libtool

安装完成的之后运行sysbench报错：

sysbench: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory

这说明sysbench无法找到mysql的库文件，这很可能是环境变量LD_LIBRARY_PATH没有设置，设置后即可解决该问题：

export LD_LIBRARY_PATH=/usr/mysql/lib
或者
ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/

二.压力测试

 

1.测试环境

测试机
cpu	单路Intel(R) Xeon(R) CPU E5-2630 0 @ 2.30GHz*6*2
内存	16G
系统	Cenos 6.3
内核	2.6.32-279.el6.x86_64 #1 SMP
Raid级别	Raid10
文件系统	Xfs
硬盘	4块SAS , 15krpm,300G,6Gbps
测试工具	Sysbench,TPCC,mysqlap

2.innodb关键选项

performance_schema	5.5没有，5.6为0
innodb_buffer_pool_size	8G ,感觉有点小，不知道20G以上会表现如何
innodb_buffer_pool_instances	5.5：1, 5.6：8
innodb_log_file_size	256M
innodb_flush_log_at_trx_commit	2

3.sysben测试情况

从上面的图可以看出，如果是在高并发的情况下，mysql5.6的事务能力和响应时间比mysql5.5的要好。

附sysbench的用法
1.创建测试数据
sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=10000000  --mysql-host=10.1.10.95 --mysql-user=root --mysql-password='' --mysql-port=3307 --num-threads=8 prepare

2.测试
sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=10000000  --mysql-host=10.1.10.95 --mysql-user=root --mysql-password='' --mysql-port=3307 --num-threads=8 run

3.清除数据
sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=10000000  --mysql-host=10.1.10.95 --mysql-user=root --mysql-password='' --mysql-port=3307 --num-threads=8 cleanup