dartiss / transient-cleaner Goto Github PK

View Code? Open in Web Editor NEW

5.0 3.0 1.0 1.82 MB

WordPress plugin to clean expired transients from your options table.

Home Page: https://wordpress.org/plugins/artiss-transient-cleaner/

License: GNU General Public License v2.0

PHP 100.00%

wordpress wordpress-plugin transients wordpress-transients

transient-cleaner's Introduction

Transient Cleaner

Remove expired transients from your options table. The original and best!

This plugin is designed only for WordPress 5.8 or below, as transient cleaning is part of core functionality after that point.

"Transients are a simple and standardized way of storing cached data in the WordPress database temporarily by giving it a custom name and a timeframe after which it will expire and be deleted."

Unfortunately, expired transients only get deleted when you attempt to access them. If you don't access the transient then, even though it's expired, WordPress will not remove it. This is a known "issue" but due to reasons, which are explained in the FAQ, this has not been adequately resolved.

Why is this a problem? Transients are often used by plugins to "cache" data (my own plugins included). Because of this it means that expired data can be left and build up, resulting in a bloated database table.

Meantime, this plugin is the hero that you've been waiting for. Simply activate the plugin, sit back and enjoy a much cleaner, smaller options table. It also adds the additional recommendation that after a database upgrade all transients will be cleared down.

I'd like to thank WordPress Developer Andrew Nacin for his early discussion on this. Also, I'd like to acknowledge the useful article at Everybody Staze for ensuring the proposed solution made sense, and W-Shadow.com for the cleaning code.

Iconography is courtesy of the very talented Janki Rathod ♥️

transient-cleaner's People

Contributors

Stargazers

Watchers

Forkers

theperfectwill

transient-cleaner's Issues

Update to core handling

Okay, so bear with me, this is a big one.

Since WP4.9, core has done the housekeeping itself (why the hell didn't anybody tell me?). Here's the code... https://github.com/WordPress/WordPress/blob/e5b8662000b53dfdf734bef83eb2b02facfabb16/wp-includes/option.php#L1028

It hooks into the daily trash collection here: https://github.com/WordPress/WordPress/blob/b8bc65042ab4c57cefc46bbf9eb8d56e00188dee/wp-admin/admin.php#L106. Oh, and it does it on upgrade too. Basically, what my plugin does. Plus it handles some other things better than I do.

So, with this release I want to use what'a already there and add a few extras on from mine. Basically, the ability to run them ad-hoc. To do this, I need to call delete_expired_transients. What I'll loose is the ability to report on when it last ran.

This will also limit the options - the ability to run, plus the ability to optimise afterwards. Also provide the ability to clear all transients too.

Don't run automatic cleaning if using object cache

Scheduler is being set up even if object cache is in use

Add new plugin header

Create a function to return transient stats

A new function will be added that will fetch and return information about transients.

At this point, it will be used to display the data on the settings screen.

Not clearing scheduled event on uninstall

I need to use wp_clear_scheduled_hook in uninstall.php to remove the scheduled event.

Drop maximum WP version to < 4.9 and add admin notice

Transient housekeeping was added in WP 4.9, so this plugin is not longer required after that point.

Fix multisite transient count

When multisite is active, this plugin combines the $wpdb->options count and the $wpdb->sitemeta using string concatenation instead of addition. So 6129 and 42 becomes 612,942 transients. Please change your .= to += on lines 72/73 of options-general.php!

https://wordpress.org/support/topic/multisite-transient-count/

Add a link to the menu bar

Will provide a quick way to the cleaning features.

Menu not appearing after activation

Settings link in meta doesn't work and menu is not appearing under Tools.

May be related to user having a staging site. Could it be that the menu option is pointing to an invalid location?

https://wordpress.org/support/topic/sorry-you-are-not-allowed-to-access-this-page-50/#post-9714268

Modify language used for this plugin

Drop the user of "housekeep" or "housekeeping". Preferred words are maintenance or cleanup.
For the admin message, I refer to disabling the plugin - it should be deactivate

Since this in both website WP CRON stop running: i think the two things are related because server log shows the WP CRON stop running next transient cleaning

I'm not able to restart WP CRON so i've to use ALTERNATE WP CRON

Can you help me?