WordPress.com

1. rimpyhola
   Member
   May 27, 2006, 12:55 AM

   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

2. timethief
   Member
   May 27, 2006, 3:08 AM

   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.

3. options
   Member
   May 27, 2006, 3:19 AM

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

4. podz
   Member
   May 27, 2006, 10:05 AM

   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 :)]

Topic Closed

This topic has been closed to new replies.