WordPress.org

Ari Stathopoulos

Adam Zieliński

Bero

Brandon Payton

zaerl

Jan Jakeš

<p>The SQLite plugin is a community, feature plugin. The intent is to allow testing an SQLite integration with WordPress and gather feedback, with the goal of eventually landing it in WordPress core.</p>
<p>This feature plugin includes code from the PHPMyAdmin project (specifically parts of the PHPMyAdmin/sql-parser library), licensed under the GPL v2 or later. More info on the PHPMyAdmin/sql-parser library can be found on <a href="https://github.com/phpmyadmin/sql-parser" rel="nofollow ugc">GitHub</a>.</p>


SQLite Database Integration



Installed version 2.0



Activated



Message: "All checks completed successfully, your site can use an SQLite database. You can proceed with the installation."



Screen with text and button. Ok, I can go back by just deactivating this plugin! Great!



Clicked button "Install SQLite database"



"PDO Driver for SQLite is missing" alone on an blank page, wheverer I go



Stuck. My somewhat "well crafted" and sophisticated testing site gone away, it seemed. 




Why could this plugin not check the availability of this driver before presenting a clickable button, or even proceeding?



Since I'm knowledgable enough to delete the ´wp-content/db.php´ file I was soon back to start, so I don't need help.



Others, if less knowledable in WP, should be warned and stay away until proper tests can be made before proceeding. On screen instructions on how to manually disable it in an emergency should also be given.


Possibly worst UX trap I have ever seen


I used it to spin up a test site in CI, it's just elegant and brings WP closer to Static when we need it. There's a place for SQLite simplicity in some WP workflows. Loved it!


Excellent!


Thank you dev team for providing this plugin !


Great Plugin! Makes WP so fast!


Ok, so in terms of doing what it says in the tin, for me it looks great. I've set up 20 - 30 instances, it runs my core plugins and has a footprint of ~ 105M when running with a default setup. Seems to be at least as fast as the MySQL instances sat next to them.



Here's the problem tho'. It would seem I can't actually convert any existing sites over to run on these instances without a lot of manual work. (I say this after reading the experiences of some others who claim to have tried).



Are there any relatively automatic tools and/or documentation that I might have missed when it comes to migrating a MySQL instance over to SqLite (and back, in the event of a problem), or at least a Roadmap of if / when such tools or plugins might become available?



A roadmap or estimation might at least (if it's a long way away) prompt someone to get on and do it?


Great, seems only one step away ...

SQLite integration plugin by the WordPress Team.

Ayuda WordPress

Fernando Tellado

<p><strong>Easy Actions Scheduler Cleaner</strong> helps you clean up your Actions Scheduler database tables. Over time, these tables can accumulate thousands or even millions of records from completed, failed, canceled, and past-due actions that are no longer needed, as well as extensive logs that can take up significant database space.</p>
<p>This plugin provides two cleanup modes plus email notifications:</p>
<h4>Manual cleanup</h4>
<p>Run a one-time cleanup that removes all unnecessary records at once:</p>
<ul>
<li><strong>Delete completed actions</strong> – Actions that have already been executed successfully</li>
<li><strong>Delete failed actions</strong> – Actions that encountered errors during execution</li>
<li><strong>Delete canceled actions</strong> – Actions that were manually canceled</li>
<li><strong>Delete past-due actions</strong> – Actions that missed their scheduled execution time</li>
<li><strong>Delete old pending actions</strong> – Pending actions older than 30 days</li>
<li><strong>Delete action logs</strong> – Historical log records that accumulate over time</li>
</ul>
<h4>Scheduled cleanup</h4>
<p>Configure automatic cleanup to run on a schedule with smart thresholds:</p>
<ul>
<li><strong>Flexible frequency</strong> – Daily, weekly, biweekly, or monthly</li>
<li><strong>Per-type configuration</strong> – Enable/disable cleanup for each action type independently</li>
<li><strong>Threshold system</strong> – Only clean when records exceed your configured minimum (e.g., clean completed actions only when there are more than 100)</li>
<li><strong>Configurable pending age</strong> – Set custom age for old pending actions (7 to 365 days)</li>
<li><strong>Last run reporting</strong> – See results from the last scheduled cleanup</li>
<li><strong>Background processing (NEW in 1.3)</strong> – The scheduled cleanup now runs as a self-rescheduling Action Scheduler job, so it never times out on large sites with millions of records</li>
</ul>
<h4>Email notifications</h4>
<p>Stay informed about your database status with configurable email notifications:</p>
<ul>
<li><strong>Periodic reports</strong> – Receive daily, weekly, or monthly reports with database status, cleanup results, and estimated space savings</li>
<li><strong>Accumulation alerts</strong> – Get notified when records pile up without an active scheduled cleanup</li>
<li><strong>Missed cleanup alerts</strong> – Detect when WP-Cron fails to execute a scheduled cleanup</li>
<li><strong>Separate recipient lists</strong> – Configure different email addresses for management reports and technical alerts</li>
<li><strong>HTML formatted emails</strong> – Clean, readable email reports</li>
<li><strong>Test emails</strong> – Send test report or alert emails directly from the settings page to verify delivery</li>
</ul>
<h4>Key features</h4>
<ul>
<li><strong>Two cleanup modes</strong> – Manual one-time cleanup or scheduled automatic cleanup</li>
<li><strong>Smart thresholds</strong> – Scheduled cleanup only runs when record counts justify it</li>
<li><strong>Database space estimation</strong> – See how much space your Action Scheduler tables are using</li>
<li><strong>Email notifications</strong> – Periodic reports, accumulation alerts, and missed cleanup warnings</li>
<li><strong>Batch processing</strong> – Handles large datasets efficiently (10,000 records per batch)</li>
<li><strong>Detailed reporting</strong> – Shows exactly how many records were deleted by type and estimated space freed</li>
<li><strong>Orphaned data cleanup</strong> – Also removes related orphaned groups</li>
<li><strong>Complete logs cleanup</strong> – Removes all action logs that accumulate over time</li>
<li><strong>WooCommerce integration</strong> – Seamlessly works with WooCommerce’s Action Scheduler</li>
</ul>
<h4>Why use this plugin?</h4>
<p>The Actions Scheduler tool used by WooCommerce and many other WordPress plugins can accumulate millions of database records over time, which can:</p>
<ul>
<li>Slow down your website performance</li>
<li>Increase database size unnecessarily</li>
<li>Make database backups larger and slower</li>
<li>Impact Actions Scheduler’s own performance</li>
</ul>
<p>The action logs table (<code>actionscheduler_logs</code>) is particularly problematic as it records detailed information about every action execution and can grow exponentially on busy sites.</p>
<h4>Works with Action Scheduler 4.0 and WooCommerce 11.0</h4>
<p>Action Scheduler 4.0 (bundled with WooCommerce 11.0) now removes failed actions automatically after three months, on top of the completed-action cleanup it already did. This plugin still does more, and on your terms: it cleans on demand and immediately, and it also clears past-due actions, old pending actions, every action log, and orphaned groups that Action Scheduler leaves behind.</p>
<h4>Important notes</h4>
<ul>
<li><strong>Cleanup is irreversible</strong> – Always backup your database before use</li>
<li><strong>Scheduled cleanup respects thresholds</strong> – Only cleans when record counts exceed your minimums</li>
<li><strong>You choose the mode</strong> – Use manual for one-time cleanup or scheduled for ongoing maintenance</li>
</ul>
<h4>Perfect for</h4>
<ul>
<li>E-commerce sites with large Action Scheduler tables</li>
<li>Sites with millions of action log records</li>
<li>Database maintenance and optimization</li>
<li>Before major WooCommerce updates</li>
<li>Preparing for site migrations</li>
<li>Regular automated maintenance</li>
</ul>
<h3>Privacy Policy</h3>
<p>This plugin does not collect, store, or transmit any user data externally. Email notifications are sent using WordPress’s built-in wp_mail() function through your server’s mail configuration. All data processing happens locally on your server.</p>
<h3>Technical Details</h3>
<h4>Minimum requirements</h4>
<ul>
<li>WordPress 5.0 or higher</li>
<li>WooCommerce 3.0 or higher (optional)</li>
<li>PHP 7.4 or higher</li>
<li>MySQL 5.6 or MariaDB 10.1</li>
</ul>
<h4>Database tables affected</h4>
<ul>
<li><code>wp_actionscheduler_actions</code> – Main actions table</li>
<li><code>wp_actionscheduler_groups</code> – Groups table (orphaned records only)</li>
<li><code>wp_actionscheduler_logs</code> – Logs table (all records)</li>
</ul>
<h4>Batch processing</h4>
<p>The plugin processes deletions in batches of 10,000 records to prevent timeouts and reduce server load during cleanup operations.</p>
<h4>WP-Cron</h4>
<p>Scheduled cleanup and email notifications rely on WP-Cron. If your site uses an external cron job (DISABLE_WP_CRON), make sure your system cron is properly configured to trigger WP-Cron. The missed cleanup alert can help detect WP-Cron issues.</p>
<h4>For developers</h4>
<p>The plugin exposes three filters for fine-tuning the cleanup behavior. Add them to a mu-plugin or your theme’s functions.php:</p>
<pre><code>easc_large_site_threshold (default: 500000)
</code></pre>
<p>Number of total records (actions + logs) that triggers the “consider enabling scheduled cleanup” admin notice.</p>
<pre><code>easc_batch_size (default: 10000, context: 'scheduled')
</code></pre>
<p>Rows deleted per DELETE LIMIT query. Lower if your database struggles, raise if you have headroom. Currently applies to the scheduled cleanup only.</p>
<pre><code>easc_cleanup_step_time_budget (default: 25)
</code></pre>
<p>Seconds each background step is allowed to run before rescheduling itself. Should be lower than your hosting’s PHP max_execution_time.</p>
<p>Example:</p>
<pre><code>add_filter( 'easc_large_site_threshold', fn() => 100000 );<h3>Support</h3>
</code></pre>
<h4>Need private support or custom development?</h4>
<p>Do you need one-on-one help, priority troubleshooting, or a custom feature, integration, or tweak built specifically for your site? I offer private support and custom development. Just <a href="mailto:easy-actions-scheduler-cleaner-ayudawp@ayudawp.com" rel="nofollow ugc">contact me</a> and tell me what you need.</p>
<h4>Need help or have suggestions?</h4>
<ul>
<li><a href="https://servicios.ayudawp.com/" rel="nofollow ugc">Official website</a></li>
<li><a href="https://wordpress.org/support/plugin/easy-actions-scheduler-cleaner-ayudawp/" rel="ugc">WordPress support forum</a></li>
<li><a href="https://www.youtube.com/AyudaWordPressES" rel="nofollow ugc">YouTube channel</a></li>
<li><a href="https://ayudawp.com/" rel="nofollow ugc">Documentation and tutorials</a></li>
</ul>
<p><strong>Love the plugin?</strong> Please leave us a 5-star review and help spread the word!</p>
<h3>About AyudaWP</h3>
<p>We are specialists in WordPress security, SEO, and performance optimization plugins. We create tools that solve real problems for WordPress site owners while maintaining the highest coding standards and accessibility requirements.</p>


Easy Actions Scheduler Cleaner


In the scheduled actions, there were tens of thousands of actions, of which only 17 were Pending.



With a single click, it removed everything unnecessary, making the database size drop significantly.



An absolute lifesaver.


A must-have plugin

Clean up your Actions Scheduler database with manual or scheduled cleanup. Remove old actions and logs automatically.

SQLite Database Integration vs Easy Actions Scheduler Cleaner