After I REPAIR
OPTIMIZE
ANALYZE
OR CHECK
a table, do I need to FLUSH
it?
Asked
Active
Viewed 3,559 times
1 Answers
7
A flush is not necessary.
When it comes to ANALYZE TABLE or CHECK TABLE, they just read the table. ANALYZE
will write index statistics elsewhere.
When it comes to REPAIR TABLE or OPTIMIZE TABLE, they perform full DDL by copying the MyISAM table to a temp table and then renaming the table back.

RolandoMySQLDBA
- 43,883
- 16
- 91
- 132