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
5070
May 29, 2011 10:13AM
2155
May 31, 2011 03:40PM
1921
May 31, 2011 07:58PM
2770
June 01, 2011 03:57AM
2483
June 01, 2011 07:34PM
2087
June 02, 2011 12:43AM
Re: Partitioning & Tablespace
1979
June 02, 2011 01:02PM
2252
June 02, 2011 07:19PM
1837
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.