cc5 high server resources usage, host accoutn suspended

[Guest dorito]

my host is siteground.com and a month in to upgrading to 5 I have had various email from siteground saying my site is using too much server resources and it would deactiave my site and show an default error page for a while. A week later they suspended my account all together and said I have to purchase dedicated hosting! Ive now switched to hostgator with a normal shared account and have had no problems so far with high server resources usage. Just thought I'd share my experience. Maybe its the host or its too many bugs in the script. This was the original email:

With this notification we would like to inform you that your account XXX consumes a very high percentage of the server resources and thus affects the performance of the whole shared server.

In order to maintain the stability of the server, we had to temporarily limit the shared server resources your account can use. Please note that this may result in occasional "Resource temporary unavailable" error messages shown on your website.

We are very much aware of the inconvenience this issue may cause you, so we would like to take a moment and explain the reasons for our actions: as you know, your account is hosted on a shared hosting server and thus sharing the resources of the server with other customers' accounts. Even though our shared servers are well optimized, the nature of the shared server is such that no matter how powerful or how well optimized the machine is, it is possible that one user and even one application consumes most of the server resources and overloads the machine. Thus all other accounts on the server stop responding and become inaccessible.

In order to prevent server overload, the source of the high load has to be isolated so that it cannot affect the overall server performance. This is a standard procedure used by all shared hosting providers.

We have conducted a detailed investigation of the reasons for the high resource consumption and it turned out that your site executes slow queries towards its database, which eventually hogs the server. The server tries to execute your slow queries while putting other processes in the queue until some memory is freed. While they are waiting however, they stack up and cause further problems.

We believe you are not causing high server load intentionally and we will do our best to assist you so that your site can be fully functional again as soon as possible.

As mentioned before, the problem is caused by slow queries executed towards your application's database. There can be many reasons for slow database queries, but the following 3 are the most common ones:

1. Large database

2. Not well written scripts

3. Large number of internal links that query the database directly.

Here are some of the database queries that are slow and consume a lot of server resources:

Slow queries were found:

Executed 0 min ago for 8 sec on Database --> XXX_cube5.

SELECT * FROM `CubeCart_inventory` WHERE `status` = '1' ORDER BY RAND() LIMIT 20

Executed 0 min ago for 7 sec on Database --> XXX_cube5.

SELECT `name`, `product_id`, `quantity` FROM `CubeCart_inventory` WHERE `status` = '1' ORDER BY popularity DESC LIMIT 10

Executed 0 min ago for 8 sec on Database --> XXX_cube5.

SELECT `name`, `product_id`, `quantity` FROM `CubeCart_inventory` WHERE `status` = '1' ORDER BY popularity DESC LIMIT 10

Executed 0 min ago for 3 sec on Database --> XXX_cube5.

INSERT INTO `CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`) VALUES ('0','0','184.154.231.3','','gvb3893rke3dedrbjljmr1hjb5','1321310004','1321310004','Lynx/2.8.5rel.1 libwww-FM/2.14 SSL-MM/1.4.1 OpenSSL/0.9.8e-fips-rhel5

Executed 0 min ago for 2 sec on Database --> XXX_cube5.

SHOW COLUMNS FROM CubeCart_sessions

Executed 0 min ago for 2 sec on Database --> XXX_cube5.

SELECT * FROM `CubeCart_inventory` WHERE `status` = '1' ORDER BY RAND() LIMIT 20

From the queries above we can conclude that your issue is caused by not well written scripts. In order to have the limitations removed, you should optimize your script so that it consumes less server resources.

Having not well written scripts is a quite complex problem. It may be caused by an additionally installed extension/module that is not working properly, or it may be in the application itself.

If the reason is in an extension/module, the easiest solution would be to disable/remove it. This can usually be done from the application's admin area.

If the problem is in the application itself, solving it may take much more time and effort and will probably require advanced programming skills. In such cases it would be best to contact the application's developers and ask for further assistance. They should be able to examine the issue and offer a suitable solution for it.

There are some general things you can do to optimize your site (such as enable cache). More information on how to optimize your site can be found in our Website Performance Tutorial (http://www.siteground.com/tutorials/websiteperformance/index.htm).

If optimizing the application is not a suitable option for you, we can offer you one of our dedicated solutions (http://www.siteground.com/dedicated_solutions.htm) as an alternative. There all of the system's resources will be dedicated to your account and using a more resource-demanding application will not be a problem.

SiteGround is experienced in providing dedicated hosting solutions and we are happy to inform you that as an existing and loyal SiteGround customer, we will offer you a beneficial upgrade package including:

-No set up fees

-Free website content transfer from the shared server to the dedicated machine

-No website downtime during the upgrade

The upgrade process is simple and straightforward and you can order your dedicated solution upgrade immediately. To do that, please log in your SiteGround User Area -> Order section-> Upgrade to Dedicated Solution option.

If the problem with your application is not resolved in 7 days, we will be forced to take further actions in order to ensure the stability of the shared server.

Thank you in advance for your understanding and cooperation!

[Robsta]

Some cheap shared hosting accounts are not sufficient for e-commerce systems. They are designed to be overloaded and allocate only a small amount of resources to each customer, that is the problem. You get what you pay for.

There are lots of hosting companies out there who have no problems running v5 in a shared environment.

[Guest jgislermn]

Hi,

We have been having VERY slow loading as well. We do not have shared hosting, we have a dedicated server. Many customers have complained about how slow things run, and this is becoming a big problem.

I do the 'maintenance' 2 times every day and that seems to help a little bit, but only for a few hours.

Any ideas on a fix?

Thanks,

Jen

[Guest ebatule]

We have a dedicated server as well and are having the same problem.