MySQL Forums
Forum List  »  Data Recovery

faster recoveries from crash
Posted by: Pat O`Mara
Date: May 24, 2009 10:16AM

Hi Folks,

My (Linux) server occassional crashes for one reason or another. Invariably the majority of my MyISAM tables are corrupt and need to be repaired. They're always repaired cleanly and without problem, but with several GB of data it's quite a slow process - generally takes an hour or so.

I'm wondering if there's anything I can set in my.cnf to reduce the changes of tables being marked as crashed. Would enabling the bin log help?

Options: ReplyQuote

Written By
faster recoveries from crash
May 24, 2009 10:16AM
May 25, 2009 06:18AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.