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
10552
May 13, 2005 05:03PM
3116
May 23, 2005 03:29PM
4564
May 24, 2005 01:52AM
3380
May 25, 2005 02:17AM
3364
May 26, 2005 01:45AM
3400
May 25, 2005 04:09PM
3393
May 26, 2005 02:02AM
Re: Partitioning in MySQL: Range Partitioning
3516
July 01, 2005 03:11AM
3744
July 01, 2005 03:24PM
3600
July 01, 2005 06:24PM
3163
September 20, 2005 09:13AM
3599
September 20, 2005 02:26PM
3053
September 20, 2005 04:35PM
3367
October 07, 2005 06:27PM
3394
October 09, 2005 04:11AM
3275
October 10, 2005 05:08AM
3686
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.