MySQL Forums
Forum List  »  Performance

Re: Queries very slow until key cache fills up. Is there a way around this?
Posted by: rbnetus
Date: December 03, 2004 03:40PM

Thanks Harrison,
I tried the warming up the cache, but I think my query was not right. I tried to load the whole table in a background thread. That killed performance on first few runs because the disk activity was so high. I'll try loading just the Ids or doing something like sum on it and see if it helps.
Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Queries very slow until key cache fills up. Is there a way around this?
2044
December 03, 2004 03:40PM


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.