MySQL Forums
Forum List  »  Partitioning

Choosing a partition type
Posted by: Kamal Joshi
Date: March 22, 2007 10:48AM

I have a table of 100 millions of records. The table detail is as follows

CREATE TABLE `X` (
`memberid` int(10) unsigned NOT NULL,
`exerciseid` int(10) unsigned NOT NULL,
`score` int(10) unsigned NOT NULL,
`attempted_time` datetime NOT NULL,
KEY `member_id` (`member_id`),
KEY `exercise_id` (`exercise_id`),
KEY `attempted_time_id` (`attempted_time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

The table does not have any UNIQUE or PRIMARY KEY and I want to partition this table from the available partition types.
What could be best way for this type of table? Please help!

Options: ReplyQuote


Subject
Views
Written By
Posted
Choosing a partition type
3106
March 22, 2007 10:48AM
2176
March 22, 2007 08:44PM


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.