I have been experiencing a problem where mysql appears to hang when authenticating connections. I am running mysql 3.23.52-log on a dedicated PIII server with 768MB of RAM and FreeBSD 4.1. Nothing else runs on this server and 99.9% of the connections come in remotely. What appears to be happening, is the server gets a little busy due to some slow queries and the queries start to back up. When the server gets done catching up with the queue no new threads can connect, they all hang on authentication. After a few minutes the new attempts stop showing up on the processlist. I know that mysqld is not hanging because I was on the server yesterday while it happened and I could still run queries fine, I just couldn't establish any new connections. MySQL never takes up more than 380MB of RAM on the server, the CPU peaks every now and then, but for the most part stays low. It seems to recover fine when the queue is only around 40 queries, but when the queue gets over 100 we have this problem. Any ideas on what is going on?
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
