MySQL Forums
Forum List  »  Partitioning

Re: Pruning by month
Posted by: Michael Taggart
Date: October 23, 2008 06:12PM

Totally thinking out loud here, but would this work?

CREATE TABLE `test3` (
`id` int(11) NOT NULL,
`dtime` datetime NOT NULL,
`value` bigint(20) NOT NULL,
KEY `test3_id_dtime_idx` (`id`,`dtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 DELAY_KEY_WRITE=1 /*!50100
PARTITION BY HASH(month(dtime))
PARTITIONS 12;

Run a test and let me know. I am curious about this myself as I have data that would work really well if I could partition by month.

Options: ReplyQuote


Subject
Views
Written By
Posted
10074
October 23, 2008 04:56AM
Re: Pruning by month
4338
October 23, 2008 06:12PM
4564
October 23, 2008 06:17PM
4276
October 23, 2008 06:46PM
4193
October 23, 2008 07:21PM
4005
October 25, 2008 06:42PM
3862
February 12, 2009 08:42AM


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.