MySQL Forums :: General :: Preloading Index - LOAD INDEX INTO CACHE problem


Advanced Search

Preloading Index - LOAD INDEX INTO CACHE problem
Posted by: Chris James ()
Date: June 04, 2009 09:56AM

Hi,

I'm trying to pre-load a particular index in my (innodb) database with the syntax:

load index into cache my_table;

However, I get the error:

The storage engine for the table doesn't support preload_keys


I looked this up and there are hints about preload_keys not working on partitioned tables. However, my table is not partitioned.

What other problems might there be? Why would I be getting this error?


Many thanks,
Chris.

Options: ReplyQuote


Subject Written By Posted
Preloading Index - LOAD INDEX INTO CACHE problem Chris James 06/04/2009 09:56AM
Re: Preloading Index - LOAD INDEX INTO CACHE problem Rick James 06/06/2009 05:55PM


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.