#一、安装
#yum安装
#yum install -y sysbench
#编译安装
#下载安装源码 https://github.com/akopytov/sysbench
#bzr branch lp:sysbench //下载到当前目录,文件名为: sysbench
yum gcc automake m4 libtool bzr
./autogen.sh
./configure --prefix=/usr/local/sysbench --with-mysql-libs=/usr/local/mysql/lib/ --with-mysql-includes=/usr/local/mysql/include/
make
make install
ln -s /usr/local/sysbench/bin/sysbench /usr/bin/sysbench
#要添加环境变量,不然会报错
/etc/profile 添加环境变量
export LD_LIBRARY_PATH=/usr/local/mysql/lib/
source /etc/profile
step5:
sysbench --help验证是否成功
二、测试前准备
create database sbtest;
flush privivleges
或mysqladmin create sbtest
三、混合读写
#读写测试还是用oltp.lua,只需把--oltp-read-only等于off。
sysbench --mysql-host=172.16.*.* --mysql-port=33306 --mysql-user=root --mysql-password=123123 \
--mysql-db=sbtest --test=/usr/local/sysbench/share/sysbench/tests/include/oltp_legacy/oltp.lua \
--oltp_tables_count=10 --oltp-table-size=100000 --rand-init=on prepare -db-driver=mysql
sysbench --mysql-host=172.16.*.* --mysql-port=33306 --mysql-user=root --mysql-password=123123 \
--mysql-db=sbtest --test=/usr/local/sysbench/share/sysbench/tests/include/oltp_legacy/oltp.lua \
--oltp_tables_count=10 --oltp-table-size=10000000 --num-threads=8 --oltp-read-only=off \
--report-interval=10 --rand-type=uniform --max-time=3600 \
--max-requests=0 --percentile=99 run >> /usr/local/sysbench/log/sysbench_oltpX_8_2014
#yum安装
#yum install -y sysbench
#编译安装
#下载安装源码 https://github.com/akopytov/sysbench
#bzr branch lp:sysbench //下载到当前目录,文件名为: sysbench
yum gcc automake m4 libtool bzr
./autogen.sh
./configure --prefix=/usr/local/sysbench --with-mysql-libs=/usr/local/mysql/lib/ --with-mysql-includes=/usr/local/mysql/include/
make
make install
ln -s /usr/local/sysbench/bin/sysbench /usr/bin/sysbench
#要添加环境变量,不然会报错
/etc/profile 添加环境变量
export LD_LIBRARY_PATH=/usr/local/mysql/lib/
source /etc/profile
step5:
sysbench --help验证是否成功
二、测试前准备
create database sbtest;
flush privivleges
或mysqladmin create sbtest
三、混合读写
#读写测试还是用oltp.lua,只需把--oltp-read-only等于off。
sysbench --mysql-host=172.16.*.* --mysql-port=33306 --mysql-user=root --mysql-password=123123 \
--mysql-db=sbtest --test=/usr/local/sysbench/share/sysbench/tests/include/oltp_legacy/oltp.lua \
--oltp_tables_count=10 --oltp-table-size=100000 --rand-init=on prepare -db-driver=mysql
sysbench --mysql-host=172.16.*.* --mysql-port=33306 --mysql-user=root --mysql-password=123123 \
--mysql-db=sbtest --test=/usr/local/sysbench/share/sysbench/tests/include/oltp_legacy/oltp.lua \
--oltp_tables_count=10 --oltp-table-size=10000000 --num-threads=8 --oltp-read-only=off \
--report-interval=10 --rand-type=uniform --max-time=3600 \
--max-requests=0 --percentile=99 run >> /usr/local/sysbench/log/sysbench_oltpX_8_2014