MySQL Forums
Forum List  »  Partitioning

Re: Convert non-partitioned -> partitioned
Posted by: Luca Ghezzo
Date: August 21, 2006 07:41AM

Mikael Ronstrom Wrote:
> You simply write:
> ALTER TABLE table_name
> PARTITION BY ...
>
> followed by exactly the same partitioning syntax
> you would have used
> if you were to create the table.

So please tell me if I'm right: imagine a table ABC having lots of records and stored in file ABC.ibd. If I write something like that, using eight partitions and storing each partition in a different file ABC_n.ibd (in different places, too), what I'm going to see is:

- new files are created
- records are migrated in new partitions according to partitioning criteria
- in the end, old ABC.ibd file is deleted (I don't expect it to survive since it would be useless at this point)

Is it correct? This is a test I'm going to do by myself ASAP, anyway.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Convert non-partitioned -> partitioned
2155
August 21, 2006 07:41AM


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.