Skip navigation links

MySQL Forums :: MyISAM :: load index into cache


Advanced Search

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

Hi,

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?

p.s.
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.

Thanks

Options: ReplyQuote


Subject Views Written By Posted
load index into cache 2098 Mike Connell 08/16/2005 04:48PM
Re: load index into cache 1518 08/17/2005 04:08AM
Re: load index into cache 1552 Mike Connell 08/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.