2.1 只读示例
./bin/sysbench –test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua
–mysql-host=192.168.80.134 –mysql-port=3306 –mysql-user=root –mysql-password=root123
–mysql-db=sbtest –oltp-tables-count=10 –oltp-table-size=10000000
–report-interval=10 –oltp-dist-type=uniform –rand-init=on –max-requests=0
–oltp-test-mode=nontrx –oltp-nontrx-mode=select
–oltp-read-only=on –oltp-skip-trx=on
–time=120 –threads=12
[prepare|run|cleanup]
生成数据|运行测试|清除数据
2.2混合读写
.bin/sysbench –test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua
–mysql-host=192.168.80.134 –mysql-port=3306 –mysql-user=root –mysql-password=root123
–mysql-db=sbtest –oltp-tables-count=10 –oltp-table-size=500000
–report-interval=10 –rand-init=on –max-requests=0 –oltp-test-mode=nontrx
–oltp-nontrx-mode=select
–oltp-read-only=off
–time=120 –threads=128 prepare
[prepare|run|cleanup]
2.3修改数据只写测试
.bin/sysbench –test=/usr/share/sysbench/tests/include/oltp_legacy/update_index.lua
–mysql-host=192.168.80.134 –mysql-port=3306 –mysql-user=root –mysql-password=root123
–mysql-db=sbtest –oltp-tables-count=10 –oltp-table-size=500000
–report-interval=10 –rand-init=on –max-requests=0 –oltp-test-mode=nontrx
–oltp-nontrx-mode=select
–oltp-read-only=off
–time=120 –threads=128 prepare
[prepare|run|cleanup]