== Test run #1 : improved2 , MDEV-29104 === commit 4f07e31a18a60782f54c9d92daf93df848748992 (HEAD -> bb-10.11-MDEV-29104, origin/bb-10.11-MDEV-29104) Author: Oleg Smirnov Date: Mon Sep 19 21:36:09 2022 +0700 MDEV-29104 Optimize queries to INFORMATION_SCHEMA.PARAMETERS/ROUTINES psergey@blackbox:~/mdev29104$ bash run.sh Benchmark Average number of seconds to run all queries: 0.006 seconds Minimum number of seconds to run all queries: 0.006 seconds Maximum number of seconds to run all queries: 0.007 seconds Number of clients running queries: 1 Average number of queries per client: 1 Benchmark Average number of seconds to run all queries: 0.033 seconds Minimum number of seconds to run all queries: 0.033 seconds Maximum number of seconds to run all queries: 0.035 seconds Number of clients running queries: 5 Average number of queries per client: 1 Benchmark Average number of seconds to run all queries: 0.158 seconds Minimum number of seconds to run all queries: 0.157 seconds Maximum number of seconds to run all queries: 0.159 seconds Number of clients running queries: 20 Average number of queries per client: 1 Benchmark Average number of seconds to run all queries: 0.800 seconds Minimum number of seconds to run all queries: 0.796 seconds Maximum number of seconds to run all queries: 0.809 seconds Number of clients running queries: 100 Average number of queries per client: 1 == Test run #2: improved 1, fix for 20609 == commit a7f2b2d70b66ff2dbe93d212eaf6af99a6d5fb5e (HEAD -> bb-10.11-MDEV-29104) Author: Oleg Smirnov Date: Fri Sep 16 15:04:54 2022 +0400 MDEV-29550 Fix Valgrind/MSAN uninitialised value errors psergey@blackbox:~/mdev29104$ bash -x run.sh + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 1 Benchmark Average number of seconds to run all queries: 0.138 seconds Minimum number of seconds to run all queries: 0.134 seconds Maximum number of seconds to run all queries: 0.166 seconds Number of clients running queries: 1 Average number of queries per client: 1 + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 5 Benchmark Average number of seconds to run all queries: 0.283 seconds Minimum number of seconds to run all queries: 0.276 seconds Maximum number of seconds to run all queries: 0.296 seconds Number of clients running queries: 5 Average number of queries per client: 1 + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 20 Benchmark Average number of seconds to run all queries: 2.152 seconds Minimum number of seconds to run all queries: 2.133 seconds Maximum number of seconds to run all queries: 2.179 seconds Number of clients running queries: 20 Average number of queries per client: 1 + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 100 Benchmark Average number of seconds to run all queries: 10.802 seconds Minimum number of seconds to run all queries: 10.771 seconds Maximum number of seconds to run all queries: 10.871 seconds Number of clients running queries: 100 Average number of queries per client: 1 == Test run #3 : Vanilla 10.11 == commit 3ec4241b00aee10e4b0eb1f6cc596f336e6ad1e5 (HEAD -> bb-10.11-MDEV-29104) Merge: 90608bd6490 6978bcbf374 Author: Marko Mäkelä Date: Wed Sep 7 10:14:41 2022 +0300 Merge 10.10 into 10.11 psergey@blackbox:~/mdev29104$ bash -x run.sh + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 1 Benchmark Average number of seconds to run all queries: 0.136 seconds Minimum number of seconds to run all queries: 0.132 seconds Maximum number of seconds to run all queries: 0.164 seconds Number of clients running queries: 1 Average number of queries per client: 1 + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 5 Benchmark Average number of seconds to run all queries: 0.293 seconds Minimum number of seconds to run all queries: 0.282 seconds Maximum number of seconds to run all queries: 0.307 seconds Number of clients running queries: 5 Average number of queries per client: 1 + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 20 Benchmark Average number of seconds to run all queries: 2.146 seconds Minimum number of seconds to run all queries: 2.130 seconds Maximum number of seconds to run all queries: 2.173 seconds Number of clients running queries: 20 Average number of queries per client: 1 + for i in 1 5 20 100 + /home/psergey/dev-git2/10.11-info-schema-review/client/mysqlslap --socket=/tmp/mysql4.sock -uroot -q 'select * from information_schema.parameters where SPECIFIC_NAME = '\''aaa_sp50001'\''' -i 10 -c 100 Benchmark Average number of seconds to run all queries: 10.812 seconds Minimum number of seconds to run all queries: 10.772 seconds Maximum number of seconds to run all queries: 10.868 seconds Number of clients running queries: 100 Average number of queries per client: 1