Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-16 Thread via GitHub


dataroaring merged PR #50066:
URL: https://github.com/apache/doris/pull/50066


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


hello-stephen commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2808430868

   # BE UT Coverage Report
   Increment line coverage `100.00% (3/3)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/d6648d75ef7b15da8e0037f725735fed22ec1350_d6648d75ef7b15da8e0037f725735fed22ec1350/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/d6648d75ef7b15da8e0037f725735fed22ec1350_d6648d75ef7b15da8e0037f725735fed22ec1350/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 52.83% (14222/26921) |
   | Line Coverage | 41.72% (123433/295891) |
   | Region Coverage   | 40.44% (62856/155413) |
   | Branch Coverage   | 35.07% (31524/89892) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2808289833

   
   
   ClickBench: Total hot run time: 29.5 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d6648d75ef7b15da8e0037f725735fed22ec1350, 
data reload: false
   
   query1   0.030.030.03
   query2   0.120.100.10
   query3   0.240.190.19
   query4   1.590.190.19
   query5   0.590.580.58
   query6   1.160.720.71
   query7   0.020.010.01
   query8   0.040.040.03
   query9   0.580.520.51
   query10  0.550.560.58
   query11  0.160.110.11
   query12  0.140.110.12
   query13  0.620.590.60
   query14  1.141.181.18
   query15  0.860.830.85
   query16  0.360.380.38
   query17  1.011.031.03
   query18  0.210.210.20
   query19  1.861.831.77
   query20  0.010.000.01
   query21  15.42   0.910.55
   query22  0.741.090.65
   query23  15.10   1.370.63
   query24  6.921.980.81
   query25  0.450.230.15
   query26  0.620.170.13
   query27  0.060.050.05
   query28  9.310.810.42
   query29  12.54   4.043.39
   query30  0.260.100.06
   query31  2.840.580.38
   query32  3.220.540.47
   query33  3.063.023.08
   query34  15.74   5.094.42
   query35  4.524.524.47
   query36  0.660.490.48
   query37  0.090.060.06
   query38  0.040.030.03
   query39  0.030.030.02
   query40  0.170.130.13
   query41  0.070.020.02
   query42  0.030.030.02
   query43  0.040.030.03
   Total cold run time: 103.22 s
   Total hot run time: 29.5 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2808283433

   
   
   TPC-DS: Total hot run time: 192575 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit d6648d75ef7b15da8e0037f725735fed22ec1350, 
data reload: false
   
   query1   1427108010501050
   query2   6453183318111811
   query3   10982   450744054405
   query4   54905   24849   23801   23801
   query5   4986555 482 482
   query6   356 206 191 191
   query7   4935522 292 292
   query8   346 248 254 248
   query9   5373256825722568
   query10  445 305 249 249
   query11  15315   14986   14768   14768
   query12  158 112 110 110
   query13  1030550 394 394
   query14  10250   630563036303
   query15  211 191 180 180
   query16  7105664 463 463
   query17  1086701 577 577
   query18  1588430 295 295
   query19  195 186 156 156
   query20  128 130 115 115
   query21  205 127 127 127
   query22  4375447542364236
   query23  34197   33502   33325   33325
   query24  6763236923782369
   query25  449 464 405 405
   query26  679 276 161 161
   query27  2389509 334 334
   query28  3032217221672167
   query29  578 561 424 424
   query30  268 224 185 185
   query31  860 883 771 771
   query32  76  65  64  64
   query33  454 367 320 320
   query34  769 874 519 519
   query35  815 841 775 775
   query36  941 1001895 895
   query37  111 103 81  81
   query38  4192423041854185
   query39  1489142014351420
   query40  226 126 106 106
   query41  53  53  53  53
   query42  123 110 108 108
   query43  495 510 487 487
   query44  1303816 812 812
   query45  178 177 169 169
   query46  833 1031648 648
   query47  1876185717601760
   query48  386 413 318 318
   query49  690 528 425 425
   query50  658 704 417 417
   query51  4248419542774195
   query52  109 109 99  99
   query53  231 261 192 192
   query54  622 578 516 516
   query55  83  81  81  81
   query56  319 296 299 296
   query57  1151117711531153
   query58  273 292 258 258
   query59  2780281727232723
   query60  319 311 319 311
   query61  130 131 128 128
   query62  746 757 699 699
   query63  235 191 187 187
   query64  15241044730 730
   query65  4431435842194219
   query66  724 415 360 360
   query67  15954   15382   15344   15344
   query68  6893876 521 521
   query69  532 289 261 261
   query70  1197113111241124
   query71  470 318 280 280
   query72  5892481448434814
   query73  1288646 339 339
   query74  8929914187538753
   query75  3659320926932693
   query76  40721189747 747
   query77  626 368 272 272
   query78  999310039   92849284
   query79  2666801 554 554
   query80  665 503 447 447
   query81  475 256 216 216
   query82  601 125 94  94
   query83  247 244 227 227
   query84  287 102 89  89
   query85  780 358 315 315
   query86  367 316 275 275
   query87  4405447243704370
   query88  3219223321932193
   query89  387 322 276 276
   query90  1761213 215 213
   query91  146 143 114 114
   query92  78  61  55  55
   query93  2425960 592 592
   query94  689 420 313 313
   query95  366 294 283 283
   query96  484 568 266 266
   query97  3163318930983098
   query98  229 211 206 206
   query99  1440142512761276
   Total cold run time: 299047 ms
   Total hot run time: 192575 ms
   ```
   
   


-- 
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 

Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2808239253

   
   
   TPC-H: Total hot run time: 33771 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d6648d75ef7b15da8e0037f725735fed22ec1350, 
data reload: false
   
   -- Round 1 --
   q1   25847   507049904990
   q2   2065283 186 186
   q3   10379   1284719 719
   q4   10222   998 541 541
   q5   7508244322902290
   q6   185 167 132 132
   q7   943 732 623 623
   q8   9316130010711071
   q9   6795508951225089
   q10  6818229918931893
   q11  481 282 271 271
   q12  353 354 217 217
   q13  17781   364930813081
   q14  246 222 202 202
   q15  536 495 500 495
   q16  444 445 394 394
   q17  615 867 375 375
   q18  7590721770407040
   q19  1230942 559 559
   q20  345 331 223 223
   q21  4258342224242424
   q22  10171011956 956
   Total cold run time: 114974 ms
   Total hot run time: 33771 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5075508450745074
   q2   245 332 226 226
   q3   2155269123182318
   q4   1430179813971397
   q5   4441438544044385
   q6   218 172 130 130
   q7   2012190717811781
   q8   2629258524832483
   q9   7304724270577057
   q10  3025318826972697
   q11  589 529 503 503
   q12  689 783 614 614
   q13  3519393532703270
   q14  287 313 294 294
   q15  532 496 467 467
   q16  465 502 464 464
   q17  1152156213791379
   q18  7828762076167616
   q19  840 820 889 820
   q20  2022199018171817
   q21  5205489448174817
   q22  11181040996 996
   Total cold run time: 52780 ms
   Total hot run time: 50605 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


github-actions[bot] commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2808154379

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


sollhui commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2808144130

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


sollhui commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2808142210

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2806987756

   # BE UT Coverage Report
   Increment line coverage `66.67% (2/3)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/5cbeb96c2c72a3af21e380789445b82184ac231a_5cbeb96c2c72a3af21e380789445b82184ac231a/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/5cbeb96c2c72a3af21e380789445b82184ac231a_5cbeb96c2c72a3af21e380789445b82184ac231a/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 52.43% (14109/26908) |
   | Line Coverage | 41.35% (122333/295846) |
   | Region Coverage   | 40.07% (62252/155346) |
   | Branch Coverage   | 34.78% (31253/89858) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


sollhui commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805451088

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


sollhui commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805455736

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


github-actions[bot] commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805420442

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


github-actions[bot] commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805420906

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2806582083

   
   
   TPC-DS: Total hot run time: 186345 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 5cbeb96c2c72a3af21e380789445b82184ac231a, 
data reload: false
   
   query1   1016479 505 479
   query2   6547194619311931
   query3   6761220 218 218
   query4   26197   23399   23415   23399
   query5   4376628 481 481
   query6   305 193 198 193
   query7   4639488 277 277
   query8   280 232 237 232
   query9   8624256625852566
   query10  483 303 260 260
   query11  15605   15120   14813   14813
   query12  156 108 107 107
   query13  1646510 376 376
   query14  9193603959955995
   query15  205 182 182 182
   query16  7177635 487 487
   query17  1193712 573 573
   query18  1958402 313 313
   query19  191 181 157 157
   query20  120 117 156 117
   query21  211 122 102 102
   query22  3971413639733973
   query23  33924   33099   33045   33045
   query24  8461238123942381
   query25  524 444 410 410
   query26  1236267 155 155
   query27  2748513 335 335
   query28  4354244623992399
   query29  807 573 456 456
   query30  287 225 194 194
   query31  918 854 756 756
   query32  75  71  64  64
   query33  564 388 336 336
   query34  795 874 511 511
   query35  828 836 724 724
   query36  946 988 871 871
   query37  124 102 78  78
   query38  4108416541594159
   query39  1477140414191404
   query40  219 125 117 117
   query41  62  62  62  62
   query42  122 106 109 106
   query43  517 515 479 479
   query44  1313812 791 791
   query45  181 173 171 171
   query46  846 1012616 616
   query47  1745180417731773
   query48  381 409 304 304
   query49  810 553 447 447
   query50  668 687 406 406
   query51  4180416740574057
   query52  107 100 97  97
   query53  230 248 188 188
   query54  571 569 494 494
   query55  80  79  79  79
   query56  290 309 277 277
   query57  1135115610671067
   query58  264 264 243 243
   query59  2620281527992799
   query60  326 317 296 296
   query61  133 131 132 131
   query62  803 741 649 649
   query63  231 190 187 187
   query64  44691028707 707
   query65  4367429042394239
   query66  1140431 311 311
   query67  15841   15423   15199   15199
   query68  8349901 515 515
   query69  473 309 261 261
   query70  1231109011121090
   query71  444 337 290 290
   query72  5296480347264726
   query73  712 598 334 334
   query74  9224909187408740
   query75  3832320026892689
   query76  36631200769 769
   query77  786 376 289 289
   query78  10061   10128   92709270
   query79  2295807 576 576
   query80  606 497 434 434
   query81  537 252 225 225
   query82  443 123 96  96
   query83  287 265 238 238
   query84  290 98  84  84
   query85  793 354 313 313
   query86  338 294 273 273
   query87  4616448343624362
   query88  3330218722372187
   query89  389 320 285 285
   query90  1931215 208 208
   query91  146 142 110 110
   query92  77  61  63  61
   query93  1300952 595 595
   query94  677 403 293 293
   query95  411 299 287 287
   query96  489 561 279 279
   query97  3219323431663166
   query98  232 202 207 202
   query99  1499142712971297
   Total cold run time: 274657 ms
   Total hot run time: 186345 ms
   ```
   
   


-- 
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 

Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2806625935

   
   
   ClickBench: Total hot run time: 31.24 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5cbeb96c2c72a3af21e380789445b82184ac231a, 
data reload: false
   
   query1   0.040.030.03
   query2   0.120.100.11
   query3   0.240.200.19
   query4   1.600.190.19
   query5   0.580.600.58
   query6   1.200.710.71
   query7   0.030.020.01
   query8   0.050.030.03
   query9   0.580.540.52
   query10  0.580.570.56
   query11  0.150.110.11
   query12  0.150.120.11
   query13  0.620.620.59
   query14  2.682.842.80
   query15  0.950.860.86
   query16  0.380.370.38
   query17  1.041.051.02
   query18  0.210.200.20
   query19  1.861.971.86
   query20  0.010.020.01
   query21  15.91   0.870.56
   query22  0.901.140.65
   query23  15.12   1.400.60
   query24  7.041.810.83
   query25  0.560.200.19
   query26  0.630.150.13
   query27  0.050.040.05
   query28  9.380.900.41
   query29  12.56   3.983.30
   query30  0.250.090.06
   query31  2.840.590.39
   query32  3.220.580.48
   query33  3.002.993.06
   query34  15.85   5.074.46
   query35  4.474.514.52
   query36  0.650.490.49
   query37  0.090.060.06
   query38  0.050.040.03
   query39  0.040.020.03
   query40  0.150.140.12
   query41  0.080.030.02
   query42  0.040.030.02
   query43  0.030.030.03
   Total cold run time: 105.98 s
   Total hot run time: 31.24 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2806451093

   
   
   TPC-H: Total hot run time: 34447 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 5cbeb96c2c72a3af21e380789445b82184ac231a, 
data reload: false
   
   -- Round 1 --
   q1   26614   502850585028
   q2   2108291 189 189
   q3   10366   1245696 696
   q4   10217   1060541 541
   q5   7547308524162416
   q6   197 165 132 132
   q7   908 771 616 616
   q8   9316139311631163
   q9   6899509751855097
   q10  6800232118931893
   q11  485 300 275 275
   q12  351 356 219 219
   q13  17763   367931363136
   q14  226 222 213 213
   q15  523 492 479 479
   q16  631 613 576 576
   q17  619 887 406 406
   q18  7609737071007100
   q19  1229953 580 580
   q20  344 335 226 226
   q21  4398338224902490
   q22  1034976 979 976
   Total cold run time: 116184 ms
   Total hot run time: 34447 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5101508950755075
   q2   242 330 224 224
   q3   2189265623172317
   q4   1458194715081508
   q5   4555443444394434
   q6   216 165 124 124
   q7   1984191017751775
   q8   2578244725742447
   q9   7296727271847184
   q10  2968317127032703
   q11  575 510 485 485
   q12  656 766 579 579
   q13  3588390332743274
   q14  297 303 273 273
   q15  517 485 475 475
   q16  644 684 668 668
   q17  1161159813641364
   q18  7724744474997444
   q19  835 841 972 841
   q20  1988206218421842
   q21  5214463845664566
   q22  10661047982 982
   Total cold run time: 52852 ms
   Total hot run time: 50584 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


sollhui commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805563700

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


sollhui closed pull request #50066: [fix](transaction) remove visible rowset 
from memory during deletion transaction
URL: https://github.com/apache/doris/pull/50066


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


doris-robot commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805447380

   
   
   TPC-H: Total hot run time: 35119 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 8ac61e231b42553617ea09143f9c784871b368c3, 
data reload: false
   
   -- Round 1 --
   q1   26157   513250945094
   q2   2055298 179 179
   q3   10378   1225701 701
   q4   10216   1001553 553
   q5   7521241922872287
   q6   185 170 133 133
   q7   916 755 625 625
   q8   9325126311051105
   q9   6817504750575047
   q10  6863227718751875
   q11  480 296 280 280
   q12  369 362 227 227
   q13  1   369530983098
   q14  223 226 233 226
   q15  531 489 485 485
   q16  626 604 569 569
   q17  619 852 365 365
   q18  7761744572807280
   q19  1396953 563 563
   q20  337 356 228 228
   q21  4460360932073207
   q22  10621019992 992
   Total cold run time: 116074 ms
   Total hot run time: 35119 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5309510950995099
   q2   242 329 229 229
   q3   2154265122262226
   q4   1419192414661466
   q5   4458444143704370
   q6   215 171 133 133
   q7   1985189617921792
   q8   2556255025932550
   q9   7207698872306988
   q10  2976314727682768
   q11  583 516 498 498
   q12  683 803 601 601
   q13  3496385934023402
   q14  273 298 279 279
   q15  513 475 482 475
   q16  659 683 672 672
   q17  1157155713951395
   q18  7732760474137413
   q19  847 842 868 842
   q20  1935198818561856
   q21  5299487947284728
   q22  1063103910261026
   Total cold run time: 52761 ms
   Total hot run time: 50808 ms
   ```
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


sollhui commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805135023

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [fix](transaction) remove visible rowset from memory during deletion transaction [doris]

2025-04-15 Thread via GitHub


hello-stephen commented on PR #50066:
URL: https://github.com/apache/doris/pull/50066#issuecomment-2805134721

   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]