Re: OPTIMIZE TABLE VERY SLOW In one RDS instance
Posted by: Peter Brawley
Date: September 20, 2021 10:45AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: OPTIMIZE TABLE VERY SLOW In one RDS instance
September 20, 2021 10:45AM


Sorry, only registered users may post in this forum.

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.