How to purge wordpress option table

Sometimes the options table can get really big when it comes to WordPress. This could be related to poorly written WP plugins or either tons of

1
_transient

entries left in the database, for what I blame WordPress. Transient entries are usually created to simply store cached information. In many cases this is completely fine, but they could also be abused by hackers who can insert injections to your WP site and in this case size of options table can get really huge and your blog may start performing slow.

If you don’t know if this particular issues is related to your site, I recommend you typing the following URL in your browser’s address bar:

1
yourwpblog.com/wp-admin/options.php

. Please make sure you are logged in as an admin user.

If you see many entries like those shown below you must know this is complete junk and you can safely get ride of it.

Screenshot

How to Remove Unnecessarily _transient Entries?

1. Login to phpMyAdmin.
2. Navigate to database of your WP blog and click on SQL tab, appearing on the top.
3. Run the following qeury:

 

1
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');

4. Transient entries are now removed and the size of your wp_options table should be now reduced.

Leave a Reply