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