/
all_small.sh
136 lines (99 loc) · 6.85 KB
/
all_small.sh
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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
ntabs=$1
nrows=$2
readsecs=$3
writesecs=$4
insertsecs=$5
dbAndCreds=$6
setup=$7
cleanup=$8
client=$9
tableoptions=${10}
sysbdir=${11}
ddir=${12}
dname=${13}
usepk=${14}
prepstmt=${15}
# value for "postwrite" option for most tests
pwr=0
# The remaining args are the number of concurrent users per test run, for example "1 2 4"
shift 15
# This does load, runs a query test and then does "postwrite" work
echo point-query.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds $setup 0 point-query.warm 100 $client $tableoptions $sysbdir $ddir $dname $usepk 1 $prepstmt $ntabs
echo point-query.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 point-query.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
for range in 10 100 1000 ; do
echo random-points.pre range $range
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 random-points.pre $range $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
done
for range in 10 100 10000 ; do
echo read-only.pre range $range
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 read-only.pre $range $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
done
echo points-covered-pk.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-covered-pk.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo points-notcovered-pk.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-notcovered-pk.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo points-covered-si.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-covered-si.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo points-notcovered-si.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-notcovered-si.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-covered-pk.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-covered-pk.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-notcovered-pk.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-notcovered-pk.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-covered-si.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-covered-si.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-notcovered-si.pre
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-notcovered-si.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo update-inlist
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 update-inlist 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo update-index
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 update-index 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo update-nonindex
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 update-nonindex 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo update-one
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 update-one 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo update-zipf
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 update-zipf 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo write-only
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 write-only 10000 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo read-write range 10
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 read-write 10 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo read-write range 100 and do postwrite
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 read-write 100 $client $tableoptions $sysbdir $ddir $dname $usepk 1 $prepstmt $@
for range in 10 100 10000 ; do
echo read-only range $range
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 read-only $range $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
done
echo point-query
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 point-query 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
for range in 10 100 1000 ; do
echo random-points range $range
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 random-points $range $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
done
echo hot-points
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 hot-points 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo points-covered-pk
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-covered-pk 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo points-notcovered-pk
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-notcovered-pk 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo points-covered-si
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-covered-si 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo points-notcovered-si
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 points-notcovered-si 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-covered-pk
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-covered-pk 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-notcovered-pk
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-notcovered-pk 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-covered-si
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-covered-si 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo range-notcovered-si
bash run.sh $ntabs $nrows $readsecs $dbAndCreds 0 0 range-notcovered-si 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo scan
bash run.sh $ntabs $nrows $insertsecs $dbAndCreds 0 0 scan 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $ntabs
echo delete
bash run.sh $ntabs $nrows $writesecs $dbAndCreds 0 0 delete 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo insert
bash run.sh $ntabs $nrows $insertsecs $dbAndCreds 0 $cleanup insert 100 $client $tableoptions $sysbdir $ddir $dname $usepk $pwr $prepstmt $@
echo Done