MySQL Forums
Forum List  »  NDB clusters

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

Written By
How do I get rid of the MAX_ROWS limitation?
May 30, 2012 09:51AM

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.