This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 9f3bc11b04 [improvement](ssb) run-ssb-queries.sh and
run-ssb-flat-queries.sh add analyze database with sync and calculate total time
#21653
9f3bc11b04 is described below
commit 9f3bc11b04da1abde91bd9b5179271ddeccfd20d
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]
