Slow connectivity from Mac laptop to MySQL database, only on local network (Navicat)

Posted on 2011-05-11
Last Modified: 2012-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!

Any suggestions?
Question by:petersonent

    Accepted Solution

    I figured it out using this thread...

    Our Windows 2003 Server wasn't able to resolve the hostnames of our Mac laptops.  The article suggests using skip-name-resolve in the MySQL my.ini file, then using the IP to connect to the database.  Unfortunately, we can't use the skip-name-resolve, because we need to be able to access our MySQL connection on the LAN or WAN using a hostname.  So, I took the other route..

    I added an entry for the hostname of the laptop and it's currently assigned IP, and the connection is super fast now.  We're setting up the router to issue reserved IPs to these two machines via their MAC addresses, so they always get the same IP, and the host files entries will always work.  

    Author Closing Comment

    This configuration has resolved the slowness issue.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now