Re: Surviving MySQL crash

[Foo Ji-Haw]

Heikki Tuuri wrote:

> Ji-Haw,
>
> if the OS crashes do not corrupt files, then InnoDB tables would 
> survive an OS crash without a problem. 

Thanks for the reply Heikki. Let me rephrase my problem: the data 
remains intact, but I suspect the indexes are corrupted. Basically I 
have to run myisamcheck and mysqlcheck to get my tables operational 
again. No data loss though.

Logan (thanks Logan) suggested a periodic flush call. I am wondering if 
auto flushing is available?