MySQL Forums
Forum List  »  Partitioning

Move from unpartitioned database to partitioned database
Posted by: Piyush Maheshwari
Date: March 19, 2012 07:43AM

Hi

I have a un-partitioned database with around 35 tables.
Some of the tables are around 30Gb. I want to set-up partitioning on these tables in an efficient manner.
I have some questions-
1) Can I alter my table structure to add partioning?
2) If no , then is what is the procedure for adding partitioning?
3) Do I have to periodically add new partitions?
4) Do I have to re-build my indexes after a partition is dropped?

I am looking for ways to achieve this with least manual labour( due to 35 tables).
Any help would be appreciated.

Thanks,
Piyush

Options: ReplyQuote


Subject
Views
Written By
Posted
Move from unpartitioned database to partitioned database
2844
March 19, 2012 07:43AM


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.