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 _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: 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.
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:
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.
Is There Any Easier Way to Remove all The Junk?
If you would like to clean all transient records and much more with a single click, I suggest you installing Smart Cleanup Tools to your site.
However, you should always consider upgrading your WP site and plugins to the latest available version.
I just managed to save 4.5MB of junk by cleaning wp_options table..
Thanks!!
I am glad it helped!
Where do I access phpMyAdmin…do I need to write my blogs address?
Usually by your web host admin panel like cPanel or DirectAdmin. If you don’t have any clue what I am talking about contact your host guy and I am sure you will find the right way to access your WP database.
This reduced my table size considerably – thank you!
This is good to hear!
Hullo Mr Joe,
Did as you said. Some tables got cleared. Is it right.
Thanks
Reduce the size over 200MB, many thanks
Thanks a lot, from 107 MB to 15 MB is just a SQL query away!
Perfect WP Freak!
Great tweak , manage to remove 200 record , but still have around 240 recoreds like this
_site_transient_timeout_browser_070d07dd169514a18a616d28106c
is it safe to remove them too ??
I am happy it worked for you.
Yes, it’s safe to remove _site_transient_timeout_browser_ entries as well.
Let me know if you need any additional help.
Thanks
also cleared 134 records
still have
_transient_timeout_dash_
_transient_timeout_feed_
_site_transient_timeout
is it safe to remove them ?
in general can I remove all transient ?
It’s totally safe to remove all transient files from database. It won’t do any harm to your WP blog.