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]