MySQL Forums
Forum List  »  Performance

Re: No caching - or brutal performance - for repeat queries 4.1.8nt
Posted by: James Day
Date: December 23, 2004 02:50PM

Obvious question first, just in case. The server is set to use port 3306. Is that the port the external users are using and is the firewall set to let it through (must be, it seems...:)).

Next I wonder about thread_cache and how many connections you're getting. Might try a higher value for it. But I have a hard time seeing this explaining seconds worth of delay.

How fast is select version() from inside and outside? If it's slow that would point away from your query or the cache as the issue.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
1956
December 23, 2004 02:50PM


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.