MySQL Forums :: NDB clusters :: How do I get rid of the MAX_ROWS limitation?


Advanced Search

How do I get rid of the MAX_ROWS limitation?
Posted by: Benjamin J. ()
Date: May 30, 2012 09:51AM

I installed cluster version 7.2.6 because the documentation states:

"Previously, it was possible to store a maximum of 46137488 rows in a single MySQL Cluster partition. This limitation has now been removed."

I created a new table and inserted my data. At around 369 million rows I got a

ERROR 1114 (HY000): The table '' is full

269M / (#partitions) = 369M / (#datanodes*#replica) = 369M/(4*2) = 369M / 8 = 46M

So apparently the limitation is still there by default.

What's the fastest and safest way to completely get rid of this limitation?

Options: ReplyQuote


Subject Views Written By Posted
How do I get rid of the MAX_ROWS limitation? 2469 Benjamin J. 05/30/2012 09:51AM
Re: How do I get rid of the MAX_ROWS limitation? 862 Benjamin J. 05/30/2012 10:13AM
Re: How do I get rid of the MAX_ROWS limitation? 1013 Benjamin J. 05/31/2012 04:23AM
Re: How do I get rid of the MAX_ROWS limitation? 1361 Mauritz Sundell 06/01/2012 03:26AM
Re: How do I get rid of the MAX_ROWS limitation? 864 Benjamin J. 06/01/2012 04:03AM
Re: How do I get rid of the MAX_ROWS limitation? 851 Mat Keep 06/01/2012 06:47AM


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.