If you are using the WP Activity Log plugin on your WordPress website for tracking site activity and changes, then it is worth keeping an eye on the site’s database tables that the plugin uses.
The WP Activity Log plugin uses the following custom database tables for storage;
If you are already using the WP-Optimize plugin, then you can quickly check the size of the WP Activity Log from wp-admin;
WP-Optimize > Database > Tables
Then go search for wsal and the tables will show in the WP-Optimize UI.
Many hosts provide phpMyAdmin, which can easily be used to check the database tables used by the WP Activity Log plugin.
WP Activity Log allows you to set the activity log retention. Navigate to:
WP Activity Log > Settings > Activity Log Viewer
If you notice that your
wp_wsal_metadata database table was over 10GB in size; then, you can purge all of the logs from the WP Activity Log settings in wp-admin.
WP Activity Log > Settings > Advanced Settings
In the advanced settings tab, click on the purge button next to the Purge Activity Log.
Setting up the WP Activity Log retention and keeping an eye on the plugin’s custom database tables will help you to make better decisions to remove any extra bloat.