MySQL Forums
Forum List  »  MyISAM

Re: improve the chances crash recovery for MyISAM
Posted by: Rick James
Date: June 10, 2012 10:51PM

A crash _may_ leave _some_ MyISAM unusable until RECOVER TABLE is run (possibly via mysqlcheck). During RECOVER, the table being recovered will be inaccessible. If it is a big table (millions of rows), that could be a long time. Period. End of discussion.

So, what to do?

* Avoid crashing. What causes the crashes?

* Switch to InnoDB.

* Tuning _may_ help speed up RECOVER _some_. But it is unlikely to help as much as you probably want.

Options: ReplyQuote

Written By
Re: improve the chances crash recovery for MyISAM
June 10, 2012 10:51PM

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.