Bug 23891 MySQL runs out of connections

[Chris McAvoy]

http://bugs.php.net/bug.php?id=23891

According to this report, what the person was asking isn't a bug, it's
a feature (rimshot).

I'm running into this problem almost exactly, and really don't
understand what the answer is. The support person snidely suggests
reading the manual, which is always great advice, but in this case
really doesn't help out.

Could someone explain what "If you use mysql_select_db () or slightly
different connection string you can have more open connections then
you have process." means?

If I don't use mysql_select_db , then what do I use?

Thanks,
Chris

[J0hn Sm1th]

Re: Bug 23891 MySQL runs out of connections

Chris McAvoy wrote:[color=blue]
> http://bugs.php.net/bug.php?id=23891
>
> According to this report, what the person was asking isn't a bug, it's
> a feature (rimshot).
>
> I'm running into this problem almost exactly, and really don't
> understand what the answer is. The support person snidely suggests
> reading the manual, which is always great advice, but in this case
> really doesn't help out.
>
> Could someone explain what "If you use mysql_select_db () or slightly
> different connection string you can have more open connections then
> you have process." means?
>
> If I don't use mysql_select_db , then what do I use?
>
> Thanks,
> Chris[/color]

The only solution is to not use persistent connections, it isn't
*really* a bug apparently, but a problem that occurs with a certainly
PHP+WebServer combo - The issue arrises if you use using a multi-process
web server such as Apache. Since database connections cannot be shared
among different processes a new one is created if the request happen to
come to a different web server child process.

http://www.php.net/manual/en/features.persistent-connections.php