MySQL Forums :: Partitioning :: MySql composite partitioning


Advanced Search

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 908 Btissam Ghazi 03/08/2016 05:10PM
Re: MySql composite partitioning 497 Rick James 03/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.