You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "mrhhsg (via GitHub)" <gi...@apache.org> on 2023/11/15 09:37:42 UTC
[PR] [debug](log) add some log to debug issue about insert [doris]
mrhhsg opened a new pull request, #27045:
URL: https://github.com/apache/doris/pull/27045
## Proposed changes
Issue Number: close #xxx
<!--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] [debug](log) add some log to debug issue about insert [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27045:
URL: https://github.com/apache/doris/pull/27045#issuecomment-1812360882
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 45.42 seconds
stream load tsv: 555 seconds loaded 74807831229 Bytes, about 128 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: 34 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 28.5 seconds inserted 10000000 Rows, about 350K ops/s
storage size: 17096750825 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] [debug](log) add some log to debug issue about insert [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27045:
URL: https://github.com/apache/doris/pull/27045#issuecomment-1812120893
clang-tidy review says "All clean, LGTM! :+1:"
--
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] [debug](log) add some log to debug issue about insert [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27045:
URL: https://github.com/apache/doris/pull/27045#issuecomment-1813581784
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
Re: [PR] [debug](log) add some log to debug issue about insert [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27045:
URL: https://github.com/apache/doris/pull/27045#issuecomment-1812363893
<details>
<summary>TPC-H test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'</summary>
```
Tpch sf100 test result on commit 6ff1a7361c50fa261ee1cc1bacdc170edc48846b, data reload: false
run tpch-sf100 query with default conf and session variables
q1 5325 5343 5098 5098
q2 371 150 159 150
q3 2037 1987 1967 1967
q4 1409 1293 1234 1234
q5 3940 3931 3954 3931
q6 248 134 133 133
q7 1407 878 907 878
q8 2733 2781 2765 2765
q9 12246 9661 9609 9609
q10 3429 3562 3513 3513
q11 382 258 258 258
q12 446 286 291 286
q13 4611 3781 3789 3781
q14 311 291 303 291
q15 649 579 584 579
q16 674 586 586 586
q17 1131 987 957 957
q18 7796 7370 7457 7370
q19 1669 1689 1653 1653
q20 551 328 318 318
q21 4426 4013 4030 4013
q22 514 407 402 402
Total cold run time: 56305 ms
Total hot run time: 49772 ms
run tpch-sf100 query with default conf and set session variable runtime_filter_mode=off
q1 5066 5055 4959 4959
q2 349 233 237 233
q3 4066 3867 3965 3867
q4 2777 2745 2782 2745
q5 9404 9426 9383 9383
q6 248 126 128 126
q7 2708 2291 2297 2291
q8 4861 4818 4842 4818
q9 13165 13054 13115 13054
q10 4086 4168 4174 4168
q11 745 685 643 643
q12 1000 853 817 817
q13 4293 3620 3536 3536
q14 378 338 355 338
q15 619 582 568 568
q16 739 690 703 690
q17 3927 3885 3927 3885
q18 9487 8883 9003 8883
q19 1838 1773 1790 1773
q20 2452 2074 2095 2074
q21 8747 8545 8529 8529
q22 989 847 908 847
Total cold run time: 81944 ms
Total hot run time: 78227 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] [debug](log) add some log to debug issue about insert [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #27045:
URL: https://github.com/apache/doris/pull/27045#issuecomment-1813581718
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] [debug](log) add some log to debug issue about insert [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #27045:
URL: https://github.com/apache/doris/pull/27045#issuecomment-1812256197
TeamCity be ut coverage result:
Function Coverage: 36.79% (8418/22879)
Line Coverage: 29.27% (68380/233630)
Region Coverage: 27.87% (35344/126822)
Branch Coverage: 24.64% (18062/73296)
Coverage Report: http://coverage.selectdb-in.cc/coverage/6ff1a7361c50fa261ee1cc1bacdc170edc48846b_6ff1a7361c50fa261ee1cc1bacdc170edc48846b/report/index.html
--
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] [debug](log) add some log to debug issue about insert [doris]
Posted by "mrhhsg (via GitHub)" <gi...@apache.org>.
mrhhsg commented on PR #27045:
URL: https://github.com/apache/doris/pull/27045#issuecomment-1812108603
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] [debug](log) add some log to debug issue about insert [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #27045:
URL: https://github.com/apache/doris/pull/27045
--
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