revision-id: 9f187fd724c7c1c0217fe5fecf4e7ef361579497 () parent(s): c04d43a9833865607a2529c29801b52ef2a8c729 author: Sergei Petrunia committer: Sergei Petrunia timestamp: 2020-03-16 23:00:03 +0300 message: Test MyRocks-style encoding --- .gitignore | 5 +++++ 25-collect-results.sh | 18 ++++++++++++++++++ 25-setup-memcmp-trees.sh | 8 ++++++++ 25-varchar-memcmp.sh | 20 ++++++++++++++++++++ 4 files changed, 51 insertions(+) diff --git a/.gitignore b/.gitignore index dc2b0c7..8e56f01 100644 --- a/.gitignore +++ b/.gitignore @@ -28,3 +28,8 @@ my-mariadb-10.4.cnf my-mysql-8.0.cnf mysql-8.0-data mysql-8.0-vars.sh +10.5-memcmp +10.5-memcmp-data +10.5-memcmp-data.clean +10.5-memcmp-vars.sh +my-10.5-memcmp.cnf diff --git a/25-collect-results.sh b/25-collect-results.sh new file mode 100644 index 0000000..1f9c247 --- /dev/null +++ b/25-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-new 10.5-memcmp ; 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/25-setup-memcmp-trees.sh b/25-setup-memcmp-trees.sh new file mode 100644 index 0000000..cf7bd78 --- /dev/null +++ b/25-setup-memcmp-trees.sh @@ -0,0 +1,8 @@ +#!/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 + +./setup-server/setup-mariadb-current.sh 10.5-mdev21955 d187214b884f3f37eda052dacc701eece6284183 10.5-memcmp + + diff --git a/25-varchar-memcmp.sh b/25-varchar-memcmp.sh new file mode 100644 index 0000000..5156bf7 --- /dev/null +++ b/25-varchar-memcmp.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-memcmp 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