Hi all,
Is there any chance to stop OPTIMIZE TABLE operation without data corrupting?
I found this situation if I kill thread ID of an optimizing operation from the processlist, the data became a corrupted.
And the documentation says the same:
Killing a REPAIR TABLE or OPTIMIZE TABLE operation on a MyISAM table results in a table that is corrupted and unusable. Any reads or writes to such a table fail until you optimize or repair it again (without interruption)