On Tuesday 20 November 2001 09:52, [EMAIL PROTECTED] wrote: > From: [EMAIL PROTECTED] > Operating system: Win2000 > PHP version: 4.0.6 > PHP Bug Type: MySQL related > Bug description: Loses Track of Persistent Connections > > Running Apache 1.3.20 with php 4.0.6 > MySQL 3.23.42nt running on the same machine. > > I have 2 accounts which pconnect to mySQL. It looks like php is forgetting > it has connections open when pconnect is called, and opening duplicates, as > the MySQL process table gets filled up. > > (Made worse since MySQL seems to ignore its wait_timeout setting!)
I have the same problem occuring with Running Apache 1.3.20 with php 4.0.6 using MySQL 3.23.43 on Linux (2.4.10). It would appear every time a script is run a new socket to mysql is open, after the query is finished the socket just stays open and waits in sleep state (according to mysql's process-list) until mysql kills when the wait_timeout is reached. I've switched to using mysql_connect() and the problem has dissapeared. Could it be that the mysql's socket when using mysql_pconnect() is only shared within the apache child, thus every child needs to open a new socket to mysql? -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
