Re: [PR] [enhance](mtmv)Optimize MTMV lock logic [doris]
github-actions[bot] commented on PR #44967: URL: https://github.com/apache/doris/pull/44967#issuecomment-2516391789 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] [enhance](mtmv)Optimize MTMV lock logic [doris]
github-actions[bot] commented on PR #44967: URL: https://github.com/apache/doris/pull/44967#issuecomment-2516391739 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] [enhance](mtmv)Optimize MTMV lock logic [doris]
doris-robot commented on PR #44967: URL: https://github.com/apache/doris/pull/44967#issuecomment-2516170435 ClickBench: Total hot run time: 33.05 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 23f43b917d3427f9b69d9895f164467312aafbdc, data reload: false query1 0.030.040.03 query2 0.060.030.03 query3 0.240.070.07 query4 1.620.100.11 query5 0.420.410.41 query6 1.140.660.65 query7 0.020.010.01 query8 0.040.030.03 query9 0.570.520.49 query10 0.570.560.57 query11 0.130.100.10 query12 0.150.100.12 query13 0.600.600.58 query14 2.732.742.78 query15 0.910.820.83 query16 0.380.370.39 query17 1.011.061.06 query18 0.220.210.21 query19 1.941.912.05 query20 0.020.010.02 query21 15.36 0.580.59 query22 2.642.121.90 query23 17.07 0.810.74 query24 3.001.421.40 query25 0.290.130.04 query26 0.490.130.14 query27 0.040.040.04 query28 10.41 1.091.07 query29 12.57 3.273.22 query30 0.260.060.06 query31 2.870.370.37 query32 3.280.470.45 query33 2.983.123.01 query34 17.08 4.524.50 query35 4.504.474.50 query36 0.680.500.48 query37 0.090.060.06 query38 0.060.030.03 query39 0.040.030.03 query40 0.160.130.12 query41 0.070.030.02 query42 0.040.020.02 query43 0.030.030.03 Total cold run time: 106.81 s Total hot run time: 33.05 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] [enhance](mtmv)Optimize MTMV lock logic [doris]
doris-robot commented on PR #44967: URL: https://github.com/apache/doris/pull/44967#issuecomment-2516165416 TPC-DS: Total hot run time: 196973 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 23f43b917d3427f9b69d9895f164467312aafbdc, data reload: false query1 1258953 930 930 query2 6239208119921992 query3 11005 439144844391 query4 33399 23555 23619 23555 query5 3553475 447 447 query6 275 185 165 165 query7 3989293 322 293 query8 287 226 234 226 query9 9586272127102710 query10 461 246 250 246 query11 17881 15238 15275 15238 query12 145 104 97 97 query13 1543407 405 405 query14 9704665467016654 query15 248 204 189 189 query16 8067498 472 472 query17 1563592 604 592 query18 2203317 330 317 query19 262 168 165 165 query20 128 111 113 111 query21 198 105 103 103 query22 4907460544574457 query23 35377 36587 34403 34403 query24 10716 258425372537 query25 541 382 406 382 query26 783 155 158 155 query27 2844274 297 274 query28 8199252225062506 query29 671 413 470 413 query30 233 143 157 143 query31 1074866 866 866 query32 95 57 52 52 query33 769 298 295 295 query34 1129514 537 514 query35 936 797 752 752 query36 1119972 984 972 query37 128 79 74 74 query38 4516451144494449 query39 1512146114851461 query40 257 103 104 103 query41 46 45 56 45 query42 114 98 98 98 query43 528 499 492 492 query44 1278851 849 849 query45 188 171 174 171 query46 1175723 726 723 query47 2025198019711971 query48 426 316 321 316 query49 998 406 442 406 query50 832 412 392 392 query51 7443728972627262 query52 103 94 95 94 query53 254 186 179 179 query54 1092415 408 408 query55 87 81 79 79 query56 271 237 240 237 query57 1298117111651165 query58 238 209 212 209 query59 3217293630192936 query60 264 242 237 237 query61 113 103 107 103 query62 888 671 684 671 query63 213 187 182 182 query64 3973673 661 661 query65 3279319932183199 query66 954 360 294 294 query67 15854 15590 15754 15590 query68 4818570 578 570 query69 438 250 259 250 query70 1167115210451045 query71 334 248 245 245 query72 6025415143294151 query73 773 356 365 356 query74 10532 912689608960 query75 3408262927062629 query76 2697101711131017 query77 374 274 313 274 query78 10285 945893879387 query79 1687587 609 587 query80 967 425 427 425 query81 554 237 228 228 query82 860 125 119 119 query83 239 143 142 142 query84 232 73 73 73 query85 1297302 290 290 query86 371 311 302 302 query87 4651450045394500 query88 3415219921782178 query89 432 287 294 287 query90 2016187 183 183 query91 137 105 104 104 query92 58 50 50 50 query93 1739551 546 546 query94 927 293 296 293 query95 353 282 249 249 query96 615 282 280 280 query97 2831267826552655 query98 220 199 190 190 query99 1552133313441333 Total cold run time: 300955 ms Total hot run time: 196973 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] [enhance](mtmv)Optimize MTMV lock logic [doris]
doris-robot commented on PR #44967: URL: https://github.com/apache/doris/pull/44967#issuecomment-2516151557 TPC-H: Total hot run time: 40394 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 23f43b917d3427f9b69d9895f164467312aafbdc, data reload: false -- Round 1 -- q1 17586 755376417553 q2 2052172 169 169 q3 10755 113412141134 q4 10489 771 693 693 q5 7631272627692726 q6 236 147 145 145 q7 1011650 608 608 q8 9266186819281868 q9 6637653265336532 q10 7037227722912277 q11 460 277 255 255 q12 441 216 222 216 q13 17765 299430042994 q14 242 204 212 204 q15 577 523 518 518 q16 651 601 579 579 q17 979 534 539 534 q18 7389683766446644 q19 1330987 973 973 q20 470 180 181 180 q21 4003329232843284 q22 385 312 308 308 Total cold run time: 107392 ms Total hot run time: 40394 ms - Round 2, with runtime_filter_mode=off - q1 7234724172697241 q2 334 231 231 231 q3 2913284729502847 q4 2028186318531853 q5 5652572356835683 q6 228 148 145 145 q7 2304182518071807 q8 3422356035133513 q9 9031906090649060 q10 3579355435753554 q11 609 501 510 501 q12 807 631 616 616 q13 11158 319632313196 q14 302 279 273 273 q15 573 535 531 531 q16 689 643 644 643 q17 1854165216421642 q18 8335789776177617 q19 1705167015151515 q20 2107189018811881 q21 5595545354785453 q22 654 596 598 596 Total cold run time: 71113 ms Total hot run time: 60398 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] [enhance](mtmv)Optimize MTMV lock logic [doris]
zddr commented on PR #44967: URL: https://github.com/apache/doris/pull/44967#issuecomment-2516062827 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] [enhance](mtmv)Optimize MTMV lock logic [doris]
doris-robot commented on PR #44967: URL: https://github.com/apache/doris/pull/44967#issuecomment-2516062459 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]
