mysqlgui and DNS
I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present The problems appear to be related to DNS lookups. I'm not sure why mysqlgui needs any info other than what is present in the hosts file. In comparison, the console-based client, mysql.exe, suffers no delays with or without a dial-up connection. The second problem is also present on Win98 but the delays are much shorter. On my linux machine, mysqlgui has none of these problems even if a dial-up connection is active. Is anyone else having this problem? Is there a fix for it? Thanks in advance Environment: machine 1: red hat linux 7.2 - mysql server machine 2: windows xp - client machine 3: windows 98 - client - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui and DNS
John Derrick writes: I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present [skip] Is anyone else having this problem? Is there a fix for it? Thanks in advance Environment: machine 1: red hat linux 7.2 - mysql server machine 2: windows xp - client machine 3: windows 98 - client A fix is to use IP address in the host field. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui and DNS
Thanks for the reply. Using the IP address in the host field does not fix the problem, however. The delay in problem 1 changes from 1 - 2 seconds to 10 seconds. No impact on problem 2. Do I need to change the parameters to the server? - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:08 PM Subject: Re: mysqlgui and DNS John Derrick writes: I'm having a couple of problems running mysqlgui on Windows XP Pro. 1) Intermittent 1 - 2 second delays on connecting and executing queries 2) 30 second delay on connecting and occasionally when executing queries when a dial-up connection is present [skip] Is anyone else having this problem? Is there a fix for it? Thanks in advance Environment: machine 1: red hat linux 7.2 - mysql server machine 2: windows xp - client machine 3: windows 98 - client A fix is to use IP address in the host field. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php