Why we don’t Optimize InnoDB Tables

The process for optimizing InnoDB tables before MySQL version 5.7 is, at default, ineffective as it essentially rebuilds the entire table. However MySQL version 5.7 or greater or MariaDB is fine as this is resolved and not affected. We know some hosting companies have a configuration that will allow for correct optimization before 5.7 but that’s few and far between. However, we have implemented an override option for the user as long as they are aware of the risks.

Posted in: Optimization Questions