Connections from localhost fast. Connections anywhere else slow.

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=3Dgcdmw-win32@m.gmane.org

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

--=_alternative 0070168785257015_=
Content-Type: text/plain; charset="US-ASCII"

"James Frankman" wrote on 06/03/2005 04:17:42 PM:

> 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.


Have you tried the setting "skip-name-resolve" ? (
http://dev.mysql.com/doc/mysql/en/server-options.html)

There has been some history here on the lists of Win32 systems having slow
DNS lookups. This may help.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0070168785257015_=--

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

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.

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.

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).

Anyway, give us more info...

Best regards,

On 6/3/05, James Frankman wrote:
> I have a serious produciton problem on my hand. Need help ASAP.
>=20
> If we connect to MySQL using localhost, it is very fast, but if we use i=
ts 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.
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


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

--
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

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

Thanks for the speedy response. You can't buy support this fast.

-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.

-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?

-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.


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.

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.

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).

Anyway, give us more info...

Best regards,

On 6/3/05, James Frankman wrote:
> I have a serious produciton problem on my hand. Need help ASAP.
>=20
> 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.
>=20
> --
> 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


--=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

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

Hi James,

We had a problem when connecting to the database (with an ip address in the
conneciton string) took 10-15 seconds and then suddenly the query results
would appear instantly. This problem usually occurred if the internet
connection was unavailable.

Anyway, to solve this problem, we added the following lines to our .ini file

skip-name-resolve
skip-host-cache

Try this, restart the MySQL Service and see if the problem persists.

Greg

----- Original Message -----
From: "James Frankman"
To: "Daniel da Veiga" ;
Sent: Friday, June 03, 2005 10:53 PM
Subject: RE: Connections from localhost fast. Connections anywhere else
slow.


>
> Thanks for the speedy response. You can't buy support this fast.
>
> -We are connecting via TCP/IP.
>
> -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.
>
> -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?
>
> -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.
>
> It is now obvious that this is a network issue as we are having problems
> on other servers/software.
>
> 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.
>
>
> 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.
>
> 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.
>
> 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).
>
> Anyway, give us more info...
>
> Best regards,
>
> 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=danieldaveiga@gmail.com
>>
>>
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=jfrankman@idfbins.com
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=greg@i-online.co.za
>



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

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 seve=
ral 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 ne=
twork 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 s=
ervers 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 iss=
ue, but if anyone has some ideas as why certain ports on our network are ex=
periencing 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 woul=
d be helpful.
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@g=
mail.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

--
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

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

That did it. MySQL is now quick as ever.=20

I am confused about what these do. Why did MySQL work before I started =
experiencing the problems today? What changes could have occurred to our =
network/hardware that required us to add these two entries in our .ini =
file?

-----Original Message-----
From: Greg Quinn [mailto:greg@officium.co.za]
Sent: Friday, June 03, 2005 3:26 PM
To: James Frankman
Cc: win32@lists.mysql.com
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.


Hi James,

We had a problem when connecting to the database (with an ip address in =
the=20
conneciton string) took 10-15 seconds and then suddenly the query =
results=20
would appear instantly. This problem usually occurred if the internet=20
connection was unavailable.

Anyway, to solve this problem, we added the following lines to our .ini =
file

skip-name-resolve
skip-host-cache

Try this, restart the MySQL Service and see if the problem persists.

Greg

----- Original Message -----=20
From: "James Frankman"
To: "Daniel da Veiga" ;
Sent: Friday, June 03, 2005 10:53 PM
Subject: RE: Connections from localhost fast. Connections anywhere else=20
slow.


>
> Thanks for the speedy response. You can't buy support this fast.
>
> -We are connecting via TCP/IP.
>
> -DNS servers appear to be working correctly. Even if they weren't we =
are=20
> experienceing problems when using the actual ip address. If I =
understand=20
> my networking when you use the ip address, the DNS server is not used.
>
> -I tried your suggestions about the connect vs. query time. It takes=20
> several seconds to connect to MySQL, but query times are =
instantaneous. It=20
> must be a network issue right?
>
> -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=20
> with port 211 on a completely separate server. However our web server =
and=20
> ftp servers respond fine. They are on ports 80 and 23 I think.
>
> It is now obvious that this is a network issue as we are having =
problems=20
> on other servers/software.
>
> Not to waste the mysql list with troubleshooting a general networking=20
> issue, but if anyone has some ideas as why certain ports on our =
network=20
> 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.
>
>
> 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.
>
> 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.
>
> 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).
>
> Anyway, give us more info...
>
> Best regards,
>
> 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=20
>> its ip address to connect it is extremely slow. Other network =
connections=20
>> to our MySQL server do not seem slow. Any help diagnosing this =
problem=20
>> would be helpful.
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:=20
>> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
>>
>>
>
>
> --=20
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:=20
> http://lists.mysql.com/win32?unsub=3Djfrankman@idfbins.com
>
>
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Dgreg@i-online.co.za
>=20



--
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

Service Manageer

------=_NextPart_000_0021_01C56859.7B90C370
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

When I try to start my service manager I receive a pop-up which states
"fails to start the service please try again in 30 seconds"

There is no reason given and I have no idea why it will not start. I cannot
go into the mysql/bin/ folder and start the DB there either.

I tried changing the mysql folder name and then downloading a newer version
of mysql but I could not install it as it would quit as I was configuring
it.

I am running mysql-essential-4.1.10-win32 on a XP Professional box it ran
for about three months and then died.

Can anyone help me?

Warren

Totus possum, totum Deum.
Totus ero, totum meum.
WSW



------=_NextPart_000_0021_01C56859.7B90C370
Content-Type: text/plain; charset=us-ascii

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

Re: Service Manageer

make sure you are starting the service under an account that has execute permissions for the exe and read and write on the data directories and condig filed.

Corey

-----Original Message-----

From: "warren"
Subj: Service Manageer
Date: Fri Jun 3, 2005 5:29 pm
Size: 627 bytes
To:

When I try to start my service manager I receive a pop-up which states
"fails to start the service please try again in 30 seconds"

There is no reason given and I have no idea why it will not start. I cannot
go into the mysql/bin/ folder and start the DB there either.

I tried changing the mysql folder name and then downloading a newer version
of mysql but I could not install it as it would quit as I was configuring
it.

I am running mysql-essential-4.1.10-win32 on a XP Professional box it ran
for about three months and then died.

Can anyone help me?

Warren

Totus possum, totum Deum.
Totus ero, totum meum.
WSW





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

Re: Service Manageer

--------------080107010000040701090109
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

06032005 2106 GMT-5

When you go to Services, can the service be started there at all? What
does Event Viewer say?

Wade


warren said the following on 6/3/2005 17:29:

>When I try to start my service manager I receive a pop-up which states
>"fails to start the service please try again in 30 seconds"
>
>There is no reason given and I have no idea why it will not start. I cannot
>go into the mysql/bin/ folder and start the DB there either.
>
>I tried changing the mysql folder name and then downloading a newer version
>of mysql but I could not install it as it would quit as I was configuring
>it.
>
>I am running mysql-essential-4.1.10-win32 on a XP Professional box it ran
>for about three months and then died.
>
>Can anyone help me?
>
>Warren
>
>Totus possum, totum Deum.
>Totus ero, totum meum.
>WSW
>
>
>
>
>----------------------------------------------------------- -------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.323 / Virus Database: 267.5.2 - Release Date: 6/3/2005
>
>

--------------080107010000040701090109--

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

We had this same problem yesterday. We are running 4.1.11a and out of
no where our connections go crazy. We ripped apart our network before
realizing it wasn't a network problem.

I can not find what caused this to suddenly fail. I need to read up on
how and why mySQL tries to resolve these IPs. Why would it all of a
sudden stop working after months of zero problems.

If you ever figure it out, please let me know.

-----Original Message-----
From: James Frankman [mailto:jfrankman@idfbins.com]=20
Sent: Friday, June 03, 2005 5:18 PM
To: Greg Quinn
Cc: win32@lists.mysql.com
Subject: RE: Connections from localhost fast. Connections anywhere else
slow.

That did it. MySQL is now quick as ever.=20

I am confused about what these do. Why did MySQL work before I started
experiencing the problems today? What changes could have occurred to our
network/hardware that required us to add these two entries in our .ini
file?

-----Original Message-----
From: Greg Quinn [mailto:greg@officium.co.za]
Sent: Friday, June 03, 2005 3:26 PM
To: James Frankman
Cc: win32@lists.mysql.com
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.


Hi James,

We had a problem when connecting to the database (with an ip address in
the=20
conneciton string) took 10-15 seconds and then suddenly the query
results=20
would appear instantly. This problem usually occurred if the internet=20
connection was unavailable.

Anyway, to solve this problem, we added the following lines to our .ini
file

skip-name-resolve
skip-host-cache

Try this, restart the MySQL Service and see if the problem persists.

Greg

----- Original Message -----=20
From: "James Frankman"
To: "Daniel da Veiga" ;
Sent: Friday, June 03, 2005 10:53 PM
Subject: RE: Connections from localhost fast. Connections anywhere else=20
slow.


>
> Thanks for the speedy response. You can't buy support this fast.
>
> -We are connecting via TCP/IP.
>
> -DNS servers appear to be working correctly. Even if they weren't we
are=20
> experienceing problems when using the actual ip address. If I
understand=20
> my networking when you use the ip address, the DNS server is not used.
>
> -I tried your suggestions about the connect vs. query time. It takes=20
> several seconds to connect to MySQL, but query times are
instantaneous. It=20
> must be a network issue right?
>
> -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=20
> with port 211 on a completely separate server. However our web server
and=20
> ftp servers respond fine. They are on ports 80 and 23 I think.
>
> It is now obvious that this is a network issue as we are having
problems=20
> on other servers/software.
>
> Not to waste the mysql list with troubleshooting a general networking=20
> issue, but if anyone has some ideas as why certain ports on our
network=20
> 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.
>
>
> 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.
>
> 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.
>
> 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).
>
> Anyway, give us more info...
>
> Best regards,
>
> 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=20
>> its ip address to connect it is extremely slow. Other network
connections=20
>> to our MySQL server do not seem slow. Any help diagnosing this
problem=20
>> would be helpful.
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:=20
>> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
>>
>>
>
>
> --=20
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:=20
> http://lists.mysql.com/win32?unsub=3Djfrankman@idfbins.com
>
>
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=3Dgreg@i-online.co.za
>=20



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


--
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

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

Well, the only two factors that affected us were...

a.) The internet connection went down, or the way the network accessed its
DNS server changed, or the DNS could not be found.
b.) The network server was changed to a domain controller.

So check if something along these lines changed on your network.

I must admit though I don't see the point if you supply an IP Address in the
connection string why dns's and name resolutions should ever play a
factor??? Maybe this can be fixed in an updated version.

----- Original Message -----
From: "Ryan Paulson"
To: "James Frankman" ; "Greg Quinn"

Cc:
Sent: Saturday, June 04, 2005 3:18 PM
Subject: RE: Connections from localhost fast. Connections anywhere else
slow.


> We had this same problem yesterday. We are running 4.1.11a and out of
> no where our connections go crazy. We ripped apart our network before
> realizing it wasn't a network problem.
>
> I can not find what caused this to suddenly fail. I need to read up on
> how and why mySQL tries to resolve these IPs. Why would it all of a
> sudden stop working after months of zero problems.
>
> If you ever figure it out, please let me know.
>
> -----Original Message-----
> From: James Frankman [mailto:jfrankman@idfbins.com]
> Sent: Friday, June 03, 2005 5:18 PM
> To: Greg Quinn
> Cc: win32@lists.mysql.com
> Subject: RE: Connections from localhost fast. Connections anywhere else
> slow.
>
> That did it. MySQL is now quick as ever.
>
> I am confused about what these do. Why did MySQL work before I started
> experiencing the problems today? What changes could have occurred to our
> network/hardware that required us to add these two entries in our .ini
> file?
>
> -----Original Message-----
> From: Greg Quinn [mailto:greg@officium.co.za]
> Sent: Friday, June 03, 2005 3:26 PM
> To: James Frankman
> Cc: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere else
> slow.
>
>
> Hi James,
>
> We had a problem when connecting to the database (with an ip address in
> the
> conneciton string) took 10-15 seconds and then suddenly the query
> results
> would appear instantly. This problem usually occurred if the internet
> connection was unavailable.
>
> Anyway, to solve this problem, we added the following lines to our .ini
> file
>
> skip-name-resolve
> skip-host-cache
>
> Try this, restart the MySQL Service and see if the problem persists.
>
> Greg
>
> ----- Original Message -----
> From: "James Frankman"
> To: "Daniel da Veiga" ;
> Sent: Friday, June 03, 2005 10:53 PM
> Subject: RE: Connections from localhost fast. Connections anywhere else
> slow.
>
>
>>
>> Thanks for the speedy response. You can't buy support this fast.
>>
>> -We are connecting via TCP/IP.
>>
>> -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.
>>
>> -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?
>>
>> -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.
>>
>> It is now obvious that this is a network issue as we are having
> problems
>> on other servers/software.
>>
>> 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.
>>
>>
>> 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.
>>
>> 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.
>>
>> 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).
>>
>> Anyway, give us more info...
>>
>> Best regards,
>>
>> 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=danieldaveiga@gmail.com
>>>
>>>
>>
>>
>> --
>> Daniel da Veiga
>> Computer Operator - RS - Brazil
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:
>> http://lists.mysql.com/win32?unsub=jfrankman@idfbins.com
>>
>>
>> --
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:
> http://lists.mysql.com/win32?unsub=greg@i-online.co.za
>>
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=ryan@nichecommerce.net
>



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

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

I hope it is addressed in an upcoming version. I love mySQL, but things
like this make me think about firing up my SQL Server box.

Weird thing is when this happened most of my team was out of the office
and the remainder of us were talking about scalability issues we need to
address before Christmas. Then BOOM, pagers and phones light up. I
guess we were thinking too far ahead.

I'll update this list with any findings I make today.

-----Original Message-----
From: Greg Quinn [mailto:greg@officium.co.za]=20
Sent: Saturday, June 04, 2005 8:53 AM
To: win32@lists.mysql.com
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.

Well, the only two factors that affected us were...

a.) The internet connection went down, or the way the network accessed
its=20
DNS server changed, or the DNS could not be found.
b.) The network server was changed to a domain controller.

So check if something along these lines changed on your network.

I must admit though I don't see the point if you supply an IP Address in
the=20
connection string why dns's and name resolutions should ever play a=20
factor??? Maybe this can be fixed in an updated version.

----- Original Message -----=20
From: "Ryan Paulson"
To: "James Frankman" ; "Greg Quinn"=20

Cc:
Sent: Saturday, June 04, 2005 3:18 PM
Subject: RE: Connections from localhost fast. Connections anywhere else=20
slow.


> We had this same problem yesterday. We are running 4.1.11a and out of
> no where our connections go crazy. We ripped apart our network before
> realizing it wasn't a network problem.
>
> I can not find what caused this to suddenly fail. I need to read up
on
> how and why mySQL tries to resolve these IPs. Why would it all of a
> sudden stop working after months of zero problems.
>
> If you ever figure it out, please let me know.
>
> -----Original Message-----
> From: James Frankman [mailto:jfrankman@idfbins.com]
> Sent: Friday, June 03, 2005 5:18 PM
> To: Greg Quinn
> Cc: win32@lists.mysql.com
> Subject: RE: Connections from localhost fast. Connections anywhere
else
> slow.
>
> That did it. MySQL is now quick as ever.
>
> I am confused about what these do. Why did MySQL work before I started
> experiencing the problems today? What changes could have occurred to
our
> network/hardware that required us to add these two entries in our .ini
> file?
>
> -----Original Message-----
> From: Greg Quinn [mailto:greg@officium.co.za]
> Sent: Friday, June 03, 2005 3:26 PM
> To: James Frankman
> Cc: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere
else
> slow.
>
>
> Hi James,
>
> We had a problem when connecting to the database (with an ip address
in
> the
> conneciton string) took 10-15 seconds and then suddenly the query
> results
> would appear instantly. This problem usually occurred if the internet
> connection was unavailable.
>
> Anyway, to solve this problem, we added the following lines to our
..ini
> file
>
> skip-name-resolve
> skip-host-cache
>
> Try this, restart the MySQL Service and see if the problem persists.
>
> Greg
>
> ----- Original Message -----=20
> From: "James Frankman"
> To: "Daniel da Veiga" ;

> Sent: Friday, June 03, 2005 10:53 PM
> Subject: RE: Connections from localhost fast. Connections anywhere
else
> slow.
>
>
>>
>> Thanks for the speedy response. You can't buy support this fast.
>>
>> -We are connecting via TCP/IP.
>>
>> -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.
>>
>> -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?
>>
>> -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.
>>
>> It is now obvious that this is a network issue as we are having
> problems
>> on other servers/software.
>>
>> 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.
>>
>>
>> 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.
>>
>> 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.
>>
>> 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).
>>
>> Anyway, give us more info...
>>
>> Best regards,
>>
>> 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
>> 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
>> MySQL Windows Mailing List
>> For list archives: http://lists.mysql.com/win32
>> To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dgreg@i-online.co.za
>>
>
>
>
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dryan@nichecommerce.net
>=20



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


--
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

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

This is not really a network problem, it is related to how the OS uses
the net, Windows is focused on the "let's make it work for MOST
people" stuff, so, they really put on effort on making the user's life
easier, thus decreasing other factors, like speed, stability and
hardware specific acceleration. I had the same problem here, so I
CLONED the server on a Linux box (just for fun), when I mean clone, I
mean I used the same machine, the same hardware and the same data, and
voila, the Linux server didn't suffer from the DNS lookup and gateway
lost problem (see, I'm not telling you to change your server OS, just
to realize you MAY have problems like that because the way the OS
works). The fact is that Windows (and TCP itself) is suppose to
deliver the packet, no matter how long it takes.

I'm not standing for Linux, we're a Windows list for a reason, MOST
people use it (for now), I'm just trying to clear the problem.
Adjusting your registry network settings may help :)

Best regards,

On 6/4/05, Ryan Paulson wrote:
> I hope it is addressed in an upcoming version. I love mySQL, but things
> like this make me think about firing up my SQL Server box.
>=20
> Weird thing is when this happened most of my team was out of the office
> and the remainder of us were talking about scalability issues we need to
> address before Christmas. Then BOOM, pagers and phones light up. I
> guess we were thinking too far ahead.
>=20
> I'll update this list with any findings I make today.
>=20
> -----Original Message-----
> From: Greg Quinn [mailto:greg@officium.co.za]
> Sent: Saturday, June 04, 2005 8:53 AM
> To: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere else
> slow.
>=20
> Well, the only two factors that affected us were...
>=20
> a.) The internet connection went down, or the way the network accessed
> its
> DNS server changed, or the DNS could not be found.
> b.) The network server was changed to a domain controller.
>=20
> So check if something along these lines changed on your network.
>=20
> I must admit though I don't see the point if you supply an IP Address in
> the
> connection string why dns's and name resolutions should ever play a
> factor??? Maybe this can be fixed in an updated version.
>=20
> ----- Original Message -----
> From: "Ryan Paulson"
> To: "James Frankman" ; "Greg Quinn"
>
> Cc:
> Sent: Saturday, June 04, 2005 3:18 PM
> Subject: RE: Connections from localhost fast. Connections anywhere else
> slow.
>=20
>=20
> > We had this same problem yesterday. We are running 4.1.11a and out of
> > no where our connections go crazy. We ripped apart our network before
> > realizing it wasn't a network problem.
> >
> > I can not find what caused this to suddenly fail. I need to read up
> on
> > how and why mySQL tries to resolve these IPs. Why would it all of a
> > sudden stop working after months of zero problems.
> >
> > If you ever figure it out, please let me know.
> >
> > -----Original Message-----
> > From: James Frankman [mailto:jfrankman@idfbins.com]
> > Sent: Friday, June 03, 2005 5:18 PM
> > To: Greg Quinn
> > Cc: win32@lists.mysql.com
> > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> > That did it. MySQL is now quick as ever.
> >
> > I am confused about what these do. Why did MySQL work before I started
> > experiencing the problems today? What changes could have occurred to
> our
> > network/hardware that required us to add these two entries in our .ini
> > file?
> >
> > -----Original Message-----
> > From: Greg Quinn [mailto:greg@officium.co.za]
> > Sent: Friday, June 03, 2005 3:26 PM
> > To: James Frankman
> > Cc: win32@lists.mysql.com
> > Subject: Re: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> > Hi James,
> >
> > We had a problem when connecting to the database (with an ip address
> in
> > the
> > conneciton string) took 10-15 seconds and then suddenly the query
> > results
> > would appear instantly. This problem usually occurred if the internet
> > connection was unavailable.
> >
> > Anyway, to solve this problem, we added the following lines to our
> .ini
> > file
> >
> > skip-name-resolve
> > skip-host-cache
> >
> > Try this, restart the MySQL Service and see if the problem persists.
> >
> > Greg
> >
> > ----- Original Message -----
> > From: "James Frankman"
> > To: "Daniel da Veiga" ;
>
> > Sent: Friday, June 03, 2005 10:53 PM
> > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> >>
> >> Thanks for the speedy response. You can't buy support this fast.
> >>
> >> -We are connecting via TCP/IP.
> >>
> >> -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.
> >>
> >> -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?
> >>
> >> -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.
> >>
> >> It is now obvious that this is a network issue as we are having
> > problems
> >> on other servers/software.
> >>
> >> 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.
> >>
> >>
> >> 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.
> >>
> >> 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.
> >>
> >> 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).
> >>
> >> Anyway, give us more info...
> >>
> >> Best regards,
> >>
> >> 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
> >>>
> >>>
> >>
> >>
> >> --
> >> Daniel da Veiga
> >> Computer Operator - RS - Brazil
> >>
> >> --
> >> 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=3Dgreg@i-online.co.za
> >>
> >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=3Dryan@nichecommerce.net
> >
>=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dryan@nichecommerce.net
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


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

--
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

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

I may be a littel late, but it sounds a lot like reverse DNS issues.
When your client connects to the server, the server looks up the name of the
client that is connecting. IOf there is no reverse DNS entry for it, it
keeps re-trying. I have seen these things take as much as a minute before
timing out. Check whether you have a reverse entry, or an entry in the hosts
file.
Another thing to check is to do a 'show processlist' during the connection
or during a query. The process list returned also tells you the client. If
this is an IP address, your server does not know the name of the client,
which indicates it's probably the issue.

----- Original Message -----
From: "James Frankman"
To: "Greg Quinn"
Cc:
Sent: Saturday, June 04, 2005 8:18 AM
Subject: RE: Connections from localhost fast. Connections anywhere else
slow.


> That did it. MySQL is now quick as ever.
>
> I am confused about what these do. Why did MySQL work before I started
experiencing the problems today? What changes could have occurred to our
network/hardware that required us to add these two entries in our .ini file?
>
> -----Original Message-----
> From: Greg Quinn [mailto:greg@officium.co.za]
> Sent: Friday, June 03, 2005 3:26 PM
> To: James Frankman
> Cc: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere else
> slow.
>
>
> Hi James,
>
> We had a problem when connecting to the database (with an ip address in
the
> conneciton string) took 10-15 seconds and then suddenly the query results
> would appear instantly. This problem usually occurred if the internet
> connection was unavailable.
>
> Anyway, to solve this problem, we added the following lines to our .ini
file
>
> skip-name-resolve
> skip-host-cache
>
> Try this, restart the MySQL Service and see if the problem persists.
>
> Greg
>
> ----- Original Message -----
> From: "James Frankman"
> To: "Daniel da Veiga" ;
> Sent: Friday, June 03, 2005 10:53 PM
> Subject: RE: Connections from localhost fast. Connections anywhere else
> slow.
>
>
> >
> > Thanks for the speedy response. You can't buy support this fast.
> >
> > -We are connecting via TCP/IP.
> >
> > -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.
> >
> > -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?
> >
> > -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.
> >
> > It is now obvious that this is a network issue as we are having problems
> > on other servers/software.
> >
> > 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.
> >
> >
> > 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.
> >
> > 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.
> >
> > 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).
> >
> > Anyway, give us more info...
> >
> > Best regards,
> >
> > 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=danieldaveiga@gmail.com
> >>
> >>
> >
> >
> > --
> > Daniel da Veiga
> > Computer Operator - RS - Brazil
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=jfrankman@idfbins.com
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
http://lists.mysql.com/win32?unsub=greg@i-online.co.za
> >
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless.c om.au
>


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

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

Leigh,

Just finished talking to our network admin. The reverse DNS lookup is =
indeed the problem. They had to enable the reverse DNS lookup on our =
"subnet" and everything started working fine.=20

I am still curious about what could have caused this to occur in the =
first place. We have been using MySQL for almost three years now and =
until Friday, we never had this problem. Our network admin swears no =
changes were made to the network configuration before this problem =
appeared last Friday. Do you have any ideas what could have triggered =
this problem? I see only two scenarios to consider:

1. MySQL never used the reverse DNS lookup until last Friday
2. Some network process or software changed our network configuration =
so that the reverse DNS lookup became disabled or removed somehow.

Like most analysts/programmers, I do not like a mysteries. I want to be =
able to explain why this happened all of the sudden so we can know how =
to prevent it from happening again. Any theories, ideas, or =
explanations would be appreciated.

-----Original Message-----
From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
Sent: Sunday, June 05, 2005 5:52 PM
To: James Frankman
Cc: win32@lists.mysql.com
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.


I may be a littel late, but it sounds a lot like reverse DNS issues.
When your client connects to the server, the server looks up the name of =
the
client that is connecting. IOf there is no reverse DNS entry for it, it
keeps re-trying. I have seen these things take as much as a minute =
before
timing out. Check whether you have a reverse entry, or an entry in the =
hosts
file.
Another thing to check is to do a 'show processlist' during the =
connection
or during a query. The process list returned also tells you the client. =
If
this is an IP address, your server does not know the name of the client,
which indicates it's probably the issue.

----- Original Message -----=20
From: "James Frankman"
To: "Greg Quinn"
Cc:
Sent: Saturday, June 04, 2005 8:18 AM
Subject: RE: Connections from localhost fast. Connections anywhere else
slow.


> That did it. MySQL is now quick as ever.
>
> I am confused about what these do. Why did MySQL work before I started
experiencing the problems today? What changes could have occurred to our
network/hardware that required us to add these two entries in our .ini =
file?
>
> -----Original Message-----
> From: Greg Quinn [mailto:greg@officium.co.za]
> Sent: Friday, June 03, 2005 3:26 PM
> To: James Frankman
> Cc: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere =
else
> slow.
>
>
> Hi James,
>
> We had a problem when connecting to the database (with an ip address =
in
the
> conneciton string) took 10-15 seconds and then suddenly the query =
results
> would appear instantly. This problem usually occurred if the internet
> connection was unavailable.
>
> Anyway, to solve this problem, we added the following lines to our =
..ini
file
>
> skip-name-resolve
> skip-host-cache
>
> Try this, restart the MySQL Service and see if the problem persists.
>
> Greg
>
> ----- Original Message -----=20
> From: "James Frankman"
> To: "Daniel da Veiga" ; =

> Sent: Friday, June 03, 2005 10:53 PM
> Subject: RE: Connections from localhost fast. Connections anywhere =
else
> slow.
>
>
> >
> > Thanks for the speedy response. You can't buy support this fast.
> >
> > -We are connecting via TCP/IP.
> >
> > -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.
> >
> > -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?
> >
> > -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.
> >
> > It is now obvious that this is a network issue as we are having =
problems
> > on other servers/software.
> >
> > 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.
> >
> >
> > 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.
> >
> > 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.
> >
> > 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).
> >
> > Anyway, give us more info...
> >
> > Best regards,
> >
> > 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
> > 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
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
http://lists.mysql.com/win32?unsub=3Dgreg@i-online.co.za
> >
>
>
>
> --=20
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwireless .com.au
>


--
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

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

Well, I can't really say what happened, but its indeed a mistery to be
solved, I've seen this problem occurs many times, and always enabled a
solution (you can see those by my previous messages) and never thought
about reverse DNS (for the same reason James's admins never did,
because I never changed anything on the network before the problem
happens), now that you realized what is the problem, it may be of help
to me and many users around that had the same problem and, like me,
searched alternatives that eventually worked. I have some questions:

1) Does it happen only on win32 systems? (as I said before, my Linux
box and a Mac running here never had problems, but maybe other people
had)

2) Its a network configuration issue (TCP/IP), or maybe related to how
MySQL uses the network, or another option, the way MySQL interacts
with the system's network interface?

That's why I love this lists :)

Best regards,

On 6/6/05, James Frankman wrote:
> Leigh,
>=20
> Just finished talking to our network admin. The reverse DNS lookup is ind=
eed the problem. They had to enable the reverse DNS lookup on our "subnet" =
and everything started working fine.
>=20
> I am still curious about what could have caused this to occur in the firs=
t place. We have been using MySQL for almost three years now and until Fri=
day, we never had this problem. Our network admin swears no changes were ma=
de to the network configuration before this problem appeared last Friday. D=
o you have any ideas what could have triggered this problem? I see only two=
scenarios to consider:
>=20
> 1. MySQL never used the reverse DNS lookup until last Friday
> 2. Some network process or software changed our network configura=
tion so that the reverse DNS lookup became disabled or removed someho=
w.
>=20
> Like most analysts/programmers, I do not like a mysteries. I want to be a=
ble to explain why this happened all of the sudden so we can know how to pr=
event it from happening again. Any theories, ideas, or explanations would =
be appreciated.
>=20
> -----Original Message-----
> From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> Sent: Sunday, June 05, 2005 5:52 PM
> To: James Frankman
> Cc: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere else
> slow.
>=20
>=20
> I may be a littel late, but it sounds a lot like reverse DNS issues.
> When your client connects to the server, the server looks up the name of =
the
> client that is connecting. IOf there is no reverse DNS entry for it, it
> keeps re-trying. I have seen these things take as much as a minute before
> timing out. Check whether you have a reverse entry, or an entry in the ho=
sts
> file.
> Another thing to check is to do a 'show processlist' during the connectio=
n
> or during a query. The process list returned also tells you the client. I=
f
> this is an IP address, your server does not know the name of the client,
> which indicates it's probably the issue.
>=20
> ----- Original Message -----
> From: "James Frankman"
> To: "Greg Quinn"
> Cc:
> Sent: Saturday, June 04, 2005 8:18 AM
> Subject: RE: Connections from localhost fast. Connections anywhere else
> slow.
>=20
>=20
> > That did it. MySQL is now quick as ever.
> >
> > I am confused about what these do. Why did MySQL work before I started
> experiencing the problems today? What changes could have occurred to our
> network/hardware that required us to add these two entries in our .ini fi=
le?
> >
> > -----Original Message-----
> > From: Greg Quinn [mailto:greg@officium.co.za]
> > Sent: Friday, June 03, 2005 3:26 PM
> > To: James Frankman
> > Cc: win32@lists.mysql.com
> > Subject: Re: Connections from localhost fast. Connections anywhere else
> > slow.
> >
> >
> > Hi James,
> >
> > We had a problem when connecting to the database (with an ip address in
> the
> > conneciton string) took 10-15 seconds and then suddenly the query resul=
ts
> > would appear instantly. This problem usually occurred if the internet
> > connection was unavailable.
> >
> > Anyway, to solve this problem, we added the following lines to our .ini
> file
> >
> > skip-name-resolve
> > skip-host-cache
> >
> > Try this, restart the MySQL Service and see if the problem persists.
> >
> > Greg
> >
> > ----- Original Message -----
> > From: "James Frankman"
> > To: "Daniel da Veiga" ; >
> > Sent: Friday, June 03, 2005 10:53 PM
> > Subject: RE: Connections from localhost fast. Connections anywhere else
> > slow.
> >
> >
> > >
> > > Thanks for the speedy response. You can't buy support this fast.
> > >
> > > -We are connecting via TCP/IP.
> > >
> > > -DNS servers appear to be working correctly. Even if they weren't we =
are
> > > experienceing problems when using the actual ip address. If I underst=
and
> > > my networking when you use the ip address, the DNS server is not used=
..
> > >
> > > -I tried your suggestions about the connect vs. query time. It takes
> > > several seconds to connect to MySQL, but query times are instantaneou=
s.
> It
> > > must be a network issue right?
> > >
> > > -We are noticing similar problems with other peices of software on ou=
r
> > > network that you connect to on a TCP port. We seem to be having probl=
ems
> > > 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.
> > >
> > > It is now obvious that this is a network issue as we are having probl=
ems
> > > on other servers/software.
> > >
> > > Not to waste the mysql list with troubleshooting a general networking
> > > issue, but if anyone has some ideas as why certain ports on our netwo=
rk
> > > 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 el=
se
> > > slow.
> > >
> > >
> > > This is one of those problems you have thousands of solutions for, bu=
t
> > > a few would aplly to your machine, network, server, client, protocols
> > > and environment specific configuration.
> > >
> > > 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.
> > >
> > > Another suggestion, use the MySQL client console from a remote machin=
e
> > > 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, colisio=
n
> > > or any other kind of packet loss (that may be caused by hardware
> > > configs).
> > >
> > > Anyway, give us more info...
> > >
> > > Best regards,
> > >
> > > 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 probl=
em
> > >> 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
> > >>
> > >>
> > >
> > >
> > > --
> > > Daniel da Veiga
> > > Computer Operator - RS - Brazil
> > >
> > > --
> > > 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=3Dgreg@i-online.co.za
> > >
> >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwireless .com.au
> >
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


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

--
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

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

>>1) Does it happen only on win32 systems? (as I said before, my Linux
box and a Mac running here never had problems, but maybe other people
had)

Unfortunately, we only run MySQL on Win32 :-(

>>2) Its a network configuration issue (TCP/IP), or maybe related to how
MySQL uses the network, or another option, the way MySQL interacts
with the system's network interface?

I'm not sure on this one. But, I beleive it is more of a general network =
issue. The reason I think this way is that we simultaneously had a =
problem with a TCP socket server from the third party vendor. This =
service would listen on port 211 and accept connections from activex =
controls embedded in Internet Explorer. Once the reverse DNS was enabled =
this service started working again. My guess is that this service must =
have tried to perform reverse DNS lookups just like MySQL does by =
default. So the problem was not just a MySQL issue, we had at least one =
other peice of software experiencing the same problem. Unfortunately, I =
only know the basics of networking, I could use someone with more =
network experience to help me investigate this problem. To me the =
fundamental question is what (if anything) can cause reverse DNS lookups =
to become disabled on a network?

-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
Sent: Monday, June 06, 2005 10:19 AM
To: MySQL Win32 List
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.


Well, I can't really say what happened, but its indeed a mistery to be
solved, I've seen this problem occurs many times, and always enabled a
solution (you can see those by my previous messages) and never thought
about reverse DNS (for the same reason James's admins never did,
because I never changed anything on the network before the problem
happens), now that you realized what is the problem, it may be of help
to me and many users around that had the same problem and, like me,
searched alternatives that eventually worked. I have some questions:

1) Does it happen only on win32 systems? (as I said before, my Linux
box and a Mac running here never had problems, but maybe other people
had)

2) Its a network configuration issue (TCP/IP), or maybe related to how
MySQL uses the network, or another option, the way MySQL interacts
with the system's network interface?

That's why I love this lists :)

Best regards,

On 6/6/05, James Frankman wrote:
> Leigh,
>=20
> Just finished talking to our network admin. The reverse DNS lookup is =
indeed the problem. They had to enable the reverse DNS lookup on our =
"subnet" and everything started working fine.
>=20
> I am still curious about what could have caused this to occur in the =
first place. We have been using MySQL for almost three years now and =
until Friday, we never had this problem. Our network admin swears no =
changes were made to the network configuration before this problem =
appeared last Friday. Do you have any ideas what could have triggered =
this problem? I see only two scenarios to consider:
>=20
> 1. MySQL never used the reverse DNS lookup until last Friday
> 2. Some network process or software changed our network =
configuration so that the reverse DNS lookup became disabled or =
removed somehow.
>=20
> Like most analysts/programmers, I do not like a mysteries. I want to =
be able to explain why this happened all of the sudden so we can know =
how to prevent it from happening again. Any theories, ideas, or =
explanations would be appreciated.
>=20
> -----Original Message-----
> From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> Sent: Sunday, June 05, 2005 5:52 PM
> To: James Frankman
> Cc: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere =
else
> slow.
>=20
>=20
> I may be a littel late, but it sounds a lot like reverse DNS issues.
> When your client connects to the server, the server looks up the name =
of the
> client that is connecting. IOf there is no reverse DNS entry for it, =
it
> keeps re-trying. I have seen these things take as much as a minute =
before
> timing out. Check whether you have a reverse entry, or an entry in the =
hosts
> file.
> Another thing to check is to do a 'show processlist' during the =
connection
> or during a query. The process list returned also tells you the =
client. If
> this is an IP address, your server does not know the name of the =
client,
> which indicates it's probably the issue.
>=20
> ----- Original Message -----
> From: "James Frankman"
> To: "Greg Quinn"
> Cc:
> Sent: Saturday, June 04, 2005 8:18 AM
> Subject: RE: Connections from localhost fast. Connections anywhere =
else
> slow.
>=20
>=20
> > That did it. MySQL is now quick as ever.
> >
> > I am confused about what these do. Why did MySQL work before I =
started
> experiencing the problems today? What changes could have occurred to =
our
> network/hardware that required us to add these two entries in our .ini =
file?
> >
> > -----Original Message-----
> > From: Greg Quinn [mailto:greg@officium.co.za]
> > Sent: Friday, June 03, 2005 3:26 PM
> > To: James Frankman
> > Cc: win32@lists.mysql.com
> > Subject: Re: Connections from localhost fast. Connections anywhere =
else
> > slow.
> >
> >
> > Hi James,
> >
> > We had a problem when connecting to the database (with an ip address =
in
> the
> > conneciton string) took 10-15 seconds and then suddenly the query =
results
> > would appear instantly. This problem usually occurred if the =
internet
> > connection was unavailable.
> >
> > Anyway, to solve this problem, we added the following lines to our =
..ini
> file
> >
> > skip-name-resolve
> > skip-host-cache
> >
> > Try this, restart the MySQL Service and see if the problem persists.
> >
> > Greg
> >
> > ----- Original Message -----
> > From: "James Frankman"
> > To: "Daniel da Veiga" ; =

> > Sent: Friday, June 03, 2005 10:53 PM
> > Subject: RE: Connections from localhost fast. Connections anywhere =
else
> > slow.
> >
> >
> > >
> > > Thanks for the speedy response. You can't buy support this fast.
> > >
> > > -We are connecting via TCP/IP.
> > >
> > > -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.
> > >
> > > -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?
> > >
> > > -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.
> > >
> > > It is now obvious that this is a network issue as we are having =
problems
> > > on other servers/software.
> > >
> > > 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.
> > >
> > >
> > > 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.
> > >
> > > 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.
> > >
> > > 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).
> > >
> > > Anyway, give us more info...
> > >
> > > Best regards,
> > >
> > > 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
> > >>
> > >>
> > >
> > >
> > > --
> > > Daniel da Veiga
> > > Computer Operator - RS - Brazil
> > >
> > > --
> > > 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=3Dgreg@i-online.co.za
> > >
> >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwireless .com.au
> >
>=20
>=20
> --
> 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


--=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

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

I too would enjoy an explanation of why this happens. =20

I am running Windows 2003 Standard Server. We have no domain or
internal DNS server and our "network" is running as a workgroup. All my
servers run MySQL 4.1.11a and when this problem started, it started
across all my DB servers. That is why I don't think it is limited to
MySQL, but why all of a sudden did it quite.


-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]=20
Sent: Monday, June 06, 2005 11:19 AM
To: MySQL Win32 List
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.

Well, I can't really say what happened, but its indeed a mistery to be
solved, I've seen this problem occurs many times, and always enabled a
solution (you can see those by my previous messages) and never thought
about reverse DNS (for the same reason James's admins never did,
because I never changed anything on the network before the problem
happens), now that you realized what is the problem, it may be of help
to me and many users around that had the same problem and, like me,
searched alternatives that eventually worked. I have some questions:

1) Does it happen only on win32 systems? (as I said before, my Linux
box and a Mac running here never had problems, but maybe other people
had)

2) Its a network configuration issue (TCP/IP), or maybe related to how
MySQL uses the network, or another option, the way MySQL interacts
with the system's network interface?

That's why I love this lists :)

Best regards,

On 6/6/05, James Frankman wrote:
> Leigh,
>=20
> Just finished talking to our network admin. The reverse DNS lookup is
indeed the problem. They had to enable the reverse DNS lookup on our
"subnet" and everything started working fine.
>=20
> I am still curious about what could have caused this to occur in the
first place. We have been using MySQL for almost three years now and
until Friday, we never had this problem. Our network admin swears no
changes were made to the network configuration before this problem
appeared last Friday. Do you have any ideas what could have triggered
this problem? I see only two scenarios to consider:
>=20
> 1. MySQL never used the reverse DNS lookup until last Friday
> 2. Some network process or software changed our network
configuration so that the reverse DNS lookup became disabled or
removed somehow.
>=20
> Like most analysts/programmers, I do not like a mysteries. I want to
be able to explain why this happened all of the sudden so we can know
how to prevent it from happening again. Any theories, ideas, or
explanations would be appreciated.
>=20
> -----Original Message-----
> From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> Sent: Sunday, June 05, 2005 5:52 PM
> To: James Frankman
> Cc: win32@lists.mysql.com
> Subject: Re: Connections from localhost fast. Connections anywhere
else
> slow.
>=20
>=20
> I may be a littel late, but it sounds a lot like reverse DNS issues.
> When your client connects to the server, the server looks up the name
of the
> client that is connecting. IOf there is no reverse DNS entry for it,
it
> keeps re-trying. I have seen these things take as much as a minute
before
> timing out. Check whether you have a reverse entry, or an entry in the
hosts
> file.
> Another thing to check is to do a 'show processlist' during the
connection
> or during a query. The process list returned also tells you the
client. If
> this is an IP address, your server does not know the name of the
client,
> which indicates it's probably the issue.
>=20
> ----- Original Message -----
> From: "James Frankman"
> To: "Greg Quinn"
> Cc:
> Sent: Saturday, June 04, 2005 8:18 AM
> Subject: RE: Connections from localhost fast. Connections anywhere
else
> slow.
>=20
>=20
> > That did it. MySQL is now quick as ever.
> >
> > I am confused about what these do. Why did MySQL work before I
started
> experiencing the problems today? What changes could have occurred to
our
> network/hardware that required us to add these two entries in our .ini
file?
> >
> > -----Original Message-----
> > From: Greg Quinn [mailto:greg@officium.co.za]
> > Sent: Friday, June 03, 2005 3:26 PM
> > To: James Frankman
> > Cc: win32@lists.mysql.com
> > Subject: Re: Connections from localhost fast. Connections anywhere
else
> > slow.
> >
> >
> > Hi James,
> >
> > We had a problem when connecting to the database (with an ip address
in
> the
> > conneciton string) took 10-15 seconds and then suddenly the query
results
> > would appear instantly. This problem usually occurred if the
internet
> > connection was unavailable.
> >
> > Anyway, to solve this problem, we added the following lines to our
..ini
> file
> >
> > skip-name-resolve
> > skip-host-cache
> >
> > Try this, restart the MySQL Service and see if the problem persists.
> >
> > Greg
> >
> > ----- Original Message -----
> > From: "James Frankman"
> > To: "Daniel da Veiga" ;

> > Sent: Friday, June 03, 2005 10:53 PM
> > Subject: RE: Connections from localhost fast. Connections anywhere
else
> > slow.
> >
> >
> > >
> > > Thanks for the speedy response. You can't buy support this fast.
> > >
> > > -We are connecting via TCP/IP.
> > >
> > > -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.
> > >
> > > -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?
> > >
> > > -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.
> > >
> > > It is now obvious that this is a network issue as we are having
problems
> > > on other servers/software.
> > >
> > > 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.
> > >
> > >
> > > 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.
> > >
> > > 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.
> > >
> > > 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).
> > >
> > > Anyway, give us more info...
> > >
> > > Best regards,
> > >
> > > 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
> > >>
> > >>
> > >
> > >
> > > --
> > > Daniel da Veiga
> > > Computer Operator - RS - Brazil
> > >
> > > --
> > > 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=3Dgreg@i-online.co.za
> > >
> >
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwireless .com.au
> >
>=20
>=20
> --
> 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


--=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=3Dryan@nichecommerce.net


--
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

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

--=_alternative 005D0B0085257018_=
Content-Type: text/plain; charset="US-ASCII"

"Ryan J. Paulson" wrote on 06/06/2005 12:47:21 PM:

> I too would enjoy an explanation of why this happens.

> I am running Windows 2003 Standard Server. We have no domain or
> internal DNS server and our "network" is running as a workgroup. All my
> servers run MySQL 4.1.11a and when this problem started, it started
> across all my DB servers. That is why I don't think it is limited to
> MySQL, but why all of a sudden did it quite.

>
> -----Original Message-----
> From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
> Sent: Monday, June 06, 2005 11:19 AM
> To: MySQL Win32 List
> Subject: Re: Connections from localhost fast. Connections anywhere else
> slow.

> Well, I can't really say what happened, but its indeed a mistery to be
> solved, I've seen this problem occurs many times, and always enabled a
> solution (you can see those by my previous messages) and never thought
> about reverse DNS (for the same reason James's admins never did,
> because I never changed anything on the network before the problem
> happens), now that you realized what is the problem, it may be of help
> to me and many users around that had the same problem and, like me,
> searched alternatives that eventually worked. I have some questions:

> 1) Does it happen only on win32 systems? (as I said before, my Linux
> box and a Mac running here never had problems, but maybe other people
> had)

> 2) Its a network configuration issue (TCP/IP), or maybe related to how
> MySQL uses the network, or another option, the way MySQL interacts
> with the system's network interface?

> That's why I love this lists :)

> Best regards,

> On 6/6/05, James Frankman wrote:
> > Leigh,
> >
> > Just finished talking to our network admin. The reverse DNS lookup is
> indeed the problem. They had to enable the reverse DNS lookup on our
> "subnet" and everything started working fine.
> >
> > I am still curious about what could have caused this to occur in the
> first place. We have been using MySQL for almost three years now and
> until Friday, we never had this problem. Our network admin swears no
> changes were made to the network configuration before this problem
> appeared last Friday. Do you have any ideas what could have triggered
> this problem? I see only two scenarios to consider:
> >
> > 1. MySQL never used the reverse DNS lookup until last Friday
> > 2. Some network process or software changed our network
> configuration so that the reverse DNS lookup became disabled or
> removed somehow.
> >
> > Like most analysts/programmers, I do not like a mysteries. I want to
> be able to explain why this happened all of the sudden so we can know
> how to prevent it from happening again. Any theories, ideas, or
> explanations would be appreciated.
> >
> > -----Original Message-----
> > From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> > Sent: Sunday, June 05, 2005 5:52 PM
> > To: James Frankman
> > Cc: win32@lists.mysql.com
> > Subject: Re: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> > I may be a littel late, but it sounds a lot like reverse DNS issues.
> > When your client connects to the server, the server looks up the name
> of the
> > client that is connecting. IOf there is no reverse DNS entry for it,
> it
> > keeps re-trying. I have seen these things take as much as a minute
> before
> > timing out. Check whether you have a reverse entry, or an entry in the
> hosts
> > file.
> > Another thing to check is to do a 'show processlist' during the
> connection
> > or during a query. The process list returned also tells you the
> client. If
> > this is an IP address, your server does not know the name of the
> client,
> > which indicates it's probably the issue.
> >
> > ----- Original Message -----
> > From: "James Frankman"
> > To: "Greg Quinn"
> > Cc:
> > Sent: Saturday, June 04, 2005 8:18 AM
> > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> > > That did it. MySQL is now quick as ever.
> > >
> > > I am confused about what these do. Why did MySQL work before I
> started
> > experiencing the problems today? What changes could have occurred to
> our
> > network/hardware that required us to add these two entries in our .ini
> file?
> > >
> > > -----Original Message-----
> > > From: Greg Quinn [mailto:greg@officium.co.za]
> > > Sent: Friday, June 03, 2005 3:26 PM
> > > To: James Frankman
> > > Cc: win32@lists.mysql.com
> > > Subject: Re: Connections from localhost fast. Connections anywhere
> else
> > > slow.
> > >
> > >
> > > Hi James,
> > >
> > > We had a problem when connecting to the database (with an ip address
> in
> > the
> > > conneciton string) took 10-15 seconds and then suddenly the query
> results
> > > would appear instantly. This problem usually occurred if the
> internet
> > > connection was unavailable.
> > >
> > > Anyway, to solve this problem, we added the following lines to our
> .ini
> > file
> > >
> > > skip-name-resolve
> > > skip-host-cache
> > >
> > > Try this, restart the MySQL Service and see if the problem persists.
> > >
> > > Greg
> > >
> > > ----- Original Message -----
> > > From: "James Frankman"
> > > To: "Daniel da Veiga" ;
>
> > > Sent: Friday, June 03, 2005 10:53 PM
> > > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > > slow.
> > >
> > >
> > > >
> > > > Thanks for the speedy response. You can't buy support this fast.
> > > >
> > > > -We are connecting via TCP/IP.
> > > >
> > > > -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.
> > > >
> > > > -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?
> > > >
> > > > -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.
> > > >
> > > > It is now obvious that this is a network issue as we are having
> problems
> > > > on other servers/software.
> > > >
> > > > 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.
> > > >
> > > >
> > > > 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.
> > > >
> > > > 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.
> > > >
> > > > 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).
> > > >
> > > > Anyway, give us more info...
> > > >
> > > > Best regards,
> > > >
> > > > 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.
> > > >>
> > > >>
> > > >
> > > >
> > > > --
> > > > Daniel da Veiga
> > > > Computer Operator - RS - Brazil
> > > >
> > > > --
> Daniel da Veiga
> Computer Operator - RS - Brazil

I am not sure of your issue timing but could it have been related to an
Automated Windows Update (patch)? That is one process that frequently
changes your settings without asking for permission and is generally
allowed to "do its thing" without a lot of supervision.

Different versions of the OS may have had their patches released on
different dates and any one of them may have turned off your Reverse DNS
lookups as a "security enhancement" or whatever Mr. Gate$ and his
"developers" are calling such things these days.

Why not check your update logs and see if the timings match up between a
patch install and the beginnings of your DNS problems? I suggest this
because this list has been getting more of these complaints than before
and that is one mechanism you may all have in common.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 005D0B0085257018_=--

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

I had the problem on Friday as well, then again this morning before I
changed any of my settings. I am running on Windows XP Pro. I just
think it is also weird that this started on Friday for several people as
well. Just too many similar things....

Since I turned off name resolution it seems to be running fine.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


Ryan Paulson wrote:

>I too would enjoy an explanation of why this happens.
>
>I am running Windows 2003 Standard Server. We have no domain or
>internal DNS server and our "network" is running as a workgroup. All my
>servers run MySQL 4.1.11a and when this problem started, it started
>across all my DB servers. That is why I don't think it is limited to
>MySQL, but why all of a sudden did it quite.
>
>
>-----Original Message-----
>From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
>Sent: Monday, June 06, 2005 11:19 AM
>To: MySQL Win32 List
>Subject: Re: Connections from localhost fast. Connections anywhere else
>slow.
>
>Well, I can't really say what happened, but its indeed a mistery to be
>solved, I've seen this problem occurs many times, and always enabled a
>solution (you can see those by my previous messages) and never thought
>about reverse DNS (for the same reason James's admins never did,
>because I never changed anything on the network before the problem
>happens), now that you realized what is the problem, it may be of help
>to me and many users around that had the same problem and, like me,
>searched alternatives that eventually worked. I have some questions:
>
>1) Does it happen only on win32 systems? (as I said before, my Linux
>box and a Mac running here never had problems, but maybe other people
>had)
>
>2) Its a network configuration issue (TCP/IP), or maybe related to how
>MySQL uses the network, or another option, the way MySQL interacts
>with the system's network interface?
>
>That's why I love this lists :)
>
>Best regards,
>
>On 6/6/05, James Frankman wrote:
>
>
>>Leigh,
>>
>>Just finished talking to our network admin. The reverse DNS lookup is
>>
>>
>indeed the problem. They had to enable the reverse DNS lookup on our
>"subnet" and everything started working fine.
>
>
>>I am still curious about what could have caused this to occur in the
>>
>>
>first place. We have been using MySQL for almost three years now and
>until Friday, we never had this problem. Our network admin swears no
>changes were made to the network configuration before this problem
>appeared last Friday. Do you have any ideas what could have triggered
>this problem? I see only two scenarios to consider:
>
>
>> 1. MySQL never used the reverse DNS lookup until last Friday
>> 2. Some network process or software changed our network
>>
>>
>configuration so that the reverse DNS lookup became disabled or
>removed somehow.
>
>
>>Like most analysts/programmers, I do not like a mysteries. I want to
>>
>>
>be able to explain why this happened all of the sudden so we can know
>how to prevent it from happening again. Any theories, ideas, or
>explanations would be appreciated.
>
>
>>-----Original Message-----
>>From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
>>Sent: Sunday, June 05, 2005 5:52 PM
>>To: James Frankman
>>Cc: win32@lists.mysql.com
>>Subject: Re: Connections from localhost fast. Connections anywhere
>>
>>
>else
>
>
>>slow.
>>
>>
>>I may be a littel late, but it sounds a lot like reverse DNS issues.
>>When your client connects to the server, the server looks up the name
>>
>>
>of the
>
>
>>client that is connecting. IOf there is no reverse DNS entry for it,
>>
>>
>it
>
>
>>keeps re-trying. I have seen these things take as much as a minute
>>
>>
>before
>
>
>>timing out. Check whether you have a reverse entry, or an entry in the
>>
>>
>hosts
>
>
>>file.
>>Another thing to check is to do a 'show processlist' during the
>>
>>
>connection
>
>
>>or during a query. The process list returned also tells you the
>>
>>
>client. If
>
>
>>this is an IP address, your server does not know the name of the
>>
>>
>client,
>
>
>>which indicates it's probably the issue.
>>
>>----- Original Message -----
>>From: "James Frankman"
>>To: "Greg Quinn"
>>Cc:
>>Sent: Saturday, June 04, 2005 8:18 AM
>>Subject: RE: Connections from localhost fast. Connections anywhere
>>
>>
>else
>
>
>>slow.
>>
>>
>>
>>
>>>That did it. MySQL is now quick as ever.
>>>
>>>I am confused about what these do. Why did MySQL work before I
>>>
>>>
>started
>
>
>>experiencing the problems today? What changes could have occurred to
>>
>>
>our
>
>
>>network/hardware that required us to add these two entries in our .ini
>>
>>
>file?
>
>
>>>-----Original Message-----
>>>From: Greg Quinn [mailto:greg@officium.co.za]
>>>Sent: Friday, June 03, 2005 3:26 PM
>>>To: James Frankman
>>>Cc: win32@lists.mysql.com
>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>
>>>
>else
>
>
>>>slow.
>>>
>>>
>>>Hi James,
>>>
>>>We had a problem when connecting to the database (with an ip address
>>>
>>>
>in
>
>
>>the
>>
>>
>>>conneciton string) took 10-15 seconds and then suddenly the query
>>>
>>>
>results
>
>
>>>would appear instantly. This problem usually occurred if the
>>>
>>>
>internet
>
>
>>>connection was unavailable.
>>>
>>>Anyway, to solve this problem, we added the following lines to our
>>>
>>>
>.ini
>
>
>>file
>>
>>
>>>skip-name-resolve
>>>skip-host-cache
>>>
>>>Try this, restart the MySQL Service and see if the problem persists.
>>>
>>>Greg
>>>
>>>----- Original Message -----
>>>From: "James Frankman"
>>>To: "Daniel da Veiga" ;
>>>
>>>
>
>
>
>>>Sent: Friday, June 03, 2005 10:53 PM
>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>
>>>
>else
>
>
>>>slow.
>>>
>>>
>>>
>>>
>>>>Thanks for the speedy response. You can't buy support this fast.
>>>>
>>>>-We are connecting via TCP/IP.
>>>>
>>>>-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.
>
>
>>>>-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?
>>>>
>>>>-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.
>>>>
>>>>It is now obvious that this is a network issue as we are having
>>>>
>>>>
>problems
>
>
>>>>on other servers/software.
>>>>
>>>>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.
>>>>
>>>>
>>>>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.
>>>>
>>>>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.
>>>>
>>>>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).
>>>>
>>>>Anyway, give us more info...
>>>>
>>>>Best regards,
>>>>
>>>>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=danieldaveiga@gmail. com
>>>>>
>>>>>
>>>>>
>>>>>
>>>>--
>>>>Daniel da Veiga
>>>>Computer Operator - RS - Brazil
>>>>
>>>>--
>>>>MySQL Windows Mailing List
>>>>For list archives: http://lists.mysql.com/win32
>>>>To unsubscribe:
>>>>http://lists.mysql.com/win32?unsub=jfrankman@idfbins.com
>>>>
>>>>
>>>>--
>>>>MySQL Windows Mailing List
>>>>For list archives: http://lists.mysql.com/win32
>>>>To unsubscribe:
>>>>
>>>>
>>http://lists.mysql.com/win32?unsub=greg@i-online.co.za
>>
>>
>>>--
>>>MySQL Windows Mailing List
>>>For list archives: http://lists.mysql.com/win32
>>>To unsubscribe:
>>>
>>>
>>http://lists.mysql.com/win32?unsub=lsharpe@pacificwireless .com.au
>>
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe:
>>
>>
>http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>
>>
>>
>
>
>
>

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

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

When it happened to me, all apps, including my web server, even
acessing using IP at the machine running the server was laggy, that's
why I think its a network issue, because as James said, not only MySQL
is affected...

But we never had reverse DNS, it all happens when our primary gateway
goes down or when our DNS server crashes...

On 6/6/05, Ryan Paulson wrote:
> I too would enjoy an explanation of why this happens.
>=20
> I am running Windows 2003 Standard Server. We have no domain or
> internal DNS server and our "network" is running as a workgroup. All my
> servers run MySQL 4.1.11a and when this problem started, it started
> across all my DB servers. That is why I don't think it is limited to
> MySQL, but why all of a sudden did it quite.
>=20
>=20
> -----Original Message-----
> From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
> Sent: Monday, June 06, 2005 11:19 AM
> To: MySQL Win32 List
> Subject: Re: Connections from localhost fast. Connections anywhere else
> slow.
>=20
> Well, I can't really say what happened, but its indeed a mistery to be
> solved, I've seen this problem occurs many times, and always enabled a
> solution (you can see those by my previous messages) and never thought
> about reverse DNS (for the same reason James's admins never did,
> because I never changed anything on the network before the problem
> happens), now that you realized what is the problem, it may be of help
> to me and many users around that had the same problem and, like me,
> searched alternatives that eventually worked. I have some questions:
>=20
> 1) Does it happen only on win32 systems? (as I said before, my Linux
> box and a Mac running here never had problems, but maybe other people
> had)
>=20
> 2) Its a network configuration issue (TCP/IP), or maybe related to how
> MySQL uses the network, or another option, the way MySQL interacts
> with the system's network interface?
>=20
> That's why I love this lists :)
>=20
> Best regards,
>=20
> On 6/6/05, James Frankman wrote:
> > Leigh,
> >
> > Just finished talking to our network admin. The reverse DNS lookup is
> indeed the problem. They had to enable the reverse DNS lookup on our
> "subnet" and everything started working fine.
> >
> > I am still curious about what could have caused this to occur in the
> first place. We have been using MySQL for almost three years now and
> until Friday, we never had this problem. Our network admin swears no
> changes were made to the network configuration before this problem
> appeared last Friday. Do you have any ideas what could have triggered
> this problem? I see only two scenarios to consider:
> >
> > 1. MySQL never used the reverse DNS lookup until last Friday
> > 2. Some network process or software changed our network
> configuration so that the reverse DNS lookup became disabled or
> removed somehow.
> >
> > Like most analysts/programmers, I do not like a mysteries. I want to
> be able to explain why this happened all of the sudden so we can know
> how to prevent it from happening again. Any theories, ideas, or
> explanations would be appreciated.
> >
> > -----Original Message-----
> > From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> > Sent: Sunday, June 05, 2005 5:52 PM
> > To: James Frankman
> > Cc: win32@lists.mysql.com
> > Subject: Re: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> > I may be a littel late, but it sounds a lot like reverse DNS issues.
> > When your client connects to the server, the server looks up the name
> of the
> > client that is connecting. IOf there is no reverse DNS entry for it,
> it
> > keeps re-trying. I have seen these things take as much as a minute
> before
> > timing out. Check whether you have a reverse entry, or an entry in the
> hosts
> > file.
> > Another thing to check is to do a 'show processlist' during the
> connection
> > or during a query. The process list returned also tells you the
> client. If
> > this is an IP address, your server does not know the name of the
> client,
> > which indicates it's probably the issue.
> >
> > ----- Original Message -----
> > From: "James Frankman"
> > To: "Greg Quinn"
> > Cc:
> > Sent: Saturday, June 04, 2005 8:18 AM
> > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> > > That did it. MySQL is now quick as ever.
> > >
> > > I am confused about what these do. Why did MySQL work before I
> started
> > experiencing the problems today? What changes could have occurred to
> our
> > network/hardware that required us to add these two entries in our .ini
> file?
> > >
> > > -----Original Message-----
> > > From: Greg Quinn [mailto:greg@officium.co.za]
> > > Sent: Friday, June 03, 2005 3:26 PM
> > > To: James Frankman
> > > Cc: win32@lists.mysql.com
> > > Subject: Re: Connections from localhost fast. Connections anywhere
> else
> > > slow.
> > >
> > >
> > > Hi James,
> > >
> > > We had a problem when connecting to the database (with an ip address
> in
> > the
> > > conneciton string) took 10-15 seconds and then suddenly the query
> results
> > > would appear instantly. This problem usually occurred if the
> internet
> > > connection was unavailable.
> > >
> > > Anyway, to solve this problem, we added the following lines to our
> .ini
> > file
> > >
> > > skip-name-resolve
> > > skip-host-cache
> > >
> > > Try this, restart the MySQL Service and see if the problem persists.
> > >
> > > Greg
> > >
> > > ----- Original Message -----
> > > From: "James Frankman"
> > > To: "Daniel da Veiga" ;
>
> > > Sent: Friday, June 03, 2005 10:53 PM
> > > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > > slow.
> > >
> > >
> > > >
> > > > Thanks for the speedy response. You can't buy support this fast.
> > > >
> > > > -We are connecting via TCP/IP.
> > > >
> > > > -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.
> > > >
> > > > -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?
> > > >
> > > > -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.
> > > >
> > > > It is now obvious that this is a network issue as we are having
> problems
> > > > on other servers/software.
> > > >
> > > > 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.
> > > >
> > > >
> > > > 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.
> > > >
> > > > 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.
> > > >
> > > > 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).
> > > >
> > > > Anyway, give us more info...
> > > >
> > > > Best regards,
> > > >
> > > > 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
> > > >>
> > > >>
> > > >
> > > >
> > > > --
> > > > Daniel da Veiga
> > > > Computer Operator - RS - Brazil
> > > >
> > > > --
> > > > 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=3Dgreg@i-online.co.za
> > > >
> > >
> > >
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwireless .com.au
> > >
> >
> >
> > --
> > 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=3Dryan@nichecommerce.net
>=20
>=20


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

--
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

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

I also find it interesting that this has happened on Friday for several =
others. Is it possible a scheduled Windows patch took place on Friday?

-----Original Message-----
From: Brandon Schenz [mailto:brandons@midwestsports.com]
Sent: Monday, June 06, 2005 10:57 AM
To: MySQL Win32 List
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.


I had the problem on Friday as well, then again this morning before I=20
changed any of my settings. I am running on Windows XP Pro. I just=20
think it is also weird that this started on Friday for several people as =

well. Just too many similar things....

Since I turned off name resolution it seems to be running fine.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


Ryan Paulson wrote:

>I too would enjoy an explanation of why this happens. =20
>
>I am running Windows 2003 Standard Server. We have no domain or
>internal DNS server and our "network" is running as a workgroup. All =
my
>servers run MySQL 4.1.11a and when this problem started, it started
>across all my DB servers. That is why I don't think it is limited to
>MySQL, but why all of a sudden did it quite.
>
>
>-----Original Message-----
>From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]=20
>Sent: Monday, June 06, 2005 11:19 AM
>To: MySQL Win32 List
>Subject: Re: Connections from localhost fast. Connections anywhere else
>slow.
>
>Well, I can't really say what happened, but its indeed a mistery to be
>solved, I've seen this problem occurs many times, and always enabled a
>solution (you can see those by my previous messages) and never thought
>about reverse DNS (for the same reason James's admins never did,
>because I never changed anything on the network before the problem
>happens), now that you realized what is the problem, it may be of help
>to me and many users around that had the same problem and, like me,
>searched alternatives that eventually worked. I have some questions:
>
>1) Does it happen only on win32 systems? (as I said before, my Linux
>box and a Mac running here never had problems, but maybe other people
>had)
>
>2) Its a network configuration issue (TCP/IP), or maybe related to how
>MySQL uses the network, or another option, the way MySQL interacts
>with the system's network interface?
>
>That's why I love this lists :)
>
>Best regards,
>
>On 6/6/05, James Frankman wrote:
> =20
>
>>Leigh,
>>
>>Just finished talking to our network admin. The reverse DNS lookup is
>> =20
>>
>indeed the problem. They had to enable the reverse DNS lookup on our
>"subnet" and everything started working fine.
> =20
>
>>I am still curious about what could have caused this to occur in the
>> =20
>>
>first place. We have been using MySQL for almost three years now and
>until Friday, we never had this problem. Our network admin swears no
>changes were made to the network configuration before this problem
>appeared last Friday. Do you have any ideas what could have triggered
>this problem? I see only two scenarios to consider:
> =20
>
>> 1. MySQL never used the reverse DNS lookup until last Friday
>> 2. Some network process or software changed our network
>> =20
>>
>configuration so that the reverse DNS lookup became disabled or
>removed somehow.
> =20
>
>>Like most analysts/programmers, I do not like a mysteries. I want to
>> =20
>>
>be able to explain why this happened all of the sudden so we can know
>how to prevent it from happening again. Any theories, ideas, or
>explanations would be appreciated.
> =20
>
>>-----Original Message-----
>>From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
>>Sent: Sunday, June 05, 2005 5:52 PM
>>To: James Frankman
>>Cc: win32@lists.mysql.com
>>Subject: Re: Connections from localhost fast. Connections anywhere
>> =20
>>
>else
> =20
>
>>slow.
>>
>>
>>I may be a littel late, but it sounds a lot like reverse DNS issues.
>>When your client connects to the server, the server looks up the name
>> =20
>>
>of the
> =20
>
>>client that is connecting. IOf there is no reverse DNS entry for it,
>> =20
>>
>it
> =20
>
>>keeps re-trying. I have seen these things take as much as a minute
>> =20
>>
>before
> =20
>
>>timing out. Check whether you have a reverse entry, or an entry in the
>> =20
>>
>hosts
> =20
>
>>file.
>>Another thing to check is to do a 'show processlist' during the
>> =20
>>
>connection
> =20
>
>>or during a query. The process list returned also tells you the
>> =20
>>
>client. If
> =20
>
>>this is an IP address, your server does not know the name of the
>> =20
>>
>client,
> =20
>
>>which indicates it's probably the issue.
>>
>>----- Original Message -----
>>From: "James Frankman"
>>To: "Greg Quinn"
>>Cc:
>>Sent: Saturday, June 04, 2005 8:18 AM
>>Subject: RE: Connections from localhost fast. Connections anywhere
>> =20
>>
>else
> =20
>
>>slow.
>>
>>
>> =20
>>
>>>That did it. MySQL is now quick as ever.
>>>
>>>I am confused about what these do. Why did MySQL work before I
>>> =20
>>>
>started
> =20
>
>>experiencing the problems today? What changes could have occurred to
>> =20
>>
>our
> =20
>
>>network/hardware that required us to add these two entries in our .ini
>> =20
>>
>file?
> =20
>
>>>-----Original Message-----
>>>From: Greg Quinn [mailto:greg@officium.co.za]
>>>Sent: Friday, June 03, 2005 3:26 PM
>>>To: James Frankman
>>>Cc: win32@lists.mysql.com
>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>> =20
>>>
>else
> =20
>
>>>slow.
>>>
>>>
>>>Hi James,
>>>
>>>We had a problem when connecting to the database (with an ip address
>>> =20
>>>
>in
> =20
>
>>the
>> =20
>>
>>>conneciton string) took 10-15 seconds and then suddenly the query
>>> =20
>>>
>results
> =20
>
>>>would appear instantly. This problem usually occurred if the
>>> =20
>>>
>internet
> =20
>
>>>connection was unavailable.
>>>
>>>Anyway, to solve this problem, we added the following lines to our
>>> =20
>>>
>.ini
> =20
>
>>file
>> =20
>>
>>>skip-name-resolve
>>>skip-host-cache
>>>
>>>Try this, restart the MySQL Service and see if the problem persists.
>>>
>>>Greg
>>>
>>>----- Original Message -----
>>>From: "James Frankman"
>>>To: "Daniel da Veiga" ;
>>> =20
>>>
>
> =20
>
>>>Sent: Friday, June 03, 2005 10:53 PM
>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>> =20
>>>
>else
> =20
>
>>>slow.
>>>
>>>
>>> =20
>>>
>>>>Thanks for the speedy response. You can't buy support this fast.
>>>>
>>>>-We are connecting via TCP/IP.
>>>>
>>>>-DNS servers appear to be working correctly. Even if they weren't
>>>> =20
>>>>
>we are
> =20
>
>>>>experienceing problems when using the actual ip address. If I
>>>> =20
>>>>
>understand
> =20
>
>>>>my networking when you use the ip address, the DNS server is not
>>>> =20
>>>>
>used.
> =20
>
>>>>-I tried your suggestions about the connect vs. query time. It
>>>> =20
>>>>
>takes
> =20
>
>>>>several seconds to connect to MySQL, but query times are
>>>> =20
>>>>
>instantaneous.
> =20
>
>>It
>> =20
>>
>>>>must be a network issue right?
>>>>
>>>>-We are noticing similar problems with other peices of software on
>>>> =20
>>>>
>our
> =20
>
>>>>network that you connect to on a TCP port. We seem to be having
>>>> =20
>>>>
>problems
> =20
>
>>>>with port 211 on a completely separate server. However our web
>>>> =20
>>>>
>server
> =20
>
>>and
>> =20
>>
>>>>ftp servers respond fine. They are on ports 80 and 23 I think.
>>>>
>>>>It is now obvious that this is a network issue as we are having
>>>> =20
>>>>
>problems
> =20
>
>>>>on other servers/software.
>>>>
>>>>Not to waste the mysql list with troubleshooting a general
>>>> =20
>>>>
>networking
> =20
>
>>>>issue, but if anyone has some ideas as why certain ports on our
>>>> =20
>>>>
>network
> =20
>
>>>>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
>>>> =20
>>>>
>else
> =20
>
>>>>slow.
>>>>
>>>>
>>>>This is one of those problems you have thousands of solutions for,
>>>> =20
>>>>
>but
> =20
>
>>>>a few would aplly to your machine, network, server, client,
>>>> =20
>>>>
>protocols
> =20
>
>>>>and environment specific configuration.
>>>>
>>>>First, how are you trying to connect? TCP/IP? If so, then you
>>>> =20
>>>>
>should
> =20
>
>>>>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
>>>> =20
>>>>
>properly?
> =20
>
>>>>When MySQL (and any other tcp program) try to resolve names, it
>>>> =20
>>>>
>takes
> =20
>
>>>>a long time if it can't find a name server, even if you're using
>>>>direct IP addressing.
>>>>
>>>>Another suggestion, use the MySQL client console from a remote
>>>> =20
>>>>
>machine
> =20
>
>>>>and see if what takes time is the CONNECTION or the QUERY, because
>>>> =20
>>>>
>if
> =20
>
>>>>its the connection, than your network isn't configured properly,
>>>> =20
>>>>
>but
> =20
>
>>>>if the QUERIES are slow too, then you may have fragmentation,
>>>> =20
>>>>
>colision
> =20
>
>>>>or any other kind of packet loss (that may be caused by hardware
>>>>configs).
>>>>
>>>>Anyway, give us more info...
>>>>
>>>>Best regards,
>>>>
>>>>On 6/3/05, James Frankman wrote:
>>>> =20
>>>>
>>>>>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
>>>>> =20
>>>>>
>we use
> =20
>
>>>>>its ip address to connect it is extremely slow. Other network
>>>>> =20
>>>>>
>>connections
>> =20
>>
>>>>>to our MySQL server do not seem slow. Any help diagnosing this
>>>>> =20
>>>>>
>problem
> =20
>
>>>>>would be helpful.
>>>>>
>>>>>--
>>>>>MySQL Windows Mailing List
>>>>>For list archives: http://lists.mysql.com/win32
>>>>>To unsubscribe:
>>>>>http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmai l.com
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>>--
>>>>Daniel da Veiga
>>>>Computer Operator - RS - Brazil
>>>>
>>>>--
>>>>MySQL Windows Mailing List
>>>>For list archives: http://lists.mysql.com/win32
>>>>To unsubscribe:
>>>>http://lists.mysql.com/win32?unsub=3Djfrankman@idfbins.c om
>>>>
>>>>
>>>>--
>>>>MySQL Windows Mailing List
>>>>For list archives: http://lists.mysql.com/win32
>>>>To unsubscribe:
>>>> =20
>>>>
>>http://lists.mysql.com/win32?unsub=3Dgreg@i-online.co.za
>> =20
>>
>>>--
>>>MySQL Windows Mailing List
>>>For list archives: http://lists.mysql.com/win32
>>>To unsubscribe:
>>> =20
>>>
>>http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwirele ss.com.au
>> =20
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe:
>> =20
>>
>http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.co m
> =20
>
>> =20
>>
>
>
> =20
>

--=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

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

Another thought I have: is it possible some anti-spyware or anti-virus =
package caused this problem. I know this if much less likely to be the =
culprit, but thought I should bring it up.=20

-As far as anti-virus we use Symantec. Not sure what anti-spyware tools =
we use.

-----Original Message-----
From: SGreen@unimin.com [mailto:SGreen@unimin.com]
Sent: Monday, June 06, 2005 10:53 AM
To: Ryan Paulson
Cc: Daniel da Veiga; Ryan J. Paulson; MySQL Win32 List
Subject: RE: Connections from localhost fast. Connections anywhere else
slow.


"Ryan J. Paulson" wrote on 06/06/2005 12:47:21 =
PM:

> I too would enjoy an explanation of why this happens.

> I am running Windows 2003 Standard Server. We have no domain or
> internal DNS server and our "network" is running as a workgroup. All =
my
> servers run MySQL 4.1.11a and when this problem started, it started
> across all my DB servers. That is why I don't think it is limited to
> MySQL, but why all of a sudden did it quite.

>=20
> -----Original Message-----
> From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
> Sent: Monday, June 06, 2005 11:19 AM
> To: MySQL Win32 List
> Subject: Re: Connections from localhost fast. Connections anywhere =
else
> slow.

> Well, I can't really say what happened, but its indeed a mistery to be
> solved, I've seen this problem occurs many times, and always enabled a
> solution (you can see those by my previous messages) and never thought
> about reverse DNS (for the same reason James's admins never did,
> because I never changed anything on the network before the problem
> happens), now that you realized what is the problem, it may be of help
> to me and many users around that had the same problem and, like me,
> searched alternatives that eventually worked. I have some questions:

> 1) Does it happen only on win32 systems? (as I said before, my Linux
> box and a Mac running here never had problems, but maybe other people
> had)

> 2) Its a network configuration issue (TCP/IP), or maybe related to how
> MySQL uses the network, or another option, the way MySQL interacts
> with the system's network interface?

> That's why I love this lists :)

> Best regards,

> On 6/6/05, James Frankman wrote:
> > Leigh,
> >
> > Just finished talking to our network admin. The reverse DNS lookup =
is
> indeed the problem. They had to enable the reverse DNS lookup on our
> "subnet" and everything started working fine.
> >
> > I am still curious about what could have caused this to occur in the
> first place. We have been using MySQL for almost three years now and
> until Friday, we never had this problem. Our network admin swears no
> changes were made to the network configuration before this problem
> appeared last Friday. Do you have any ideas what could have triggered
> this problem? I see only two scenarios to consider:
> >
> > 1. MySQL never used the reverse DNS lookup until last Friday
> > 2. Some network process or software changed our network
> configuration so that the reverse DNS lookup became disabled or
> removed somehow.
> >
> > Like most analysts/programmers, I do not like a mysteries. I want to
> be able to explain why this happened all of the sudden so we can know
> how to prevent it from happening again. Any theories, ideas, or
> explanations would be appreciated.
> >
> > -----Original Message-----
> > From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> > Sent: Sunday, June 05, 2005 5:52 PM
> > To: James Frankman
> > Cc: win32@lists.mysql.com
> > Subject: Re: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> > I may be a littel late, but it sounds a lot like reverse DNS issues.
> > When your client connects to the server, the server looks up the =
name
> of the
> > client that is connecting. IOf there is no reverse DNS entry for it,
> it
> > keeps re-trying. I have seen these things take as much as a minute
> before
> > timing out. Check whether you have a reverse entry, or an entry in =
the
> hosts
> > file.
> > Another thing to check is to do a 'show processlist' during the
> connection
> > or during a query. The process list returned also tells you the
> client. If
> > this is an IP address, your server does not know the name of the
> client,
> > which indicates it's probably the issue.
> >
> > ----- Original Message -----
> > From: "James Frankman"
> > To: "Greg Quinn"
> > Cc:
> > Sent: Saturday, June 04, 2005 8:18 AM
> > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > slow.
> >
> >
> > > That did it. MySQL is now quick as ever.
> > >
> > > I am confused about what these do. Why did MySQL work before I
> started
> > experiencing the problems today? What changes could have occurred to
> our
> > network/hardware that required us to add these two entries in our =
..ini
> file?
> > >
> > > -----Original Message-----
> > > From: Greg Quinn [mailto:greg@officium.co.za]
> > > Sent: Friday, June 03, 2005 3:26 PM
> > > To: James Frankman
> > > Cc: win32@lists.mysql.com
> > > Subject: Re: Connections from localhost fast. Connections anywhere
> else
> > > slow.
> > >
> > >
> > > Hi James,
> > >
> > > We had a problem when connecting to the database (with an ip =
address
> in
> > the
> > > conneciton string) took 10-15 seconds and then suddenly the query
> results
> > > would appear instantly. This problem usually occurred if the
> internet
> > > connection was unavailable.
> > >
> > > Anyway, to solve this problem, we added the following lines to our
> .ini
> > file
> > >
> > > skip-name-resolve
> > > skip-host-cache
> > >
> > > Try this, restart the MySQL Service and see if the problem =
persists.
> > >
> > > Greg
> > >
> > > ----- Original Message -----
> > > From: "James Frankman"
> > > To: "Daniel da Veiga" ;
>
> > > Sent: Friday, June 03, 2005 10:53 PM
> > > Subject: RE: Connections from localhost fast. Connections anywhere
> else
> > > slow.
> > >
> > >
> > > >
> > > > Thanks for the speedy response. You can't buy support this fast.
> > > >
> > > > -We are connecting via TCP/IP.
> > > >
> > > > -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.
> > > >
> > > > -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?
> > > >
> > > > -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.
> > > >
> > > > It is now obvious that this is a network issue as we are having
> problems
> > > > on other servers/software.
> > > >
> > > > 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.
> > > >
> > > >
> > > > 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.
> > > >
> > > > 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.
> > > >
> > > > 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).
> > > >
> > > > Anyway, give us more info...
> > > >
> > > > Best regards,
> > > >
> > > > 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.
> > > >>
> > > >>
> > > >
> > > >
> > > > --
> > > > Daniel da Veiga
> > > > Computer Operator - RS - Brazil
> > > >
> > > > --
> Daniel da Veiga
> Computer Operator - RS - Brazil

I am not sure of your issue timing but could it have been related to an=20
Automated Windows Update (patch)? That is one process that frequently=20
changes your settings without asking for permission and is generally=20
allowed to "do its thing" without a lot of supervision.=20

Different versions of the OS may have had their patches released on=20
different dates and any one of them may have turned off your Reverse DNS =

lookups as a "security enhancement" or whatever Mr. Gate$ and his=20
"developers" are calling such things these days.

Why not check your update logs and see if the timings match up between a =

patch install and the beginnings of your DNS problems? I suggest this=20
because this list has been getting more of these complaints than before=20
and that is one mechanism you may all have in common.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

--
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

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

We do not have an anti-spyware package on the mySQL computer, and use
AVG as anti-virus. I'm going to look at the update logs here in a
little bit.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


James Frankman wrote:

>Another thought I have: is it possible some anti-spyware or anti-virus package caused this problem. I know this if much less likely to be the culprit, but thought I should bring it up.
>
>-As far as anti-virus we use Symantec. Not sure what anti-spyware tools we use.
>
>-----Original Message-----
>From: SGreen@unimin.com [mailto:SGreen@unimin.com]
>Sent: Monday, June 06, 2005 10:53 AM
>To: Ryan Paulson
>Cc: Daniel da Veiga; Ryan J. Paulson; MySQL Win32 List
>Subject: RE: Connections from localhost fast. Connections anywhere else
>slow.
>
>
>"Ryan J. Paulson" wrote on 06/06/2005 12:47:21 PM:
>
>
>
>>I too would enjoy an explanation of why this happens.
>>
>>
>
>
>
>>I am running Windows 2003 Standard Server. We have no domain or
>>internal DNS server and our "network" is running as a workgroup. All my
>>servers run MySQL 4.1.11a and when this problem started, it started
>>across all my DB servers. That is why I don't think it is limited to
>>MySQL, but why all of a sudden did it quite.
>>
>>
>
>
>
>>-----Original Message-----
>>From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
>>Sent: Monday, June 06, 2005 11:19 AM
>>To: MySQL Win32 List
>>Subject: Re: Connections from localhost fast. Connections anywhere else
>>slow.
>>
>>
>
>
>
>>Well, I can't really say what happened, but its indeed a mistery to be
>>solved, I've seen this problem occurs many times, and always enabled a
>>solution (you can see those by my previous messages) and never thought
>>about reverse DNS (for the same reason James's admins never did,
>>because I never changed anything on the network before the problem
>>happens), now that you realized what is the problem, it may be of help
>>to me and many users around that had the same problem and, like me,
>>searched alternatives that eventually worked. I have some questions:
>>
>>
>
>
>
>>1) Does it happen only on win32 systems? (as I said before, my Linux
>>box and a Mac running here never had problems, but maybe other people
>>had)
>>
>>
>
>
>
>>2) Its a network configuration issue (TCP/IP), or maybe related to how
>>MySQL uses the network, or another option, the way MySQL interacts
>>with the system's network interface?
>>
>>
>
>
>
>>That's why I love this lists :)
>>
>>
>
>
>
>>Best regards,
>>
>>
>
>
>
>>On 6/6/05, James Frankman wrote:
>>
>>
>>>Leigh,
>>>
>>>Just finished talking to our network admin. The reverse DNS lookup is
>>>
>>>
>>indeed the problem. They had to enable the reverse DNS lookup on our
>>"subnet" and everything started working fine.
>>
>>
>>>I am still curious about what could have caused this to occur in the
>>>
>>>
>>first place. We have been using MySQL for almost three years now and
>>until Friday, we never had this problem. Our network admin swears no
>>changes were made to the network configuration before this problem
>>appeared last Friday. Do you have any ideas what could have triggered
>>this problem? I see only two scenarios to consider:
>>
>>
>>> 1. MySQL never used the reverse DNS lookup until last Friday
>>> 2. Some network process or software changed our network
>>>
>>>
>>configuration so that the reverse DNS lookup became disabled or
>>removed somehow.
>>
>>
>>>Like most analysts/programmers, I do not like a mysteries. I want to
>>>
>>>
>>be able to explain why this happened all of the sudden so we can know
>>how to prevent it from happening again. Any theories, ideas, or
>>explanations would be appreciated.
>>
>>
>>>-----Original Message-----
>>>From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
>>>Sent: Sunday, June 05, 2005 5:52 PM
>>>To: James Frankman
>>>Cc: win32@lists.mysql.com
>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>
>>>
>>else
>>
>>
>>>slow.
>>>
>>>
>>>I may be a littel late, but it sounds a lot like reverse DNS issues.
>>>When your client connects to the server, the server looks up the name
>>>
>>>
>>of the
>>
>>
>>>client that is connecting. IOf there is no reverse DNS entry for it,
>>>
>>>
>>it
>>
>>
>>>keeps re-trying. I have seen these things take as much as a minute
>>>
>>>
>>before
>>
>>
>>>timing out. Check whether you have a reverse entry, or an entry in the
>>>
>>>
>>hosts
>>
>>
>>>file.
>>>Another thing to check is to do a 'show processlist' during the
>>>
>>>
>>connection
>>
>>
>>>or during a query. The process list returned also tells you the
>>>
>>>
>>client. If
>>
>>
>>>this is an IP address, your server does not know the name of the
>>>
>>>
>>client,
>>
>>
>>>which indicates it's probably the issue.
>>>
>>>----- Original Message -----
>>>From: "James Frankman"
>>>To: "Greg Quinn"
>>>Cc:
>>>Sent: Saturday, June 04, 2005 8:18 AM
>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>
>>>
>>else
>>
>>
>>>slow.
>>>
>>>
>>>
>>>
>>>>That did it. MySQL is now quick as ever.
>>>>
>>>>I am confused about what these do. Why did MySQL work before I
>>>>
>>>>
>>started
>>
>>
>>>experiencing the problems today? What changes could have occurred to
>>>
>>>
>>our
>>
>>
>>>network/hardware that required us to add these two entries in our .ini
>>>
>>>
>>file?
>>
>>
>>>>-----Original Message-----
>>>>From: Greg Quinn [mailto:greg@officium.co.za]
>>>>Sent: Friday, June 03, 2005 3:26 PM
>>>>To: James Frankman
>>>>Cc: win32@lists.mysql.com
>>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>>
>>>>
>>else
>>
>>
>>>>slow.
>>>>
>>>>
>>>>Hi James,
>>>>
>>>>We had a problem when connecting to the database (with an ip address
>>>>
>>>>
>>in
>>
>>
>>>the
>>>
>>>
>>>>conneciton string) took 10-15 seconds and then suddenly the query
>>>>
>>>>
>>results
>>
>>
>>>>would appear instantly. This problem usually occurred if the
>>>>
>>>>
>>internet
>>
>>
>>>>connection was unavailable.
>>>>
>>>>Anyway, to solve this problem, we added the following lines to our
>>>>
>>>>
>>.ini
>>
>>
>>>file
>>>
>>>
>>>>skip-name-resolve
>>>>skip-host-cache
>>>>
>>>>Try this, restart the MySQL Service and see if the problem persists.
>>>>
>>>>Greg
>>>>
>>>>----- Original Message -----
>>>>From: "James Frankman"
>>>>To: "Daniel da Veiga" ;
>>>>
>>>>
>>
>>
>>
>>>>Sent: Friday, June 03, 2005 10:53 PM
>>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>>
>>>>
>>else
>>
>>
>>>>slow.
>>>>
>>>>
>>>>
>>>>
>>>>>Thanks for the speedy response. You can't buy support this fast.
>>>>>
>>>>>-We are connecting via TCP/IP.
>>>>>
>>>>>-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.
>>
>>
>>>>>-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?
>>>>>
>>>>>-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.
>>>>>
>>>>>It is now obvious that this is a network issue as we are having
>>>>>
>>>>>
>>problems
>>
>>
>>>>>on other servers/software.
>>>>>
>>>>>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.
>>>>>
>>>>>
>>>>>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.
>>>>>
>>>>>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.
>>>>>
>>>>>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).
>>>>>
>>>>>Anyway, give us more info...
>>>>>
>>>>>Best regards,
>>>>>
>>>>>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.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>--
>>>>>Daniel da Veiga
>>>>>Computer Operator - RS - Brazil
>>>>>
>>>>>--
>>>>>
>>>>>
>>Daniel da Veiga
>>Computer Operator - RS - Brazil
>>
>>
>
>I am not sure of your issue timing but could it have been related to an
>Automated Windows Update (patch)? That is one process that frequently
>changes your settings without asking for permission and is generally
>allowed to "do its thing" without a lot of supervision.
>
>Different versions of the OS may have had their patches released on
>different dates and any one of them may have turned off your Reverse DNS
>lookups as a "security enhancement" or whatever Mr. Gate$ and his
>"developers" are calling such things these days.
>
>Why not check your update logs and see if the timings match up between a
>patch install and the beginnings of your DNS problems? I suggest this
>because this list has been getting more of these complaints than before
>and that is one mechanism you may all have in common.
>
>Shawn Green
>Database Administrator
>Unimin Corporation - Spruce Pine
>
>
>

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

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

Well, I have all automatic updates disabled, and even if it was
enabled, our proxy server would denny access to the updates server,
but we have Novell here, and so, if the admin put some patch on the
init script it may have updated the machine, I'll ask for tech support
if anything of that nature was implemented, but I'm pretty sure it
wasn't...

And, for instance, it happened like 2 months ago for me, so, it seems
to me its not time related, its more of a "hey, they had the same
problem too, lets report". Oh, and it happened on 4 different versions
of the server and lots of different machine (win95,98,NT,XP,2000).

On 6/6/05, James Frankman wrote:
> I also find it interesting that this has happened on Friday for several o=
thers. Is it possible a scheduled Windows patch took place on Friday?
>=20
> -----Original Message-----
> From: Brandon Schenz [mailto:brandons@midwestsports.com]
> Sent: Monday, June 06, 2005 10:57 AM
> To: MySQL Win32 List
> Subject: Re: Connections from localhost fast. Connections anywhere else
> slow.
>=20
>=20
> I had the problem on Friday as well, then again this morning before I
> changed any of my settings. I am running on Windows XP Pro. I just
> think it is also weird that this started on Friday for several people as
> well. Just too many similar things....
>=20
> Since I turned off name resolution it seems to be running fine.
>=20
> *Brandon Schenz*
> Midwest Sports Supply
> IT Manager
> Phone: 513-956-4900
> Fax: 513-956-4910
> E-mail: brandons@midwestsports.com
>=20
>=20
> Ryan Paulson wrote:
>=20
> >I too would enjoy an explanation of why this happens.
> >
> >I am running Windows 2003 Standard Server. We have no domain or
> >internal DNS server and our "network" is running as a workgroup. All my
> >servers run MySQL 4.1.11a and when this problem started, it started
> >across all my DB servers. That is why I don't think it is limited to
> >MySQL, but why all of a sudden did it quite.
> >
> >
> >-----Original Message-----
> >From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
> >Sent: Monday, June 06, 2005 11:19 AM
> >To: MySQL Win32 List
> >Subject: Re: Connections from localhost fast. Connections anywhere else
> >slow.
> >
> >Well, I can't really say what happened, but its indeed a mistery to be
> >solved, I've seen this problem occurs many times, and always enabled a
> >solution (you can see those by my previous messages) and never thought
> >about reverse DNS (for the same reason James's admins never did,
> >because I never changed anything on the network before the problem
> >happens), now that you realized what is the problem, it may be of help
> >to me and many users around that had the same problem and, like me,
> >searched alternatives that eventually worked. I have some questions:
> >
> >1) Does it happen only on win32 systems? (as I said before, my Linux
> >box and a Mac running here never had problems, but maybe other people
> >had)
> >
> >2) Its a network configuration issue (TCP/IP), or maybe related to how
> >MySQL uses the network, or another option, the way MySQL interacts
> >with the system's network interface?
> >
> >That's why I love this lists :)
> >
> >Best regards,
> >
> >On 6/6/05, James Frankman wrote:
> >
> >
> >>Leigh,
> >>
> >>Just finished talking to our network admin. The reverse DNS lookup is
> >>
> >>
> >indeed the problem. They had to enable the reverse DNS lookup on our
> >"subnet" and everything started working fine.
> >
> >
> >>I am still curious about what could have caused this to occur in the
> >>
> >>
> >first place. We have been using MySQL for almost three years now and
> >until Friday, we never had this problem. Our network admin swears no
> >changes were made to the network configuration before this problem
> >appeared last Friday. Do you have any ideas what could have triggered
> >this problem? I see only two scenarios to consider:
> >
> >
> >> 1. MySQL never used the reverse DNS lookup until last Friday
> >> 2. Some network process or software changed our network
> >>
> >>
> >configuration so that the reverse DNS lookup became disabled or
> >removed somehow.
> >
> >
> >>Like most analysts/programmers, I do not like a mysteries. I want to
> >>
> >>
> >be able to explain why this happened all of the sudden so we can know
> >how to prevent it from happening again. Any theories, ideas, or
> >explanations would be appreciated.
> >
> >
> >>-----Original Message-----
> >>From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
> >>Sent: Sunday, June 05, 2005 5:52 PM
> >>To: James Frankman
> >>Cc: win32@lists.mysql.com
> >>Subject: Re: Connections from localhost fast. Connections anywhere
> >>
> >>
> >else
> >
> >
> >>slow.
> >>
> >>
> >>I may be a littel late, but it sounds a lot like reverse DNS issues.
> >>When your client connects to the server, the server looks up the name
> >>
> >>
> >of the
> >
> >
> >>client that is connecting. IOf there is no reverse DNS entry for it,
> >>
> >>
> >it
> >
> >
> >>keeps re-trying. I have seen these things take as much as a minute
> >>
> >>
> >before
> >
> >
> >>timing out. Check whether you have a reverse entry, or an entry in the
> >>
> >>
> >hosts
> >
> >
> >>file.
> >>Another thing to check is to do a 'show processlist' during the
> >>
> >>
> >connection
> >
> >
> >>or during a query. The process list returned also tells you the
> >>
> >>
> >client. If
> >
> >
> >>this is an IP address, your server does not know the name of the
> >>
> >>
> >client,
> >
> >
> >>which indicates it's probably the issue.
> >>
> >>----- Original Message -----
> >>From: "James Frankman"
> >>To: "Greg Quinn"
> >>Cc:
> >>Sent: Saturday, June 04, 2005 8:18 AM
> >>Subject: RE: Connections from localhost fast. Connections anywhere
> >>
> >>
> >else
> >
> >
> >>slow.
> >>
> >>
> >>
> >>
> >>>That did it. MySQL is now quick as ever.
> >>>
> >>>I am confused about what these do. Why did MySQL work before I
> >>>
> >>>
> >started
> >
> >
> >>experiencing the problems today? What changes could have occurred to
> >>
> >>
> >our
> >
> >
> >>network/hardware that required us to add these two entries in our .ini
> >>
> >>
> >file?
> >
> >
> >>>-----Original Message-----
> >>>From: Greg Quinn [mailto:greg@officium.co.za]
> >>>Sent: Friday, June 03, 2005 3:26 PM
> >>>To: James Frankman
> >>>Cc: win32@lists.mysql.com
> >>>Subject: Re: Connections from localhost fast. Connections anywhere
> >>>
> >>>
> >else
> >
> >
> >>>slow.
> >>>
> >>>
> >>>Hi James,
> >>>
> >>>We had a problem when connecting to the database (with an ip address
> >>>
> >>>
> >in
> >
> >
> >>the
> >>
> >>
> >>>conneciton string) took 10-15 seconds and then suddenly the query
> >>>
> >>>
> >results
> >
> >
> >>>would appear instantly. This problem usually occurred if the
> >>>
> >>>
> >internet
> >
> >
> >>>connection was unavailable.
> >>>
> >>>Anyway, to solve this problem, we added the following lines to our
> >>>
> >>>
> >.ini
> >
> >
> >>file
> >>
> >>
> >>>skip-name-resolve
> >>>skip-host-cache
> >>>
> >>>Try this, restart the MySQL Service and see if the problem persists.
> >>>
> >>>Greg
> >>>
> >>>----- Original Message -----
> >>>From: "James Frankman"
> >>>To: "Daniel da Veiga" ;
> >>>
> >>>
> >
> >
> >
> >>>Sent: Friday, June 03, 2005 10:53 PM
> >>>Subject: RE: Connections from localhost fast. Connections anywhere
> >>>
> >>>
> >else
> >
> >
> >>>slow.
> >>>
> >>>
> >>>
> >>>
> >>>>Thanks for the speedy response. You can't buy support this fast.
> >>>>
> >>>>-We are connecting via TCP/IP.
> >>>>
> >>>>-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.
> >
> >
> >>>>-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?
> >>>>
> >>>>-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.
> >>>>
> >>>>It is now obvious that this is a network issue as we are having
> >>>>
> >>>>
> >problems
> >
> >
> >>>>on other servers/software.
> >>>>
> >>>>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.
> >>>>
> >>>>
> >>>>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.
> >>>>
> >>>>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.
> >>>>
> >>>>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).
> >>>>
> >>>>Anyway, give us more info...
> >>>>
> >>>>Best regards,
> >>>>
> >>>>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@gmai l.com
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>--
> >>>>Daniel da Veiga
> >>>>Computer Operator - RS - Brazil
> >>>>
> >>>>--
> >>>>MySQL Windows Mailing List
> >>>>For list archives: http://lists.mysql.com/win32
> >>>>To unsubscribe:
> >>>>http://lists.mysql.com/win32?unsub=3Djfrankman@idfbins.c om
> >>>>
> >>>>
> >>>>--
> >>>>MySQL Windows Mailing List
> >>>>For list archives: http://lists.mysql.com/win32
> >>>>To unsubscribe:
> >>>>
> >>>>
> >>http://lists.mysql.com/win32?unsub=3Dgreg@i-online.co.za
> >>
> >>
> >>>--
> >>>MySQL Windows Mailing List
> >>>For list archives: http://lists.mysql.com/win32
> >>>To unsubscribe:
> >>>
> >>>
> >>http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwirele ss.com.au
> >>
> >>
> >>--
> >>MySQL Windows Mailing List
> >>For list archives: http://lists.mysql.com/win32
> >>To unsubscribe:
> >>
> >>
> >http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.co m
> >
> >
> >>
> >>
> >
> >
> >
> >
>=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
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


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

--
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

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

I would suspect the logs on your DNS servers or other network Servers =
would be more likely place to check the logs as I think this is a =
network issue, not a MySQL one.

-----Original Message-----
From: Brandon Schenz [mailto:brandons@midwestsports.com]
Sent: Monday, June 06, 2005 11:09 AM
Cc: MySQL Win32 List
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.


We do not have an anti-spyware package on the mySQL computer, and use=20
AVG as anti-virus. I'm going to look at the update logs here in a=20
little bit.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


James Frankman wrote:

>Another thought I have: is it possible some anti-spyware or anti-virus =
package caused this problem. I know this if much less likely to be the =
culprit, but thought I should bring it up.=20
>
>-As far as anti-virus we use Symantec. Not sure what anti-spyware tools =
we use.
>
>-----Original Message-----
>From: SGreen@unimin.com [mailto:SGreen@unimin.com]
>Sent: Monday, June 06, 2005 10:53 AM
>To: Ryan Paulson
>Cc: Daniel da Veiga; Ryan J. Paulson; MySQL Win32 List
>Subject: RE: Connections from localhost fast. Connections anywhere else
>slow.
>
>
>"Ryan J. Paulson" wrote on 06/06/2005 12:47:21 =
PM:
>
> =20
>
>>I too would enjoy an explanation of why this happens.
>> =20
>>
>
> =20
>
>>I am running Windows 2003 Standard Server. We have no domain or
>>internal DNS server and our "network" is running as a workgroup. All =
my
>>servers run MySQL 4.1.11a and when this problem started, it started
>>across all my DB servers. That is why I don't think it is limited to
>>MySQL, but why all of a sudden did it quite.
>> =20
>>
>
> =20
>
>>-----Original Message-----
>>From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
>>Sent: Monday, June 06, 2005 11:19 AM
>>To: MySQL Win32 List
>>Subject: Re: Connections from localhost fast. Connections anywhere =
else
>>slow.
>> =20
>>
>
> =20
>
>>Well, I can't really say what happened, but its indeed a mistery to be
>>solved, I've seen this problem occurs many times, and always enabled a
>>solution (you can see those by my previous messages) and never thought
>>about reverse DNS (for the same reason James's admins never did,
>>because I never changed anything on the network before the problem
>>happens), now that you realized what is the problem, it may be of help
>>to me and many users around that had the same problem and, like me,
>>searched alternatives that eventually worked. I have some questions:
>> =20
>>
>
> =20
>
>>1) Does it happen only on win32 systems? (as I said before, my Linux
>>box and a Mac running here never had problems, but maybe other people
>>had)
>> =20
>>
>
> =20
>
>>2) Its a network configuration issue (TCP/IP), or maybe related to how
>>MySQL uses the network, or another option, the way MySQL interacts
>>with the system's network interface?
>> =20
>>
>
> =20
>
>>That's why I love this lists :)
>> =20
>>
>
> =20
>
>>Best regards,
>> =20
>>
>
> =20
>
>>On 6/6/05, James Frankman wrote:
>> =20
>>
>>>Leigh,
>>>
>>>Just finished talking to our network admin. The reverse DNS lookup is
>>> =20
>>>
>>indeed the problem. They had to enable the reverse DNS lookup on our
>>"subnet" and everything started working fine.
>> =20
>>
>>>I am still curious about what could have caused this to occur in the
>>> =20
>>>
>>first place. We have been using MySQL for almost three years now and
>>until Friday, we never had this problem. Our network admin swears no
>>changes were made to the network configuration before this problem
>>appeared last Friday. Do you have any ideas what could have triggered
>>this problem? I see only two scenarios to consider:
>> =20
>>
>>> 1. MySQL never used the reverse DNS lookup until last Friday
>>> 2. Some network process or software changed our network
>>> =20
>>>
>>configuration so that the reverse DNS lookup became disabled or
>>removed somehow.
>> =20
>>
>>>Like most analysts/programmers, I do not like a mysteries. I want to
>>> =20
>>>
>>be able to explain why this happened all of the sudden so we can know
>>how to prevent it from happening again. Any theories, ideas, or
>>explanations would be appreciated.
>> =20
>>
>>>-----Original Message-----
>>>From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
>>>Sent: Sunday, June 05, 2005 5:52 PM
>>>To: James Frankman
>>>Cc: win32@lists.mysql.com
>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>> =20
>>>
>>else
>> =20
>>
>>>slow.
>>>
>>>
>>>I may be a littel late, but it sounds a lot like reverse DNS issues.
>>>When your client connects to the server, the server looks up the name
>>> =20
>>>
>>of the
>> =20
>>
>>>client that is connecting. IOf there is no reverse DNS entry for it,
>>> =20
>>>
>>it
>> =20
>>
>>>keeps re-trying. I have seen these things take as much as a minute
>>> =20
>>>
>>before
>> =20
>>
>>>timing out. Check whether you have a reverse entry, or an entry in =
the
>>> =20
>>>
>>hosts
>> =20
>>
>>>file.
>>>Another thing to check is to do a 'show processlist' during the
>>> =20
>>>
>>connection
>> =20
>>
>>>or during a query. The process list returned also tells you the
>>> =20
>>>
>>client. If
>> =20
>>
>>>this is an IP address, your server does not know the name of the
>>> =20
>>>
>>client,
>> =20
>>
>>>which indicates it's probably the issue.
>>>
>>>----- Original Message -----
>>>From: "James Frankman"
>>>To: "Greg Quinn"
>>>Cc:
>>>Sent: Saturday, June 04, 2005 8:18 AM
>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>> =20
>>>
>>else
>> =20
>>
>>>slow.
>>>
>>>
>>> =20
>>>
>>>>That did it. MySQL is now quick as ever.
>>>>
>>>>I am confused about what these do. Why did MySQL work before I
>>>> =20
>>>>
>>started
>> =20
>>
>>>experiencing the problems today? What changes could have occurred to
>>> =20
>>>
>>our
>> =20
>>
>>>network/hardware that required us to add these two entries in our =
..ini
>>> =20
>>>
>>file?
>> =20
>>
>>>>-----Original Message-----
>>>>From: Greg Quinn [mailto:greg@officium.co.za]
>>>>Sent: Friday, June 03, 2005 3:26 PM
>>>>To: James Frankman
>>>>Cc: win32@lists.mysql.com
>>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>> =20
>>>>
>>else
>> =20
>>
>>>>slow.
>>>>
>>>>
>>>>Hi James,
>>>>
>>>>We had a problem when connecting to the database (with an ip address
>>>> =20
>>>>
>>in
>> =20
>>
>>>the
>>> =20
>>>
>>>>conneciton string) took 10-15 seconds and then suddenly the query
>>>> =20
>>>>
>>results
>> =20
>>
>>>>would appear instantly. This problem usually occurred if the
>>>> =20
>>>>
>>internet
>> =20
>>
>>>>connection was unavailable.
>>>>
>>>>Anyway, to solve this problem, we added the following lines to our
>>>> =20
>>>>
>>.ini
>> =20
>>
>>>file
>>> =20
>>>
>>>>skip-name-resolve
>>>>skip-host-cache
>>>>
>>>>Try this, restart the MySQL Service and see if the problem persists.
>>>>
>>>>Greg
>>>>
>>>>----- Original Message -----
>>>>From: "James Frankman"
>>>>To: "Daniel da Veiga" ;
>>>> =20
>>>>
>>
>> =20
>>
>>>>Sent: Friday, June 03, 2005 10:53 PM
>>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>> =20
>>>>
>>else
>> =20
>>
>>>>slow.
>>>>
>>>>
>>>> =20
>>>>
>>>>>Thanks for the speedy response. You can't buy support this fast.
>>>>>
>>>>>-We are connecting via TCP/IP.
>>>>>
>>>>>-DNS servers appear to be working correctly. Even if they weren't
>>>>> =20
>>>>>
>>we are
>> =20
>>
>>>>>experienceing problems when using the actual ip address. If I
>>>>> =20
>>>>>
>>understand
>> =20
>>
>>>>>my networking when you use the ip address, the DNS server is not
>>>>> =20
>>>>>
>>used.
>> =20
>>
>>>>>-I tried your suggestions about the connect vs. query time. It
>>>>> =20
>>>>>
>>takes
>> =20
>>
>>>>>several seconds to connect to MySQL, but query times are
>>>>> =20
>>>>>
>>instantaneous.
>> =20
>>
>>>It
>>> =20
>>>
>>>>>must be a network issue right?
>>>>>
>>>>>-We are noticing similar problems with other peices of software on
>>>>> =20
>>>>>
>>our
>> =20
>>
>>>>>network that you connect to on a TCP port. We seem to be having
>>>>> =20
>>>>>
>>problems
>> =20
>>
>>>>>with port 211 on a completely separate server. However our web
>>>>> =20
>>>>>
>>server
>> =20
>>
>>>and
>>> =20
>>>
>>>>>ftp servers respond fine. They are on ports 80 and 23 I think.
>>>>>
>>>>>It is now obvious that this is a network issue as we are having
>>>>> =20
>>>>>
>>problems
>> =20
>>
>>>>>on other servers/software.
>>>>>
>>>>>Not to waste the mysql list with troubleshooting a general
>>>>> =20
>>>>>
>>networking
>> =20
>>
>>>>>issue, but if anyone has some ideas as why certain ports on our
>>>>> =20
>>>>>
>>network
>> =20
>>
>>>>>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
>>>>> =20
>>>>>
>>else
>> =20
>>
>>>>>slow.
>>>>>
>>>>>
>>>>>This is one of those problems you have thousands of solutions for,
>>>>> =20
>>>>>
>>but
>> =20
>>
>>>>>a few would aplly to your machine, network, server, client,
>>>>> =20
>>>>>
>>protocols
>> =20
>>
>>>>>and environment specific configuration.
>>>>>
>>>>>First, how are you trying to connect? TCP/IP? If so, then you
>>>>> =20
>>>>>
>>should
>> =20
>>
>>>>>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
>>>>> =20
>>>>>
>>properly?
>> =20
>>
>>>>>When MySQL (and any other tcp program) try to resolve names, it
>>>>> =20
>>>>>
>>takes
>> =20
>>
>>>>>a long time if it can't find a name server, even if you're using
>>>>>direct IP addressing.
>>>>>
>>>>>Another suggestion, use the MySQL client console from a remote
>>>>> =20
>>>>>
>>machine
>> =20
>>
>>>>>and see if what takes time is the CONNECTION or the QUERY, because
>>>>> =20
>>>>>
>>if
>> =20
>>
>>>>>its the connection, than your network isn't configured properly,
>>>>> =20
>>>>>
>>but
>> =20
>>
>>>>>if the QUERIES are slow too, then you may have fragmentation,
>>>>> =20
>>>>>
>>colision
>> =20
>>
>>>>>or any other kind of packet loss (that may be caused by hardware
>>>>>configs).
>>>>>
>>>>>Anyway, give us more info...
>>>>>
>>>>>Best regards,
>>>>>
>>>>>On 6/3/05, James Frankman wrote:
>>>>> =20
>>>>>
>>>>>>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
>>>>>> =20
>>>>>>
>>we use
>> =20
>>
>>>>>>its ip address to connect it is extremely slow. Other network
>>>>>> =20
>>>>>>
>>>connections
>>> =20
>>>
>>>>>>to our MySQL server do not seem slow. Any help diagnosing this
>>>>>> =20
>>>>>>
>>problem
>> =20
>>
>>>>>>would be helpful.
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>>>--
>>>>>Daniel da Veiga
>>>>>Computer Operator - RS - Brazil
>>>>>
>>>>>--
>>>>> =20
>>>>>
>>Daniel da Veiga
>>Computer Operator - RS - Brazil
>> =20
>>
>
>I am not sure of your issue timing but could it have been related to an =

>Automated Windows Update (patch)? That is one process that frequently=20
>changes your settings without asking for permission and is generally=20
>allowed to "do its thing" without a lot of supervision.=20
>
>Different versions of the OS may have had their patches released on=20
>different dates and any one of them may have turned off your Reverse =
DNS=20
>lookups as a "security enhancement" or whatever Mr. Gate$ and his=20
>"developers" are calling such things these days.
>
>Why not check your update logs and see if the timings match up between =
a=20
>patch install and the beginnings of your DNS problems? I suggest this=20
>because this list has been getting more of these complaints than before =

>and that is one mechanism you may all have in common.
>
>Shawn Green
>Database Administrator
>Unimin Corporation - Spruce Pine
>
> =20
>

--=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

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

We also had a problem about two months ago. It was again on a Friday
which is all I can remember at this point.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


Daniel da Veiga wrote:

>Well, I have all automatic updates disabled, and even if it was
>enabled, our proxy server would denny access to the updates server,
>but we have Novell here, and so, if the admin put some patch on the
>init script it may have updated the machine, I'll ask for tech support
>if anything of that nature was implemented, but I'm pretty sure it
>wasn't...
>
>And, for instance, it happened like 2 months ago for me, so, it seems
>to me its not time related, its more of a "hey, they had the same
>problem too, lets report". Oh, and it happened on 4 different versions
>of the server and lots of different machine (win95,98,NT,XP,2000).
>
>On 6/6/05, James Frankman wrote:
>
>
>>I also find it interesting that this has happened on Friday for several others. Is it possible a scheduled Windows patch took place on Friday?
>>
>>-----Original Message-----
>>From: Brandon Schenz [mailto:brandons@midwestsports.com]
>>Sent: Monday, June 06, 2005 10:57 AM
>>To: MySQL Win32 List
>>Subject: Re: Connections from localhost fast. Connections anywhere else
>>slow.
>>
>>
>>I had the problem on Friday as well, then again this morning before I
>>changed any of my settings. I am running on Windows XP Pro. I just
>>think it is also weird that this started on Friday for several people as
>>well. Just too many similar things....
>>
>>Since I turned off name resolution it seems to be running fine.
>>
>>*Brandon Schenz*
>>Midwest Sports Supply
>>IT Manager
>>Phone: 513-956-4900
>>Fax: 513-956-4910
>>E-mail: brandons@midwestsports.com
>>
>>
>>Ryan Paulson wrote:
>>
>>
>>
>>>I too would enjoy an explanation of why this happens.
>>>
>>>I am running Windows 2003 Standard Server. We have no domain or
>>>internal DNS server and our "network" is running as a workgroup. All my
>>>servers run MySQL 4.1.11a and when this problem started, it started
>>>across all my DB servers. That is why I don't think it is limited to
>>>MySQL, but why all of a sudden did it quite.
>>>
>>>
>>>-----Original Message-----
>>>From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
>>>Sent: Monday, June 06, 2005 11:19 AM
>>>To: MySQL Win32 List
>>>Subject: Re: Connections from localhost fast. Connections anywhere else
>>>slow.
>>>
>>>Well, I can't really say what happened, but its indeed a mistery to be
>>>solved, I've seen this problem occurs many times, and always enabled a
>>>solution (you can see those by my previous messages) and never thought
>>>about reverse DNS (for the same reason James's admins never did,
>>>because I never changed anything on the network before the problem
>>>happens), now that you realized what is the problem, it may be of help
>>>to me and many users around that had the same problem and, like me,
>>>searched alternatives that eventually worked. I have some questions:
>>>
>>>1) Does it happen only on win32 systems? (as I said before, my Linux
>>>box and a Mac running here never had problems, but maybe other people
>>>had)
>>>
>>>2) Its a network configuration issue (TCP/IP), or maybe related to how
>>>MySQL uses the network, or another option, the way MySQL interacts
>>>with the system's network interface?
>>>
>>>That's why I love this lists :)
>>>
>>>Best regards,
>>>
>>>On 6/6/05, James Frankman wrote:
>>>
>>>
>>>
>>>
>>>>Leigh,
>>>>
>>>>Just finished talking to our network admin. The reverse DNS lookup is
>>>>
>>>>
>>>>
>>>>
>>>indeed the problem. They had to enable the reverse DNS lookup on our
>>>"subnet" and everything started working fine.
>>>
>>>
>>>
>>>
>>>>I am still curious about what could have caused this to occur in the
>>>>
>>>>
>>>>
>>>>
>>>first place. We have been using MySQL for almost three years now and
>>>until Friday, we never had this problem. Our network admin swears no
>>>changes were made to the network configuration before this problem
>>>appeared last Friday. Do you have any ideas what could have triggered
>>>this problem? I see only two scenarios to consider:
>>>
>>>
>>>
>>>
>>>> 1. MySQL never used the reverse DNS lookup until last Friday
>>>> 2. Some network process or software changed our network
>>>>
>>>>
>>>>
>>>>
>>>configuration so that the reverse DNS lookup became disabled or
>>>removed somehow.
>>>
>>>
>>>
>>>
>>>>Like most analysts/programmers, I do not like a mysteries. I want to
>>>>
>>>>
>>>>
>>>>
>>>be able to explain why this happened all of the sudden so we can know
>>>how to prevent it from happening again. Any theories, ideas, or
>>>explanations would be appreciated.
>>>
>>>
>>>
>>>
>>>>-----Original Message-----
>>>>From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
>>>>Sent: Sunday, June 05, 2005 5:52 PM
>>>>To: James Frankman
>>>>Cc: win32@lists.mysql.com
>>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>>
>>>>
>>>>
>>>>
>>>else
>>>
>>>
>>>
>>>
>>>>slow.
>>>>
>>>>
>>>>I may be a littel late, but it sounds a lot like reverse DNS issues.
>>>>When your client connects to the server, the server looks up the name
>>>>
>>>>
>>>>
>>>>
>>>of the
>>>
>>>
>>>
>>>
>>>>client that is connecting. IOf there is no reverse DNS entry for it,
>>>>
>>>>
>>>>
>>>>
>>>it
>>>
>>>
>>>
>>>
>>>>keeps re-trying. I have seen these things take as much as a minute
>>>>
>>>>
>>>>
>>>>
>>>before
>>>
>>>
>>>
>>>
>>>>timing out. Check whether you have a reverse entry, or an entry in the
>>>>
>>>>
>>>>
>>>>
>>>hosts
>>>
>>>
>>>
>>>
>>>>file.
>>>>Another thing to check is to do a 'show processlist' during the
>>>>
>>>>
>>>>
>>>>
>>>connection
>>>
>>>
>>>
>>>
>>>>or during a query. The process list returned also tells you the
>>>>
>>>>
>>>>
>>>>
>>>client. If
>>>
>>>
>>>
>>>
>>>>this is an IP address, your server does not know the name of the
>>>>
>>>>
>>>>
>>>>
>>>client,
>>>
>>>
>>>
>>>
>>>>which indicates it's probably the issue.
>>>>
>>>>----- Original Message -----
>>>>From: "James Frankman"
>>>>To: "Greg Quinn"
>>>>Cc:
>>>>Sent: Saturday, June 04, 2005 8:18 AM
>>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>>
>>>>
>>>>
>>>>
>>>else
>>>
>>>
>>>
>>>
>>>>slow.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>That did it. MySQL is now quick as ever.
>>>>>
>>>>>I am confused about what these do. Why did MySQL work before I
>>>>>
>>>>>
>>>>>
>>>>>
>>>started
>>>
>>>
>>>
>>>
>>>>experiencing the problems today? What changes could have occurred to
>>>>
>>>>
>>>>
>>>>
>>>our
>>>
>>>
>>>
>>>
>>>>network/hardware that required us to add these two entries in our .ini
>>>>
>>>>
>>>>
>>>>
>>>file?
>>>
>>>
>>>
>>>
>>>>>-----Original Message-----
>>>>>From: Greg Quinn [mailto:greg@officium.co.za]
>>>>>Sent: Friday, June 03, 2005 3:26 PM
>>>>>To: James Frankman
>>>>>Cc: win32@lists.mysql.com
>>>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>>>
>>>>>
>>>>>
>>>>>
>>>else
>>>
>>>
>>>
>>>
>>>>>slow.
>>>>>
>>>>>
>>>>>Hi James,
>>>>>
>>>>>We had a problem when connecting to the database (with an ip address
>>>>>
>>>>>
>>>>>
>>>>>
>>>in
>>>
>>>
>>>
>>>
>>>>the
>>>>
>>>>
>>>>
>>>>
>>>>>conneciton string) took 10-15 seconds and then suddenly the query
>>>>>
>>>>>
>>>>>
>>>>>
>>>results
>>>
>>>
>>>
>>>
>>>>>would appear instantly. This problem usually occurred if the
>>>>>
>>>>>
>>>>>
>>>>>
>>>internet
>>>
>>>
>>>
>>>
>>>>>connection was unavailable.
>>>>>
>>>>>Anyway, to solve this problem, we added the following lines to our
>>>>>
>>>>>
>>>>>
>>>>>
>>>.ini
>>>
>>>
>>>
>>>
>>>>file
>>>>
>>>>
>>>>
>>>>
>>>>>skip-name-resolve
>>>>>skip-host-cache
>>>>>
>>>>>Try this, restart the MySQL Service and see if the problem persists.
>>>>>
>>>>>Greg
>>>>>
>>>>>----- Original Message -----
>>>>>From: "James Frankman"
>>>>>To: "Daniel da Veiga" ;
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>
>>>
>>>
>>>
>>>>>Sent: Friday, June 03, 2005 10:53 PM
>>>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>>>
>>>>>
>>>>>
>>>>>
>>>else
>>>
>>>
>>>
>>>
>>>>>slow.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Thanks for the speedy response. You can't buy support this fast.
>>>>>>
>>>>>>-We are connecting via TCP/IP.
>>>>>>
>>>>>>-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.
>>>
>>>
>>>
>>>
>>>>>>-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?
>>>>>>
>>>>>>-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.
>>>>>>
>>>>>>It is now obvious that this is a network issue as we are having
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>problems
>>>
>>>
>>>
>>>
>>>>>>on other servers/software.
>>>>>>
>>>>>>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.
>>>>>>
>>>>>>
>>>>>>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.
>>>>>>
>>>>>>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.
>>>>>>
>>>>>>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).
>>>>>>
>>>>>>Anyway, give us more info...
>>>>>>
>>>>>>Best regards,
>>>>>>
>>>>>>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=danieldaveiga@gmai l.com
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>--
>>>>>>Daniel da Veiga
>>>>>>Computer Operator - RS - Brazil
>>>>>>
>>>>>>--
>>>>>>MySQL Windows Mailing List
>>>>>>For list archives: http://lists.mysql.com/win32
>>>>>>To unsubscribe:
>>>>>>http://lists.mysql.com/win32?unsub=jfrankman@idfbins.c om
>>>>>>
>>>>>>
>>>>>>--
>>>>>>MySQL Windows Mailing List
>>>>>>For list archives: http://lists.mysql.com/win32
>>>>>>To unsubscribe:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>http://lists.mysql.com/win32?unsub=greg@i-online.co.za
>>>>
>>>>
>>>>
>>>>
>>>>>--
>>>>>MySQL Windows Mailing List
>>>>>For list archives: http://lists.mysql.com/win32
>>>>>To unsubscribe:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>http://lists.mysql.com/win32?unsub=lsharpe@pacificwirele ss.com.au
>>>>
>>>>
>>>>--
>>>>MySQL Windows Mailing List
>>>>For list archives: http://lists.mysql.com/win32
>>>>To unsubscribe:
>>>>
>>>>
>>>>
>>>>
>>>http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.co m
>>>
>>>
>>>
>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe: http://lists.mysql.com/win32?unsub=jfrankman@idfbins.com
>>
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>>
>>
>>
>>
>
>
>
>

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

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

I can't find anything in any of our logs. My systems engineer swears
that it is something inside MySQL that blew up. We had zero network or
database configuration changes before the crash.

-----Original Message-----
From: Brandon Schenz [mailto:brandons@midwestsports.com]=20
Sent: Monday, June 06, 2005 12:35 PM
To: Daniel da Veiga
Cc: MySQL Win32 List
Subject: Re: Connections from localhost fast. Connections anywhere else
slow.

We also had a problem about two months ago. It was again on a Friday=20
which is all I can remember at this point.

*Brandon Schenz*
Midwest Sports Supply
IT Manager
Phone: 513-956-4900
Fax: 513-956-4910
E-mail: brandons@midwestsports.com


Daniel da Veiga wrote:

>Well, I have all automatic updates disabled, and even if it was
>enabled, our proxy server would denny access to the updates server,
>but we have Novell here, and so, if the admin put some patch on the
>init script it may have updated the machine, I'll ask for tech support
>if anything of that nature was implemented, but I'm pretty sure it
>wasn't...
>
>And, for instance, it happened like 2 months ago for me, so, it seems
>to me its not time related, its more of a "hey, they had the same
>problem too, lets report". Oh, and it happened on 4 different versions
>of the server and lots of different machine (win95,98,NT,XP,2000).
>
>On 6/6/05, James Frankman wrote:
> =20
>
>>I also find it interesting that this has happened on Friday for
several others. Is it possible a scheduled Windows patch took place on
Friday?
>>
>>-----Original Message-----
>>From: Brandon Schenz [mailto:brandons@midwestsports.com]
>>Sent: Monday, June 06, 2005 10:57 AM
>>To: MySQL Win32 List
>>Subject: Re: Connections from localhost fast. Connections anywhere
else
>>slow.
>>
>>
>>I had the problem on Friday as well, then again this morning before I
>>changed any of my settings. I am running on Windows XP Pro. I just
>>think it is also weird that this started on Friday for several people
as
>>well. Just too many similar things....
>>
>>Since I turned off name resolution it seems to be running fine.
>>
>>*Brandon Schenz*
>>Midwest Sports Supply
>>IT Manager
>>Phone: 513-956-4900
>>Fax: 513-956-4910
>>E-mail: brandons@midwestsports.com
>>
>>
>>Ryan Paulson wrote:
>>
>> =20
>>
>>>I too would enjoy an explanation of why this happens.
>>>
>>>I am running Windows 2003 Standard Server. We have no domain or
>>>internal DNS server and our "network" is running as a workgroup. All
my
>>>servers run MySQL 4.1.11a and when this problem started, it started
>>>across all my DB servers. That is why I don't think it is limited to
>>>MySQL, but why all of a sudden did it quite.
>>>
>>>
>>>-----Original Message-----
>>>From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]
>>>Sent: Monday, June 06, 2005 11:19 AM
>>>To: MySQL Win32 List
>>>Subject: Re: Connections from localhost fast. Connections anywhere
else
>>>slow.
>>>
>>>Well, I can't really say what happened, but its indeed a mistery to
be
>>>solved, I've seen this problem occurs many times, and always enabled
a
>>>solution (you can see those by my previous messages) and never
thought
>>>about reverse DNS (for the same reason James's admins never did,
>>>because I never changed anything on the network before the problem
>>>happens), now that you realized what is the problem, it may be of
help
>>>to me and many users around that had the same problem and, like me,
>>>searched alternatives that eventually worked. I have some questions:
>>>
>>>1) Does it happen only on win32 systems? (as I said before, my Linux
>>>box and a Mac running here never had problems, but maybe other people
>>>had)
>>>
>>>2) Its a network configuration issue (TCP/IP), or maybe related to
how
>>>MySQL uses the network, or another option, the way MySQL interacts
>>>with the system's network interface?
>>>
>>>That's why I love this lists :)
>>>
>>>Best regards,
>>>
>>>On 6/6/05, James Frankman wrote:
>>>
>>>
>>> =20
>>>
>>>>Leigh,
>>>>
>>>>Just finished talking to our network admin. The reverse DNS lookup
is
>>>>
>>>>
>>>> =20
>>>>
>>>indeed the problem. They had to enable the reverse DNS lookup on our
>>>"subnet" and everything started working fine.
>>>
>>>
>>> =20
>>>
>>>>I am still curious about what could have caused this to occur in the
>>>>
>>>>
>>>> =20
>>>>
>>>first place. We have been using MySQL for almost three years now and
>>>until Friday, we never had this problem. Our network admin swears no
>>>changes were made to the network configuration before this problem
>>>appeared last Friday. Do you have any ideas what could have triggered
>>>this problem? I see only two scenarios to consider:
>>>
>>>
>>> =20
>>>
>>>> 1. MySQL never used the reverse DNS lookup until last Friday
>>>> 2. Some network process or software changed our network
>>>>
>>>>
>>>> =20
>>>>
>>>configuration so that the reverse DNS lookup became disabled or
>>>removed somehow.
>>>
>>>
>>> =20
>>>
>>>>Like most analysts/programmers, I do not like a mysteries. I want to
>>>>
>>>>
>>>> =20
>>>>
>>>be able to explain why this happened all of the sudden so we can know
>>>how to prevent it from happening again. Any theories, ideas, or
>>>explanations would be appreciated.
>>>
>>>
>>> =20
>>>
>>>>-----Original Message-----
>>>>From: Leigh Sharpe [mailto:lsharpe@pacificwireless.com.au]
>>>>Sent: Sunday, June 05, 2005 5:52 PM
>>>>To: James Frankman
>>>>Cc: win32@lists.mysql.com
>>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>>
>>>>
>>>> =20
>>>>
>>>else
>>>
>>>
>>> =20
>>>
>>>>slow.
>>>>
>>>>
>>>>I may be a littel late, but it sounds a lot like reverse DNS issues.
>>>>When your client connects to the server, the server looks up the
name
>>>>
>>>>
>>>> =20
>>>>
>>>of the
>>>
>>>
>>> =20
>>>
>>>>client that is connecting. IOf there is no reverse DNS entry for it,
>>>>
>>>>
>>>> =20
>>>>
>>>it
>>>
>>>
>>> =20
>>>
>>>>keeps re-trying. I have seen these things take as much as a minute
>>>>
>>>>
>>>> =20
>>>>
>>>before
>>>
>>>
>>> =20
>>>
>>>>timing out. Check whether you have a reverse entry, or an entry in
the
>>>>
>>>>
>>>> =20
>>>>
>>>hosts
>>>
>>>
>>> =20
>>>
>>>>file.
>>>>Another thing to check is to do a 'show processlist' during the
>>>>
>>>>
>>>> =20
>>>>
>>>connection
>>>
>>>
>>> =20
>>>
>>>>or during a query. The process list returned also tells you the
>>>>
>>>>
>>>> =20
>>>>
>>>client. If
>>>
>>>
>>> =20
>>>
>>>>this is an IP address, your server does not know the name of the
>>>>
>>>>
>>>> =20
>>>>
>>>client,
>>>
>>>
>>> =20
>>>
>>>>which indicates it's probably the issue.
>>>>
>>>>----- Original Message -----
>>>>From: "James Frankman"
>>>>To: "Greg Quinn"
>>>>Cc:
>>>>Sent: Saturday, June 04, 2005 8:18 AM
>>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>>
>>>>
>>>> =20
>>>>
>>>else
>>>
>>>
>>> =20
>>>
>>>>slow.
>>>>
>>>>
>>>>
>>>>
>>>> =20
>>>>
>>>>>That did it. MySQL is now quick as ever.
>>>>>
>>>>>I am confused about what these do. Why did MySQL work before I
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>started
>>>
>>>
>>> =20
>>>
>>>>experiencing the problems today? What changes could have occurred to
>>>>
>>>>
>>>> =20
>>>>
>>>our
>>>
>>>
>>> =20
>>>
>>>>network/hardware that required us to add these two entries in our
..ini
>>>>
>>>>
>>>> =20
>>>>
>>>file?
>>>
>>>
>>> =20
>>>
>>>>>-----Original Message-----
>>>>>From: Greg Quinn [mailto:greg@officium.co.za]
>>>>>Sent: Friday, June 03, 2005 3:26 PM
>>>>>To: James Frankman
>>>>>Cc: win32@lists.mysql.com
>>>>>Subject: Re: Connections from localhost fast. Connections anywhere
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>else
>>>
>>>
>>> =20
>>>
>>>>>slow.
>>>>>
>>>>>
>>>>>Hi James,
>>>>>
>>>>>We had a problem when connecting to the database (with an ip
address
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>in
>>>
>>>
>>> =20
>>>
>>>>the
>>>>
>>>>
>>>> =20
>>>>
>>>>>conneciton string) took 10-15 seconds and then suddenly the query
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>results
>>>
>>>
>>> =20
>>>
>>>>>would appear instantly. This problem usually occurred if the
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>internet
>>>
>>>
>>> =20
>>>
>>>>>connection was unavailable.
>>>>>
>>>>>Anyway, to solve this problem, we added the following lines to our
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>.ini
>>>
>>>
>>> =20
>>>
>>>>file
>>>>
>>>>
>>>> =20
>>>>
>>>>>skip-name-resolve
>>>>>skip-host-cache
>>>>>
>>>>>Try this, restart the MySQL Service and see if the problem
persists.
>>>>>
>>>>>Greg
>>>>>
>>>>>----- Original Message -----
>>>>>From: "James Frankman"
>>>>>To: "Daniel da Veiga" ;
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>
>>>
>>>
>>> =20
>>>
>>>>>Sent: Friday, June 03, 2005 10:53 PM
>>>>>Subject: RE: Connections from localhost fast. Connections anywhere
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>else
>>>
>>>
>>> =20
>>>
>>>>>slow.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>>>>Thanks for the speedy response. You can't buy support this fast.
>>>>>>
>>>>>>-We are connecting via TCP/IP.
>>>>>>
>>>>>>-DNS servers appear to be working correctly. Even if they weren't
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>we are
>>>
>>>
>>> =20
>>>
>>>>>>experienceing problems when using the actual ip address. If I
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>understand
>>>
>>>
>>> =20
>>>
>>>>>>my networking when you use the ip address, the DNS server is not
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>used.
>>>
>>>
>>> =20
>>>
>>>>>>-I tried your suggestions about the connect vs. query time. It
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>takes
>>>
>>>
>>> =20
>>>
>>>>>>several seconds to connect to MySQL, but query times are
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>instantaneous.
>>>
>>>
>>> =20
>>>
>>>>It
>>>>
>>>>
>>>> =20
>>>>
>>>>>>must be a network issue right?
>>>>>>
>>>>>>-We are noticing similar problems with other peices of software on
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>our
>>>
>>>
>>> =20
>>>
>>>>>>network that you connect to on a TCP port. We seem to be having
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>problems
>>>
>>>
>>> =20
>>>
>>>>>>with port 211 on a completely separate server. However our web
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>server
>>>
>>>
>>> =20
>>>
>>>>and
>>>>
>>>>
>>>> =20
>>>>
>>>>>>ftp servers respond fine. They are on ports 80 and 23 I think.
>>>>>>
>>>>>>It is now obvious that this is a network issue as we are having
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>problems
>>>
>>>
>>> =20
>>>
>>>>>>on other servers/software.
>>>>>>
>>>>>>Not to waste the mysql list with troubleshooting a general
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>networking
>>>
>>>
>>> =20
>>>
>>>>>>issue, but if anyone has some ideas as why certain ports on our
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>network
>>>
>>>
>>> =20
>>>
>>>>>>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
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>else
>>>
>>>
>>> =20
>>>
>>>>>>slow.
>>>>>>
>>>>>>
>>>>>>This is one of those problems you have thousands of solutions for,
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>but
>>>
>>>
>>> =20
>>>
>>>>>>a few would aplly to your machine, network, server, client,
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>protocols
>>>
>>>
>>> =20
>>>
>>>>>>and environment specific configuration.
>>>>>>
>>>>>>First, how are you trying to connect? TCP/IP? If so, then you
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>should
>>>
>>>
>>> =20
>>>
>>>>>>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
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>properly?
>>>
>>>
>>> =20
>>>
>>>>>>When MySQL (and any other tcp program) try to resolve names, it
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>takes
>>>
>>>
>>> =20
>>>
>>>>>>a long time if it can't find a name server, even if you're using
>>>>>>direct IP addressing.
>>>>>>
>>>>>>Another suggestion, use the MySQL client console from a remote
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>machine
>>>
>>>
>>> =20
>>>
>>>>>>and see if what takes time is the CONNECTION or the QUERY, because
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>if
>>>
>>>
>>> =20
>>>
>>>>>>its the connection, than your network isn't configured properly,
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>but
>>>
>>>
>>> =20
>>>
>>>>>>if the QUERIES are slow too, then you may have fragmentation,
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>colision
>>>
>>>
>>> =20
>>>
>>>>>>or any other kind of packet loss (that may be caused by hardware
>>>>>>configs).
>>>>>>
>>>>>>Anyway, give us more info...
>>>>>>
>>>>>>Best regards,
>>>>>>
>>>>>>On 6/3/05, James Frankman wrote:
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>>>>>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
>>>>>>>
>>>>>>>
>>>>>>> =20
>>>>>>>
>>>we use
>>>
>>>
>>> =20
>>>
>>>>>>>its ip address to connect it is extremely slow. Other network
>>>>>>>
>>>>>>>
>>>>>>> =20
>>>>>>>
>>>>connections
>>>>
>>>>
>>>> =20
>>>>
>>>>>>>to our MySQL server do not seem slow. Any help diagnosing this
>>>>>>>
>>>>>>>
>>>>>>> =20
>>>>>>>
>>>problem
>>>
>>>
>>> =20
>>>
>>>>>>>would be helpful.
>>>>>>>
>>>>>>>--
>>>>>>>MySQL Windows Mailing List
>>>>>>>For list archives: http://lists.mysql.com/win32
>>>>>>>To unsubscribe:
>>>>>>>http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gm ail.com
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> =20
>>>>>>>
>>>>>>--
>>>>>>Daniel da Veiga
>>>>>>Computer Operator - RS - Brazil
>>>>>>
>>>>>>--
>>>>>>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:
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>>http://lists.mysql.com/win32?unsub=3Dgreg@i-online.co.za
>>>>
>>>>
>>>> =20
>>>>
>>>>>--
>>>>>MySQL Windows Mailing List
>>>>>For list archives: http://lists.mysql.com/win32
>>>>>To unsubscribe:
>>>>>
>>>>>
>>>>> =20
>>>>>
>>>>http://lists.mysql.com/win32?unsub=3Dlsharpe@pacificwire less.com.au
>>>>
>>>>
>>>>--
>>>>MySQL Windows Mailing List
>>>>For list archives: http://lists.mysql.com/win32
>>>>To unsubscribe:
>>>>
>>>>
>>>> =20
>>>>
>>>http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail. com
>>>
>>>
>>> =20
>>>
>>>> =20
>>>>
>>>
>>>
>>> =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=3Ddanieldaveiga@gmail.com
>>
>>
>> =20
>>
>
>
> =20
>

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


--
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