Database is disabled due to server overloading

  • Unknown's avatar
    imankur0708 · Member ·

    I have some wordpress in my site. Now my host has disabled my databases and giving the reason that database is generating queries which is doing overloading on server.

    He sent us some of the queries results like

    3115 | travel_refer | localhost | travel_refer | Sleep | 19 | |
    |
    | 3124 | travel_refer | localhost | travel_refer | Sleep | 19 | |
    |
    | 3136 | travel_refer | localhost | travel_refer | Sleep | 19 | |
    |
    | 3163 | travel_refer | localhost | travel_refer | Sleep | 17 | |
    |
    | 3202 | travel_refer | localhost | travel_refer | Sleep | 13 | |
    |
    | 3207 | travel_america | localhost | travel_america | Query | 3 | Sorting result | SELECT DATE_ADD(post_date_gmt, INTERVAL ‘-18000
    ‘ SECOND) FROM north_posts WHERE post_date_gmt <= ’20 |
    | 3235 | travel_refer | localhost | travel_refer | Sleep | 11 | |
    |
    | 3244 | travel_america | localhost | travel_america | Query | 3 | Sorting result | SELECT DATE_ADD(post_date_gmt, INTERVAL ‘-18000
    ‘ SECOND) FROM north_posts WHERE post_date_gmt <= ’20 |
    | 3271 | travel_refer | localhost | travel_refer | Sleep | 9 | |
    |
    | 3278 | travel_america | localhost | travel_america | Query | 9 | removing tmp table | SELECT ID, post_title, post_content FROM north_
    posts WHERE post_status = ‘publish’ AND post_password |
    | 3283 | travel_refer | localhost | travel_refer | Sleep | 9 | |
    |
    | 3288 | travel_america | localhost | travel_america | Query | 8 | Sorting result | SELECT ID, post_title, post_content FROM north_
    posts WHERE post_status = ‘publish’ AND post_password |
    | 3292 | travel_america | localhost | travel_america | Query | 2 | Sorting result | SELECT post_date_gmt FROM north_posts WHERE pos
    t_date_gmt <= ‘2006-05-20 05:09:38’ AND post_status = |
    root@matrix [~]# efer | localhost | travel_refer | Sleep | 7 | |

    The databases are still on the server. They are disabled due to the amount of server load they were generating from the queries above.

    I am unaware of the fact that what to do with this problem. They have disable the database and saying that till the time we dont rectify this query generation problem our database would be down..

    Please help me ASAP

    Thanks

  • Unknown's avatar
    timethief · Member ·

    Are you sure you are on the correct forum (wordpress.com)? Could it be that you ought to be on the wordpress.org forum? I ask because this does not sound (on the surface) like a common wordpress.com question.

  • Unknown's avatar
    options · Member ·

    you’d better ask help off to wordpress.org/support.

    perhaps, this is some cache related issues or your site receives a huge traffic and therefore needs a ‘beefy dedicated physical server’ (2GB RAM may be a good starting point).

  • Unknown's avatar
    podz · Member ·

    As timethief has said, go here: http://wordpress.org/support
    Over there:
    – detail your host
    – get the hosts machine specs if possible and post them.
    – what plugins you are using
    – what other help they have given (if any at all)
    – if you are allowed to run your site with no plugins activated

    [name edited – drmike. Sorry, I’m not a blond :)]

  • The topic ‘Database is disabled due to server overloading’ is closed to new replies.