On Fri, Sep 19, 2003 at 11:47:38AM +0300, Egor Egorov wrote:
I have a server which has been running for about a year now. It
started with kernel 2.4.19 and mysql 3.x it has since been
continually
upgraded so that it is now kernel 2.4.20 and mysql 4.0.13. The
server is
a Compaq server with dual Pentium II (Deschutes) 400MHz 512Kb cache
CPUs, 320Mb RAM and SCSI drives. The OS is Gentoo Linux.
From the beginning it has behaved strangely - connections to mysql
(be
that with the mysql textclient or from PHP) fails about 2 out of 3
times
in periods. Some times there are no problems, other times it's
almost
impossible to connect. This behavior has been consistent from the
start,
so it has been a problem when running both mysql 3.x and 4.0.x.
I have monitored the servers load and the loads are the same in the
periods when it fails as in the periods when it doesn't. I have
tried
monitoring the mysql logs, but no entries show up upon the failed
connection attempts.
No other services malfunctions in this way, or indeed at all on the
server.
I have run out of ideas on how to debug this problem, can anybody
here
help me?
What error did you receive?
In PHP it just says connection failed. I can't remember the exact
message the textclient gave, and it is in a period of not failing right
now (typical!) so I can't get the message right now. I think it gave a
message about connection aborted. As soon as it does it again I'll write
the correct message to the list.
--
Anders
-BEGIN GEEK CODE BLOCK-
Version: 3.12
GCS/O d--@ s:+ a-- C++ UL+++$ P++ L+++ E- W+ N(+) o K? w O-- M- V
PS+ PE@ Y+ PGP+ t 5 X R+ tv+ b++ DI+++ D+ G e- h !r y?
--END GEEK CODE BLOCK--
PGPKey: http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x8BFECB41
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]