From: Date: July 29 2005 4:59pm Subject: Re: Complete server lock List-Archive: http://lists.mysql.com/mysql/187093 Message-Id: <42EA4443.2080107@clewett.org.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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.