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