基于sysbench-mongodb-lua的mongodb的性能测试

﹏ヽ暗。殇╰゛Y 2024-03-26 10:30 58阅读 0赞

## 1.环境准备 ##

### install sysbench ###

yum install sysbench

### install mongorover driver ###

··· yum install libmongoc-dev libbson-dev luarocks

luarocks install mongorover --local ···

yum install libbson.x86\_64

yum install mongo-c-driver.x86\_64

## 2.测试 ##

./sysbench  oltp-mongo.lua --tables=10 --threads=10 --table-size=100 --mongodb-db=sbtest --mongodb-host=localhost --mongodb-port=27017  --rand-type=pareto prepare
    
    ./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
    
    > 本文由博客一文多发平台 [OpenWrite][] 发布！

[OpenWrite]: https://openwrite.cn?from=article_bottom