Re: Partitioning in MySQL: Range Partitioning

[Mohamed OUADOU]

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