I’m facing a serious issue on a WordPress site hosted on Cloudways. There are millions of pending scheduled actions (Action Scheduler jobs), and they are not being processed, which is affecting functionality, especially with WooCommerce and other plugins that rely on scheduled tasks.
What I Need Help With:
How can I safely process millions of pending scheduled actions?
Is there a recommended strategy to batch run these without crashing PHP?
Would WP-CLI's wp action-scheduler run work efficiently on such a large queue?
Any database optimization or maintenance tips to handle this better?
⚠️ Important Notes:
I don’t want to delete these actions — they might be critical (e.g., order emails, hooks, etc.)
I have access to SSH if needed
The site is live, so downtime must be avoided
