Re: Partitioning & Tablespace
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?
Subject
Views
Written By
Posted
5178
May 29, 2011 10:13AM
2235
May 31, 2011 03:40PM
1987
May 31, 2011 07:58PM
2850
June 01, 2011 03:57AM
2578
June 01, 2011 07:34PM
2165
June 02, 2011 12:43AM
Re: Partitioning & Tablespace
2055
June 02, 2011 01:02PM
2329
June 02, 2011 07:19PM
1909
June 02, 2011 08:44PM
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.