MySQL Forums
Forum List  »  Partitioning

Re: PARTITION BY RANGE ,problem for NULL values
Posted by: soumen chowdhury
Date: January 21, 2011 12:54AM

Mattias Jonsson Wrote:
> When I tried to create the table including the
> partitioning clause, I got the following
> warnings:
> Warning 1292 Incorrect datetime value:
> '0000-00-00'
> Warning 1292 Incorrect datetime value:
> '2010-11-31'
> Warning 1292 Incorrect datetime value:
> '2011-11-31'
> After correcting the non existent dates (x-11-31
> -> x-11-30) it will not break on that error.
> Since it is LESS THAN I suggest to use the first
> in every month instead, currently you have ranges
> that start with the last in every month and end
> with the second last day in every month.
> And also TO_DAYS(TIMESTAMP_column) is not allowed
> as partitioning function, I suggest using
> UNIX_TIMESTAMP(open_date) instead or change the
> column type to DATETIME.
> Read more in the manual, start with:
> g-limitations-functions.html

MR. Jonsson;
Many a thanks for the suggestion,i have started the partitioning with UNIX_TIMESTAMP and first in every month.

It's still going on,table has 14 million records,working on 4 cpu,15 GB memory.

I shall further ask for ur assistance,if it fails.

Soumen Chowdhury.

Edited 1 time(s). Last edit at 01/21/2011 12:56AM by soumen chowdhury.

Options: ReplyQuote

Written By
Re: PARTITION BY RANGE ,problem for NULL values
January 21, 2011 12:54AM

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.