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
> 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

Written By
Re: Convert non-partitioned -> partitioned
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.