Problems with connections to mySQL
| From: | Marc Hanlon | Date: | Tue, 21 Aug 2001 00:05:52 +0000 |
| Subject: | Problems with connections to mySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-63588@lists.php.net to get a copy of this message | ||
I seem to be having a major problem with Apache 1.3.20 (Win32), PHP 4.0.6
and mySQL server 3.23.33 running on a Windows 98 SE machine.
I use a single mySQL persistant connection through a globals.php3 file, it
doesn't seem to be working as expected though, here is a copy of me NETSTATS
and you'll understand:
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:1040
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:1837
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:1839
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:1841
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:1844
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:1846
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:1848
ESTABLISHED
TCP dell:3306
javascript-of-unknown-origin.netscape.com:2501
As you can see, there are multiple strange connections to the SQL port. I
cant locate whats causing all these connections but I'm certain it has
something to do with the persistant connection.
This leads to a huge burden on my computer and I think it runs out of
connections cause every 10 mins or so Apache says it cannot connect to the
SQL server and I have to restart the Apache service to get it going.
Any advice would be very welcome.
Marc.
P.s. I am in the process of d/l the latest mySQL but I have little faith in
this problem being fixed in it.