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

[GitBox]

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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org