----- Original Message -----
From: "Chris Faust" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 1:18 PM
Subject: RE: Desperate - failed: Lost connection to MySQL server during
query
> I really don't think its any of the scripts either, everything was
> running fine at another location (none of these errors ever came up)
> and the scripts do run fine via the command line.
Hmm, if stuff runs consistently well on the command line, then that seems to
be ruling out a hardware error (unless you connect our DBI over TCP/IP, in
which case you could have a faulty Ethernet card; but I assumed you are
using a local UNIX domain socket, like /tmp/mysql.sock).
> One other test I did was put part of the site that was getting as many
> lost connection errors as anything else, on another machine (the
> administration side of it) and once there it ran perfectly using the
> same mySql server (and its even IIS).
This DOES seem to indicate you are connecting using TCP/IP. Are you? If so,
a whole new sleuth of options appears.
> I'm leaning towards either Redhat 8, or Apache 2 or the combination of
> the two of them - I just can't figure out what else to try or what to
> look for.
Try connecting over the domain socket; or / and add something like this to
the [mysql] section of my.cnf,
set-variable = connect_timeout=4
Just to see whether it is a timing problem.
- Mark
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
