Too many connections - Nats or Sponsor problem? - GoFuckYourself.com

dcortez · 09-27-2006, 12:25 PM

Is the following a problem with Nats or the the resources the Sponsor has allocated through Nats?

NATS has found a problem

Too many connections

Who is breaking down in this case?

Anyone else seeing a lot of these over past day or so?

Sly · 09-27-2006, 12:27 PM

My quick guess is its a server problem, possibly needs more RAM. But I'm no tech, I just pretend to know what I'm talking about. :-)

fuzebox · 09-27-2006, 12:29 PM

Generally it's because the mysql max_connections variable is too low (usually it's at the default which is 100)... Most new NATS programs discover this within a couple weeks of opening their program and fix it.

Sly · 09-27-2006, 12:31 PM

fuzebox is a NATS wizard! He has nice hair too.

dcortez · 09-27-2006, 12:34 PM

Quote:

Originally Posted by fuzebox

Generally it's because the mysql max_connections variable is too low (usually it's at the default which is 100)... Most new NATS programs discover this within a couple weeks of opening their program and fix it.

So is it the Sponsor who does not have sufficient resources on their machines, or are the databases hosted on Nats infrastructure?

Better yet, who has to fix the problem?

squishypimp · 09-27-2006, 12:35 PM

looks like an SQL error.

TMM_John · 09-27-2006, 02:35 PM

Quote:

Originally Posted by dcortez

So is it the Sponsor who does not have sufficient resources on their machines, or are the databases hosted on Nats infrastructure?

Better yet, who has to fix the problem?

As a few people said its a problem of the software needing more connections than their mysql install will allow. As programs grow they will need more and more. This is a problem fixed by most programs themselves, however, if they need our assistance we help them fix it.

edit: To answer your other question, the sql server is hosted by the client. We do not host anything for our clients and all NATS installs run independant of each other. This is why when there are a few that have mysql problems within a short period of time it is a coincidence not a "NATS problem" as sometimes people like to argue. NATS installs are not dependant upon our servers and they don't know what other NATS installs are doing so the problems are unrelated and client specific. Just enough installs out there that from time to time there will be problems on more than one

Pete-KT · 09-27-2006, 02:51 PM

Quote:

Originally Posted by PBucksJohn

As a few people said its a problem of the software needing more connections than their mysql install will allow. As programs grow they will need more and more. This is a problem fixed by most programs themselves, however, if they need our assistance we help them fix it.

edit: To answer your other question, the sql server is hosted by the client. We do not host anything for our clients and all NATS installs run independant of each other. This is why when there are a few that have mysql problems within a short period of time it is a coincidence not a "NATS problem" as sometimes people like to argue. NATS installs are not dependant upon our servers and they don't know what other NATS installs are doing so the problems are unrelated and client specific. Just enough installs out there that from time to time there will be problems on more than one

Very nice a professional answer John, I also need to talk to you about some stuff.

dcortez · 09-27-2006, 07:55 PM

Quote:

Originally Posted by PBucksJohn

As a few people said its a problem of the software needing more connections than their mysql install will allow. As programs grow they will need more and more. This is a problem fixed by most programs themselves, however, if they need our assistance we help them fix it.

edit: To answer your other question, the sql server is hosted by the client. We do not host anything for our clients and all NATS installs run independant of each other. This is why when there are a few that have mysql problems within a short period of time it is a coincidence not a "NATS problem" as sometimes people like to argue. NATS installs are not dependant upon our servers and they don't know what other NATS installs are doing so the problems are unrelated and client specific. Just enough installs out there that from time to time there will be problems on more than one

That answers my questions exactly.

As an affiliate seeing the error, it's not obvious who is exceeding their limits as not all of us know how a Nats solution is installed.

So this is something we should raise with our sponsors (if they don't already know).

Thank-you.

pornpf69 · 09-27-2006, 08:09 PM

Quote:

Originally Posted by dcortez

That answers my questions exactly.

As an affiliate seeing the error, it's not obvious who is exceeding their limits as not all of us know how a Nats solution is installed.

So this is something we should raise with our sponsors (if they don't already know).

Thank-you.

if you knew a little about MySQl/PHP you would have figured that out on your own.....

BucksMania · 09-28-2006, 07:31 AM

Quote:

Originally Posted by Sly

He has nice hair too.

good to know

09-27-2006, 12:25 PM	#1
dcortez DINO CORTEZ™ Industry Role: Join Date: Jun 2003 Location: Vancouver Island Posts: 2,145	Too many connections - Nats or Sponsor problem? Is the following a problem with Nats or the the resources the Sponsor has allocated through Nats? NATS has found a problem Too many connections Who is breaking down in this case? Anyone else seeing a lot of these over past day or so?

09-27-2006, 12:27 PM	#2
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,329	My quick guess is its a server problem, possibly needs more RAM. But I'm no tech, I just pretend to know what I'm talking about. :-) __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available Great for TSS, Nifty Stats, remote work, virtual assistants, etc. Click here for more details.

09-27-2006, 12:31 PM	#4
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,329	fuzebox is a NATS wizard! He has nice hair too. __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available Great for TSS, Nifty Stats, remote work, virtual assistants, etc. Click here for more details.

09-27-2006, 12:35 PM	#6
squishypimp PostMaster General Join Date: Aug 2006 Posts: 10,781	looks like an SQL error. __________________ Signature For Sale

09-27-2006, 12:29 PM	#3
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,119	Generally it's because the mysql max_connections variable is too low (usually it's at the default which is 100)... Most new NATS programs discover this within a couple weeks of opening their program and fix it.