sysbench-mongodb
sysbench-mongodb copied to clipboard
The benchmark seems to run more than designated time.
Hello team,
-
This is my config.bash. I have set it run for 1 min. But it runs more than that. Can you please let me know if I have missed any.
-
Can you please let me know as to what can be measured in these tests? ex: CPU metrics, TPS etc.
# database in which to run the benchmark
export DB_NAME=sbtest
# database username on DB_NAME
# Use USERNAME=none
# to login to mongodb without using credentials.
export USERNAME=username
# database password to use for USERNAME
export PASSWORD=password
# name of the server to connect to
export MONGO_SERVER=fqdn
# port of the server to connect to
export MONGO_PORT=27017
# Use "yes" to load the collections
DOLOAD=yes
# Use "yes" to execute the benchmark
DOQUERY=yes
# Use a seed for the RNG, like $( date +%s )
# This can be used to repeat, or not, the sequence of keys used per test.
SEED=$( date +%s )
# number of collections to create for the benchmark
# valid values : integer > 0
export NUM_COLLECTIONS=16
# number of documents to maintain per collection
# valid values : integer > 0
export NUM_DOCUMENTS_PER_COLLECTION=10000000
# total number of documents to insert per "batch"
# valid values : integer > 0
export NUM_DOCUMENTS_PER_INSERT=1000
# total number of simultaneous insertion threads (for loader)
# valid values : integer > 0
export NUM_LOADER_THREADS=8
# total number of simultaneous benchmark threads
# valid values : integer > 0
export NUM_WRITER_THREADS=64
# run the benchmark for this many minutes
# valid values : intever > 0
export RUN_TIME_MINUTES=1
export RUN_TIME_SECONDS=$[RUN_TIME_MINUTES*60]
# write concern for the benchmark client
# valid values : FSYNC_SAFE, NONE, NORMAL, REPLICAS_SAFE, SAFE
export WRITE_CONCERN=SAFE
# total number of transactions per second, allows for the benchmark to be rate limited
# valid values : integer > 0
export MAX_TPS=500
# display performance information every time the client application inserts this many documents
# valid values : integer > 0, set to -1 if using NUM_SECONDS_PER_FEEDBACK
export NUM_INSERTS_PER_FEEDBACK=-1
# display performance information every time the client application has run for this many seconds
# valid values : integer > 0, set to -1 if using NUM_INSERTS_PER_FEEDBACK
export NUM_SECONDS_PER_FEEDBACK=10
# set to N to use begin/commit/ensure for TokuMX
# valid values : N or Y
export SYSBENCH_AUTO_COMMIT=Y
# number of documents to retrieve in range queries
# valid values : integer > 0
export SYSBENCH_RANGE_SIZE=100
# number of point queries per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_POINT_SELECTS=10
# number of simple range queries per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_SIMPLE_RANGES=1
# number of aggregation queries per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_SUM_RANGES=1
# number of ordered range queries per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_ORDER_RANGES=1
# number of distinct range queries per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_DISTINCT_RANGES=1
# set all of the following 3 parameters to zero for a read-only benchmark
# number of indexed updates per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_INDEX_UPDATES=1
# number of non-indexed updates per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_NON_INDEX_UPDATES=1
# number of delete/insert operations per sysbench "transaction"
# valid values : integer >= 0
export SYSBENCH_INSERTS=1