Slow Connecting to MySql Server

[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