MySQL Forums
Forum List  »  InnoDB

Re: mysql got signal 6 and restarted twice in last 2 days
Posted by: Vaibhav Upadhyay
Date: February 27, 2017 12:42PM

Ok Peter thanks for your time.

seems i am stuck in between handling regular growth and on other side managing older records to update in-order to use partition efficiently.

i believe if i can manage to update the partition column i can manage to solve the problem upto certain extent.

i think i really have to use very very small chunk for deleting and then have tp approach for optimisation and further updating in very smaller chunks.

Also thanks for drawing attention to the memory swap , that was a big miss from my part.

Thank you Peter and Jon.
will post my updates on progress.

Options: ReplyQuote

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.