MySQL Forums
Forum List  »  Partitioning

Re: partition based upon timestamp column per day
Posted by: Rick James
Date: March 02, 2011 09:13PM

DATE consumes 3 bytes
TIMESTAMP consumes 4 bytes
DATETIME consumes 8 bytes

You have not explained why you think PARTITION will help you at all.

Which Engine are you using?

How do you do the INSERTs? One row at a time (least efficient)? Batched INSERTs? LOAD DATA?

You are going to have 31 partitions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: partition based upon timestamp column per day
1671
March 02, 2011 09:13PM


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.