Hostgator shutdown my site (Server overload)

[z72diego]

Hello, i need urgent help.

Today, my site stopped working and I received this email from hostgator:

 

Hello,

 

I apologize, but I was forced to suspend the script /home/XXXXX/public_html as it was causing a high load on the server, and due to it affecting all of the other accounts on the system, I was forced to take immediate action for the health of the server.

 

Unfortunately I do not have any specific recommendations for this script, however, in general, adding some sort of caching mechanism, where the script does not need to generate a new page with every request, helps to lower the over load that a script will cause. Likely the original author or support group of the software that you are using will be able to help you to understand how to add something of this nature.

 

If you reply back to this with your IP address (http://www.hostgator.com/ip.shtml) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.

 

XXXXX 31091 74.0 0.3 390444 32496 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/category.php

XXXXX 30740 67.0 0.3 390440 31952 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/category.php

XXXXX 30561 58.0 0.3 388904 30924 ? RN 15:00 0:00 \_ /usr/bin/php /home/XXXXX/public_html/category.php

XXXXX 30907 40.0 0.3 389648 31456 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/category.php

XXXXX 31250 33.0 0.3 388672 30356 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/category.php

XXXXX 30299 26.3 0.3 390700 32516 ? RN 15:00 0:00 \_ /usr/bin/php /home/XXXXX/public_html/category.php

XXXXX 30359 20.0 0.3 385832 27796 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/search.php

XXXXX 30391 20.0 0.3 385832 27796 ? RN 15:00 0:00 \_ /usr/bin/php /home/XXXXX/public_html/search.php

XXXXX 31259 14.0 0.3 384552 26416 ? RN 15:00 0:00 \_ /usr/bin/php /home/XXXXX/public_html/search.php

XXXXX 30363 12.0 0.3 383244 24804 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/search.php

XXXXX 30437 12.0 0.2 382100 23780 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/search.php

XXXXX 31270 11.0 0.2 285268 23592 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/search.php

XXXXX 30446 10.0 0.2 283472 21648 ? RN 15:00 0:00 | \_ /usr/bin/php /home/XXXXX/public_html/search.php

 

MySQL queries:

 

18511765 XXXXX_XXX localhost XXXXX_prestashop Query 0 statistics SELECT *, ( IF ('2013-03-18 17:00:42' >= `from` AND '2013-03-18 17:00:42' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 44, 4, 0) + IF (`id_currency` = 4, 8, 0) + IF (`id_shop` = 1, 16, 0)) AS `score`\n\t\t\t\tFROM `ps_specific_price`\n\t\t\t\tWHERE `id_product` IN (0, 176)\n\t\t\t\tAND `id_shop` IN (0, 1)\n\t\t\t\tAND `id_currency` IN (0, 4)\n\t\t\t\tAND `id_country` IN (0, 44)\n\t\t\t\tAND `id_group` IN (0, 1)\n\t\t\t\tAND `from_quantity` <= 1\n\t\t\t\tAND\n\t\t\t\t(\n\t\t\t\t\t(`from` = '0000-00-00 00:00:00' OR '2013-03-18 17:00:42' >= `from`)\n\t\t\t\t\tAND\n\t\t\t\t\t(`to` = '0000-00-00 00:00:00' OR '2013-03-18 17:00:42' <= `to`)\n\t\t\t\t)\n\t\t\t\tORDER BY `from_quantity` DESC, `score` DESC LIMIT 1 0 0 1

18511785 XXXXX_XXX localhost XXXXX_prestashop Query 0 Sending data SELECT DISTINCT p.id_product, pl.name pname, cl.name cname,\n\t\t\t\tcl.link_rewrite crewrite, pl.link_rewrite prewrite ,(\n\t\t\t\tSELECT SUM(weight)\n\t\t\t\tFROM ps_search_word sw\n\t\t\t\tLEFT JOIN ps_search_index si ON sw.id_word = si.id_word\n\t\t\t\tWHERE sw.id_lang = 6\n\t\t\t\tAND si.id_product = p.id_product\n\t\t\t\tAND (sw.word LIKE 'funda%' OR sw.word LIKE 'asient

 

Please, I'm desperate. I use PrestaShop 1.4.8.2, I have enabled the cache, Force Compile is disabled, the CCC is enabled and I use Blowfish instead of mcript.

 

Thanks.

[Trip]

Hmm, try to disable datamining for statitics eg. disable all statistic modules. Regenerate search words or disable it temporarely. Upgrade your hosting package. Upgrade you shop to 1.4.10 if possible. Enable debug profiling and developement mode to see if there are possible bugs or slow modules. Thats what I would try.

Good luck, trip

[GoGoMo]

I second the server upgrade for hosting your online shop not with hostgator though. Many people have complained regarding hostgator shutting down their sites on shared servers. Disable any modules you're not using for your site.

[z72diego]

Hi, thanks for your prompt replies.

 

I just off the statistics modules and if the problem persists, I'll just have to change hosting.

 

Do you recommend me to upgrade to version 1.5.3.1?

[Dh42]

It looks like it is your blocks category module. Do you add new categories often to your site?

[vkpdaxdv]

Disable any modules you're not using for your site.

[z72diego]

Hello, no, but you can say that the site has many categories (around 500), but so far had not caused problems.

 

Just deactivate many statistics modules, amongst others.

 

Thank you very much for your answers, I will continue testing configurations to achieve the best possible performance.

 

Thank you all again.

[Dh42]

What categories module are you using, that is more than likely the problem.

[z72diego]

Im using the blockcategories v2.0 that comes by default with prestashop.

I figured that's the problem because of the amount of error lines. But I do not know what may be the problem. (perhaps the number of categories created)

 

Thanks.

[Dh42]

the block categories is your problem. If you don't change categories a lot, rewrite it in plain html and all should be golden.