Is db_optimize.pl still necessary for Archive Manager after migrating to innodb engine

Products

• DX NetOps

Issue/Introduction

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

 

Environment

Release : 22.2.x / 21.x

Resolution

It is still recommended to run db_optimize.pl 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 db_optimize.pl on a monthly basis.

 

Additional Information

Optimize Table MYSQL Docs