Bug #28098 [Com]: mysql_pconnect never kills threads
Edit report at https://bugs.php.net/bug.php?id=28098&edit=1
ID: 28098
Comment by: jose dot nobile at gmail dot com
Reported by: moreau at myrealbox dot com
Summary: mysql_pconnect never kills threads
Status: Bogus
Type: Bug
Package: MySQL related
Operating System: FreeBSD 5.2.1
PHP Version: 4.3.6
Block user comment: N
Private report: N
New Comment:
I don't found any form to use persistent connections.
No threads, no working
threads, no working
php in console, no working
What is the enviroment to use persistent connections?
Apache + forker
Apache + Worker
Apache + PHP fastcgi
Which???
This is not a bogus, is a real BUG of 7 years old.
Previous Comments:
------------------------------------------------------------------------
[2004-04-22 18:26:16] iliaa@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php
When using threads you should not be using persistent
connections, because PHP cannot identify existing
connections as already avaliable and therefor opens a new
persistent connection each time.
------------------------------------------------------------------------
[2004-04-22 08:36:07] moreau at myrealbox dot com
Thanks for your answer too, I didn't know that persistent connection is not closed after ending
script.
But I don't agree that such behaviour as I describe is normal. As I mentioned pconnect generate
new thread in each new running script.
BUT THIS IS THE SAME SCRIPT! So as said in documentation
pconnect should REUSE old connection , BUT DON'T generate
new connection. In practice - pconnet don't close any connection at all, but don't reuse
previous connection and
generate new.
Is this also correct behaviour ?
------------------------------------------------------------------------
[2004-04-22 01:54:05] iliaa@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php
Persistent connections remain active until the Apache is
shutdown. This is expected behavior.
------------------------------------------------------------------------
[2004-04-21 22:02:35] moreau at myrealbox dot com
Yes, significantly.
Each script is successfully ended , so apache returns in
normal state ( minimal threads and process - as pointed in config ) after long timeout ( when pages
aren't requested ). But MySQL has many threads and no one of threads never die.
------------------------------------------------------------------------
[2004-04-21 19:19:51] gschlossnagle@php.net
mysql extension will create one connection per database
connect string per PHP interpreter context, i.e. one per
Apache thread or child. Is the number of connections
you are seeing exceeding your Apache thread count?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=28098
--
Edit this bug report at https://bugs.php.net/bug.php?id=28098&edit=1
Thread (7 messages)