Loading data into mysql tables taking insanely long time
Posted by: PURNACHANDRA IRUKULAPATI
Date: February 20, 2018 03:51PM

I'm a Java developer with some functional knowledge of mysql (not an expert by any means!). I have mysql version 5.7.21 which is hosted on Ubuntu 16.04.3 LTS (xenial).

I have a Java program which uses dbUnit frameworkm which downloads the data from our production servers into xml files and tries to load them into mysql tables. In fact, this process actually recreates the schemas and tables in local mysql, before loading the data into the tables. This process used to take around 40-45 mins earlier, whereas all of a sudden it started taking insanely long times, i.e., multiple days. Does anybody have any insights in to this problem? I'm not sure what kind of data helps in troubleshooting this issue, but will provide it upon demand.

Thanks in advance,
Purna

Options: ReplyQuote


Subject
Written By
Posted
Loading data into mysql tables taking insanely long time
February 20, 2018 03:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.