>>>>> "Tim" == Tim Bunce <Tim.Bunce@stripped> writes:
Tim> On Sun, Jan 09, 2000 at 03:53:18PM -0500, Bill Marrs wrote:
>>
>> Sinisa said:
>> >The feature planned is not to integrate startup with recovery, but to
>> >enable recovery while mysql server is running.
>>
>> Well, if you guys change it so that I can bring up mysqld after a kernel
>> panic and have it realize that it's tables need fixing -- then it goes
>> ahead and automatically fixes them - that would be very useful to me.
Tim> And everyone else. Monty recently said that that was the plan (myisam
Tim> tables have a 'stable' flag that the server can use for this at startup).
>> Otherwise, I need to add my own myisamchk lines to my server's startup scripts.
Tim> Best to do that anyway in the meantime. I'm surprised it's not there
Tim> already, even if only as an option.
I agree; I will add that.
Tim> Could you implement yours as an option and post it back to the list?
The proper lines that should cover most cases are:
myisamchk --silent --force --fast --medium-check $DATADIR/*.MYI
isamchk --silent --force $DATADIR/*.MYI
The --fast will tell myisamchk to skip tables that hasn't been
modified since last check.
Regards,
Monty
