Hi!
>>>>> "Steven" == Steven Roussey <[EMAIL PROTECTED]> writes:
Steven> Changes in release 3.23.39
Steven> --------------------------
Steven> * Fixed problem with shutdown when `INSERT DELAYED' was waiting for
Steven> a `LOCK TABLE'.
Steven> * Running `myisamchk --fast --force' will no longer repair tables
Steven> that only had the open count wrong.
Steven> --------------------------
Steven> THANK YOU! You don't know what it was for the first item to require a forced
Steven> shutdown that made myisamchk take a huge amount of time. Although we have
Steven> not had the need for a `myisamchk --fast --force' in a while, I tell you if
Steven> you had a big fulltext index, you would avoid it like the plague.
Steven> Now I have a question: Does this also apply to automatic repair inside
Steven> mysqld? I'd finally use the feature if its true...
If you just run CHECK TABLE, it will repair the open count (it should
always have done that).
myisamchk --fast --force is equal to:
run CHECK TABLE on all tables
Run REPAIR TABLE on tables which was not marked as ok.
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php