MySQL Forums
Forum List  »  MyISAM

Re: Table crash - how to find the cause?
Posted by: Rick James
Date: November 18, 2010 12:07AM

With only 100 INSERTs/minute, don't bother with DELAYED. At 100/sec, that might be worth doing.

Killing mysql and power failure can corrupt MyISAM tables. Do CHECK TABLE (or run myisamchk), and do REPAIRs as indicated. And do this immediately after restarting mysql, not later.

Options: ReplyQuote


Subject
Views
Written By
Posted
8145
November 16, 2010 05:48AM
Re: Table crash - how to find the cause?
2903
November 18, 2010 12:07AM


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.