search cancel

Is still necessary for Archive Manager after migrating to innodb engine


Article ID: 255051


Updated On:


DX NetOps


I just wanted to verify that if we migrate to InnoDB there will be no further need to run the script on a regular basis to reclaim disk space. My understanding is that InnoDB automatically manages disk space usage.



Release : 22.2.x / 21.x


It is still recommended to run but the optimize table command when run on innodb just does a recreate table + analyze which is the equivalent command of rebuilding the table structure and update index statistics.

Therefore because we are constantly deleting events as we pass the 45 days age it does appear to be beneficial in running on a monthly basis.


Additional Information

Optimize Table MYSQL Docs