MySQL Forums
Forum List  »  Partitioning

Re: Internals - what are the stages of partition creation?
Posted by: Shlomo Priymak
Date: December 03, 2007 07:22AM

Thanks Mikael,

This is just what I also thought was going on - and this is why I was surprised to find that "extra" stage.

1) Create the new table with a temporary name (actually
6 partitions are created forming one table)
--done as anticipated
2) Copy the data from the original table to the new table.
This will take some time for a large table...
--done as anticipated
3) Rename table from temporary name to original table name.
--done as anticipated
4) Drops the old table.
--done as anticipated
5) Fill 6 tables as temporary #sql-XXXXX#P#p[0-6].ibd files, again.

This 5th stage took a really long time, and I don't know why it's there and what did it do. There was no more the old t.ibd file, only new t#P#p0.ibd, t#P#p1.ibd (and so on) files, and the files mentioned in section 5 above.

What could it be? Am I missing something?

Options: ReplyQuote

Written By
Re: Internals - what are the stages of partition creation?
December 03, 2007 07:22AM

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.