mysql> show full processlist;
+-----+----------------------+--------------------+------+---------+------+----------------------------------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+----------------------+--------------------+------+---------+------+----------------------------------+-----------------------+
| 1 | system user | | NULL | Connect | 623 | Waiting for master to send event | NULL |
| 2 | system user | | NULL | Connect | 0 | Reading event from the relay log | NULL |
| 400 | root | localhost | v3 | Sleep | 68 | | NULL |
| 585 | root | localhost | v3 | Query | 0 | NULL | show full processlist |
| 748 | unauthenticated user | 172.19.0.27:32833 | NULL | Connect | NULL | login | NULL |
| 749 | unauthenticated user | 172.19.0.27:32836 | NULL | Connect | NULL | login | NULL |
| 750 | unauthenticated user | 172.19.0.27:32838 | NULL | Connect | NULL | login | NULL |
| 751 | unauthenticated user | 172.19.0.27:32841 | NULL | Connect | NULL | login | NULL |
| 752 | unauthenticated user | 172.19.0.27:32844 | NULL | Connect | NULL | login | NULL |
| 753 | unauthenticated user | 172.19.0.27:32846 | NULL | Connect | NULL | login | NULL |
| 754 | unauthenticated user | 172.19.0.27:32848 | NULL | Connect | NULL | login | NULL |
| 755 | unauthenticated user | 172.19.0.139:46827 | NULL | Connect | NULL | login | NULL |
| 756 | unauthenticated user | 172.19.0.139:46830 | NULL | Connect | NULL | login | NULL |
| 757 | unauthenticated user | 172.19.0.139:46831 | NULL | Connect | NULL | login | NULL |
| 758 | unauthenticated user | 172.19.0.27:32857 | NULL | Connect | NULL | login | NULL |
| 759 | unauthenticated user | 172.19.0.27:32858 | NULL | Connect | NULL | login | NULL |
| 760 | unauthenticated user | 172.19.0.27:32859 | NULL | Connect | NULL | login | NULL |
| 761 | unauthenticated user | 172.19.0.27:32863 | NULL | Connect | NULL | login | NULL |
| 762 | unauthenticated user | 172.19.0.27:32864 | NULL | Connect | NULL | login | NULL |
| 763 | unauthenticated user | 172.19.0.27:32866 | NULL | Connect | NULL | login | NULL |
| 764 | unauthenticated user | 172.19.0.27:32870 | NULL | Connect | NULL | login | NULL |
| 765 | unauthenticated user | 172.19.0.27:32871 | NULL | Connect | NULL | login | NULL |
| 766 | unauthenticated user | 172.19.0.139:46833 | NULL | Connect | NULL | login | NULL |
| 767 | unauthenticated user | 172.19.0.27:32878 | NULL | Connect | NULL | login | NULL |
| 768 | unauthenticated user | 172.19.0.27:32881 | NULL | Connect | NULL | login | NULL |
| 769 | unauthenticated user | 172.19.0.27:32885 | NULL | Connect | NULL | login | NULL |
| 770 | unauthenticated user | 172.19.0.139:46835 | NULL | Connect | NULL | login | NULL |
| 771 | unauthenticated user | 172.19.0.27:32888 | NULL | Connect | NULL | login | NULL |
| 772 | unauthenticated user | 172.19.0.27:32890 | NULL | Connect | NULL | login | NULL |
| 773 | unauthenticated user | 172.19.0.139:46837 | NULL | Connect | NULL | login | NULL |
| 774 | unauthenticated user | 172.19.0.139:46839 | NULL | Connect | NULL | login | NULL |
| 775 | unauthenticated user | 172.19.0.139:46841 | NULL | Connect | NULL | login | NULL |
| 776 | unauthenticated user | 172.19.0.139:46844 | NULL | Connect | NULL | login | NULL |
| 777 | unauthenticated user | 172.19.0.139:46845 | NULL | Connect | NULL | login | NULL |
| 778 | unauthenticated user | 172.19.0.139:46847 | NULL | Connect | NULL | login | NULL |
| 779 | unauthenticated user | 172.19.0.27:32898 | NULL | Connect | NULL | login | NULL |
| 780 | unauthenticated user | 172.19.0.27:32900 | NULL | Connect | NULL | login | NULL |
| 781 | unauthenticated user | 172.19.0.139:46850 | NULL | Connect | NULL | login | NULL |
| 782 | unauthenticated user | 172.19.0.139:46852 | NULL | Connect | NULL | login | NULL |
| 783 | unauthenticated user | 172.19.0.139:46854 | NULL | Connect | NULL | login | NULL |
| 784 | unauthenticated user | 172.19.0.139:46857 | NULL | Connect | NULL | login | NULL |
| 785 | unauthenticated user | 172.19.0.139:46859 | NULL | Connect | NULL | login | NULL |
| 786 | unauthenticated user | 172.19.0.27:32903 | NULL | Connect | NULL | login | NULL |
| 787 | unauthenticated user | 172.19.0.139:46862 | NULL | Connect | NULL | login | NULL |
| 788 | unauthenticated user | 172.19.0.139:46865 | NULL | Connect | NULL | login | NULL |
| 789 | unauthenticated user | 172.19.0.139:46866 | NULL | Connect | NULL | login | NULL |
| 790 | unauthenticated user | 172.19.0.139:46868 | NULL | Connect | NULL | login | NULL |
| 791 | unauthenticated user | 172.19.0.139:46871 | NULL | Connect | NULL | login | NULL |
| 792 | unauthenticated user | 172.19.0.139:46873 | NULL | Connect | NULL | login | NULL |
| 793 | unauthenticated user | 172.19.0.27:32907 | NULL | Connect | NULL | login | NULL |
| 794 | unauthenticated user | 172.19.0.27:32909 | NULL | Connect | NULL | login | NULL |
| 795 | unauthenticated user | 172.19.0.27:32911 | NULL | Connect | NULL | login | NULL |
| 796 | unauthenticated user | 172.19.0.139:46875 | NULL | Connect | NULL | login | NULL |
| 797 | unauthenticated user | 172.19.0.27:32914 | NULL | Connect | NULL | login | NULL |
| 798 | unauthenticated user | 172.19.0.27:32916 | NULL | Connect | NULL | login | NULL |
| 799 | unauthenticated user | 172.19.0.139:46877 | NULL | Connect | NULL | login | NULL |
| 800 | unauthenticated user | 172.19.0.139:46879 | NULL | Connect | NULL | login | NULL |
+-----+----------------------+--------------------+------+---------+------+----------------------------------+-----------------------+
57 rows in set (0.00 sec)
views:
797answers:
1
+4
A:
A connection with "unauthenticated user" in the User column has initiated a connection but hasn't sent his/her credentials yet, so the server doesn't know who exactly is connecting.
If such connections only showed up in the list when they were authenticated, it could potentially run the server out of available sockets and you wouldn't even know why.
Most often stuck connections are due to DNS not resolving properly, which the skip-name-resolve option will help with.
More info at the Pythian blog.
Artem Russakovskii
2009-06-11 20:21:23
You mean when we connect to db,it's splited into 2 steps?
Shore
2009-06-11 20:24:58
4 actually, according to the Pythian blog article.
Artem Russakovskii
2009-06-11 20:26:57