MySQL Forums
Forum List  »  Performance

Re: Lock wait timeout exceeded; try restarting transaction
Posted by: Ra Nala
Date: January 08, 2016 06:23AM

When i go through the link which is provided by you. they suggested us to kept chunk size 1000. but in my case i used 300000 it might be problem in my scenario.

why i kept chunk size 300000 is, when my ETL(pdi) tool iterate the job so many times i may get java heap space error.

Anyhow Sir, please correct me if i kept size is too much high.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Lock wait timeout exceeded; try restarting transaction
2107
January 08, 2016 06:23AM


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.