Unauthenticated user issues?

[Brandon Laing]

Hey all,

Having some issues with a new MySQL system. We're running the 64-bit version of MySQL 4.1.11, installed from RPMs, on a dual Opteron system, 4 gigs of memory, 15k RPM SCSI drives, gig network, etc. We replaced our old server, which was running version 4.0.17 with this box. For the most part, things have been working great (and very fast!) so far. However, a couple times we've had everything hang on us while waiting for mysql to authenticate a new connection. Running a show processlist shows the strings like this:

| 108160 | unauthenticated user | 192.168.XXX.XXX:3449 | NULL | Connect | NULL | login | NULL
| 108162 | unauthenticated user | 192.168.XXX.XXX:39610 | NULL | Connect | NULL | login | NULL |
| 108163 | unauthenticated user | 192.168.XXX.XXX:39611 | NULL | Connect | NULL | login | NULL |
| 108164 | unauthenticated user | 192.168.XXX.XXX:39612 | NULL | Connect | NULL | login | NULL |
| 108165 | unauthenticated user | 192.168.XXX.XXX:39613 | NULL | Connect | NULL | login | NULL |
| 108166 | unauthenticated user | 192.168.XXX.XXX:39614 | NULL | Connect | NULL | login | NULL |
| 108167 | unauthenticated user | 192.168.XXX.XXX:39615 | NULL | Connect | NULL | login | NULL |


We'll have 20-30 of these within a couple of minutes, and they just keep piling up. During this time, no new connections can be made. All new connections are coming from our internal network as well. About the only thing we've been able to do is start killing these processes until finding the one that's causing the problem, at which time everything else goes through.

So, I've looked around a bit and have seen that this issue shows up from time to time, but nobody ever has a resolution for it. I'm hoping that someone has some ideas to try to attempt to work through this problem. I can provide my.cnf configuratons if they will help any.

Any suggestions would really be appreciated here.

Thanks.