MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
No caching - or brutal performance - for repeat queries 4.1.8nt
3431
Ed Tilley
December 20, 2004 12:14PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2159
James Day
December 20, 2004 04:25PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2114
Ed Tilley
December 23, 2004 12:19PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2098
James Day
December 23, 2004 02:50PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2115
Ed Tilley
December 28, 2004 01:58AM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2108
Andr Schršder
December 28, 2004 03:55PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2138
Peter Zaitsev
December 31, 2004 07:17PM


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.