revision-id: 2d1fa80200411f92e84ca1f9aedd9868835b4b31 () parent(s): 72a54d0b59055cb0ffe20a9a9be5cf09f95f60ac author: Sergei Petrunia committer: Sergei Petrunia timestamp: 2020-03-11 12:52:34 +0300 message: Re-run the benchmark on the final patch --- .gitignore | 13 +++++++++++++ 20-setup-new-trees.sh | 6 ++++++ 21-collect-results.sh | 18 ++++++++++++++++++ 21-run-varch-bench-again.sh | 20 ++++++++++++++++++++ 4 files changed, 57 insertions(+) diff --git a/.gitignore b/.gitignore index 0469c25..fcd5175 100644 --- a/.gitignore +++ b/.gitignore @@ -10,3 +10,16 @@ mariadb-10.5-vars.sh my-mariadb-10.5.cnf mysql-vars.sh mariadb-10.4 +10.5-new-data +10.5-new-data.clean/ +10.5-new +10.5-old +10.5-old-data +10.5-old-data.clean +10.5-new-vars.sh +10.5-old-vars.sh +my-10.5-new.cnf +my-10.5-old.cnf +mysql-boost +mysql-8.0 +mysql8-data diff --git a/20-setup-new-trees.sh b/20-setup-new-trees.sh new file mode 100644 index 0000000..6f61b5f --- /dev/null +++ b/20-setup-new-trees.sh @@ -0,0 +1,6 @@ +#!/bin/bash + +./setup-server/setup-mariadb-current.sh 10.5 b753ac066bc26acda9deb707a31c112f1bbf9ec2 10.5-new +./setup-server/setup-mariadb-current.sh 10.5 561b5ce3647a63c343f70ce183e408423b3fa65c 10.5-old + + diff --git a/21-collect-results.sh b/21-collect-results.sh new file mode 100644 index 0000000..ca59338 --- /dev/null +++ b/21-collect-results.sh @@ -0,0 +1,18 @@ +#!/bin/bash + +set -e + +RES='result-varchars' + +#mkdir $RES + +bash filesort-bench1/06-make-collect-results.sh > $RES/collect-results.sql + +for SERVER in 10.5-old 10.5-new ; do + + bash prepare-server.sh -r -m $SERVER + source $SERVER-vars.sh + + $MYSQL $MYSQL_ARGS test < $RES/collect-results.sql | tee $RES/results-$SERVER.txt + +done diff --git a/21-run-varch-bench-again.sh b/21-run-varch-bench-again.sh new file mode 100644 index 0000000..4607fb5 --- /dev/null +++ b/21-run-varch-bench-again.sh @@ -0,0 +1,20 @@ +#!/bin/bash + +set -e + +RES='result-varchars' + +mkdir $RES + +bash filesort-bench1/06-make-varchar-bench.sh > $RES/varchar-bench.sql + +for SERVER in 10.5-old 10.5-new ; do + + (cd $SERVER; git log -1) > $RES/tree-$SERVER.txt + + bash prepare-server.sh -m $SERVER + source $SERVER-vars.sh + echo $SERVER + $MYSQL $MYSQL_ARGS test < $RES/varchar-bench.sql | tee $RES/varchar-$SERVER.txt + +done