CentOS 7.5
MongoDB 4.2分片集群
YCSB 0.17
安装包和部署步骤见以下链接:
https://github.com/brianfrankcooper/YCSB/tree/master/mongodb?spm=a2c4g.11186623.2.2.49ff38dc0tfGjX
https://blog.csdn.net/vkingnew/article/details/82027461
https://www.ucloud.cn/yun/77438.html
./bin/ycsb load mongodb -s -P workloads/workloada -p mongodb.url=mongodb://ycsb:123456@172.16.254.137:30000/ycsb
recordcount=1000 operationcount=100000 workload=site.ycsb.workloads.CoreWorkload readallfields=true readproportion=0.5 updateproportion=0.5 scanproportion=0 insertproportion=0 requestdistribution=zipfian
./bin/ycsb run mongodb -s -P workloads/workloada -p mongodb.url=mongodb://ycsb:123456@172.16.254.137:30000/ycsb
[OVERALL], RunTime(ms), 236582 [OVERALL], Throughput(ops/sec), 422.68642584812034 [TOTAL_GCS_PS_Scavenge], Count, 129 [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 294 [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.12426980919934738 [TOTAL_GCS_PS_MarkSweep], Count, 0 [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0 [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0 [TOTAL_GCs], Count, 129 [TOTAL_GC_TIME], Time(ms), 294 [TOTAL_GC_TIME_%], Time(%), 0.12426980919934738 [READ], Operations, 50062 [READ], AverageLatency(us), 2277.1574847189486 [READ], MinLatency(us), 902 [READ], MaxLatency(us), 505087 [READ], 95thPercentileLatency(us), 3923 [READ], 99thPercentileLatency(us), 5323 [READ], Return=OK, 50062 [CLEANUP], Operations, 1 [CLEANUP], AverageLatency(us), 4602.0 [CLEANUP], MinLatency(us), 4600 [CLEANUP], MaxLatency(us), 4603 [CLEANUP], 95thPercentileLatency(us), 4603 [CLEANUP], 99thPercentileLatency(us), 4603 [UPDATE], Operations, 49938 [UPDATE], AverageLatency(us), 2416.4448716408347 [UPDATE], MinLatency(us), 1022 [UPDATE], MaxLatency(us), 505599 [UPDATE], 95thPercentileLatency(us), 3993 [UPDATE], 99thPercentileLatency(us), 5443 [UPDATE], Return=OK, 49938
recordcount=1000 operationcount=100000 workload=site.ycsb.workloads.CoreWorkload readallfields=true readproportion=0 updateproportion=0 scanproportion=1 insertproportion=0 requestdistribution=zipfian maxscanlength=100 scanlengthdistribution=uniform
./bin/ycsb run mongodb -s -P workloads/workloade -p mongodb.url=mongodb://ycsb:123456@172.16.254.137:30000/ycsb
[OVERALL], RunTime(ms), 568640 [OVERALL], Throughput(ops/sec), 175.85818795723128 [TOTAL_GCS_PS_Scavenge], Count, 2013 [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 4263 [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.749683455261677 [TOTAL_GCS_PS_MarkSweep], Count, 0 [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0 [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0 [TOTAL_GCs], Count, 2013 [TOTAL_GC_TIME], Time(ms), 4263 [TOTAL_GC_TIME_%], Time(%), 0.749683455261677 [CLEANUP], Operations, 1 [CLEANUP], AverageLatency(us), 3405.0 [CLEANUP], MinLatency(us), 3404 [CLEANUP], MaxLatency(us), 3405 [CLEANUP], 95thPercentileLatency(us), 3405 [CLEANUP], 99thPercentileLatency(us), 3405 [SCAN], Operations, 100000 [SCAN], AverageLatency(us), 5666.21491 [SCAN], MinLatency(us), 1365 [SCAN], MaxLatency(us), 513535 [SCAN], 95thPercentileLatency(us), 9095 [SCAN], 99thPercentileLatency(us), 11591 [SCAN], Return=OK, 100000
我们进行了两个场景的测试,一个是正常查询(场景一),一个是走全表扫描(场景二),可以看到第一次测试总耗时和平均耗时都要低,OPS比第二次高出很多。