I noticed the issue as one of the clients that connects to the server started receiving Too Many Connection and/or Could not create new thread messages. When I managed to take a look at the process list, I could see that there were hundreds of connections pending login.. it looked like they were waiting on a locked table, but I could not see any.
I managed to get it corrected by doing a FLUSH TABLES WITH READ LOCK and then an UNLOCK TABLES.. but I have no idea what may have caused this Login problem.
Any suggestions would be greatly appreciated.
Thanks.
-- Regards,
Derek Buttineau Internet Systems Administrator Compu-SOLVE Internet Services
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]