Are you using BIND? You may want to make sure you applied your new changes
to it and also make sure your
/etc/host.conf has the right order for searching in it.
Rob
----- Original Message -----
From: "Tim Cadell" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 8:26 PM
Subject: Re: Connection delay problem
> Nope, didn't solve it. I added that to the mysqld command and restarted
> it (checked with ps -ef to make sure it took) and it still does it.
>
> Sasha also suggested that I try using straight IP addresses everywhere,
> and I did that, but it hasn't helped yet.
>
> Thanks for the suggestion, though.
>
> Tim Cadell
> Total Net
>
> -----Original Message-----
> From: "Jason Brooke" <[EMAIL PROTECTED]>
> To: "Tim Cadell" <[EMAIL PROTECTED]>, "MySQL List"
> <[EMAIL PROTECTED]>
> Date: Thu, 23 Aug 2001 10:16:58 +1000
> Subject: Re: Connection delay problem
>
> > > We're having problems with connecting to our MySQL database after
> > making
> > > some changes to our system. Unfortunately, we had to reassign it's IP
> > > address and, at the same time, our customer wanted to change the
> > domain
> > > name for the system. Changing both seems to have been a bad thing.
> > >
> > > Now, with every connection method I've tried (perl DBI, mysql command
> > > line), there is a 15 second delay before the connection succeeds,
> > which
> > > it always does.
> > >
> > > Can anyone give me a hint on this one?
> > >
> > > Tim Cadell
> > > Total Net
> >
> > It's probably trying to resolve each host that connects to it, although
> > from
> > your description it even sounds like connecting from the localhost is
> > getting the same behaviour too which is strange since your /etc/hosts
> > file
> > should have an entry for that
> >
> > --skip-name-resolve in the startup line would probably fix it
> >
> > jason
> >
>
>
>
> ---------------------------------------------------------------------
> 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
