forked from tmcallaghan/sysbench-mongodb
-
Notifications
You must be signed in to change notification settings - Fork 1
/
config.small.bash
119 lines (88 loc) · 3.61 KB
/
config.small.bash
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
# You will most likely want to change these values
# 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=none
# database password to use for USERNAME
export PASSWORD=none
# name of the server to connect to
export MONGO_SERVER=localhost
# 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 )
# if running TokuMX, need to select compression for collection and secondary indexes (zlib is default)
# valid values : lzma, quicklz, zlib, none
export MONGO_COMPRESSION=zlib
# if running TokuMX, need to select basement node size (65536 is default)
# valid values : integer > 0 : 65536 for 64K
export MONGO_BASEMENT=65536
# number of collections to create for the benchmark
# valid values : integer > 0
export NUM_COLLECTIONS=4
# number of documents to maintain per collection
# valid values : integer > 0
export NUM_DOCUMENTS_PER_COLLECTION=10000
# 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=4
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=999999
# 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