What does this error msg mean?

[Anon]

Warning: Too many connections in ../includes/db_library/content.inc on line 954

..and more to the point, what can I do? It's happening every third or fourth time I refresh the page. Does this mean that if more than a few people are looking at it then it will throw this ugly thing up?
I'm using mysql_pconnect() to connect if that helps.

Any assistance would be greatly appreciated.

Nick

[kid_c]

Personally I never use pconnect for anything web-related, only rarely use it in shell scripts that cannot afford to lose the db conneciton.

I believe taking out pconnect will definately solve your problem......or if you insist on using it, wherever you open your sock in your pages, always do a check like:

if (!$sock)
$sock = mysql_pconnect("host",user,pass);

--
Keith Bussey
[e-mail]
Programmer - WISOL.com
[phone] ext. 225

[Anon]

Well, it seems to work okay now, I must have missunderstood the use of that function. I thought it would save resources as it would only connect if it didn't already have a connection?

anyway...

Cheers

Nick

[mithril]

Nick,

Saving resources via reusing open connections is the premise behind persistent connections, but in many cases it takes longer to excute using pconnect over connect. Don't ask me why, but that's the observation I've made through my own experience and I've read several other opinions that seem to support it.

In your case it sounds like your open connections are getting orphaned somehow, thus forcing the server to try and open a new connection. Since persistent connections persist (excuse the pun🙂 for a set period of time, the default is 1 hour I believe, you eventually max out the total number of connections the MySQL server will allow and get the error message you mentioned.

One way to sort over acheive what I think you're trying to do is to store the connection resource identifer returned by mysql_connect() in a variable, then pass it into mysql_query() and mysql_select_db() functions. While MySQL will automatically try to reuse any open and inactive connection, this method allows to you explictly reuse the connection opened at the begining of your script for all database operations during that script execution. For example:

  $conn = @mysql_connect("localhost", "username", "password");

  @mysql_select_db("my_db", $conn);

  $rs = @($sql, $conn);

HTH.

geoff