After I REPAIR
OPTIMIZE
ANALYZE
OR CHECK
a table, do I need to FLUSH
it?
mysql - FLUSH TABLE needed?
Asked Answered
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.
© 2022 - 2024 — McMap. All rights reserved.