Re: How do I get rid of the MAX_ROWS limitation?

[Mauritz Sundell]

Hi Benjamin,
sorry to say, but the 46 million row limit per partitions is not removed in 7.2.6.
And the easiest way to work around this is to increase the number of partitions.

Increasing the number of partition can be done by setting MAX_ROWS big enough.
ALTER TABLE ... MAX_ROWS = 700000000;

Another option is to increase the number of LDM blocks per node, that will increase the number of default partitions. This later may also increase performance if you got many cores per node.
See for example MaxNoOfExecutionThreads or ThreadConfig.