Dear All:
i got the problem everytime when i restart my sql database,my program need to take long time to connect to the database,this happen since last few week and before that all is working fine.The following is my database processlist.All the Unauthenticated user is not yet get the connection.Any idea.Thanks.
| Id | User | Host | db | Command |
Time | State
| Info |
+--------+----------------------+-------------+--------------+---------+------+-------------------
---+------------------+
| 1 | system user | none | | Connect |
1358 | connecting to master | |
| 9291 | sa | 10.0.48.142 | incoming2200 | Sleep |
0 |
| |
| 11091 | sa | 10.0.48.143 | incoming2200 | Sleep |
0 |
| |
| 13724 | sa | 10.0.48.142 | smsdb2200 | Sleep |
797 |
| |
| 13726 | sa | 10.0.48.142 | mmind2200 | Sleep |
797 |
| |
| 13733 | sa | 10.0.48.142 | incoming2200 | Sleep |
797 |
| |
| 13775 | sa | 10.0.48.142 | incoming2200 | Sleep |
1 |
| |
| 14376 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 14416 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 14463 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 14531 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 14657 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 14680 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 14873 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 15057 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 15112 | unauthenticated user | 10.0.48.147 | | Connect
| | login
| |
| 15173 | unauthenticated user | 10.0.48.147 | | Connect
