This is an automated email from the ASF dual-hosted git repository. kxiao pushed a commit to branch branch-2.0 in repository https://gitbox.apache.org/repos/asf/doris.git
commit a7e8b28287ee62976c4303e73edd4482e7f10598 Author: 郭小龙 <[email protected]> AuthorDate: Mon Jul 10 11:45:45 2023 +0800 [improvement](ssb) run-ssb-queries.sh and run-ssb-flat-queries.sh add analyze database with sync and calculate total time #21653 --- tools/ssb-tools/bin/run-ssb-flat-queries.sh | 6 ++++++ tools/ssb-tools/bin/run-ssb-queries.sh | 6 ++++++ 2 files changed, 12 insertions(+) diff --git a/tools/ssb-tools/bin/run-ssb-flat-queries.sh b/tools/ssb-tools/bin/run-ssb-flat-queries.sh index b94693be53..133c7216aa 100755 --- a/tools/ssb-tools/bin/run-ssb-flat-queries.sh +++ b/tools/ssb-tools/bin/run-ssb-flat-queries.sh @@ -122,6 +122,12 @@ run_sql "show variables;" echo '============================================' run_sql "show table status;" echo '============================================' +start=$(date +%s) +run_sql "analyze database ${DB} with sync;" +end=$(date +%s) +totalTime=$((end - start)) +echo "analyze database ${DB} with sync total time: ${totalTime} s" +echo '============================================' sum=0 for i in '1.1' '1.2' '1.3' '2.1' '2.2' '2.3' '3.1' '3.2' '3.3' '3.4' '4.1' '4.2' '4.3'; do diff --git a/tools/ssb-tools/bin/run-ssb-queries.sh b/tools/ssb-tools/bin/run-ssb-queries.sh index ba3b0e04eb..ad5aecd9af 100755 --- a/tools/ssb-tools/bin/run-ssb-queries.sh +++ b/tools/ssb-tools/bin/run-ssb-queries.sh @@ -132,6 +132,12 @@ run_sql "show variables;" echo '============================================' run_sql "show table status;" echo '============================================' +start=$(date +%s) +run_sql "analyze database ${DB} with sync;" +end=$(date +%s) +totalTime=$((end - start)) +echo "analyze database ${DB} with sync total time: ${totalTime} s" +echo '============================================' sum=0 for i in '1.1' '1.2' '1.3' '2.1' '2.2' '2.3' '3.1' '3.2' '3.3' '3.4' '4.1' '4.2' '4.3'; do --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
