After Upgrading API Gateway from 10.0 to 10.1 CR 2
It takes 18 minutes to start up
Release : 10.1
SSG Logs show the auto archiver where the time is spent. This may have been a one time run after the upgrade that took the time (before and after 8 minutes each).
NOTE: There are over 8 Million records in audit main table are these records required to keep of off box them
2022-12-09T11:06:29.454-0500 INFO 1901 com.l7tech.server.service.ServiceCache: Created/Updated/Deleted: [c6b320f0ca043527d40d48eb6ea16954]
2022-12-09T11:15:29.290-0500 INFO 72 com.l7tech.server.audit.AuditArchiver: Starting Audit Archiver check.
2022-12-09T11:15:29.324-0500 INFO 72 com.l7tech.server.audit.AuditArchiver: Below start_archive threshold, not starting archiver thread.
2022-12-09T11:22:04.003-0500 SEVERE 1 com.networknt.schema.JsonSchemaFactory: Failed to load json schema!
java.io.FileNotFoundException: http://example.com/example.json
Clear out audit data
If records are not need suggest access mysql and clean up audit tables
Mysql 8 run the query to cleanup and analyze tables
# mysql
mysql>
SET FOREIGN_KEY_CHECKS = 0;
truncate table audit_admin;
truncate table audit_detail;
truncate table audit_detail_params;
truncate table audit_main;
truncate table audit_message;
truncate table audit_system;
SET FOREIGN_KEY_CHECKS = 1;
analyze table audit_admin;
analyze table audit_detail;
analyze table audit_detail_params;
analyze table audit_main;
analyze table audit_message;
analyze table audit_system;