Bug #27465 Multiple Unauthenticated User line shown in MySQL when it overload the server
Submitted: 27 Mar 2007 10:03 Modified: 28 Mar 2007 8:39
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.37 OS:Linux (Centos)
Assigned to: CPU Architecture:Any
Tags: Unauthenticated User

[27 Mar 2007 10:03] [ name withheld ] 
Description:
The server overloaded by MySQL service. MySQL "Show full processlist" provides below results:

| 2763877 | unauthenticated user | 192.168.1.9:38105 | NULL| Connect | NULL | Reading from net     | NULL|
| 2763876 | nuffmy_my            | 192.168.1.9:38104 | NULL| Connect | NULL | Reading from net     | NULL|
| 2763875 | unauthenticated user | 192.168.1.9:38103 | NULL| Connect | NULL | Reading from net     | NULL|
| 2763874 | unauthenticated user | 192.168.1.9:38102 | NULL| Connect | NULL | Reading from net     | NULL|
| 2763873 | unauthenticated user | 192.168.1.9:38101 | NULL| Connect | NULL | Reading from net     | NULL|
| 2763872 | unauthenticated user | 192.168.1.9:38100 | NULL| Connect | NULL | Reading from net     | NULL|
| 2763879 | unauthenticated user | 192.168.1.9:38107 | NULL| Connect | NULL | Reading from net     | NULL|

In my.cnf, I have enabled "skip-name-resolve" and have the hostname information included into /etc/hosts file.

How to repeat:
This issue happens when the database size is more than 1GB and are connected to the busy web application powered by PHP engine.

Suggested fix:
May be can directly drop this kind of connection since it is unauthenticated.
[28 Mar 2007 8:39] Sveta Smirnova 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read what "unauthenticated user" state means at http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html