MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Mysql hangs once in 2 days with mysterious deadlock?
Posted by: Hankin Chick
Date: November 04, 2014 01:46AM

No, I had autocommit turned on.

But I have changed a few things. Disabled row locking by locking the whole table every time I did an update/insert/delete.

It's been 10 days and I haven't had a crash.

So innodb's row locking maybe not working well, it'll crash the database and lose data.

Instead of deleting things by bulk, I'm using "limit" with the "delete"s so that things get deleted a little bit at a time so it doesn't lock the whole table for too long.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.