/ Plugin Category

/ Site Administration & Utilities

/ Database Management & Cleanup

/ Delete Expired Transients

Delete Expired Transients

By webaware

Site Administration & Utilities / Database Management & Cleanup

Delete Expired Transients Review - In-Depth Analysis

Delete old, expired transients from WordPress wp_options table to optimize database performance.

Performance Overview

WPS Score

6.66/10

User Rating

5/5 (based on 13+ reviews)

Active Installations

5,000+

Update Frequency

Below Average It is calculated using the weighted average of same category plugins.

Security Score

1 / 10 (Very Low Risk) It is calculated using the weighted average of all versions.

What It Does

Delete old, expired transients from the WordPress options table to prevent them from bloating your database and slowing down your website.

WordPress stores transient records in the options table. Many transients have an expiration time, but they often remain in the database after expiration. This plugin schedules a daily task to delete expired transients efficiently.

It performs this operation with a single SQL query and runs a second query to remove orphaned expiration records. This plugin is optimized for fast performance and maximum compatibility.

Now optimized for WordPress Multisite, it does not collect personally identifiable information and helps reduce potential data leakage.

Comparing to Alternatives

Delete Expired Transients is a straightforward plugin focused on cleaning expired transients from your WordPress database. Compared to other plugins, it offers simplicity without extra features.

Top alternatives

Delete Expired Transients

Strengths

Simple and easy to use with minimal configuration
Effectively removes expired transients to optimize database
Lightweight with no unnecessary features

Weaknesses

No advanced options or scheduling features
Lacks integration with caching plugins
No premium version with extended capabilities

User Sentiment Analysis

Users appreciate the plugin's simplicity and effectiveness in managing expired transients.

Positive highlights

"Very useful plugin! Thanks!" - SVTX
"Great plugin, effective, simple and direct, plus great support." - sojasoja
"Just installed and left it to do its magic." - Perrorist
"Still works great, perfect on Multisite." - G
"Easy to use." - ganohr

Common complaints

Weaknesses

Limited features beyond deleting expired transients
No options for customization or scheduling

Who Should Use This?

Best for

Users seeking a no-fuss, lightweight plugin to clean expired transients without additional features.

Not ideal for

Users who want advanced control, scheduling, or integration with caching solutions may find it lacking.

Pricing & Value

Free version includes

The free version efficiently deletes expired transients, providing essential database cleanup without cost.

Final Verdict

Delete Expired Transients excels at its core function of removing expired transients with simplicity and reliability.

While it lacks advanced features and a premium version, it remains a valuable tool for users wanting straightforward database optimization.

Other Notable Features

Here are a few other notable features of this free Delete Expired Transients plugin.

Delete expired transients

Database optimization

WordPress performance

Screenshots

FAQ

According to Codex, transients are:

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

NB: by default they are stored in the database, but if you have an object cache like memcached they won’t be.

Here’s a few useful SQL queries to run in MySQL when you are trying to debug what’s happening with transients.

-- transients that are not autoloaded (should be all with expiration times) select option_name, option_value from wp_options where option_name regexp '^(_site)?_transient_.*' and autoload='no' order by option_name;  -- transient expirations select option_name, option_value, from_unixtime(option_value) as expiry_time from wp_options where option_name regexp '^(_site)?_transient_timeout_.*' order by option_value desc;  -- transient expirations with paired transients (inc. orphans) select t1.option_name, t2.option_name, t1.option_value, from_unixtime(t1.option_value) as expiry_time from wp_options t1 left join wp_options t2 on t2.option_name = replace(t1.option_name, '_timeout', '') where t1.option_name regexp '^(_site)?_transient_timeout_.*' order by t1.option_value desc;  -- expired transient expirations with paired transients (inc. orphans) select t1.option_name, t2.option_name, t1.option_value, from_unixtime(t1.option_value) as expiry_time from wp_options t1 left join wp_options t2 on t2.option_name = replace(t1.option_name, '_timeout', '') where t1.option_name regexp '^(_site)?_transient_timeout_.*' and t1.option_value < unix_timestamp() order by t1.option_value desc;