MySQL Forums
Forum List  »  Performance

MySQL slow connection time
Posted by: Anker Berg-Sonne
Date: April 23, 2005 04:32PM

I know I shouldn't have done two things as once, but I upgraded to the GA 4.1 and set innodb_file_per_table to 1 and migrated my database to innodb. All this based on what I heard at the conference.

My problem is that establishing connections from ny node other than the local host is incredibly slow, like 5 seconds. If I run mysql like this

mysql -h MyHost -u root

it comes back lickety split if I do it on the server running MySQL, but its slow as molasses when connecting from any other system.

Any ideas?

TIA/Anker

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL slow connection time
21776
April 23, 2005 04:32PM
24506
April 23, 2005 06:35PM
12154
April 24, 2005 07:36AM
12358
April 24, 2005 08:31AM
9586
August 27, 2007 01:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.