How to Keep Your WP Activity Log Plugin Database Storage Down

Learn How to Reduce WP Activity Log Plugin Database Size

Heads up: This page may include affiliate links. Read the full disclosure.

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.

WP Activity Log

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

WP Activity Log - Retention

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

WP Activity Log - Purge

In the advanced settings tab, click on the purge button next to the Purge Activity Log.

WP Activity Log - Purge Confirmation

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

Looking for something?

Privacy laws apply to businesses that collect personal information. Since no personal information is collected by the MainWP plugins, no privacy laws apply to the MainWP plugins. This includes GDPR, UK DPA 2018, PIPEDA, Australia Privacy Act 1988, LGPD, PIPL, and other privacy laws.
Donata Stroink-Skillrud
Donata Stroink-Skillrud
President of Agency Attorneys