Add system check for deprecated ARCHIVE log tables
In #663 (closed), we changed the default engine for log tables from ARCHIVE
to InnoDB
and shipped this with 5.16. While new installations (and tables first created on 5.16+) will use the InnoDB
engine by default, existing log tables are not migrated automatically. This needs to be done using the System.updatelogtables
API with forceEngineMigration
set to "1".
Once the change has seen some production usage (i.e. a couple of releases from now), we should add a system check to warn admins if any of their log tables use the ARCHIVE
engine and prompt them to migrate affected tables using the API.