MySQL Forums
Forum List  »  General

Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
Posted by: tom worster
Date: December 29, 2010 10:42AM

Hi Rick,

There's an auto_increment for the dict ids that I omitted for no reason that I can remember.

All those 4 keys you described sure would be nice. I think what you explain is what EXPLAIN means when it says "Using index" in the Extra column.

The dictionary is read frequently in the id-to-name direction so the (id, name) key would speed it up for sure. It is written to once a day by an overnight batch process. So I'm guessing MyISAM is a reasonable choice.

If I quit trying to preload keys then I think the only downside to what you proposed is speed of the overnight update. That's the trade-off: read speed (important to the app) vs. speed of the overnight batch (less so).

Options: ReplyQuote


Subject
Written By
Posted
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
December 29, 2010 10:42AM


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.