WordPress Server Overload on Low Activity Site

  • My site got recently shut down for a server overload, it is a low activity site. I have WP-Cache and everything. I can’t figure out what is causing the MYSQL overload. Here is the MySQL information at the time of the overload, do you guys know what plugin or what is causing this?
    [code]

    Below I paste the mysql activity generated by your site at the moment of the high server load

    | 4 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 51 | closing tables | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHER |
    | 5 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 49 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 6 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 48 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 7 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 7 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 15 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 60 | closing tables | SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_p |
    | 16 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 51 | closing tables | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHER |
    | 17 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 48 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 19 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 20 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 48 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 21 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 50 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 26 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 48 | Opening tables | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 27 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 28 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 50 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 29 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 52 | Opening tables | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHER |
    | 30 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 12 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 54 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Sleep | 1 | | |
    | 55 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Sleep | 1 | | |
    | 56 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 12 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 57 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 12 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 61 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 62 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 63 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 64 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 65 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 66 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 2 | Opening tables | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 67 | dracoy88_iphoto | localhost | dracoy88_renders | Query | 49 | closing tables | SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rat |
    | 68 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 47 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 70 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 47 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 71 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 7 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 72 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 12 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 73 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 2 | Opening tables | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND |
    | 94 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 13 | closing tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 105 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 7 | Opening tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 118 | dracoy88_iphoto | localhost | dracoy88_renders | Query | 31 | closing tables | SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rat |
    | 120 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 3 | Opening tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 121 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 30 | closing tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 124 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 26 | Opening tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 125 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 3 | Opening tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 127 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 3 | Opening tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 128 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 24 | closing tables | UPDATE wp_options SET option_value = 'O:8:\"stdClass\":3:{s:7:\"updates\";a:1:{i:0;O:8:\"stdClass\": |
    | 132 | dracoy88_iphoto | localhost | dracoy88_renders | Query | 2 | Opening tables | DELETE FROM cpg14x_banned WHERE expiry < '2009-01-23 23:23:29' |
    | 138 | dracoy88_iphoto | localhost | dracoy88_renders | Query | 12 | closing tables | SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rat |
    | 152 | dracoy88_yanyan | localhost | dracoy88_yanyanblog | Query | 1 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'siteurl' |[/code]

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

  • You should have a look at your Web site traffic logs (hopefully your ISP provides that feature) to see where your traffic is coming from. Maybe one or two visitors are hammering your site on purpose, or maybe it’s due to an ill-behaved Web spider, of which there are several – and some or most of those can be totally blocked.

    Thread Starter dracoy

    (@dracoy)

    Thanks will do.

    Do you have Simple Tags installed? That plugin has been known to cause many issues involving slowdowns and slow queries.

    Dracoy,

    I am in a similar situation and the sql below is causing my db to be shutdown:

    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND
    wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’)
    ORDER BY wp_posts.post_date DESC LIMIT 0, 10

    were you able to find out which plugin was running this sql?

    Does anyone have a clue?

    I received a similar message:

    WordPress database error: [Got error 127 from table handler]
    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘private’) ORDER BY wp_posts.post_date DESC LIMIT 0, 21

    Turning off my “Bad Behavior” plugin seems to have stopped this; could this be an attack against the anti-spam plugin against those using it?

    Doubtful – my site doesn’t generate a tremendous number of hits daily, and I have both bad behavior and akismet active without any issues.

    This question has been asked many times before, unfortunately without any clear solution other than banging heads with your ISP or moving to a host that doesn’t oversell their servers bandwidth.

    GoDaddy is one of the worst at this, IMO.

    [Got error 127 from table handler]

    Get that fixed first! You might pass that error message along to your host — or try a repair if you have phpMyAdmin or access to something similar.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WordPress Server Overload on Low Activity Site’ is closed to new replies.