You can archive some of the alerts from the main WordPress security audit trail database to a secondary one to keep the main audit trail database small, manageable and fast. Once the alerts are archived in the archiving database they can still be viewed, searched through and be included in the reports as explained in this post.
How to Archive Alerts from the WordPress Audit Log
- Install and activate the premium External DB add-on.
- Once installed, navigate to the Archiving tab in the External DB node in the plugin’s menu.
- Configure how many alerts you want to archive. You can configure to archive alerts which are older than a specific time, or simply specify the number of how many alerts you would like to keep in the main database, as shown in the below screenshot.
- Configure the database connection details and the frequency of the archiving process.
- Click Save Changes to save the changes and start archiving alerts.
Use the Stop Archiving toggle switch to temporarily stop the archiving of alerts, in case your website or web server are experiencing performance issues. You can also use the Execute Archiving Now button to trigger the archiving of alerts.
Viewing the Audit Trail in the Archiving Database
Once you enable archiving and alerts from the WordPress security audit trail are archived, a drop down menu will be available in the Audit Log Viewer that allows you to select which database to view, as shown in the below screenshot.
Note that both the Reports Add-on and Search Add-on fully support the archiving database. Therefore when creating a report, or searching for specific activity, if there are alerts in the archiving database that match the criteria you will be alerted about it and can select to view such alerts as well, or include them in the reports.
Refer to the External DB Add-On getting started guide for more information on the add-on and its other features.