Website too slow and too many connections

[shinotaku1412]

Hi!

 

My shop is going too slow both in the front-end and in the back-end. I have configurated the performance to use cache, to never recompile template files, do not open console, use CCC and minify and compress files, ...

 

And when I try to enter in the front-end, I sometimes get an error saying that there ara too many connections.

 

The shop's URL is: http://www.kuriososbaby.com/tienda

 

How can I fixed that?

[NemoPS]

What are the specs of your hosting?

[shinotaku1412]

What are the specs of your hosting?

 

HDD: 1 GB (76% used)

RAM: 2GB

Bandwidth: 100 Mb

PHP: 5.4

Prestashop 1.5

 

If you need some other data, ask me please

[NemoPS]

With a 100mb bandwidth only, it's no surprise you run out of resources. I think you need more of it, as well as hdd space

[shinotaku1412]

I think the bandwith is not the problem. I have other prestashop webs on the same server and they work fine.

 

I try in other server with 2GB of bandwith and try it in a local server and I've got the same issues.

Edited April 18, 2016 by shinotaku1412 (see edit history)

[tuk66]

Consider to use CDN because of many images, but the problem is with server overloading, to my mind. The page is created so slowly so it can be a bottleneck in processor or database.

[shinotaku1412]

Consider to use CDN because of many images, but the problem is with server overloading, to my mind. The page is created so slowly so it can be a bottleneck in processor or database.

What can I do to improve the speed of the page creation?

[tuk66]

Enable profiling in /config/defines.inc.php

define('_PS_DEBUG_PROFILING_', true);

or try another hosting right away.

[shinotaku1412]

Enable profiling in /config/defines.inc.php

define('_PS_DEBUG_PROFILING_', true);

or try another hosting right away.

I try to enable the profiling and the website works as slow as before. The current server is the 3rd one I try, and I don't know what else I can do to solve it.

[tuk66]

Do you see something suspiciously slowing the shop in the profiling report?

[shinotaku1412]

Do you see something suspiciously slowing the shop in the profiling report?

Y have enabled the profiling, but the web loads the same way and I don't get any report. Do I need to enable anything else in order to be able to get the report?

[shinotaku1412]

I've got 900 products on my shop. When I deleted it and left only 50 products, the website works perfect. Can the problem be the number of products?

[tuk66]

This would indicate a database-module issue.

[shinotaku1412]

This would indicate a database-module issue.

And what can I do to improve the website speed?

[tuk66]

Firstly, you must find the problem.

[shinotaku1412]

Firstly, you must find the problem.

I know. When I say what can I do to fixed it, how to find the problem was implicit in the question

[tuk66]

I really don't know. I have no usable information.

[shinotaku1412]

I really don't know. I have no usable information.

Ok. Thanks for the info anyway

[ezcb]

Bonjour,

peut etre une solution ici

https://www.prestashop.com/forums/topic/469753-pb-sqlstate08004-1040-too-many-connections/?do=findComment&comment=2450116

[catalin.scaesteanu]

I know. When I say what can I do to fixed it, how to find the problem was implicit in the question

 

Hi,

 

To find the problem you can try to disable non-prestashop modules and see if page load is affected.

 

In Prestashop v1.6 there is an option at "Advanced Parameters" > Performance called "Disable non PrestaShop modules", I think there should be something similar for prestashop v1.5 too.

 

After that you should enable third party modules one by one and check which is affecting page load.

 

If none of that works then you should consider a new hosting with better specs and newer version of PHP (5.4 is old and slow).

 

Hope this helps.