WP Options Table Corrupting...

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.

Questions:

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.

  • Tyler Postle

    Hey again Max,

    Good to hear from you again :slight_smile:

    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?

    It could be a globally active one, but it wouldn't normally only affect 1 site that way. Did you run a repair on the table? You can do that in phpmyadmin.

    2) What is the best procedure to find the culprit given this problem presents itself over time?

    Normally as you mentioned, it's often plugin conflicts, so deactivating all plugins can help and then repairing the database. Themes can be a potential issue too.

    3) What's the best way to proactively monitor the DB? Is there a tool that is preferred to flag potential issues?

    I find adminer is a very handy plugin when it comes to the DB. Not sure how it is for monitoring for errors, but it's very convenient when going in and checking out tables/managing the database. Essentially gives you phpmyadmin access right from your WordPress dashboard and automatically shows the tables associated with that site.

    Is there anything particular different about the site that is always affected? A theme you only use on that site maybe?

    Hope this helps Max! Look forward to hearing back.

    All the best,
    Tyler

  • Tyler Postle

    Hey Maxwebgear,

    Hope your weekend is going well today! Just wanting to add in some additional info here that a colleague informed me on :slight_smile:

    A more common cause of table becoming corrupt is if a query dies halfway through - this can be caused by plugins that make huge queries. Any plugins come to mind that you might have on your site doing heavy queries to the database?

    It would also be a good idea to ask your host about it too, then you can rule out hardware issues.

    Here's some additional resources for monitoring and maintenance that you might be interested in too :slight_smile:

    Monitoring: http://www.nagios.com/solutions/mysql-monitoring

    Maintenance: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

    Hope this helps!

    Let us know if it happens again.

    Have a great weekend :slight_smile:

    All the best,
    Tyler

    PS. This has some more info as well: http://dev.mysql.com/doc/refman/5.1/en/corrupted-myisam-tables.html

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.