最新消息:

sysbench安装与使用

SQL 老鹰 402浏览 0评论

1 安装
download:
git clone https://github.com/akopytov/sysbench.git
install:
./autogen.sh
./configure
make
make install
2: 使用
prepare:
sysbench –test=’./sysbench/tests/db/oltp.lua’ –oltp_tables_count=100 –report-interval=10 –oltp-table-size=1000 –num-threads=2 –mysql-user=vicgroup –mysql-password=0xunclub –mysql-table-engine=innodb –rand-init=on –mysql-host=192.168.11.47 –mysql-port=3306 –mysql-db=oltp prepare

run:
sysbench –test=’./sysbench/tests/db/oltp.lua’ –oltp_tables_count=100 –report-interval=5 –oltp-table-size=100 –mysql-user=vicgroup –mysql-password=0xunclub –oltp-connect-delay=10 –oltp-dist-type=uniform –rand-init=on –mysql-table-engine=innodb –mysql-host=192.168.11.47 –mysql-port=3306 –mysql-db=oltp –max-time=15 –max-requests=0 –num-threads=6 –thread-stack-size=256 run

clean up:

sysbench –test=’./sysbench/tests/db/oltp.lua’ –oltp_tables_count=100 –report-interval=5 –oltp-table-size=100 –mysql-user=vicgroup –mysql-password=0xunclub –mysql-table-engine=innodb –mysql-host=192.168.11.47 –mysql-port=3306 –mysql-db=oltp cleanup

转载请注明:冯英胜的博客 » sysbench安装与使用

发表我的评论
取消评论
表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址