Home » Performance » MySQL » Very slow connection time over network.
Very slow connection time over network. [message #1190] Thu, 03 May 2007 09:40 Go to next message
prsplayer82  is currently offline 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!!
Re: Very slow connection time over network. [message #1191 is a reply to message #1190 ] Thu, 03 May 2007 12:11 Go to previous messageGo to next message
linuxrunner  is currently offline 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.
Re: Very slow connection time over network. [message #1280 is a reply to message #1191 ] Mon, 21 May 2007 05:06 Go to previous message
Nekroido  is currently offline Nekroido
Messages: 1
Registered: May 2007
Junior Member

linuxrunner wrote on Thu, 03 May 2007 19:11

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.


Thank you!!! Smile
Previous Topic:Performance query count and subselect
Next Topic:Index Question
Goto Forum:
  



Current Time: Tue Jan 6 16:20:26 EST 2009

Total time taken to generate the page: 0.26322 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge