sysbench-mongodb icon indicating copy to clipboard operation
sysbench-mongodb copied to clipboard

The benchmark seems to run more than designated time.

Open gowtham500 opened this issue 4 years ago • 0 comments

Hello team,

  1. 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.

  2. 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

gowtham500 avatar Mar 25 '20 15:03 gowtham500