revision-id: 72a54d0b59055cb0ffe20a9a9be5cf09f95f60ac () parent(s): 3e6f15943587c3dd046d4d25ce1c85fe4d28eb5d author: Sergei Petrunia committer: Sergei Petrunia timestamp: 2020-03-10 18:27:33 +0300 message: Make 06-make-varchar_bench collect more data points --- filesort-bench1/06-make-collect-results.sh | 12 ++++++++---- filesort-bench1/06-make-varchar-bench.sh | 5 +++-- 2 files changed, 11 insertions(+), 6 deletions(-) diff --git a/filesort-bench1/06-make-collect-results.sh b/filesort-bench1/06-make-collect-results.sh index be49046..a659ce6 100644 --- a/filesort-bench1/06-make-collect-results.sh +++ b/filesort-bench1/06-make-collect-results.sh @@ -9,7 +9,8 @@ create table rep_by_vcsize ( table_size int, END -for varchar_size in 50 100 150 200 250; do +VARCHAR_SIZES="25 50 75 100 125 150 200 255"; +for varchar_size in $VARCHAR_SIZES ; do echo -n " vc${varchar_size} int, " done @@ -17,14 +18,16 @@ cat << END dummy int); END -for table_size in 100000 500000 1000000 2000000 4000000 8000000 ; do +TABLE_SIZES="25000 50000 100000 500000 1000000 2000000 4000000" +#for table_size in 100000 500000 1000000 2000000 4000000 8000000 ; do +for table_size in $TABLE_SIZES ; do cat << END insert into rep_by_vcsize select $table_size, END -for varchar_size in 50 100 150 200 250; do +for varchar_size in $VARCHAR_SIZES ; do cat <<END (select test_time_ms from test_runs where table_size=$table_size and varchar_size= $varchar_size), @@ -42,7 +45,7 @@ done heading="select 'table_size" query_str="select concat(table_size,',', " -for varchar_size in 50 100 150 200 250; do +for varchar_size in $VARCHAR_SIZES ; do heading="$heading,$varchar_size" query_str="$query_str vc${varchar_size},',', " done @@ -52,3 +55,4 @@ query_str="$query_str 0) as H from rep_by_vcsize;" echo $heading echo $query_str + diff --git a/filesort-bench1/06-make-varchar-bench.sh b/filesort-bench1/06-make-varchar-bench.sh index bb1754b..85afcfd 100644 --- a/filesort-bench1/06-make-varchar-bench.sh +++ b/filesort-bench1/06-make-varchar-bench.sh @@ -34,11 +34,12 @@ END ### -for table_size in 100000 500000 1000000 2000000 4000000 8000000 ; do +for table_size in 25000 50000 100000 500000 1000000 2000000 4000000 ; do +#8000000 ; do # 16000000 #32000000 # if -for varchar_size in 50 100 150 200 250 ; do +for varchar_size in 25 50 75 100 125 150 200 255 ; do rand_table_name="t_rand_${table_size}_${varchar_size}" test_table_name="t_char_${table_size}_${varchar_size}"