Post by LEDStrobeCity » Fri Sep 08, 2017 7:24 am

I have 3 web sites on my hosting account and they have been working just fine for years and now I installed opencart into two separate folders on my server (One is my live site and one is a test site) and I have started the past few days to notice when I try to visit ANY of my websites (not just the opencart sites) that they will take a VERY long time to load (5 minutes) or they won't load at all. If I wait about an hour and try again they will load fine but after I click on a few links it starts to slow down and finally not load at all. What could be causing this?
When I go to the error log inside opencart I find a list of errors but it is the same 2 errors repeated over and over. They are:
2017-08-31 14:53:46 - PHP Warning: mysqli::mysqli(): (08004/1040): Too many connections in /home1/public_html/system/library/db/mysqli.php on line 7
2017-08-31 14:53:46 - PHP Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home1/public_html/system/library/db/mysqli.php on line 10

Newbie

Posts

Joined
Fri Sep 08, 2017 7:14 am

Post by MrPhil » Fri Sep 08, 2017 7:46 am

What version of OpenCart? If it's not 3.0.x, report this thread and ask that it be moved to the appropriate section.

User avatar
Active Member

Posts

Joined
Wed May 10, 2017 11:52 pm

Post by LEDStrobeCity » Fri Sep 08, 2017 8:44 am

Version 3.0.2.0

Newbie

Posts

Joined
Fri Sep 08, 2017 7:14 am

Post by grgr » Fri Sep 08, 2017 10:20 pm

You might want to upgrade your web hosting to something a little better.

Image Image Image Image Image Image


User avatar
Active Member

Posts

Joined
Mon Mar 28, 2011 4:08 pm

Post by LEDStrobeCity » Sun Sep 10, 2017 7:15 am

Could this issue be happening due to me having 4 websites running on the same shared hosting account? I did just have 2 websites and they ran perfectly fine but when I added the 2 opencart sites (1 live site and 1 test site) this is when I started having the problems. If I deleted the other 2 sites off my account would that fix the issue or is this something much deeper?

Newbie

Posts

Joined
Fri Sep 08, 2017 7:14 am

Post by MrPhil » Sun Sep 10, 2017 9:51 pm

If you're getting messages about "too many connections", see if there is a configuration setting in your stores to restrict them to a single DB connection at a time. It might be named "pconnect" or something similar. If that doesn't help, you may just be overburdening your server and need to upgrade to a more capable system, or split your work across multiple servers.

User avatar
Active Member

Posts

Joined
Wed May 10, 2017 11:52 pm
Who is online

Users browsing this forum: dani888 and 14 guests