Announcement

Announcement Module
Collapse
No announcement yet.

Killing OPTIMIZE TABLE operation on MyISAM without corrupting data???

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Killing OPTIMIZE TABLE operation on MyISAM without corrupting data???

    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)
Working...
X