MySQL Forums
Forum List  »  Performance

Re: Queries slow down daily, optimizing helps -> why?
Posted by: Kaspar Con
Date: February 19, 2009 03:32AM

This is a very possible explanation! You are right about your assuption that the second query is fast. First one is really slow, next ones fast. But if I change the queryterm it is slow again. Next query with the second term is fast again.

So it looks like a caching problem? Or is it a I/O problem?

Is there anything I could do to avoid it?

'schul' is no whole word, it could be part of a name e.g. Schulz. This is why I could not use FULLTEXT. The query is used to find users whith a username that contains the querystring.

Options: ReplyQuote

Written By
Re: Queries slow down daily, optimizing helps -> why?
February 19, 2009 03:32AM
March 18, 2009 03:58AM

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.