MySQL Bugs: #23086: MySQL Administrator slow when entering server host

Bug #23086	MySQL Administrator slow when entering server host
Submitted:	8 Oct 2006 5:03	Modified:	17 Oct 2006 10:02
Reporter:	brian wasserman	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.4 rc	OS:	Windows (XP SP2)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	administrator, client, dns, GUI, slow, windows, XP

Description:
MySQL Administrator is very slow when I type in my destination host in the "Sever Host" box.  It is about a two second delay between each character typed to show up in the box.  I believe this is because the GUI does something that causes a DNS lookup on keyboard events.  Each lookup attempt fails until the hostname is complete and resolves.  If the host doesn't resolve then the Username box also has the same symptoms.  But once the hostname is valid the Username box functions normally.

How to repeat:
Run MySQL Administrator
Enter hostname
 
If symptom is not seen then enter invalid hostname and try to enter a username.

If delays aren't noticed then use packet sniffer such as Ethereal to see the DNS lookup requests.  The response time probably depends on the environment, so the bug symptoms may not be noticed by all developers or users.

Suggested fix:
Don't resolve hostname or connect to the server until OK is clicked.

Thank you for the bug report.

Bug: http://bugs.mysql.com/bug.php?id=23111 was marked as duplicate of
this one.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Bug: http://bugs.mysql.com/bug.php?id=23649 was marked as duplicate of
this one.