You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/03/22 09:14:00 UTC

[GitHub] [incubator-doris] gaodayue opened a new issue #5553: MysqlResultWriter may become a bottleneck for some queries

gaodayue opened a new issue #5553:
URL: https://github.com/apache/incubator-doris/issues/5553


   For queries that return a large number of rows and columns,  we observed that `MysqlResultWriter` may become a bottleneck. 
   
   For example, the query below returns 18K rows and 100 bigint columns for each row. And we observed that `TupleConvertTime` accounts for **51%** of the total execution time.
   
   ```
       Fragment 0:
         Instance 4c71a7a8e4fe447c-9840e16d115713b4:(Active: 363.487ms, % non-child: 49.92%)
            - AverageThreadTokens: 4607182418800017400.00
            - MemoryLimit: 8.00 GB
            - PeakMemoryUsage: 15.75 MB
            - PeakReservation: 0.00 
            - PeakUsedReservation: 0.00 
            - RowsProduced: 18.002K (18002)
           DataBufferSender (dst_fragment_instance_id=4c71a7a8e4fe447c-9840e16d115713b4):
              - AppendBatchTime: 194.511ms
                - ResultRendTime: 5.220ms
                - TupleConvertTime: 185.573ms
              - NumSentRows: 18.002K (18002)
   ```
   
   


-- 
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.

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

[GitHub] [incubator-doris] yangzhg closed issue #5553: MysqlResultWriter may become a bottleneck for some queries

Posted by GitBox <gi...@apache.org>.
yangzhg closed issue #5553:
URL: https://github.com/apache/incubator-doris/issues/5553


   


-- 
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.

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