How to insert large data when there is limitation on RAM

[sandhya rani]

Hi all,

Is there any alternative method for data storage in memory other than disk storage.

Suppose there is a limitation on the RAM used in the data nodes then, how to insert large data in memory?

We know that, all indexed columns and first 256 bytes of Blob/Text data is stored in memory (data and index memory). If there is no more space available in memory then, we get table full error, even when data and index memory are set to maximum value in config.ini based on available RAM.

So, even though we are employing disk data storage using cluster 6.3.20, we get table full error due to limitation on RAM. How to overcome this memory issue other than upgrading to higher RAM?

Looking forward for any suggestion in this regard.