Slow Connecting to MySql Server

[vpalhories]

Hello,

We currently have production databases running on a Microsoft Server 2003 Standard Edition Box with all of the latest service packs. The version of MySql database that is running is 4.1.10a. I have an exact mirrored copy on a Linux Server running the same version of the DB.

Opening the database thru SQLyog from my Laptop on the Windows Server takes roughly 4 seconds. Opening the same database on the Linux server takes less than 1 second. I tried various other tools (MySql Adminstrator,etc) and get similar results. I'm using the IP Address and not the server name, so there should be no DNS lookups. The same problem occurs when I try to open a database running on a remote Windows XP SP2 box. Running it locally on the same box opens the database in less than a second.

I tried the same thing from a Windows XP Pro PC with no service packs and opening the database remotely or locally takes the same time. So … problem seems to be related somehow to Service Pack 2.

Am I going crazy??? Any thoughts on the matter? Anyone experiencing similar problems?

Thanks

— Val

[peterlaursen]

This probably is not the reply that answers your question.

But I run MySQL on my local machine with WinXP SP2. And MySQL connections opens in less than ½ second no matter if I connect directly or if I “backloop” the connection forth and back to my ISP. And that is even with a dyndns lookup!

I think it might be a problem with the TCP-implementation with some of your network gear (router/switch) and WinXP/2003 SP2. Firmware update available? Chance to try another unit ?

[vpalhories]

peterlaursen wrote on Jul 19 2005, 02:05 AM:

This probably is not the reply that answers your question.

But I run MySQL on my local machine with WinXP SP2. And MySQL connections opens in less than ½ second no matter if I connect directly or if I “backloop” the connection forth and back to my ISP. And that is even with a dyndns lookup!

I think it might be a problem with the TCP-implementation with some of your network gear (router/switch) and WinXP/2003 SP2. Firmware update available? Chance to try another unit ?

Hi,

Thanks for the reply. Running MySql on my local machine with WinXP SP2 and opening the connection from my local machine also opens the DB in 1/2 a second. If however another user tries to open the MySql Connection running on my machine from their PC then it takes it 4-5 seconds. Doing the same thing with MySql running on a WinXP SP1a box takes 1/2 second from the other computer, so no problem.

— Val

[peterlaursen]

I understand this – and always did!

But when I'm “backlooping” the connection from my local to my ISP and back to local (with SP2) I think this situation equals some other users connecting.

If you want to test I can create an account for you here. I'll PM you connections details then.

[peterlaursen]

So I think the most likely the “negotiation” of network protocol with some network gear of yours is slow with machines running recent Windows updates.

[vpalhories]

peterlaursen wrote on Jul 19 2005, 06:20 PM:

So I think the most likely the “negotiation” of network protocol with some network gear of yours is slow with machines running recent Windows updates.

Hi,

I finally was able to resolve the problem by adding –skip-name-resolve to my MySQL config file and restarting MySQL. I now get sub-second response when opening the connection. Note that this is only useful if you do not use hostnames in your permissions, just IP numbers which is the case for me.

Thanks for taking the time to help me resolve the issue.

Have a great night.

— Val

[Author]

Posts