MySQL Forums
Forum List  »  Performance

Re: get connection very slowly
Posted by: Peter Zaitsev
Date: December 15, 2004 01:31PM

The first is to check what is taking so long. Ie you can take a look at network
traffic going on between client and server or at least take a look at server
processlist during these 15 seconds.

Can you connect from the same (server) host fine ?

Typical issue is DNS problems. MySQL resolves host name of the client which is connecting. Check how quick is "nslookup <clientip>" on server.

MySQL caches resolved ips which would explain why previous server version was running fine.

I was also could suggest to downgrade back to 4.0 and see if problem goes away to ensure it is server version problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
3902
December 13, 2004 08:34PM
2099
December 14, 2004 12:24AM
Re: get connection very slowly
2349
December 15, 2004 01:31PM
2095
December 16, 2004 05:37AM
1965
December 16, 2004 05:57AM


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.