今年双十一遇到一个问题,user里面有unauthenticated user
mysql> show processlist;
+--------+----------------------+----------------------+-----------+---------+-------+-----------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+----------------------+----------------------+-----------+---------+-------+-----------------------------+------------------+
| 1 | event_scheduler | localhost | NULL | Daemon | 25 | Waiting for next activation | NULL |
| 143573 | d_XXXX_v2 | 10.153.205.173:45272 | d_XXXX_v2 | Sleep | 23097 | | NULL |
| 143875 | root | 10.153.205.173:52192 | d_XXXX_v2 | Sleep | 22936 | | NULL |
| 156237 | root | localhost | d_XXXX_v2 | Sleep | 6642 | | NULL |
| 157318 | root | localhost | NULL | Sleep | 5791 | | NULL |
| 165517 | d_XXXX_v2 | 10.153.205.173:34345 | d_XXXX_v2 | Sleep | 3 | | NULL |
| 166163 | root | 10.153.205.173:44449 | d_XXXX_v2 | Sleep | 0 | | NULL |
| 166289 | root | localhost | d_XXXX_v2 | Query | 0 | init | show processlist |
| 167891 | d_XXXX_v2 | 10.153.205.173:59812 | d_XXXX_v2 | Sleep | 1 | | NULL |
| 168158 | root | 10.153.205.173:47288 | d_XXXX_v2 | Sleep | 0 | | NULL |
| 168159 | unauthenticated user | 10.173.82.76:41376 | NULL | Connect | NULL | Reading from net | NULL |
+--------+----------------------+----------------------+-----------+---------+-------+-----------------------------+------------------+
http://blog.itpub.net/22664653/viewspace-1815489/