Bug #41284 problem with "unauthenticated user"
Submitted: 6 Dec 2008 23:06 Modified: 8 Dec 2008 11:44
Reporter: Heintz Hugues Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:14.12 Distrib 5.0.70 OS:Linux (gentoo 2007.0)
Assigned to: CPU Architecture:Any
Tags: Unauthenticated User

[6 Dec 2008 23:06] Heintz Hugues
i have 2 servers ...
1 = web
2 = data

1 send many connexions to 2
2 have averagely 50 local perscitant connexion ( normal )

in the showprocesslist i receive a lot of that :
"2266400  	unauthenticated user  	****:45738  	NULL  	Connect  	NULL  	Reading from net  	NULL"

the local connexions were very good without latence

i have too attempted skip name resolve in my.cnf
i have a 100Mbps connexion witch is averagely used on 100%

help me please :'(
the server load is near 0.02

thanks in advance.

How to repeat:
lot of distant connexion...

Suggested fix:
[8 Dec 2008 8:59] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

"unauthenticated user" is normal when one attempts to connect, but havaen't been authenticated yet. In your case you should tune number of persistent connection, value of max_connections and check if latter is reasonable for your hardware and OS limits.
[8 Dec 2008 11:44] Heintz Hugues
i have already attempted that

max_connections = 1000
max_connect_errors              = 1000
connect_timeout                 = 30

i have no problem with my hardware limits...

thanks in advance.