MySQL Forums
Forum List  »  Data Warehouse

Re: datawarehouse ETL rolls back after 5 GB of data transfer
Posted by: shyam ahuja
Date: May 17, 2010 01:03PM

I did re-installed mysql with multifunctional and oltp options which allows more memory allocated to hold data!

my last table(log_playlg) is approx 60 GB or so. I see other tables are flushed. last insert is still running.

Is there way to flush tables in the middle of transaction, by chance? I want to see how many records are generated and how much time more it will take. It is painful to watch transactions moving slowly.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: datawarehouse ETL rolls back after 5 GB of data transfer
3420
May 17, 2010 01:03PM


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.