You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "deardeng (via GitHub)" <gi...@apache.org> on 2024/06/17 07:17:14 UTC
[PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
deardeng opened a new pull request, #36382:
URL: https://github.com/apache/doris/pull/36382
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172688605
<details>
<summary>TPC-H: <b>Total hot run time: 40689 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit c82bf03a5d9920ebc3311dcccda3958598a58adb, data reload: false
------ Round 1 ----------------------------------
q1 17615 4416 4306 4306
q2 2032 190 194 190
q3 10443 1234 1145 1145
q4 10212 887 837 837
q5 7548 2720 2684 2684
q6 218 134 134 134
q7 982 620 629 620
q8 9236 2088 2078 2078
q9 8810 6536 6488 6488
q10 8950 3747 3735 3735
q11 471 240 242 240
q12 459 232 233 232
q13 17938 2983 3010 2983
q14 261 226 223 223
q15 514 496 463 463
q16 520 379 377 377
q17 995 640 639 639
q18 8122 7558 7352 7352
q19 7460 1571 1382 1382
q20 669 317 331 317
q21 4854 3910 4150 3910
q22 412 355 354 354
Total cold run time: 118721 ms
Total hot run time: 40689 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4423 4304 4229 4229
q2 375 265 261 261
q3 3204 2950 2907 2907
q4 1982 1708 1751 1708
q5 5536 5517 5449 5449
q6 226 131 127 127
q7 2261 1845 1834 1834
q8 3308 3456 3409 3409
q9 8740 8835 8730 8730
q10 4137 3704 3805 3704
q11 595 503 493 493
q12 856 630 634 630
q13 16104 3128 3184 3128
q14 323 283 287 283
q15 524 475 487 475
q16 505 446 458 446
q17 1823 1520 1479 1479
q18 8023 8044 8058 8044
q19 1808 1561 1528 1528
q20 2132 1884 1859 1859
q21 5198 4883 4715 4715
q22 669 563 566 563
Total cold run time: 72752 ms
Total hot run time: 56001 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on code in PR #36382:
URL: https://github.com/apache/doris/pull/36382#discussion_r1642764754
##########
fe/fe-core/src/main/java/org/apache/doris/analysis/ShowReplicaDistributionStmt.java:
##########
@@ -37,6 +37,7 @@ public class ShowReplicaDistributionStmt extends ShowStmt {
.add("BackendId").add("ReplicaNum").add("ReplicaSize")
.add("NumGraph").add("NumPercent")
.add("SizeGraph").add("SizePercent")
+ .add("Cloud").add("CloudClusterName").add("CloudClusterId")
Review Comment:
cloud column seems redundant
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172475568
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172580382
<details>
<summary>ClickBench: <b>Total hot run time: 30.88 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit a42835c73b2f2940994037c456b27bc08491c6f2, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.06 0.07
query5 0.50 0.48 0.49
query6 1.16 0.73 0.73
query7 0.02 0.01 0.02
query8 0.05 0.05 0.04
query9 0.55 0.49 0.50
query10 0.54 0.55 0.54
query11 0.15 0.11 0.10
query12 0.15 0.12 0.12
query13 0.59 0.59 0.60
query14 0.77 0.78 0.79
query15 0.84 0.81 0.82
query16 0.37 0.37 0.38
query17 1.01 0.95 1.02
query18 0.22 0.24 0.25
query19 1.92 1.81 1.75
query20 0.01 0.01 0.01
query21 15.46 0.67 0.66
query22 4.59 6.14 2.22
query23 18.32 1.38 1.28
query24 2.19 0.22 0.21
query25 0.14 0.10 0.09
query26 0.27 0.18 0.17
query27 0.08 0.08 0.09
query28 13.19 1.02 1.00
query29 12.65 3.26 3.20
query30 0.25 0.06 0.06
query31 2.87 0.39 0.39
query32 3.29 0.48 0.47
query33 2.94 2.91 2.90
query34 17.25 4.44 4.41
query35 4.50 4.57 4.49
query36 0.65 0.48 0.46
query37 0.18 0.15 0.16
query38 0.16 0.14 0.14
query39 0.04 0.03 0.04
query40 0.17 0.16 0.15
query41 0.10 0.05 0.05
query42 0.06 0.05 0.04
query43 0.04 0.04 0.04
Total cold run time: 110.26 s
Total hot run time: 30.88 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "deardeng (via GitHub)" <gi...@apache.org>.
deardeng commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172586561
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2173742285
<details>
<summary>ClickBench: <b>Total hot run time: 30.32 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit fd62ed056b696df56f64fc537d454f971bf5a6c7, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.23 0.05 0.05
query4 1.67 0.08 0.08
query5 0.50 0.48 0.49
query6 1.11 0.73 0.72
query7 0.03 0.01 0.01
query8 0.05 0.04 0.04
query9 0.54 0.51 0.49
query10 0.54 0.54 0.55
query11 0.16 0.11 0.11
query12 0.15 0.13 0.12
query13 0.59 0.58 0.60
query14 0.78 0.76 0.77
query15 0.83 0.81 0.81
query16 0.36 0.36 0.37
query17 1.04 1.01 0.94
query18 0.21 0.25 0.22
query19 1.91 1.80 1.80
query20 0.02 0.01 0.01
query21 15.43 0.69 0.66
query22 3.60 7.90 1.66
query23 18.26 1.37 1.39
query24 2.18 0.23 0.22
query25 0.16 0.09 0.07
query26 0.27 0.18 0.18
query27 0.08 0.08 0.09
query28 13.20 1.02 0.98
query29 12.58 3.24 3.21
query30 0.26 0.06 0.08
query31 2.84 0.39 0.38
query32 3.28 0.48 0.46
query33 2.85 2.90 2.88
query34 17.05 4.42 4.45
query35 4.50 4.48 4.46
query36 0.65 0.46 0.47
query37 0.18 0.15 0.15
query38 0.16 0.15 0.15
query39 0.05 0.03 0.03
query40 0.18 0.15 0.14
query41 0.09 0.05 0.04
query42 0.05 0.04 0.04
query43 0.04 0.03 0.04
Total cold run time: 108.77 s
Total hot run time: 30.32 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2176368972
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "deardeng (via GitHub)" <gi...@apache.org>.
deardeng commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172476558
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2173730664
<details>
<summary>TPC-DS: <b>Total hot run time: 172666 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit fd62ed056b696df56f64fc537d454f971bf5a6c7, data reload: false
query1 931 381 382 381
query2 6470 2334 2235 2235
query3 6649 207 209 207
query4 18639 17296 17186 17186
query5 4135 478 493 478
query6 270 159 159 159
query7 4609 300 298 298
query8 295 276 272 272
query9 8625 2392 2389 2389
query10 601 306 291 291
query11 10457 10110 9967 9967
query12 140 89 92 89
query13 1624 375 360 360
query14 9524 7690 7878 7690
query15 229 182 187 182
query16 7757 275 277 275
query17 1887 533 561 533
query18 1785 273 269 269
query19 201 154 156 154
query20 93 82 82 82
query21 212 131 131 131
query22 4207 4079 3963 3963
query23 33788 32994 33048 32994
query24 11879 2926 2818 2818
query25 672 352 357 352
query26 1762 153 147 147
query27 2920 320 317 317
query28 7531 2037 2018 2018
query29 1066 621 607 607
query30 284 148 156 148
query31 965 713 749 713
query32 97 54 54 54
query33 782 299 303 299
query34 936 465 468 465
query35 741 624 630 624
query36 1055 973 946 946
query37 211 74 70 70
query38 2876 2735 2726 2726
query39 834 775 777 775
query40 287 125 126 125
query41 52 53 52 52
query42 122 96 101 96
query43 571 555 520 520
query44 1198 719 725 719
query45 198 172 174 172
query46 1083 707 712 707
query47 1867 1783 1766 1766
query48 377 298 307 298
query49 1187 429 403 403
query50 766 382 402 382
query51 6754 6667 6608 6608
query52 112 89 98 89
query53 368 289 286 286
query54 1100 437 431 431
query55 80 74 77 74
query56 305 254 249 249
query57 1161 1023 1035 1023
query58 261 249 253 249
query59 3351 3153 3067 3067
query60 292 271 263 263
query61 95 88 95 88
query62 683 434 438 434
query63 325 297 288 288
query64 9909 2287 1755 1755
query65 3147 3114 3113 3113
query66 1333 358 327 327
query67 15268 14942 14787 14787
query68 4565 542 544 542
query69 455 310 311 310
query70 1177 1086 1133 1086
query71 402 274 269 269
query72 7009 5449 5383 5383
query73 746 323 322 322
query74 5928 5511 5445 5445
query75 3454 2628 2673 2628
query76 2805 992 960 960
query77 479 309 297 297
query78 10201 9953 9824 9824
query79 2452 508 511 508
query80 2505 464 524 464
query81 580 221 214 214
query82 804 113 100 100
query83 321 196 174 174
query84 268 90 89 89
query85 2182 284 271 271
query86 501 316 319 316
query87 3218 3089 3068 3068
query88 4124 2355 2347 2347
query89 482 400 393 393
query90 1825 196 198 196
query91 133 102 98 98
query92 69 51 50 50
query93 2580 519 506 506
query94 1258 197 187 187
query95 408 315 326 315
query96 589 267 267 267
query97 3198 3089 2986 2986
query98 227 191 195 191
query99 1181 831 825 825
Total cold run time: 276117 ms
Total hot run time: 172666 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172711771
<details>
<summary>TPC-DS: <b>Total hot run time: 175642 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit c82bf03a5d9920ebc3311dcccda3958598a58adb, data reload: false
query1 940 388 380 380
query2 6480 2556 2411 2411
query3 6642 212 207 207
query4 19525 17339 17522 17339
query5 3723 502 497 497
query6 254 163 170 163
query7 4582 299 297 297
query8 362 316 315 315
query9 8674 2419 2415 2415
query10 578 341 293 293
query11 10509 10067 10096 10067
query12 122 95 87 87
query13 1642 375 365 365
query14 9921 7762 6997 6997
query15 239 193 189 189
query16 7734 280 276 276
query17 1878 570 528 528
query18 1985 285 304 285
query19 198 163 184 163
query20 92 87 85 85
query21 211 134 126 126
query22 4352 4134 3981 3981
query23 33832 33850 33721 33721
query24 11873 2849 2939 2849
query25 654 400 410 400
query26 1644 161 161 161
query27 2954 335 331 331
query28 7637 2129 2131 2129
query29 1064 683 717 683
query30 244 155 160 155
query31 960 771 751 751
query32 93 57 59 57
query33 770 313 318 313
query34 974 500 482 482
query35 781 653 677 653
query36 1126 949 1004 949
query37 164 76 78 76
query38 3055 2875 2831 2831
query39 881 815 829 815
query40 251 135 131 131
query41 63 59 58 58
query42 127 101 105 101
query43 592 535 537 535
query44 1221 736 746 736
query45 207 167 162 162
query46 1092 759 754 754
query47 1899 1809 1794 1794
query48 390 313 301 301
query49 955 450 446 446
query50 774 397 401 397
query51 6763 6689 6686 6686
query52 103 91 100 91
query53 366 291 293 291
query54 900 482 459 459
query55 76 77 77 77
query56 313 298 303 298
query57 1125 1033 1022 1022
query58 273 271 293 271
query59 3391 3234 3306 3234
query60 335 306 308 306
query61 136 134 133 133
query62 627 461 453 453
query63 325 292 304 292
query64 10009 2592 2108 2108
query65 3180 3131 3101 3101
query66 1271 357 355 355
query67 15635 14925 15026 14925
query68 7970 554 582 554
query69 717 503 397 397
query70 1162 1061 1113 1061
query71 536 295 283 283
query72 8945 5608 5994 5608
query73 816 324 328 324
query74 5991 5543 5514 5514
query75 4967 2646 2689 2646
query76 4770 929 1023 929
query77 774 306 304 304
query78 10566 9973 9801 9801
query79 1808 509 516 509
query80 2237 486 477 477
query81 558 220 224 220
query82 741 108 101 101
query83 304 175 172 172
query84 273 94 100 94
query85 1380 405 335 335
query86 405 349 340 340
query87 3282 3161 3119 3119
query88 3683 2383 2405 2383
query89 498 385 384 384
query90 1939 200 194 194
query91 141 117 110 110
query92 61 54 51 51
query93 3778 509 506 506
query94 1126 203 195 195
query95 417 334 321 321
query96 594 275 273 273
query97 3251 3123 3054 3054
query98 210 206 196 196
query99 1187 865 848 848
Total cold run time: 286835 ms
Total hot run time: 175642 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2173303211
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "deardeng (via GitHub)" <gi...@apache.org>.
deardeng commented on code in PR #36382:
URL: https://github.com/apache/doris/pull/36382#discussion_r1642765647
##########
fe/fe-core/src/main/java/org/apache/doris/analysis/ShowReplicaDistributionStmt.java:
##########
@@ -37,6 +37,7 @@ public class ShowReplicaDistributionStmt extends ShowStmt {
.add("BackendId").add("ReplicaNum").add("ReplicaSize")
.add("NumGraph").add("NumPercent")
.add("SizeGraph").add("SizePercent")
+ .add("Cloud").add("CloudClusterName").add("CloudClusterId")
Review Comment:
多一个不多
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "deardeng (via GitHub)" <gi...@apache.org>.
deardeng commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2173569395
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172484828
Add an example to show the output (before and after this change)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172722497
<details>
<summary>ClickBench: <b>Total hot run time: 31.04 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit c82bf03a5d9920ebc3311dcccda3958598a58adb, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.03 0.04
query3 0.22 0.05 0.05
query4 1.67 0.08 0.08
query5 0.50 0.48 0.48
query6 1.12 0.72 0.72
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.54 0.49 0.48
query10 0.55 0.55 0.54
query11 0.16 0.11 0.11
query12 0.15 0.13 0.12
query13 0.59 0.59 0.60
query14 0.81 0.76 0.79
query15 0.82 0.81 0.82
query16 0.37 0.36 0.37
query17 1.03 1.02 1.00
query18 0.21 0.26 0.24
query19 1.84 1.76 1.81
query20 0.01 0.01 0.02
query21 15.41 0.66 0.66
query22 3.99 6.89 2.45
query23 18.28 1.35 1.34
query24 2.17 0.22 0.22
query25 0.16 0.09 0.09
query26 0.27 0.17 0.18
query27 0.08 0.08 0.08
query28 13.15 1.02 0.99
query29 12.61 3.29 3.24
query30 0.25 0.06 0.06
query31 2.87 0.39 0.37
query32 3.28 0.48 0.47
query33 2.93 2.82 2.91
query34 17.09 4.46 4.39
query35 4.44 4.43 4.42
query36 0.65 0.47 0.46
query37 0.18 0.15 0.15
query38 0.16 0.14 0.15
query39 0.04 0.03 0.04
query40 0.17 0.14 0.14
query41 0.10 0.05 0.04
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.16 s
Total hot run time: 31.04 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2173303276
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172569553
<details>
<summary>TPC-DS: <b>Total hot run time: 173899 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit a42835c73b2f2940994037c456b27bc08491c6f2, data reload: false
query1 911 394 378 378
query2 6449 2338 2289 2289
query3 6639 207 201 201
query4 19687 17279 17402 17279
query5 3619 451 469 451
query6 239 151 158 151
query7 4576 309 290 290
query8 306 278 271 271
query9 8519 2364 2349 2349
query10 580 302 275 275
query11 10442 10021 10001 10001
query12 116 85 82 82
query13 1646 358 355 355
query14 9836 7656 7789 7656
query15 224 183 195 183
query16 7735 265 263 263
query17 1892 566 506 506
query18 1943 266 267 266
query19 189 152 149 149
query20 90 83 80 80
query21 205 137 125 125
query22 4269 4037 4131 4037
query23 33881 33521 33938 33521
query24 11757 2872 2927 2872
query25 667 375 364 364
query26 1648 162 151 151
query27 3018 327 324 324
query28 7344 2106 2103 2103
query29 1044 680 608 608
query30 245 155 162 155
query31 926 758 767 758
query32 98 51 53 51
query33 760 282 274 274
query34 1022 483 479 479
query35 752 626 650 626
query36 1081 968 991 968
query37 179 75 75 75
query38 2922 2838 2853 2838
query39 888 863 830 830
query40 265 137 133 133
query41 57 52 55 52
query42 118 104 102 102
query43 578 562 543 543
query44 1253 718 732 718
query45 198 159 165 159
query46 1077 699 705 699
query47 1873 1744 1812 1744
query48 369 288 289 288
query49 900 398 405 398
query50 763 388 391 388
query51 6727 6668 6696 6668
query52 104 89 88 88
query53 357 289 288 288
query54 877 457 447 447
query55 75 71 72 71
query56 268 250 261 250
query57 1125 1038 1032 1032
query58 253 244 258 244
query59 3553 3209 3128 3128
query60 289 268 288 268
query61 93 93 90 90
query62 591 474 433 433
query63 325 287 281 281
query64 9694 2230 1729 1729
query65 3178 3104 3071 3071
query66 1222 324 316 316
query67 15697 15048 15082 15048
query68 4583 540 532 532
query69 544 404 374 374
query70 1114 1148 1122 1122
query71 396 269 257 257
query72 7078 5514 5644 5514
query73 745 318 316 316
query74 5988 5455 5551 5455
query75 3489 2648 2666 2648
query76 2904 967 897 897
query77 616 291 291 291
query78 10315 9943 9686 9686
query79 2868 500 508 500
query80 1377 450 447 447
query81 566 221 222 221
query82 741 101 102 101
query83 193 167 161 161
query84 262 86 91 86
query85 1313 265 265 265
query86 412 331 301 301
query87 3341 3093 3081 3081
query88 3884 2357 2334 2334
query89 493 380 378 378
query90 1828 186 185 185
query91 121 101 101 101
query92 59 51 50 50
query93 4057 505 500 500
query94 1083 185 180 180
query95 400 318 310 310
query96 614 261 257 257
query97 3265 3012 3047 3012
query98 210 196 190 190
query99 1175 842 837 837
Total cold run time: 276257 ms
Total hot run time: 173899 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2173705178
<details>
<summary>TPC-H: <b>Total hot run time: 40183 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit fd62ed056b696df56f64fc537d454f971bf5a6c7, data reload: false
------ Round 1 ----------------------------------
q1 18267 4613 4404 4404
q2 2560 199 217 199
q3 12177 1157 1168 1157
q4 10575 815 790 790
q5 7857 2722 2726 2722
q6 230 143 142 142
q7 971 603 597 597
q8 9238 2090 2117 2090
q9 8813 6494 6536 6494
q10 8957 3723 3697 3697
q11 446 252 233 233
q12 444 241 230 230
q13 17781 2987 2945 2945
q14 259 222 227 222
q15 513 471 481 471
q16 517 390 370 370
q17 976 673 723 673
q18 7992 7419 7448 7419
q19 4243 1479 1523 1479
q20 672 320 330 320
q21 5029 3199 3235 3199
q22 395 330 334 330
Total cold run time: 118912 ms
Total hot run time: 40183 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4447 4240 4236 4236
q2 374 273 266 266
q3 2988 2820 2781 2781
q4 1892 1589 1673 1589
q5 5259 5331 5304 5304
q6 223 129 135 129
q7 2123 1733 1700 1700
q8 3185 3355 3336 3336
q9 8395 8387 8341 8341
q10 3921 3744 3708 3708
q11 585 483 474 474
q12 756 619 602 602
q13 16555 2944 3019 2944
q14 290 270 248 248
q15 526 473 477 473
q16 476 415 413 413
q17 1759 1452 1470 1452
q18 7784 7614 7367 7367
q19 1706 1550 1512 1512
q20 1965 1795 1766 1766
q21 4939 4765 4831 4765
q22 603 543 559 543
Total cold run time: 70751 ms
Total hot run time: 53949 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #36382:
URL: https://github.com/apache/doris/pull/36382#issuecomment-2172546779
<details>
<summary>TPC-H: <b>Total hot run time: 40002 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a42835c73b2f2940994037c456b27bc08491c6f2, data reload: false
------ Round 1 ----------------------------------
q1 17594 4515 4400 4400
q2 2025 189 199 189
q3 10442 1215 1057 1057
q4 10191 793 701 701
q5 7490 2715 2756 2715
q6 227 136 141 136
q7 970 609 589 589
q8 9227 2116 2089 2089
q9 8976 6530 6519 6519
q10 8943 3724 3767 3724
q11 460 239 244 239
q12 392 233 232 232
q13 17779 3002 3029 3002
q14 273 218 227 218
q15 509 484 482 482
q16 527 375 379 375
q17 976 594 703 594
q18 8044 7452 7392 7392
q19 9100 1566 1525 1525
q20 698 319 323 319
q21 4952 3162 3875 3162
q22 384 345 343 343
Total cold run time: 120179 ms
Total hot run time: 40002 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4354 4320 4340 4320
q2 381 280 284 280
q3 3242 2904 2938 2904
q4 1968 1713 1724 1713
q5 5541 5527 5483 5483
q6 228 138 134 134
q7 2311 1863 1867 1863
q8 3347 3460 3423 3423
q9 8682 8809 8737 8737
q10 4146 3776 3861 3776
q11 611 498 490 490
q12 830 629 632 629
q13 15903 3138 3159 3138
q14 311 269 285 269
q15 537 502 473 473
q16 507 437 451 437
q17 1832 1519 1537 1519
q18 8213 8048 7826 7826
q19 1788 1727 1667 1667
q20 2085 1899 1848 1848
q21 6149 4861 4855 4855
q22 641 536 547 536
Total cold run time: 73607 ms
Total hot run time: 56320 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](cloud) add cloud cluster info for `admin show replica distribution from` [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #36382:
URL: https://github.com/apache/doris/pull/36382
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org