Slow connectivity from Mac laptop to MySQL database, only on local network (Navicat)
Posted on 2011-05-11
We have two MacBook Pro laptops running OS 10.6.7, with Navicat for connecting to our MySQL database running on Windows Server 2003. One of the laptops is running Navicat via Parallels and Windows 7, and the other is running it direct on the Mac OS.
When we are directly connected to the network with the database running locally, the connection to it is SO slow. It takes on average 8-12 seconds to open a table. If we're outside the network and connecting to the database with the external IP, the connection is super fast, taking less than 2 seconds to open a table.
I did a tracert to the server from the LAN, and there's just one hop, to 192.168.50.xx, our Windows server. It's not bouncing around.
We also have 3 Windows PC's, 2 desktops running XP and 1 laptop running Win7 that have Navicat installed. All of those machines run super fast regardless of LAN/WAN connectivity.
So, it appears that something on the Mac is slowing down the connectivity, but only when on the LAN. I had stumbled on an article a few months ago that touched on this issue and something with the Mac wanting to resolve hostnames on the server repeatedly, and they suggested changing a setting on the MySQL server. Unfortunately, I can't find that article now!