MySQL Forums
Forum List  »  Performance

Re: Queries slow down daily, optimizing helps -> why?
Posted by: Kaspar Con
Date: February 21, 2009 06:15AM

I tested it once again and I actually was wrong in my answer about the query speed when doing the same query several times.

It is not that simple.

If the server is slow the first query takes 6,6 s, the second (same) ALSO takes 6,6 s and the third one is fast with 31 ms. (Actually the time is the time to serve the page but there is not much more than the query in question).
Using another term starts the same procedure, slow, slow, fast.

But: It is not always like that. Sometimes queries are three times slow, some times only once and I could not find any similarities in the searchtearms between similar bahaviour.

I think this is kind of strange, if the reason should be that the table has to be loaded into the cache.

BTW: Rising the key_buffer to 3 GB did not have any positive effect.

Any more ideas?


Options: ReplyQuote

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

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.