-
Notifications
You must be signed in to change notification settings - Fork 0
/
scalability.sh
executable file
·57 lines (53 loc) · 2.42 KB
/
scalability.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
#!/bin/bash
P=4096
B=32
T=4
E=512
R=1
#BCC=131072
BCC=65536
# Remember to specify a path for your dedicated storage device
#DB_HOME="/scratchNVM1/zczhu/test_db_dir/db_working_home"
DB_HOME="./db_working_home"
Z_list=("0.0" "1.0")
ZD_list=("3")
bpk_list=("2.0" "4.0")
scale_factor_list=("1.0" "2.0" "4.0" "8.0" "16.0")
#scale_factor_list=("1.0")
#bpk_list=("2.0" "3.0" "4.0" "5.0")
dir="output/"
mkdir -p "${dir}"
#cp output/*.sh ${dir}
for scale_factor in ${scale_factor_list[@]}
do
cd ../workload_generator_scripts/
../workload_generator_scripts/zipfian_only_workload.sh ${scale_factor}
cd -
mkdir -p "${dir}/SF${scale_factor}/"
newBCC=`echo "${BCC}*${scale_factor}" | bc | awk '{printf("%d\n",$1)}' `
echo ${newBCC}
for ZD in ${ZD_list[@]}
do
for Z in ${Z_list[@]}
do
for bpk in ${bpk_list[@]}
do
echo "./simple_benchmark -T ${T} -E ${E} --dd -p ${DB_HOME} --qwp ../workload_generator_scripts/Z${Z}_ZD${ZD}_simple_mixed_query_workload.txt -B ${B} -P ${P} -b ${bpk} --BCC ${newBCC} -V 1 --no_dynamic_cmpct --dw --dr > ${dir}/SF${scale_factor}/Z${Z}_ZD${ZD}_bpk-${bpk}_output_simple_mixed_workload.txt"
./simple_benchmark -T ${T} -E ${E} --dd -p ${DB_HOME} --qwp ../workload_generator_scripts/Z${Z}_ZD${ZD}_simple_mixed_query_workload.txt -B ${B} -P ${P} -b ${bpk} --BCC ${newBCC} -R ${R} -V 1 --no_dynamic_cmpct --dw --dr > ${dir}/SF${scale_factor}/Z${Z}_ZD${ZD}_bpk-${bpk}_output_simple_mixed_workload.txt
#./simple_benchmark -T ${T} -E ${E} --dd -p ${DB_HOME} --qwp ../workload_generator_scripts/Z${Z}_ZD${ZD}_simple_mixed_query_workload.txt -B ${B} -P ${P} -b ${bpk} --BCC ${BCC} -R ${R} -V 1 --no_dynamic_cmpct > ${dir}/Z${Z}_ZD${ZD}_bpk-${bpk}_output_simple_mixed_workload.txt
rm ${DB_HOME}/*
rm ${DB_HOME}-monkey/*
rm ${DB_HOME}-workloadaware/*
done
#cp ../workload_generator_scripts/Z${Z}_ZD${ZD}_query_workload.txt ./${dir}/
cd ${dir}/SF${scale_factor}
../grep_accessed_data_blocks_by_bpk.sh ${ZD} ${Z} > accessed_data_blocks_ZD${ZD}_Z${Z}_result.txt
../grep_read_bytes_by_bpk.sh ${ZD} ${Z} > read_bytes_ZD${ZD}_Z${Z}_result.txt
../grep_query_latency_by_bpk.sh ${ZD} ${Z} > query_latency_ZD${ZD}_Z${Z}_result.txt
../grep_avg_latency_by_bpk.sh ${ZD} ${Z} > avg_latency_ZD${ZD}_Z${Z}_result.txt
../grep_write_latency_by_bpk.sh ${ZD} ${Z} > write_latency_ZD${ZD}_Z${Z}_result.txt
cd -
done
done
done
#cp ../workload_generator_scripts/ingestion_workload.txt ${dir}/