一、简介
一、简介
SysBench是一个模块化的、跨平台、多线程基准测试工具,主要用于评估测试各种不同系统参数下的数据库负载情况。
当前功能允许测试的系统参数有:
1. file I/O performance (文件I / O性能)
2.scheduler performance (调度性能)
3.memory allocation and transfer speed (内存分配和传输速度)
4.POSIX threads implementation performance (POSIX线程执行绩效)
5.database server performance (OLTP benchmark) (数据库服务器性能)
SysBench运行指定数目的线程,他们都是并行的执行请求。实际工作量的请求产生依赖于指定的测试模式(在编译中添加测试模块)。可以限制请求总数或总时间为基准,或两者。
二、安装
wget http://downloads.sourceforge.net/project/sysbench/sysbench/0.4.12/sysbench-0.4.12.tar.gz
# tar -zxvf sysbench-0.4.12.tar.gz
# cd sysbench-0.4.12
# ./autogen.sh
# ./configure --with-mysql-includes=/usr/local/perconamysql/include/ --with-mysql-libs=/usr/local/perconamysql/lib/
#make && make install</span>
安装过程中出现的错误以及解决办法:
问题一:
../libtool: line 838: X--tag=CC: command not found ../libtool: line 871: libtool: ignoring unknown tag : command not found ../libtool: line 838: X--mode=link: command not found ../libtool: line 1004: *** Warning: inferring the mode of operation is deprecated.: command not found ../libtool: line 1005: *** Future versions of Libtool will require --mode=MODE be specified.: command not found ../libtool: line 2231: X-g: command not found ../libtool: line 2231: X-O2: command not found ../libtool: line 1951: X-L/usr/local/mysql-5.5.8/lib: No such file or directory ../libtool: line 2400: Xsysbench: command not found
解决办法:
1.在编译前先运行autogen.sh即可。
2.安装新版本的libtool工具,注意,一定要先configure之后再将libtool拷贝到sysbench的目录中。
问题二:
# sysbench: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory 解决办法: # in -s /usr/local/mysql-5.5.8/lib/libmysqlclient.so.16 /lib64/libmysqlclient.so.16