Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
github-actions[bot] commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2823262472 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
gavinchou merged PR #49882: URL: https://github.com/apache/doris/pull/49882 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2822973792 ClickBench: Total hot run time: 29.87 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ad89e2cb7e6106b66cdfd98d55598fd78c5cf599, data reload: false query1 0.050.040.03 query2 0.120.110.12 query3 0.250.200.19 query4 1.590.200.20 query5 0.600.590.59 query6 1.180.710.72 query7 0.030.010.02 query8 0.040.030.03 query9 0.580.520.51 query10 0.570.590.56 query11 0.150.110.11 query12 0.160.110.12 query13 0.620.590.60 query14 1.201.231.19 query15 0.890.860.85 query16 0.400.380.38 query17 1.061.041.01 query18 0.210.200.19 query19 1.961.811.80 query20 0.020.010.01 query21 15.39 0.910.55 query22 0.771.390.74 query23 14.73 1.400.64 query24 7.061.250.90 query25 0.500.170.08 query26 0.650.170.15 query27 0.060.050.04 query28 10.52 0.900.44 query29 12.58 3.993.31 query30 0.260.090.07 query31 2.820.600.38 query32 3.230.540.46 query33 3.003.073.11 query34 15.99 5.124.54 query35 4.574.604.51 query36 0.670.500.49 query37 0.080.060.06 query38 0.060.040.04 query39 0.020.020.02 query40 0.170.130.13 query41 0.080.020.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 104.97 s Total hot run time: 29.87 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2822968789 TPC-DS: Total hot run time: 192187 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 ad89e2cb7e6106b66cdfd98d55598fd78c5cf599, data reload: false query1 1408111010631063 query2 6106175917711759 query3 11160 479847904790 query4 53976 25685 23028 23028 query5 5029521 451 451 query6 358 227 200 200 query7 4894499 288 288 query8 340 256 239 239 query9 5652259226122592 query10 422 337 261 261 query11 14988 14970 14698 14698 query12 160 122 115 115 query13 1040525 403 403 query14 10092 652463476347 query15 207 196 183 183 query16 7218661 502 502 query17 749 613 613 query18 1630416 343 343 query19 208 210 199 199 query20 126 126 128 126 query21 251 120 113 113 query22 4321456542774277 query23 34094 33440 33410 33410 query24 6577241024812410 query25 474 473 414 414 query26 722 272 157 157 query27 2246508 343 343 query28 3437214021242124 query29 599 557 429 429 query30 275 221 193 193 query31 869 865 774 774 query32 77 62 69 62 query33 448 372 317 317 query34 784 881 531 531 query35 801 834 790 790 query36 966 999 924 924 query37 118 100 78 78 query38 4240416442004164 query39 1495145414541454 query40 213 124 108 108 query41 53 60 49 49 query42 127 113 114 113 query43 532 511 487 487 query44 1370821 824 821 query45 191 177 167 167 query46 865 1039665 665 query47 1866186317701770 query48 394 419 307 307 query49 692 527 445 445 query50 687 696 411 411 query51 4233425041384138 query52 121 114 106 106 query53 242 265 181 181 query54 583 586 520 520 query55 81 85 79 79 query56 377 297 313 297 query57 1187121011141114 query58 276 264 256 256 query59 2616274726672667 query60 361 321 324 321 query61 135 136 128 128 query62 732 784 657 657 query63 222 188 190 188 query64 19581079743 743 query65 4324421642324216 query66 716 402 304 304 query67 15894 15712 15370 15370 query68 7594904 516 516 query69 541 303 261 261 query70 1201107610641064 query71 512 317 325 317 query72 5880481146644664 query73 1452597 350 350 query74 9135905188378837 query75 3823319326642664 query76 43761212780 780 query77 612 376 287 287 query78 10049 10143 91999199 query79 2328814 569 569 query80 817 521 426 426 query81 485 256 228 228 query82 442 128 96 96 query83 355 244 231 231 query84 298 106 87 87 query85 779 349 313 313 query86 390 308 312 308 query87 4352439342714271 query88 3350223923152239 query89 397 318 277 277 query90 1801220 215 215 query91 143 145 110 110 query92 74 71 57 57 query93 2000943 582 582 query94 658 420 305 305 query95 367 312 280 280 query96 498 567 274 274 query97 3195323731083108 query98 237 211 205 205 query99 1438144112751275 Total cold run time: 299546 ms Total hot run time: 192187 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] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2822956735 TPC-H: Total hot run time: 34096 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ad89e2cb7e6106b66cdfd98d55598fd78c5cf599, data reload: false -- Round 1 -- q1 26130 516150745074 q2 2081279 182 182 q3 10402 1256687 687 q4 10221 1017527 527 q5 7633242723752375 q6 183 159 130 130 q7 920 758 608 608 q8 9315122410671067 q9 6812512851535128 q10 6888231318761876 q11 493 293 267 267 q12 362 355 219 219 q13 17800 371731253125 q14 229 232 207 207 q15 542 482 497 482 q16 451 448 408 408 q17 602 879 367 367 q18 7562730372667266 q19 1581947 551 551 q20 329 327 220 220 q21 4022338824092409 q22 10981023921 921 Total cold run time: 115656 ms Total hot run time: 34096 ms - Round 2, with runtime_filter_mode=off - q1 5206513251025102 q2 237 320 228 228 q3 2154267022702270 q4 1388179114751475 q5 4494440543874387 q6 214 167 129 129 q7 1963194517261726 q8 2583249624922492 q9 7299719069946994 q10 2989324527172717 q11 562 483 507 483 q12 695 766 607 607 q13 3606387733193319 q14 286 305 292 292 q15 546 482 483 482 q16 485 513 458 458 q17 1206152813971397 q18 7782765974507450 q19 834 807 901 807 q20 2039196418621862 q21 5327483148454831 q22 105710271027 Total cold run time: 53006 ms Total hot run time: 50535 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2822854707 run performance -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
hello-stephen commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2821780003 # BE Regression P0 && UT Coverage Report Increment line coverage `0.00% (0/180)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/49882_ad89e2cb7e6106b66cdfd98d55598fd78c5cf599_merge/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/49882_ad89e2cb7e6106b66cdfd98d55598fd78c5cf599_merge/report/index.html) | Category | Coverage | |---|| | Function Coverage || | Line Coverage || | Region Coverage || | Branch Coverage || -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
hello-stephen commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2821585565 # BE UT Coverage Report Increment line coverage `0.00% (0/180)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/ad89e2cb7e6106b66cdfd98d55598fd78c5cf599_ad89e2cb7e6106b66cdfd98d55598fd78c5cf599/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/ad89e2cb7e6106b66cdfd98d55598fd78c5cf599_ad89e2cb7e6106b66cdfd98d55598fd78c5cf599/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.53% (14537/27155) | | Line Coverage | 42.36% (126008/297493) | | Region Coverage | 41.18% (64402/156388) | | Branch Coverage | 35.76% (32373/90530) | -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2821311033 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2821212714 # BE UT Coverage Report Increment line coverage `0.00% (0/178)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/ab4d208fc2033ca172060bf854dba4288e6a7ee4_ab4d208fc2033ca172060bf854dba4288e6a7ee4/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/ab4d208fc2033ca172060bf854dba4288e6a7ee4_ab4d208fc2033ca172060bf854dba4288e6a7ee4/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.53% (14535/27155) | | Line Coverage | 42.35% (125979/297485) | | Region Coverage | 41.18% (64397/156390) | | Branch Coverage | 35.75% (32369/90530) | -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2821127371 ClickBench: Total hot run time: 29.48 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false query1 0.040.040.03 query2 0.140.100.12 query3 0.250.190.19 query4 1.590.200.19 query5 0.600.590.60 query6 1.180.720.72 query7 0.030.010.01 query8 0.040.040.03 query9 0.580.540.51 query10 0.570.560.57 query11 0.150.110.11 query12 0.140.120.11 query13 0.610.600.60 query14 1.211.161.16 query15 0.870.830.86 query16 0.380.370.38 query17 1.031.041.01 query18 0.210.200.19 query19 1.851.791.77 query20 0.010.010.01 query21 15.40 0.900.55 query22 0.771.270.74 query23 14.76 1.390.66 query24 7.032.190.64 query25 0.500.190.08 query26 0.580.150.13 query27 0.060.040.05 query28 9.950.890.44 query29 12.52 4.023.30 query30 0.260.100.07 query31 2.820.600.38 query32 3.220.540.47 query33 3.033.093.05 query34 15.79 5.174.49 query35 4.544.594.53 query36 0.660.490.49 query37 0.090.060.06 query38 0.050.040.04 query39 0.030.020.03 query40 0.160.140.13 query41 0.090.030.03 query42 0.030.020.02 query43 0.040.040.03 Total cold run time: 103.86 s Total hot run time: 29.48 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2821114280 TPC-DS: Total hot run time: 193289 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 ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false query1 1440107010661066 query2 6337184018681840 query3 11132 465646154615 query4 25421 24140 23538 23538 query5 5512662 457 457 query6 316 210 199 199 query7 3985484 274 274 query8 292 239 235 235 query9 8561254825552548 query10 516 310 273 273 query11 15198 15011 14761 14761 query12 166 109 108 108 query13 1550509 380 380 query14 8799601061026010 query15 198 186 165 165 query16 7208643 476 476 query17 1169772 648 648 query18 2003424 314 314 query19 194 196 164 164 query20 123 125 124 124 query21 202 135 119 119 query22 4717461044374437 query23 34524 33804 33639 33639 query24 8788246924322432 query25 525 548 395 395 query26 1187269 149 149 query27 3166509 331 331 query28 4714215921482148 query29 735 568 454 454 query30 281 226 195 195 query31 874 873 801 801 query32 76 67 64 64 query33 530 398 315 315 query34 783 863 519 519 query35 793 844 779 779 query36 981 1010920 920 query37 109 97 76 76 query38 4188422141794179 query39 1482141814501418 query40 217 128 109 109 query41 55 51 53 51 query42 127 105 112 105 query43 508 492 480 480 query44 1310818 807 807 query45 188 173 164 164 query46 831 1047655 655 query47 1878192117981798 query48 385 419 319 319 query49 755 520 405 405 query50 674 710 424 424 query51 4168423343484233 query52 108 104 101 101 query53 227 253 181 181 query54 581 600 526 526 query55 86 81 80 80 query56 319 317 297 297 query57 1214119811731173 query58 289 289 255 255 query59 2737285027852785 query60 330 329 300 300 query61 130 135 122 122 query62 777 726 666 666 query63 225 192 188 188 query64 41351128711 711 query65 4415437043904370 query66 1097401 300 300 query67 15944 15593 15418 15418 query68 9570896 504 504 query69 516 297 259 259 query70 1229114711041104 query71 481 308 279 279 query72 5587473246754675 query73 718 591 345 345 query74 9258905790279027 query75 4452319126882688 query76 38091181751 751 query77 1003370 285 285 query78 9974999693149314 query79 6786781 556 556 query80 635 505 434 434 query81 487 255 212 212 query82 722 126 104 104 query83 280 253 235 235 query84 368 111 90 90 query85 750 344 307 307 query86 341 320 306 306 query87 4379446543374337 query88 3697218921882188 query89 464 323 271 271 query90 2024209 211 209 query91 139 140 112 112 query92 75 61 58 58 query93 3969961 573 573 query94 671 410 302 302 query95 368 294 285 285 query96 486 579 270 270 query97 3181324631163116 query98 269 209 206 206 query99 1460140012991299 Total cold run time: 290633 ms Total hot run time: 193289 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] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2821084897 TPC-H: Total hot run time: 33970 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false -- Round 1 -- q1 25741 506249814981 q2 2057285 178 178 q3 10399 1246719 719 q4 10220 1008532 532 q5 7455245223552355 q6 181 164 132 132 q7 914 758 598 598 q8 9310127810921092 q9 7356520752095207 q10 6884228218861886 q11 471 282 269 269 q12 341 359 224 224 q13 18093 369230743074 q14 237 232 213 213 q15 546 492 490 490 q16 449 453 407 407 q17 584 851 351 351 q18 7587710570487048 q19 1505933 566 566 q20 340 335 222 222 q21 4003272824172417 q22 1104102810091009 Total cold run time: 115777 ms Total hot run time: 33970 ms - Round 2, with runtime_filter_mode=off - q1 5113504150675041 q2 237 324 230 230 q3 2147263822492249 q4 1461184514131413 q5 437844144378 q6 217 175 124 124 q7 2001195217811781 q8 2554257025722570 q9 7293721970037003 q10 3038318327412741 q11 581 513 482 482 q12 668 772 603 603 q13 3480393632443244 q14 294 300 261 261 q15 530 486 477 477 q16 480 520 483 483 q17 1137152613871387 q18 7699757674817481 q19 793 821 989 821 q20 1989203318881888 q21 5204488748124812 q22 1174107110501050 Total cold run time: 52534 ms Total hot run time: 50519 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820983751 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820859723 # BE UT Coverage Report Increment line coverage `0.00% (0/178)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/ab4d208fc2033ca172060bf854dba4288e6a7ee4_ab4d208fc2033ca172060bf854dba4288e6a7ee4/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/ab4d208fc2033ca172060bf854dba4288e6a7ee4_ab4d208fc2033ca172060bf854dba4288e6a7ee4/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.53% (14535/27155) | | Line Coverage | 42.35% (125983/297467) | | Region Coverage | 41.17% (64388/156378) | | Branch Coverage | 35.76% (32367/90518) | -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820620802 ClickBench: Total hot run time: 29.79 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false query1 0.040.040.03 query2 0.120.100.11 query3 0.240.180.20 query4 1.600.190.11 query5 0.580.550.55 query6 1.200.700.71 query7 0.030.020.01 query8 0.040.030.03 query9 0.580.520.51 query10 0.570.560.57 query11 0.160.110.12 query12 0.150.120.12 query13 0.620.600.60 query14 1.181.211.19 query15 0.880.860.86 query16 0.390.420.39 query17 1.051.041.06 query18 0.210.200.20 query19 1.891.861.84 query20 0.010.020.01 query21 15.38 0.900.56 query22 0.751.320.94 query23 14.77 1.350.63 query24 7.920.761.03 query25 0.500.230.08 query26 0.580.150.14 query27 0.050.050.04 query28 9.640.880.44 query29 12.59 3.963.31 query30 0.240.090.07 query31 2.810.590.38 query32 3.220.540.47 query33 3.093.113.09 query34 15.69 5.114.47 query35 4.544.534.48 query36 0.660.500.48 query37 0.080.060.06 query38 0.050.030.04 query39 0.030.020.03 query40 0.160.130.13 query41 0.080.020.02 query42 0.040.020.02 query43 0.030.030.03 Total cold run time: 104.44 s Total hot run time: 29.79 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820606453 TPC-DS: Total hot run time: 185256 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 ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false query1 1041493 505 493 query2 6566180017701770 query3 6756218 220 218 query4 26221 24012 23220 23220 query5 5156611 487 487 query6 329 205 189 189 query7 4653492 296 296 query8 287 228 230 228 query9 8673257125792571 query10 498 329 268 268 query11 15199 15113 14802 14802 query12 153 110 107 107 query13 1671520 404 404 query14 9161607362776073 query15 206 182 161 161 query16 7290603 478 478 query17 1130746 561 561 query18 1966392 296 296 query19 187 179 154 154 query20 121 124 120 120 query21 209 121 107 107 query22 4041413840844084 query23 33804 32910 32871 32871 query24 8415237124332371 query25 548 454 383 383 query26 1225264 147 147 query27 2759487 326 326 query28 4369212621112111 query29 775 532 441 441 query30 283 211 185 185 query31 912 824 720 720 query32 75 66 63 63 query33 565 359 293 293 query34 803 838 516 516 query35 783 814 763 763 query36 942 989 909 909 query37 122 105 82 82 query38 4157406140204020 query39 1510145613961396 query40 214 123 109 109 query41 56 52 51 51 query42 118 109 103 103 query43 486 513 466 466 query44 1314784 789 784 query45 179 175 171 171 query46 823 1034613 613 query47 1798178117221722 query48 381 405 299 299 query49 792 498 430 430 query50 655 674 389 389 query51 4213409540654065 query52 114 107 100 100 query53 230 256 187 187 query54 589 585 520 520 query55 87 80 82 80 query56 296 297 317 297 query57 1175113310891089 query58 259 263 264 263 query59 2472257325502550 query60 315 324 307 307 query61 132 134 134 134 query62 791 736 640 640 query63 223 192 186 186 query64 43791038684 684 query65 4348422142534221 query66 1139409 316 316 query67 15715 15600 15307 15307 query68 6602887 523 523 query69 482 297 264 264 query70 1227111010331033 query71 405 319 286 286 query72 5620476449074764 query73 660 624 343 343 query74 9254897888898889 query75 3164326026932693 query76 32431192757 757 query77 479 378 291 291 query78 9908998592379237 query79 1897826 570 570 query80 682 525 436 436 query81 490 247 212 212 query82 197 137 94 94 query83 260 243 240 240 query84 260 105 80 80 query85 758 373 308 308 query86 371 306 286 286 query87 4432450742314231 query88 2863218122042181 query89 384 303 276 276 query90 2009221 202 202 query91 136 144 112 112 query92 70 63 57 57 query93 2189928 581 581 query94 676 406 311 311 query95 374 292 281 281 query96 490 557 272 272 query97 3115322831473147 query98 233 220 203 203 query99 1356140313291329 Total cold run time: 271140 ms Total hot run time: 185256 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] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820577138 TPC-H: Total hot run time: 33939 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false -- Round 1 -- q1 26353 508950025002 q2 2081291 179 179 q3 10378 1260699 699 q4 10239 1020530 530 q5 7523237924262379 q6 187 163 131 131 q7 921 780 606 606 q8 9313130710731073 q9 6901510250505050 q10 6811230119081908 q11 479 292 270 270 q12 352 352 220 220 q13 17767 371630833083 q14 234 233 214 214 q15 537 476 510 476 q16 449 454 402 402 q17 606 881 356 356 q18 7693741870637063 q19 1568965 573 573 q20 342 353 224 224 q21 4306336125312531 q22 10451022970 970 Total cold run time: 116085 ms Total hot run time: 33939 ms - Round 2, with runtime_filter_mode=off - q1 5216509950975097 q2 242 348 228 228 q3 2176267623032303 q4 1424182515051505 q5 4566447644324432 q6 214 166 126 126 q7 1972188217221722 q8 2650263526032603 q9 7148722571307130 q10 3007318127232723 q11 599 503 504 503 q12 670 762 583 583 q13 3594400832653265 q14 295 299 279 279 q15 507 475 487 475 q16 452 511 462 462 q17 1161157113751375 q18 7677749974047404 q19 822 768 846 768 q20 1945198918741874 q21 5337476746694669 q22 10741005984 984 Total cold run time: 52748 ms Total hot run time: 50510 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820314014 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820065688 ClickBench: Total hot run time: 29.41 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false query1 0.040.040.03 query2 0.120.110.11 query3 0.270.190.20 query4 1.590.200.20 query5 0.610.580.59 query6 1.160.720.72 query7 0.020.010.02 query8 0.040.030.04 query9 0.570.520.50 query10 0.560.560.56 query11 0.160.110.11 query12 0.150.120.11 query13 0.620.600.60 query14 1.191.171.18 query15 0.870.830.85 query16 0.400.380.38 query17 1.041.031.06 query18 0.210.200.20 query19 1.861.781.80 query20 0.010.010.01 query21 15.42 0.900.55 query22 0.751.200.72 query23 14.82 1.400.68 query24 6.522.150.58 query25 0.440.160.06 query26 0.650.170.15 query27 0.060.050.05 query28 8.820.880.43 query29 12.55 3.933.27 query30 0.250.090.07 query31 2.810.590.39 query32 3.240.540.46 query33 3.053.143.02 query34 15.73 5.054.49 query35 4.544.614.55 query36 0.660.490.48 query37 0.080.060.07 query38 0.060.040.03 query39 0.030.030.02 query40 0.170.140.12 query41 0.080.030.03 query42 0.030.020.03 query43 0.030.030.03 Total cold run time: 102.28 s Total hot run time: 29.41 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820058969 TPC-DS: Total hot run time: 185961 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 ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false query1 1024480 491 480 query2 6561179018101790 query3 6763226 218 218 query4 26350 23780 22759 22759 query5 4277661 464 464 query6 308 199 200 199 query7 4619503 279 279 query8 282 256 275 256 query9 8625258425832583 query10 493 323 270 270 query11 15540 15052 14892 14892 query12 163 115 111 111 query13 1647534 399 399 query14 9731630863076307 query15 217 194 177 177 query16 7518638 487 487 query17 1199733 629 629 query18 2017415 337 337 query19 202 205 173 173 query20 126 119 120 119 query21 234 124 108 108 query22 4045409740184018 query23 34091 33067 33192 33067 query24 8486246924082408 query25 563 479 425 425 query26 1232275 158 158 query27 2747495 336 336 query28 4361212820962096 query29 761 649 428 428 query30 277 214 182 182 query31 922 840 750 750 query32 77 62 64 62 query33 561 368 315 315 query34 783 854 525 525 query35 812 806 756 756 query36 955 986 883 883 query37 114 105 79 79 query38 4180425041024102 query39 1454141813981398 query40 218 120 104 104 query41 58 57 51 51 query42 119 109 105 105 query43 496 546 473 473 query44 1266803 792 792 query45 182 178 172 172 query46 860 1033636 636 query47 1751176017111711 query48 372 411 316 316 query49 785 518 397 397 query50 692 686 403 403 query51 4064415541364136 query52 110 106 102 102 query53 233 261 190 190 query54 570 583 502 502 query55 88 87 84 84 query56 332 300 289 289 query57 1164112810741074 query58 265 270 257 257 query59 2596271525282528 query60 320 338 318 318 query61 129 127 129 127 query62 808 735 677 677 query63 227 194 197 194 query64 43331007666 666 query65 4334421542604215 query66 1085423 327 327 query67 15791 15574 15293 15293 query68 8417897 517 517 query69 463 312 266 266 query70 1233111410661066 query71 469 316 298 298 query72 5782478448364784 query73 742 642 360 360 query74 915387018701 query75 3990321627162716 query76 37371203778 778 query77 787 385 290 290 query78 10043 10110 93079307 query79 4272823 570 570 query80 656 529 450 450 query81 470 306 221 221 query82 573 129 102 102 query83 290 256 252 252 query84 302 110 86 86 query85 788 353 325 325 query86 346 313 295 295 query87 4449443944224422 query88 3386221922212219 query89 446 314 302 302 query90 1974223 223 223 query91 142 146 117 117 query92 77 64 61 61 query93 2845949 580 580 query94 676 417 316 316 query95 372 303 285 285 query96 486 593 282 282 query97 3144330231163116 query98 248 211 202 202 query99 1449142812881288 Total cold run time: 279507 ms Total hot run time: 185961 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 t
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820045461 TPC-H: Total hot run time: 33724 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit ab4d208fc2033ca172060bf854dba4288e6a7ee4, data reload: false -- Round 1 -- q1 26294 505750115011 q2 2101279 191 191 q3 10491 1253679 679 q4 10252 1014534 534 q5 7613234823262326 q6 181 162 132 132 q7 911 741 595 595 q8 9303128910591059 q9 6776509350695069 q10 6875229918761876 q11 482 293 263 263 q12 345 347 218 218 q13 17787 364830473047 q14 227 221 203 203 q15 533 479 487 479 q16 444 441 402 402 q17 594 817 377 377 q18 7731741471327132 q19 1341938 550 550 q20 329 336 220 220 q21 3941332623872387 q22 10671019974 974 Total cold run time: 115618 ms Total hot run time: 33724 ms - Round 2, with runtime_filter_mode=off - q1 5071505850695058 q2 228 319 226 226 q3 2134266123132313 q4 1413188513701370 q5 4544442143984398 q6 213 165 125 125 q7 1942189717811781 q8 2612247525172475 q9 7275715971827159 q10 3001315727332733 q11 576 513 482 482 q12 682 758 586 586 q13 3496388633133313 q14 281 294 265 265 q15 517 493 482 482 q16 443 503 470 470 q17 1116150314131413 q18 7755756973817381 q19 776 829 935 829 q20 2008204919041904 q21 5312463144844484 q22 1068105310171017 Total cold run time: 52463 ms Total hot run time: 50264 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2820014143 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2819992908 run cloud_p0 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2819911843 run cloud_p0 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2817810153 run cloud_p0 -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
github-actions[bot] commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2817547967 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2815250921 # BE UT Coverage Report Increment line coverage `0.00% (0/165)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/52a927341142ceda21c0975d51b758203dcf7c7e_52a927341142ceda21c0975d51b758203dcf7c7e/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/52a927341142ceda21c0975d51b758203dcf7c7e_52a927341142ceda21c0975d51b758203dcf7c7e/report/index.html) | Category | Coverage | |---|| | Function Coverage | 53.14% (14423/27144) | | Line Coverage | 41.98% (124940/297588) | | Region Coverage | 40.82% (63838/156408) | | Branch Coverage | 35.45% (32096/90546) | -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2815109528 TPC-H: Total hot run time: 33752 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 52a927341142ceda21c0975d51b758203dcf7c7e, data reload: false -- Round 1 -- q1 26061 503450565034 q2 2058290 184 184 q3 10376 1224682 682 q4 10220 1009539 539 q5 7544241323272327 q6 186 168 133 133 q7 941 746 611 611 q8 9312128710271027 q9 6824515251095109 q10 6810231118931893 q11 469 281 277 277 q12 348 356 224 224 q13 17769 366431193119 q14 224 237 219 219 q15 533 496 496 496 q16 454 450 402 402 q17 583 862 356 356 q18 7513721770377037 q19 1397957 555 555 q20 338 318 214 214 q21 4010266723652365 q22 1055977 949 949 Total cold run time: 115025 ms Total hot run time: 33752 ms - Round 2, with runtime_filter_mode=off - q1 5139512250785078 q2 249 342 230 230 q3 2164261123122312 q4 1427181114121412 q5 4427437744044377 q6 219 166 126 126 q7 2041191217991799 q8 2602254625352535 q9 7258725069956995 q10 3006316927642764 q11 590 501 494 494 q12 697 746 631 631 q13 3537384033043304 q14 284 300 269 269 q15 541 501 475 475 q16 477 503 463 463 q17 1153157313901390 q18 7762751973547354 q19 770 777 808 777 q20 2063209019001900 q21 5175498648094809 q22 1054104210131013 Total cold run time: 52635 ms Total hot run time: 50507 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2815143429 ClickBench: Total hot run time: 29.77 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 52a927341142ceda21c0975d51b758203dcf7c7e, data reload: false query1 0.040.040.03 query2 0.130.100.12 query3 0.250.200.19 query4 1.580.200.21 query5 0.620.620.59 query6 1.190.720.71 query7 0.020.020.02 query8 0.030.030.03 query9 0.580.540.50 query10 0.560.580.56 query11 0.140.110.12 query12 0.150.120.11 query13 0.610.590.59 query14 1.151.221.19 query15 0.870.870.85 query16 0.390.380.39 query17 1.061.051.00 query18 0.210.200.20 query19 1.931.801.81 query20 0.020.010.01 query21 15.42 0.890.56 query22 0.761.190.71 query23 14.91 1.380.62 query24 6.702.500.88 query25 0.480.080.25 query26 0.680.170.15 query27 0.060.050.05 query28 9.660.780.44 query29 12.56 4.063.38 query30 0.260.090.06 query31 2.820.580.39 query32 3.240.560.46 query33 3.063.083.11 query34 15.60 5.154.44 query35 4.534.514.50 query36 0.680.500.48 query37 0.080.060.06 query38 0.060.040.04 query39 0.030.020.02 query40 0.170.140.12 query41 0.080.030.03 query42 0.030.020.03 query43 0.030.030.03 Total cold run time: 103.43 s Total hot run time: 29.77 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2815127562 TPC-DS: Total hot run time: 192494 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 52a927341142ceda21c0975d51b758203dcf7c7e, data reload: false query1 1410110510741074 query2 6265178917951789 query3 10995 453345234523 query4 53716 25572 23427 23427 query5 5171495 459 459 query6 355 200 199 199 query7 4985500 276 276 query8 338 273 261 261 query9 6128255125702551 query10 455 318 262 262 query11 15217 14975 14801 14801 query12 164 112 105 105 query13 1098521 400 400 query14 10383 646766016467 query15 196 194 185 185 query16 7041678 493 493 query17 1125761 604 604 query18 1527418 336 336 query19 210 202 177 177 query20 141 140 132 132 query21 205 150 126 126 query22 4324437441594159 query23 34471 33257 33416 33257 query24 6787244524642445 query25 466 476 425 425 query26 638 280 165 165 query27 2295501 337 337 query28 3166213821542138 query29 580 578 436 436 query30 295 221 194 194 query31 873 839 786 786 query32 74 69 70 69 query33 474 372 334 334 query34 884 892 524 524 query35 830 840 728 728 query36 951 1008900 900 query37 116 108 101 101 query38 4211423641484148 query39 1517144614181418 query40 208 122 110 110 query41 55 53 60 53 query42 129 107 108 107 query43 510 495 477 477 query44 1350826 833 826 query45 178 174 172 172 query46 865 1055652 652 query47 1824183717691769 query48 387 425 324 324 query49 665 533 456 456 query50 660 708 419 419 query51 4227422442294224 query52 109 113 102 102 query53 243 266 188 188 query54 586 586 524 524 query55 86 88 85 85 query56 310 298 283 283 query57 1195115811051105 query58 260 267 268 267 query59 2612282225822582 query60 330 310 310 310 query61 134 125 127 125 query62 736 756 684 684 query63 233 220 197 197 query64 14061039712 712 query65 4468421442264214 query66 735 395 303 303 query67 15726 15535 15165 15165 query68 7497892 506 506 query69 543 295 268 268 query70 1211109611011096 query71 513 327 301 301 query72 5585487249604872 query73 1267708 345 345 query74 8940886787968796 query75 3800320827132713 query76 43581198764 764 query77 597 383 294 294 query78 996210047 92009200 query79 2429827 569 569 query80 689 512 455 455 query81 501 271 224 224 query82 427 127 99 99 query83 379 253 243 243 query84 300 103 89 89 query85 789 348 305 305 query86 403 303 280 280 query87 4447456145024502 query88 3133220822292208 query89 402 314 281 281 query90 1837221 224 221 query91 143 148 117 117 query92 70 61 58 58 query93 1938942 577 577 query94 667 406 300 300 query95 379 337 290 290 query96 474 560 273 273 query97 3176322431163116 query98 230 211 203 203 query99 1445138912831283 Total cold run time: 298835 ms Total hot run time: 192494 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] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2815027247 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2815017132 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2806993311 # BE UT Coverage Report Increment line coverage `0.00% (0/124)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/b58435eeb0572e89af2bcee84fdb485e01b64799_b58435eeb0572e89af2bcee84fdb485e01b64799/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/b58435eeb0572e89af2bcee84fdb485e01b64799_b58435eeb0572e89af2bcee84fdb485e01b64799/report/index.html) | Category | Coverage | |---|| | Function Coverage | 52.42% (14109/26913) | | Line Coverage | 41.33% (122322/295935) | | Region Coverage | 40.06% (62247/155367) | | Branch Coverage | 34.77% (31247/89866) | -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2806663104 ClickBench: Total hot run time: 30.88 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit b58435eeb0572e89af2bcee84fdb485e01b64799, data reload: false query1 0.030.030.03 query2 0.130.110.11 query3 0.250.190.19 query4 1.590.190.19 query5 0.590.590.59 query6 1.200.710.72 query7 0.020.010.01 query8 0.040.040.03 query9 0.570.530.52 query10 0.570.570.57 query11 0.150.120.11 query12 0.140.110.12 query13 0.610.590.59 query14 2.802.802.82 query15 0.910.850.84 query16 0.380.380.40 query17 1.081.031.02 query18 0.210.190.19 query19 1.882.011.79 query20 0.010.010.02 query21 15.37 0.910.56 query22 0.741.160.62 query23 14.99 1.380.65 query24 7.911.020.36 query25 0.450.260.10 query26 0.640.160.15 query27 0.050.050.06 query28 8.960.880.45 query29 12.63 4.043.33 query30 0.250.090.08 query31 2.810.580.38 query32 3.230.560.46 query33 3.063.063.19 query34 15.84 5.154.51 query35 4.554.574.54 query36 0.650.490.48 query37 0.080.060.06 query38 0.050.040.04 query39 0.030.020.02 query40 0.160.140.12 query41 0.090.020.03 query42 0.040.020.03 query43 0.040.030.03 Total cold run time: 105.78 s Total hot run time: 30.88 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2806629927 TPC-DS: Total hot run time: 193673 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 b58435eeb0572e89af2bcee84fdb485e01b64799, data reload: false query1 1422109610571057 query2 6277195519591955 query3 11151 457047844570 query4 25408 23642 23483 23483 query5 4082618 456 456 query6 284 199 206 199 query7 3986496 277 277 query8 300 260 248 248 query9 8500260826212608 query10 481 330 268 268 query11 15183 15074 14891 14891 query12 166 110 109 109 query13 1568531 404 404 query14 8755634461836183 query15 201 192 164 164 query16 7304654 482 482 query17 1196725 594 594 query18 2086440 331 331 query19 199 206 177 177 query20 130 129 124 124 query21 210 128 122 122 query22 4433462644884488 query23 34772 34038 33482 33482 query24 8593244824252425 query25 547 487 397 397 query26 1210272 154 154 query27 3120497 335 335 query28 4569246124332433 query29 751 582 475 475 query30 277 225 196 196 query31 948 851 844 844 query32 84 63 62 62 query33 535 387 327 327 query34 802 875 511 511 query35 811 836 777 777 query36 963 989 911 911 query37 131 104 79 79 query38 4335413942614139 query39 1526146914461446 query40 220 126 113 113 query41 53 55 50 50 query42 118 101 108 101 query43 519 513 497 497 query44 1317834 819 819 query45 182 187 171 171 query46 860 1026645 645 query47 1843187217871787 query48 391 413 311 311 query49 779 520 425 425 query50 699 711 427 427 query51 4288430741754175 query52 112 108 99 99 query53 241 261 193 193 query54 588 576 520 520 query55 105 93 84 84 query56 319 307 295 295 query57 1156123911211121 query58 269 262 295 262 query59 2743275426002600 query60 323 314 297 297 query61 128 134 131 131 query62 757 714 639 639 query63 228 189 189 189 query64 40181061677 677 query65 4342423842484238 query66 982 409 307 307 query67 15795 15649 16090 15649 query68 8872936 526 526 query69 496 317 269 269 query70 1221112111291121 query71 474 323 302 302 query72 5830475447784754 query73 701 625 344 344 query74 9155893687848784 query75 3891319026482648 query76 37401192769 769 query77 786 389 281 281 query78 998010267 93029302 query79 2522816 562 562 query80 621 513 531 513 query81 499 250 217 217 query82 447 127 92 92 query83 277 242 237 237 query84 289 99 86 86 query85 785 364 317 317 query86 341 289 288 288 query87 4416453343704370 query88 3275217521512151 query89 396 309 286 286 query90 1923204 213 204 query91 142 145 113 113 query92 83 59 58 58 query93 1385949 595 595 query94 665 429 293 293 query95 425 295 274 274 query96 481 563 268 268 query97 3162326631653165 query98 223 200 207 200 query99 1440142812791279 Total cold run time: 279614 ms Total hot run time: 193673 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 t
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2806517223 TPC-H: Total hot run time: 34065 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit b58435eeb0572e89af2bcee84fdb485e01b64799, data reload: false -- Round 1 -- q1 26065 521349714971 q2 2058274 190 190 q3 10397 1258694 694 q4 10229 1022539 539 q5 7524241323492349 q6 187 164 134 134 q7 936 756 601 601 q8 9303133011621162 q9 6790509852625098 q10 6817230918811881 q11 480 289 269 269 q12 346 361 215 215 q13 17775 370730443044 q14 230 233 207 207 q15 525 483 494 483 q16 633 615 578 578 q17 626 859 386 386 q18 7491728370477047 q19 1531977 556 556 q20 344 355 232 232 q21 4326361724332433 q22 10591039996 996 Total cold run time: 115672 ms Total hot run time: 34065 ms - Round 2, with runtime_filter_mode=off - q1 5121505950555055 q2 240 330 234 234 q3 2177265822912291 q4 1413180414911491 q5 4453439943744374 q6 216 167 130 130 q7 2020191417301730 q8 2605249024732473 q9 7381720372447203 q10 2970319427622762 q11 604 527 500 500 q12 683 746 632 632 q13 3495387433373337 q14 280 307 273 273 q15 533 485 482 482 q16 673 683 659 659 q17 1177151314301430 q18 7816750776087507 q19 841 852 1059852 q20 1953197619451945 q21 5296478647774777 q22 1104107910141014 Total cold run time: 53051 ms Total hot run time: 51151 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
dataroaring commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2805428201 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
hello-stephen commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2802239021 # BE UT Coverage Report Increment line coverage `0.00% (0/91)` :tada: [Increment coverage report](http://coverage.selectdb-in.cc/coverage/db4adce4281035815cd5ca27b67293ab51163add_db4adce4281035815cd5ca27b67293ab51163add/increment_report/index.html) [Complete coverage report](http://coverage.selectdb-in.cc/coverage/db4adce4281035815cd5ca27b67293ab51163add_db4adce4281035815cd5ca27b67293ab51163add/report/index.html) | Category | Coverage | |---|| | Function Coverage | 52.47% (14107/26887) | | Line Coverage | 41.26% (121953/295542) | | Region Coverage | 40.02% (62103/155162) | | Branch Coverage | 34.67% (31085/89670) | -- 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2801972321 ClickBench: Total hot run time: 30.86 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit db4adce4281035815cd5ca27b67293ab51163add, data reload: false query1 0.040.040.03 query2 0.120.110.11 query3 0.240.190.19 query4 1.590.200.19 query5 0.570.600.58 query6 1.200.720.75 query7 0.030.020.01 query8 0.040.030.04 query9 0.570.520.51 query10 0.560.570.56 query11 0.160.110.11 query12 0.140.110.11 query13 0.620.590.60 query14 2.682.682.82 query15 0.940.860.85 query16 0.400.380.37 query17 1.041.011.02 query18 0.210.190.19 query19 1.891.921.83 query20 0.010.010.01 query21 15.35 0.900.54 query22 0.771.170.66 query23 14.98 1.380.64 query24 6.502.380.54 query25 0.480.130.19 query26 0.720.160.14 query27 0.050.050.05 query28 9.730.910.43 query29 12.54 4.043.29 query30 0.250.090.08 query31 2.810.600.38 query32 3.230.550.48 query33 3.143.123.07 query34 15.87 5.084.49 query35 4.474.504.47 query36 0.680.500.49 query37 0.090.070.06 query38 0.050.040.03 query39 0.030.020.03 query40 0.170.140.13 query41 0.080.020.02 query42 0.030.020.02 query43 0.030.030.02 Total cold run time: 105.1 s Total hot run time: 30.86 s ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2801955790 TPC-DS: Total hot run time: 192735 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 db4adce4281035815cd5ca27b67293ab51163add, data reload: false query1 1426108310461046 query2 6117187418721872 query3 11055 438245334382 query4 53586 24451 23031 23031 query5 5053532 445 445 query6 341 203 192 192 query7 4865501 280 280 query8 326 252 249 249 query9 5850260726082607 query10 434 319 260 260 query11 15007 15007 14662 14662 query12 150 110 103 103 query13 1024494 377 377 query14 10045 635764036357 query15 205 189 178 178 query16 7047649 479 479 query17 1083746 560 560 query18 1525400 318 318 query19 196 227 168 168 query20 126 130 117 117 query21 212 122 104 104 query22 4486457342834283 query23 34400 33627 33500 33500 query24 6695245124472447 query25 500 509 434 434 query26 669 276 162 162 query27 2215510 341 341 query28 3079246124272427 query29 612 581 460 460 query30 283 226 201 201 query31 859 903 798 798 query32 80 69 63 63 query33 465 388 316 316 query34 773 873 520 520 query35 802 908 772 772 query36 973 995 898 898 query37 125 98 74 74 query38 4267427842424242 query39 1657142914371429 query40 215 123 106 106 query41 55 53 50 50 query42 125 111 106 106 query43 512 523 485 485 query44 1335839 825 825 query45 181 182 168 168 query46 829 1035651 651 query47 1844188018011801 query48 384 414 312 312 query49 668 516 408 408 query50 660 713 411 411 query51 4230421943684219 query52 116 105 99 99 query53 227 258 186 186 query54 591 570 510 510 query55 81 83 86 83 query56 288 327 307 307 query57 1177118911391139 query58 261 255 251 251 query59 2728293626792679 query60 343 322 307 307 query61 132 132 128 128 query62 774 751 685 685 query63 227 190 183 183 query64 17081058776 776 query65 4317425142034203 query66 773 393 306 306 query67 15615 15479 15176 15176 query68 7268882 520 520 query69 532 298 265 265 query70 1286113811221122 query71 497 328 303 303 query72 5794487649444876 query73 1437693 347 347 query74 8873915590219021 query75 3827322326672667 query76 42661182742 742 query77 618 380 307 307 query78 10174 10004 93639363 query79 2447834 564 564 query80 641 516 445 445 query81 471 259 224 224 query82 471 130 95 95 query83 361 251 233 233 query84 286 94 90 90 query85 873 356 305 305 query86 374 322 290 290 query87 4521446143594359 query88 3391221122482211 query89 405 328 282 282 query90 1956209 217 209 query91 145 143 119 119 query92 77 61 57 57 query93 1455947 574 574 query94 694 415 281 281 query95 368 300 284 284 query96 485 559 275 275 query97 3139328531053105 query98 233 202 200 200 query99 1444141012861286 Total cold run time: 297818 ms Total hot run time: 192735 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 t
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
doris-robot commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2801912376 TPC-H: Total hot run time: 33850 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit db4adce4281035815cd5ca27b67293ab51163add, data reload: false -- Round 1 -- q1 26010 506350205020 q2 2075279 186 186 q3 10386 1232681 681 q4 10226 995 538 538 q5 7541232823032303 q6 181 161 129 129 q7 900 743 606 606 q8 9301126210021002 q9 6817508251195082 q10 6810233119001900 q11 472 297 288 288 q12 360 350 215 215 q13 17778 366030443044 q14 231 224 216 216 q15 522 490 491 490 q16 626 614 583 583 q17 573 886 352 352 q18 7642716870877087 q19 1235949 555 555 q20 334 346 221 221 q21 3765339323872387 q22 10631037965 965 Total cold run time: 114848 ms Total hot run time: 33850 ms - Round 2, with runtime_filter_mode=off - q1 5096512251045104 q2 243 333 227 227 q3 2171269122592259 q4 1422181413791379 q5 4397438343694369 q6 216 173 129 129 q7 1958196518041804 q8 2573254925302530 q9 7246717270397039 q10 3000321427462746 q11 574 514 519 514 q12 700 755 636 636 q13 3515387432313231 q14 285 328 278 278 q15 518 479 475 475 q16 656 686 640 640 q17 1158156213981398 q18 7690758774107410 q19 783 820 936 820 q20 1946199018401840 q21 5234488647394739 q22 1113106610301030 Total cold run time: 52494 ms Total hot run time: 50597 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
Re: [PR] [Enhancement](compaction) Try get global lock when execute compaction [doris]
Yukang-Lian commented on PR #49882: URL: https://github.com/apache/doris/pull/49882#issuecomment-2801782196 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-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
