Choice of Partition on a BIG INT
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?
Subject
Views
Written By
Posted
Choice of Partition on a BIG INT
4129
October 15, 2008 02:26AM
2711
October 15, 2008 10:36AM
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.