MySQL Forums
Forum List  »  General

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
June 04, 2009 09:56AM


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.