Bug #42121 5 to 10 seconds to authenticate connection

• Submitted: 14 Jan 2009 22:37
• Modified: 15 Jan 2009 6:23
• Reporter: Anker Berg-Sonne
• Status: Not a Bug
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 5.1.30
• OS: Windows (XP Pro SP 2)
• CPU Architecture: Any

[14 Jan 2009 22:37] Anker Berg-Sonne

Description:
It takes 5 to 10 seconds to authenticate new connections. This happens no matter whether I am trying to establish the connection locally or remotely, and it doesn't matter whether I log in as root or another user.

The system appears to be completely idle during the delay. No CPU usage and no disk activity.

If I stop and restart MySQL the delay is initially even longer, on the order of 30 seconds to a minute.

If I do a SHOW FULL PROCESSLIST the state is Login and the command is Connect.

How to repeat:
Happens consistently.

[14 Jan 2009 22:52] MySQL Verification Team

Thank you for the bug report. That sounds like DNS hostname lookups, could you please do a test starting the server with the option: --skip-name-resolve but in this case use only IP numbers in the MySQL grant tables. Thanks in advance.

[14 Jan 2009 23:37] Anker Berg-Sonne

Thank you, Miguel,

Yes, it was a DNS name resolution delay. I fixed it by editing the hosts file on the server. Now it works as it should.

Anker

[15 Jan 2009 6:23] Sveta Smirnova

Thank you, Anker, for the feedback.

Closed as "Not a Bug", because last comment.