Best Web Hosting

Database Cleaner Plugin That Removes Expired Transients | WP Learning Lab - Best Webhosting

Thanks! Share it with your friends!

URL

You disliked this video. Thanks for the feedback!

Sorry, only registred users can create playlists.
ULTRAFAST, CHEAP, SCALABLE AND RELIABLE! WE STRONGLY RECOMMEND ACCU WEB HOSTING COMPANY
Database Cleaner Plugin That Removes Expired Transients | WP Learning Lab

Watch Wordpress WPLearningLab Video: Database Cleaner Plugin That Removes Expired Transients | WP Learning Lab.
Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL
Database Cleaner Plugin That Removes Expired Transients | WP Learning Lab

Download your exclusive 10-Point WP Security Checklist: http://bit.ly/10point-wordpress-hardening-checklist

An easy database cleaner process is to remove expired and non-expired transients from your WordPress database. This database cleanup process involves a plugin that deletes bits of information that are temporarily stored in your database.

Sometimes, a plugin developer will code the expiration incorrectly and the transients never expire. This can lead to a bloated and slow database.

The transients accumulate in the wp_options table. The view the size of the table you have to access your phpMyAdmin through your hosting account cPanel.

Then you open the database for your site and you will see a high level table called wp_options. To the far right it shows the size of the table.

Make note of the size and compare it to the size of the table after you clear any expired transients the plugin finds.

Next, let's install the plugin.

To install this plugin please log into your WordPress dashboard, hover over Plugins and then click on Add New.

On the next page type "delete expired transients" into the search bar. The plugin we want should be the first one in the top left.

Click on the Install Now button and then click Activate after it's installed.

Once activated, a new menu item is added under the Tools menu called Delete Transients. Click on that menu item.

Now you'll see the simple, single page of the plugin.

This page shows how many expired transients there are on your site and how many transients in total.

Transients that aren't expired are generally needed by one of your plugins to work properly. After a certain amount of time those transients expire and can be deleted.

Improperly coded plugins don't have that expiration associated with the transients, so the transients never expire and just pile up in your database.

Below the numbers of transients, you can choose what to delete.

The safest is to delete expired transients, if there are any. Since they're expired they're no longer in use.

You also have the option of deleting all transients, which you should do with caution. There is a chance it will affect your site's functionality until the plugin needing those transients creates them again.

However, on one of my sites, I have a plugin, I don't know which one yet, that keeps creating transients without expiring them. So my database keeps growing in size. So, in my case I'm comfortable deleting all the transients because that improves my site's function.

After you've chosen the right option for you click on the Delete button.

Now you can go back to your phpMyAdmin and refresh the page to see if there is a change in the size of the wp_options table. For me, the change in size is always substantial.

Subscribe to this awesome channel here: http://www.youtube.com/subscription_center?add_user=wplearninglab

Published:
Category: Wordpress WPLearningLab
80 Views

Related Videos

  • Learning the Basics of Buying Expired Domains | GoDaddy Hangout

    Learning the Basics of Buying Expired Domains | GoDaddy Hangout

    by Best Webhosting Added 93 Views / 0 Likes

    Heather Dopson and Joe Styler of GoDaddy will chat about the basics of buying Expired Domains on GoDaddy's auctions, the timeline of when and how to bid, and why bidding on expired domains with us makes good business sense.

  • Change DB Prefix WordPress Plugin - Secure Your WordPress MySQL Database | WP Learning Lab

    Change DB Prefix WordPress Plugin - Secure Your WordPress MySQL Database | WP Learning Lab

    by Best Webhosting Added 89 Views / 0 Likes

    Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Change DB Prefix WordPress Plugin - Secure Your WordPress MySQL Database | WP Learning Lab In this tutorial I'm going to show you how to use the Change DB Prefix WordPress plugin to improve MySQL database security. Anyone running a WordPress-based website needs to con

  • How to fix "Error establishing a database connection" | WP Learning Lab

    How to fix "Error establishing a database connection" | WP Learning Lab

    by Best Webhosting Added 80 Views / 0 Likes

    Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Grab your free 10-Point WP Security Checklist: http://bit.ly/10point-wordpress-hardening-checklist Error establishing database connection is a very common error that I bet every WordPress user has encountered at some point. Luckily the fix is very easy and there are two ways to fix it. Nearly every time this error is caused by incorrect or incomplete database information in

  • Edit wp-config.php To Add WordPress Database Credentials | WP Learning Lab

    Edit wp-config.php To Add WordPress Database Credentials | WP Learning Lab

    by Best Webhosting Added 100 Views / 0 Likes

    Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Edit wp-config.php To Add WordPress Database Credentials | WP Learning Lab In another video (here: https://youtu.be/wtG1IJ1Wbvs) I showed you how to create a MySQL database for your WordPress site. In this video I'm going to show you how to edit wp-config.php file to include the database credentials. Although many people will be intimidated by i

  • Popular Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab

    Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab

    by Best Webhosting Added 110 Views / 0 Likes

    Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Create a MySQL Database for your WordPress Site via cPanel | WP Learning Lab Although this video specific to WordPress users, it is also a great MySQL beginners tutorial. You won't actually go into phpMyAdmin or interact with the database directly so there's no danger of breaking very much. The first thing you need we'll do in this MySQL tutoria

  • How To Manually Backup WordPress MySQL Database, Files and Folders | WP Learning Lab

    How To Manually Backup WordPress MySQL Database, Files and Folders | WP Learning Lab

    by Best Webhosting Added 76 Views / 0 Likes

    How To Manually Backup WordPress MySQL Database, Files and Folders https://youtu.be/cfLFO7kiS2Y The other half of this tutorial, how to manually restore from a backup: https://www.youtube.com/watch?v=7RazMUnBFnQ&list=PLlgSvQqMfii4qdGkBEavOHwqRqEzhhk5d In this WordPress tutorial, I'm going to show you how to manually backup WordPress MySQL database, files and folders. Being able to backup your website is important because you will want to do this befor

  • Limit WordPress Revisions In wp-config - Revision Control Speeds Up Database | WP Learning Lab

    Limit WordPress Revisions In wp-config - Revision Control Speeds Up Database | WP Learning Lab

    by Best Webhosting Added 80 Views / 0 Likes

    Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Limit WordPress Revsions In wp-config - Revision Control Speeds Up Database | WP Learning Lab define( 'WP_POST_REVISIONS', X ); In this tutorial you will learn about the WordPress revision control system (also known as WordPress version control). This system keeps Wor

  • Manually Restore WordPress Site From Backup (Database, Files & Folders) | WP Learning Lab

    Manually Restore WordPress Site From Backup (Database, Files & Folders) | WP Learning Lab

    by Best Webhosting Added 82 Views / 0 Likes

    Manually Restore WordPress Site From Backup (Database, Files & Folders) https://youtu.be/7RazMUnBFnQ Exclusive for WPLearningLab viewers, up to 50% off hosting: https://wplearninglab.com/wordpress-hosting-offer/ Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist In this tutorial I'm going to show you how to manually restore your WordPress site from a backup. We will restore the database, files a

  • WordPress Salts, Unique Keys & Database Prefix - WP Hack Prevention & Security | WP Learning Lab

    WordPress Salts, Unique Keys & Database Prefix - WP Hack Prevention & Security | WP Learning Lab

    by Best Webhosting Added 96 Views / 0 Likes

    Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist WordPress Salts, Unique Keys & Database Prefix - WP Hack Prevention & Security | WP Learning Lab In this tutorial I show you how to add WordPress unique keys and salts to your WP-Config.php file and how to change the WordPress database prefix. Both of these are import

  • Popular Disable WordPress Core, Theme & Plugin Updates Using A Plugin | WP Learning Lab

    Disable WordPress Core, Theme & Plugin Updates Using A Plugin | WP Learning Lab

    by Best Webhosting Added 119 Views / 0 Likes

    Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist Disable WordPress Core, Theme & Plugin Updates Using A Plugin | WP Learning Lab In this tutorial you will discover how to use the Easy Updates Manager plugin and how to use it to disable WordPress updates, disable WordPress automatic updates for specific plugins, and

  • Media Cleaner Wordpress - These Can Be Awesome Or Trouble

    Media Cleaner Wordpress - These Can Be Awesome Or Trouble

    by Best Webhosting Added 78 Views / 0 Likes

    Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: http://vid.io/xqRL Media Cleaner Wordpress - These Can Be Awesome Or Trouble https://youtu.be/LjQ-ohMVyFA #wordpress #medialibrary #optimization Join our private Facebook group today! https://www.facebook.com/groups/wplearninglab In this tutorial I show you how to use a media cleaner WordPress. But using it can be dangerous because it may recommend deleting images that are still in use on you

  • WordPress. How To Disable Plugin(s) Via Database Or By Manual Removal

    WordPress. How To Disable Plugin(s) Via Database Or By Manual Removal

    by Best Webhosting Added 89 Views / 0 Likes

    Our Support team is ready to present a new tutorial that will show you how to disable WordPress plugins via database or by manual removal. Choose your WordPress template now: http://www.templatemonster.com/wordpress-themes.php?utm_source=youtube&utm_medium=link&utm_campaign=wptuts125 Want to Build WordPress Site in 5 Hours? Subscribe to this course: http://www.templatemonster.com/website-5-days.php?utm_source=youtube&utm_medium=link&utm_campaign=wptut

RECOMMENDED WEB HOSTING

FASTCOMET

Fastcomet

HOSTGATOR

HOSTGATOR

BLUEHOST

BLUEHOST

SITEGROUND

SITEGROUND

A2 HOSTING

A2 HOSTING

HOSTINGER

HOSTINGER

DREAMHOST

DREAMHOST

ACCU WEBHOSTING

ACCU WEBHOSTING

MILESWEB

MILESWEB

HOSTPAPA

HOSTPAPA
RSS