Hi!
>>>>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> Currently mysql waits until disk space freed for myisam tables for
Peter> all situations exept of repair and.... optimize.
Peter> Even more table is marked as crashed and will not repair
Peter> automatically even after disk space freed.
Peter> This situation is not really good thing i think, as if repair table
Peter> is usually called in maintenace mode so you can handle the error,
Peter> optimize table may be used just to shrink tables for to free some
Peter> space, or (in my case) to make concurent inserts work again.
Peter> Also by idea optimize table should be safe procedure, which should
Peter> leave the old copy if it fails.
Peter> My suggessions are:
Peter> 1) may be it would be nice to wait for disk problem to be resolved,
Peter> as it happens in other cases, or make it configurable if you think
Peter> it would be better not to eat all space in this case
This would be easy to do with an option to repair table.
Peter> 2) optimize table may be changed a bit to make a copy of table
Peter> before running optimize on it. This would need a bit more disk space
Peter> and will be a bit slower but will be much safer and will allow
Peter> clients to read from table during all time while optimize works.
This could of course also be done with an option.
We shall put both of the above suggestions on our TODO.
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
