MySQL Forums
Forum List  »  Partitioning

MySql composite partitioning
Posted by: Btissam Ghazi
Date: March 08, 2016 05:10PM

I need to create a composite partitionning in Mariadb range/list, in Oracle the command is:

CREATE TABLE t1
( id NUMBER(*,0),
pdateid date
)
TABLESPACE tbs_t1
PARTITION BY RANGE (pdateid)
SUBPARTITION BY LIST (id)
SUBPARTITION TEMPLATE
(SUBPARTITION SP1 VALUES (1,2),
SUBPARTITION SPDEF VALUES (DEFAULT))
(PARTITION APR_2015 VALUES LESS THAN (3043) tablespace tbs_t1_APR,
PARTITION MAY_2015 VALUES LESS THAN (3074) tablespace tbs_t1_MAY) ;

1-what could be the syntax for the same command in MariaDb ,and how to specify the storage for the partitions (ex: tbs_t1_APR)?
2-which storage engine should be choosen in this case for best performance?
3-which command give the template of the partiton?


Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
MySql composite partitioning
1079
March 08, 2016 05:10PM
582
March 09, 2016 06:59PM


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.