WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Server Overload on Low Activity Site (8 posts)

  1. Dracoy
    Member
    Posted 5 years ago #

    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]

  2. Mark
    Member
    Posted 5 years ago #

    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.

  3. Dracoy
    Member
    Posted 5 years ago #

    Thanks will do.

  4. Delete Me
    Member
    Posted 5 years ago #

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

  5. spatel6549
    Member
    Posted 5 years ago #

    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?

  6. ThinkingSkull
    Member
    Posted 5 years ago #

    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?

  7. Saurus
    Member
    Posted 5 years ago #

    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.

  8. Chris_K
    Member
    Posted 5 years ago #

    [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.

Topic Closed

This topic has been closed to new replies.

About this Topic