WordPress Database Issues – Site unresponsive

  • Hi,

    I’m having an issue with one of my merchandise sites running Woocommerce. I began receiving “Internal Server 500” errors and the site would go down intermittently. After working with my host GoDaddy they eventually came back and said it was a an issue with long running SQL queries. The query the GoDaddy sent me that seemed to be causing the problem is

    [Tue Mar 31 21:51:25 2015] Query killed – i610261_wp1 : SELECT OPTION_NAME, OPTION_VALUE FROM WP_OPTIONS WHERE AUTOLOAD = ‘YES’

    The WP_Options table has around 300000 rows and is sitting at 220Mib. I’m pretty new to Databases so is this rather large or ok?

    The problem i have now is that the site is down longer and longer (I can’t access it at all for most of today). I started recreating the site & database as the backups i had are corrupt and wont let me restore. I also dont want to restore to the original backup as I will loose a heap of products. I need to somehow repair the original site so i can do a cart2cart migration so we don’t loose all the products already uploaded.

    Anyone have an idea where to start?

    Thanks in advance

Viewing 2 replies - 1 through 2 (of 2 total)

  • The WP_Options table has around 300000 rows and is sitting at 220Mib. I’m pretty new to Databases so is this rather large or ok?

    those are too much, what you have in there? you need to clear those up.
    are you sure 200 mb is wp_options table only?

    there can be some lame tables created by various plugins like statpress etc which can take space fast in db. please reconfirm if this is the case by loggin into phpmyadmin.

    Thread Starter mkcwebdev

    (@mkcwebdev)

    The whole DB is 260MiB and the wp_options table is 234MiB of it.

    I’ve tried disabling most of the plugins but it is still having the same issue.

    How do i go about finding which process is causing the problem?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress Database Issues – Site unresponsive’ is closed to new replies.