Apart from its optimization activities, does OPTIMIZE TABLE also CHECK the tables for corruptions and REPAIR the corrupted ones? The OPTIMIZE TABLE documentation ([URL]http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html[/URL]) 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