I'm having an ongoing battle with my wp_options table which keeps hanging my website.
I don't get any error message - it just times out. I can access all static pages, but nothing through wordpress that needs the database.
The only thing that brings it back is a repair or optimize of the wp_options table. However, if I run a check on the table before repairing, it comes back reporting as OK.
I've tried disabling plugins and asked around on the theme's forum and my host support (which is pretty good to be honest), but no joy.
If I don't spot that the site is down, it will often clear itself up within a few hours, but all that downtime is not good!
Does anyone have any bright ideas, or suggestions how I can troubleshoot this?