Jump to content

VPS server overloaded/hanged, just 80 products - need help


Recommended Posts

I was running my eCommerce shop from last 2 years on host gator basic hosting and there was no issue at all, I had 80 products and have to generate product combinations, generating products combination took much resources and host gator warn us about it, so decided to move on VPS hosting.

Purchased bluehost VPS hosting with 2.4 Ghz process, 2gb ram, 30 gb had drive,

but after upgrading,  my server is going overloaded from last couple of weeks and website is very slow.

 

it normally consumed 16gb or ram and 30-40 times more load compare to what resources has assigned to me, so blue host has given me warning..

 

I tried to sortout the issue, but unable to solve it.

I monitored the mysql and got few sessions are hanging up, which is overloading server.

 

Can anyhone help in it, ready to pay for resolving this matter.

 

 

Share this post


Link to post
Share on other sites

I assume you are using the exact same website on the new hosting, correct? If so, there must be something misconfigured on the server side, it can't be Prestashop

  • Like 1

Share this post


Link to post
Share on other sites

from the information provided it can be hard to give a proper response. 

I've often seen loading issues caused by malicious code injections, however in your case someone needs to take some time to profile the application especially that you have a VPS and it's possible directly on your hosting account.

 

As nemo asked, it's the exactly set up, nothing changed, no theme added, no plugin installed?

  • Like 1

Share this post


Link to post
Share on other sites

Thank you for your prompt response, website has been changed, like I have installed new theme, few addons and modules are installed. you may visit it..

 

scottishkiltshop.com

 

I have tried every thing upto my knowledge but unable to resolve this issue, had many hours of conversation with tier 3 technical support of blue host, but they are unable to help.

 

Sitelock is installed and all files are cleaned, nothing bad is injected in database..

 

my cpanel is showing database size about 404 bytes...

 

when I reboot my server, it stay cool for some time and start consuming resourcing after few hours it goes upto max.

 

one more thing, I have installed comm 100 chat support software on website, and it shows random 40-50 or 100 + immediate users on it, believe some one is spoofing.. 

Share this post


Link to post
Share on other sites

When I moved website from host gator to bluehost, it's size was 26mb but now when I download back up of my database, it size is just 404 bytes.. but all products are listed on website so how database could be so small.

what's going wrong.. :-(

Edited by bsource (see edit history)

Share this post


Link to post
Share on other sites

I received following error some time on website

 

Link to database cannot be established: SQLSTATE[42000] [1203] User scottiv1_user already has more than 'max_user_connections' active connections

Share this post


Link to post
Share on other sites

you said that you're on VPS, so  suppose that you've got possibility to configure own server.

increase limit for max user connections

 

in your mysql configuration file should be line similar to:

 

#max_connections        = 100
 
remove hash and define own max connections value. i think that 100 will be enough :-)

Share this post


Link to post
Share on other sites

I believe there is some lime but its enough, as concurrent sql session goes upto 150+,

right at the movement there are only 2 users on the website, and its consuming about 1GB ram and 6Ghz processor.

Share this post


Link to post
Share on other sites

Here are sql quereis hanging up in process list

 

 

4 | scottiv1_user | localhost | scottish_shop | Query | 114 | Sending data | SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m. |

 

| 4 | scottiv1_user | localhost | scottish_shop | Query | 291 | Sending data | SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m. | | 28 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 51 | scottiv1_user | localhost | scottish_shop | Query | 108 | Sending data | SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m. |

  • Thanks 1

Share this post


Link to post
Share on other sites

if the server works properly after a reboot and gets progressively worse, then you have a memory leak or inproperly configured mysql database.  Sounds like you just need some plan of tuning of the VPS server.

 

This is something bluehost should be doing for you, as the hosting provider

  • Like 1

Share this post


Link to post
Share on other sites

Here are sql quereis hanging up in process list

 

 

4 | scottiv1_user | localhost | scottish_shop | Query | 114 | Sending data | SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m. |

 

| 4 | scottiv1_user | localhost | scottish_shop | Query | 291 | Sending data | SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m. | | 28 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 51 | scottiv1_user | localhost | scottish_shop | Query | 108 | Sending data | SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight` , m. |

 

Hi Chugtai, can you confirm that this issue has been solved via your later thread here, http://www.prestashop.com/forums/topic/294884-solved-prestashop-1561-googlebot-crawl-slow-blocklayered/page-2?do=findComment&comment=1488956

 

This thread was solved and it is similar to the problem you are describing now. Thank you for the clarification. 

Share this post


Link to post
Share on other sites
  • 5 months later...
  • 6 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More