MySQL Forums
Forum List  »  Partitioning

create partition with index and unique key
Posted by: deva clementraj
Date: April 28, 2011 04:01AM

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.
why?
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


Subject
Views
Written By
Posted
create partition with index and unique key
3059
April 28, 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.