下载 wget http://imysql.com/wp-content/uploads/2014/09/sysbench-0.4.12-1.1.tgz
sysbench安装过程中如果执行./autogen.sh出现
libtoolize 1.4+ wasn't found, exiting
则需要安装libtool
yum install libtool
执行./autogen.sh
./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib && make
如果梅雨报错的话,会在解压目录下生成一个sysbench工具目录
测试前的准备工作:
创建测试库 create database systest;
cd /opt/sysbench-0.4.12-1.1/sysbench
./sysbench --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=root \
--test=tests/db/oltp.lua --oltp_tables_count=10 --oltp-table-size=100000 --rand-init=on prepare