MySQL Forums :: Partitioning :: MAX_ROWS on Partitions

Advanced Search

MAX_ROWS on Partitions
Posted by: Adam Berrada ()
Date: December 19, 2008 11:22PM

On a site I'm creating, there will be multiple Forums for different things (on an NDBCLUSTER).
I'm deciding whether to create a table for each Forum, or to create one big table (holding all Forums) and partition it horizontally(based on which forum a row belongs to). I know that the maximum MAX_ROWS on a table is around 4.3billion(4294967295), and that "one big table" may eventually exceed 4.3b rows. So, my question is:

is the 4.3billion-rows the total maximum for a table (partitioned or not), or can you set MAX_ROWS separately on each partition to MAX_ROWS=4294967295 (there by making the table go beyond 4.3b rows)?

Options: ReplyQuote

Subject Views Written By Posted
MAX_ROWS on Partitions 4750 Adam Berrada 12/19/2008 11:22PM
Re: MAX_ROWS on Partitions 2740 Rick James 02/26/2009 12:58AM
Re: MAX_ROWS on Partitions 3229 Adam Berrada 02/28/2009 06:29PM
Re: MAX_ROWS on Partitions 3018 Rick James 03/01/2009 01:05AM
Re: MAX_ROWS on Partitions 2759 Adam Berrada 03/01/2009 08:35AM

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.