MySQL Forums
Forum List  »  MyISAM

improve the chances crash recovery for MyISAM
Posted by: Mubarak Abdallah
Date: June 06, 2012 08:10PM

Hi I have a critical mysql running 2 DBs with 5 million entries each.
This has been setup with MyISAM quite long time ago. So far no performance issues.

But I would like to have the ease of recovery for MyISAM tables as close can be to InnoDB recovery. I have small MySQL DBs that always need running recovery commands to run offline every time the server crash.

Can someone guide to steps that can be done to improve tables checks?
I have heard that myisam_recover option can make the performance slow and use alot of RAM, what are the other choices?

I'm using version 5.0.92

Options: ReplyQuote


Subject
Views
Written By
Posted
improve the chances crash recovery for MyISAM
2234
June 06, 2012 08:10PM


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.