MySQL Forums
Forum List  »  Performance

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

Yes, kind of. The slow_log said 21k examined rows before and now 11k.

OK, i understand quite well that you can only explain one EXPLAIN after the other, but it just would've been quite sweet, if there would be such a rule of thumb. Thanks for clarifying!

The query is fast yet so it seems that you solved my problem! Thanks a lot for your patience!! I learned a lot.

Now I can try to prove my new knowledge to some more queries that get slow without optimizing. I hope this is also a problem of correct indexing. Perhaps I open a new similar thread if I fail there... :-)

BTW: I do not completely understand why the problem occoured at all because the system ran years without this index and without having that problem. But sometimes perhaps it is better not to dig too deep...

Options: ReplyQuote


Subject
Views
Written By
Posted
2087
March 18, 2009 03:58AM
Re: Queries slow down daily, optimizing helps -> why?
2111
February 28, 2009 06:20AM


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.