List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:January 27 2012 6:01am
Subject:This partition function is not allowed
View as plain text  
Dear all,

Today i am creating a partition table in my mysql server  
5.1.34-community-log .

create table sample( a integer, dt_stamp timestamp not null default 
current timestamp, content varchar)engine= innodb
 PARTITION BY RANGE ( UNIX_TIMESTAMP(dt_stamp) ) (
    ->     PARTITION p0 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-02-01 
00:00:00') ),
    ->     PARTITION p1 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-03-01 
00:00:00') ),
   ->     PARTITION p8 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-10-01 
00:00:00') ),
    ->     PARTITION p9 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-11-01 
00:00:00') ),
    ->     PARTITION p10 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-12-01 
00:00:00') ),
    ->     PARTITION p11 VALUES LESS THAN (MAXVALUE)
    -> );
ERROR 1564 (HY000): This partition function is not allowed

After some Rn D on the error I found my mysql version does not support 
partitioning on timestamp column.
So i need to upgrade mysql server.
But my my.cnf requirements are :-
innodb_data_file_path           | 
/hdd2-1/innodb_data1/ibdata1:250G;/hdd3-1/innodb_data2/ibdata2:250G;/hdd4-1/innodb_data3/ibdata3:1G:autoextend

It takes near about 5 -6 hours to create these files & start my server.
Is it possible I upgrade to higher version 5.5 with existing data dirs 
and existing innodb tables.
Is there any link that shows how to upgrade mysql in
[root@s6-mysd-1 ~]# cat /etc/issue
Caos NSA: Node - Server - Appliance (release 1.0/Cato) \

Thanks in advance.
Thread
This partition function is not allowedAdarsh Sharma27 Jan
  • Re: This partition function is not allowedJohan De Meersman27 Jan