MySQL Forums
Forum List  »  Partitioning

Reasonable number of partitions?
Posted by: Shlomi Noach
Date: March 08, 2007 10:09AM

Hello,

I'm trying to get a measurement for a reasonable number of partitions for a large table.
For example, I have a table with 100,000,000 rows. Is it reasonable to partition it by HASH with 100 partitions? 1000 partitions?
Also, is it reasonable to partition by HASH with 100 partitions, then sub partition by HASH with 100 sub partitions?

Last, is there a means to calculate an "optimal" number of partitions? What are the costs and penalties of using many partitions?

Thanks in advance,
Shlomi

Options: ReplyQuote


Subject
Views
Written By
Posted
Reasonable number of partitions?
6653
March 08, 2007 10:09AM
4951
March 14, 2007 12:34PM
3629
September 20, 2007 08:36PM
3418
September 12, 2007 11:26AM


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.