MySQL TCP/IP Connection

[jaime]

Senario 1

I have a Server running RedHat ES4 PSA 7.5(WebServer) and a Dedicate Database Server running Mysql4.1.x.Art. I didn't want to install PSA for my Database Server because I only wanted mysql running on it(Dedicate DB Server).

We have our Webserver(PSA7.5) and our Database Server on separate Networks and We're connecting through tcp/ip on port 3306 of mysql. But when I launched the application through the browser https://application_IP it took a long time to connect.

Senario 2

So I decide to test our application, but this time by using PSA7.5(Clean Installation) as our Database server and using the Web Server for our application. We place them on separate Networks again. When I launched the application through the browser the application connected very very fast.

Our Network Configuration is definitly not the problem as we tested this application thoroughly using PSA7.5.

I was using Atomic Rocket Turtle Compile MySQL Packages I though it was optimized already correct me if I'm wrong. Can anyone give me some ideas as to why my connection was slow or how I can fix this problem using the first Senario. I don't want to use PSA7.5 as my Database Server.

Thank You

 

[jaime]

I fixed the problem and here is the answer .

I include the "skip-name-resolve" in /etc/my.cnf file