Randal Rust wrote:
On Mon, Apr 14, 2008 at 11:13 AM, Daniel Convissor
<[EMAIL PROTECTED]> wrote:
close() is called during PHP's cleanup process that happens at the
end of script execution.
OK, so if I don't have to *explicitly* tell the process to close, then
why do I keep getting a lot of threads that are Sleeping? And for a
long period of time? This is what is causing the slowdown on the
server. If I manually go into the DB and kill threads that have been
sleeping for a long time, then the system speeds back up.
I am by no means an expert, by I always close the connections explicitly. My
understanding is that the connection gets closed eventually, but by MySQL
itself after a time out period. I'd just send the close commands and see that
the connections are closed in a controlled fashion that I can influence. I am
sure the one command more will be way less overhead than MySQL holding on to
idle connections that never will be used again.
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
