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