MySQL Forums
Forum List  »  Performance

Re: can you use INDEX DIRECTORY= with ALTER TABLE/CREATE INDEX?
Posted by: Felix Geerinckx
Date: December 22, 2005 02:35AM

Mark Modrall wrote:
> I've tried
> CREATE INDEX itest on test (time) INDEX_DIRECTORY='/mnt/ramtmp'
> ALTER TABLE test ADD INDEX itest (time) INDEX_DIRECTORY='/mnt/ramtmp'
>
> and get parse errors on both.

There should be no underscore between INDEX and DIRECTORY.
But there are quite some limitations (according to the manual), e.g.:

1) It doesn't work with CREATE INDEX
2) It is ignored with ALTER TABLE

in other words, you can only use it in the CREATE TABLE statement, and it's not supported on all platforms and only for MyISAM.

Why don't you give the RAMdisk memory to the key buffer, and let take MySQL care of it?

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: can you use INDEX DIRECTORY= with ALTER TABLE/CREATE INDEX?
1285
December 22, 2005 02:35AM


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.