sysbench的使用

https://github.com/akopytov/sysbench

 

git clone  https://github.com/akopytov/sysbench

 

/usr/local/sysbench/bin/sysbench

 

 

 /usr/local/sysbench/bin/sysbench --version

 

docker.io/severalnines/sysbench:latest

 

docker run -d -it --name sysbench -v /root/benchdir:/admin/bench -p 8000:80 docker.io/severalnines/sysbench:latest bash

 

 

通过sysbench自带的lua脚本对mysql进行测试

sysbench --mysql-host=192.168.1.1  --mysql-port=3306 --mysql-user=root     --mysql-password=123456 --mysql-db=db1 --table_size=1000000 --db-driver=mysql oltp_insert prepare

sysbench --mysql-host=192.168.1.1 --mysql-port=3306 --mysql-user=root     --mysql-password=123456 --mysql-db=test --db-driver=mysql oltp_insert run

 sysbench --mysql-host=192.168.1.1 --mysql-port=3306 --mysql-user=sbtest     --mysql-password=123456 --mysql-db=tempdb oltp_insert cleanup