This is an automated email from the ASF dual-hosted git repository.
kassiez pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 2f79bbb8cb1 [Doc](benchmark) update 2.1 benchmark doc. (#1493)
2f79bbb8cb1 is described below
commit 2f79bbb8cb137e93b6819f5287e88b11046beb63
Author: feifeifeimoon <wangyufeim...@gmail.com>
AuthorDate: Wed Dec 11 17:56:42 2024 +0800
[Doc](benchmark) update 2.1 benchmark doc. (#1493)
## Versions
- [x] dev
- [ ] 3.0
- [x] 2.1
- [x] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
benchmark/ssb.md | 93 ++++++++-------
benchmark/tpcds.md | 235 +++++++++++++++++++-------------------
benchmark/tpch.md | 80 ++++++-------
common_docs_zh/benchmark/ssb.md | 93 ++++++++-------
common_docs_zh/benchmark/tpcds.md | 231 +++++++++++++++++++------------------
common_docs_zh/benchmark/tpch.md | 87 +++++++-------
static/images/tpcds_2.1.png | Bin 586248 -> 462753 bytes
static/images/tpch_2.1.png | Bin 45732 -> 248565 bytes
8 files changed, 408 insertions(+), 411 deletions(-)
diff --git a/benchmark/ssb.md b/benchmark/ssb.md
index ef071f40ec0..7922b74b412 100644
--- a/benchmark/ssb.md
+++ b/benchmark/ssb.md
@@ -30,25 +30,24 @@ under the License.
This document mainly introduces the performance of Doris on the SSB 1000G test
set.
-We tested 13 queries on the SSB standard test dataset based on Apache Doris
version 2.0.6.
+We tested 13 queries on the SSB standard test dataset based on Apache Doris
version 2.0.16.
## 1. Hardware Environment
-| Hardware | Configuration Instructions |
-|---------------------|-------------------------------------------|
-| Number of mMachines | 4 Tencent Cloud Virtual Machine（1FE，3BEs） |
-| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48C |
-| Memory | 192G |
-| Network | 21Gbps |
-| Disk | ESSD Cloud Hard Disk |
+| Hardware | Configuration Instructions |
+|--------------------|------------------------------------------|
+| Number of Machines | 4 Aliyun Virtual Machine (1FE，3BEs) |
+| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32C |
+| Memory | 128G |
+| Disk | Enterprise SSD (PL0) |
## 2. Software Environment
- Doris Deployed 3BEs and 1FE
-- Kernel Version: Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051)
+- Kernel Version: Linux version 5.15.0-101-generic
- OS version: Ubuntu 20.04 LTS (Focal Fossa)
-- Doris software version: Apache Doris 2.0.6.
-- JDK: openjdk version "1.8.0_131"
+- Doris software version: Apache Doris 2.0.16-rc01
+- JDK: openjdk version "1.8.0_352-352"
## 3. Test Data Volume
@@ -63,46 +62,46 @@ We tested 13 queries on the SSB standard test dataset based
on Apache Doris vers
## 4. SSB Flat Test Results
-Here we use Apache Doris 2.0.6 for comparative testing. In the test, we use
Query Time(ms) as the main performance indicator. The test results are as
follows:
-
-| Query | Doris 2.0.6 (ms) |
-|-------|------------------|
-| q1.1 | 86 |
-| q1.2 | 31 |
-| q1.3 | 87 |
-| q2.1 | 1046 |
-| q2.2 | 569 |
-| q2.3 | 480 |
-| q3.1 | 1339 |
-| q3.2 | 957 |
-| q3.3 | 215 |
-| q3.4 | 34 |
-| q4.1 | 1569 |
-| q4.2 | 174 |
-| q4.3 | 109 |
-| Total | 6696 |
+Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use
Query Time(ms) as the main performance indicator. The test results are as
follows:
+
+| Query | Doris 2.0.16 (ms) |
+|-----------|-------------------|
+| q1.1 | 80 |
+| q1.2 | 10 |
+| q1.3 | 110 |
+| q2.1 | 1680 |
+| q2.2 | 1210 |
+| q2.3 | 1060 |
+| q3.1 | 2010 |
+| q3.2 | 1560 |
+| q3.3 | 600 |
+| q3.4 | 10 |
+| q4.1 | 2380 |
+| q4.2 | 190 |
+| q4.3 | 120 |
+| **Total** | **11020** |
## 5. Standard SSB Test Results
-Here we use Apache Doris 2.0.6 for comparative testing. In the test, we use
Query Time(ms) as the main performance indicator. The test results are as
follows:
-
-| Query | Doris 2.0.6 (ms) |
-|-------|------------------|
-| q1.1 | 332 |
-| q1.2 | 86 |
-| q1.3 | 80 |
-| q2.1 | 985 |
-| q2.2 | 844 |
-| q2.3 | 768 |
-| q3.1 | 2924 |
-| q3.2 | 944 |
-| q3.3 | 766 |
-| q3.4 | 146 |
-| q4.1 | 3451 |
-| q4.2 | 829 |
-| q4.3 | 325 |
-| Total | 12480 |
+Here we use Apache Doris 2.0.16 for comparative testing. In the test, we use
Query Time(ms) as the main performance indicator. The test results are as
follows:
+
+| Query | Doris 2.0.16 (ms) |
+|-----------|-------------------|
+| q1.1 | 330 |
+| q1.2 | 80 |
+| q1.3 | 80 |
+| q2.1 | 1780 |
+| q2.2 | 1970 |
+| q2.3 | 1510 |
+| q3.1 | 4000 |
+| q3.2 | 1720 |
+| q3.3 | 1510 |
+| q3.4 | 160 |
+| q4.1 | 4010 |
+| q4.2 | 840 |
+| q4.3 | 400 |
+| **Total** | **19390** |
## 6. Environment Preparation
diff --git a/benchmark/tpcds.md b/benchmark/tpcds.md
index a90df892d90..11caff6d940 100644
--- a/benchmark/tpcds.md
+++ b/benchmark/tpcds.md
@@ -32,32 +32,32 @@ The design goal of TPC-DS is to simulate complex decision
support workloads in t
This document mainly introduces the performance of Doris on the TPC-DS 1000G
test set.
-On 99 queries on the TPC-DS standard test data set, we conducted a comparison
test based on Apache Doris 2.1.1-rc03 and Apache Doris 2.0.6 versions.
+On 99 queries on the TPC-DS standard test data set, we conducted a comparison
test based on Apache Doris 2.1.7-rc03 and Apache Doris 2.0.16-rc01 versions.
## 1. Hardware Environment
-| Hardware | Configuration Instructions |
-|---------------------|-------------------------------------------|
-| Number of mMachines | 4 Tencent Cloud Virtual Machine（1FE，3BEs） |
-| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48C |
-| Memory | 192G |
-| Network | 21Gbps |
-| Disk | ESSD Cloud Hard Disk |
+| Hardware | Configuration Instructions |
+|--------------------|------------------------------------------|
+| Number of Machines | 4 Aliyun Virtual Machine (1FE，3BEs) |
+| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32C |
+| Memory | 128G |
+| Disk | Enterprise SSD (PL0) |
+
## 2. Software Environment
- Doris Deployed 3BEs and 1FE
-- Kernel Version: Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051)
+- Kernel Version: Linux version 5.15.0-101-generic
- OS version: Ubuntu 20.04 LTS (Focal Fossa)
-- Doris software version: Apache Doris 2.1.1-rc03, Apache Doris 2.0.6.
-- JDK: openjdk version "1.8.0_131"
+- Doris software version: Apache Doris 2.1.7-rc03, Apache Doris 2.0.16-rc01
+- JDK: openjdk version "1.8.0_352-352"
## 3. Test Data Volume
-The TPC-DS 1000G data generated by the simulation of the entire test are
respectively imported into Apache Doris 2.1.1-rc03 and Apache Doris 2.0.6 for
testing. The following is the relevant description and data volume of the table.
+The TPC-DS 1000G data generated by the simulation of the entire test are
respectively imported into Apache Doris 2.1.7-rc03 and Apache Doris 2.0.16-rc01
for testing. The following is the relevant description and data volume of the
table.
| TPC-DS Table Name | Rows |
|------------------------|---------------|
@@ -92,110 +92,111 @@ TPC-DS 99 test query statements :
[TPC-DS-Query-SQL](https://github.com/apache/d
## 5. Test Results
-Here we use Apache Doris 2.1.1-rc03 and Apache Doris 2.0.6 for comparative
testing. In the test, we use Query Time(ms) as the main performance indicator.
The test results are as follows:
-
-| Query | Apache Doris 2.1.1-rc03 (ms) | Apache Doris 2.0.6 (ms) |
-|-----------|-------------------------------|--------------------------|
-| query1 | 729 | 914 |
-| query2 | 5120 | 4669 |
-| query3 | 286 | 285 |
-| query4 | 11633 | 35148 |
-| query5 | 641 | 22979 |
-| query6 | 267 | 1351 |
-| query7 | 468 | 517 |
-| query8 | 263 | 591 |
-| query9 | 4444 | 5430 |
-| query10 | 418 | 3341 |
-| query11 | 7246 | 23300 |
-| query12 | 115 | 105 |
-| query13 | 661 | 1719 |
-| query14 | 13955 | 33254 |
-| query15 | 474 | 1414 |
-| query16 | 366 | 402 |
-| query17 | 1097 | 2371 |
-| query18 | 581 | 760 |
-| query19 | 283 | 308 |
-| query20 | 137 | 117 |
-| query21 | 110 | 94 |
-| query22 | 1996 | 2481 |
-| query23 | 44826 | 77381 |
-| query24 | 9873 | 23910 |
-| query25 | 666 | 1021 |
-| query26 | 221 | 213 |
-| query27 | 490 | 544 |
-| query28 | 4089 | 4593 |
-| query29 | 768 | 1024 |
-| query30 | 313 | 682 |
-| query31 | 1847 | 2252 |
-| query32 | 71 | 68 |
-| query33 | 460 | 539 |
-| query34 | 629 | 638 |
-| query35 | 1660 | 10505 |
-| query36 | 412 | 441 |
-| query37 | 94 | 86 |
-| query38 | 8804 | 8379 |
-| query39 | 606 | 898 |
-| query40 | 164 | 190 |
-| query41 | 55 | 30 |
-| query42 | 115 | 113 |
-| query43 | 804 | 1332 |
-| query44 | 1509 | 1520 |
-| query45 | 1678 | 1306 |
-| query46 | 1196 | 2167 |
-| query47 | 2812 | 3859 |
-| query48 | 559 | 1419 |
-| query49 | 646 | 725 |
-| query50 | 757 | 1299 |
-| query51 | 6380 | 4954 |
-| query52 | 128 | 123 |
-| query53 | 396 | 391 |
-| query54 | 388 | 8212 |
-| query55 | 124 | 124 |
-| query56 | 360 | 434 |
-| query57 | 1811 | 2494 |
-| query58 | 304 | 666 |
-| query59 | 5758 | 7432 |
-| query60 | 474 | 481 |
-| query61 | 486 | 536 |
-| query62 | 647 | 1082 |
-| query63 | 358 | 303 |
-| query64 | 3250 | 4968 |
-| query65 | 5410 | 5971 |
-| query66 | 484 | 603 |
-| query67 | 26347 | 34052 |
-| query68 | 1422 | 1428 |
-| query69 | 654 | 808 |
-| query70 | 2285 | 4462 |
-| query71 | 650 | 1006 |
-| query72 | 4324 | 4717 |
-| query73 | 500 | 558 |
-| query74 | 6678 | 14127 |
-| query75 | 3734 | 6312 |
-| query76 | 1835 | 1870 |
-| query77 | 382 | 496 |
-| query78 | 19923 | 23091 |
-| query79 | 3061 | 4090 |
-| query80 | 851 | 1559 |
-| query81 | 565 | 960 |
-| query82 | 242 | 221 |
-| query83 | 254 | 415 |
-| query84 | 203 | 131 |
-| query85 | 364 | 444 |
-| query86 | 651 | 931 |
-| query87 | 8972 | 8554 |
-| query88 | 4095 | 5202 |
-| query89 | 508 | 480 |
-| query90 | 233 | 322 |
-| query91 | 174 | 159 |
-| query92 | 62 | 59 |
-| query93 | 1601 | 1618 |
-| query94 | 297 | 297 |
-| query95 | 1240 | 27354 |
-| query96 | 508 | 847 |
-| query97 | 5449 | 11528 |
-| query98 | 382 | 287 |
-| query99 | 1410 | 2147 |
-| **Total** | **264028** | **487990** |
+Here we use Apache Doris 2.1.7-rc03 and Apache Doris 2.0.16-rc01 for
comparative testing. In the test, we use Query Time(ms) as the main performance
indicator.
+The test results are as follows: (Apache Doris 2.0.16-rc01 q78 q79 failed to
execute due to lack of latest memory optimization and was removed when
calculating the total sum)
+
+| Query | Apache Doris 2.1.7-rc03 (ms) | Apache Doris 2.0.16-rc01 (ms) |
+|-----------|-------------------------------|--------------------------------|
+| query01 | 630 | 890 |
+| query02 | 4930 | 6930 |
+| query03 | 360 | 460 |
+| query04 | 11070 | 42320 |
+| query05 | 620 | 15360 |
+| query06 | 220 | 1020 |
+| query07 | 550 | 750 |
+| query08 | 330 | 670 |
+| query09 | 6830 | 7550 |
+| query10 | 370 | 2900 |
+| query11 | 6960 | 27380 |
+| query12 | 100 | 80 |
+| query13 | 790 | 2860 |
+| query14 | 13470 | 42340 |
+| query15 | 510 | 940 |
+| query16 | 520 | 550 |
+| query17 | 1310 | 2650 |
+| query18 | 560 | 820 |
+| query19 | 200 | 400 |
+| query20 | 100 | 190 |
+| query21 | 80 | 80 |
+| query22 | 2300 | 3070 |
+| query23 | 38240 | 75260 |
+| query24 | 8340 | 26580 |
+| query25 | 780 | 1190 |
+| query26 | 200 | 220 |
+| query27 | 530 | 750 |
+| query28 | 5940 | 7400 |
+| query29 | 940 | 1250 |
+| query30 | 270 | 490 |
+| query31 | 1890 | 2530 |
+| query32 | 60 | 70 |
+| query33 | 350 | 450 |
+| query34 | 750 | 1380 |
+| query35 | 1370 | 8970 |
+| query36 | 530 | 570 |
+| query37 | 60 | 60 |
+| query38 | 7520 | 8710 |
+| query39 | 560 | 1010 |
+| query40 | 150 | 180 |
+| query41 | 50 | 40 |
+| query42 | 100 | 140 |
+| query43 | 1150 | 1960 |
+| query44 | 2020 | 3220 |
+| query45 | 430 | 960 |
+| query46 | 1250 | 2760 |
+| query47 | 2660 | 5790 |
+| query48 | 630 | 2570 |
+| query49 | 730 | 800 |
+| query50 | 1640 | 2200 |
+| query51 | 6430 | 6270 |
+| query52 | 110 | 160 |
+| query53 | 250 | 490 |
+| query54 | 1280 | 7790 |
+| query55 | 110 | 160 |
+| query56 | 290 | 410 |
+| query57 | 1480 | 3510 |
+| query58 | 240 | 550 |
+| query59 | 7760 | 11870 |
+| query60 | 380 | 490 |
+| query61 | 540 | 670 |
+| query62 | 740 | 1560 |
+| query63 | 210 | 460 |
+| query64 | 5790 | 6840 |
+| query65 | 4900 | 7960 |
+| query66 | 480 | 810 |
+| query67 | 27320 | 46110 |
+| query68 | 1600 | 2380 |
+| query69 | 380 | 800 |
+| query70 | 3480 | 5330 |
+| query71 | 460 | 790 |
+| query72 | 3160 | 5390 |
+| query73 | 660 | 1250 |
+| query74 | 5990 | 16450 |
+| query75 | 4610 | 8410 |
+| query76 | 1590 | 2950 |
+| query77 | 300 | 480 |
+| query78 | 17970 | - |
+| query79 | 3040 | - |
+| query80 | 570 | 910 |
+| query81 | 460 | 760 |
+| query82 | 270 | 330 |
+| query83 | 220 | 290 |
+| query84 | 130 | 110 |
+| query85 | 520 | 470 |
+| query86 | 760 | 1220 |
+| query87 | 800 | 8760 |
+| query88 | 5560 | 9690 |
+| query89 | 430 | 750 |
+| query90 | 150 | 400 |
+| query91 | 150 | 120 |
+| query92 | 40 | 40 |
+| query93 | 2440 | 2670 |
+| query94 | 340 | 310 |
+| query95 | 350 | 1810 |
+| query96 | 660 | 1680 |
+| query97 | 5020 | 14990 |
+| query98 | 190 | 330 |
+| query99 | 1560 | 3230 |
+| **Total** | **261320** | **507380** |
## 6. Environmental Preparation
@@ -255,7 +256,7 @@ export DB='tpcds'
```shell
sh bin/create-tpcds-tables.sh -s 1000
```
-Or copy the table creation statement in
[create-tpcds-tables.sql](https://github.com/apache/doris/blob/master/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000.sql)
and excute it in Doris.
+Or copy the table creation statement in
[create-tpcds-tables](https://github.com/apache/doris/blob/master/tools/tpcds-tools/ddl/create-tpcds-tables-sf1000)
and excute it in Doris.
### 7.4 Import Data
diff --git a/benchmark/tpch.md b/benchmark/tpch.md
index 1a7754520db..eaba87d1dc6 100644
--- a/benchmark/tpch.md
+++ b/benchmark/tpch.md
@@ -30,31 +30,31 @@ TPC-H is a decision support benchmark (Decision Support
Benchmark), which consis
This document mainly introduces the performance of Doris on the TPC-H 1000G
test set.
-On 22 queries on the TPC-H standard test data set, we conducted a comparison
test based on Apache Doris 2.1.1-rc03 and Apache Doris 2.0.6 versions.
+On 22 queries on the TPC-H standard test data set, we conducted a comparison
test based on Apache Doris 2.1.7-rc03 and Apache Doris 2.0.16-rc01 versions.
## 1. Hardware Environment
-| Hardware | Configuration Instructions |
-|---------------------|-------------------------------------------|
-| Number of mMachines | 4 Tencent Cloud Virtual Machine（1FE，3BEs） |
-| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48C |
-| Memory | 192G |
-| Network | 21Gbps |
-| Disk | ESSD Cloud Hard Disk |
+| Hardware | Configuration Instructions |
+|--------------------|------------------------------------------|
+| Number of Machines | 4 Aliyun Virtual Machine (1FE，3BEs) |
+| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32C |
+| Memory | 128G |
+| Disk | Enterprise SSD (PL0) |
+
## 2. Software Environment
- Doris Deployed 3BEs and 1FE
-- Kernel Version: Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051)
+- Kernel Version: Linux version 5.15.0-101-generic
- OS version: Ubuntu 20.04 LTS (Focal Fossa)
-- Doris software version: Apache Doris 2.1.1-rc03, Apache Doris 2.0.6.
-- JDK: openjdk version "1.8.0_131"
+- Doris software version: Apache Doris 2.1.7-rc03, Apache Doris 2.0.16-rc01
+- JDK: openjdk version "1.8.0_352-352"
## 3. Test Data Volume
-The TPCH 1000G data generated by the simulation of the entire test are
respectively imported into Apache Doris 2.1.1-rc03 and Apache Doris 2.0.6 for
testing. The following is the relevant description and data volume of the table.
+The TPC-H 1000G data generated by the simulation of the entire test are
respectively imported into Apache Doris 2.1.7-rc03 and Apache Doris 2.0.16-rc01
for testing. The following is the relevant description and data volume of the
table.
| TPC-H Table Name | Rows | Annotation |
|:-----------------|:--------------|:--------------|
@@ -69,38 +69,38 @@ The TPCH 1000G data generated by the simulation of the
entire test are respectiv
## 4. Test SQL
-TPCH 22 test query statements :
[TPCH-Query-SQL](https://github.com/apache/doris/tree/master/tools/tpch-tools/queries)
+TPC-H 22 test query statements :
[TPCH-Query-SQL](https://github.com/apache/doris/tree/master/tools/tpch-tools/queries/sf1000)
## 5. Test Results
-Here we use Apache Doris 2.1.1-rc03 and Apache Doris 2.0.6 for comparative
testing. In the test, we use Query Time(ms) as the main performance indicator.
The test results are as follows:
-
-| Query | Apache Doris 2.1.1-rc03 (ms) | Apache Doris 2.0.6 (ms) |
-|-----------|------------------------------|-------------------------|
-| Q1 | 7240 | 7638 |
-| Q2 | 249 | 377 |
-| Q3 | 3528 | 4389 |
-| Q4 | 1534 | 1903 |
-| Q5 | 5457 | 6425 |
-| Q6 | 159 | 150 |
-| Q7 | 1598 | 3141 |
-| Q8 | 2958 | 2792 |
-| Q9 | 14803 | 24732 |
-| Q10 | 6743 | 7315 |
-| Q11 | 414 | 395 |
-| Q12 | 371 | 417 |
-| Q13 | 6203 | 8095 |
-| Q14 | 485 | 681 |
-| Q15 | 2246 | 1459 |
-| Q16 | 1252 | 1382 |
-| Q17 | 1461 | 1204 |
-| Q18 | 10428 | 11386 |
-| Q19 | 2329 | 2172 |
-| Q20 | 569 | 1455 |
-| Q21 | 5574 | 6570 |
-| Q22 | 1042 | 1517 |
-| **Total** | **76643** | **95595** |
+Here we use Apache Doris 2.1.7-rc03 and Apache Doris 2.0.16-rc01 for
comparative testing. In the test, we use Query Time(ms) as the main performance
indicator. The test results are as follows:
+
+| Query | Apache Doris 2.1.7-rc03 (ms) | Apache Doris 2.0.16-rc01 (ms) |
+|-----------|------------------------------|-------------------------------|
+| Q1 | 11880 | 12270 |
+| Q2 | 280 | 290 |
+| Q3 | 3890 | 4610 |
+| Q4 | 2570 | 3040 |
+| Q5 | 6630 | 8450 |
+| Q6 | 170 | 180 |
+| Q7 | 2420 | 4870 |
+| Q8 | 3730 | 3850 |
+| Q9 | 15910 | 25860 |
+| Q10 | 7880 | 8650 |
+| Q11 | 560 | 490 |
+| Q12 | 500 | 660 |
+| Q13 | 9540 | 9920 |
+| Q14 | 590 | 740 |
+| Q15 | 1170 | 1150 |
+| Q16 | 910 | 1520 |
+| Q17 | 1920 | 1770 |
+| Q18 | 17700 | 18760 |
+| Q19 | 2370 | 3240 |
+| Q20 | 560 | 830 |
+| Q21 | 9150 | 10150 |
+| Q22 | 1130 | 1390 |
+| **Total** | **101460** | **122690** |
## 6. Environmental Preparation
diff --git a/common_docs_zh/benchmark/ssb.md b/common_docs_zh/benchmark/ssb.md
index 10e6ef73ff6..e0cec895e32 100644
--- a/common_docs_zh/benchmark/ssb.md
+++ b/common_docs_zh/benchmark/ssb.md
@@ -30,25 +30,24 @@ under the License.
本文档主要介绍 Apache Doris 在 SSB 1000G 测试集上的性能表现。
-在 SSB 标准测试数据集上的 13 个查询上，我们基于 Apache Doris 2.0.6 版本进行了测试。
+在 SSB 标准测试数据集上的 13 个查询上，我们基于 Apache Doris 2.0.16 版本进行了测试。
## 1. 硬件环境
-| 硬件 | 配置说明 |
-|------|--------------------------------------|
-| 机器数量 | 4 台腾讯云主机（1 个 FE，3 个 BE） |
-| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48 核 |
-| 内存 | 192G |
-| 网络带宽 | 21Gbps |
-| 磁盘 | 高性能云硬盘 |
+| 硬件 | 配置说明 |
+|------|------------------------------------------|
+| 机器数量 | 4 台阿里云主机（1 个 FE，3 个 BE） |
+| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32核 |
+| 内存 | 128G |
+| 磁盘 | 阿里云 ESSD (PL0) |
## 2. 软件环境
- Doris 部署 3BE 1FE
-- 内核版本：Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051)
+- 内核版本：Linux version 5.15.0-101-generic
- 操作系统版本：Ubuntu 20.04 LTS (Focal Fossa)
-- Doris 软件版本：Apache Doris 2.0.6
-- JDK：openjdk version "1.8.0_131"
+- Doris 软件版本：Apache Doris 2.0.16-rc01
+- JDK：openjdk version "1.8.0_352-352"
## 3. 测试数据量
@@ -63,45 +62,45 @@ under the License.
## 4. SSB 宽表测试结果
-使用 Apache Doris 2.0.6 版本进行测试结果如下：
-
-| Query | Doris 2.0.6 (ms) |
-|-------|------------------|
-| q1.1 | 86 |
-| q1.2 | 31 |
-| q1.3 | 87 |
-| q2.1 | 1046 |
-| q2.2 | 569 |
-| q2.3 | 480 |
-| q3.1 | 1339 |
-| q3.2 | 957 |
-| q3.3 | 215 |
-| q3.4 | 34 |
-| q4.1 | 1569 |
-| q4.2 | 174 |
-| q4.3 | 109 |
-| Total | 6696 |
+使用 Apache Doris 2.0.16 版本进行测试结果如下：
+
+| Query | Doris 2.0.16 (ms) |
+|-----------|-------------------|
+| q1.1 | 80 |
+| q1.2 | 10 |
+| q1.3 | 110 |
+| q2.1 | 1680 |
+| q2.2 | 1210 |
+| q2.3 | 1060 |
+| q3.1 | 2010 |
+| q3.2 | 1560 |
+| q3.3 | 600 |
+| q3.4 | 10 |
+| q4.1 | 2380 |
+| q4.2 | 190 |
+| q4.3 | 120 |
+| **Total** | **11020** |
## 5. 标准 SSB 测试结果
-使用 Apache Doris 2.0.6 版本进行测试结果如下：
-
-| Query | Doris 2.0.6 (ms) |
-|-------|------------------|
-| q1.1 | 332 |
-| q1.2 | 86 |
-| q1.3 | 80 |
-| q2.1 | 985 |
-| q2.2 | 844 |
-| q2.3 | 768 |
-| q3.1 | 2924 |
-| q3.2 | 944 |
-| q3.3 | 766 |
-| q3.4 | 146 |
-| q4.1 | 3451 |
-| q4.2 | 829 |
-| q4.3 | 325 |
-| Total | 12480 |
+使用 Apache Doris 2.0.16 版本进行测试结果如下：
+
+| Query | Doris 2.0.16 (ms) |
+|-----------|-------------------|
+| q1.1 | 330 |
+| q1.2 | 80 |
+| q1.3 | 80 |
+| q2.1 | 1780 |
+| q2.2 | 1970 |
+| q2.3 | 1510 |
+| q3.1 | 4000 |
+| q3.2 | 1720 |
+| q3.3 | 1510 |
+| q3.4 | 160 |
+| q4.1 | 4010 |
+| q4.2 | 840 |
+| q4.3 | 400 |
+| **Total** | **19390** |
## 6. 环境准备
diff --git a/common_docs_zh/benchmark/tpcds.md
b/common_docs_zh/benchmark/tpcds.md
index 6073ef38e4a..e6dca8ee9e7 100644
--- a/common_docs_zh/benchmark/tpcds.md
+++ b/common_docs_zh/benchmark/tpcds.md
@@ -32,31 +32,30 @@ TPC-DS 的设计目标是模拟现实世界中的复杂决策支持工作负载
本文档主要介绍 Doris 在 TPC-DS 1000G 测试集上的性能表现。
-在 TPC-DS 标准测试数据集上的 99 个查询上，我们基于 Apache Doris 2.1.1-rc03 和 Apache Doris 2.0.6
版本进行了对比测试。
+在 TPC-DS 标准测试数据集上的 99 个查询上，我们基于 Apache Doris 2.1.7-rc03 和 Apache Doris 2.0.16
版本进行了对比测试。
## 1. 硬件环境
-| 硬件 | 配置说明 |
-|------|--------------------------------------|
-| 机器数量 | 4 台腾讯云主机（1 个 FE，3 个 BE） |
-| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48 核 |
-| 内存 | 192G |
-| 网络带宽 | 21Gbps |
-| 磁盘 | 高性能云硬盘 |
+| 硬件 | 配置说明 |
+|------|------------------------------------------|
+| 机器数量 | 4 台阿里云主机（1 个 FE，3 个 BE） |
+| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32核 |
+| 内存 | 128G |
+| 磁盘 | 阿里云 ESSD (PL0) |
## 2. 软件环境
- Doris 部署 3BE 1FE
-- 内核版本：Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051)
+- 内核版本：Linux version 5.15.0-101-generic
- 操作系统版本：Ubuntu 20.04 LTS (Focal Fossa)
-- Doris 软件版本：Apache Doris 2.1.1-rc03、Apache Doris 2.0.6
-- JDK：openjdk version "1.8.0_131"
+- Doris 软件版本：Apache Doris 2.1.7-rc03、Apache Doris 2.0.16
+- JDK：openjdk version "1.8.0_352-352"
## 3. 测试数据量
-整个测试模拟生成 TPC-DS 1000G 的数据分别导入到 Apache Doris 2.1.1-rc03 和 Apache Doris 2.0.6
版本进行测试，下面是表的相关说明及数据量。
+整个测试模拟生成 TPC-DS 1000G 的数据分别导入到 Apache Doris 2.1.7-rc03 和 Apache Doris 2.0.16
版本进行测试，下面是表的相关说明及数据量。
| TPC-DS 表名 | 行数 |
|------------------------|---------------|
@@ -92,110 +91,110 @@ TPC-DS 99 个测试查询语句：
[TPC-DS-Query-SQL](https://github.com/apache/
## 5. 测试结果
-这里我们使用 Apache Doris 2.1.1-rc03 和 Apache Doris 2.0.6 版本进行对比测试，测试结果如下：
-
-| Query | Apache Doris 2.1.1-rc03 (ms) | Apache Doris 2.0.6 (ms) |
-|-----------|-------------------------------|--------------------------|
-| query1 | 729 | 914 |
-| query2 | 5120 | 4669 |
-| query3 | 286 | 285 |
-| query4 | 11633 | 35148 |
-| query5 | 641 | 22979 |
-| query6 | 267 | 1351 |
-| query7 | 468 | 517 |
-| query8 | 263 | 591 |
-| query9 | 4444 | 5430 |
-| query10 | 418 | 3341 |
-| query11 | 7246 | 23300 |
-| query12 | 115 | 105 |
-| query13 | 661 | 1719 |
-| query14 | 13955 | 33254 |
-| query15 | 474 | 1414 |
-| query16 | 366 | 402 |
-| query17 | 1097 | 2371 |
-| query18 | 581 | 760 |
-| query19 | 283 | 308 |
-| query20 | 137 | 117 |
-| query21 | 110 | 94 |
-| query22 | 1996 | 2481 |
-| query23 | 44826 | 77381 |
-| query24 | 9873 | 23910 |
-| query25 | 666 | 1021 |
-| query26 | 221 | 213 |
-| query27 | 490 | 544 |
-| query28 | 4089 | 4593 |
-| query29 | 768 | 1024 |
-| query30 | 313 | 682 |
-| query31 | 1847 | 2252 |
-| query32 | 71 | 68 |
-| query33 | 460 | 539 |
-| query34 | 629 | 638 |
-| query35 | 1660 | 10505 |
-| query36 | 412 | 441 |
-| query37 | 94 | 86 |
-| query38 | 8804 | 8379 |
-| query39 | 606 | 898 |
-| query40 | 164 | 190 |
-| query41 | 55 | 30 |
-| query42 | 115 | 113 |
-| query43 | 804 | 1332 |
-| query44 | 1509 | 1520 |
-| query45 | 1678 | 1306 |
-| query46 | 1196 | 2167 |
-| query47 | 2812 | 3859 |
-| query48 | 559 | 1419 |
-| query49 | 646 | 725 |
-| query50 | 757 | 1299 |
-| query51 | 6380 | 4954 |
-| query52 | 128 | 123 |
-| query53 | 396 | 391 |
-| query54 | 388 | 8212 |
-| query55 | 124 | 124 |
-| query56 | 360 | 434 |
-| query57 | 1811 | 2494 |
-| query58 | 304 | 666 |
-| query59 | 5758 | 7432 |
-| query60 | 474 | 481 |
-| query61 | 486 | 536 |
-| query62 | 647 | 1082 |
-| query63 | 358 | 303 |
-| query64 | 3250 | 4968 |
-| query65 | 5410 | 5971 |
-| query66 | 484 | 603 |
-| query67 | 26347 | 34052 |
-| query68 | 1422 | 1428 |
-| query69 | 654 | 808 |
-| query70 | 2285 | 4462 |
-| query71 | 650 | 1006 |
-| query72 | 4324 | 4717 |
-| query73 | 500 | 558 |
-| query74 | 6678 | 14127 |
-| query75 | 3734 | 6312 |
-| query76 | 1835 | 1870 |
-| query77 | 382 | 496 |
-| query78 | 19923 | 23091 |
-| query79 | 3061 | 4090 |
-| query80 | 851 | 1559 |
-| query81 | 565 | 960 |
-| query82 | 242 | 221 |
-| query83 | 254 | 415 |
-| query84 | 203 | 131 |
-| query85 | 364 | 444 |
-| query86 | 651 | 931 |
-| query87 | 8972 | 8554 |
-| query88 | 4095 | 5202 |
-| query89 | 508 | 480 |
-| query90 | 233 | 322 |
-| query91 | 174 | 159 |
-| query92 | 62 | 59 |
-| query93 | 1601 | 1618 |
-| query94 | 297 | 297 |
-| query95 | 1240 | 27354 |
-| query96 | 508 | 847 |
-| query97 | 5449 | 11528 |
-| query98 | 382 | 287 |
-| query99 | 1410 | 2147 |
-| **Total** | **264028** | **487990** |
+这里我们使用 Apache Doris 2.1.7-rc03 和 Apache Doris 2.0.16
版本进行对比测试，测试结果如下：(由于缺少最新的内存优化，Apache Doris 2.0.16 q78 q79无法执行，在计算总和时被删除)
+
+| Query | Apache Doris 2.1.7-rc03 (ms) | Apache Doris 2.0.16-rc01 (ms) |
+|-----------|-------------------------------|--------------------------------|
+| query01 | 630 | 890 |
+| query02 | 4930 | 6930 |
+| query03 | 360 | 460 |
+| query04 | 11070 | 42320 |
+| query05 | 620 | 15360 |
+| query06 | 220 | 1020 |
+| query07 | 550 | 750 |
+| query08 | 330 | 670 |
+| query09 | 6830 | 7550 |
+| query10 | 370 | 2900 |
+| query11 | 6960 | 27380 |
+| query12 | 100 | 80 |
+| query13 | 790 | 2860 |
+| query14 | 13470 | 42340 |
+| query15 | 510 | 940 |
+| query16 | 520 | 550 |
+| query17 | 1310 | 2650 |
+| query18 | 560 | 820 |
+| query19 | 200 | 400 |
+| query20 | 100 | 190 |
+| query21 | 80 | 80 |
+| query22 | 2300 | 3070 |
+| query23 | 38240 | 75260 |
+| query24 | 8340 | 26580 |
+| query25 | 780 | 1190 |
+| query26 | 200 | 220 |
+| query27 | 530 | 750 |
+| query28 | 5940 | 7400 |
+| query29 | 940 | 1250 |
+| query30 | 270 | 490 |
+| query31 | 1890 | 2530 |
+| query32 | 60 | 70 |
+| query33 | 350 | 450 |
+| query34 | 750 | 1380 |
+| query35 | 1370 | 8970 |
+| query36 | 530 | 570 |
+| query37 | 60 | 60 |
+| query38 | 7520 | 8710 |
+| query39 | 560 | 1010 |
+| query40 | 150 | 180 |
+| query41 | 50 | 40 |
+| query42 | 100 | 140 |
+| query43 | 1150 | 1960 |
+| query44 | 2020 | 3220 |
+| query45 | 430 | 960 |
+| query46 | 1250 | 2760 |
+| query47 | 2660 | 5790 |
+| query48 | 630 | 2570 |
+| query49 | 730 | 800 |
+| query50 | 1640 | 2200 |
+| query51 | 6430 | 6270 |
+| query52 | 110 | 160 |
+| query53 | 250 | 490 |
+| query54 | 1280 | 7790 |
+| query55 | 110 | 160 |
+| query56 | 290 | 410 |
+| query57 | 1480 | 3510 |
+| query58 | 240 | 550 |
+| query59 | 7760 | 11870 |
+| query60 | 380 | 490 |
+| query61 | 540 | 670 |
+| query62 | 740 | 1560 |
+| query63 | 210 | 460 |
+| query64 | 5790 | 6840 |
+| query65 | 4900 | 7960 |
+| query66 | 480 | 810 |
+| query67 | 27320 | 46110 |
+| query68 | 1600 | 2380 |
+| query69 | 380 | 800 |
+| query70 | 3480 | 5330 |
+| query71 | 460 | 790 |
+| query72 | 3160 | 5390 |
+| query73 | 660 | 1250 |
+| query74 | 5990 | 16450 |
+| query75 | 4610 | 8410 |
+| query76 | 1590 | 2950 |
+| query77 | 300 | 480 |
+| query78 | 17970 | x |
+| query79 | 3040 | x |
+| query80 | 570 | 910 |
+| query81 | 460 | 760 |
+| query82 | 270 | 330 |
+| query83 | 220 | 290 |
+| query84 | 130 | 110 |
+| query85 | 520 | 470 |
+| query86 | 760 | 1220 |
+| query87 | 800 | 8760 |
+| query88 | 5560 | 9690 |
+| query89 | 430 | 750 |
+| query90 | 150 | 400 |
+| query91 | 150 | 120 |
+| query92 | 40 | 40 |
+| query93 | 2440 | 2670 |
+| query94 | 340 | 310 |
+| query95 | 350 | 1810 |
+| query96 | 660 | 1680 |
+| query97 | 5020 | 14990 |
+| query98 | 190 | 330 |
+| query99 | 1560 | 3230 |
+| **Total** | **261320** | **507380** |
## 6. 环境准备
diff --git a/common_docs_zh/benchmark/tpch.md b/common_docs_zh/benchmark/tpch.md
index 0c8b31a4eaf..ae99b085e24 100644
--- a/common_docs_zh/benchmark/tpch.md
+++ b/common_docs_zh/benchmark/tpch.md
@@ -30,36 +30,35 @@ TPC-H 是一个决策支持基准（Decision Support Benchmark），它由一套
本文档主要介绍 Doris 在 TPC-H 1000G 测试集上的性能表现。
-在 TPC-H 标准测试数据集上的 22 个查询上，我们基于 Apache Doris 2.1.1-rc03 和 Apache Doris 2.0.6
版本进行了对比测试。
+在 TPC-H 标准测试数据集上的 22 个查询上，我们基于 Apache Doris 2.1.7-rc03 和 Apache Doris 2.0.16
版本进行了对比测试。
## 1. 硬件环境
-| 硬件 | 配置说明 |
-|------|--------------------------------------|
-| 机器数量 | 4 台腾讯云主机（1 个 FE，3 个 BE） |
-| CPU | AMD EPYC™ Milan(2.55GHz/3.5GHz) 48 核 |
-| 内存 | 192G |
-| 网络带宽 | 21Gbps |
-| 磁盘 | 高性能云硬盘 |
+| 硬件 | 配置说明 |
+|------|------------------------------------------|
+| 机器数量 | 4 台阿里云主机（1 个 FE，3 个 BE） |
+| CPU | Intel Xeon (Ice Lake) Platinum 8369B 32核 |
+| 内存 | 128G |
+| 磁盘 | 阿里云 ESSD (PL0) |
## 2. 软件环境
- Doris 部署 3BE 1FE
-- 内核版本：Linux version 5.4.0-96-generic (buildd@lgw01-amd64-051)
+- 内核版本：Linux version 5.15.0-101-generic
- 操作系统版本：Ubuntu 20.04 LTS (Focal Fossa)
-- Doris 软件版本：Apache Doris 2.1.1-rc03、Apache Doris 2.0.6
-- JDK：openjdk version "1.8.0_131"
+- Doris 软件版本：Apache Doris 2.1.7-rc03、Apache Doris 2.0.16
+- JDK：openjdk version "1.8.0_352-352"
## 3. 测试数据量
-整个测试模拟生成 TPCH 1000G 的数据分别导入到 Apache Doris 2.1.1-rc03 和 Apache Doris 2.0.6
版本进行测试，下面是表的相关说明及数据量。
+整个测试模拟生成 TPC-H 1000G 的数据分别导入到 Apache Doris 2.1.7-rc03 和 Apache Doris 2.0.16
版本进行测试，下面是表的相关说明及数据量。
-| TPC-H 表名 | 行数 | 备注 |
-|:---------|:------|:-------|
-| REGION | 5 | 区域表 |
-| NATION | 25 | 国家表 |
+| TPC-H 表名 | 行数 | 备注 |
+|:---------|:-------|:-------|
+| REGION | 5 | 区域表 |
+| NATION | 25 | 国家表 |
| SUPPLIER | 1000 万 | 供应商表 |
| PART | 2 亿 | 零部件表 |
| PARTSUPP | 8 亿 | 零部件供应表 |
@@ -69,38 +68,38 @@ TPC-H 是一个决策支持基准（Decision Support Benchmark），它由一套
## 4. 测试 SQL
-TPCH 22 个测试查询语句：
[TPCH-Query-SQL](https://github.com/apache/doris/tree/master/tools/tpch-tools/queries)
+TPC-H 22 个测试查询语句：
[TPCH-Query-SQL](https://github.com/apache/doris/tree/master/tools/tpch-tools/queries/sf1000)
## 5. 测试结果
-这里我们使用 Apache Doris 2.1.1-rc03 和 Apache Doris 2.0.6 版本进行对比测试，测试结果如下：
-
-| Query | Apache Doris 2.1.1-rc03 (ms) | Apache Doris 2.0.6 (ms) |
-|--------|------------------------------|-------------------------|
-| Q1 | 7240 | 7638 |
-| Q2 | 249 | 377 |
-| Q3 | 3528 | 4389 |
-| Q4 | 1534 | 1903 |
-| Q5 | 5457 | 6425 |
-| Q6 | 159 | 150 |
-| Q7 | 1598 | 3141 |
-| Q8 | 2958 | 2792 |
-| Q9 | 14803 | 24732 |
-| Q10 | 6743 | 7315 |
-| Q11 | 414 | 395 |
-| Q12 | 371 | 417 |
-| Q13 | 6203 | 8095 |
-| Q14 | 485 | 681 |
-| Q15 | 2246 | 1459 |
-| Q16 | 1252 | 1382 |
-| Q17 | 1461 | 1204 |
-| Q18 | 10428 | 11386 |
-| Q19 | 2329 | 2172 |
-| Q20 | 569 | 1455 |
-| Q21 | 5574 | 6570 |
-| Q22 | 1042 | 1517 |
-| **合计** | **76643** | **95595** |
+这里我们使用 Apache Doris 2.1.7-rc03 和 Apache Doris 2.0.16 版本进行对比测试，测试结果如下：
+
+| Query | Apache Doris 2.1.7-rc03 (ms) | Apache Doris 2.0.16-rc01 (ms) |
+|-----------|------------------------------|-------------------------------|
+| Q1 | 11880 | 12270 |
+| Q2 | 280 | 290 |
+| Q3 | 3890 | 4610 |
+| Q4 | 2570 | 3040 |
+| Q5 | 6630 | 8450 |
+| Q6 | 170 | 180 |
+| Q7 | 2420 | 4870 |
+| Q8 | 3730 | 3850 |
+| Q9 | 15910 | 25860 |
+| Q10 | 7880 | 8650 |
+| Q11 | 560 | 490 |
+| Q12 | 500 | 660 |
+| Q13 | 9540 | 9920 |
+| Q14 | 590 | 740 |
+| Q15 | 1170 | 1150 |
+| Q16 | 910 | 1520 |
+| Q17 | 1920 | 1770 |
+| Q18 | 17700 | 18760 |
+| Q19 | 2370 | 3240 |
+| Q20 | 560 | 830 |
+| Q21 | 9150 | 10150 |
+| Q22 | 1130 | 1390 |
+| **Total** | **101460** | **122690** |
## 6. 环境准备
diff --git a/static/images/tpcds_2.1.png b/static/images/tpcds_2.1.png
index 48a7e890ed6..2bb02dbed17 100644
Binary files a/static/images/tpcds_2.1.png and b/static/images/tpcds_2.1.png
differ
diff --git a/static/images/tpch_2.1.png b/static/images/tpch_2.1.png
index 4df8d8488a3..997024309da 100644
Binary files a/static/images/tpch_2.1.png and b/static/images/tpch_2.1.png
differ
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
