RE: Complete server lock

[Daniel]

MySQL and DNS can be such a fun issue because it comes
suddenly and leaves just as suddenly with --skip-name-resolve.

For in-depth info on how MySQL uses DNS, and info about
this potential DNS-related bug: http://codenode.com/mysql/dns

-Daniel

-----Original Message-----
From: Ben Clewett [mailto:ben@stripped] 
Sent: Friday, July 29, 2005 8:59 AM
To: JamesDR
Cc: mysql@stripped
Subject: Re: Complete server lock



JamesDR wrote:
> I noticed, on my Linux server, that MySQL makes a DNS lookup anyway.
> Even if the IP is used or not. It normally digs on the PTR record. I
had 
> all of my perms IP based, however, it still looked at the PTR record.
At 
> the time I hadn't set any up in my DNS server. After I added all the
PTR 
> records of the clients that were connecting to the server, it was fast

> again.
> 
> ...Something to think about...

James, I think you've found the problem.  For the benefit of us novices,

what is the PTR record?  After which I can add this to my /etc/hosts, 
which should help.

If there is anybody who knows how to build a DNS clean MySQL, I would be

very interested in knowing.

Regards,

Ben Clewett.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1