MySQL Forums
Forum List  »  MyISAM

Re: Table kept crashing
Posted by: Rick James
Date: August 29, 2014 09:40PM

Switch to InnoDB.

InnoDB is much more crash resistant, and does not need the use of myisamchk (or REPAIR TABLE) after crashes. It repairs itself automatically. Furthermore, there are cases where MyISAM (after a crash) will be left in an unpredictable state.

After switching to InnoDB, learn the basics of "transactions" and use them to some level.

Options: ReplyQuote

Written By
August 27, 2014 01:56AM
Re: Table kept crashing
August 29, 2014 09:40PM

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.