Slow Loading Audit Logs

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post Page 1 of 1

Support_Nolan

User avatar
Posts: 8
Joined: Mon May 21, 2018 10:54 am

Post by Support_Nolan » Fri May 31, 2019 5:16 pm
Question:

My audit logs are taking a substantial time to load, why could this be?

Answer:

If you are on a version previous to 5.7.0, we significantly enhanced the performance on the audit log pages by using database specific pagination SQL to handle large tables. This enhancement was applied to the Trigger Logs, Completed Jobs, Job File Audit, AS2, FTP, FTPS, GoFast, HTTPS, and SFTP audit log pages.

Upgrading to version 5.7.0 or higher should enhance your Audit Log loading speed.

If you are on a version higher than 5.7.0:

Check your database statistics to see if you have one or more tables that are extremely large. If you have only one page of your audit logs that are not loading, you may have a table that is getting too large to handle properly. (System -> Database Configuration -> Statistics)
Database_Statistics.png
Database_Statistics.png (11.45 KiB) Viewed 8091 times

To fix this issue, there are two recommendation in which you can adjust your setting to lower the size of your table.
  • Lower the days to keep your Audit Logs. This can be found by going to Logs/Reporting -> Log Settings (Services or Job Logs) and lowering the days to keep logs.
    NOTE: Lowering the retention days by a large number can cause significant overhead on the database. If your database table is in the millions, it is highly recommended to reduce the number of days in small step pattern. (Ex: reduce by 5 days - restart - allow it to purge - reduce another 5 days - restart - etc)
DaysToKeepLogs.PNG
DaysToKeepLogs.PNG (19.19 KiB) Viewed 8091 times
  • Exempt events you may deem unnecessary. For example, you can exempt successful connections for one or more IP Addresses.
IP_Exemption.PNG
IP_Exemption.PNG (18.78 KiB) Viewed 8091 times
Nolan Priebe
Support Analyst
e. [email protected]
p. 1-800-949-4696
w. GoAnywhere.com | HelpSystems.com
1 post Page 1 of 1