Re: can you use INDEX DIRECTORY= with ALTER TABLE/CREATE INDEX?

[Felix Geerinckx]

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.