On a multi-user setup, I noticed that our options table for one specific subsite was corrupted. I was sifting through the forums and found that a plugin could be the culprit.
After looking at the subsite that presented the problem, it didn't have hardly any plugins active aside from our standard network activated items. It's actually one of our most basic sites with a modest amount of traffic.
1) If the options table is corrupting for a specific site, could it still be a global or non-activated plugin for that site even if those same plugins are being run on other subsites without a corruption?
2) What is the best procedure to find the culprit given this problem presents itself over time?
3) What's the best way to proactively monitor the DB? Is there a tool that is preferred to flag potential issues?
Right now things are going smooth, but this particular issue seems to take a few weeks to present itself again, so any advice is appreciated.
As always... thanks in advance.