Ok – so you need to find out where the extra wp_options are coming from. Run this SQL command:

select left(option_name,15) option_name, count( * ) total from wp_options where autoload = ‘yes’ group by left(option_name,15) order by total desc;

To run SQL you can use the SQL Executioner plugin.

Once you’ve run the above, it’ll give you an indication of the source of the wp_options that are set to autoload. Then you know where you can delete them or switch them to autoload = ‘no’.

To delete them, run:

delete from wp_options where autoload = ‘yes’ and option_name like ‘transient%’;

Or you can just switch autoload off by using:

update wp_options set autoload = ‘wpi’ where option_name like ‘transient%’ and autoload = ‘yes’;

Note: You can set the autoload value to anything other than ‘yes’ and they will not be autoloaded, but still be available if a plugin really does need them. You can use ‘no’ but if you use ‘wpi’ or some other value it lets you revert your changes if you need to.

For example, to revert changes back:

update wp_options set autoload = ‘yes’ where autoload = ‘wpi’;

Hope this helps 🙂