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