WS Action Scheduler Cleaner

WS Action Scheduler Cleaner is a small tool designed to optimize your WordPress database by managing the Action Scheduler tables. Action Scheduler, a robust job queue and background processing library, is utilized by many popular plugins such as WooCommerce, WP Forms, and Jetpack to handle resource-intensive tasks asynchronously.

While Action Scheduler is crucial for the smooth operation of these plugins, its tables can grow significantly over time, potentially impacting your site’s performance. This is where WS Action Scheduler Cleaner comes in.

Key features:

• Easily clear completed, failed, or canceled actions from the Action Scheduler tables
• Set up automatic clearing schedules for efficient database maintenance
• Optimize the database tables to reclaim unused space and potentially improve performance
• Customize retention periods for logs and actions
• User-friendly interface integrated into the WordPress admin area

By regularly cleaning up unnecessary data from Action Scheduler tables, you can:

• Improve database query performance
• Reduce database size
• Enhance overall site speed and responsiveness

WS Action Scheduler Cleaner is an essential tool for any WordPress site using plugins that rely on Action Scheduler, especially high-traffic e-commerce sites or membership platforms that generate a large number of scheduled actions.

Usage

1. In the WordPress admin panel, go to Tools > Action Scheduler Cleaner
2. Select which action statuses you want to clear (completed, failed, canceled)
3. Set up different automatic clearing schedules if desired
4. Click “Clear Selected Actions” to manually clear actions – or let the automatic schedule handle it
5. Optionally optimize the DB tables as well; this is your solution for when the size of the tables doesn’t seem to go down on simple clearing

For best results, we recommend setting up an automatic clearing schedule to maintain optimal database performance. Something like 7 days is usually sufficient. By default, Action Scheduler does this every 30 days, but only for completed and canceled actions, whereas you can control this aspect in the plugin. On deactivation of the plugin, the 30-day retention period as well as which actions get cleared will reset to their defaults.

Developer Information

Cleanup and optimization run in time-bounded chunks: each pass deletes up to batch_size rows per SQL statement and repeats until max_seconds elapses or no matching rows remain. Progress is saved between chunks so large tables can be processed without a single long request.

The following filters (since 1.3.0) let you tune behavior for your hosting environment. Add them in a custom plugin or your theme’s functions.php.

Manual cleanup (admin UI / AJAX)

• wsacsc_ajax_cleanup_batch_size (default: 10000) — Maximum rows deleted per DELETE statement during manual clear operations initiated from the admin screen. Higher values can speed up very large tables but increase load per query.
• wsacsc_ajax_cleanup_max_seconds (default: 18) — Seconds of work per AJAX request before the plugin saves progress and returns. The admin UI polls for the next chunk while you keep the page open. Increase on slow hosts if chunks finish too quickly; decrease if requests time out.

Scheduled cleanup (WP-Cron)

Read the full description on the official page →