Sometimes the wp_options table can get really big and bloated. This could be related to poorly written WP plugins or either tons of _transient entries left in the database. Transient entries are usually created to simply store cached information.
This is solved with such sql:
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');
Or check the number of not needed records with such sql:
SELECT * FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');
Optimize and repair MySQL tables
- Visit PHPMYyAdmin
- Select database tables with overhead
- Choose "Optimize table" or "Repair table"
Delete obsolete WordPress files:
- wp-atom.php
- wp-commentsrss2.php
- wp-feed.php
- wp-pass.php
- wp-rdf.php
- wp-register.php
- wp-rss.php
- wp-rss2.php