Hi,
You right.RH8 have a problem with glibc.All people from the list recommende
to make a downgrade to version 2.x or download binary distribution from
MySQL site which is compiled with the right version of glibc.
Are and other ways to solve your problems but i think you need to a stable
solution.
Anyway if you start MySQL daemon with option --skip-name-resolve and the
problem it's solved then you have only this 2 options.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Chris Faust" <[EMAIL PROTECTED]>
To: "John P" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 02, 2003 6:54 AM
Subject: RE: Desperate - failed: Lost connection to MySQL server during
query
> Thanks for the help John, I really don't know all the specifics of the
> hardware setup as it is all out at our ISP, I know its a rack mounted P4
and
> its going into a Cisco switch but that's about it.
>
> We have made some progress though and as strange as it sounds its really
> looking like its something with RH 8, in short we downgraded perl 5.8 to
> 5.6.1 with no results, we then went from Apache 2 down to 1.3 with no
> results, then that night backup exec came through and the machine spiked
to
> 100% - noticed it by luck of being on the machine at the same time, this
> pretty much took Apache, Perl and my code out of the question.
>
> Did up a new machine (same specs), put RH 7.3 on it, copied everything
over
> and made it live.. Right before we switched over to the new machine we
> stopped throttling the server (it was the only way to stop those errors)
and
> instantly those connection failures started happening like crazy.
> As soon as we made the switch, they all went away, load was cut in half
and
> CPU idle went up around 30 to 40% and things were just screaming, 110%
> improvement in all areas.
>
> So you'd think everything was wonderful now, wouldn't you?.. Well check
this
> out.. As soon as the new web server was brought up I started getting (and
> still get) tons of "Aborted connection ... (Got an error reading
> communication packets)" - and mySql has run without a flaw since day one,
> also the scripts and DBI and everything was exactly the same on the new
web
> server from the old web server (mysql would have no knowledge of the
> switch).
> I can say I'm about 98% sure that everything mySql shows for this problem
> at:
> http://www.mysql.com/doc/en/Communication_errors.html
> Isn't a issue.
>
> As RH 8 is also running on the dedicated mySql machine, I'm starting to
> believe its the root of all my problems.
>
> Its been a wild week!!
>
> Thanks
> -Chris
>
>
>
> >> -----Original Message-----
> >> From: John P [mailto:[EMAIL PROTECTED]]
> >> Sent: Saturday, December 28, 2002 1:45 PM
> >> To: Chris Faust; [EMAIL PROTECTED]
> >> Subject: Re: Desperate - failed: Lost connection to MySQL server during
> >> query
> >>
> >>
> >> > If you are running close to the same setup with no problems
> >> then I feel a
> >> > little better about it not being a issue of pure traffic.
> >>
> >> Yes, we operate in a very similar way to you. (BTW, we have had very
good
> >> results with a PHP based cache facility that simply stores the db
driven
> >> pages over a selectable time period; good if your pages don't change
that
> >> much! Capacity increased 4000% or so; would imagine something
> >> similar exists
> >> for perl)
> >>
> >> > I don't think the link between the machines is a issue, both
> >> machines are
> >> > dedicated and at the same location, I've tried using both the
> >> external and
> >> > internal (10.0.x.x) IP to connect to the DB with the same
> >> results and in
> >> all
> >> > cases both machines have had entries in their hosts file for
> >> one another.
> >> >
> >> > As for simultaneous connections, that is something that I
> >> still need to go
> >> > through the logs and come up with a real number for those time
> >> frames.. I
> >> > don't know anyway to see a real number of actual users using Apache
via
> >> the
> >> > command line (is there such a thing?).
> >>
> >> I've always done ps -ef | grep httpd | wc -l a few times which shows
the
> >> processes, you can get a good idea of whether the site is busy or not.
I
> >> don't know how to actually find the exact number of users, I
> >> suppose netstat
> >> ?
> >>
> >> > One thing I wonder that I forgot to ask - does using IP address as
the
> >> host
> >> > for a user in mySql matter? Meaning before DNS switched over I
> >> wanted to
> >> get
> >> > everything up and running so I created all the mysql user
> >> accounts based
> >> on
> >> > the IP address of the web server (and not name).
> >> > I would think if this were a issue at all I would be getting "denied"
> >> > messages and it wouldn't work 100% of the time, but I thought I would
> >> throw
> >> > it out there.
> >>
> >> I'd do everything by IP, especially for the "internal" stuff.
> >>
> >> It might be worth trying a dedicated cable+two separate network cards
in
> >> each server to handle MySQL traffic. Just a thought, but could packets
be
> >> getting lost between the two servers (network overloaded or out
> >> of ports on
> >> eth0 or ..?)
> >>
> >> Post your exact network setup (machines, switches/hubs etc) and
> >> that might
> >> give some more clues?
> >>
> >> Good luck
> >> John
> >>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
