Hi .. I need advise to choose a good hosting provider. My site http://articlefulltime.com/ is disabled for high CPU usage (I have no ideas what caused high CPU usage), as this is only the articles directory (about 100K over posts). SQL database is 1.1 GB (but my package is 10 GBs) Please help me.
It's really hard to say because we don't know why your site is causing a lot of CPU usage. I always run sites on at least a VPS that I setup and manage so I can easily look to see what might be causing problems if they come up. Can you ask your host if they know what script is/was causing the CPU usage? That might give you a clue if there is some tuning you can do to mitigate it (though in a shared environment, most of the effective tuning settings like MySQL are out of your control).
Yes ,please choose VPS rather than shared hosting . In XEN VPS ,your will get full resources as guaranteed .
Probably since your site contain so many pages and big database, so BOTs creates high Apache activity. So due to high Apache Process any mySQL activity your provider face high CPU usage issue on their node. Make sure they are not overselling their node.
First you may need to check with your current provider for the main cause meanwhile you may need at least a SEMI-D or VPS to handle your needs since it is about CPU usage.
Shared hosting will only fit your needs to a point, if you go with a VPS then either OpenVZ or Xen will be your best bet. Do you have a budget for an upgrade to a VPS? as it will be much more than shared hosting. Some hosting companies have application hosting which can provide dedicated CPU power. Might be worth looking into!
I'm guessing it's all the MySQL stuff that is causing the high CPU load. A 1GB database is not small by any means. In fact, it's a pretty large database, which would leave me to believe that your site is pretty heavy as far as PHP/SQL is concerned. As others have mentioned, a VPS or even dedicated solution is going to be the answer to fixing this problem. There is a good chance your site is beyond the useful limits of shared hosting. Choosing a new shared provider is not going to fix the problem.
Well, if it is your MySQL database, you could always buy a small vps and host your database on that server. So you can host your main files on the shared host, and pay a few bux to host your database on a seperate machine.
agreed you should look out for at least a VPS or a dedicated and I suggest you also check if you can reduce size of the database by deleting not used tables and contents. BUT keep in mind if you are not used to running servers on your own it's a good ideae to get some kind of managed service in order to keep your website online
I think depend on your size of DB 1.1GB is very big for shared hosting. Every query for your website should be consume very much CPU due to big size of DB.
I think you should look at some hosts that have CloudLinux implemented in their Shared Hosting Platform
It is almost certain that your MySQL DB is causing the load that your host is concerned with. You would probably have better luck setting up your own VPS where you will have dedicated resources.
If you are on a shared account and using all the resources you really should strongly consider a VPS. It will be a big improvement all around.
I am 100% sure I can understand how you felt which I created a thread at my own DP thread here. I found the solution to my need. As many members said, VPS is what you need now. In the other way round, I shall congratulate you to move into VPS hosting if you were. This because you are better in building a great site with you current skill. It is about time to grow for you..... Keep up the great work!