Re: Connections with bad DNS cause lockups

2005-09-14 Thread Tuc at T-B-O-H
I'm not sure if we are able to find > any clues in the trace files when using clients with a good reverse. > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >I hacked the Makefile so that it would recompile it with > > -debug on t

Re: Connections with bad DNS cause lockups

2005-09-05 Thread Tuc at T-B-O-H
so that if it does start to become uncontactable I'll get paged. Thanks, Tuc > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >Ok. Is there a way to get a timestamp in the file too? If > > this happens while I'm not ne

Re: Connections with bad DNS cause lockups

2005-09-05 Thread Tuc at T-B-O-H
to find the place > where mysqld hangs. In my opinion, it is possible. You should > research the last entries at the end of the trace file (using tail, > for example) after mysql has hung. I'm not sure if we are able to find > any clues in the trace files when using clients with a go

Re: Connections with bad DNS cause lockups

2005-09-03 Thread Tuc at T-B-O-H
place where the new connections hang. See: > http://dev.mysql.com/doc/mysql/en/making-trace-files.html > > > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > >> > >> Hello. > >> > >> In my opinion, we're a little kinked in this issue. Le

Re: Connections with bad DNS cause lockups

2005-09-03 Thread Tuc at T-B-O-H
> > Hello. > > In my opinion, we're a little kinked in this issue. Let's start over. > :( Sorry. I've been told by the GF that I have a habit of doing it to her too. > > In one of your posts you mentioned that the server runs lots > of other services besides the database. > Yes,

Re: Connections with bad DNS cause lockups

2005-09-02 Thread Tuc at T-B-O-H
> > Hello. > > > > is that when it gets probed, it COMPLETELY offlines (DOS) the server. > > One upon a time I solved such an issue with MySQL on FreeBSD by switching > to the official binaries from: > http://dev.mysql.com/downloads > > Still, the recommended way to run MySQL on FreeBSD is c

Re: Connections with bad DNS cause lockups

2005-09-01 Thread Tuc at T-B-O-H
Hi, I'm running FreeBSD 5.4 on the system in question. It was my understanding on newer Unixes that things like a call to gethostbyname(3) would cause it to go against the nsdispatch(3) in libc and determine what method to perform its various lookups. Right now its set to read nsswitch.con

Re: Connections with bad DNS cause lockups

2005-09-01 Thread Tuc at T-B-O-H
not a perfect solution but it may keep you going until MySQL can > figure out something better to deal with misbehaving DNS servers. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote on 09/01/2005 1

Re: Connections with bad DNS cause lockups

2005-09-01 Thread Tuc at T-B-O-H
tion! Just also seems difficult to keep proper documentation if we are using IPs and not complete hostnames. Thanks, Tuc > > Tuc at T-B-O-H <[EMAIL PROTECTED]> wrote: > > Hi, > > > >We seem to be running into a probl

Connections with bad DNS cause lockups

2005-08-30 Thread Tuc at T-B-O-H
Hi, We seem to be running into a problem with our installation that we don't understand. We are running "mysql-server-4.0.25" from the ports collection on a FreeBSD 5.3-RELEASE-p10 machine. Its tcpwrapper'd to only allow from our /24, and a single machine outside the /24.