Slot connection on a remote MySQL server - not name resolve problem!

--0015175cba340418e8047571dca1
Content-Type: text/plain; charset=ISO-8859-1

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

--0015175cba340418e8047571dca1--

Re: Slot connection on a remote MySQL server - not name resolve

--0015175cd87eefcb640475757649
Content-Type: text/plain; charset=ISO-8859-1

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

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

--0015175cd87eefcb640475757649--