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/01/29 11:23:11 UTC

[GitHub] [incubator-doris] HappenLee opened a new issue #5322: [Bug] Memory consumption of ODBC MySQL Driver

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


   **Describe the bug**
   
   When we need to load lots of data in ODBC table use MySQL ODBC Driver.
   
   Now, ODBC Driver can comsume lots of mem to cache the result of server and delay the load time. 
   ![image](https://user-images.githubusercontent.com/10553413/106268307-e2218a80-6265-11eb-9013-8ba572cfa50f.png)
   
   `204830048 rows affected (6 min 57.06 sec)`
   
   ![image](https://user-images.githubusercontent.com/10553413/106268960-cbc7fe80-6266-11eb-877a-2be11bcc446a.png)
   
   ## After use cursor and no cache the result
   ![image](https://user-images.githubusercontent.com/10553413/106269169-1e091f80-6267-11eb-9f02-104215807b24.png)
   
   mem not use so many and load time only cost: `204830048 rows affected (6 min 27.66 sec)`
   
    
   


----------------------------------------------------------------
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] HappenLee closed issue #5322: [Bug] Memory consumption of ODBC MySQL Driver

Posted by GitBox <gi...@apache.org>.

HappenLee closed issue #5322:
URL: https://github.com/apache/incubator-doris/issues/5322


   


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