xoxoxo

Registered
Mar 13, 2010
2
0
51
Hi

I was informed by my webhost that my account is suspended..But I am not really convinced by his statements since he has emailed me on a sunday when my traffic is less than half of normal day traffic..Please let me know how I should proceed. Here is the complete transcript of his message

Sir,
your wordpress usage has outgrown and is the prime cause of crashing mysql server every single day.
please know this much usage cannot be handled by shared hosting as there's a limit of 20% CPU resource usage on
our shared plans.

your mysql queries are just not fit to get handled by any shared plan,you should move this account to a
VPS hosting atleast if not a dedicated server.
your mysql process list is attached below which shows 75 active requests which is beyond resources which can be allocated to
a shared account.

5
9 hostaccount_wrdp1 localhost hostaccount_wrdp1 Query 714 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
17 hostaccount_wrdp1 localhost hostaccount_wrdp1 Query 704 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
1825 hostaccount_wrdp4 localhost hostaccount_wrdp4 Query 690 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
26 hostaccount_fanboi localhost hostaccount_dbname Query 689 Opening tables SELECT * FROM tbl_config
43 hostaccount_wrdp1 localhost hostaccount_wrdp1 Query 672 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
47 hostaccount_wrdp1 localhost hostaccount_wrdp1 Query 667 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
62 hostaccount_wrdp4 localhost hostaccount_wrdp4 Query 651 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
65 hostaccount_wrdp1 localhost hostaccount_wrdp1 Query 648 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
76 hostaccount_wrdp1 localhost hostaccount_wrdp1 Query 638 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
83 hostaccount_wrdp1 localhost hostaccount_wrdp1 Query 635 Opening tables SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
91 hostaccount_wrdp1 localhost NULL Init DB 624 NULL NULL
94 hostaccount_wrdp1 localhost NULL Init DB 623 NULL NULL
100 hostaccount_wrdp4 localhost NULL Init DB 614 NULL NULL
109 hostaccount_wrdp1 localhost NULL Init DB 601 NULL NULL
114 hostaccount_wrdp1 localhost NULL Init DB 591 NULL NULL
116 hostaccount_wrdp1 localhost NULL Init DB 589 NULL NULL
118 hostaccount_wrdp1 localhost NULL Init DB 587 NULL NULL
122 hostaccount_wrdp4 localhost NULL Init DB 577 NULL NULL
125 hostaccount_wrdp4 localhost NULL Init DB 576 NULL NULL
133 hostaccount_wrdp4 localhost NULL Init DB 555 NULL NULL
137 hostaccount_wrdp1 localhost NULL Init DB 552 NULL NULL
142 hostaccount_wrdp4 localhost NULL Init DB 548 NULL NULL
147 hostaccount_wrdp1 localhost NULL Init DB 541 NULL NULL
148 hostaccount_wrdp1 localhost NULL Init DB 541 NULL NULL
152 hostaccount_wrdp1 localhost NULL Init DB 535 NULL NULL
154 hostaccount_wrdp1 localhost NULL Init DB 534 NULL NULL
157 hostaccount_wrdp1 localhost NULL Init DB 533 NULL NULL
161 hostaccount_wrdp4 localhost NULL Init DB 524 NULL NULL
163 hostaccount_wrdp1 localhost NULL Init DB 520 NULL NULL
169 hostaccount_wrdp4 localhost NULL Init DB 512 NULL NULL
171 hostaccount_wrdp1 localhost NULL Init DB 510 NULL NULL
174 hostaccount_wrdp1 localhost NULL Init DB 506 NULL NULL
176 hostaccount_wrdp4 localhost NULL Init DB 503 NULL NULL
183 hostaccount_wrdp1 localhost NULL Init DB 499 NULL NULL
188 hostaccount_wrdp4 localhost NULL Init DB 497 NULL NULL
207 hostaccount_wrdp1 localhost NULL Init DB 480 NULL NULL
210 hostaccount_wrdp1 localhost NULL Init DB 478 NULL NULL
211 hostaccount_wrdp1 localhost NULL Init DB 476 NULL NULL
238 hostaccount_wrdp1 localhost NULL Init DB 438 NULL NULL
239 hostaccount_wrdp4 localhost NULL Init DB 437 NULL NULL
256 hostaccount_wrdp4 localhost NULL Init DB 401 NULL NULL
270 hostaccount_wrdp1 localhost NULL Init DB 155 NULL NULL
271 hostaccount_wrdp1 localhost NULL Init DB 155 NULL NULL
272 hostaccount_wrdp1 localhost NULL Init DB 154 NULL NULL
280 hostaccount_wrdp1 localhost NULL Init DB 147 NULL NULL
281 hostaccount_wrdp1 localhost NULL Init DB 147 NULL NULL
282 hostaccount_wrdp1 localhost NULL Init DB 147 NULL NULL
283 hostaccount_wrdp4 localhost NULL Init DB 147 NULL NULL
286 hostaccount_fanboi localhost NULL Init DB 145 NULL NULL
289 hostaccount_wrdp1 localhost NULL Init DB 142 NULL NULL
294 hostaccount_wrdp4 localhost NULL Init DB 138 NULL NULL
298 hostaccount_wrdp1 localhost NULL Init DB 134 NULL NULL
300 hostaccount_wrdp1 localhost NULL Init DB 132 NULL NULL
312 hostaccount_wrdp1 localhost NULL Init DB 117 NULL NULL
313 hostaccount_fanboi localhost NULL Init DB 115 NULL NULL
316 hostaccount_wrdp1 localhost NULL Init DB 113 NULL NULL
317 hostaccount_wrdp1 localhost NULL Init DB 111 NULL NULL
318 hostaccount_wrdp1 localhost NULL Init DB 110 NULL NULL
319 hostaccount_wrdp1 localhost NULL Init DB 110 NULL NULL
320 hostaccount_wrdp1 localhost NULL Init DB 109 NULL NULL
322 hostaccount_wrdp1 localhost NULL Init DB 107 NULL NULL
323 hostaccount_wrdp1 localhost NULL Init DB 106 NULL NULL
326 hostaccount_wrdp1 localhost NULL Init DB 104 NULL NULL
338 hostaccount_wrdp1 localhost NULL Init DB 92 NULL NULL
352 hostaccount_wrdp1 localhost NULL Init DB 78 NULL NULL
363 hostaccount_fanboi localhost NULL Init DB 66 NULL NULL
364 hostaccount_wrdp1 localhost NULL Init DB 63 NULL NULL
366 hostaccount_wrdp4 localhost NULL Init DB 61 NULL NULL
375 hostaccount_wrdp4 localhost NULL Init DB 48 NULL NULL
380 hostaccount_wrdp1 localhost NULL Init DB 41 NULL NULL
381 hostaccount_wrdp1 localhost NULL Init DB 38 NULL NULL
396 hostaccount_wrdp1 localhost NULL Init DB 19 NULL NULL
401 hostaccount_wrdp1 localhost NULL Init DB 12 NULL NULL
411 hostaccount_wrdp1 localhost NULL Init DB 2 NULL NULL
Thanks
 

Spiral

BANNED
Jun 24, 2005
2,018
8
193
This would be a matter between you and your web hosting provider and Cpanel support forums is not the place for this kind of issue.

With that said though, a few comments to help you out ....

Wordpress is well known for eating resources and other issues that I am not going to get into right now but suffice to say your software could be more of an issue than anything else

Now regarding what you said about "75" connections and the log information, that is not a "physical" or "technical" limit but rather a limit that your hosting provider has decided to impose and there may or may not be justifiable reason there. I would not be able to say without knowing the specifications of their servers including hardware and number of sites they host on those servers.

You might just want to find a new host and I could make a few recommendations as to who to go with and who not to go with if you want to contact me privately.

Hope that helps you out