7

After I REPAIR OPTIMIZE ANALYZE OR CHECK a table, do I need to FLUSH it?

Hope4You
  • 1,817
  • 3
  • 21
  • 42

1 Answers1

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
  • 41,574
  • 15
  • 86
  • 128