You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "w41ter (via GitHub)" <gi...@apache.org> on 2024/09/18 07:41:33 UTC
[PR] [fix](restore) Set the storage medium of the bind replicas [doris]
w41ter opened a new pull request, #40921:
URL: https://github.com/apache/doris/pull/40921
Since the replicas are bound to the same disk, the storage medium must be the same to avoid media migration.
--
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter merged PR #40921:
URL: https://github.com/apache/doris/pull/40921
--
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2358844870
<details>
<summary>TPC-DS: <b>Total hot run time: 194013 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 96f9e69ee7c185f5ab3e5fca256a67316f2ec4bc, data reload: false
query1 973 362 372 362
query2 6562 2115 2067 2067
query3 6704 217 217 217
query4 34214 23361 23323 23323
query5 4311 470 473 470
query6 274 196 164 164
query7 4611 291 301 291
query8 278 225 222 222
query9 9619 2671 2650 2650
query10 464 272 275 272
query11 18321 15281 15190 15190
query12 162 99 99 99
query13 1629 436 396 396
query14 11244 6933 6916 6916
query15 259 171 171 171
query16 7889 471 439 439
query17 1665 573 559 559
query18 2106 304 297 297
query19 368 147 146 146
query20 115 109 110 109
query21 212 106 103 103
query22 4573 4366 4212 4212
query23 34636 34313 33937 33937
query24 11234 2873 2953 2873
query25 594 392 411 392
query26 1065 160 166 160
query27 2700 281 285 281
query28 8116 2464 2448 2448
query29 679 423 430 423
query30 327 156 154 154
query31 1003 738 816 738
query32 101 56 56 56
query33 777 305 278 278
query34 973 485 485 485
query35 882 722 714 714
query36 1096 941 941 941
query37 146 84 88 84
query38 3973 3957 3925 3925
query39 1479 1410 1380 1380
query40 283 99 98 98
query41 51 49 48 48
query42 118 95 94 94
query43 521 502 488 488
query44 1247 827 794 794
query45 196 162 170 162
query46 1141 769 759 759
query47 1884 1793 1823 1793
query48 454 356 368 356
query49 1137 430 410 410
query50 822 394 401 394
query51 7104 6906 7018 6906
query52 100 85 86 85
query53 256 184 178 178
query54 1346 468 470 468
query55 83 80 77 77
query56 273 276 279 276
query57 1239 1103 1090 1090
query58 243 238 282 238
query59 3072 3040 2908 2908
query60 291 269 265 265
query61 107 105 108 105
query62 863 654 653 653
query63 222 183 180 180
query64 5244 636 630 630
query65 3253 3160 3182 3160
query66 1340 302 288 288
query67 16086 15672 15493 15493
query68 3082 872 844 844
query69 449 335 340 335
query70 1210 1156 1169 1156
query71 340 325 338 325
query72 5825 3326 3348 3326
query73 582 582 582 582
query74 9181 9000 9045 9000
query75 3005 2912 2898 2898
query76 1943 872 858 858
query77 374 368 360 360
query78 9325 9222 9234 9222
query79 931 886 868 868
query80 597 582 567 567
query81 445 251 252 251
query82 230 232 226 226
query83 162 160 154 154
query84 239 110 99 99
query85 676 365 362 362
query86 310 311 321 311
query87 4421 4300 4501 4300
query88 4827 4040 4021 4021
query89 386 354 360 354
query90 1449 307 301 301
query91 164 166 165 165
query92 77 71 72 71
query93 904 911 890 890
query94 565 338 388 338
query95 418 402 399 399
query96 488 488 485 485
query97 3115 3100 3150 3100
query98 230 220 224 220
query99 1396 1292 1285 1285
Total cold run time: 292656 ms
Total hot run time: 194013 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2357734515
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2357841624
<details>
<summary>ClickBench: <b>Total hot run time: 33.05 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 b95482414e8d983b7e59ad556ea14dc3aaa23a60, data reload: false
query1 0.05 0.05 0.04
query2 0.06 0.02 0.02
query3 0.22 0.06 0.06
query4 1.64 0.10 0.10
query5 0.51 0.51 0.48
query6 1.13 0.73 0.73
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.54 0.50 0.49
query10 0.53 0.53 0.54
query11 0.15 0.10 0.10
query12 0.14 0.10 0.10
query13 0.60 0.59 0.58
query14 3.12 3.07 2.94
query15 0.88 0.82 0.83
query16 0.38 0.39 0.38
query17 1.07 1.05 1.02
query18 0.19 0.19 0.20
query19 1.96 1.88 2.03
query20 0.02 0.01 0.01
query21 15.36 0.61 0.62
query22 3.43 3.05 2.46
query23 17.22 0.78 0.76
query24 2.59 1.13 0.67
query25 0.26 0.05 0.09
query26 0.39 0.13 0.14
query27 0.04 0.04 0.04
query28 11.07 1.09 1.07
query29 12.55 3.24 3.25
query30 0.25 0.06 0.07
query31 2.86 0.38 0.37
query32 3.27 0.46 0.45
query33 3.00 3.04 3.06
query34 16.92 4.41 4.44
query35 4.39 4.44 4.40
query36 0.67 0.48 0.49
query37 0.08 0.06 0.06
query38 0.04 0.03 0.04
query39 0.03 0.02 0.03
query40 0.15 0.13 0.13
query41 0.07 0.03 0.02
query42 0.03 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 107.95 s
Total hot run time: 33.05 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2358856235
<details>
<summary>ClickBench: <b>Total hot run time: 31.85 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 96f9e69ee7c185f5ab3e5fca256a67316f2ec4bc, data reload: false
query1 0.05 0.04 0.04
query2 0.07 0.03 0.03
query3 0.22 0.06 0.06
query4 1.64 0.10 0.10
query5 0.49 0.51 0.50
query6 1.12 0.72 0.72
query7 0.02 0.01 0.01
query8 0.04 0.03 0.02
query9 0.57 0.51 0.49
query10 0.58 0.55 0.54
query11 0.14 0.10 0.10
query12 0.13 0.11 0.11
query13 0.61 0.59 0.59
query14 2.98 2.97 2.99
query15 0.88 0.82 0.82
query16 0.40 0.37 0.38
query17 0.97 1.00 1.02
query18 0.23 0.20 0.20
query19 1.87 1.83 2.00
query20 0.01 0.01 0.01
query21 15.35 0.58 0.58
query22 3.01 1.83 1.16
query23 17.32 0.88 0.69
query24 2.90 1.60 0.99
query25 0.19 0.10 0.08
query26 0.65 0.14 0.13
query27 0.05 0.05 0.04
query28 10.55 1.09 1.06
query29 12.52 3.24 3.31
query30 0.24 0.06 0.06
query31 2.89 0.38 0.37
query32 3.26 0.46 0.45
query33 2.98 3.03 3.03
query34 17.05 4.39 4.32
query35 4.44 4.45 4.39
query36 0.70 0.48 0.48
query37 0.08 0.05 0.05
query38 0.04 0.03 0.03
query39 0.03 0.02 0.02
query40 0.15 0.13 0.12
query41 0.08 0.02 0.02
query42 0.03 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 107.56 s
Total hot run time: 31.85 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2359951863
<details>
<summary>TPC-DS: <b>Total hot run time: 194002 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 8a0f666013d2177d51f4f30932a8815a6a32a127, data reload: false
query1 987 372 368 368
query2 6522 2116 2035 2035
query3 6705 211 218 211
query4 34254 23573 23397 23397
query5 4321 467 474 467
query6 268 173 156 156
query7 4622 299 313 299
query8 274 230 228 228
query9 10001 2691 2685 2685
query10 474 283 267 267
query11 18253 15065 15111 15065
query12 156 98 94 94
query13 1634 416 412 412
query14 10269 7319 7228 7228
query15 261 174 175 174
query16 8069 488 441 441
query17 1674 582 557 557
query18 2161 305 308 305
query19 379 148 150 148
query20 122 109 105 105
query21 214 105 105 105
query22 4630 4329 4261 4261
query23 34376 34261 33675 33675
query24 11188 2950 2951 2950
query25 633 401 395 395
query26 1330 161 163 161
query27 2820 283 282 282
query28 8125 2504 2456 2456
query29 874 424 418 418
query30 321 158 158 158
query31 1016 782 804 782
query32 99 58 59 58
query33 776 310 295 295
query34 959 476 486 476
query35 908 733 731 731
query36 1091 897 931 897
query37 153 85 89 85
query38 3971 3875 3829 3829
query39 1473 1432 1408 1408
query40 279 99 102 99
query41 51 52 49 49
query42 114 96 99 96
query43 516 482 501 482
query44 1299 819 796 796
query45 197 169 163 163
query46 1136 763 748 748
query47 1919 1779 1866 1779
query48 463 364 364 364
query49 1162 438 390 390
query50 798 386 410 386
query51 7076 6791 6768 6768
query52 98 85 87 85
query53 253 178 176 176
query54 1343 451 463 451
query55 78 76 75 75
query56 261 250 248 248
query57 1243 1092 1077 1077
query58 235 237 227 227
query59 3196 3185 2963 2963
query60 297 251 257 251
query61 102 105 102 102
query62 870 661 674 661
query63 208 184 184 184
query64 5314 647 622 622
query65 3627 3200 3168 3168
query66 1446 299 312 299
query67 16083 15489 15604 15489
query68 3418 879 856 856
query69 445 347 346 346
query70 1178 1199 1165 1165
query71 348 327 333 327
query72 6077 3393 3347 3347
query73 581 579 571 571
query74 9633 8949 8998 8949
query75 3065 2897 2887 2887
query76 1927 868 859 859
query77 384 358 363 358
query78 10340 9278 9263 9263
query79 936 877 883 877
query80 601 582 570 570
query81 448 249 256 249
query82 229 226 227 226
query83 162 163 157 157
query84 236 113 99 99
query85 683 386 347 347
query86 312 317 319 317
query87 4369 4288 4280 4280
query88 4743 4092 4062 4062
query89 370 360 363 360
query90 1468 311 309 309
query91 164 162 164 162
query92 77 72 74 72
query93 912 920 901 901
query94 568 377 344 344
query95 423 404 408 404
query96 483 478 484 478
query97 3120 3074 3134 3074
query98 227 232 226 226
query99 1393 1329 1298 1298
Total cold run time: 295347 ms
Total hot run time: 194002 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2359829894
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2357735280
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2357805372
<details>
<summary>TPC-H: <b>Total hot run time: 41380 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 b95482414e8d983b7e59ad556ea14dc3aaa23a60, data reload: false
------ Round 1 ----------------------------------
q1 17580 7459 7271 7271
q2 2043 160 158 158
q3 10678 1092 1189 1092
q4 10556 716 754 716
q5 7751 3009 3078 3009
q6 235 149 154 149
q7 1001 617 611 611
q8 9429 2037 2066 2037
q9 6824 6383 6390 6383
q10 7037 2252 2274 2252
q11 453 251 259 251
q12 409 219 226 219
q13 17784 2999 2999 2999
q14 253 222 221 221
q15 585 535 509 509
q16 685 611 604 604
q17 987 795 783 783
q18 7287 6727 6684 6684
q19 1392 1020 1015 1015
q20 576 287 293 287
q21 3947 3282 3151 3151
q22 1114 1007 979 979
Total cold run time: 108606 ms
Total hot run time: 41380 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7295 7241 7236 7236
q2 324 232 235 232
q3 3049 2911 2990 2911
q4 1965 1851 1861 1851
q5 5554 5608 5581 5581
q6 230 146 148 146
q7 2246 1784 1782 1782
q8 3305 3430 3404 3404
q9 8789 8992 8774 8774
q10 3521 3463 3482 3463
q11 596 482 481 481
q12 852 610 617 610
q13 11473 3155 3167 3155
q14 299 281 284 281
q15 589 519 526 519
q16 711 684 679 679
q17 1827 1605 1592 1592
q18 8160 7883 7627 7627
q19 1709 1502 1625 1502
q20 2110 1890 1889 1889
q21 5592 5351 5474 5351
q22 1126 1042 1056 1042
Total cold run time: 71322 ms
Total hot run time: 60108 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2358719580
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2359905500
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2359941259
<details>
<summary>TPC-H: <b>Total hot run time: 41859 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 8a0f666013d2177d51f4f30932a8815a6a32a127, data reload: false
------ Round 1 ----------------------------------
q1 17577 7405 7309 7309
q2 2051 165 163 163
q3 10568 1168 1253 1168
q4 10219 814 781 781
q5 7732 3126 3074 3074
q6 240 149 150 149
q7 1012 619 602 602
q8 9427 2093 2044 2044
q9 6831 6403 6403 6403
q10 7019 2314 2308 2308
q11 432 249 251 249
q12 409 226 217 217
q13 17794 3041 2976 2976
q14 242 213 215 213
q15 578 519 515 515
q16 677 603 616 603
q17 989 841 747 747
q18 7462 6683 6838 6683
q19 1389 1040 1081 1040
q20 588 296 280 280
q21 4014 3347 3316 3316
q22 1109 1024 1019 1019
Total cold run time: 108359 ms
Total hot run time: 41859 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7311 7287 7225 7225
q2 334 228 222 222
q3 2943 2792 2758 2758
q4 1927 1685 1709 1685
q5 5385 5415 5454 5415
q6 224 143 143 143
q7 2092 1728 1705 1705
q8 3217 3356 3369 3356
q9 8466 8449 8496 8449
q10 3383 3352 3364 3352
q11 572 462 473 462
q12 764 571 609 571
q13 8260 3015 2951 2951
q14 286 256 267 256
q15 559 513 512 512
q16 697 671 660 660
q17 1780 1573 1542 1542
q18 7655 7399 7200 7200
q19 1676 1549 1521 1521
q20 2045 1815 1795 1795
q21 5272 5266 5229 5229
q22 1108 1000 1022 1000
Total cold run time: 65956 ms
Total hot run time: 58009 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2359956809
<details>
<summary>ClickBench: <b>Total hot run time: 33.11 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 8a0f666013d2177d51f4f30932a8815a6a32a127, data reload: false
query1 0.05 0.05 0.04
query2 0.07 0.03 0.03
query3 0.23 0.06 0.06
query4 1.65 0.10 0.09
query5 0.52 0.50 0.51
query6 1.13 0.71 0.73
query7 0.02 0.01 0.01
query8 0.04 0.03 0.06
query9 0.54 0.50 0.50
query10 0.56 0.55 0.55
query11 0.14 0.11 0.11
query12 0.13 0.11 0.11
query13 0.61 0.60 0.59
query14 2.96 2.94 3.10
query15 0.90 0.83 0.81
query16 0.38 0.37 0.39
query17 0.98 1.02 1.05
query18 0.23 0.21 0.21
query19 1.89 1.79 1.99
query20 0.01 0.01 0.01
query21 15.62 0.59 0.58
query22 2.69 3.10 1.87
query23 17.42 0.84 0.80
query24 2.86 1.87 1.47
query25 0.25 0.15 0.04
query26 0.50 0.14 0.13
query27 0.05 0.03 0.04
query28 9.71 1.10 1.07
query29 12.57 3.20 3.23
query30 0.24 0.06 0.06
query31 2.89 0.38 0.38
query32 3.28 0.47 0.45
query33 2.98 3.04 3.02
query34 17.12 4.37 4.43
query35 4.42 4.41 4.39
query36 0.67 0.47 0.49
query37 0.09 0.06 0.06
query38 0.04 0.03 0.03
query39 0.03 0.02 0.02
query40 0.16 0.12 0.12
query41 0.07 0.02 0.02
query42 0.02 0.02 0.02
query43 0.04 0.03 0.03
Total cold run time: 106.76 s
Total hot run time: 33.11 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2358818253
<details>
<summary>TPC-H: <b>Total hot run time: 41983 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 96f9e69ee7c185f5ab3e5fca256a67316f2ec4bc, data reload: false
------ Round 1 ----------------------------------
q1 18198 7468 7373 7373
q2 2749 161 159 159
q3 11241 1368 1199 1199
q4 10555 747 765 747
q5 8756 3158 3161 3158
q6 245 154 155 154
q7 1037 632 605 605
q8 9424 2053 2060 2053
q9 6909 6403 6423 6403
q10 7008 2276 2289 2276
q11 440 246 252 246
q12 407 225 219 219
q13 17816 3001 2998 2998
q14 244 217 218 217
q15 574 526 525 525
q16 677 622 605 605
q17 976 815 807 807
q18 7267 6714 6907 6714
q19 1408 1062 1101 1062
q20 578 297 286 286
q21 4011 3157 3306 3157
q22 1122 1020 1029 1020
Total cold run time: 111642 ms
Total hot run time: 41983 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7276 7186 7577 7186
q2 330 235 227 227
q3 2939 2758 2792 2758
q4 1951 1709 1714 1709
q5 5387 5371 5429 5371
q6 220 141 139 139
q7 2077 1703 1710 1703
q8 3188 3296 3356 3296
q9 8431 8463 8429 8429
q10 3370 3350 3325 3325
q11 578 472 467 467
q12 751 569 587 569
q13 7379 2999 2999 2999
q14 285 259 265 259
q15 559 517 520 517
q16 704 655 657 655
q17 1764 1546 1568 1546
q18 7838 7321 7404 7321
q19 1662 1536 1406 1406
q20 2046 1814 1815 1814
q21 5272 5170 5138 5138
q22 1131 1052 995 995
Total cold run time: 65138 ms
Total hot run time: 57829 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](restore) Set the storage medium of the bind replicas [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2359829918
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](restore) Set the storage medium of the bind replicas [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40921:
URL: https://github.com/apache/doris/pull/40921#issuecomment-2357830701
<details>
<summary>TPC-DS: <b>Total hot run time: 199591 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 b95482414e8d983b7e59ad556ea14dc3aaa23a60, data reload: false
query1 1284 880 885 880
query2 6378 2050 2022 2022
query3 10790 3976 3637 3637
query4 64039 28877 23682 23682
query5 4983 501 485 485
query6 415 177 171 171
query7 5483 304 324 304
query8 327 225 220 220
query9 8549 2645 2639 2639
query10 464 297 289 289
query11 17231 15115 15750 15115
query12 164 107 100 100
query13 1501 434 430 430
query14 10920 7658 7315 7315
query15 211 174 174 174
query16 6811 487 420 420
query17 1254 605 583 583
query18 1510 312 323 312
query19 211 159 157 157
query20 127 109 115 109
query21 216 104 105 104
query22 4757 4647 4753 4647
query23 34633 34052 34014 34014
query24 6036 2950 2961 2950
query25 519 411 406 406
query26 649 163 160 160
query27 1625 283 287 283
query28 4316 2460 2416 2416
query29 672 435 440 435
query30 239 159 165 159
query31 954 767 776 767
query32 76 57 54 54
query33 446 298 305 298
query34 894 502 493 493
query35 836 759 720 720
query36 1067 935 953 935
query37 160 91 89 89
query38 4054 3947 3915 3915
query39 1456 1392 1391 1391
query40 212 97 98 97
query41 50 48 53 48
query42 114 98 95 95
query43 533 493 501 493
query44 1163 814 803 803
query45 199 168 164 164
query46 1226 759 769 759
query47 1902 1794 1814 1794
query48 456 352 378 352
query49 669 396 395 395
query50 843 399 424 399
query51 7057 6967 6909 6909
query52 97 94 85 85
query53 258 184 186 184
query54 561 459 466 459
query55 78 75 77 75
query56 291 283 270 270
query57 1197 1088 1092 1088
query58 234 237 238 237
query59 3051 3137 2863 2863
query60 321 278 266 266
query61 118 103 102 102
query62 761 676 661 661
query63 218 195 186 186
query64 1342 676 620 620
query65 3273 3208 3182 3182
query66 677 299 312 299
query67 16115 15413 15591 15413
query68 1282 897 862 862
query69 451 355 365 355
query70 1192 1231 1103 1103
query71 344 332 340 332
query72 5955 3388 3435 3388
query73 590 583 585 583
query74 9265 9013 8959 8959
query75 2989 2975 2907 2907
query76 1127 881 889 881
query77 517 371 381 371
query78 9583 9355 9269 9269
query79 946 932 895 895
query80 606 594 595 594
query81 458 257 247 247
query82 245 238 238 238
query83 159 154 163 154
query84 265 107 101 101
query85 662 376 369 369
query86 316 310 310 310
query87 4383 4397 4363 4363
query88 4937 4021 4051 4021
query89 377 371 366 366
query90 1734 315 310 310
query91 163 166 165 165
query92 75 73 74 73
query93 907 900 899 899
query94 592 387 370 370
query95 507 417 414 414
query96 488 480 482 480
query97 3162 3118 3145 3118
query98 242 226 230 226
query99 1419 1290 1315 1290
Total cold run time: 305211 ms
Total hot run time: 199591 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