MySQL Forums
Forum List  »  Partitioning

Re: Partitioning & Tablespace
Posted by: Mattias Jonsson
Date: June 02, 2011 01:02PM

Hi Lazuardi,

DATA DICTIONARY is a MyISAM feature implemented by symbolic links, which did not work on windows (support for it in NTFS came in Vista, but it is rarely used and is still not supported by MySQL/MyISAM).

So it is not supported by InnoDB. :(
If you do something NOT supported, like moving the .ibd files and symlinking to them, remember that it may fail when doing ALTER commands or OPTIMIZE TABLE.

To my knowledge there is currently no supported way to have InnoDB partitions on different spindles.

Are you only asking for knowledge or do you have a specific performance problem?

Options: ReplyQuote

Written By
May 29, 2011 10:13AM
June 01, 2011 03:57AM
June 01, 2011 07:34PM
Re: Partitioning & Tablespace
June 02, 2011 01:02PM
June 02, 2011 07:19PM

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.