MySQL Forums
Forum List  »  Partitioning

Re: Convert non-partitioned -> partitioned
Posted by: Luca Ghezzo
Date: August 22, 2006 06:05AM

Jon Stephens Wrote:
> Basically that's correct. For MyISAM tables, the
> behaviour's exactly as you've described.
> NDB Cluster has automatic partitioning and InnoDB
> maintains its own tablespace, so partitioned
> tables created using those storage engines are
> structured somewhat differently on the filesystem
> level.

In our scenario, our due to be partitioned tables are already on single files since we set parameter innodb_file_per_table to ON. Shouldn't this involve them to be rebuilt as single files, too, when partitioned, and not stored into common InnoDB tablespace?

Options: ReplyQuote

Written By
Re: Convert non-partitioned -> partitioned
August 22, 2006 06:05AM

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.