MySQL Forums
Forum List  »  NDB clusters

Re: Mysql NDB Cluster error while restoration of data "ERROR 1114 (HY000) at line 25: The table 'table1' is full"
Posted by: Mauritz Sundell
Date: May 02, 2023 07:48AM

Hi Purval

Ndb is by default an in-memory database, only writing to disk to have a disk durable state.

If your sql files is 2.2GB most likely you will need that or even a bit more as DataMemory. Please increase DataMemory.

To increase the capacity of a Ndb cluster further one can either add more nodegroups or make part of data stored on disk.

Currently you have one nodegroup with two data nodes, both will store all your data to not loose any data if one node goes down.

Some information about nodegroups can be found in:
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node.html

For information about store some data on disk see:
https://dev.mysql.com/doc/mysql-cluster-excerpt/8.0/en/mysql-cluster-disk-data.html

Note that indexes are always in memory, and columns needed for index can not be stored on disk.

Regards,
Mauritz

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql NDB Cluster error while restoration of data "ERROR 1114 (HY000) at line 25: The table 'table1' is full"
90
May 02, 2023 07:48AM


Sorry, only registered users may post in this forum.

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.