49 messages in com.mysql.lists.win32RE: Connections from localhost fast. ...
FromSent OnAttachments
James Frankman03 Jun 2005 13:17 
SGr...@unimin.com03 Jun 2005 13:20 
Daniel da Veiga03 Jun 2005 13:32 
James Frankman03 Jun 2005 13:52 
Greg Quinn03 Jun 2005 14:25 
Daniel da Veiga03 Jun 2005 14:27 
James Frankman03 Jun 2005 15:17 
James Frankman03 Jun 2005 15:23 
warren03 Jun 2005 15:29 
cor...@bbqguys.com03 Jun 2005 18:58 
Wade Smart03 Jun 2005 19:07 
Ryan Paulson04 Jun 2005 06:18 
Greg Quinn04 Jun 2005 06:52 
Ryan Paulson04 Jun 2005 07:01 
Daniel da Veiga04 Jun 2005 13:42 
Leigh Sharpe05 Jun 2005 16:51 
James Frankman06 Jun 2005 08:31 
Daniel da Veiga06 Jun 2005 09:18 
James Frankman06 Jun 2005 09:35 
Ryan Paulson06 Jun 2005 09:46 
SGr...@unimin.com06 Jun 2005 09:52 
Brandon Schenz06 Jun 2005 09:56 
Daniel da Veiga06 Jun 2005 09:56 
James Frankman06 Jun 2005 09:59 
James Frankman06 Jun 2005 10:05 
Brandon Schenz06 Jun 2005 10:08 
Daniel da Veiga06 Jun 2005 10:08 
James Frankman06 Jun 2005 10:11 
Brandon Schenz06 Jun 2005 10:34 
Ryan Paulson06 Jun 2005 11:46 
James Frankman06 Jun 2005 12:00 
Ryan Paulson06 Jun 2005 12:03 
Brandon Schenz06 Jun 2005 12:08 
Daniel da Veiga06 Jun 2005 12:08 
James Frankman06 Jun 2005 12:13 
James Frankman06 Jun 2005 12:14 
Daniel da Veiga06 Jun 2005 12:20 
James Frankman06 Jun 2005 12:25 
Ryan Paulson06 Jun 2005 12:36 
James Frankman06 Jun 2005 13:26 
Leigh Sharpe06 Jun 2005 17:59 
Erich Dollansky06 Jun 2005 18:25 
Armando06 Jun 2005 22:33 
James Frankman07 Jun 2005 07:18 
Leigh Sharpe07 Jun 2005 16:55 
James Frankman08 Jun 2005 07:02 
Ryan Paulson08 Jun 2005 07:07 
Leigh Sharpe08 Jun 2005 16:47 
Nabble-Member119 Dec 2007 11:52 
Subject:RE: Connections from localhost fast. Connections anywhere else slow.
From:James Frankman (jfra@idfbins.com)
Date:06/06/2005 10:05:19 AM
List:com.mysql.lists.win32

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: SGr@unimin.com [mailto:SGr@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" <rpau@netshops.com> 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:dani@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 <jfra@idfbins.com> 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:lsha@pacificwireless.com.au] Sent: Sunday, June 05, 2005 5:52 PM To: James Frankman Cc: win@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" <jfra@idfbins.com> To: "Greg Quinn" <gr@officium.co.za> Cc: <win@lists.mysql.com> 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:gr@officium.co.za] Sent: Friday, June 03, 2005 3:26 PM To: James Frankman Cc: win@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" <jfra@idfbins.com> To: "Daniel da Veiga" <dani@gmail.com>; <win@lists.mysql.com> 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:dani@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 <jfra@idfbins.com> 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