MySQL Forums
Forum List  »  Partitioning

Possible Partition ?
Posted by: Daniel tu
Date: November 20, 2008 03:45AM

Im trying to partition a table which store large amount data collected from machines. Also I dont want to keep add partition every week.
i dont think it is possible to partition a table more than 2 layer.
Is there any other way to achieve the goal.

-Year
------ Month
-------------EQID
---------------eqdata
---------------eqdata
such as

PARTITION BY RANGE(YEAR(UpdateTime))(
PARTITION P1 VALUES LESS THAN (2007)(
PARTITION BY RANGE( Month(UpdateTime) )(
SUBPARTITION BY Key( EQID) (
),
),
),
.
.
PARTITION S1 VALUES LESS THABN MAXVALUE
)



Edited 1 time(s). Last edit at 11/20/2008 03:46AM by Daniel tu.

Options: ReplyQuote


Subject
Views
Written By
Posted
Possible Partition ?
3630
November 20, 2008 03:45AM


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.