MySQL Forums
Forum List  »  Partitioning

partition and subpartitioning help
Posted by: deva clementraj
Date: May 11, 2011 04:01AM

i tried to create partition with year as main partition and month has subpartition
but the value are not going to the correct partitioned rows
so i created a other partition only with range (to_days(timestamp))
when i insert it the value goes to the correct partition .
but when use select statement like(select * from data where timestamp>='2009-09-01' and timesatmp<='2009-09-02') it gives the result
but when use this statement(select * from data where timestamp>='2009-09-01' and timesatmp<='2009-09-31') is show a error like Glib-Error **:gmem c:173:faildata allocate 8224000000 byte aborting
the create table id is like this
PARTITION p_2003_02 VALUES LESS THAN (to_days('2003-03-01')),
PARTITION p_2003_03 VALUES LESS THAN (to_days('2003-04-01')),
PARTITION p_2003_04 VALUES LESS THAN (to_days('2003-05-01')),
PARTITION p_2003_05 VALUES LESS THAN (to_days('2003-06-01')),
PARTITION p_2003_06 VALUES LESS THAN (to_days('2003-07-01')),
PARTITION p_2003_07 VALUES LESS THAN (to_days('2003-08-01')),
PARTITION p_2003_08 VALUES LESS THAN (to_days('2003-09-01')),
PARTITION p_2003_09 VALUES LESS THAN (to_days('2003-10-01')),
PARTITION p_2003_10 VALUES LESS THAN (to_days('2003-11-01')),
PARTITION p_2003_11 VALUES LESS THAN (to_days('2003-12-01')),
PARTITION p_2003_12 VALUES LESS THAN (to_days('2004-01-01')),

PARTITION p_2004_01 VALUES LESS THAN (to_days('2004-02-01')),
PARTITION p_2004_02 VALUES LESS THAN (to_days('2004-03-01')),
PARTITION p_2004_03 VALUES LESS THAN (to_days('2004-04-01')),
PARTITION p_2004_04 VALUES LESS THAN (to_days('2004-05-01')),
PARTITION p_2004_05 VALUES LESS THAN (to_days('2004-06-01')),
PARTITION p_2004_06 VALUES LESS THAN (to_days('2004-07-01')),
PARTITION p_2004_07 VALUES LESS THAN (to_days('2004-08-01')),
PARTITION p_2004_08 VALUES LESS THAN (to_days('2004-09-01')),
PARTITION p_2004_09 VALUES LESS THAN (to_days('2004-10-01')),
PARTITION p_2004_10 VALUES LESS THAN (to_days('2004-11-01')),
PARTITION p_2004_11 VALUES LESS THAN (to_days('2004-12-01')),
PARTITION p_2004_12 VALUES LESS THAN (to_days('2005-01-01')),


PARTITION p_2005_01 VALUES LESS THAN (to_days('2005-02-01')),
PARTITION p_2005_02 VALUES LESS THAN (to_days('2005-03-01')),
PARTITION p_2005_03 VALUES LESS THAN (to_days('2005-04-01')),
PARTITION p_2005_04 VALUES LESS THAN (to_days('2005-05-01')),
PARTITION p_2005_05 VALUES LESS THAN (to_days('2005-06-01')),
PARTITION p_2005_06 VALUES LESS THAN (to_days('2005-07-01')),
PARTITION p_2005_07 VALUES LESS THAN (to_days('2005-08-01')),
PARTITION p_2005_08 VALUES LESS THAN (to_days('2005-09-01')),
PARTITION p_2005_09 VALUES LESS THAN (to_days('2005-10-01')),
PARTITION p_2005_10 VALUES LESS THAN (to_days('2005-11-01')),
PARTITION p_2005_11 VALUES LESS THAN (to_days('2005-12-01')),
PARTITION p_2005_12 VALUES LESS THAN (to_days('2006-01-01')),
..
..
..
..
PARTITION p11 VALUES LESS THAN MAXVALUE);
what to do give me suggestion

soon

Options: ReplyQuote


Subject
Views
Written By
Posted
partition and subpartitioning help
3622
May 11, 2011 04:01AM


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.