this is sent to me by my hosting company. CPU / Memory workload Statistic 04/02/2012 11.09 0.66 04/03/2012 10.11 0.66 The usage is still high for a shared environment. We are waiting for a response from you regarding the modifications that your database developer have made in your account so that we can verify the usage of your account. --------------------------- how i can modify my database coz they said if modifications to database are done then load can be lowered. i did many things to satisfy the hosting(chanigng to .htaccess, robots.txt, all scripts are to latest versions,) but now they said something which i dont know. please can any one help here. http://www.forexfreeze.com/
Well to be honest if your unhappy with your services you can just move elsewhere, or it may be that your using so much resources that it's best to upgrade to a VPS or something, it's down to several factors
the best you can do is to switch to another hosting , then you can see if there is a problem with your DB, or with the server it self (what is more likely).
Wow those "CPU / Memory workload Statistic " are completely useless. Your host should have atleast sent you some top output so that you can find out which processes exactly are causing the issue.
A good host would actually tell you whats causing the high usage and give you suggestions on how to lower it
you are right josh. but i need to do what does it mean by database optimisation? do you have any idea what it is.
getting rid of unneccsary tables that are in a DB, this can be risky as if you dont know what yoru doin and go deleting any old table then it could lead to the DB becoming corrupted and then your screwed.
They are a good host which is looking for answers, you have told them that you have made the DB changes, so they are wondering where and what the changes are. Just like any other host? Also - the host is asking you to correct an issue with your code, even if you do move hosts your still going to have the same issue. So find the php file which has the largest load time, then look at the code and also check out the error_log if you are getting logs at all.
this is what i received today. Here are the most recent statistics for your account usage: --------------------------------------- CPU / Memory workload Statistic --------------------------------------- Date %CPU %Memory --------------------------------------- 04/02/2012 11.09 0.66 04/03/2012 10.11 0.66 04/04/2012 9.23 0.62 04/05/2012 11.25 1.07 04/06/2012 6.93 0.45 04/07/2012 7.86 0.49 MySQL Usage Statistic --------------------------------------- Date Total Connections CPU Time Bytes Received Bytes Sent --------------------------------------- 04/01/2012 20058 270 102.06 MB 2.10 GB 04/02/2012 19661 265 98.89 MB 2.03 GB 04/03/2012 18632 270 89.37 MB 1.63 GB 04/04/2012 15151 213 73.74 MB 1.43 GB 04/05/2012 15426 209 75.67 MB 1.42 GB 04/06/2012 13042 166 59.17 MB 1.23 GB 04/07/2012 12654 163 61.24 MB 1.18 GB --------------------------------------- Unfortunately the usage is still high for our shared server. Please note that you are hosted on a shared server and you need to share resources with other customers. We will still wait a response from you regarding the last modification that you have made and we will be able to help you further. Please note that you have a large number of Total Connections for the database and also a high CPU Memory usage. We will continue to monitor your account usage for the next 24 hours and we will provide you new stats when available.