MySQL Forums :: Partitioning :: Partitioning by hour

Rick James Wrote:
-------------------------------------------------------
> Correction: HOUR() is available as of 5.1.12:
> http://dev.mysql.com/doc/refman/5.1/en/partitionin
> g-limitations-functions.html

Thanks! Yes, HOUR() allows me to split the table in partitions by hour (the benefit of this is that I have daily tables with about 50 gigs of data, everyday, and it would help me with partition pruning).

However, although the table is in fact created with hourly partitions, I get no benefit out of pruning.

http://dev.mysql.com/doc/refman/5.1/en/partitioning-pruning.html says Pruning can also be applied for tables partitioned on a DATE or DATETIME column when the partitioning expression uses the YEAR() or TO_DAYS() function.

So I was wondering if there was some kind of workaround, besides adding an hour INT column as you suggested.