Optimize your WordPress database by efficiently managing the Action Scheduler tables used by popular plugins like WooCommerce.

Winning Solutions

<p>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.</p>
<p>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.</p>
<p>Key features:</p>
<ul>
<li>Easily clear completed, failed, or canceled actions from the Action Scheduler tables</li>
<li>Set up automatic clearing schedules for efficient database maintenance</li>
<li>Optimize the database tables to reclaim unused space and potentially improve performance</li>
<li>Customize retention periods for logs and actions</li>
<li>User-friendly interface integrated into the WordPress admin area</li>
</ul>
<p>By regularly cleaning up unnecessary data from Action Scheduler tables, you can:</p>
<ul>
<li>Improve database query performance</li>
<li>Reduce database size</li>
<li>Enhance overall site speed and responsiveness</li>
</ul>
<p>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.</p>
<h3>Usage</h3>
<ol>
<li>In the WordPress admin panel, go to Tools > Action Scheduler Cleaner</li>
<li>Select which action statuses you want to clear (completed, failed, canceled)</li>
<li>Set up different automatic clearing schedules if desired</li>
<li>Click “Clear Selected Actions” to manually clear actions – or let the automatic schedule handle it</li>
<li>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</li>
</ol>
<p>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.</p>
<h3>Developer Information</h3>
<p>Cleanup and optimization run in time-bounded chunks: each pass deletes up to <code>batch_size</code> rows per SQL statement and repeats until <code>max_seconds</code> elapses or no matching rows remain. Progress is saved between chunks so large tables can be processed without a single long request.</p>
<p>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 <code>functions.php</code>.</p>
<h4>Manual cleanup (admin UI / AJAX)</h4>
<ul>
<li><code>wsacsc_ajax_cleanup_batch_size</code> (default: <code>10000</code>) — Maximum rows deleted per <code>DELETE</code> statement during manual clear operations initiated from the admin screen. Higher values can speed up very large tables but increase load per query.</li>
<li><code>wsacsc_ajax_cleanup_max_seconds</code> (default: <code>18</code>) — 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.</li>
</ul>
<h4>Scheduled cleanup (WP-Cron)</h4>
<ul>
<li><code>wsacsc_cron_cleanup_batch_size</code> (default: <code>2000</code>) — Same as the AJAX batch size, but for automatic retention cleanup run on a schedule. Defaults are lower than manual cleanup to reduce impact on live traffic.</li>
<li><code>wsacsc_cron_cleanup_max_seconds</code> (default: <code>45</code>) — Seconds of work per cron run before the job pauses and schedules continuation (see below).</li>
</ul>
<h4>Background continuation</h4>
<ul>
<li><code>wsacsc_cleanup_use_background_continuation</code> (default: <code>true</code>) — When a chunk ends before deletion is finished, schedule a single WP-Cron event to resume the job in the background. This is important for scheduled cleanup on large tables and when no admin session is polling progress. Manual cleanup in the browser also continues via AJAX polling; setting this filter to <code>false</code> disables cron-based resumption only (unfinished scheduled jobs may stall unless something else triggers the next chunk).</li>
</ul>
<h4>Scheduled auto-optimize</h4>
<p>After a scheduled retention pass deletes all matching rows for a table, the plugin may run <code>OPTIMIZE TABLE</code> automatically to reclaim disk space. Manual clear from the admin UI never auto-optimizes; use the Optimize button instead.</p>
<ul>
<li><code>wsacsc_scheduled_auto_optimize_max_rows</code> (default: <code>100000</code>) — Run auto-optimize only if the table’s total row count is at or below this value after cleanup. Prevents long, blocking optimize operations on tables that are still huge. Values below <code>1000</code> are raised to <code>1000</code>.</li>
<li><code>wsacsc_scheduled_auto_optimize_delay_seconds</code> (default: <code>5</code>) — Seconds to wait after the last delete batch before running <code>OPTIMIZE TABLE</code>, giving the database a short breather. Clamped between <code>0</code> and <code>60</code>.</li>
</ul>
<p>Example (gentler cron, no background continuation):</p>
<pre><code>add_filter( 'wsacsc_cron_cleanup_batch_size', function () { return 500; } );
add_filter( 'wsacsc_cron_cleanup_max_seconds', function () { return 30; } );
add_filter( 'wsacsc_cleanup_use_background_continuation', '__return_false' );
</code></pre>
<p>Author: Winning Solutions<br />
Author URI: <a href="https://www.winning-solutions.de" rel="nofollow ugc">https://www.winning-solutions.de</a></p>


Alternatives to WS Action Scheduler Cleaner

Top alternatives