mysql - FLUSH TABLE needed?
Asked Answered
I

1

7

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

Informality answered 9/2, 2012 at 18:16 Comment(0)
Q
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.

Quixotic answered 9/2, 2012 at 18:23 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.