On Thu, 4 Sep 2003, Balaji H. Kasal wrote:

> > 
> >     It is usually better not to use persistenc connections.
> >     So drop the pmysql_connect or if you really need to use
> >     them set set max connections higher for mysql.
> 
>    Which problem it has? 

        On a really busy site persistent connections will just
        pile up and in the end the sql server will reach its
        max connections limit. Unless you will do many connects
        per page you will virtually gain almost nothing by
        using persistent connections.

        If you absolutely need to use persistent connections 
        you can stop max connections filling up by dropping
        MaxRequestsPerChild from httpd.conf to something 
        like 150 or lower. This way unnesseccary connections
        get killed when the Apache child dies.

-- 
Mika Tuupola                      http://www.appelsiini.net/~tuupola/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to