I have set my system to a partition length of “1” and a partition unit of “Month”.
As expected, I have one partition per month:
sqlt_data_1_2011_04, sqlt_data_1_2011_05, sqlt_data_1_2011_06 and so on.
However, partitions don’t seem to begin until 09:14 or 10:14 on the first of the month (I think the 09:14 vs 10:14 is to do with daylight savings), and don’t end until the same time on the first of the following month.
This means that some of April’s data is in the May partition, some of May’s data is in the June partition and so on.
Is there any way to ensure that there is only data for a particular month in the partition for that month?
What determines the cutover time between partitions?