Announcement

Announcement Module
Collapse
No announcement yet.

Does OPTIMIZE TABLE do a CHECK and REPAIR

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

  • Does OPTIMIZE TABLE do a CHECK and REPAIR

    Apart from its optimization activities, does OPTIMIZE TABLE also CHECK the tables for corruptions and REPAIR the corrupted ones? The OPTIMIZE TABLE documentation (http://dev.mysql.com/doc/refman/5.0/...ize-table.html) isn't very clear about this.

    Currently i'm running a periodic OPTIMIZE TABLE and i'm wondering if i should replace that with "mysqlcheck -Aao –auto-repair".

    Appreciate you time. Thanks.

    -Thiru

  • #2
    It is engine-specific. What storage engine?

    Comment

    Working...
    X