How to Keep Your WP Activity Log Plugin Database Storage Down

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;
wp_wsal_metadata
wp_wsal_occurrences
wp_wsal_sessions

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.

Useful Links

• https://melapress.com/support/kb/wp-activity-log-plugin-database-documentation/
• https://melapress.com/support/kb/wp-activity-log-deleted-plugin-uninstall-option/
• https://melapress.com/support/kb/wp-activity-log-retention-policies/
• https://melapress.com/support/kb/wp-activity-log-slow-down-website/
• https://wordpress.org/support/article/phpmyadmin/