Re: Pruning by month

[Michael Taggart]

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.