Re: Partitioning tables

[Mattias Jonsson]

You can partition by RANGE (TO_DAYS(datetime_col)) for one datetime field in 5.1.
And in 5.5 you can also partition by several columns like:
RANGE COLUMNS (datetime_col1, datetime_col2...)
(PARTITION `p2010-01_2010-01...` VALUES LESS THAN ('2010-01-01', '2010-01-01'...)
PARTITION `p2010-01_2010-02...` VALUES LESS THAN ('2010-01-01', '2010-02-01'...)
...
PARTITION `p2010-02_2010-01...` VALUES LESS THAN ('2010-02-01', '2010-01-01'...)
PARTITION `p2010-02_2010-02...` VALUES LESS THAN ('2010-02-01', '2010-02-01'...)