MySQL Performance: MySQL => Very slow connection time over network.

Members

Help

Home

Home » Performance » MySQL » Very slow connection time over network.

Show: Today's Messages :: Show Polls :: Message Navigator

Very slow connection time over network. [message #1190]

Thu, 03 May 2007 09:40

prsplayer82
Messages: 1
Registered: May 2007

Junior Member

My application is a Java Swing app that connects to a MySQL 5.0 database on a Mac Mini on the network. When the application is running on the same computer as the database (Mac Mini), it runs fine. However, when any other computer tries to acces it, it takes 1 to 2 mins to connect to the database. Any ideas on where to start? Thank you for your help!!

Report message to a moderator

Re: Very slow connection time over network. [message #1191 is a reply to message #1190 ]

Thu, 03 May 2007 12:11

linuxrunner
Messages: 15
Registered: February 2007
Location: NYC

Junior Member

1. Check your DNS servers are not taking forever to respond or use "skip-name-resolve" in your my.cnf and add your accounts with IP address.

2. Check your network duplex settings(they should be the same on both sides) on both the server and client machines, also any switches/routers/hubs.

Report message to a moderator