MySQL Forums
Forum List  »  Partitioning

Re: Partition by Date Column
Posted by: Mikael Ronström
Date: October 26, 2006 11:24PM

Hi Robert,
As mentioned in previous posts to the forum YEARWEEK can work
but isn't activated yet. So easiest way to activate is if you
file a bug report and I'll fix it :), it's a 1-liner.


Robert Pelletier Wrote:
-------------------------------------------------------
> I changed my partitionning scheme for database
> pruning, but it still doesn't like I'd like it
> to.
>
> I switched to using "partition by range
> (yearweek(date))".
>
> Selecting one day works with pruning. Selecting a
> range makes all the partitions to be scanned.
>
> I also have "corruption" when using "explain
> partitions select blablabla" that looks like this
> :
> r?s\?p200627,p200628,p200629
>

Not sure about this, file a bug about I presume.

Rgrds Mikael
> Any idea why? What did I do wrong?

Options: ReplyQuote


Subject
Views
Written By
Posted
17468
July 05, 2006 10:23AM
5785
July 24, 2006 09:01AM
5183
September 04, 2006 09:56PM
4527
September 05, 2006 05:07PM
6041
September 06, 2006 01:34AM
4086
October 03, 2006 12:06PM
5110
October 03, 2006 09:04PM
3971
October 25, 2006 08:45AM
Re: Partition by Date Column
3885
October 26, 2006 11:24PM
3762
January 28, 2009 02:08AM
3789
March 19, 2009 01:35AM
3575
April 06, 2009 08:15AM


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.