MySQL Forums
Forum List  »  Partitioning

Re: Partitioning problem
Posted by: Robert Freeland
Date: September 04, 2008 12:19PM

I think that the partitioning formula must resolve to DAYS, rather than individual hours.

We also discovered something odd that's apparently related. We have a table partitioned by month, but if you do an EXPLAIN PARTITIONS on this statement...

SELECT COUNT(*) FROM foo WHERE CreateDT BETWEEN '2008-08-01' AND '2008-08-31 23:59:59';

... you'll find that it accesses BOTH the 200808 partition AND the 200809 partition. As near as I can tell, this is because the second limit rounds to '2008-09-01', which falls in the later partition. Nevertheless, this is certainly not the expected or desired outcome.

Options: ReplyQuote

Written By
August 31, 2008 03:49AM
Re: Partitioning problem
September 04, 2008 12:19PM
September 06, 2008 01:17PM
October 08, 2008 08:00AM
October 08, 2008 10:56PM

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.