MySQL Forums
Forum List  »  InnoDB

Re: Mysql hangs once in 2 days with mysterious deadlock?
Posted by: Hankin Chick
Date: October 05, 2014 03:43PM

Me too, this is annoying. Lots of down time while it's stuck. I found that disabling core-file in my.cnf helps. It can take forever to do a core dump if you have a lot of memory.

The other day it got to the point where the database crashed and it wouldn't start up again and I had to use innodb_force_recovery and do a dump and restore.

I'm afraid these crashes will destroy something one day.

I do use transactions.
No foreign keys.
Have lots of partitions in big tables.

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.