login
Short Description
The initial state for a connection thread until the client has been authenticated successfully.
Detailed Description​
The initial state for a connection thread until the client has been authenticated successfully.
How to reduce this wait​
Seeing threads stuck in this state can be caused by DNS name resolution issues. By default MySQL will attempt this lookup for each thread. Restarting MySQL with the --skip-name-resolve option can help if this is the issue.
Additional Links​
- MySQL Documentation - General thread states - login
- codeinthehole - Solving MySQL connection problems caused by a dead name server
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.