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