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
