MySQL Forums
Forum List  »  Partitioning

make number of partitions variable
Posted by: Mat private
Date: May 30, 2008 09:37AM


I was wondering if it is possoble to make a table with a flexiblepartitions variable.

I have a database where I store tickdata for stocks and I would like to make partitions per day, so that every day really has it's own partiotion. Since the database is filled continuously, I cannot set op the number of partitions when making the table.

So is it possible to do something like:

create table hereAretheticks (id int(11) not null auto_increment,symbol varchar(8),price double(17,3),_dateTime as bigint) Partition by hash (day(_dateTime)) Partitions select count(distinct(left(_datetime,8))) from hereAretheticks + 1;

where _datetime has a format like 20080530173228


Options: ReplyQuote

Written By
make number of partitions variable
May 30, 2008 09:37AM

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.