|List:||MySQL on Win32||« Previous MessageNext Message »|
|From:||Nabble-Member1||Date:||December 19 2007 7:52pm|
|Subject:||RE: Connections from localhost fast. Connections anywhere else|
|View as plain text|
Yes. Adding these 2 entries under server section in my.ini fixed my system performance too. What happened in my network is that web server and DB server are in 2 different subnets. TCP messages are routed via a firewall device. Thanh jfrankman wrote: > > 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@stripped] > Sent: Friday, June 03, 2005 3:26 PM > To: James Frankman > Cc: win32@stripped > 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" <jfrankman@stripped> > To: "Daniel da Veiga" <danieldaveiga@stripped>; <win32@stripped> > 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@stripped] >> 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 <jfrankman@stripped> 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=1 >>> >>> >> >> >> -- >> 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=1 >> >> >> -- >> MySQL Windows Mailing List >> For list archives: http://lists.mysql.com/win32 >> To unsubscribe: http://lists.mysql.com/win32?unsub=1 >> > > > > -- > MySQL Windows Mailing List > For list archives: http://lists.mysql.com/win32 > To unsubscribe: http://lists.mysql.com/win32?unsub=1 > > > -- View this message in context: http://www.nabble.com/Connections-from-localhost-fast.-Connections-anywhere-else-slow.-tp129994p14423833.html Sent from the MySQL - Win32 mailing list archive at Nabble.com.