How to Delete all Transients in your Sites Database

WordPress uses transients for storing cached short-term data in a sites database within the options database table. Depending on the set of plugins you are using in your plugin stack those plugins can end up bloating your options database table and those transients might not expire correctly.

You can check to see how many transients are being stored in your options database table by using phpMyAdmin and then searching for the following option name from the options database table;

_transient_%

This will return all of the options that are transients which will give you an idea of the number of transients currently being stored on your site database.

You could also delete all existing transients using the following MySQL query in phpMyAdmin;

DELETE FROM wp_options WHERE option_name LIKE ('%\_transient\_%')

Plugins such as WP-Optimize, WP Rocket, and WPS Cleaner will allow you to easily delete all existing transients in your site’s database all from wp-admin.

To delete all of the existing transients using the WP-Optimize plugin go to the admin menu;

Manage all your WordPress sites with the MainWP Dashboard

WordPress Management for Professionals

Are you ready to go Pro?

All MainWP Pro Extensions are available through one of our convenient bundled packages.

WP-Optimize > Database

Then scroll down to the section which shows remove expired transients and then select remove all transients and then click on the run the optimization button.

If you are using the WP Rocket plugin on your site then go to the following admin menu item;

Settings > WP Rocket > Database

Select all expired transients and all transients are selected to be deleted in the settings and then click on the Save changes and optimize button.

If you are using the WPS Cleaner plugin after you have installed and activated the plugin go to the admin menu item it adds;

Tools > WPS Cleaner > Options

Then click on the clear transient options button which will then clear all of the existing transients.

If your site has high levels of transients being stored in the site’s options database table you will notice performance issues when you are using wp-admin on the site and it can cause performance issues on the front-end of the site.

Looking for something?

Your Download Is Just One Click Away

…or just download the plugin.

By entering your email, you agree to our Terms of Service and Privacy Policy.