MySQL Bugs: #15925: myodbc initial connection to w2k is painfully slow

Bug #15925	myodbc initial connection to w2k is painfully slow
Submitted:	22 Dec 2005 3:46	Modified:	28 May 2013 12:37
Reporter:	lian Wei Sheng	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S5 (Performance)
Version:	3.51.10	OS:	Windows (W2K)
Assigned to:		CPU Architecture:	Any

Description:
Hi, i have a problem with w2k connection using myODBC. i have a client that is using w2k server and is a not connected to internet. then i try using a window ME as my workstation. Then i goto the odbc setting there to test my connection. when i click on the test button it took a very very long time to prompt me a message telling me that the connection is sucessful. then i try to click on the combo box to select database. but when i click on the combo box it always not responding. 
so i go back and use another w2k as my server and try this case again at my own place. But the result is different. the connection is more faster than my client one. the only different is that my w2k server is connected to the internet. 
so can anyone tell me how to solve this problem?

How to repeat:
just use a w2k server to try.

Thank you for a problem report. Please, send the results of "ipconfig /all" command on your server and problematic client, as well as "netstat -r" results from the client that connects slow. Do you have any firewalls installed? The exact version of MyODBC (3.51.x) and MySQL server you are trying to connect to may be also useful.

Here are the result that you ask me to give you.

C:\Documents and Settings\Administrator>ipconfig /all

Windows 2000 IP Configuration

        Host Name . . . . . . . . . . . . : w2kserver
        Primary DNS Suffix  . . . . . . . :KINGVALLEY.COM.MY
        Node Type . . . . . . . . . . . . : Hybrid
        IP Routing Enabled. . . . . . . . : No
        WINS Proxy Enabled. . . . . . . . : No
        DNS suffix search List  . . . . . . : KINGVALLEY.COM.MY

Ethernet adapter Local Area Connection:

        Connection-specific DNS Suffix  . :
        Description . . . . . . . . . . . : Realtek RTL8139/810x Family Fast Ethernet NIC
        Physical Address. . . . . . . . . : 00-00-1C-D5-CE-E2
        DHCP Enabled. . . . . . . . . . . : No
        IP Address. . . . . . . . . . . . : 192.168.3.10
        Subnet Mask . . . . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . . . . : 
        DNS Servers . . . . . . . . . . . : 192.168.3.100
        Primary WINS Server . . . . . : 192.168.3.10 

C:\Documents and Settings\Administrator>netstat -r

Route Table
===========================================================================
Interface List
0x1 ........................... MS TCP Loopback interface
0x1000003 ...00 00 1c d5 ce e2 ...... Realtek RTL8139/810x Family Fast Ethernet NIC
===========================================================================
===========================================================================
Active Routes:
Network Destination        Netmask          Gateway       Interface  Metric
        127.0.0.0        255.0.0.0        127.0.0.1       127.0.0.1       1
      192.168.3.0    255.255.255.0     192.168.3.10    192.168.3.10       1
     192.168.3.10  255.255.255.255        127.0.0.1       127.0.0.1       1
    192.168.3.255  255.255.255.255     192.168.3.10    192.168.3.10       1
        224.0.0.0        224.0.0.0     192.168.3.10    192.168.3.10       1
  255.255.255.255  255.255.255.255     192.168.3.10    192.168.3.10       1
===========================================================================
Persistent Routes:
  None

The netstat -r on the previous message is the server one. i think i need to go to my client place there to get the workstation netstat -r and the ipconfig/all and when i do get it then i post another message. sorry.

No the server don't have any firewall and the MyODBC that i am using is 3.51.10.0.

Please, add the information about the problematic client and reopen this bug report. You may also try to install and check MyODBC 3.51.12 (available at http://dev.mysql.com/downloads/connector/odbc/3.51.html)

Hi, here are the workstation ipconfig/all for one of the workstation win98

Windows 98 IP Configuration

             Host Name . . . . . . . . . . . . . .: Chai PC.KINGVALLEY
             DNS Servers  . . . . . . . . . . . . : 192.168.3.100
             Node Type . . . . . . . . . . . . . .: Broadcast
             NetBIOS Scope ID . . . . . . . . .: 
             IP Routing Enabled . . . . . . . . : No
             WINS Proxy Enabled . . . . . . . : No
             NetBIOS Resolution Uses DNS : Yes

0 Ethernet adapter :
             
             Description . . . . . . . . . . . . . .: Realtek 8139-series PCI NIC
           
             Physical Address. . . . . . . . . . .: 00-02-44-8C-0E-95
             DHCP Enabled. . . . . . . . . . . . : No
             IP Address. . . . . . . . . . . . . . .: 192.168.3.14
             Subnet Mask . . . . . . . . . . . . . : 255.255.255.0
             Default Gateway . . . . . . . . . . .: 
             Primary WINS Server . . . . . . . . :
             Secondary WINS Server . . . . . . .: 
             Lease Obtained . . . . . . . . . . . . :
             Lease Expires . . . . . . . . . . . . . :

here the netstat -r

Route Table

Active Routes:

Network Address      Netmask       Gateway Address        Interface        Metric
127.0.0.0                255.0.0.0      127.0.0.1                   127.0.0.1       1
192.168.3.0         255.255.255.0   192.168.3.14              192.168.3.14  1
192.168.3.14     255.255.255.255  127.0.0.1                   127.0.0.1       1
192.168.3.255   255.255.255.255  192.168.3.14              192.168.3.14  1 
244.0.0.0                224.0.0.0      192.168.3.14              192.168.3.14  1
255.255.255.255 255.255.255.255  192.168.3.14             192.168.3.14  1

Active Connections
Proto       Local Address               Foreign Address              State

Your networks information looks OK for me...

Have you tried to connect using mysql command line client? Is it slow too? If you are connecting with host names, please, try to connect using IP-addresses and inform about any change of connection speed. DNS issues are a common reason for such a slowdown.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.