Re: Partitioning in MySQL: Range Partitioning
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
Subject
Views
Written By
Posted
10201
May 13, 2005 05:03PM
2974
May 23, 2005 03:29PM
4412
May 24, 2005 01:52AM
3262
May 25, 2005 02:17AM
3211
May 26, 2005 01:45AM
3268
May 25, 2005 04:09PM
3262
May 26, 2005 02:02AM
Re: Partitioning in MySQL: Range Partitioning
3375
July 01, 2005 03:11AM
3603
July 01, 2005 03:24PM
3449
July 01, 2005 06:24PM
3016
September 20, 2005 09:13AM
3420
September 20, 2005 02:26PM
2912
September 20, 2005 04:35PM
3249
October 07, 2005 06:27PM
3248
October 09, 2005 04:11AM
3132
October 10, 2005 05:08AM
3536
July 06, 2005 08:25AM
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.