Hello.
>MySQL cannot resolve this servers hostname for brief >periods around the same time every day. You can disable the hostname cache by starting the server with the --skip-host-cache option. But the performance can slow down. You may use nslookup to check the correct work of the DNS servers during that periods of day. See: http://dev.mysql.com/doc/mysql/en/dns.html Ed Pauley II <[EMAIL PROTECTED]> wrote: > I have 3 different MySQL server setups. On two of the servers, one > running 4.0 and one running 4.1, I have seen a peculiar problem. It > seems that when a client server is taken offline for a period of time > (few hours to couple of days) and is brought back online, MySQL has a > problem resolving the hostname and the clients are denied access. > Obviously my privileges are setup by hostname instead of IP. I have also > seen a weird problem with one client that makes and closes a lot of > connections. MySQL cannot resolve this servers hostname for brief > periods around the same time every day. Are there any known issues with > MySQL and its internal DNS caching? Could there be something wrong with > my DNS servers configuration? It just seems odd that it works fine 99.9% > of the time. I suppose I will have to change my privileges to use IPs. > > Any help or input would be appreciated. > > Thanks, > Ed > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
