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 other part of MySQL which uses DNS
lookups? For instance, logging of some kind?
Or any other reason a MySQL daemon would not respond to a kill?
Thank for the ideas,
Ben Clewett.
Jigal van Hemert wrote:
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 DNS to resolve these...
If I get a state where a 'kill' will not cause MySQL to exit. Is
there any other know way to ask MySQL to exit cleanly?
MySQL server was probably waiting for a bunch of DNS requests? Until a
timeout occurs it will probably keep the connection waiting. This can
cause a lot of connections to occur until you reach max_connections at
which point it will not accept new connections anymore.
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]