You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "wangbo (via GitHub)" <gi...@apache.org> on 2024/02/08 09:12:54 UTC
[PR] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
wangbo opened a new pull request, #30996:
URL: https://github.com/apache/doris/pull/30996
cherry-pick #30907
--
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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "wangbo (via GitHub)" <gi...@apache.org>.
wangbo commented on PR #30996:
URL: https://github.com/apache/doris/pull/30996#issuecomment-1933645660
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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30996:
URL: https://github.com/apache/doris/pull/30996#issuecomment-1933645603
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)
--
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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30996:
URL: https://github.com/apache/doris/pull/30996#issuecomment-1933658334
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30996:
URL: https://github.com/apache/doris/pull/30996#issuecomment-1933702960
<details>
<summary>TPC-H: <b>Total hot run time: 50646 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 7575f1f6c5704dceb6083e42874d6e5187440407, data reload: false
------ Round 1 ----------------------------------
q1 17557 4421 4340 4340
q2 2033 153 149 149
q3 10278 1895 1924 1895
q4 10094 1281 1339 1281
q5 8981 4020 4012 4012
q6 227 120 119 119
q7 2018 1562 1605 1562
q8 9287 2736 2746 2736
q9 11160 11485 11040 11040
q10 8677 3572 3529 3529
q11 427 239 241 239
q12 458 289 294 289
q13 18360 4002 4020 4002
q14 366 327 327 327
q15 506 458 444 444
q16 692 585 585 585
q17 1137 972 977 972
q18 7223 6984 6915 6915
q19 1709 1512 1498 1498
q20 534 315 300 300
q21 4411 4028 4110 4028
q22 502 401 384 384
Total cold run time: 116637 ms
Total hot run time: 50646 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4294 4282 4278 4278
q2 323 217 218 217
q3 4188 4125 4132 4125
q4 2750 2740 2761 2740
q5 7407 7220 7249 7220
q6 236 121 113 113
q7 3219 2935 2865 2865
q8 4341 4423 4454 4423
q9 17647 17167 17462 17167
q10 4244 4267 4247 4247
q11 743 688 707 688
q12 1009 846 869 846
q13 4512 3706 3705 3705
q14 427 419 413 413
q15 497 447 464 447
q16 755 719 689 689
q17 3841 3793 3810 3793
q18 8771 8856 8720 8720
q19 1744 1714 1685 1685
q20 2367 2128 2103 2103
q21 8591 8477 8536 8477
q22 1066 934 968 934
Total cold run time: 82972 ms
Total hot run time: 79895 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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30996:
URL: https://github.com/apache/doris/pull/30996#issuecomment-1933743167
<details>
<summary>ClickBench: <b>Total hot run time: 30.82 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 7575f1f6c5704dceb6083e42874d6e5187440407, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.02
query3 0.26 0.06 0.05
query4 1.82 0.08 0.06
query5 0.54 0.53 0.52
query6 1.26 0.61 0.62
query7 0.02 0.02 0.01
query8 0.04 0.02 0.02
query9 0.52 0.48 0.49
query10 0.55 0.54 0.54
query11 0.11 0.09 0.08
query12 0.11 0.09 0.09
query13 0.62 0.62 0.61
query14 0.81 0.80 0.78
query15 0.78 0.76 0.76
query16 0.37 0.36 0.37
query17 0.99 1.01 1.01
query18 0.22 0.27 0.24
query19 1.84 1.86 1.83
query20 0.01 0.01 0.01
query21 15.46 0.55 0.55
query22 1.92 2.88 1.60
query23 17.02 1.06 0.85
query24 6.00 0.95 1.42
query25 1.58 0.12 0.10
query26 0.28 0.14 0.14
query27 0.11 0.11 0.11
query28 6.75 0.74 0.70
query29 12.71 2.33 2.28
query30 0.58 0.55 0.59
query31 2.81 0.39 0.39
query32 3.39 0.49 0.49
query33 3.10 3.11 3.12
query34 15.27 4.82 4.81
query35 4.84 4.82 4.85
query36 1.06 1.03 1.01
query37 0.06 0.05 0.04
query38 0.03 0.02 0.02
query39 0.01 0.02 0.02
query40 0.16 0.14 0.14
query41 0.07 0.01 0.01
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.2 s
Total hot run time: 30.82 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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "xiaokang (via GitHub)" <gi...@apache.org>.
xiaokang merged PR #30996:
URL: https://github.com/apache/doris/pull/30996
--
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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30996:
URL: https://github.com/apache/doris/pull/30996#issuecomment-1933731519
<details>
<summary>TPC-DS: <b>Total hot run time: 236192 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 7575f1f6c5704dceb6083e42874d6e5187440407, data reload: false
query1 912 395 381 381
query2 6516 2233 1985 1985
query3 6920 197 191 191
query4 20736 18005 17960 17960
query5 19726 6519 6520 6519
query6 286 213 229 213
query7 4150 287 293 287
query8 244 243 231 231
query9 3056 2613 2573 2573
query10 420 288 287 287
query11 11223 10769 10649 10649
query12 124 70 81 70
query13 5578 661 618 618
query14 17897 13408 13221 13221
query15 351 228 234 228
query16 6416 266 262 262
query17 1726 1456 850 850
query18 2319 399 390 390
query19 197 147 147 147
query20 76 79 79 79
query21 186 92 94 92
query22 5312 4983 4953 4953
query23 32587 31870 31877 31870
query24 7004 6565 6442 6442
query25 504 426 424 424
query26 529 157 158 157
query27 1867 289 287 287
query28 6068 2171 2186 2171
query29 2835 2760 2871 2760
query30 233 162 161 161
query31 917 731 733 731
query32 65 56 61 56
query33 384 231 239 231
query34 857 461 475 461
query35 1093 919 880 880
query36 1674 1288 1634 1288
query37 90 60 58 58
query38 3128 2958 2896 2896
query39 1365 1329 1323 1323
query40 198 94 93 93
query41 34 32 31 31
query42 83 81 83 81
query43 701 642 586 586
query44 1107 713 703 703
query45 234 223 230 223
query46 1234 950 972 950
query47 1803 1637 1852 1637
query48 976 677 673 673
query49 615 359 364 359
query50 865 619 643 619
query51 5525 5523 5422 5422
query52 91 82 74 74
query53 441 322 324 322
query54 2622 2464 2480 2464
query55 76 79 75 75
query56 212 219 189 189
query57 1229 1097 1116 1097
query58 214 210 200 200
query59 3321 3109 3218 3109
query60 203 178 183 178
query61 87 81 79 79
query62 863 454 490 454
query63 479 331 329 329
query64 2538 1533 1351 1351
query65 3584 3561 3534 3534
query66 803 370 378 370
query67 15786 15743 16081 15743
query68 9568 637 662 637
query69 563 358 340 340
query70 1744 1909 1882 1882
query71 403 307 313 307
query72 6493 3368 3396 3368
query73 727 341 318 318
query74 6352 5904 5831 5831
query75 5332 3698 3646 3646
query76 6074 1158 1217 1158
query77 991 249 240 240
query78 33506 49428 45464 45464
query79 16099 650 654 650
query80 5310 373 373 373
query81 558 228 232 228
query82 848 99 90 90
query83 415 134 130 130
query84 260 67 67 67
query85 2679 284 272 272
query86 484 382 393 382
query87 3288 3007 3022 3007
query88 6782 2286 2322 2286
query89 443 294 277 277
query90 2499 206 207 206
query91 156 137 115 115
query92 66 50 49 49
query93 6134 605 564 564
query94 1861 197 213 197
query95 1106 1053 1058 1053
query96 632 339 319 319
query97 6443 6423 6350 6350
query98 190 178 171 171
query99 3944 989 888 888
Total cold run time: 353445 ms
Total hot run time: 236192 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] [Feature](executor)Support ShowProcessStmt Show all Fe connection (#3… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30996:
URL: https://github.com/apache/doris/pull/30996#issuecomment-1933748272
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 7575f1f6c5704dceb6083e42874d6e5187440407 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 21.8 seconds inserted 10000000 Rows, about 458K ops/s
```
--
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