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.delev...@gmail.com> > 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...? > > > >
