You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "gavinchou (via GitHub)" <gi...@apache.org> on 2025/12/04 18:03:26 UTC
[PR] [chore](cloud) Enable txn lazy commit for by default [doris]
gavinchou opened a new pull request, #58732:
URL: https://github.com/apache/doris/pull/58732
(no 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #58732:
URL: https://github.com/apache/doris/pull/58732
--
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3839988966
skip 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3655207021
<details>
<summary>TPC-H: <b>Total hot run time: 34824 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 5fb59535c467cf14c4d2c013397efbed2fcd99ab, data reload: false
------ Round 1 ----------------------------------
q1 17761 4324 4115 4115
q2 2126 357 236 236
q3 11891 1355 749 749
q4 10368 825 311 311
q5 7938 2175 1890 1890
q6 190 169 136 136
q7 1012 870 725 725
q8 9361 1441 1156 1156
q9 7096 5337 5272 5272
q10 6814 2391 1980 1980
q11 520 316 300 300
q12 628 725 594 594
q13 17791 3611 3065 3065
q14 293 305 271 271
q15 594 518 513 513
q16 693 687 623 623
q17 693 839 494 494
q18 8120 7156 7056 7056
q19 1096 957 620 620
q20 406 355 243 243
q21 4156 3888 3480 3480
q22 1037 1012 995 995
Total cold run time: 110584 ms
Total hot run time: 34824 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4059 4000 4013 4000
q2 325 390 328 328
q3 2094 2641 2287 2287
q4 1289 1773 1297 1297
q5 4186 4999 4611 4611
q6 223 175 134 134
q7 2062 1895 1885 1885
q8 2722 2470 2499 2470
q9 7530 7558 7453 7453
q10 3037 3280 2820 2820
q11 600 511 472 472
q12 784 772 653 653
q13 3646 3807 3425 3425
q14 299 296 289 289
q15 548 510 522 510
q16 661 655 606 606
q17 1259 1546 1438 1438
q18 7838 7715 7731 7715
q19 863 820 845 820
q20 2001 1964 1825 1825
q21 4609 4297 4119 4119
q22 1100 1044 961 961
Total cold run time: 51735 ms
Total hot run time: 50118 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3613890460
<details>
<summary>TPC-H: <b>Total hot run time: 34176 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 cdd4d623256246f9152bc032e9d1cf47d1f2e2f8, data reload: false
------ Round 1 ----------------------------------
q1 17590 5061 4952 4952
q2 2023 312 195 195
q3 10293 1302 738 738
q4 10220 822 317 317
q5 7476 2440 2117 2117
q6 187 171 139 139
q7 961 791 630 630
q8 9356 1419 1032 1032
q9 6996 5316 5309 5309
q10 6824 2184 1802 1802
q11 536 302 295 295
q12 337 369 219 219
q13 17763 3672 3023 3023
q14 229 229 208 208
q15 591 506 512 506
q16 871 857 793 793
q17 668 870 461 461
q18 8058 7171 7134 7134
q19 1098 961 625 625
q20 375 340 219 219
q21 4014 3203 2529 2529
q22 1054 976 933 933
Total cold run time: 107520 ms
Total hot run time: 34176 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4954 4984 4873 4873
q2 325 374 305 305
q3 2132 2669 2278 2278
q4 1329 1749 1306 1306
q5 4252 4408 4504 4408
q6 224 181 131 131
q7 2155 1907 1797 1797
q8 2680 2595 2547 2547
q9 7543 7575 7463 7463
q10 3133 3250 2856 2856
q11 582 521 493 493
q12 890 706 588 588
q13 3482 3927 3283 3283
q14 283 304 284 284
q15 550 524 513 513
q16 904 933 889 889
q17 1182 1513 1428 1428
q18 7804 7777 7612 7612
q19 873 902 845 845
q20 2078 2050 1893 1893
q21 4641 4517 4165 4165
q22 1062 1026 975 975
Total cold run time: 53058 ms
Total hot run time: 50932 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3655244264
<details>
<summary>TPC-DS: <b>Total hot run time: 177745 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 5fb59535c467cf14c4d2c013397efbed2fcd99ab, data reload: false
query5 4424 604 462 462
query6 323 228 224 224
query7 4216 458 280 280
query8 304 249 239 239
query9 8755 2571 2564 2564
query10 504 390 320 320
query11 15292 14804 14520 14520
query12 180 119 114 114
query13 1259 496 403 403
query14 6186 3199 2937 2937
query14_1 2836 2826 2858 2826
query15 218 203 180 180
query16 885 512 430 430
query17 1134 708 605 605
query18 2692 449 349 349
query19 235 225 208 208
query20 125 111 114 111
query21 228 147 117 117
query22 4123 4269 4116 4116
query23 16453 16194 15989 15989
query23_1 16069 16009 16103 16009
query24 7404 1655 1219 1219
query24_1 1258 1232 1216 1216
query25 580 499 433 433
query26 1248 280 168 168
query27 2743 476 312 312
query28 4426 2140 2133 2133
query29 827 591 457 457
query30 320 247 217 217
query31 816 691 614 614
query32 78 72 80 72
query33 560 333 301 301
query34 895 922 538 538
query35 768 827 725 725
query36 874 923 858 858
query37 131 93 75 75
query38 2804 2889 2798 2798
query39 805 746 703 703
query39_1 692 729 705 705
query40 222 134 120 120
query41 65 62 59 59
query42 105 99 101 99
query43 424 438 397 397
query44 1315 742 737 737
query45 191 193 181 181
query46 872 993 602 602
query47 1699 1727 1663 1663
query48 316 321 241 241
query49 620 438 352 352
query50 650 287 224 224
query51 3850 3776 3794 3776
query52 103 113 96 96
query53 315 345 293 293
query54 281 268 251 251
query55 80 74 71 71
query56 290 294 320 294
query57 1158 1145 1089 1089
query58 268 259 250 250
query59 2330 2466 2344 2344
query60 311 316 288 288
query61 199 158 155 155
query62 720 680 624 624
query63 324 288 308 288
query64 4994 1307 992 992
query65 3976 3923 3922 3922
query66 1422 451 330 330
query67 15205 14940 14759 14759
query68 8419 1014 731 731
query69 491 343 325 325
query70 1056 977 961 961
query71 361 321 278 278
query72 6061 4959 5061 4959
query73 696 617 311 311
query74 8708 8917 8562 8562
query75 3162 3113 2751 2751
query76 4021 1135 730 730
query77 568 393 293 293
query78 9491 9535 9022 9022
query79 1609 869 613 613
query80 694 668 549 549
query81 505 265 232 232
query82 234 132 109 109
query83 255 262 240 240
query84 253 114 104 104
query85 926 492 451 451
query86 358 300 285 285
query87 2968 2994 2954 2954
query88 4245 2303 2280 2280
query89 469 423 392 392
query90 2209 155 151 151
query91 174 165 142 142
query92 82 75 63 63
query93 1487 925 555 555
query94 472 307 279 279
query95 586 375 303 303
query96 618 479 212 212
query97 2255 2270 2230 2230
query98 219 194 189 189
query99 1275 1290 1212 1212
Total cold run time: 260717 ms
Total hot run time: 177745 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3614500334
# BE Regression && UT Coverage Report
Increment line coverage `100% (0/0)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58732_cdd4d623256246f9152bc032e9d1cf47d1f2e2f8_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58732_cdd4d623256246f9152bc032e9d1cf47d1f2e2f8_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 72.16% (24719/34254) |
| Line Coverage | 58.88% (259567/440819) |
| Region Coverage | 53.89% (216215/401241) |
| Branch Coverage | 55.34% (92296/166782) |
--
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3613618907
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).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3613620704
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3613935296
<details>
<summary>TPC-DS: <b>Total hot run time: 179600 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 cdd4d623256246f9152bc032e9d1cf47d1f2e2f8, data reload: false
query5 4873 634 492 492
query6 336 233 222 222
query7 4659 467 267 267
query8 297 243 227 227
query9 8721 2658 2650 2650
query10 537 313 275 275
query11 15335 14752 14568 14568
query12 170 118 115 115
query13 1691 485 369 369
query14 6028 3274 3006 3006
query14_1 2912 2856 2905 2856
query15 209 200 189 189
query16 7465 474 459 459
query17 1215 704 603 603
query18 2014 442 341 341
query19 217 198 166 166
query20 141 124 117 117
query21 227 134 110 110
query22 3934 4026 3965 3965
query23 16683 16155 15969 15969
query23_1 16115 15955 16146 15955
query24 7241 1641 1212 1212
query24_1 1196 1208 1227 1208
query25 654 510 454 454
query26 1262 279 178 178
query27 2912 476 306 306
query28 4352 2216 2185 2185
query29 875 592 474 474
query30 310 242 222 222
query31 816 714 622 622
query32 86 75 71 71
query33 666 357 306 306
query34 866 913 541 541
query35 798 837 730 730
query36 895 906 832 832
query37 119 91 77 77
query38 3845 3846 3775 3775
query39 775 745 714 714
query39_1 881 711 702 702
query40 220 124 113 113
query41 66 62 60 60
query42 126 98 97 97
query43 427 415 396 396
query44 1311 769 755 755
query45 194 191 186 186
query46 899 956 587 587
query47 1677 1745 1651 1651
query48 397 313 229 229
query49 759 436 352 352
query50 675 299 251 251
query51 3862 3879 3843 3843
query52 124 95 90 90
query53 231 227 174 174
query54 319 247 247 247
query55 97 76 72 72
query56 332 294 298 294
query57 1154 1148 1087 1087
query58 291 255 241 241
query59 2329 2408 2295 2295
query60 351 318 297 297
query61 160 152 160 152
query62 811 668 600 600
query63 224 177 175 175
query64 4614 1181 881 881
query65 4038 3929 3965 3929
query66 1240 445 326 326
query67 15429 14945 14768 14768
query68 8375 939 657 657
query69 513 303 266 266
query70 1080 1006 978 978
query71 483 294 272 272
query72 6219 4936 4939 4936
query73 756 580 295 295
query74 8775 8875 8591 8591
query75 3582 3001 2517 2517
query76 3591 1151 738 738
query77 827 395 301 301
query78 9356 9547 8849 8849
query79 1636 881 578 578
query80 657 549 450 450
query81 500 280 246 246
query82 246 129 100 100
query83 278 275 254 254
query84 260 121 97 97
query85 916 478 449 449
query86 333 298 266 266
query87 4038 4061 3985 3985
query88 3900 2162 2142 2142
query89 406 320 288 288
query90 2152 159 154 154
query91 173 166 141 141
query92 80 71 66 66
query93 1260 1028 682 682
query94 729 323 277 277
query95 556 326 321 321
query96 534 503 221 221
query97 2578 2651 2602 2602
query98 245 203 202 202
query99 1373 1321 1241 1241
Total cold run time: 270997 ms
Total hot run time: 179600 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3654763991
# BE UT Coverage Report
Increment line coverage ` ` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/cdd4d623256246f9152bc032e9d1cf47d1f2e2f8_cdd4d623256246f9152bc032e9d1cf47d1f2e2f8/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/cdd4d623256246f9152bc032e9d1cf47d1f2e2f8_cdd4d623256246f9152bc032e9d1cf47d1f2e2f8/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 53.48% (18849/35245) |
| Line Coverage | 39.23% (174404/444602) |
| Region Coverage | 33.84% (134982/398870) |
| Branch Coverage | 34.81% (58128/166982) |
--
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3655542976
# BE UT Coverage Report
Increment line coverage ` ` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/5fb59535c467cf14c4d2c013397efbed2fcd99ab_5fb59535c467cf14c4d2c013397efbed2fcd99ab/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/5fb59535c467cf14c4d2c013397efbed2fcd99ab_5fb59535c467cf14c4d2c013397efbed2fcd99ab/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 53.43% (18845/35271) |
| Line Coverage | 39.21% (174410/444800) |
| Region Coverage | 33.82% (134901/398932) |
| Branch Coverage | 34.78% (58089/167011) |
--
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3653994755
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3656216722
# BE Regression && UT Coverage Report
Increment line coverage `100% (0/0)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58732_5fb59535c467cf14c4d2c013397efbed2fcd99ab_merge/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58732_5fb59535c467cf14c4d2c013397efbed2fcd99ab_merge/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 72.25% (24972/34564) |
| Line Coverage | 59.04% (262235/444186) |
| Region Coverage | 53.89% (217483/403561) |
| Branch Coverage | 55.47% (93092/167824) |
--
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3654494616
<details>
<summary>TPC-DS: <b>Total hot run time: 178581 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 cdd4d623256246f9152bc032e9d1cf47d1f2e2f8, data reload: false
query5 4465 652 504 504
query6 341 254 225 225
query7 4216 478 274 274
query8 310 257 236 236
query9 8767 2596 2599 2596
query10 519 421 345 345
query11 15343 14823 14579 14579
query12 203 115 114 114
query13 1264 511 406 406
query14 6129 3281 3070 3070
query14_1 2886 2864 2920 2864
query15 213 200 179 179
query16 810 470 443 443
query17 1122 688 566 566
query18 2612 435 335 335
query19 231 223 208 208
query20 120 118 108 108
query21 212 135 114 114
query22 3975 3989 4061 3989
query23 16715 16040 15942 15942
query23_1 16074 15929 16047 15929
query24 7311 1644 1253 1253
query24_1 1237 1221 1209 1209
query25 526 474 414 414
query26 1258 270 164 164
query27 2758 486 310 310
query28 4476 2166 2147 2147
query29 843 541 441 441
query30 316 247 220 220
query31 855 693 638 638
query32 81 67 66 66
query33 543 341 293 293
query34 904 902 530 530
query35 771 815 725 725
query36 893 922 833 833
query37 128 94 81 81
query38 2914 2930 2843 2843
query39 768 747 689 689
query39_1 688 700 737 700
query40 221 136 123 123
query41 69 61 62 61
query42 107 107 106 106
query43 436 435 410 410
query44 1345 765 758 758
query45 196 195 182 182
query46 866 998 611 611
query47 1655 1696 1595 1595
query48 317 329 238 238
query49 645 432 351 351
query50 663 289 217 217
query51 3836 3899 3778 3778
query52 105 112 98 98
query53 319 353 307 307
query54 291 267 260 260
query55 75 75 75 75
query56 290 299 303 299
query57 1152 1124 1067 1067
query58 263 253 253 253
query59 2295 2486 2339 2339
query60 325 335 293 293
query61 159 156 176 156
query62 690 643 636 636
query63 332 301 312 301
query64 4928 1312 1042 1042
query65 4028 3944 3989 3944
query66 1418 445 335 335
query67 15075 15190 15208 15190
query68 2733 1053 774 774
query69 462 362 332 332
query70 1085 988 979 979
query71 330 312 289 289
query72 6476 5113 5034 5034
query73 496 578 305 305
query74 8655 8848 8537 8537
query75 3139 3126 2756 2756
query76 2911 1152 754 754
query77 360 402 296 296
query78 9514 9813 8789 8789
query79 1007 936 630 630
query80 1165 657 549 549
query81 549 272 230 230
query82 460 135 101 101
query83 400 254 233 233
query84 251 124 99 99
query85 995 508 460 460
query86 387 296 289 289
query87 3007 3117 2925 2925
query88 3258 2283 2300 2283
query89 465 422 391 391
query90 1978 160 161 160
query91 185 161 145 145
query92 72 68 66 66
query93 1013 912 560 560
query94 528 312 265 265
query95 581 325 300 300
query96 590 457 208 208
query97 2281 2312 2256 2256
query98 203 191 193 191
query99 1301 1295 1188 1188
Total cold run time: 252602 ms
Total hot run time: 178581 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3839974495
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3654456858
<details>
<summary>TPC-H: <b>Total hot run time: 35170 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 cdd4d623256246f9152bc032e9d1cf47d1f2e2f8, data reload: false
------ Round 1 ----------------------------------
q1 17702 4196 4045 4045
q2 2059 346 229 229
q3 10162 1318 737 737
q4 10209 847 309 309
q5 7468 2085 2026 2026
q6 182 174 137 137
q7 993 846 706 706
q8 9355 1449 1174 1174
q9 7105 5320 5347 5320
q10 6879 2418 1977 1977
q11 546 321 300 300
q12 685 750 562 562
q13 17771 3705 3056 3056
q14 303 305 278 278
q15 606 517 515 515
q16 678 667 642 642
q17 705 839 526 526
q18 8078 7200 7111 7111
q19 1090 965 618 618
q20 414 361 247 247
q21 4288 3902 3707 3707
q22 1044 1003 948 948
Total cold run time: 108322 ms
Total hot run time: 35170 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4124 4319 4076 4076
q2 329 410 319 319
q3 2130 2693 2338 2338
q4 1324 1766 1306 1306
q5 4279 4733 4680 4680
q6 238 182 133 133
q7 2047 1954 1819 1819
q8 2716 2549 2532 2532
q9 7623 7603 7542 7542
q10 3127 3210 2867 2867
q11 585 507 503 503
q12 703 889 642 642
q13 3721 3950 3320 3320
q14 290 305 274 274
q15 553 534 511 511
q16 654 684 630 630
q17 1203 1376 1374 1374
q18 7908 7925 7616 7616
q19 876 903 929 903
q20 1959 1956 1818 1818
q21 4663 4384 4154 4154
q22 1119 1003 994 994
Total cold run time: 52171 ms
Total hot run time: 50351 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3654510683
<details>
<summary>ClickBench: <b>Total hot run time: 27.5 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 cdd4d623256246f9152bc032e9d1cf47d1f2e2f8, data reload: false
query1 0.05 0.05 0.04
query2 0.11 0.06 0.05
query3 0.26 0.09 0.09
query4 1.62 0.12 0.11
query5 0.28 0.25 0.23
query6 1.17 0.64 0.64
query7 0.03 0.03 0.03
query8 0.06 0.04 0.04
query9 0.58 0.51 0.51
query10 0.55 0.55 0.55
query11 0.15 0.11 0.11
query12 0.15 0.12 0.11
query13 0.62 0.59 0.59
query14 0.99 0.99 0.98
query15 0.82 0.79 0.81
query16 0.42 0.42 0.39
query17 1.05 1.07 1.03
query18 0.23 0.21 0.22
query19 1.81 1.78 1.75
query20 0.02 0.02 0.02
query21 15.49 0.29 0.14
query22 5.08 0.06 0.05
query23 15.93 0.28 0.10
query24 1.17 1.10 0.51
query25 0.08 0.11 0.04
query26 0.14 0.14 0.13
query27 0.09 0.06 0.05
query28 4.55 1.22 1.02
query29 12.61 4.06 3.25
query30 0.28 0.14 0.13
query31 2.85 0.64 0.40
query32 3.23 0.54 0.46
query33 3.02 3.03 3.09
query34 16.95 5.18 4.52
query35 4.53 4.55 4.58
query36 0.67 0.49 0.49
query37 0.10 0.06 0.06
query38 0.07 0.05 0.04
query39 0.04 0.03 0.03
query40 0.17 0.14 0.14
query41 0.09 0.03 0.03
query42 0.05 0.03 0.03
query43 0.05 0.03 0.04
Total cold run time: 98.21 s
Total hot run time: 27.5 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3613931226
# BE UT Coverage Report
Increment line coverage ` ` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/cdd4d623256246f9152bc032e9d1cf47d1f2e2f8_cdd4d623256246f9152bc032e9d1cf47d1f2e2f8/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/cdd4d623256246f9152bc032e9d1cf47d1f2e2f8_cdd4d623256246f9152bc032e9d1cf47d1f2e2f8/report/index.html)
| Category | Coverage |
|-------------------|--------------------|
| Function Coverage | 53.34% (18634/34932) |
| Line Coverage | 39.01% (172132/441198) |
| Region Coverage | 33.64% (133348/396421) |
| Branch Coverage | 34.58% (57367/165883) |
--
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3613953138
<details>
<summary>ClickBench: <b>Total hot run time: 27.15 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 cdd4d623256246f9152bc032e9d1cf47d1f2e2f8, data reload: false
query1 0.05 0.05 0.04
query2 0.10 0.05 0.05
query3 0.25 0.08 0.08
query4 1.61 0.11 0.11
query5 0.29 0.27 0.27
query6 1.16 0.65 0.63
query7 0.04 0.03 0.03
query8 0.05 0.04 0.04
query9 0.58 0.51 0.50
query10 0.56 0.56 0.55
query11 0.16 0.11 0.11
query12 0.14 0.11 0.12
query13 0.62 0.59 0.59
query14 0.99 0.98 1.01
query15 0.80 0.79 0.81
query16 0.41 0.39 0.42
query17 0.98 1.06 1.09
query18 0.23 0.22 0.21
query19 1.89 1.76 1.86
query20 0.02 0.01 0.01
query21 15.46 0.29 0.14
query22 4.75 0.06 0.05
query23 16.01 0.29 0.10
query24 0.96 0.24 0.45
query25 0.11 0.08 0.05
query26 0.13 0.12 0.14
query27 0.10 0.05 0.05
query28 3.52 1.22 1.01
query29 12.59 3.95 3.18
query30 0.28 0.14 0.12
query31 2.83 0.61 0.41
query32 3.23 0.55 0.46
query33 3.08 3.02 3.02
query34 16.98 5.14 4.54
query35 4.52 4.61 4.51
query36 0.68 0.50 0.50
query37 0.11 0.06 0.07
query38 0.07 0.05 0.03
query39 0.05 0.03 0.03
query40 0.18 0.13 0.14
query41 0.09 0.04 0.03
query42 0.05 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.75 s
Total hot run time: 27.15 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "gavinchou (via GitHub)" <gi...@apache.org>.
gavinchou commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3655056925
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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3655262740
<details>
<summary>ClickBench: <b>Total hot run time: 27.38 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 5fb59535c467cf14c4d2c013397efbed2fcd99ab, data reload: false
query1 0.05 0.05 0.04
query2 0.10 0.05 0.05
query3 0.25 0.09 0.08
query4 1.61 0.11 0.11
query5 0.27 0.25 0.24
query6 1.15 0.64 0.63
query7 0.04 0.03 0.03
query8 0.05 0.04 0.05
query9 0.57 0.50 0.50
query10 0.56 0.55 0.56
query11 0.16 0.11 0.11
query12 0.15 0.12 0.12
query13 0.62 0.60 0.59
query14 0.98 0.99 0.99
query15 0.82 0.80 0.79
query16 0.42 0.42 0.42
query17 1.00 0.98 0.96
query18 0.24 0.21 0.20
query19 1.91 1.82 1.85
query20 0.02 0.01 0.01
query21 15.46 0.28 0.14
query22 4.76 0.06 0.04
query23 15.94 0.29 0.10
query24 1.75 0.57 0.47
query25 0.07 0.06 0.08
query26 0.14 0.13 0.13
query27 0.08 0.06 0.06
query28 4.91 1.23 1.03
query29 12.60 3.93 3.21
query30 0.28 0.14 0.11
query31 2.82 0.65 0.40
query32 3.24 0.55 0.46
query33 2.97 3.02 3.02
query34 16.90 5.18 4.51
query35 4.59 4.54 4.54
query36 0.64 0.49 0.49
query37 0.11 0.06 0.07
query38 0.07 0.05 0.03
query39 0.04 0.03 0.03
query40 0.18 0.14 0.13
query41 0.09 0.03 0.03
query42 0.04 0.02 0.02
query43 0.04 0.03 0.04
Total cold run time: 98.69 s
Total hot run time: 27.38 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] [chore](cloud) Enable txn lazy commit for by default [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58732:
URL: https://github.com/apache/doris/pull/58732#issuecomment-3839974667
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