NYCPHP Meetup

NYPHP.org

[nycphp-talk] mysql_pconnect

D C Krook dkrook at hotmail.com
Thu Aug 29 11:55:34 EDT 2002


Oktay,

It could be, I recall that Rasmus answered someone's similar question about 
mysql_pconnect with a pretty simple answer.  I wish I had taken notes.

In any case, your connection pool will be limited by Apache & and MySQL's 
max_connections and MaxClients settings, so you won't have an ever 
increasing number of connections:

http://pres.lerdorf.com/show/osconmysql/4


>From: Oktay Altunergil <nyphp at altunergil.com>
>Reply-To: talk at nyphp.org
>To: NYPHP Talk <talk at nyphp.org>
>Subject: Re: [nycphp-talk] mysql_pconnect
>Date: Thu, 29 Aug 2002 11:10:07 -0400
>Received: from mc1-f19.law16.hotmail.com ([65.54.236.26]) by 
>mc1-s15.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.4905); Thu, 29 
>Aug 2002 08:29:08 -0700
>Received: from parsec.nyphp.org ([66.250.54.138]) by 
>mc1-f19.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.4905); Thu, 29 
>Aug 2002 08:22:42 -0700
>Received: from nyphp.org (parsec.nyphp.org [66.250.54.138])by 
>parsec.nyphp.org (8.12.3/8.12.3) with ESMTP id g7TFA7E7000954;Thu, 29 Aug 
>2002 11:10:07 -0400 (EDT)(envelope-from listmaster at nyphp.org)
>Message-Id: <200208291510.g7TFA7E7000954 at parsec.nyphp.org>
>X-Paralist-Archived: <http://nyphp.org/list/paralist_archive.php?L_mid=999>
>X-List-Software: Paralist 0.6
>List-ID: <nyphptalk.nyphp.org>
>List-Owner: <mailto:listmaster at nyphp.org>
>List-Archive: <http://nyphp.org/list/paralist_archive.php?L_lid=1>
>List-Subscribe: <http://nyphp.org/list/>
>List-Unsubscribe: <http://nyphp.org/list/>
>Organization: New York PHP
>X-Mailer: Paramail 0.5
>Return-Path: listmaster at nyphp.org
>X-OriginalArrivalTime: 29 Aug 2002 15:22:43.0381 (UTC) 
>FILETIME=[EBAE0650:01C24F6F]
>
>this might be misunderstanding.. are you sure this is for pconnect ?
>
>php.net says:
>
>"
>  First, when connecting, the function would first try to find a 
>(persistent) link that's already open with the same host, username and 
>password. If one is found, an identifier for it will be returned instead of 
>opening a new connection.
>
>Second, the connection to the SQL server will not be closed when the 
>execution of the script ends. Instead, the link will remain open for future 
>use (mysql_close() will not close links established by mysql_pconnect()). "
>
>oktay
>
>On Thu, 29 Aug 2002 11:04:40 -0400
>D C Krook <dkrook at hotmail.com> wrote:
>
> > The connection to the db is implicitly closed after the script is run.
> >
> > Rasmus Lerdorf did a presentation on PHP/MySQL at OSCON last month where 
>he
> > discussed that:
> >
> > http://pres.lerdorf.com/show/osconmysql/
> >
> >
> > _________________________________________________________________
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >






=======================================
D C Krook
http://krook.net/ || http://krook.info/


_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com




More information about the talk mailing list