MySQL Forums
Forum List  »  MyISAM

load index into cache
Posted by: Mike Connell
Date: August 16, 2005 04:48PM


I've allocated a 2Gig cache for a set of tables that are incrementally loaded at night.
This was done so that these tables don't disturb the regular cache for my most
frequent activities.

What happens if I do a load index into cache and the index file is bigger than the cache?
Does it just keep loading the index once the max cache size is reached and booting out
records it loaded at the first?

It would be really, really, really great to be able to specify the exact index to get
cached rather than all the indexes associated with the table. I have some really big
tables and it would be really, really, really great to say exactly which index gets cached
out of all the indexes on a table. One way this could be done would be to have a mark
flag on an index so that when the load index into cache command is given, only the marked
indexes are loaded.


Options: ReplyQuote

Written By
load index into cache
August 16, 2005 04:48PM
August 17, 2005 04:08AM
August 17, 2005 10:08PM

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.