MySQL Forums
Forum List  »  Partitioning

Re: Thoughts on partitioning by hour - and which partition type?
Posted by: Phil Hildebrand
Date: June 03, 2008 11:47AM

That seems like a fairly good way to approach it if you want to minimize maint tasks on your partitions...

You might consider not having the UNIQUE KEY id (hour_part,id), since your primary key essentially does the same think (guarantees uniqueness on hour_part,id).

You should probably consider innodb_file_per_table if you are not already using that as well (to give each partition it's own innodb file).

Options: ReplyQuote

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.