利用Sysbench对MySQL进行压测

tar xzvf sysbench-0.5.tar.gz
cd sysbench-0.5
chmod +x autogen.sh
./autogen.sh
./configure --with-mysql --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib && make && make install
#--with-oracle 支持oracle
#prepare准备数据，run执行测试，cleanup清理数据
sysbench --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=master1 --oltp-tables-count=10 --oltp-table-size=6000000 --num-threads=50 --max-requests=100000000 --report-interval=1 --mysql-table-engine=innodb --test=/root/sysbench-0.5/sysbench/tests/db/oltp.lua prepare
#oltp进行压测
sysbench --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=master1 --oltp-tables-count=10 --oltp-table-size=6000000 --num-threads=50 --max-requests=100000000 --report-interval=1 --mysql-table-engine=innodb --test=/root/sysbench-0.5/sysbench/tests/db/oltp.lua run