Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The benchmark seems to run more than designated time. #21

Open
gowtham500 opened this issue Mar 25, 2020 · 0 comments
Open

The benchmark seems to run more than designated time. #21

gowtham500 opened this issue Mar 25, 2020 · 0 comments

Comments

@gowtham500
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant