MySQL Forums
Forum List  »  Partitioning

Re: Partitioning in MySQL: Range Partitioning
Posted by: Mohamed OUADOU
Date: July 01, 2005 03:11AM

Hi,

As an idea for table partitionning, it will be very interessting when working with large table to allow both partitions and subpartitions .
For example, a table partitionned by year can have a year partition divided in 12 subpartitions for each month of the year.

Another idea is to allow for example round robin partitionning, in order to increase write performance! Read performance can also be increased since it can be done in parallel mode.

As drop partition, it will be very interesting to allow data partition moving to a table. In some applications monthly data archiving is needed, as an example after each month the partition aged more than 1 year will be moved to a table named ARCHIVE_T_(year-1)_month.

ALTER TABLE T move PARTITION P0 TO TABLE ARCHIVE_T_0_MONTH;


Rgrds
Mohamed OUADOU
Database Architect

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning in MySQL: Range Partitioning
3061
July 01, 2005 03:11AM


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.