MySQL Forums
Forum List  »  Partitioning

data not storing in the correct partition
Posted by: deva clementraj
Date: April 28, 2011 05:18AM

dear sir
i have crores of records in one table
it has id,time,values as it columns
based on the time i have to partitioned as years and subpatition the year has month. if i insert values to that table it not storing in the correct partitioned palce.
i'm using Innodb as storege engine.

and also i want to add index and unique key to that table,the index should stored in hard disk not in memeory and the partitioned value index should store in hard disk for fast execution.

pls help me soon.

Options: ReplyQuote

Written By
data not storing in the correct partition
April 28, 2011 05:18AM

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.