FW: Connections from localhost fast. Connections anywhere else slow.

Our network group, has pretty much resolved to bounce a few servers and =
our switches tomorrow. I have two work arounds that keep MySQL running. =
One was to connect to MySQL useing localhost on our web server. The =
other was to add the skip-networking parameter into our my.ini.=20

Our network guys are definately scratching their heads of this one as =
this network problem has only affected MySQL and one other socket server =
application.

-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
Sent: Friday, June 03, 2005 3:28 PM
To: MySQL Win32 List
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.


Check the config file for the "bind-address" variable and the manual
for what it is, if that doesn't work, you may check your clients HOSTS
file (%WINDIR%\HOSTS) for an entry regarding your server. As I said
before, other protocols (IPX, NETBEUI, QoS) may interfer and slow down
your TCP connections, I've seen this specially on 95/98. Another
thing, if you use a proxy, http tunelling, or your gateway goes down
for any reason, if your dns goes down too, you'll experience problems
connecting (even using the IP directly, specially on winxp).

Well, that's how far we can go, if you're the network support, I'm
sorry (:P) if not, call them because someone isn't doying the job :)

On 6/3/05, James Frankman wrote:
>=20
> Thanks for the speedy response. You can't buy support this fast.
>=20
> -We are connecting via TCP/IP.
>=20
> -DNS servers appear to be working correctly. Even if they weren't we =
are experienceing problems when using the actual ip address. If I =
understand my networking when you use the ip address, the DNS server is =
not used.
>=20
> -I tried your suggestions about the connect vs. query time. It takes =
several seconds to connect to MySQL, but query times are instantaneous. =
It must be a network issue right?
>=20
> -We are noticing similar problems with other peices of software on our =
network that you connect to on a TCP port. We seem to be having problems =
with port 211 on a completely separate server. However our web server =
and ftp servers respond fine. They are on ports 80 and 23 I think.
>=20
> It is now obvious that this is a network issue as we are having =
problems on other servers/software.
>=20
> Not to waste the mysql list with troubleshooting a general networking =
issue, but if anyone has some ideas as why certain ports on our network =
are experiencing performance problems, I am all ears.
> -----Original Message-----
> From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
> Sent: Friday, June 03, 2005 2:33 PM
> To: MySQL Win32 List
> Subject: Re: Connections from localhost fast. Connections anywhere =
else
> slow.
>=20
>=20
> This is one of those problems you have thousands of solutions for, but
> a few would aplly to your machine, network, server, client, protocols
> and environment specific configuration.
>=20
> First, how are you trying to connect? TCP/IP? If so, then you should
> configure the bind address, I've seen machines with modens (and
> dial-up adapters) have speed problems when using direct tcp/ip
> connections. Are your DNS working OK? Is your network setup properly?
> When MySQL (and any other tcp program) try to resolve names, it takes
> a long time if it can't find a name server, even if you're using
> direct IP addressing.
>=20
> Another suggestion, use the MySQL client console from a remote machine
> and see if what takes time is the CONNECTION or the QUERY, because if
> its the connection, than your network isn't configured properly, but
> if the QUERIES are slow too, then you may have fragmentation, colision
> or any other kind of packet loss (that may be caused by hardware
> configs).
>=20
> Anyway, give us more info...
>=20
> Best regards,
>=20
> On 6/3/05, James Frankman wrote:
> > I have a serious produciton problem on my hand. Need help ASAP.
> >
> > If we connect to MySQL using localhost, it is very fast, but if we =
use its ip address to connect it is extremely slow. Other network =
connections to our MySQL server do not seem slow. Any help diagnosing =
this problem would be helpful.
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> >
> >
>=20
>=20
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Djfrankman@idfbins.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Djfrankman@idfbins.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org