List:General Discussion« Previous MessageNext Message »
From:Kim Delevati Date:October 9 2009 12:14am
Subject:Re: Slot connection on a remote MySQL server - not name resolve
problem!
View as plain text  
Damn I just said I wrote slot instead of slow...

Well I solved the problem, we added the client ip on the etc/hosts file on
the server. Now its pretty fast.

2009/10/8 Kim Delevati <kim.delevati@stripped>

> Hi.
>
> I'm using MySQL on a Ubuntu Server 8.10, I was running as a MySQL server
> but switched my database to another machine, on a Windows Server 2008.
> Problem is, the connection to that other server (which is on the same
> network) is very slow, taking 4-6 seconds every time. That is impossible to
> use on our applications. The ping from my machine to the server is around
> 0.150ms. I'm using Mysql-client 5.0 and the server is running Mysql-server
> 5.1.35.
> It is slow using mysql directly from the terminal, or with php, with
> persistent or not connections, etc.
>
> Further info: on the other machines I've tested, a Ubuntu 8.04 and Windows
> Server 2003, the connection is very fast. Skip-name-resolve is set on the
> server's configuration, and that seems to be the general cause of problems
> like this.
>
> So, does anyone what might the problem? Something badly configurated, an
> error on my network, distro specific bug...?
>
>
>
>

Thread
Slot connection on a remote MySQL server - not name resolve problem!Kim Delevati8 Oct
  • Re: Slot connection on a remote MySQL server - not name resolve problem!Kim Delevati9 Oct