Re: a problem, should be very happy for some help...

Well, if it were Linux I'd say that you've reached the descriptor limit on the machine. Try using mysql_pconnect instead so that all connections get reused. Also make sure you are using localhost as hostname so that the connection goes through a unix socket instead of an inet socket (i think it is faster that way). If it doesn't work, you might have to ask your isp for some tweaking of the mysql setup or even (although unlikely), recompile the kernel to allow for more file descriptors. You should try to find a way to lower the time each connection takes (so that they will be freed faster) or increase the connection limit. (or both!) my $0.02 Adolfo Garcia uServers At 17:51 1/30/2002 -0200, you wrote:

Hi, Are you closing the connection ? If not, they could be staying opened. Regards ----- Original Message ----- From: <mailto:anton@portal.se>Anton Hillerström To: <mailto:webmaster@php.net>webmaster@php.net Sent: Wednesday, January 30, 2002 3:14 PM Subject: a problem, should be very happy for some help... Hi! I really enjoy the site php.net, that's the absolutely best reference site I ever seen... I have a problem with my site and maybe you can help me, give me an advice how to solve it... It's a community with about 50 000 members... earlier it was written in ASP / MS SQL Server and now it's in PHP / MySQL... when it is over about 60 persons online I get this error when trying open the DB with: mysql_connect($host, $userid, $pass): Warning: Can't create TCP/IP socket (55) in /usr/home/...inc.php on line 12 Warning: MySQL Connection Failed: Can't create TCP/IP socket (55) in /usr/home/...inc.php on line 12 The webserver and the DB server is separated from each other... The operative system is FreeBSD. Apache/1.3.19 (Unix) FrontPage/4.0.4.3 PHP/4.0.6 mysql: server version: 3.23.36 The page is on a webhost and the best thing is if I can solve it without consulting the web hotel.. Best regards Anton