MySQL Forums
Forum List  »  Partitioning

Choice of Partition on a BIG INT
Posted by: Richard Lees
Date: October 15, 2008 02:26AM

Hello

I know that partitioning will definitely enhance my database structure, however I have a problem as to which partition type to use and how to implement it.

CREATE TABLE IF NOT EXISTS `serp_results` (
`instanceid` bigint(20) unsigned NOT NULL,
`urlid` int(10) unsigned NOT NULL,
`rankid` smallint(5) unsigned NOT NULL,
KEY `instanceid` (`instanceid`,`urlid`)
) ENGINE=MyISAM ROW_FORMAT=FIXED;

"instanceid" is actually other values packed together into a BIG INT value, so bitwise operators can be used to search this table based on these values, rather than performing JOINs on other tables.

Ideally I'd just be able to create the partitions in ranges, as the last 15 bits of "instanceid" are actually a category. I'd create further partitions based on another couple of bits.

However it seems that MySQL does not allow bitwise operators when creating a partition (doesn't mention why they stopped allowing it either)

Is there any way around this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Choice of Partition on a BIG INT
4129
October 15, 2008 02:26AM
2694
October 22, 2008 10:46AM
2284
January 21, 2009 11:10AM


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.