You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Mryange (via GitHub)" <gi...@apache.org> on 2023/11/24 03:41:00 UTC
[PR] [fix](profilev2) fix merge profile min is zero [doris]
Mryange opened a new pull request, #27524:
URL: https://github.com/apache/doris/pull/27524
## Proposed changes
before
```
- ExecTime: avg 50.514us, max 101.28us, min 0ns
- OpenTime: avg 39.126us, max 78.252us, min 0ns
```
now
```
- ExecTime: avg 15.413us, max 17.80us, min 14.677us
- OpenTime: avg 15.281us, max 16.953us, min 14.553us
```
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](profilev2) fix merge profile min is zero [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #27524:
URL: https://github.com/apache/doris/pull/27524
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](profilev2) fix merge profile min is zero [doris]
Posted by "Mryange (via GitHub)" <gi...@apache.org>.
Mryange commented on PR #27524:
URL: https://github.com/apache/doris/pull/27524#issuecomment-1825111859
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](profilev2) fix merge profile min is zero [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27524:
URL: https://github.com/apache/doris/pull/27524#issuecomment-1825152957
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](profilev2) fix merge profile min is zero [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27524:
URL: https://github.com/apache/doris/pull/27524#issuecomment-1825176656
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.07 seconds
stream load tsv: 567 seconds loaded 74807831229 Bytes, about 125 MB/s
stream load json: 18 seconds loaded 2358488459 Bytes, about 124 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 29.3 seconds inserted 10000000 Rows, about 341K ops/s
storage size: 17098330267 Bytes
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](profilev2) fix merge profile min is zero [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27524:
URL: https://github.com/apache/doris/pull/27524#issuecomment-1825180984
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 3595fe68e99cdc7a77deb2ecee52c0609c3f8068, data reload: false
run tpch-sf100 query with default conf and session variables
q1 4889 4633 4659 4633
q2 386 178 149 149
q3 2025 1973 1898 1898
q4 1393 1242 1232 1232
q5 3935 3918 4021 3918
q6 244 130 125 125
q7 1427 881 888 881
q8 2747 2751 2738 2738
q9 56419 13673 9474 9474
q10 13144 3532 3507 3507
q11 387 233 251 233
q12 1602 293 293 293
q13 21835 3813 3809 3809
q14 321 289 292 289
q15 574 531 530 530
q16 675 582 588 582
q17 1141 956 933 933
q18 7831 7343 7368 7343
q19 1713 1685 1648 1648
q20 572 313 309 309
q21 7237 4039 3982 3982
q22 479 383 376 376
Total cold run time: 130976 ms
Total hot run time: 48882 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 4629 4576 4580 4576
q2 345 216 276 216
q3 4014 3978 3990 3978
q4 2694 2709 2695 2695
q5 9627 9605 9584 9584
q6 244 123 121 121
q7 2993 2489 2482 2482
q8 4437 4409 4446 4409
q9 12810 12816 12825 12816
q10 4080 4165 4199 4165
q11 766 703 692 692
q12 972 826 821 821
q13 4289 3598 3588 3588
q14 376 349 355 349
q15 571 512 546 512
q16 733 656 672 656
q17 3830 3838 3934 3838
q18 9704 9046 9019 9019
q19 1796 1766 1767 1766
q20 2374 2058 2038 2038
q21 8818 8423 8405 8405
q22 868 844 797 797
Total cold run time: 80970 ms
Total hot run time: 77523 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](profilev2) fix merge profile min is zero [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27524:
URL: https://github.com/apache/doris/pull/27524#issuecomment-1825152989
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org