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


Subject
Views
Written By
Posted
2428
August 27, 2014 01:56AM
Re: Table kept crashing
1455
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.