-
install the latest sysbench https://github.com/akopytov/sysbench
!!! That important that you use the latest available version of sysbench !!!
-
install prerequisites for mongorover driver
bash# apt-get install libmongoc-dev libbson-dev luarocks
-
install mongorover driver
bash# luarocks install mongorover --local
= MongoDB specific options
--mongodb_host=STRING MongoDB: hostname [localhost] --mongodb_port=STRING MongoDB: port [27017] --mongodb_db=STRING MongoDB: database name [sbtest_test]
- prepare
./sysbench oltp-mongo.lua --tables=10 --threads=10 --table-size=100 --mongodb-db=sbtest --mongodb-host=localhost --mongodb-port=27017 --rand-type=pareto prepare
- run oltp_rw
./sysbench oltp-mongo.lua --tables=10 --threads=10 --table-size=100 --mongodb-db=sbtest --mongodb-host=localhost --mongodb-port=27017 --time=120 --report-interval=1 --rand-type=pareto run
Running the test with following options:
Number of threads: 10
Initializing random number generator from current time
Initializing worker threads...
Threads started!
General statistics:
total time: 120.0106s
total number of events: 100774
Latency (ms):
min: 10.30
avg: 11.91
max: 25.85
95th percentile: 14.21
sum: 1199874.10
Threads fairness:
events (avg/stddev): 10077.4000/30.69
execution time (avg/stddev): 119.9874/0.00
The metric is number of events(queries/transactions) per second: 100774/120 ~ 840 events per second
- run oltp_ro test
./sysbench oltp-mongo.lua --tables=10 --threads=10 --table-size=100 --mongodb-db=sbtest --mongodb-host=localhost --mongodb-port=27017 --time=120 --read_only=on --report-interval=1 --rand-type=pareto run
- run point_select only query
./sysbench oltp-mongo.lua --tables=10 --threads=10 --table-size=100 --mongodb-db=sbtest --mongodb-host=localhost --mongodb-port=27017 --time=120 --point_selects=1 --simple_ranges=0 --sum_ranges=0 --order_ranges=0 --distinct_ranges=0 --index_updates=0 --non_index_updates=0 --delete_inserts=0 --report-interval=1 --rand-type=pareto run
- cleanup
./sysbench oltp-mongo.lua --tables=10 --threads=10 --table-size=100 --mongodb-db=sbtest --mongodb-host=localhost --mongodb-port=27017 cleanup