MySQL Forums
Forum List  »  Performance

Re: mysql connection speed.
Posted by: Harrison Fisk
Date: May 03, 2005 09:08AM

Hi,

Slow connections like that are normally tied to DNS issues. Make sure that your server can resolve the remote hostname properly (and quickly). Also if you are using windows, it can be very slow to try to resolve the name over the windows networking setup.

Try to add the computers to your /etc/hosts file (or if you are on windows, into the hosts file there), which should speed that up. Also you could run mysqld with the --skip-name-resolve option.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2581
April 30, 2005 03:00AM
Re: mysql connection speed.
1714
May 03, 2005 09:08AM
1797
May 03, 2005 09:38AM


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.