Re: OPTIMIZE TABLE VERY SLOW In one RDS instance
InnoDB doesn't support OPTIMIZE. The command creates an empty table, copies all rows from the existing table, deletes the old table, renames the new table, re-indexes, then runs ANALYZE to gather stats. Try doing that sequence instead of ANALYZE to see which step takes so much time for that table.
Subject
Written By
Posted
September 20, 2021 01:59AM
Re: OPTIMIZE TABLE VERY SLOW In one RDS instance
September 20, 2021 10:45AM
September 20, 2021 01:51PM
September 20, 2021 03:21PM
September 20, 2021 08:33PM
September 20, 2021 11:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.