Re: [PR] [opt](query) accelerate query information_schema.tables from follower node in cloud mode (#51240) [doris]
dataroaring merged PR #51405: URL: https://github.com/apache/doris/pull/51405 -- 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] [opt](query) accelerate query information_schema.tables from follower node in cloud mode (#51240) [doris]
doris-robot commented on PR #51405: URL: https://github.com/apache/doris/pull/51405#issuecomment-2930872789 TPC-DS: Total hot run time: 195606 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 41cb453f6d363366a08c76fa47926a6e0cee5a53, data reload: false query1 1296909 913 909 query2 6206192119211921 query3 10833 421042684210 query4 65923 28081 23319 23319 query5 5056450 440 440 query6 413 187 197 187 query7 5479313 309 309 query8 314 237 219 219 query9 8775257225652565 query10 444 287 266 266 query11 17287 15567 15753 15567 query12 156 104 102 102 query13 1443441 430 430 query14 10220 668567766685 query15 210 188 176 176 query16 7246474 481 474 query17 1073593 611 593 query18 1812329 323 323 query19 211 160 170 160 query20 123 107 111 107 query21 208 107 103 103 query22 4666430443594304 query23 34492 34131 33831 33831 query24 6686291429472914 query25 540 442 414 414 query26 663 174 175 174 query27 2153369 342 342 query28 4344215921252125 query29 684 423 461 423 query30 240 150 151 150 query31 974 801 844 801 query32 67 55 58 55 query33 412 281 302 281 query34 908 523 540 523 query35 843 731 717 717 query36 1082925 952 925 query37 109 70 67 67 query38 4016396739463946 query39 1499144414551444 query40 217 96 101 96 query41 48 47 49 47 query42 119 103 103 103 query43 522 485 500 485 query44 1181819 814 814 query45 180 167 165 165 query46 1147758 774 758 query47 1981188518821882 query48 485 375 380 375 query49 737 414 374 374 query50 855 419 430 419 query51 7286720972207209 query52 97 88 85 85 query53 255 181 186 181 query54 561 444 454 444 query55 75 72 75 72 query56 248 234 247 234 query57 1223113710711071 query58 215 201 206 201 query59 3035299829142914 query60 283 251 249 249 query61 113 108 110 108 query62 798 669 668 668 query63 221 190 190 190 query64 1412661 609 609 query65 3243315831593158 query66 694 285 287 285 query67 15808 15498 15398 15398 query68 4025585 592 585 query69 426 264 264 264 query70 1149113811071107 query71 359 261 257 257 query72 6410406740594059 query73 740 353 359 353 query74 10206 923391589158 query75 3330263026582630 query76 1912115910661066 query77 473 275 276 275 query78 10659 960594499449 query79 1323595 598 595 query80 861 419 414 414 query81 480 221 215 215 query82 124684 86 84 query83 239 149 143 143 query84 283 84 78 78 query85 883 301 286 286 query86 354 284 298 284 query87 4366428142004200 query88 3659236723362336 query89 409 294 293 293 query90 1989187 185 185 query91 185 146 145 145 query92 68 47 57 47 query93 1568556 552 552 query94 799 303 289 289 query95 352 251 248 248 query96 600 277 282 277 query97 3309318331593159 query98 207 192 197 192 query99 1531129812861286 Total cold run time: 316545 ms Total hot run time: 195606 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] [opt](query) accelerate query information_schema.tables from follower node in cloud mode (#51240) [doris]
doris-robot commented on PR #51405: URL: https://github.com/apache/doris/pull/51405#issuecomment-2930893154 ClickBench: Total hot run time: 29.32 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 41cb453f6d363366a08c76fa47926a6e0cee5a53, data reload: false query1 0.030.030.03 query2 0.070.020.03 query3 0.230.060.06 query4 1.630.110.11 query5 0.540.510.50 query6 1.140.730.73 query7 0.020.020.03 query8 0.030.030.03 query9 0.550.520.49 query10 0.550.550.56 query11 0.140.110.11 query12 0.140.110.11 query13 0.600.590.59 query14 0.770.780.81 query15 0.830.820.82 query16 0.380.370.37 query17 0.991.071.04 query18 0.240.200.21 query19 1.961.851.85 query20 0.020.000.01 query21 15.40 0.610.60 query22 2.992.801.55 query23 17.00 0.990.78 query24 2.981.590.47 query25 0.190.180.13 query26 0.450.130.14 query27 0.050.040.03 query28 10.63 0.460.45 query29 12.63 3.183.17 query30 0.240.070.05 query31 2.870.390.37 query32 3.220.460.45 query33 2.932.963.05 query34 16.88 4.504.56 query35 4.514.504.55 query36 0.650.470.49 query37 0.100.060.06 query38 0.050.030.03 query39 0.030.030.02 query40 0.150.120.12 query41 0.080.020.02 query42 0.030.020.02 query43 0.030.030.03 Total cold run time: 104.95 s Total hot run time: 29.32 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] [opt](query) accelerate query information_schema.tables from follower node in cloud mode (#51240) [doris]
doris-robot commented on PR #51405: URL: https://github.com/apache/doris/pull/51405#issuecomment-2930822648 TPC-H: Total hot run time: 41576 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 41cb453f6d363366a08c76fa47926a6e0cee5a53, data reload: false -- Round 1 -- q1 17570 755274617461 q2 2066168 158 158 q3 10790 109512581095 q4 10526 808 802 802 q5 7803298529582958 q6 238 135 130 130 q7 1062615 607 607 q8 9355200620612006 q9 7074676967486748 q10 7070229023242290 q11 470 267 259 259 q12 430 209 210 209 q13 17779 296829582958 q14 250 201 201 201 q15 504 470 455 455 q16 553 375 367 367 q17 998 536 591 536 q18 7233661166746611 q19 1391124611811181 q20 496 197 197 197 q21 4219344333883388 q22 1087959 989 959 Total cold run time: 108964 ms Total hot run time: 41576 ms - Round 2, with runtime_filter_mode=off - q1 7473744873227322 q2 352 229 228 228 q3 3173304230323032 q4 2137189018451845 q5 5843593460895934 q6 233 127 126 126 q7 2350181817871787 q8 3714388037273727 q9 9072908389198919 q10 3693366036513651 q11 601 506 503 503 q12 819 632 633 632 q13 11315 311831863118 q14 307 269 280 269 q15 511 453 457 453 q16 507 472 458 458 q17 1994172516971697 q18 8097766376717663 q19 1804162416831624 q20 2147184018761840 q21 5778551253615361 q22 1146101910291019 Total cold run time: 73066 ms Total hot run time: 61208 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] [opt](query) accelerate query information_schema.tables from follower node in cloud mode (#51240) [doris]
sollhui commented on PR #51405: URL: https://github.com/apache/doris/pull/51405#issuecomment-2930612798 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] [opt](query) accelerate query information_schema.tables from follower node in cloud mode (#51240) [doris]
Thearas commented on PR #51405: URL: https://github.com/apache/doris/pull/51405#issuecomment-2930612307 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]
