RE: [PHP-DB] Intermittent failure when connecting to local MySQL db?

2001-12-07 Thread Leotta, Natalie (NCI/IMS)

I'm not sure if other people have lots of db problems with PHP but we had
enough that we switched our website around so it has a perl page that
creates the HTML page, queries the db, and sends the data into PHP to have
it draw a graph based on the data.  It's more complicated, but perl never
fails to connect to the database.  We had about a 10% failure rate with the
PHP.  If you find out what could be causing the problem please let me know
too :-)

We are using Sybase instead of MySQL but if it's happening to some people
across different DBMSs then maybe there's something in PHP that doesn't like
something to do with the way a network is set up or something like that??

-Natalie

> -Original Message-
> From: Jed McCaleb [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, December 07, 2001 12:26 PM
> To:   [EMAIL PROTECTED]
> Subject:  [PHP-DB] Intermittent failure when connecting to local MySQL
> db?
> 
> I have a php script that is connecting to a database on the same machine.
> It
> will connect and work fine sometimes but about half the time it will fail
> to
> connect? The machine is running FreeBSD and gets a lot of traffic. The
> problem got much worse when we tweaked some kernel parameters to allow
> more
> connections to Apache. We have since chaged back to the defaults but we
> still have the can't connect error every once in a while.
> Mysql is 3.23
> PHP is 4.0.6
> 
> Any ideas what it could be?
> Thanks,
> Jed.
> 
> 
> 
> -- 
> PHP Database 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]

-- 
PHP Database 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]




[PHP-DB] Intermittent failure when connecting to local MySQL db?

2001-12-07 Thread Jed McCaleb

I have a php script that is connecting to a database on the same machine. It
will connect and work fine sometimes but about half the time it will fail to
connect? The machine is running FreeBSD and gets a lot of traffic. The
problem got much worse when we tweaked some kernel parameters to allow more
connections to Apache. We have since chaged back to the defaults but we
still have the can't connect error every once in a while.
Mysql is 3.23
PHP is 4.0.6

Any ideas what it could be?
Thanks,
Jed.



-- 
PHP Database 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]