revision-id: 407cc78edcc4f65daf64739ed18ff33e4c50d3d5 () parent(s): 8d669d6a36d798f9d4f2162789b702a227484474 author: Sergei Petrunia committer: Sergei Petrunia timestamp: 2020-03-09 00:34:34 +0300 message: 10-sort-int-overhead.sh --- .gitignore | 1 + 10-setup-trees-reg1.sh | 6 ++++++ 10-sort-int-overhead.sh | 29 +++++++++++++++++++++++++++++ 3 files changed, 36 insertions(+) diff --git a/.gitignore b/.gitignore index cac097e..0469c25 100644 --- a/.gitignore +++ b/.gitignore @@ -9,3 +9,4 @@ mariadb-10.5-data mariadb-10.5-vars.sh my-mariadb-10.5.cnf mysql-vars.sh +mariadb-10.4 diff --git a/10-setup-trees-reg1.sh b/10-setup-trees-reg1.sh new file mode 100644 index 0000000..46fe82d --- /dev/null +++ b/10-setup-trees-reg1.sh @@ -0,0 +1,6 @@ +#!/bin/bash + +./setup-server/setup-mariadb-current.sh 10.5-mdev21784-reg1-base +./setup-server/setup-mariadb-current.sh 10.5-mdev21784-reg1-vfuncs + + diff --git a/10-sort-int-overhead.sh b/10-sort-int-overhead.sh new file mode 100644 index 0000000..a2b2417 --- /dev/null +++ b/10-sort-int-overhead.sh @@ -0,0 +1,29 @@ +#!/bin/bash + +set -e + +RES='result-sort-int' + +mkdir $RES + +bash filesort-bench1/01-make-sort-int-bench.sh > $RES/sort-int-bench.sql + +for SERVER in 10.5-mdev21784-reg1-base 10.5-mdev21784-reg1-vfuncs ; do + + (cd $SERVER; git log -1) > $RES/tree-$SERVER.txt + + bash prepare-server.sh -m $SERVER + source $SERVER-vars.sh + + $MYSQL $MYSQL_ARGS test < $RES/sort-int-bench.sql | tee $RES/sort-int-$SERVER.txt + + echo "TEST_RUN:,$SERVER" >> $RES/summary.txt + tail -n 10 $RES/sort-int-$SERVER.txt >> $RES/summary.txt +done + +cat $RES/summary.txt + + + + +