MySQL Forums :: Partitioning :: Move from unpartitioned database to partitioned database


Advanced Search

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 2787 Piyush Maheshwari 03/19/2012 07:43AM
Re: Move from unpartitioned database to partitioned database 1612 Mattias Jonsson 03/20/2012 01:21AM
Re: Move from unpartitioned database to partitioned database 1460 Piyush Maheshwari 03/20/2012 03:39AM
Re: Move from unpartitioned database to partitioned database 1321 Mattias Jonsson 03/20/2012 03:56AM
Re: Move from unpartitioned database to partitioned database 2095 Rick James 03/22/2012 07:48PM


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.