Optimise Action Scheduler

Action Scheduler is the background job system used by WooCommerce, WooCommerce Subscriptions and a lot of import plugins. It’s genuinely useful, but by default it holds on to its completed, failed and cancelled actions in its own tables for a long time. On a busy store those tables just keep growing. It’s not unusual to find millions of rows in there, and once they get that big they slow down not just Action Scheduler itself but the whole site, because those tables are queried constantly.

The Optimize Action Scheduler option shortens the retention period so old actions are cleaned up sooner rather than lingering for months. Instead of letting completed and failed actions pile up indefinitely, they get cleared out on a shorter schedule, which keeps the tables at a sensible size and keeps the queries against them fast.

If your tables have already grown out of control, there are buttons on the same screen to deal with the backlog directly. You can empty the Action Scheduler tables and you can clear its logs, so you don’t have to wait for the shorter retention period to work through the existing pile.

You’ll find all of this in the Imports tab under "Optimize Action Scheduler".

In short: Action Scheduler keeps old actions around far longer than most stores need, and on busy sites those tables grow into the millions of rows and slow everything down. This option shortens the retention period so old actions are cleaned up sooner, with buttons to empty the tables and clear the logs when you need to clear a backlog straight away.