Re: Stopping DNS Lookups

2008-10-24 Thread Richard S. Huntrods
Yes, that's exactly what the link from Hassan said to do. Interestingly, what is not stated in that link is that you must add entries in mysql tables 'db' and 'user' for '127.0.0.1' (a.k.a. 'localhost') if you need to access the database from the local server. Remote access via static IP

Re: Stopping DNS Lookups

2008-10-24 Thread Richard S. Huntrods
. Sender does not necessarily endorse content contained within this transmission. Date: Fri, 24 Oct 2008 07:51:44 -0700 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Stopping DNS Lookups Yes, that's exactly what the link from

Re: Stopping DNS Lookups

2008-10-23 Thread Moon's Father
Add skip-name-reslove in my.cnf and restart mysql immediately. On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods [EMAIL PROTECTED]wrote: Awesome! Thanks very much - exactly what I was looking for. I'm in the field and was under the gun, otherwise would have checked the manuals first.

Stopping DNS Lookups

2008-10-22 Thread Richard S. Huntrods
I have a server that runs only MySQL. It services several other servers inside a firewalled intranet. All connections to the MySQL database are done using static IP addresses. Recently I had to start monitoring the firewall traffic on this intranet, and discovered the MySQL server is

Re: Stopping DNS Lookups

2008-10-22 Thread Richard S. Huntrods
. Huntrods To: mysql@lists.mysql.com Sent: Oct 22, 2008 07:40 Subject: Stopping DNS Lookups I have a server that runs only MySQL. It services several other servers inside a firewalled intranet. All connections to the MySQL database are done using static IP addresses. Recently I had to start monitoring

Re: Stopping DNS Lookups

2008-10-22 Thread Hassan Schroeder
On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods [EMAIL PROTECTED] wrote: Recently I had to start monitoring the firewall traffic on this intranet, and discovered the MySQL server is routinely sending queries to the main DNS server (outside the firewall). I suspect the server is performing

Re: Stopping DNS Lookups

2008-10-22 Thread Richard S. Huntrods
Awesome! Thanks very much - exactly what I was looking for. I'm in the field and was under the gun, otherwise would have checked the manuals first. Again, thanks. -Richard Hassan Schroeder wrote: On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods [EMAIL PROTECTED] wrote: Recently I