sysbench-05使用手册..docx

sysbench介绍SysBench是一个模块化的、跨平台、多线程基准测试工具，主要用于评估测试各种不同系统参数下的数据库负载情况。它主要包括以下几种方式的测试：1、cpu性能2、磁盘io性能3、调度程序性能4、内存分配及传输速度5、POSIX线程性能6、数据库性能(OLTP基准测试)目前sysbench主要支持MySQL,pgsql,Oracle这3种数据库。sysbench安装默认支持MySQL，如果需要测试Oracle/PostgreSQL，则在configure时需要加上–with-oracle或者–with-pgsql参数，sysbench默认安装在： /usr/local/bin/sysbenchYum源也可以直接安装：yuminstall sysbench基于Debain的操作系统，可以直接安装：sudo apt-get install sysbench也可以下载源码，然后自己编译安装。tarxzvf sysbench-0.5.tar.gzcd sysbench-0.5chmod +x autogen.sh./autogen.sh./configure --with-mysql --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/libmake make installshell tar -zxvf sysbench-0.5.tar.gz -C /db/tool/shell cd /db/tool/sysbench-0.5shell chmod +x autogen.shshell ./autogen.sh automake 1.10.x (aclocal) wasnt found, exitingshell yum install automakeshell ./autogen.sh libtoolize 1.4+ wasnt found, exitingshell yum install libtoolshell ./autogen.sh ./autogen.sh ./autogen.sh: running `aclocal -I m4 ./autogen.sh: running `libtoolize --copy --force libtoolize: putting auxiliary files in AC_CONFIG_AUX_DIR, `config.libtoolize: copying file `config/ltmain.shlibtoolize: putting macros in AC_CONFIG_MACRO_DIR, `m4.libtoolize: copying file `m4/libtool.m4libtoolize: copying file `m4/ltoptions.m4libtoolize: copying file `m4/ltsugar.m4libtoolize: copying file `m4/ltversion.m4libtoolize: copying file `m4/lt~obsolete.m4./autogen.sh: running `autoheader ./autogen.sh: running `automake -c --foreign --add-missing configure.ac:23: installing `config/compileconfigure.ac:11: installing `config/config.guessconfigure.ac:11: installing `config/config.subconfigure.ac:16: installing `config/install-shconfigure.ac:16: installing `config/missingsysbench/Makefile.am: installing `config/depcomp./autogen.sh: running `autoconf Libtoolized with: libtoolize (GNU libtool) 2.2.6bAutomade with: automake (GNU automake) 1.11.1Configured with: autoconf (GNU Autoconf) 2.63shell ./configure --prefix=/db/sysbench --with-mysql-includes=/db/mysql/include --with-mysql-libs