Post by Evilonion » Tue Aug 13, 2019 5:50 pm

Hi
For some reason the past few months the site has been getting increasingly slow.
Error logs show a connection issue and after discussing with my host its hitting the max connections of 30 allowed.
They have said connections are staying open.

How would I fix this? as everything has been mostly running fine until this issue.

Oc 3.02 uptheme with seo backpack and nitro pack.

Active Member

Posts

Joined
Sun Oct 30, 2016 8:07 pm

Post by letxobnav » Tue Aug 13, 2019 6:59 pm

the only way that db connections stay open (sleeping) is when you use persistent db connections.
Perhaps that nitro pack alters the default db connections into persistent connections, ask them.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by thekrotek » Wed Aug 14, 2019 3:57 am

Don't use NitroPack. Just don't. It messes with the system pretty bad. As for OpenCart, it DOES close all the connections.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by paulfeakins » Wed Aug 14, 2019 5:55 pm

thekrotek wrote:
Wed Aug 14, 2019 3:57 am
Don't use NitroPack. Just don't. It messes with the system pretty bad. As for OpenCart, it DOES close all the connections.
I'm not doubting @thekrotek's experience or expertise but we actually do recommend Nitropack and think it's great.

Re. this issue, what is the size of your log file?

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Expert Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by thekrotek » Wed Aug 14, 2019 7:15 pm

paulfeakins wrote:
Wed Aug 14, 2019 5:55 pm
I'm not doubting @thekrotek's experience or expertise but we actually do recommend Nitropack and think it's great.
It's messy, you can't argue with that :-)

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by paulfeakins » Wed Aug 14, 2019 7:20 pm

thekrotek wrote:
Wed Aug 14, 2019 7:15 pm
It's messy, you can't argue with that :-)
It is quite complex, like Magento or Journal, but it does seem to work well in our experience and when it doesn't, their support is good.

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Expert Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by thekrotek » Wed Aug 14, 2019 7:59 pm

paulfeakins wrote:
Wed Aug 14, 2019 7:20 pm
It is quite complex, like Magento or Journal, but it does seem to work well in our experience and when it doesn't, their support is good.
Magento is the worst and most messy e-commerce framework ever created. Journal is the most messy OC theme ever created. Not the best examples to compare with for sure :-)

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by paulfeakins » Wed Aug 14, 2019 8:07 pm

thekrotek wrote:
Wed Aug 14, 2019 7:59 pm
Magento is the worst and most messy e-commerce framework ever created. Journal is the most messy OC theme ever created. Not the best examples to compare with for sure :-)
I agree! Which is why I used them as examples of too much complexity, but Nitropack is nowhere near that bad!

For quick, professional OpenCart support please email info@antropy.co.uk


User avatar
Expert Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - Reigate, Surrey, United Kingdom

Post by Evilonion » Sun Aug 18, 2019 8:28 am

So I disabled seo backpack and nitro pack
Cleared the error logs and left it for a couple of days.

The log now gets about 30 errors a day saying the same thing. It's still at max connections.
My host seems to think 30 is enough but in order for more I'd have to upgrade to vps.
For a vps to have double that amount I'd need a 4gb which seems insane for a cart that just gets 2000 visitors a month??

Active Member

Posts

Joined
Sun Oct 30, 2016 8:07 pm

Post by letxobnav » Sun Aug 18, 2019 9:32 am

check if some of those connections are in sleep status.
If some are, you still have a bad modification somewhere or maybe your host has put their Mysql server on persistent connections.

The number of active connections depend on how many url's you service concurrently, there may be peaks with a fast spider but I do not expect your site to spit out 30+ url's at the same time during normal operations.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Active Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by Hussain_alikaka » Sun Aug 18, 2019 9:37 am

I have same problem, need to know what to do


Posts

Joined
Sun Aug 18, 2019 9:30 am

Post by thekrotek » Sun Aug 18, 2019 1:24 pm

Evilonion wrote:
Sun Aug 18, 2019 8:28 am
The log now gets about 30 errors a day saying the same thing. It's still at max connections.
I remember having similar issue with Joomla on SiteGround servers. These guys even worse and limit connections to like 5 or 10, don't remember exactly how much. I wasn't that experienced those days and wasn't able to find the root of the issue.

I don't really think problem is with OpenCart, because, like I previously said, it manages queries more or less good. There're issues like using INSERT in foreach() construct and similar stuff, but it is related to optimization mostly. Closing connections is a different kind of issue and, I'm afraid, it can be addressed only personally for it's too specific. If you want I can try to look into this on your server. Drop me an email or text in Skype and we'll discuss the matter.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am

Who is online

Users browsing this forum: No registered users and 43 guests