/
all.sh
77 lines (59 loc) · 3.19 KB
/
all.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
ntabs=$1
nrows=$2
readsecs=$3
writesecs=$4
insertsecs=$5
engine=$6
setup=$7
cleanup=$8
client=$9
tableoptions=${10}
sysbdir=${11}
ddir=${12}
dname=${13}
usepk=${14}
concurrency="1 2 4 8 16 24 32 40 48 64"
# warm the cache but results will wiped
echo point-query.pre
bash run.sh $ntabs $nrows $readsecs $engine $setup 0 point-query.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk "48"
rm -rf sb.*.point-query.pre.*
echo point-query.pre
bash run.sh $ntabs $nrows $readsecs $engine 0 0 point-query.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo read-only.pre range 10000
bash run.sh $ntabs $nrows $readsecs $engine 0 0 read-only.pre 10000 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo random-points.pre
bash run.sh $ntabs $nrows $readsecs $engine 0 0 random-points.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
if [[ $usepk -eq 1 ]]; then
echo full-scan.pre
bash run.sh $ntabs $nrows $readsecs $engine 0 0 full-scan.pre 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
fi
echo update-inlist
bash run.sh $ntabs $nrows $writesecs $engine 0 0 update-inlist 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo update-one
bash run.sh $ntabs $nrows $writesecs $engine 0 0 update-one 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo update-index
bash run.sh $ntabs $nrows $writesecs $engine 0 0 update-index 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo update-nonindex
bash run.sh $ntabs $nrows $writesecs $engine 0 0 update-nonindex 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo delete
bash run.sh $ntabs $nrows $writesecs $engine 0 0 delete 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
for range in 100 10000 ; do
echo read-write range $range
bash run.sh $ntabs $nrows $writesecs $engine 0 0 read-write $range $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
done
for range in 100 10000 ; do
echo read-only range $range
bash run.sh $ntabs $nrows $readsecs $engine 0 0 read-only $range $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
done
echo point-query
bash run.sh $ntabs $nrows $readsecs $engine 0 0 point-query 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo random-points
bash run.sh $ntabs $nrows $readsecs $engine 0 0 random-points 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
echo hot-points
bash run.sh $ntabs $nrows $readsecs $engine 0 0 hot-points 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
if [[ $usepk -eq 1 ]]; then
echo full-scan.post
bash run.sh $ntabs $nrows $readsecs $engine 0 0 full-scan.post 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency
fi
echo insert
bash run.sh $ntabs $nrows $insertsecs $engine 0 $cleanup insert 100 $client $tableoptions $sysbdir $ddir $dname $usepk $concurrency