[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2011-05-11
2
Medium Priority
?
1,324 Views
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?
0
Comment
Question by:petersonent
  • 2
2 Comments
 

Accepted Solution

by:
petersonent earned 0 total points
ID: 35739899
I figured it out using this thread... http://ubuntuforums.org/showthread.php?t=1244034

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.  
0
 

Author Closing Comment

by:petersonent
ID: 35739907
This configuration has resolved the slowness issue.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

872 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