[mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 8:59 AM
To: JamesDR
Cc: mysql@lists.mysql.com
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
Dear MySQL,
Yesterday we had a complete lock on our MySQL 4.1.9.
If I connected to it TCP, it would make the connection and hang.
If I connected through the UNIX port, it would report no such file
'mysql.port'.
If I 'kill' or used the stop, nothing would happen.
Eventually I had to 'kill
Ben Clewett wrote:
It had been suggested that our DNS failed prior to this event. I don't
think MySQL uses DNS, but I am not entirely sure.
If the db, user, etc. tables in the mysql system database (containing
privileges, etc.) contain host names instead of IP-addresses I suspect
it needs a
Jigal,
Thanks.
I can confirm that there were no domains used for our permissions. All
IP based. Although this may have been the cause, I don't think it was
in this case. I think as well that DNS timeouts are in the region of 20
seconds to 2 minutes.
Would any person know if there is any
Ben Clewett wrote:
Jigal,
Thanks.
I can confirm that there were no domains used for our permissions. All
IP based. Although this may have been the cause, I don't think it was
in this case. I think as well that DNS timeouts are in the region of 20
seconds to 2 minutes.
Would any person
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
Ben Clewett wrote:
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
Michael,
Thank for the reference. This is useful.
Ben.
Michael Stassen wrote:
Ben Clewett wrote:
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,