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.