Re: PHPs PDO, apache and "never ending sessions"

On 07/03/2008, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
> > A bit of poking around with ps and lsof showed me that a PHP
> > application I closed days ago (no browser open) was still active
> > tying up backend sessions; the problem went away when I
> > restarted my apache. Is this "normal behaviour"? How do I
> > deal with it under normal circumstance, am I just supposed
> > to increase the number of allowed connections and not worry
> > about apache holding sessions open even after the "client"
> > has long gone?

> It depends on how you are connecting. For example if you are doing this:
>
> PDO::ATTR_PERSISTENT => true
>
> Then... yeah :). You really shouldn't use a language layer for
> persistent connections though. Use pgbouncer or pgpool.
Thanks Joshua. It was indeed set to true; I was playing with
the "hatshop" database and application from the "Beginning
PHP and PostgreSQL E-Commerce" Apress book. And found
that config.php has "define('DB_PERSISTENCY', 'true');". Thanks
for pointing me in the right direction.

> Joshua D. Drake

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm