NYCPHP Meetup

[Warren Myers]

It should also be noted that connections will automatically timeout, so you
don't technically need to close it (though it's a Good Idea (tm)). With
pconnect, PHP *should* reopen the connection if it's timed-out on MySQL's
end.

WMM

On 7/1/07, Jakob Buchgraber <jakob.buchgraber at googlemail.com> wrote:
>
> > I am in no position to correct you, but isn't it that PHP talks to MySQL
> > rather then the HTTP client? As far as MySQL is concerned, the
> > connection comes from where the PHP interpreter is located. And since
> > each connection from PHP to MySQL gets named sufficiently uniquely I
> > guess that PHP can keep multiple clients apart. Normally one opens a
> > connection, runs the queries, and then closes it. I always make sure
> > that I explicitly close the connection, but after reading the
> > documentation a script end will close the connection as well. Seems to
> > be quite different from opening files, which stay open and locked even
> > after the script is done.
> > It may just be that PHP uses only one persistent connection and feeds
> > all the queries through that one regardless of client (but returns the
> > values back to the script instance from where the query came), which is
> > what you suspect. Unless someone who really knows what is going on comes
> > forward we can only resort to speculation.
> >
> > I will give it a try and see what happens. It's only adding a "p". Since
> > the mysql_close doesn't do any thing on persistent connections there is
> > no harm in leaving it in - or so the theory goes.
> >
> > I don't see a problem with my current project as this one will never be
> > used by more than a few dozen clients at a time, but I have other
> > projects where some optimization may be more than just OK.
> >
> >
> > David
> > _______________________________________________
> > New York PHP Community Talk Mailing List
> > http://lists.nyphp.org/mailman/listinfo/talk
> >
> > NYPHPCon 2006 Presentations Online
> > http://www.nyphpcon.com
> >
> > Show Your Participation in New York PHP
> > http://www.nyphp.org/show_participation.php
> >
>
> Exactly that's what I tried telling you :-D. Of course the HTTP Client
> (=user) does not connect to mysql it's the PHP script, but the PHP
> script gets executed when the client makes a request and regardless how
> many requests he makes the PHP Script/Mysql does not know that this user
> has already been here. That's what I wanted to tell you as I thought
> that you thought that persistent connections mean that for every user a
> new connection is opened and that each connection corresponds to a user
> and is kept open for e.g. 30 minutes, but that's not true.
>
> Anyway, it seems to mean that you got it now and that's actually
> everything that counts.
>
> - Jakob
> --
> Sun Certified Programmer for the Java 2 Platform, Standard Edition 5.0
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>



-- 
http://warrenmyers.com
"God may not play dice with the universe, but something strange is going on
with the prime numbers." --Paul Erdős
"It's not possible. We are the type of people who have everything in our
favor going against us." --Ben Jarhvi, Short Circuit 2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070701/ce0e6af1/attachment.html>