Posted by howachen on 12/16/13 11:59

Jerry Stuckle 寫道：

> howachen@gmail.com wrote:
> > Hi,
> >
> > Is that when using pconnect to mysql, it is already mean connection
> > pooling?
> >
> > thanks.
> >
>
> No. mysql_pconnect() is a persistent connection. These connections
> will be around as long as your web server is running and can be reused
> by different scripts. The number of connections is fixed.
>
> Pooling allows connections to be reused also. But the difference is
> smart pooling will dynamically adjust the size of the pool. For
> instance, if a connect request is issued and there is a free connection,
> that one is used. If none are free, a new one is acquired.
>
> When a the application closes a connection, the connection isn't
> released immediately. Instead, it can hang around for a while.
> Eventually unused connections will be released.
>
> Of course, this assumes one server and one userid/password. It's a
> little more complex if you use more than one server and/or
> userid/password, but the concept is the same.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================

sorry first... my google account has some problem, which can't find my
posted article and thus I repost it today.

back to the topic...


currently which package/solutions is the most popular one for php
connection pooling?

[Back to original message]